unit
6 rows where accessibility_shortcoming_count_stroller = 2 and "created_time" is on date 2014-09-05
This data as json, CSV (advanced)
Suggested facets: connections, street_address_sv, service_nodes
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 | liikunta@espoo.fi | 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 | liikunta@espoo.fi | 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 | liikuntapalvelut@vantaa.fi | +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
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 );