1 row where accessibility_shortcoming_count_visually_impaired = 8 and "created_time" is on date 2015-08-11

View and edit SQL

Suggested facets: last_modified_time (date)

provider_type

created_time (date)

  • 2015-08-11 · 1

accessibility_shortcoming_count_visually_impaired

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

CSV options:

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
);