unit
1 row where accessibility_shortcoming_count_visually_impaired = 8 and "created_time" is on date 2015-08-11
This data as json, CSV (advanced)
| id ▼ | connections | accessibility_properties | identifiers_0_namespace | identifiers_0_value | identifiers_1_namespace | identifiers_1_value | department | root_department | provider_type | organizer_type | contract_type_id | contract_type_description_fi | contract_type_description_sv | contract_type_description_en | is_active | deleted_at | organizer_name | organizer_business_id | picture_url | picture_entrance_url | streetview_entrance_url | description_fi | description_en | short_description | name_fi | name_en | street_address_fi | street_address_sv | street_address_en | www_fi | www_sv | www_en | address_postal_full | call_charge_info_fi | call_charge_info_sv | call_charge_info_en | picture_caption | phone | fax | accessibility_phone | accessibility_email | accessibility_www | created_time | address_zip | data_source | extensions_maintenance_group | extensions_maintenance_organization | last_modified_time | accessibility_viewpoints | root_service_nodes | municipality | service_nodes | services | keywords | location_type | location_coordinates_0 | location_coordinates_1 | address_postal_full_fi | identifiers_2_value | picture_caption_fi | call_charge_info | www | name_sv | short_description_fi | accessibility_shortcoming_count_reduced_mobility | accessibility_shortcoming_count_wheelchair | location | picture_caption_sv | accessibility_shortcoming_count_stroller | address_postal_full_en | accessibility_shortcoming_count_hearing_aid | street_address | contract_type | accessibility_shortcoming_count_rollator | identifiers_2_namespace | address_postal_full_sv | short_description_sv | description_sv | accessibility_shortcoming_count_visually_impaired | short_description_en | description | picture_caption_en | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45900 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Poikkeusaukioloajat: Uimahalli ja kuntosali ovat suljettuna 30.11. - 10.1.2021.\n\nKahvila palvelee poikkeusaukioloajoin\nkts. janinsportcafe.fi\n\nHarjoitteluajat 31.8. - 31.12.2020\nma klo.7.00 - 9.00 ja 13.00 - 20.30\nti klo.7.00 -18.00\nke klo.7.00 - 9.00 ja 13.00 - 20.30\nto klo.7.00 - 9.00 ja 13.00 - 20.30\npe klo.7.00 -20.30\nla klo.9.00 - 17.00\nsu klo.9.00 - 17.00", "sv": "Avvikande \u00f6ppettider: Simhallen och gym \u00e4r st\u00e4ngd 30.11. - 10.1.2021.\n\nPerioden 31.8. - 31.12.2020\nm\u00e5 kl.7.00 - 9.00 och 13.00 - 20.30\nti kl.7.00 -18.00\non kl.7.00 - 9.00 och 13.00 - 20.30\nto kl.7.00 - 9.00 och 13.00 - 20.30\nfr kl.7.00 -20.30\nl\u00f6 kl.9.00 - 17.00\ns\u00f6 kl.9.00 - 17.00", "en": "Exceptional opening hours: Swimming hall and gym are closed 30.11. - 10.1.2021.\n\nPeriod 31.8. - 31.12.2020\nMon 7.00 - 9.00 and 13.00 - 20.30\nTue 7.00 -18.00\nWed 7.00 - 9.00 and 13.00 - 20.30\nThu 7.00 - 9.00 and 13.00 - 20.30\nFri 7.00 -20.30\nSat 9.00 - 17.00\nSun 9.00 - 17.00"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Sis\u00e4\u00e4np\u00e4\u00e4sy loppuu ja kassa sulkeutuu 30 min ennen harjoitteluajan p\u00e4\u00e4ttymist\u00e4. \nUinti-, ja harjoitteluajan p\u00e4\u00e4tytty\u00e4 on 15 minuuttia peseytymisaikaa ja 15 minuuttia pukeutumisaikaa.\n\nHuom! Tiistaisin mahdollista ladata kortteja kassalla klo.19.30 asti.\nMyymme sarjakorteista vain 10x-kortteja, kuukausi-, ja kausikortteja ei myyd\u00e4 toistaiseksi.", "sv": "D\u00f6rrarna och kassan st\u00e4ngs 30 minuter innan tr\u00e4ningstiden tar slut. Efter att bad- och tr\u00e4ningstiden tagit slut har ni 15 minuter p\u00e5 er att duscha och 15 minuter att kl\u00e4 p\u00e5 er.\nObs! P\u00e5 tisdagar kan man undantagsvis ladda kort vid kassan fram till kl. 19.30.", "en": "The entrance and cash desk close 30 minutes before the training time ends. You will have 15 minutes to wash and 15 minutes to get dressed after the swimming… | [{"value": "false", "variable": 84}, {"value": "true", "variable": 37}, {"value": "false", "variable": 106}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 53}, {"value": "false", "variable": 112}, {"value": "true", "variable": 57}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 111}, {"value": "at_least_3600mm", "variable": 3}, {"value": "false", "variable": 34}, {"value": "true", "variable": 62}, {"value": "false", "variable": 23}, {"value": "false", "variable": 49}, {"value": "false", "variable": 29}, {"value": "elsewhere", "variable": 110}, {"value": "false", "variable": 102}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "true", "variable": 59}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "4", "variable": 1}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 98}, {"value": "true", "variable": 50}, {"value": "true", "variable": 115}, {"value": "true", "variable": 105}, {"value": "gym", "variable": 61}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 33}, {"value": "false", "variable": 103}, {"value": "sport_facility", "variable": 60}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 114}, {"value": "true", "variable": 104}, {"value": "false", "variable": 22}, {"value": "false", "variable": 92}, {"value": "true", "variable": 113}, {"value": "false", "variable": 83}, {"value": "false", "variable": 38}, {"value": "true", "variable": 80}, {"value": "false", "variable": 20}, {"value": "false", "variable": 21}, {"value": "over_20mm", "variable": 56}, {"value": "over_10m", "variable": 4}, {"value": "false", "variable": 5}, {"value": "false", "variable": 44}, {"value": "false", "variable": 51}, {"value": "false", "variable": 116}, {"value": "false", "variable": 117}, {"value": "false", "variable": 79}, {"value": "true", "variable": 107}, {"value": "rough", "variable": 17}, {"value": "true", "va… | internal | 17138 | lipas | 520267 | 23816b7c-fe04-4d14-a5a0-b5f0130d6a23 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hinnat (sisältää uinnin)Aikuiset - kertamaksu 5,50 e - 10 kerran sarjakortti tai kk-kortti 44 e - kausikortti 132 eMuut - kertamaksu 3 e - 10 kerran sarjakortti tai kk-kortti 24 e - kausikortti 72 eLapset (15 - 17v.)- kertamaksu 2,50 e - 10 kerran sarjakortti tai kk-kortti 20 e - kausikortti 60 e - henkilökohtainen asiakaskortti (kausi-, kuukausi ja sarjaliput) 4 eUimahallin ja palloiluhallin aulassa kahvila: Janin Sport&Cafe Pirkkola puh. 040 015 0997.Muuta: Kuntosalin ikäraja on 15 vuotta, alle 15-vuotiaat eivät saa oleskella kuntosalilla heidän oman turvallisuutensa vuoksi. Salilla oltava sisäliikuntavaatteet ja -kengät. Pirkkolan liikuntapuistossa on kaksi eri pysäköintialuetta eri puolilla liikuntapuistoa. Niin sanottu jäähallin pysäköintialue sijaitsee Pirkkolantien varressa, tarkemmin osoitteessa Plotinrinne 1. Niin sanottu uimahallin pysäköintialue puolestaan sijaitsee osoitteessa Pirkkolan metsätie 6. Uimahallin pysäköintialueella on myös invapysäköintimahdollisuus. | Charges (includes swimming) Adults - one visit €5,50 - 10 visits or 1 month €44 - season card €132 Others - one visit €3 - 10 visits or 1 month €24 - season card €72Children (age 15 - 17)- one visit €2.50 - 10 visits or 1 month €20 - season card €60- personal customer card (10 visits, 1 month or season card) €4Other info: The age limit for the gym is 15 in order to ensure general safety, small children are not permitted in gyms for their own safety, indoor exercise clothes and shoes must be worn in the gym. Pirkkola Sports Park features two parking areas on different sides of the park. The so-called ice hall parking area is located along Pirkkolantie, at Plotinrinne 1, to be exact. The so-called swimming hall parking area is located at Pirkkolan metsätie 6. The swimming hall parking area also has disabled parking. | Pirkkolan liikuntapuisto / Uimahallin kuntosali | Pirkkola sports park swimming hall gym | Pirkkolan metsätie 6 | Britas skogsväg 6 | Pirkkolan metsätie 6 | 2015-08-11T03:40:40+03:00 | 00630 | www.hel.fi | kaikki | helsinki | 2020-12-17T09:31:47.636478+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [1403] | helsinki | [611] | [350] | {} | Point | 24.910772 | 60.232113 | Britas idrottspark / Gym vid simhallen | Kaupungilla on 12 kuntosalia ja viisi voimailusalia ympäri Helsinkiä. | 2 | 5 | 1 | 5 | Helsingfors stad har 12 motionssalar och fem styrketräningssalar på olika håll i Helsingfors. | Priser (inkluderar simning) Vuxna - engångsavgift 5,50 e - 10 gångers seriekort eller månadskort 44 e - säsongkort 4 mån. 132 e Andra - engångsavgift 3 e - 10 gångers seriekort eller månadskort 24 e - säsongkort 4 mån. 72 eBarn (15 - 17 år)- engångsavgift 2,50 e - 10 gångers seriekort eller månadskort 20 e - säsongkort 4 mån. 60 e- personell kundkortet (10 gångers seriekort, månadskort och säsongkort) 4 eÖvrigt: För att garantera den allmänna säkerheten är åldersgränsen till gymmet och de instruerade lektionerna 15 år. För deras egen säkerhets skull får små barn inte vistas på gymmet, i gymmet används kläder och skor för inomhusmotion.Vid Britas idrottspark finns två separata parkeringsområden på olika sidor av parken. Parkeringen vid ishallen ligger längs Britasvägen på Plottbrinken 1. Parkeringen vid simhallen ligger på Britas skogsväg 6. På parkeringen vid simhallen finns även möjlighet till handikapparkering. | 8 | Sports Services also has 12 gyms and five weight-training halls in Helsinki. |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [unit] ( [id] INTEGER PRIMARY KEY, [connections] TEXT, [accessibility_properties] TEXT, [identifiers_0_namespace] TEXT, [identifiers_0_value] TEXT, [identifiers_1_namespace] TEXT, [identifiers_1_value] TEXT, [department] TEXT, [root_department] TEXT, [provider_type] TEXT, [organizer_type] TEXT, [contract_type_id] TEXT, [contract_type_description_fi] TEXT, [contract_type_description_sv] TEXT, [contract_type_description_en] TEXT, [is_active] INTEGER, [deleted_at] TEXT, [organizer_name] TEXT, [organizer_business_id] TEXT, [picture_url] TEXT, [picture_entrance_url] TEXT, [streetview_entrance_url] TEXT, [description_fi] TEXT, [description_en] TEXT, [short_description] TEXT, [name_fi] TEXT, [name_en] TEXT, [street_address_fi] TEXT, [street_address_sv] TEXT, [street_address_en] TEXT, [www_fi] TEXT, [www_sv] TEXT, [www_en] TEXT, [address_postal_full] TEXT, [call_charge_info_fi] TEXT, [call_charge_info_sv] TEXT, [call_charge_info_en] TEXT, [picture_caption] TEXT, [phone] TEXT, [fax] TEXT, [email] TEXT, [accessibility_phone] TEXT, [accessibility_email] TEXT, [accessibility_www] TEXT, [created_time] TEXT, [address_zip] TEXT, [data_source] TEXT, [extensions_maintenance_group] TEXT, [extensions_maintenance_organization] TEXT, [last_modified_time] TEXT, [accessibility_viewpoints] TEXT, [root_service_nodes] TEXT, [municipality] TEXT, [service_nodes] TEXT, [services] TEXT, [keywords] TEXT, [location_type] TEXT, [location_coordinates_0] FLOAT, [location_coordinates_1] FLOAT, [address_postal_full_fi] TEXT, [identifiers_2_value] TEXT, [picture_caption_fi] TEXT, [call_charge_info] TEXT, [www] TEXT, [name_sv] TEXT, [short_description_fi] TEXT, [accessibility_shortcoming_count_reduced_mobility] TEXT, [accessibility_shortcoming_count_wheelchair] TEXT, [location] TEXT, [picture_caption_sv] TEXT, [accessibility_shortcoming_count_stroller] TEXT, [address_postal_full_en] TEXT, [accessibility_shortcoming_count_hearing_aid] TEXT, [street_address] TEXT, [contract_type] TEXT, [accessibility_shortcoming_count_rollator] TEXT, [identifiers_2_namespace] TEXT, [address_postal_full_sv] TEXT, [short_description_sv] TEXT, [description_sv] TEXT, [accessibility_shortcoming_count_visually_impaired] TEXT, [short_description_en] TEXT, [description] TEXT, [picture_caption_en] TEXT );