6 rows where accessibility_shortcoming_count_stroller = 2 and "created_time" is on date 2014-09-05

View and edit SQL

Suggested facets: connections, street_address_sv, service_nodes

accessibility_shortcoming_count_wheelchair

created_time (date)

  • 2014-09-05 · 6

accessibility_shortcoming_count_stroller

identifiers_2_namespace

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
39371 [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/efeedback/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Ohjattuun liikuntaan ilmoittautuminen"}, "www": {"fi": "https://resurssivaraus.espoo.fi/ohjattuliikunta/haku"}, "email": null, "phone": null, "contact_person": null}] [{"value": "false", "variable": 92}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 104}, {"value": "true", "variable": 25}, {"value": "false", "variable": 103}, {"value": "handrails_on_one_side", "variable": 26}, {"value": "false", "variable": 80}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "false", "variable": 28}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 5}, {"value": "false", "variable": 44}, {"value": "false", "variable": 58}, {"value": "false", "variable": 21}, {"value": "true", "variable": 51}, {"value": "false", "variable": 107}, {"value": "at_least_4_steps", "variable": 24}, {"value": "false", "variable": 37}, {"value": "false", "variable": 102}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 79}, {"value": "true", "variable": 53}, {"value": "true", "variable": 62}, {"value": "true", "variable": 50}, {"value": "gym", "variable": 61}, {"value": "true", "variable": 23}, {"value": "false", "variable": 83}, {"value": "true", "variable": 59}, {"value": "false", "variable": 98}, {"value": "false", "variable": 29}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 52}, {"value": "0", "variable": 1}, {"value": "false", "variable": 22}, {"value": "false", "variable": 48}, {"value": "true", "variable": 20}, {"value": "false", "variable": 105}, {"value": "false", "variable": 33}, {"value": "false", "variable": 27}, {"value": "sport_facility", "variable": 60}, {"value": "indoor_facility", "variable": 500}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 34}, {"value": "false", "variable": 38}, {"value": "false", "variable": 84}, {"value": "false", "variable": 49}, {"value": "true", "variable": 57}] internal 13716 lipas 78491 d8dab34f-a68f-4244-b906-84e7f651b8e1 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1       https://c1.staticflickr.com/5/4291/36005831562_997b8f3acb_b.jpg     Olarin kuntosalilla on sekä ohjattua että vapaaharjoittelutoimintaa.     Olarin kuntosali   Yläportti 4 a-b Överporten 4 a-b Yläportti 4 a-b http://www.espoo.fi/fi-FI/Kulttuuri_ja_liikunta/Liikunta/Liikunta_ja_ulkoilupaikat/Kuntosalit http://www.espoo.fi/fi-FI/Kulttuuri_ja_liikunta/Liikunta/Liikunta_ja_ulkoilupaikat/Kuntosalit http://www.espoo.fi/fi-FI/Kulttuuri_ja_liikunta/Liikunta/Liikunta_ja_ulkoilupaikat/Kuntosalit   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 816 21         2014-09-05T13:29:21+03:00 02210 www.espoo.fi kaikki espoo 2020-11-25T08:01:31.709075+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1403] espoo [611] [350] {} Point 24.734371 60.175503           Olars gym   4 8     2   1     8         8      
39753 [{"section_type": "ESERVICE_LINK", "name": {"fi": "Ohjattuun liikuntaan ilmoittautuminen"}, "www": {"fi": "https://resurssivaraus.espoo.fi/ohjattuliikunta/haku"}, "email": null, "phone": null, "contact_person": null}] [{"value": "0", "variable": 1}, {"value": "handrails_on_one_side", "variable": 26}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 49}, {"value": "false", "variable": 80}, {"value": "true", "variable": 52}, {"value": "true", "variable": 94}, {"value": "false", "variable": 38}, {"value": "false", "variable": 102}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 21}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "at_least_4_steps", "variable": 24}, {"value": "swimming_hall", "variable": 61}, {"value": "true", "variable": 97}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 92}, {"value": "true", "variable": 20}, {"value": "true", "variable": 53}, {"value": "true", "variable": 23}, {"value": "spiral_staircase", "variable": 93}, {"value": "true", "variable": 50}, {"value": "true", "variable": 104}, {"value": "false", "variable": 48}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "true", "variable": 59}, {"value": "false", "variable": 70}, {"value": "false", "variable": 29}, {"value": "false", "variable": 28}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 103}, {"value": "true", "variable": 105}, {"value": "false", "variable": 34}, {"value": "false", "variable": 27}, {"value": "true", "variable": 51}, {"value": "false", "variable": 58}, {"value": "false", "variable": 44}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 5}, {"value": "false", "variable": 79}, {"value": "false", "variable": 107}, {"value": "false", "variable": 98}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 33}, {"value": "false", "variable": 83}, {"value": "false", "variable": 62}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 37}, {"value": "-1", "variable": 63}, {"value": "false", "variable": 96}, {"value": "true", "variable": 106}, {"value": "true", "variable": 25}, {"value": "false", "variable": 84}, {"… internal 13462 lipas 505921 d8dab34f-a68f-4244-b906-84e7f651b8e1 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1       https://c1.staticflickr.com/5/4305/36005695632_20ac29c6b3_b.jpg     Uima-allas pituus 15m, leveys n. 3m, syvyys 1.5-1.6m, veden lämpötila 28°C Olarissa yleisöuintivuoroille pääsee (vielä puoli tuntia ennen sulkemista) rannekkeella (kertamaksut tai setelit eivät käy). 68+ -vuotiaat pääsevät uimaan 68+ -Sporttirannekkeella.     Olarin uimahalli Olari Swimming Pool Yläportti 4 A-B Överporten 4 A-B Yläportti 4 A-B http://www.espoo.fi/fi-FI/Kulttuuri_ja_liikunta/Liikunta/Liikunta_ja_ulkoilupaikat/Uimahallit/Olari https://www.esbo.fi/sv-FI/Kultur_och_idrott/Idrott/Idrotts_och_friluftsliv_anlaggningar/Simhallar/Olars https://www.espoo.fi/en-US/Culture_and_sport/Sports/Sports_and_Recreation_Facilities/Swimming_halls/Olari   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8168 2734         2014-09-05T13:29:21+03:00 02210 www.espoo.fi kaikki espoo 2020-11-27T07:31:30.179896+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1403] espoo [693] [729] {} Point 24.73457 60.175507           Olars simhall   6 10     2   1     10         11      
40214 [{"section_type": "HIGHLIGHT", "name": {"fi": "Helsingin kaupungin sis\u00e4liikuntapaikat suljettu koronarajoitusten takia 30.11.2020-10.1.2021", "sv": "Helsingfors stads idrotts- och motionslokaler \u00e4r st\u00e4ngda p\u00e5 grund av coronarestriktioner 30.11.2020 - 10.1.2021.", "en": "City of Helsinki's indoor sports facilities are closed due Covid-19 restrictions from November 30th, 2020 to January 10th, 2021."}, "www": {"fi": "https://www.hel.fi/uutiset/fi/kaupunginkanslia/pkseudun-koronakoordinaatioryhma-rajoitusten-jatkamisesta", "sv": "https://www.hel.fi/uutiset/fi/kaupunginkanslia/pkseudun-koronakoordinaatioryhma-rajoitusten-jatkamisesta", "en": "https://www.hel.fi/uutiset/fi/kaupunginkanslia/pkseudun-koronakoordinaatioryhma-rajoitusten-jatkamisesta"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "TOPICAL", "name": {"fi": "Helsingin sis\u00e4liikuntatiloissa edellytet\u00e4\u00e4n maanantaista 2.11.2020 alkaen kaikilta 15 vuotta t\u00e4ytt\u00e4neilt\u00e4 kasvomaskin k\u00e4ytt\u00f6\u00e4. Helsingin sis\u00e4liikuntatilojen\u202fpukeutumis- ja peseytymistilat pidet\u00e4\u00e4n avoinna, mutta niiss\u00e4 toivotaan v\u00e4ltett\u00e4v\u00e4n asioimista tai sen toteutuvan mahdollisimman nopeasti.", "sv": "Fr\u00e5n och med m\u00e5ndagen den 2 november 2020 kommer Helsingfors att kr\u00e4va att alla \u00f6ver 15 \u00e5r anv\u00e4nder munskydd i lokaler f\u00f6r inomhusmotion. Omkl\u00e4dnings- och duschutrymmena i st\u00e4dernas lokaler f\u00f6r inomhusidrott h\u00e5lls \u00f6ppna, men st\u00e4derna hoppas att man ska undvika att anv\u00e4nda dem eller vistas d\u00e4r s\u00e5 kort tid som m\u00f6jligt.", "en": "As of Monday 2 November 2020, the city of Helsinki will require face mask usage from all persons above 15 years of age at the indoor sports facilities. The dressing and shower rooms of cities' indoor sports facilities will be kept open, but they should be avoided or at least used as quickly as possible."}, "www": {"fi": "https://www.hel.fi/uutiset/fi/kulttuurin-ja-vapaa… [{"value": "false", "variable": 49}, {"value": "false", "variable": 118}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 58}, {"value": "false", "variable": 112}, {"value": "true", "variable": 107}, {"value": "on_door", "variable": 110}, {"value": "false", "variable": 116}, {"value": "false", "variable": 79}, {"value": "rough", "variable": 17}, {"value": "gym", "variable": 61}, {"value": "is_heavy", "variable": 77}, {"value": "true", "variable": 78}, {"value": "false", "variable": 5}, {"value": "true", "variable": 72}, {"value": "false", "variable": 50}, {"value": "false", "variable": 92}, {"value": "true", "variable": 57}, {"value": "false", "variable": 111}, {"value": "false", "variable": 29}, {"value": "false", "variable": 73}, {"value": "false", "variable": 84}, {"value": "0", "variable": 1}, {"value": "false", "variable": 53}, {"value": "false", "variable": 80}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 102}, {"value": "true", "variable": 115}, {"value": "false", "variable": 104}, {"value": "false", "variable": 34}, {"value": "false", "variable": 43}, {"value": "false", "variable": 105}, {"value": "true", "variable": 70}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 75}, {"value": "false", "variable": 59}, {"value": "false", "variable": 21}, {"value": "false", "variable": 48}, {"value": "false", "variable": 103}, {"value": "false", "variable": 23}, {"value": "false", "variable": 83}, {"value": "3", "variable": 63}, {"value": "true", "variable": 51}, {"value": "false", "variable": 76}, {"value": "true", "variable": 20}, {"value": "false", "variable": 62}, {"value": "true", "variable": 109}, {"value": "true", "variable": 37}, {"value": "floor_3", "variable": 108}, {"value": "true", "variable": 114}, {"value": "true", "variable": 40}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "false", "variable": 22}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 44}, … internal 13771 lipas 78465 aea46dd4-caec-4f97-9206-10e939dc6b8d 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Yrjönkadun uimahalli / Kuntosali   Yrjönkatu 21 b Georgsgatan 21 b Yrjönkatu 21 b         pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 87403         2014-09-05T13:29:49+03:00 00100 www.hel.fi kaikki helsinki 2020-12-11T15:01:36.725494+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1403] helsinki [611] [350] {} Point 24.939047 60.168407           Georgsgatans simhall / Gym   6 10     2   1     10         9      
41401 [{"section_type": "HIGHLIGHT", "name": {"fi": "Helsingin kaupungin sis\u00e4liikuntapaikat suljettu koronarajoitusten takia 30.11.2020-10.1.2021", "sv": "Helsingfors stads idrotts- och motionslokaler \u00e4r st\u00e4ngda p\u00e5 grund av coronarestriktioner 30.11.2020 - 10.1.2021.", "en": "City of Helsinki's indoor sports facilities are closed due Covid-19 restrictions from November 30th, 2020 to January 10th, 2021."}, "www": {"fi": "https://www.hel.fi/uutiset/fi/kaupunginkanslia/pkseudun-koronakoordinaatioryhma-rajoitusten-jatkamisesta", "sv": "https://www.hel.fi/uutiset/fi/kaupunginkanslia/pkseudun-koronakoordinaatioryhma-rajoitusten-jatkamisesta", "en": "https://www.hel.fi/uutiset/fi/kaupunginkanslia/pkseudun-koronakoordinaatioryhma-rajoitusten-jatkamisesta"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "TOPICAL", "name": {"fi": "Helsingin sis\u00e4liikuntatiloissa edellytet\u00e4\u00e4n maanantaista 2.11.2020 alkaen kaikilta 15 vuotta t\u00e4ytt\u00e4neilt\u00e4 kasvomaskin k\u00e4ytt\u00f6\u00e4. Helsingin sis\u00e4liikuntatilojen\u202fpukeutumis- ja peseytymistilat pidet\u00e4\u00e4n avoinna, mutta niiss\u00e4 toivotaan v\u00e4ltett\u00e4v\u00e4n asioimista tai sen toteutuvan mahdollisimman nopeasti.", "sv": "Fr\u00e5n och med m\u00e5ndagen den 2 november 2020 kommer Helsingfors att kr\u00e4va att alla \u00f6ver 15 \u00e5r anv\u00e4nder munskydd i lokaler f\u00f6r inomhusmotion. Omkl\u00e4dnings- och duschutrymmena i st\u00e4dernas lokaler f\u00f6r inomhusidrott h\u00e5lls \u00f6ppna, men st\u00e4derna hoppas att man ska undvika att anv\u00e4nda dem eller vistas d\u00e4r s\u00e5 kort tid som m\u00f6jligt.", "en": "As of Monday 2 November 2020, the city of Helsinki will require face mask usage from all persons above 15 years of age at the indoor sports facilities. The dressing and shower rooms of cities' indoor sports facilities will be kept open, but they should be avoided or at least used as quickly as possible."}, "www": {"fi": "https://www.hel.fi/uutiset/fi/kulttuurin-ja-vapaa… [{"value": "0", "variable": 1}, {"value": "false", "variable": 21}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "false", "variable": 96}, {"value": "false", "variable": 103}, {"value": "true", "variable": 52}, {"value": "false", "variable": 102}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "false", "variable": 84}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 43}, {"value": "false", "variable": 107}, {"value": "false", "variable": 29}, {"value": "false", "variable": 83}, {"value": "true", "variable": 94}, {"value": "true", "variable": 38}, {"value": "false", "variable": 105}, {"value": "false", "variable": 22}, {"value": "false", "variable": 53}, {"value": "over_20mm", "variable": 56}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 44}, {"value": "false", "variable": 48}, {"value": "true", "variable": 58}, {"value": "false", "variable": 50}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 97}, {"value": "false", "variable": 33}, {"value": "at_least_4_turning_steps", "variable": 93}, {"value": "false", "variable": 79}, {"value": "true", "variable": 92}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 70}, {"value": "false", "variable": 49}, {"value": "false", "variable": 80}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 104}, {"value": "false", "variable": 62}, {"value": "no_handrails", "variable": 41}, {"value": "true", "variable": 37}, {"value": "sport_facility", "variable": 60}, {"value": "multipurpose_sport_hall", "variable": 61}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 5}, {"value": "true", "variable": 57}, {"value": "6", "variable": 63}, {"value": "true", "variable": 40}, {"value": "false", "variable": 34}, {"value": "true", "variable": 20}, {"value": "true", "variable": 59}, {"value": "true", "variable": 51}, {"value":… internal 18347 lipas 80861 aea46dd4-caec-4f97-9206-10e939dc6b8d 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Yrjönkadun uimahalli / Liikuntasali Yrjönkatu swimming hall / gymnasium Yrjönkatu 21 b Georgsgatan 21 b Yrjönkatu 21 b https://palvelukartta.hel.fi/fi/unit/41102 https://palvelukartta.hel.fi/sv/unit/41102 https://palvelukartta.hel.fi/en/unit/41102   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 87401         2014-09-05T13:29:49+03:00 00100 www.hel.fi kaikki helsinki 2020-12-11T15:01:41.207239+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1403] helsinki [612, 2221, 2225] [900, 895, 402] {} Point 24.938957 60.168396           Georgsgatans simhall / Gymnastiksal   7 10     2   1     10         10      
42144 [{"section_type": "OPENING_HOURS", "name": {"fi": "Poikkeusaukioloajat: -", "sv": "Avvikande \u00f6ppettider: -", "en": "Exceptional opening hours: -"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "varausten mukaan \n1.9. - 30.4.\nma koulujen k\u00e4yt\u00f6ss\u00e4 \nti, ke, pe 17.00 - 22.00 \nto 18.30 - 22.00 \nla, su 9.00 - 22.00 \n1.5. - 31.8.\nma - pe 8.00 - 21.00 \nla, su 10.00 - 16.00", "sv": "bara med reservering \n1.9 - 30.4 \ni skolbruk m\u00e5ndagar \nti, on, fr 17.00 - 22.00 \nto 18.30 - 22.00 \nl\u00f6, s\u00f6 9.00 - 22.00 \n1.5 - 31.8\nm\u00e5 - fr 8.00 - 21.00 \nl\u00f6, s\u00f6 10.00 - 16.00", "en": "only by booking \n1.9 - 30.4\nMondays reserved for school use \nTue, Wed, Fri 17.00 - 22.00 \nThu 18.30 - 22.00 \nSat, Sun 9.00 - 22.00 \n1.5 - 31.8\nMon - Fri 8.00 - 21.00 \nSat, Sun 10.00 - 16.00"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "HIGHLIGHT", "name": {"fi": "Helsingin kaupungin sis\u00e4liikuntapaikat suljettu koronarajoitusten takia 30.11.2020-10.1.2021", "sv": "Helsingfors stads idrotts- och motionslokaler \u00e4r st\u00e4ngda p\u00e5 grund av coronarestriktioner 30.11.2020 - 10.1.2021.", "en": "City of Helsinki's indoor sports facilities are closed due Covid-19 restrictions from November 30th, 2020 to January 10th, 2021."}, "www": {"fi": "https://www.hel.fi/uutiset/fi/kaupunginkanslia/pkseudun-koronakoordinaatioryhma-rajoitusten-jatkamisesta", "sv": "https://www.hel.fi/uutiset/fi/kaupunginkanslia/pkseudun-koronakoordinaatioryhma-rajoitusten-jatkamisesta", "en": "https://www.hel.fi/uutiset/fi/kaupunginkanslia/pkseudun-koronakoordinaatioryhma-rajoitusten-jatkamisesta"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "liikuntapaikanhoitajat", "sv": "anl\u00e4ggningspersonalen", "en": "facility supervisors"}, "www": null, "email": null, "phone": "+358 9 310 87120", "contact_person": null}, {"section_type": "PHONE_OR_E… [{"value": "0", "variable": 1}, {"value": "1_step", "variable": 39}, {"value": "false", "variable": 29}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 59}, {"value": "true", "variable": 115}, {"value": "true", "variable": 62}, {"value": "true", "variable": 53}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "true", "variable": 80}, {"value": "false", "variable": 111}, {"value": "false", "variable": 102}, {"value": "false", "variable": 105}, {"value": "false", "variable": 34}, {"value": "false", "variable": 48}, {"value": "false", "variable": 21}, {"value": "true", "variable": 6}, {"value": "false", "variable": 103}, {"value": "true", "variable": 57}, {"value": "false", "variable": 104}, {"value": "false", "variable": 23}, {"value": "false", "variable": 92}, {"value": "false", "variable": 116}, {"value": "false", "variable": 118}, {"value": "no_handrails", "variable": 47}, {"value": "true", "variable": 109}, {"value": "over_20mm", "variable": 56}, {"value": "sport_facility", "variable": 60}, {"value": "smooth", "variable": 17}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "true", "variable": 44}, {"value": "false", "variable": 20}, {"value": "false", "variable": 46}, {"value": "false", "variable": 98}, {"value": "false", "variable": 83}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 107}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 5}, {"value": "false", "variable": 33}, {"value": "true", "variable": 117}, {"value": "true", "variable": 113}, {"value": "true", "variable": 58}, {"value": "multipurpose_sport_hall", "variable": 61}, {"value": "true", "variable": 51}, {"value": "true", "variable": 38}, {"value": "true", "variable": 52}, {"value": "false", "variable": 22}, {"value": "false", "variable": 79}, {"value": "false", "variable": 84}, {"value": "true", "variable": 114}, {"value": "false", "variable": 50}, {"value": "sufficiently_wide", "variable": 18}, {"value": "is_heavy_or_otherwise… internal 11156 lipas 89053 a093e1c0-a3ef-4672-a1c0-c2733b3cca39 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1             Lajit: Jalkapallo, koripallo, lentopallo, karate, liitokiekko. Sport events: Football, basketball, volleyball, karate, frisbee.   Puistolan liikuntahalli Puistola sports hall Koudantie 2 Koutavägen 2 Koudantie 2                     +358 50 302 8236 uistolanliikuntapuisto@hel.fi   2014-09-05T13:29:49+03:00 00760 www.hel.fi kaikki helsinki 2020-12-11T15:01:44.337578+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1403] helsinki [616] [400] {} Point 25.055632 60.26723           Parkstads idrottshall Liikuntapalvelulla on 14 liikuntahallia, mm. palloiluhalli, jalkapallohalli ja hiihtohalli. Liikuntahalleissa voi harrastaa monenlaista liikuntaa. 2 6     2   1     5     Idrott services förfogar över 14 idrottshallar; bollhall, skidhall och fotbollshall. Idrottshallar ger möjligheter till flera slags motion. Grenar: Fotboll, basketboll, volleyboll, frisbee, karate. 5 Sports Services has 14 sports halls; ski hall, ball hall, Football hall. Sports halls offer many types of sports activities.    
42894 [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://asiointi.vantaa.fi/anna-palautetta"}, "email": null, "phone": null, "contact_person": null}] [{"value": "false", "variable": 28}, {"value": "true", "variable": 37}, {"value": "false", "variable": 97}, {"value": "true", "variable": 22}, {"value": "at_least_4_turning_steps", "variable": 93}, {"value": "false", "variable": 62}, {"value": "false", "variable": 21}, {"value": "no_handrails", "variable": 41}, {"value": "handrails_on_both_sides", "variable": 95}, {"value": "true", "variable": 20}, {"value": "false", "variable": 104}, {"value": "true", "variable": 38}, {"value": "false", "variable": 103}, {"value": "false", "variable": 79}, {"value": "at_least_4_steps", "variable": 24}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 92}, {"value": "3_consecutive_steps", "variable": 39}, {"value": "false", "variable": 80}, {"value": "true", "variable": 25}, {"value": "false", "variable": 102}, {"value": "true", "variable": 53}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 59}, {"value": "true", "variable": 50}, {"value": "false", "variable": 34}, {"value": "false", "variable": 43}, {"value": "true", "variable": 94}, {"value": "false", "variable": 29}, {"value": "false", "variable": 105}, {"value": "true", "variable": 6}, {"value": "true", "variable": 23}, {"value": "0", "variable": 1}, {"value": "true", "variable": 57}, {"value": "false", "variable": 48}, {"value": "false", "variable": 27}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 84}, {"value": "false", "variable": 58}, {"value": "sufficiently_wide", "variable": 18}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 52}, {"value": "-1", "variable": 63}, {"value": "sport_facility", "variable": 60}, {"value": "false", "variable": 83}, {"value": "swimming_hall", "variable": 61}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 96}, {"value": "false", "variable": 107}, {"value": "false", "variable": 98}, {"value": "true", "variable": 5}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "false", "variable": 44}, {"valu… internal 10986 lipas 505857 c8fc61df-3e17-40b3-b96c-2097c29304c2 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Korson uimahalli   Kisatie 29 Kampvägen 29 Kisatie 29 http://www.vantaa.fi/fi/liikunta_ja_ulkoilu/uimahallit/korson_uimahalli http://www.vantaa.fi/fi/liikunta_ja_ulkoilu/uimahallit/korson_uimahalli http://www.vantaa.fi/fi/liikunta_ja_ulkoilu/uimahallit/korson_uimahalli   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8393 2229   +358 9 8392 7012 anne.pakarinen@vantaa.fi   2014-09-05T13:30:44+03:00 01450 www.vantaa.fi kaikki vantaa 2020-05-25T07:31:53.641070+03:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1403] vantaa [693] [729] {} Point 25.06988 60.35771               5 9     2   1     9         12      

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