unit
6 rows where accessibility_shortcoming_count_reduced_mobility = 9
This data as json, CSV (advanced)
Suggested facets: department, root_department, provider_type, contract_type_id, contract_type_description_fi, contract_type_description_sv, contract_type_description_en, email, created_time, data_source, extensions_maintenance_organization, root_service_nodes, municipality, keywords, accessibility_shortcoming_count_wheelchair, accessibility_shortcoming_count_stroller, accessibility_shortcoming_count_rollator, accessibility_shortcoming_count_visually_impaired, created_time (date), last_modified_time (date)
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8089 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Aukioloajat"}, "www": {"fi": "http://luontotalo.munstadi.fi/aukioloajat/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Kysymys & vastauspalsta Pulmakulma", "sv": "Fr\u00e5ge- & svarspalten Pulmakulma", "en": "Forum for questions and answers"}, "www": {"fi": "http://www.nuoret.info/", "sv": "http://www.nuoret.info/", "en": "http://www.nuoret.info/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Harrastushaku.fi", "sv": "Harrastushaku.fi", "en": "Harrastushaku.fi"}, "www": {"fi": "http://nk.hel.fi/harrastushaku/", "sv": "http://nk.hel.fi/harrastushaku/", "en": "http://nk.hel.fi/harrastushaku/"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 105}, {"value": "sufficiently_wide", "variable": 18}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 21}, {"value": "true", "variable": 37}, {"value": "false", "variable": 48}, {"value": "false", "variable": 62}, {"value": "true", "variable": 59}, {"value": "false", "variable": 107}, {"value": "true", "variable": 44}, {"value": "true", "variable": 38}, {"value": "spiral_staircase", "variable": 93}, {"value": "false", "variable": 96}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 25}, {"value": "false", "variable": 58}, {"value": "false", "variable": 42}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 50}, {"value": "false", "variable": 43}, {"value": "false", "variable": 106}, {"value": "false", "variable": 94}, {"value": "false", "variable": 34}, {"value": "0", "variable": 1}, {"value": "false", "variable": 53}, {"value": "false", "variable": 84}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "opens_easily_manually", "variable": 54}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 57}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "3", "variable": 64}, {"value": "true", "variable": 23}, {"value": "false", "variable": 29}, {"value": "false", "variable": 70}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 6}, {"value": "false", "variable": 33}, {"value": "true", "variable": 35}, {"value": "false", "variable": 79}, {"value": "false", "variable": 102}, {"value": "false", "variable": 52}, {"value": "false", "variable": 40}, {"value": "false", "variable": 22}, {"value": "rough", "variable": 17}, {"value": "true", "variable": 5}, {"value": "true", "variable": 92}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 97}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "true", "variable": 104}, {"value": "false", "variable": 4… | internal | 3041 | cfe4d81b-7366-4ae2-b87b-b986e10cd220 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | http://luontotalo.munstadi.fi/files/2014/01/Luontotalo_talokaruselli_900x300px.jpg | Meriharjun luontotalo | Young People's Nature House, Villa Paulig | Uutelantie 32 | Nybondasvägen 32 | Uutelantie 32 | http://luontotalo.munstadi.fi/ | http://luontotalo.munstadi.fi/ | http://luontotalo.munstadi.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 89038 | +358 9 310 89038 | luonto.talo@hel.fi | +358 9 310 89038 | luonto.talo@hel.fi | 2008-09-09T20:14:31+03:00 | 00990 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:02.553804+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 | [426, 458] | [580, 391] | {} | PL 84404, 00099 Helsingin kaupunki | Meriharju naturhus | 9 | 11 | 1 | P.O. Box 84404, 00099 City of Helsinki | 1 | 10 | PB 84404, 00099 Helsingfors stad | 13 | ||||||||||||||||||||||||||||||||
| 8100 | [{"section_type": "LINK", "name": {"fi": "Kysymys & vastauspalsta Pulmakulma", "sv": "Fr\u00e5ge- & svarspalten Pulmakulma", "en": "Forum for questions and answers"}, "www": {"fi": "http://www.nuoret.info/", "sv": "http://www.nuoret.info/", "en": "http://www.nuoret.info/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Harrastushaku.fi", "sv": "Harrastushaku.fi", "en": "Harrastushaku.fi"}, "www": {"fi": "http://nk.hel.fi/harrastushaku/", "sv": "http://nk.hel.fi/harrastushaku/", "en": "http://nk.hel.fi/harrastushaku/"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 50}, {"value": "false", "variable": 29}, {"value": "false", "variable": 57}, {"value": "false", "variable": 34}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 22}, {"value": "0", "variable": 1}, {"value": "false", "variable": 105}, {"value": "true", "variable": 59}, {"value": "false", "variable": 103}, {"value": "false", "variable": 20}, {"value": "false", "variable": 104}, {"value": "false", "variable": 84}, {"value": "true", "variable": 23}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "false", "variable": 102}, {"value": "false", "variable": 33}, {"value": "false", "variable": 92}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 21}, {"value": "false", "variable": 98}, {"value": "sufficiently_wide", "variable": 18}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 5}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 62}, {"value": "false", "variable": 48}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 38}, {"value": "false", "variable": 37}, {"value": "false", "variable": 25}, {"value": "false", "variable": 79}, {"value": "false", "variable": 83}, {"value": "false", "variable": 52}, {"value": "false", "variable": 44}, {"value": "false", "variable": 107}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 40}, {"value": "rough", "variable": 17}, {"value": "no_handrails", "variable": 41}, {"value": "2_consecutive_steps", "variable": 24}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "false", "variable": 51}, {"value": "false", "variable": 49}] | internal | 3042 | cfe4d81b-7366-4ae2-b87b-b986e10cd220 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Granön leirialue | Granö | Granö | Granö | http://grano.munstadi.fi/ | http://grano.munstadi.fi/ | http://grano.munstadi.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 71650 | +358 9 310 71650 | kari.pitkanen@hel.fi | 2008-09-09T20:14:31+03:00 | www.hel.fi | kaikki | sipoo | 2020-11-05T16:31:02.632750+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] | sipoo | [405] | [291] | {} | Point | 25.23261 | 60.22764 | PL 5066, 00099 Helsingin kaupunki | 9 | 10 | 2 | P.O. Box 5066, 00099 City of Helsinki | 1 | 10 | PB 5066, 00099 Helsingfors stad | 12 | |||||||||||||||||||||||||||||||||||
| 14408 | [{"section_type": "LINK", "name": {"fi": "Koulun kotisivu"}, "www": {"fi": "http://www.kauniaistenkuvataidekoulu.fi/"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 34}, {"value": "0", "variable": 1}, {"value": "false", "variable": 79}, {"value": "false", "variable": 21}, {"value": "false", "variable": 107}, {"value": "false", "variable": 48}, {"value": "false", "variable": 51}, {"value": "false", "variable": 43}, {"value": "false", "variable": 5}, {"value": "true", "variable": 23}, {"value": "true", "variable": 37}, {"value": "true", "variable": 57}, {"value": "2", "variable": 63}, {"value": "no_handrails", "variable": 95}, {"value": "true", "variable": 52}, {"value": "false", "variable": 53}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 59}, {"value": "false", "variable": 62}, {"value": "false", "variable": 105}, {"value": "at_least_4_steps", "variable": 39}, {"value": "false", "variable": 102}, {"value": "true", "variable": 40}, {"value": "no_handrails", "variable": 41}, {"value": "false", "variable": 49}, {"value": "false", "variable": 98}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 22}, {"value": "true", "variable": 38}, {"value": "true", "variable": 25}, {"value": "false", "variable": 104}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 44}, {"value": "sufficiently_wide", "variable": 18}, {"value": "at_least_4_steps", "variable": 24}, {"value": "false", "variable": 84}, {"value": "false", "variable": 97}, {"value": "true", "variable": 20}, {"value": "false", "variable": 83}, {"value": "false", "variable": 33}, {"value": "smooth", "variable": 17}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 58}, {"value": "false", "variable": 29}, {"value": "over_20mm", "variable": 56}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 28}, {"value": "true", "variable": 94}, {"value": "true", "variable": 92}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 70}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 103}, {"value": "true… | internal | 4387 | 4a87368d-4a78-40ea-8a18-2a944f713ab5 | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | OTHER_PRODUCTION_METHOD | PRIVATE_ENTERPRISE | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Kauniaisten kuvataidekoulu on perustettu 1978. Suomen vanhin kuvataidekoulu antaa kuvataiteen laajan oppimäärän mukaista perusopetusta 4-20-vuotiaille lapsille ja nuorille, suomeksi ja ruotsiksi. Koulua ylläpitää kannatusyhdistys ja toimintaa tukee Kauniaisten kaupunki. | Kauniaisten kuvataidekoulu | Läntinen Koulupolku 3 | Västra Skolstigen 3 | Läntinen Koulupolku 3 | http://www.kauniaistenkuvataidekoulu.fi/ | http://www.kauniaistenkuvataidekoulu.fi/?lang=sv | http://www.kauniaistenkuvataidekoulu.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 40 521 3036 | kuvataidekoulu@kauniainen.fi | 2014-03-26T16:39:26+02:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-11-18T07:30:56.625453+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"} | [1087, 1403] | kauniainen | [418, 1369] | [360, 359] | {"fi": ["kuvataide", "kuvataidekoulu", "lapset", "nuoret", "perusopetus", "taidekoulu", "ty\u00f6paja", "taide"], "sv": ["barn", "bildkonst", "bildkonstskola", "grundutbildning", "konst", "konstskola", "ungdomar", "verkstad"]} | Point | 24.724125 | 60.214394 | Läntinen koulupolku 3, 02700 Kauniainen | Grankulla konstskola | Kuvataidekoulu 4-20-vuotiaille lapsille sekä nuorille. | 9 | 10 | 3 | Läntinen Koulupolku 3, 02700 Kauniainen | 1 | 10 | Västra Skolstigen 3, 02700 Grankulla | En konstskola för barn och ungdomar från 4-20 år. | Grankulla konstskola grundades år 1978 och är Finlands äldsta konstskola.Konstskolan ger grundundervisning i bildkonst, för barn och unga på finska och svenska. Skolan upprätthålls av understödsföreningen för Grankulla konstskola. Grankulla stad understöder skolans verksamhet. | 13 | |||||||||||||||||||||||||||||
| 18439 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 06-18", "sv": "\u00f6ppet m\u00e5n-fre 06-18", "en": "open Mon-Fri 06-18"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "P\u00e4iv\u00e4kotimme on avoinna klo 6-18 ennalta sovitusti tarpeen mukaan."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodin johtaja"}, "www": null, "email": "heli.olkkonen@vantaa.fi", "phone": "+358 50 302 6746", "contact_person": "Heli Olkkonen"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.laajavuori@vantaa.fi", "phone": null, "contact_person": "Esikot"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "tuutikit.laajavuori@eduvantaa.fi", "phone": "+358 43 827 2019", "contact_person": "Tuutikit"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "tenavat.laajavuori@eduvantaa.fi", "phone": "+358 43 827 2018", "contact_person": "Tenavat"}, {"section_type": "LINK", "name": {"fi": "Anna palautetta", "sv": "Ber\u00e4tta din \u00e5sikt", "en": "Tell us your opinion"}, "www": {"fi": "https://asiointi.vantaa.fi/anna-palautetta", "sv": "https://asiointi.vantaa.fi/anna-palautetta", "en": "https://asiointi.vantaa.fi/anna-palautetta"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 52}, {"value": "false", "variable": 104}, {"value": "false", "variable": 79}, {"value": "true", "variable": 92}, {"value": "false", "variable": 5}, {"value": "no_handrails", "variable": 32}, {"value": "false", "variable": 107}, {"value": "false", "variable": 58}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 20}, {"value": "true", "variable": 51}, {"value": "false", "variable": 33}, {"value": "false", "variable": 102}, {"value": "false", "variable": 105}, {"value": "false", "variable": 97}, {"value": "false", "variable": 96}, {"value": "false", "variable": 70}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 57}, {"value": "false", "variable": 62}, {"value": "spiral_staircase", "variable": 93}, {"value": "false", "variable": 49}, {"value": "true", "variable": 53}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 29}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 31}, {"value": "true", "variable": 37}, {"value": "true", "variable": 94}, {"value": "true", "variable": 23}, {"value": "false", "variable": 48}, {"value": "ramp_over_6m_long_with_intermediate_landing", "variable": 30}, {"value": "false", "variable": 34}, {"value": "true", "variable": 59}, {"value": "true", "variable": 50}, {"value": "false", "variable": 103}, {"value": "2", "variable": 64}, {"value": "false", "variable": 28}, {"value": "false", "variable": 44}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 84}, {"value": "no_handrails", "variable": 26}, {"value": "at_least_4_steps", "variable": 24}, {"value": "false", "variable": 38}, {"value": "false", "variable": 21}, {"value": "false", "variable": 98}, {"value": "0", "variable": 1}, {"value": "rough", "variable": 17}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 22}, {"value": "false", "variable": 83}, {"value": "canopy_above_entrance", "… | internal | 5158 | ab4f37d0-3e53-462e-ad40-c73b57e3e39e | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Laajavuoren päiväkodissa toimii kaksi 3-5-vuotiaiden lasten ryhmää yläkerrassa sekä yksi 1-3-vuotiaiden lasten ryhmä alakerrassa, joissa tarjoamme kokopäiväistä varhaiskasvatusta.Laajavuoren päiväkodin kasvatusnäkemyksen ja toiminta-ajatuksen lähtökohta on kunkin lapsen arvostaminen yksilönä, juuri sellaisena kuin hän on. Päiväkotimme suurena vahvuutena on täältä löytyvä monimuotoisuuden kirjo. Me kaikki olemme ainutkertaisia ja erilaisia, kaikilla meillä on oppimista toisiltamme. Haluamme kasvattaa hyvän itsetunnon omaavia ja oman ainutlaatuisuutensa tiedostavia yksilöitä. Kaikki toiminta tulee olla lapsilähtöistä, juuri näiden hoidossamme olevien lasten tarpeita vastaavaa. Emme näe lapsuutta vain välivaiheena kohti aikuisuutta, vaan ainutkertaisena ja tärkeänä osana ihmiselämää, jolloin turvallisella ja lämpimällä kasvatusmallilla luodaan vahva perusta, joka kantaa pitkälle elämässä. | Laajavuoren päiväkoti | Laajavuorenrinne 5 | Bredbergsbrinken 5 | Laajavuorenrinne 5 | https://www.vantaa.fi/varhaiskasvatus_ja_koulutus/varhaiskasvatus/palvelut/paivakodit/myyrmaki/laajavuoren_paivakoti | http://www.vanda.fi/smabarnspedagogik_och_utbildning/smabarnspedagogik/olika_alternativ/daghem | http://www.vantaa.fi/day_care_and_education/early_childhood_education/early_childhood_education_options/day_care_centers | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 839 11 | etunimi.sukunimi@vantaa.fi | +358 9 8393 4756 | 2014-11-19T17:01:21+02:00 | 01620 | www.vantaa.fi | kaikki | vantaa | 2020-11-05T16:31:11.867113+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"} | [1405] | vantaa | [871, 870] | [663] | {"fi": ["varhaiskasvatus", "p\u00e4iv\u00e4koti", "suomenkielinen varhaiskasvatus", "tarha", "lastentarha"]} | Point | 24.84193 | 60.27841 | PL 2417, 01030 Vantaan kaupunki | Päiväkodissamme toimii kaksi 3-5-vuotiaiden lasten ryhmää sekä yksi 1-3-vuotiaiden lasten ryhmä, joissa tarjoamme kokopäiväistä varhaiskasvatusta. | 9 | 13 | 1 | P.O. Box 2417, 01030 City of Vantaa | 1 | 12 | PB 2417, 01030 Vanda stad | 9 | ||||||||||||||||||||||||||||||||
| 19341 | [{"section_type": "OPENING_HOURS", "name": {"fi": "COVID-19: Kiirreellinen hammashoito puh. 09 8393 5300 ma-to klo 7.30-15.00, pe klo 7.30-14.00."}, "www": null, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 35}, {"value": "true", "variable": 38}, {"value": "false", "variable": 21}, {"value": "no_handrails", "variable": 95}, {"value": "true", "variable": 57}, {"value": "true", "variable": 6}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 79}, {"value": "false", "variable": 43}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 23}, {"value": "false", "variable": 22}, {"value": "false", "variable": 105}, {"value": "true", "variable": 20}, {"value": "2_consecutive_steps", "variable": 93}, {"value": "false", "variable": 29}, {"value": "false", "variable": 97}, {"value": "false", "variable": 94}, {"value": "true", "variable": 92}, {"value": "false", "variable": 52}, {"value": "false", "variable": 102}, {"value": "false", "variable": 82}, {"value": "false", "variable": 48}, {"value": "false", "variable": 33}, {"value": "false", "variable": 28}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 84}, {"value": "true", "variable": 59}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 83}, {"value": "false", "variable": 80}, {"value": "2_consecutive_steps", "variable": 24}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 49}, {"value": "0", "variable": 1}, {"value": "false", "variable": 40}, {"value": "false", "variable": 98}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 50}, {"value": "true", "variable": 62}, {"value": "false", "variable": 34}, {"value": "over_20mm", "variable": 91}, {"value": "no_handrails", "variable": 41}, {"value": "true", "variable": 37}, {"value": "false", "variable": 25}, {"value": "true", "variable": 51}, {"value": "no_handrails", "variable": 26}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 107}, {"value": "tr… | internal | 5512 | 8809b663-71b1-43bd-a894-ac7d0c503427 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | service_by_municipally_owned_company | kunnan liikelaitoksen palvelu | tjänst från kommunalt affärsverk | service by municipally owned company | 1 | Simonkallion koulun hammashoitola | Dental clinic at Simonkallion koulu | Simonkalliontie 1 | Simonsbergsvägen 1 | http://www.vantaa.fi/terveys-_ja_sosiaalipalvelut/terveyspalvelut/hammashoito/hammashoitolat | http://www.vanda.fi/halsovard_och_sociala_tjanster/halsovardstjanster/tandvard/tandklinikerna | http://www.vantaa.fi/en/social_and_health_care_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8393 5300 | etunimi.sukunimi@vantaa.fi | +358 9 8392 3805 | 2014-11-19T17:01:21+02:00 | 01350 | www.vantaa.fi | kaikki | vantaa | 2020-05-05T09:30:55.948613+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"} | [986] | vantaa | [995] | [184] | {} | Point | 25.023745 | 60.307026 | Simonkalliontie 1, 01350 Vantaa | Tandkliniken vid Simonkallion koulu | 9 | 9 | 2 | 1 | 9 | 12 | |||||||||||||||||||||||||||||||||||
| 29582 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "1", "variable": 1}, {"value": "false", "variable": 79}, {"value": "true", "variable": 59}, {"value": "over_10m", "variable": 4}, {"value": "false", "variable": 57}, {"value": "false", "variable": 28}, {"value": "false", "variable": 48}, {"value": "false", "variable": 104}, {"value": "false", "variable": 84}, {"value": "false", "variable": 102}, {"value": "false", "variable": 29}, {"value": "false", "variable": 40}, {"value": "sufficiently_wide", "variable": 18}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 23}, {"value": "false", "variable": 51}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 5}, {"value": "false", "variable": 34}, {"value": "false", "variable": 107}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 83}, {"value": "false", "variable": 105}, {"value": "false", "variable": 21}, {"value": "over_20mm", "variable": 91}, {"value": "outdoors", "variable": 2}, {"value": "no_handrails", "variable": 26}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "no_handrails", "variable": 41}, {"value": "false", "variable": 25}, {"value": "true", "variable": 38}, {"value": "false", "variable": 52}, {"value": "false", "variable": 33}, {"value": "true", "variable": 22}, {"value": "false", "variable": 44}, {"value": "guided_and_clear", "variable": 19}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 98}, {"value": "false", "variable": 92}, {"value": "true", "variable": 62}, {"value": "false", "variable": 103}, {"value": "false", "variable": 37}, {"value": "at_least_4_steps", "variable": 24}, {"value": "less_than_3600mm", "variable": 3}, {"value": "false", "variable": 43}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 49}, {"value": "at_least_4_steps", "variable": 39}, {"value": "true", "variable": 50}, {"value": "false", "variable": 20}] | internal | 8613 | 6c92d0db-4ee8-414c-9527-b2cf2704739b | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | http://www.espoo.fi/materiaalit/asuminen_ja_ymparisto/muut_aineistot/palvelukartan_kuvat/Parkvillanpiha_Palvelukartta.JPG | Vanhan puutalon ympäröivä viheralue Etelä-Leppävaarassa. | A green area surrounding the old wooden house in Southern Leppävaara. | Parkvillanpihan puisto | Parkvilla park | Slöörinpolku | Slöörsstigen | Slöörinpolku | https://www.espoo.fi/fi-FI/Asuminen_ja_ymparisto/Ymparisto_ja_luonto/Puistot_metsat_ja_niityt | https://www.esbo.fi/sv-FI/Boende_och_miljo/Miljo_och_natur/Parker_och_gronomraden | https://www.espoo.fi/en-US/Housing_and_environment/Environment_and_nature/Parks_and_Green_Areas | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8162 5100 | 2015-11-03T12:03:45+02:00 | 02600 | www.espoo.fi | kaikki | espoo | 2020-03-13T09:31:28.725281+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"} | [1400, 1403] | espoo | [71, 502] | [786] | {"sv": ["fritid", "gr\u00f6naparken", "gr\u00f6nomr\u00e5de", "parken"], "en": ["green area", "leasure time", "leisure time spending", "park"], "fi": ["vapaa-aika", "puisto", "viheralue", "viherpuisto"]} | Point | 24.809618 | 60.21497 | Parkvillagårdens park | 9 | 9 | 2 | 1 | 9 | Ett grönområde som omger ett gammalt trähus i södra Alberga. | 13 |
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 );