unit
39 rows where "last_modified_time" is on date 2020-10-15
This data as json, CSV (advanced)
Suggested facets: provider_type, accessibility_shortcoming_count_rollator
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7621 | [{"section_type": "LINK", "name": {"fi": "Taksivene ilman ennakkovarausta 0306363700", "sv": "Taxiboat +358306363700", "en": "Taxiboat +358306363700"}, "www": {"fi": "https://www.venekyyti.fi/", "sv": "https://www.venekyyti.fi/", "en": "https://www.venekyyti.fi/"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 2881 | b7517181-f645-481d-801d-87b184bb111b | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Honkaluoto (saari) | Honkaluoto (island) | Mustikkamaa | Blåbärslandet | Mustikkamaa | 2008-09-05T15:01:19+03:00 | 00570 | www.hel.fi | kaikki | helsinki | 2020-10-15T11:01:00.018777+03:00 | [1402] | helsinki | [548] | [735] | {} | Point | 25.002718 | 60.18138 | Furuskär (ö) | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 7633 | [{"section_type": "LINK", "name": {"fi": "Taksivene ilman ennakkovarausta 0306363700", "sv": "Taxiboat +358306363700", "en": "Taxiboat +358306363700"}, "www": {"fi": "https://www.venekyyti.fi/", "sv": "https://www.venekyyti.fi/", "en": "https://www.venekyyti.fi/"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 2878 | b7517181-f645-481d-801d-87b184bb111b | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Villaluodot Itäinen saari | Villaluodot, Eastern island | Satamasaari | Hamnholmen | Satamasaari | 2008-09-05T15:01:19+03:00 | 00980 | www.hel.fi | kaikki | helsinki | 2020-10-15T12:01:04.813687+03:00 | [1402] | helsinki | [548] | [735] | {} | Point | 25.109179 | 60.175785 | Östra Ullholmen | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 7918 | [{"section_type": "LINK", "name": {"fi": "Taksivene ilman ennakkovarausta 0306363700", "sv": "Taxiboat +358306363700", "en": "Taxiboat +358306363700"}, "www": {"fi": "https://www.venekyyti.fi/", "sv": "https://www.venekyyti.fi/", "en": "https://www.venekyyti.fi/"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 2977 | b7517181-f645-481d-801d-87b184bb111b | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Villaluodot Läntinen saari | Villaluodot, Western Island | Satamasaari | Hamnholmen | Satamasaari | 2008-09-05T15:01:19+03:00 | 00980 | www.hel.fi | kaikki | helsinki | 2020-10-15T11:01:00.192562+03:00 | [1402] | helsinki | [548] | [735] | {} | Point | 25.098087 | 60.176777 | Västra Ullholmen | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 8964 | [] | [] | internal | 3697 | 420121e5-e673-4549-b4fb-1d9347fb2cc1 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Öljyntorjuntavarikko | Oil destruction measures depot | Santahamina | Sandhamn | Santahamina | https://www.hel.fi/pela/fi | https://www.hel.fi/pela/sv | https://www.hel.fi/pela/en | 2009-03-25T09:21:54+02:00 | 00860 | www.hel.fi | kaikki | helsinki | 2020-10-15T11:01:01.756132+03:00 | [1061] | helsinki | [1075] | [839] | {} | Point | 25.037477 | 60.149197 | PL 112, 00099 Helsingin kaupunki | Oljebekämpningsdepån | P.O. Box 112, 00099 City of Helsinki | PB 112, 00099 Helsingfors stad | |||||||||||||||||||||||||||||||||||||||||||||
| 9052 | [] | [] | internal | 3650 | 420121e5-e673-4549-b4fb-1d9347fb2cc1 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Laakson puistoalueen väestöhälytin | Laakso park area population alarm | Lääkärinkatu 3 | Läkaregatan 3 | Lääkärinkatu 3 | 2009-03-25T09:21:54+02:00 | 00270 | www.hel.fi | kaikki | helsinki | 2020-10-15T12:01:06.522671+03:00 | [1061] | helsinki | [1082] | [805] | {} | Point | 24.915726 | 60.195652 | Dals parkområdets befolkningslarm | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 9334 | [] | [] | internal | 3724 | 2acfea95-2982-4293-a6fe-a6fde055f012 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | service_by_municipal_group_entity | kunnan konserniyhteisön palvelu | tjänst från kommunal koncernsammanslutning | service by municipal group entity | 1 | Korkeasaaren vesibussilaituri | Korkeasaari Water Bus Quay | Korkeasaari | Högholmen | Korkeasaari | http://helsinginvesibussit.fi/ | http://helsinginvesibussit.fi/ | http://helsinginvesibussit.fi/ | 2009-05-07T14:31:55+03:00 | 00570 | www.korkeasaari.fi | kaikki | helsinki | 2020-10-15T12:01:07.012526+03:00 | [1402, 1403] | helsinki | [721, 730, 2144] | [776, 142] | {} | Point | 24.979864 | 60.175045 | Högholmens vattenbussbrygga | ||||||||||||||||||||||||||||||||||||||||||||||||
| 10957 | [] | [{"value": "difficult_to_perceive", "variable": 36}, {"value": "true", "variable": 50}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "opens_automatically_with_button", "variable": 54}, {"value": "false", "variable": 33}, {"value": "false", "variable": 48}, {"value": "false", "variable": 52}, {"value": "false", "variable": 29}, {"value": "false", "variable": 111}, {"value": "false", "variable": 116}, {"value": "true", "variable": 114}, {"value": "false", "variable": 5}, {"value": "false", "variable": 57}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 20}, {"value": "true", "variable": 115}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "true", "variable": 107}, {"value": "false", "variable": 22}, {"value": "false", "variable": 51}, {"value": "false", "variable": 38}, {"value": "false", "variable": 37}, {"value": "true", "variable": 113}, {"value": "false", "variable": 118}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 49}, {"value": "false", "variable": 21}, {"value": "false", "variable": 112}, {"value": "true", "variable": 109}, {"value": "true", "variable": 117}, {"value": "smooth", "variable": 17}, {"value": "on_door", "variable": 110}, {"value": "false", "variable": 44}, {"value": "sufficiently_wide", "variable": 18}, {"value": "0", "variable": 1}, {"value": "false", "variable": 34}, {"value": "false", "variable": 23}, {"value": "public_toilet", "variable": 60}, {"value": "indoor_facility", "variable": 500}] | internal | 4076 | db5dbae8-93bb-4248-bfe6-e237b59eec12 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Tokoinrannan yleisövessa | Tokoinranta, public toilet | Tokoinranta | Tokoistranden | Tokoinranta | https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/palvelukuvaus?id=3732 | https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/palvelukuvaus?id=3732 | https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/palvelukuvaus?id=3732 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 22111 | 2009-12-02T16:33:38+02:00 | 00530 | www.hel.fi | kaikki | helsinki | 2020-10-15T12:01:07.512079+03:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "green"} | [1400] | helsinki | [94] | [819] | {"fi": ["wc", "vappu"], "en": ["May Day"], "sv": ["vappen"]} | Point | 24.944675 | 60.180737 | Tokoistranden, allmän toalett | 2 | 3 | 3 | 5 | |||||||||||||||||||||||||||||||||||||||
| 10986 | [] | [] | internal | 3854 | db5dbae8-93bb-4248-bfe6-e237b59eec12 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Talinhuipun koira-aitaus | Talinhuippu, dog park | Poutamäentie 16 | Värmobackavägen 16 | Poutamäentie 16 | https://www.hel.fi/Helsinki/fi/kulttuuri-ja-vapaa-aika/muu-vapaa-aika/lemmikki-ja-kotielaimet/koira/ | https://www.hel.fi/Helsinki/sv/kultur-och-fritid/annan-fritid/husdjur/hundar/ | https://www.hel.fi/Helsinki/en/culture/leisure/pets/dogs/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 22111 | 2009-11-27T07:42:30+02:00 | 00360 | www.hel.fi | kaikki | helsinki | 2020-10-15T12:01:07.675365+03:00 | [1400, 1403] | helsinki | [17, 63, 494] | [317] | {"fi": ["koirapuisto"]} | Point | 24.848022 | 60.216488 | Talitoppen, hundpark | ||||||||||||||||||||||||||||||||||||||||||||
| 10988 | [] | [] | internal | 3866 | db5dbae8-93bb-4248-bfe6-e237b59eec12 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Lassilan koira-aitaus | Lassila, dog park | Niitynperäntie 14 | Ängslyckevägen 14 | Niitynperäntie 14 | https://www.hel.fi/Helsinki/fi/kulttuuri-ja-vapaa-aika/muu-vapaa-aika/lemmikki-ja-kotielaimet/koira/ | https://www.hel.fi/Helsinki/sv/kultur-och-fritid/annan-fritid/husdjur/hundar/ | https://www.hel.fi/Helsinki/en/culture/leisure/pets/dogs/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 22111 | 2009-11-27T07:42:30+02:00 | 00440 | www.hel.fi | kaikki | helsinki | 2020-10-15T13:30:58.295169+03:00 | [1400, 1403] | helsinki | [17, 63, 494] | [317] | {"fi": ["koirapuisto"]} | Point | 24.869684 | 60.23322 | Lassas, hundpark | ||||||||||||||||||||||||||||||||||||||||||||
| 11033 | [] | [] | internal | 4083 | db5dbae8-93bb-4248-bfe6-e237b59eec12 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Santahaminan koira-aitaus | Santahamina, dog park | Santahamina | Sandhamn | Santahamina | https://www.hel.fi/Helsinki/fi/kulttuuri-ja-vapaa-aika/muu-vapaa-aika/lemmikki-ja-kotielaimet/koira/ | https://www.hel.fi/Helsinki/sv/kultur-och-fritid/annan-fritid/husdjur/hundar/ | https://www.hel.fi/Helsinki/en/culture/leisure/pets/dogs/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 22111 | 2009-11-27T07:42:30+02:00 | 00860 | www.hel.fi | kaikki | helsinki | 2020-10-15T13:30:58.534973+03:00 | [1400, 1403] | helsinki | [17, 63, 494] | [317] | {"fi": ["koirapuisto"]} | Point | 25.049158 | 60.14997 | Sandhamn, hundpark | ||||||||||||||||||||||||||||||||||||||||||||
| 11036 | [] | [] | internal | 4090 | db5dbae8-93bb-4248-bfe6-e237b59eec12 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Roihuvuoren koira-aitaus | Roihuvuori, dog park | Vuorenpeikontie 7 | Bergtrollsvägen 7 | Vuorenpeikontie 7 | https://www.hel.fi/Helsinki/fi/kulttuuri-ja-vapaa-aika/muu-vapaa-aika/lemmikki-ja-kotielaimet/koira/ | https://www.hel.fi/Helsinki/sv/kultur-och-fritid/annan-fritid/husdjur/hundar/ | https://www.hel.fi/Helsinki/en/culture/leisure/pets/dogs/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 22111 | 2009-11-27T07:42:30+02:00 | 00820 | www.hel.fi | kaikki | helsinki | 2020-10-15T13:30:58.552733+03:00 | [1400, 1403] | helsinki | [17, 63, 494] | [317] | {"fi": ["koirapuisto"]} | Point | 25.05056 | 60.202347 | Kasberget, hundpark | ||||||||||||||||||||||||||||||||||||||||||||
| 11039 | [] | [] | internal | 4036 | db5dbae8-93bb-4248-bfe6-e237b59eec12 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Ystävyydenpuiston koira-aitaus | Ystävyydenpuisto, dog park | Kunnallisneuvoksentie 18 | Kommunalrådsvägen 18 | Kunnallisneuvoksentie 18 | https://www.hel.fi/Helsinki/fi/kulttuuri-ja-vapaa-aika/muu-vapaa-aika/lemmikki-ja-kotielaimet/koira/ | https://www.hel.fi/Helsinki/sv/kultur-och-fritid/annan-fritid/husdjur/hundar/ | https://www.hel.fi/Helsinki/en/culture/leisure/pets/dogs/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 22111 | 2009-11-27T07:42:30+02:00 | 00930 | www.hel.fi | kaikki | helsinki | 2020-10-15T12:01:07.995318+03:00 | [1400, 1403] | helsinki | [17, 63, 494] | [317] | {"fi": ["koirapuisto"]} | Point | 25.088268 | 60.207066 | Vänskapens park, hundpark | ||||||||||||||||||||||||||||||||||||||||||||
| 11048 | [] | [] | internal | 3858 | db5dbae8-93bb-4248-bfe6-e237b59eec12 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Uutelan suuri koira-aitaus | Uutela, dog park | Särkkäniemi | Rataudden | Särkkäniemi | https://www.hel.fi/Helsinki/fi/kulttuuri-ja-vapaa-aika/muu-vapaa-aika/lemmikki-ja-kotielaimet/koira/ | https://www.hel.fi/Helsinki/sv/kultur-och-fritid/annan-fritid/husdjur/hundar/ | https://www.hel.fi/Helsinki/en/culture/leisure/pets/dogs/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 22111 | 2009-11-27T07:42:30+02:00 | 00990 | www.hel.fi | kaikki | helsinki | 2020-10-15T12:01:08.050057+03:00 | [1400, 1403] | helsinki | [17, 63, 494] | [317] | {"fi": ["koirapuisto"]} | Point | 25.178995 | 60.201668 | Nybondas stora hundpark | ||||||||||||||||||||||||||||||||||||||||||||
| 15499 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 4476 | 828201f3-df6c-42e5-8239-fac577c3b248 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Espoonlahden kotihoito | Merikansantie 4 C | Sjöfolksvägen 4 C | Merikansantie 4 C | http://espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Senioripalvelut/Tukea_ja_apua_kotiin/Kotihoito | http://espoo.fi/sv-FI/Social_och_halsovard/Seniorer/Stod_och_hjalp_i_hemmet/Hemvard | http://espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Senioripalvelut/Tukea_ja_apua_kotiin/Kotihoito | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8164 5436 | 2015-11-03T12:03:45+02:00 | 02320 | www.espoo.fi | kaikki | espoo | 2020-10-15T12:01:09.705556+03:00 | [783, 986] | espoo | [829, 996] | [635] | {"fi": ["espoonlahden kotihoito", "kotihoito", "kotihoidon ohjaaja", "kotihoitopalvelut"]} | Point | 24.661543 | 60.1494 | ||||||||||||||||||||||||||||||||||||||||||||||
| 15641 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 4845 | 828201f3-df6c-42e5-8239-fac577c3b248 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Latokaski-Nöykkiön kotihoito | Merikansantie 4 C | Sjöfolksvägen 4 C | Merikansantie 4 C | http://espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Senioripalvelut/Tukea_ja_apua_kotiin/Kotihoito | http://espoo.fi/sv-FI/Social_och_halsovard/Seniorer/Stod_och_hjalp_i_hemmet/Hemvard | http://espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Senioripalvelut/Tukea_ja_apua_kotiin/Kotihoito | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8164 5443 | 2015-11-03T12:03:45+02:00 | 02320 | www.espoo.fi | kaikki | espoo | 2020-10-15T12:01:10.280826+03:00 | [783, 986] | espoo | [829, 996] | [635] | {"fi": ["espoonlahden kotihoito", "kotihoito", "kotihoidon ohjaaja", "kotihoitopalvelut"]} | Point | 24.661524 | 60.149406 | ||||||||||||||||||||||||||||||||||||||||||||||
| 15669 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 4493 | 828201f3-df6c-42e5-8239-fac577c3b248 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Suomenojan kotihoito | Merikansantie 4 C | Sjöfolksvägen 4 C | Merikansantie 4 C | http://espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Senioripalvelut/Tukea_ja_apua_kotiin/Kotihoito | http://espoo.fi/sv-FI/Social_och_halsovard/Seniorer/Stod_och_hjalp_i_hemmet/Hemvard | http://espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Senioripalvelut/Tukea_ja_apua_kotiin/Kotihoito | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8164 5443 | 2015-11-03T12:03:45+02:00 | 02320 | www.espoo.fi | kaikki | espoo | 2020-10-15T12:01:10.415039+03:00 | [783, 986] | espoo | [829, 996] | [635] | {"fi": ["espoonlahden kotihoito", "kotihoito", "kotihoidon ohjaaja", "kotihoitopalvelut"]} | Point | 24.661507 | 60.14939 | ||||||||||||||||||||||||||||||||||||||||||||||
| 15673 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 4499 | 828201f3-df6c-42e5-8239-fac577c3b248 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Soukan kotihoito | Soukankaari 4 | Sökösvängen 4 | Soukankaari 4 | http://espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Senioripalvelut/Tukea_ja_apua_kotiin/Kotihoito | http://espoo.fi/sv-FI/Social_och_halsovard/Seniorer/Stod_och_hjalp_i_hemmet/Hemvard | http://espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Senioripalvelut/Tukea_ja_apua_kotiin/Kotihoito | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8164 4263 | 2015-11-03T12:03:45+02:00 | 02360 | www.espoo.fi | kaikki | espoo | 2020-10-15T13:31:00.599132+03:00 | [783, 986] | espoo | [829, 996] | [635] | {"fi": ["espoonlahden kotihoito", "kotihoito", "kotihoidon ohjaaja", "kotihoitopalvelut"]} | Point | 24.671043 | 60.140163 | ||||||||||||||||||||||||||||||||||||||||||||||
| 15713 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "outdoors", "variable": 2}, {"value": "3", "variable": 64}, {"value": "false", "variable": 23}, {"value": "true", "variable": 57}, {"value": "true", "variable": 106}, {"value": "1", "variable": 1}, {"value": "true", "variable": 105}, {"value": "true", "variable": 112}, {"value": "true", "variable": 6}, {"value": "false", "variable": 48}, {"value": "true", "variable": 59}, {"value": "under_20mm", "variable": 91}, {"value": "less_than_3600mm", "variable": 3}, {"value": "true", "variable": 74}, {"value": "false", "variable": 83}, {"value": "false", "variable": 103}, {"value": "true", "variable": 114}, {"value": "true", "variable": 73}, {"value": "under_10m", "variable": 4}, {"value": "false", "variable": 34}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 104}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 50}, {"value": "false", "variable": 44}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "false", "variable": 109}, {"value": "true", "variable": 70}, {"value": "true", "variable": 113}, {"value": "true", "variable": 76}, {"value": "false", "variable": 22}, {"value": "true", "variable": 117}, {"value": "false", "variable": 53}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 92}, {"value": "false", "variable": 49}, {"value": "true", "variable": 75}, {"value": "true", "variable": 37}, {"value": "false", "variable": 29}, {"value": "false", "variable": 62}, {"value": "false", "variable": 84}, {"value": "false", "variable": 79}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 21}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 118}, {"value": "true", "variable": 78}, {"value": "false", "variable": 98}, {"value": "false", "variable": 102}, {"value": "true", "variable": 20}, {"value": "false", "variable": 116}, {"value": "false", "variable": 38}, {"value": "true", "variable": 51}, {"value": "same_floor_as_entrance", "variable": 108}, {"valu… | internal | 4643 | 828201f3-df6c-42e5-8239-fac577c3b248 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Aurorakodin palveluasumisyksikkö | Kuninkaantie 41 A | Kungsvägen 41 A | Kuninkaantie 41 A | http://www.espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Mielenterveys_ja_paihdepalvelut/Mielenterveyspalvelut/Aurorakodin_palveluasumisyksikko(32857) | http://www.esbo.fi/sv-FI/Social_och_halsovard/Sjuk_och_halsovard/Mentalvard_och_missbruksvard/Mentalvard/Aurorahemmet_avdelning_1(34743) | http://www.espoo.fi/en-US/Social_and_health_services/Health_Services/Mental_health_and_substance_abuse_services/Mental_health_services/Aurorakoti_Sheltered_Accommodation(33664) | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8164 7510 | +358 9 8168 3354 | anne.hassi@espoo.fi | 2015-11-03T12:03:45+02:00 | 02070 | www.espoo.fi | kaikki | espoo | 2020-10-15T13:31:00.746248+03:00 | {"00": null, "11": "green", "12": "red", "13": "green", "21": "green", "22": "red", "23": "green", "31": "green", "32": "red", "33": "green", "41": "green", "51": "red", "52": "red", "61": "red"} | [986] | espoo | [1022] | [354] | {"fi": ["sairaanhoitaja", "aikuispsykiatrinen kuntoutus", "aistiharhat", "aurorakoti", "mielenterveysh\u00e4iri\u00f6t", "yksil\u00f6llinen hoito"]} | Point | 24.705849 | 60.236706 | 1 | 1 | 1 | 1 | 4 | ||||||||||||||||||||||||||||||||||||||
| 18956 | [{"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": "opens_easily_manually", "variable": 77}, {"value": "false", "variable": 33}, {"value": "true", "variable": 52}, {"value": "true", "variable": 105}, {"value": "true", "variable": 76}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 50}, {"value": "false", "variable": 22}, {"value": "true", "variable": 106}, {"value": "false", "variable": 78}, {"value": "false", "variable": 111}, {"value": "true", "variable": 116}, {"value": "false", "variable": 84}, {"value": "false", "variable": 98}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 5}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 37}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 107}, {"value": "true", "variable": 53}, {"value": "true", "variable": 115}, {"value": "2", "variable": 1}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 23}, {"value": "2", "variable": 63}, {"value": "true", "variable": 114}, {"value": "sufficiently_wide", "variable": 18}, {"value": "guided_and_clear", "variable": 19}, {"value": "true", "variable": 112}, {"value": "true", "variable": 57}, {"value": "true", "variable": 74}, {"value": "true", "variable": 104}, {"value": "false", "variable": 48}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 59}, {"value": "true", "variable": 73}, {"value": "false", "variable": 102}, {"value": "false", "variable": 83}, {"value": "true", "variable": 6}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 21}, {"value": "false", "variable": 34}, {"value": "false", "variable": 38}, {"value": "true", "variable": 70}, {"value": "true", "variable": 51}, {"value": "true", "variable": 75}, {"value": "false", "variable": 62}, {"value": "false", "variable": 103}, {"value": "true", "variable": 113}, {"value": "false", "variable": 72}, {"value": "at_least_3600mm", "variable": 3}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 1… | internal | 5444 | 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 | Martinlaakson koulun hammashoitola | Dental clinic at Martinlaakson koulu | Martinlaaksonpolku 4 | Mårtensdalsstigen 4 | Martinlaaksonpolku 4 | 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 839 5300 | etunimi.sukunimi@vantaa.fi | +358 9 8393 5300 | etunimi.sukunimi@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01620 | www.vantaa.fi | kaikki | vantaa | 2020-10-15T13:31:02.647858+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] | {"fi": ["hammashoitola"]} | Point | 24.844063 | 60.276505 | Martinlaaksonpolku 4, 01620 Vantaa | Tandkliniken vid Martinlaakson koulu | 1 | 1 | 1 | 1 | 1 | 3 | |||||||||||||||||||||||||||||||||
| 23363 | [{"section_type": "LINK", "name": {"fi": "Leikkipuiston kotisivut"}, "www": {"fi": "https://www.hel.fi/varhaiskasvatus/fi/leikkipuistotjaperhetalot/lehdokki/lehdokki"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 6928 | db5dbae8-93bb-4248-bfe6-e237b59eec12 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kahluuallas, Leikkipuisto Lehdokki | Wading pool, Playground Lehdokki | Kasöörinkatu 3 | Kassörsgatan 3 | Kasöörinkatu 3 | https://www.hel.fi/Helsinki/fi/paivahoito-ja-koulutus/leikki-ja-avoin-toiminta/leikkipuistot/ | https://www.hel.fi/Helsinki/sv/dagvard-och-utbildning/lek/lekparker/ | https://www.hel.fi/helsinki/en/childhood-and-education/play/playgrounds | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 22111 | 2012-05-08T14:11:18+03:00 | 00520 | www.hel.fi | kaikki | helsinki | 2020-10-15T13:31:10.075223+03:00 | [1400, 1403] | helsinki | [61, 492] | [238] | {} | Point | 24.946548 | 60.198387 | Plaskdamm, Lekparken Lehdokki | ||||||||||||||||||||||||||||||||||||||||||||
| 24067 | [{"section_type": "OPENING_HOURS", "name": {"fi": "COVID-19: Koulu- ja opiskeluterveydenhuollon keskitetyt puhelinpalvelut, kouluterveydenhuolto p. 09 8395 0025 ma-pe klo 8-15 ja opiskeluterveydenhuolto p. 09 8395 0035 ma-pe klo 8-15."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://asiointi.vantaa.fi/anna-palautetta"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 7014 | 4738c8e5-8bab-40c2-865d-5b28e64d7591 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Koulu- ja opiskeluterveydenhuolto / Martinlaakson koulu | School and student health care / Martinlaakson kou | Martinlaaksonpolku 4 | Mårtensdalsstigen 4 | Martinlaaksonpolku 4 | http://www.vantaa.fi/varhaiskasvatus_ja_koulutus/perusopetus/koululaisen_hyvinvointi_ja_terveys/kouluterveydenhuolto | http://www.vanda.fi/smabarnspedagogik_och_utbildning/grundlaggande_utbildning/valmaende_och_halsa/skolhalsovard | http://www.vantaa.fi/en/social_and_health_care_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 312 1589 | etunimi.sukunimi@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01620 | www.vantaa.fi | kaikki | vantaa | 2020-10-15T13:31:11.604771+03:00 | [986, 1087] | vantaa | [2164, 2165, 2166, 2167] | [863, 339] | {"fi": ["koulu- ja opiskeluterveydenhuollon palvelut"]} | Point | 24.844063 | 60.276505 | Martinlaaksonpolku 4, 01620 Vantaa | Skol- och studenthälsovård / Martinlaakson koulu | Koulu- ja opiskeluterveydenhuolto | |||||||||||||||||||||||||||||||||||||||||
| 25778 | [] | [] | internal | 7759 | d9c872de-54e9-4d76-8910-c8362612edfb | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | GOVERNMENT | 1 | Merisotakoulu | The Naval Academy of Finland | Suomenlinna | Sveaborg | Suomenlinna | https://merivoimat.fi/etusivu | https://merivoimat.fi/sv/framsida | https://merivoimat.fi/en/frontpage | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 29 9800 | merisotakoulu@mil.fi | 2012-01-18T15:01:39+02:00 | 00190 | www.hel.fi | kaikki | helsinki | 2020-10-15T12:01:23.014170+03:00 | [1061] | helsinki | [1064] | [529] | {} | Point | 24.979033 | 60.14954 | PL 5, 00191 Helsinki | Sjökrigsskolan | P.O. Box 5, 00191 Helsinki | PB 5, 00191 Helsinki | |||||||||||||||||||||||||||||||||||||||||||
| 25783 | [] | [] | internal | 7859 | d9c872de-54e9-4d76-8910-c8362612edfb | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | GOVERNMENT | 1 | Sotamuseo, sukellusvene Vesikko | Military Museum, submarine Vesikko | Susisaari | Vargön | Susisaari | https://sotamuseo.fi/etusivu | https://sotamuseo.fi/sv/framsida | https://sotamuseo.fi/en/frontpage | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 29 9800 | sotamuseo@mil.fi | 2012-01-18T15:27:48+02:00 | 00190 | www.hel.fi | kaikki | helsinki | 2020-10-15T12:01:23.028750+03:00 | [1061] | helsinki | [1064] | [529] | {} | Point | 24.989462 | 60.14221 | Krigsmuseet, ubåten Vesikko | ||||||||||||||||||||||||||||||||||||||||||||||
| 25834 | [] | [] | internal | 7736 | db5dbae8-93bb-4248-bfe6-e237b59eec12 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Leikkipaikka Herttoniemen aluepuisto | Siilitie 11 | Igelkottsvägen 11 | Siilitie 11 | https://www.hel.fi/Helsinki/fi/paivahoito-ja-koulutus/leikki-ja-avoin-toiminta/leikkipuistot/ | https://www.hel.fi/Helsinki/sv/dagvard-och-utbildning/lek/lekparker/ | https://www.hel.fi/helsinki/en/childhood-and-education/play/playgrounds/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 22111 | 2012-01-25T02:30:27+02:00 | 00800 | www.hel.fi | kaikki | helsinki | 2020-10-15T12:01:23.151247+03:00 | [1400, 1403] | helsinki | [70, 501] | [389] | {} | Point | 25.03967 | 60.211563 | ||||||||||||||||||||||||||||||||||||||||||||||
| 25981 | [] | [] | internal | 7587 | db5dbae8-93bb-4248-bfe6-e237b59eec12 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Leikkipaikka Myllykallio | Isokaari 3 | Storsvängen 3 | Isokaari 3 | https://www.hel.fi/Helsinki/fi/paivahoito-ja-koulutus/leikki-ja-avoin-toiminta/leikkipuistot/ | https://www.hel.fi/Helsinki/sv/dagvard-och-utbildning/lek/lekparker/ | https://www.hel.fi/helsinki/en/childhood-and-education/play/playgrounds/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 22111 | 2012-01-25T02:30:27+02:00 | 00200 | www.hel.fi | kaikki | helsinki | 2020-10-15T13:31:13.652947+03:00 | [1400, 1403] | helsinki | [70, 501] | [389] | {} | Point | 24.866232 | 60.157967 | ||||||||||||||||||||||||||||||||||||||||||||||
| 25982 | [] | [] | internal | 7588 | db5dbae8-93bb-4248-bfe6-e237b59eec12 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Leikkipaikka Myllykallio | Vuorenpeikontie 7 | Bergtrollsvägen 7 | Vuorenpeikontie 7 | https://www.hel.fi/Helsinki/fi/paivahoito-ja-koulutus/leikki-ja-avoin-toiminta/leikkipuistot/ | https://www.hel.fi/Helsinki/sv/dagvard-och-utbildning/lek/lekparker/ | https://www.hel.fi/helsinki/en/childhood-and-education/play/playgrounds/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 22111 | 2012-01-25T02:30:27+02:00 | 00820 | www.hel.fi | kaikki | helsinki | 2020-10-15T13:31:13.661605+03:00 | [1400, 1403] | helsinki | [70, 501] | [389] | {} | Point | 24.869823 | 60.15817 | ||||||||||||||||||||||||||||||||||||||||||||||
| 26067 | [] | [] | internal | 7849 | db5dbae8-93bb-4248-bfe6-e237b59eec12 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Leikkipaikka Topeliuksen puisto | Välskärinkatu 14 | Fältskärsgatan 14 | Välskärinkatu 14 | https://www.hel.fi/Helsinki/fi/paivahoito-ja-koulutus/leikki-ja-avoin-toiminta/leikkipuistot/ | https://www.hel.fi/Helsinki/sv/dagvard-och-utbildning/lek/lekparker/ | https://www.hel.fi/helsinki/en/childhood-and-education/play/playgrounds/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 22111 | 2012-01-25T02:30:27+02:00 | 00260 | www.hel.fi | kaikki | helsinki | 2020-10-15T13:31:14.129305+03:00 | [1400, 1403] | helsinki | [70, 501] | [389] | {} | Point | 24.920013 | 60.180916 | ||||||||||||||||||||||||||||||||||||||||||||||
| 26072 | [] | [] | internal | 7665 | db5dbae8-93bb-4248-bfe6-e237b59eec12 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Leikkipaikka Tähtitornin Vuori | Tähtitorninkatu 1 | Observatoriegatan 1 | Tähtitorninkatu 1 | https://www.hel.fi/Helsinki/fi/paivahoito-ja-koulutus/leikki-ja-avoin-toiminta/leikkipuistot/ | https://www.hel.fi/Helsinki/sv/dagvard-och-utbildning/lek/lekparker/ | https://www.hel.fi/helsinki/en/childhood-and-education/play/playgrounds/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 22111 | 2012-01-25T02:30:27+02:00 | 00130 | www.hel.fi | kaikki | helsinki | 2020-10-15T13:31:14.154675+03:00 | [1400, 1403] | helsinki | [70, 501] | [389] | {} | Point | 24.950321 | 60.161045 | ||||||||||||||||||||||||||||||||||||||||||||||
| 26086 | [] | [] | internal | 7817 | db5dbae8-93bb-4248-bfe6-e237b59eec12 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Leikkipaikka Veijarivuoren puisto | Itälahdenkatu 1 | Österviksgatan 1 | Itälahdenkatu 1 | https://www.hel.fi/Helsinki/fi/paivahoito-ja-koulutus/leikki-ja-avoin-toiminta/leikkipuistot/ | https://www.hel.fi/Helsinki/sv/dagvard-och-utbildning/lek/lekparker/ | https://www.hel.fi/helsinki/en/childhood-and-education/play/playgrounds/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 22111 | 2012-01-25T02:30:27+02:00 | 00210 | www.hel.fi | kaikki | helsinki | 2020-10-15T13:31:14.228056+03:00 | [1400, 1403] | helsinki | [70, 501] | [389] | {} | Point | 24.884954 | 60.14562 | ||||||||||||||||||||||||||||||||||||||||||||||
| 27421 | [] | [] | internal | 7998 | d9c872de-54e9-4d76-8910-c8362612edfb | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | service_by_municipally_owned_company | kunnan liikelaitoksen palvelu | tjänst från kommunalt affärsverk | service by municipally owned company | 1 | Keran asema | Kera train station | Kutojantie 17 | Vävarsvägen 17 | Kutojantie 17 | https://www.vr.fi/cs/vr/fi/etusivu | https://www.vr.fi/cs/vr/sv/etusivu_sv | https://www.vr.fi/cs/vr/sv/etusivu_sv | 1,99 € /vastattu puhelu + pvm | 1,99 € / mottaget samtal + lna | Price of call in Finland 1.99 € / answered call + local network charge | +358 600 419 00 | 2012-03-13T10:42:16+02:00 | 02630 | www.hel.fi | kaikki | espoo | 2020-10-15T13:31:14.729054+03:00 | [1402] | espoo | [520] | [576] | {} | Point | 24.753544 | 60.21606 | Kera järnvägsstation | ||||||||||||||||||||||||||||||||||||||||||||
| 32219 | [] | [] | internal | 15152 | 1cfe4ad7-4591-4db5-894b-05faacdfccf7 | b7bc3fba-8f3b-4239-b8ee-e46e1529692a | SELF_PRODUCED | state_service | valtion palvelu | statlig tjänst | state service | 1 | Lentotulli, matkustajat | Airport Customs / Passengers | Helsinki-Vantaan lentoasema | Helsinki-Vantaan lentoasema | Helsinki-Vantaan lentoasema | http://www.tulli.fi | http://www.tulli.fi | http://www.tulli.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 29 552 7041 | 2013-01-08T02:30:31+02:00 | 01530 | kaikki | vantaa | 2020-10-15T12:01:26.987190+03:00 | [1061] | vantaa | [1081] | [716] | {} | Point | 24.966434 | 60.318054 | Flygtullen, passagerare | |||||||||||||||||||||||||||||||||||||||||||||
| 33272 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://asiointi.vantaa.fi/anna-palautetta"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 14111 | 68e57d85-383c-4e36-b77c-dea7c92602d3 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Håkansbölen kartano | Kartanontie 1 | Herrgårdsvägen 1 | Kartanontie 1 | http://www.vantaa.fi/vapaa-aika/kulttuuri/vantaan_kaupunginmuseo/kulttuuriymparisto | http://www.vanda.fi/fritid/kultur/vanda_stadsmuseum | http://www.vantaa.fi/leisure/culture/vantaa_city_museum | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 839 11 | etunimi.sukunimi@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01200 | www.vantaa.fi | kaikki | vantaa | 2020-10-15T13:31:17.885606+03:00 | [1400, 1401, 1403] | vantaa | [151, 260, 507, 742, 363, 746] | [344, 326] | {} | Point | 25.11369 | 60.274376 | Kartanontie 1, 01200 Vantaa | Håkansböle gård | |||||||||||||||||||||||||||||||||||||||||||
| 33475 | [] | [] | internal | 15297 | db5dbae8-93bb-4248-bfe6-e237b59eec12 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Leikkipaikka Kaadepolku | Kaadepolku 14a | Sluttstigen 14a | Kaadepolku 14a | https://www.hel.fi/Helsinki/fi/paivahoito-ja-koulutus/leikki-ja-avoin-toiminta/leikkipuistot/ | https://www.hel.fi/Helsinki/sv/dagvard-och-utbildning/lek/lekparker/ | https://www.hel.fi/helsinki/en/childhood-and-education/play/playgrounds/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 22111 | 2013-11-20T14:54:37+02:00 | 00770 | www.hel.fi | kaikki | helsinki | 2020-10-15T13:31:18.383285+03:00 | [1400, 1403] | helsinki | [70, 501] | [389] | {} | Point | 25.070847 | 60.25419 | ||||||||||||||||||||||||||||||||||||||||||||||
| 33613 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 14871 | 828201f3-df6c-42e5-8239-fac577c3b248 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Auroranportin tukiasunnot | Aurorankuja 2 | Auroragränden 2 | Aurorankuja 2 | http://www.espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Mielenterveys_ja_paihdepalvelut/Mielenterveyspalvelut/Mielenterveyskuntoutujien_asumispalvelut(32856) | http://www.esbo.fi/sv-FI/Social_och_halsovard/Sjuk_och_halsovard/Mentalvard_och_missbruksvard/Mentalvard/Boendetjanster_for_rehabiliteringsklient(35035) | http://www.espoo.fi/en-US/Social_and_health_services/Health_Services/Mental_health_and_substance_abuse_services/Mental_health_services/Housing_services_for_mental_health_rehab(33662) | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8168 3973 | 2015-11-03T12:03:45+02:00 | 02940 | www.espoo.fi | kaikki | espoo | 2020-10-15T11:01:24.817890+03:00 | [783, 986] | espoo | [836, 1057] | [543] | {"fi": ["tukiasuminen", "tukivaihe", "palveluasuminen", "tukiasunnot", "asunnottomien palveluja"]} | Point | 24.704153 | 60.237194 | ||||||||||||||||||||||||||||||||||||||||||||||
| 35327 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "0", "variable": 1}, {"value": "true", "variable": 505}, {"value": "not_guided_but_clear", "variable": 504}, {"value": "neighbourhood_sport_site", "variable": 61}, {"value": "outdoor_sport_facility", "variable": 60}, {"value": "sufficiently_wide", "variable": 508}, {"value": "smooth", "variable": 507}, {"value": "between_50_100m", "variable": 503}, {"value": "gravel", "variable": 506}, {"value": "true", "variable": 509}, {"value": "outdoor_facility", "variable": 500}, {"value": "reachable_by_car", "variable": 501}, {"value": "false", "variable": 511}, {"value": "false", "variable": 510}, {"value": "false", "variable": 517}] | internal | 17481 | 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/Aitanurmenleikkipaikka_Palvelukartta.JPG | Aitanurmen leikkipaikka | Aitanurmi playground | Kärrynpyöräntie 3 | Kärrhjulsvägen 3 | Kärrynpyöräntie 3 | https://www.espoo.fi/fi-FI/Asuminen_ja_ymparisto/Asuminen/Asukastoiminta/Asukas_ja_leikkipuistot | https://www.esbo.fi/sv-FI/Boende_och_miljo/Boende/Invanarverksamhet/Lekparker | https://www.espoo.fi/en-US/Housing_and_environment | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8162 5100 | 2015-11-03T12:03:45+02:00 | 02940 | www.espoo.fi | kaikki | espoo | 2020-10-15T13:31:19.381273+03:00 | {"00": null, "11": "green", "12": "red", "13": "red", "21": "green", "22": "red", "23": "red", "31": "green", "32": "red", "33": "red", "41": "green", "51": "green", "52": "red"} | [1400, 1403] | espoo | [70, 501] | [389] | {"sv": ["lek", "barn", "fritid", "lekpark", "lekparken", "lekplats"], "fi": ["leikkipuisto", "lapset", "leikkipaikka", "leikki", "vapaa-aika"], "en": ["leisure time spending", "chidren", "children\u00bfs play park", "kids", "leisure time", "playground"]} | Point | 24.725105 | 60.249477 | Gärdeslindans lekplats | 2 | 2 | 2 | 1 | ||||||||||||||||||||||||||||||||||||||
| 35375 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "sufficiently_wide", "variable": 508}, {"value": "false", "variable": 510}, {"value": "more_than_200m", "variable": 503}, {"value": "true", "variable": 505}, {"value": "outdoor_facility", "variable": 500}, {"value": "false", "variable": 511}, {"value": "false", "variable": 517}, {"value": "0", "variable": 1}, {"value": "neighbourhood_sport_site", "variable": 61}, {"value": "smooth", "variable": 507}, {"value": "outdoor_sport_facility", "variable": 60}, {"value": "gravel", "variable": 506}, {"value": "reachable_by_car", "variable": 501}, {"value": "true", "variable": 509}, {"value": "not_guided_but_clear", "variable": 504}] | internal | 17195 | 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/Koukkuniemenpuistonleikkipaikka_palvelukartta.JPG | Koukkuniemenpuiston leikkipaikka | Koukkuniemenpuisto playground | Koukkupolku 4 | Krokstigen 4 | Koukkupolku 4 | https://www.espoo.fi/fi-FI/Asuminen_ja_ymparisto/Asuminen/Asukastoiminta/Asukas_ja_leikkipuistot | https://www.esbo.fi/sv-FI/Boende_och_miljo/Boende/Invanarverksamhet/Lekparker | https://www.espoo.fi/en-US/Housing_and_environment | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8162 5100 | 2015-11-03T12:03:45+02:00 | 02230 | www.espoo.fi | kaikki | espoo | 2020-10-15T13:31:19.671736+03:00 | {"00": null, "11": "green", "12": "red", "13": "red", "21": "green", "22": "red", "23": "red", "31": "green", "32": "red", "33": "red", "41": "green", "51": "green", "52": "red"} | [1400, 1403] | espoo | [70, 501] | [389] | {"sv": ["lek", "barn", "fritid", "lekpark", "lekparken", "lekplats"], "fi": ["leikkipuisto", "lapset", "leikkipaikka", "leikki", "vapaa-aika"], "en": ["leisure time spending", "chidren", "children\u00bfs play park", "kids", "leisure time", "playground"]} | Point | 24.761734 | 60.154697 | Krokuddsparkens lekplats | 2 | 2 | 2 | 1 | ||||||||||||||||||||||||||||||||||||||
| 35394 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 509}, {"value": "sufficiently_wide", "variable": 508}, {"value": "between_100_200m", "variable": 503}, {"value": "outdoor_facility", "variable": 500}, {"value": "reachable_by_car", "variable": 501}, {"value": "asphalt", "variable": 506}, {"value": "outdoor_sport_facility", "variable": 60}, {"value": "false", "variable": 517}, {"value": "not_guided_but_clear", "variable": 504}, {"value": "0", "variable": 1}, {"value": "neighbourhood_sport_site", "variable": 61}, {"value": "smooth", "variable": 507}, {"value": "true", "variable": 505}, {"value": "false", "variable": 511}, {"value": "false", "variable": 510}] | internal | 17521 | 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/Lansapuronpuiston_leikkipaikka_Palvelukarrta_2017.jpg | Lansapuronpuiston leikkipaikka | Lansapuronpuisto playground | Kilonpurontie 3 | Kilobäcksvägen 3 | Kilonpurontie 3 | https://www.espoo.fi/fi-FI/Asuminen_ja_ymparisto/Asuminen/Asukastoiminta/Asukas_ja_leikkipuistot | https://www.esbo.fi/sv-FI/Boende_och_miljo/Boende/Invanarverksamhet/Lekparker | https://www.espoo.fi/en-US/Housing_and_environment | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8162 5100 | 2015-11-03T12:03:45+02:00 | 02610 | www.espoo.fi | kaikki | espoo | 2020-10-15T12:01:29.848605+03:00 | {"00": null, "11": "green", "12": "red", "13": "red", "21": "green", "22": "red", "23": "red", "31": "green", "32": "red", "33": "red", "41": "green", "51": "green", "52": "red"} | [1400, 1403] | espoo | [70, 501] | [389] | {"sv": ["lek", "barn", "fritid", "lekpark", "lekparken", "lekplats"], "fi": ["leikkipuisto", "lapset", "leikkipaikka", "leikki", "vapaa-aika"], "en": ["leisure time spending", "chidren", "children\u00bfs play park", "kids", "leisure time", "playground"]} | Point | 24.782154 | 60.213715 | Lansabäcksparkens lekplats | 2 | 2 | 2 | 1 | ||||||||||||||||||||||||||||||||||||||
| 35417 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 52}, {"value": "false", "variable": 5}, {"value": "false", "variable": 98}, {"value": "false", "variable": 107}, {"value": "false", "variable": 104}, {"value": "true", "variable": 62}, {"value": "false", "variable": 44}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 92}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 21}, {"value": "false", "variable": 83}, {"value": "rough", "variable": 17}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 57}, {"value": "false", "variable": 105}, {"value": "false", "variable": 34}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 59}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "false", "variable": 48}, {"value": "false", "variable": 38}, {"value": "false", "variable": 29}, {"value": "true", "variable": 22}, {"value": "false", "variable": 84}, {"value": "true", "variable": 20}, {"value": "false", "variable": 23}, {"value": "false", "variable": 79}, {"value": "true", "variable": 50}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "0", "variable": 1}, {"value": "false", "variable": 33}, {"value": "true", "variable": 37}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 51}, {"value": "false", "variable": 102}, {"value": "false", "variable": 49}, {"value": "false", "variable": 103}] | internal | 17428 | 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/Mikkelänpellonleikkipaikkayhdistetty_palvelukartta.jpg | Mikkelänpellon leikkipaikka | Mikkelänpelto playground | Iso maantie 14 | Stora landsvägen 14 | Iso maantie 14 | https://www.espoo.fi/fi-FI/Asuminen_ja_ymparisto/Asuminen/Asukastoiminta/Asukas_ja_leikkipuistot | https://www.esbo.fi/sv-FI/Boende_och_miljo/Boende/Invanarverksamhet/Lekparker | https://www.espoo.fi/en-US/Housing_and_environment | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8162 5100 | 2015-11-03T12:03:45+02:00 | 02770 | www.espoo.fi | kaikki | espoo | 2020-10-15T13:31:19.966104+03: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"} | [1400, 1403] | espoo | [70, 501] | [389] | {"sv": ["lek", "barn", "fritid", "lekpark", "lekparken", "lekplats"], "fi": ["leikkipuisto", "lapset", "leikkipaikka", "leikki", "vapaa-aika"], "en": ["leisure time spending", "chidren", "children\u00bfs play park", "kids", "leisure time", "playground"]} | Point | 24.638472 | 60.203003 | Mickelsåkerns lekplats | 5 | 7 | 1 | 7 | 6 | |||||||||||||||||||||||||||||||||||||
| 35494 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "sufficiently_wide", "variable": 508}, {"value": "between_50_100m", "variable": 503}, {"value": "false", "variable": 510}, {"value": "true", "variable": 509}, {"value": "reachable_by_car", "variable": 501}, {"value": "gravel", "variable": 506}, {"value": "true", "variable": 505}, {"value": "false", "variable": 511}, {"value": "false", "variable": 517}, {"value": "outdoor_facility", "variable": 500}, {"value": "outdoor_sport_facility", "variable": 60}, {"value": "smooth", "variable": 507}, {"value": "neighbourhood_sport_site", "variable": 61}, {"value": "0", "variable": 1}, {"value": "not_guided_but_clear", "variable": 504}] | internal | 16940 | 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/Vanhamankkaanpuisto_leikkipaikka_Palvelukartta.JPG | Vanhan-Mankkaan puiston leikkipaikka | Vanhan Mankkaan puisto playground | Kokinkyläntie 8 A | Kockbyvägen 8 A | Kokinkyläntie 8 A | https://www.espoo.fi/fi-FI/Asuminen_ja_ymparisto/Asuminen/Asukastoiminta/Asukas_ja_leikkipuistot | https://www.esbo.fi/sv-FI/Boende_och_miljo/Boende/Invanarverksamhet/Lekparker | https://www.espoo.fi/en-US/Housing_and_environment | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8162 5100 | 2015-11-03T12:03:45+02:00 | 02180 | www.espoo.fi | kaikki | espoo | 2020-10-15T13:31:20.396550+03:00 | {"00": null, "11": "green", "12": "red", "13": "red", "21": "green", "22": "red", "23": "red", "31": "green", "32": "red", "33": "red", "41": "green", "51": "green", "52": "red"} | [1400, 1403] | espoo | [70, 501] | [389] | {"sv": ["lek", "barn", "fritid", "lekpark", "lekparken", "lekplats"], "fi": ["leikkipuisto", "lapset", "leikkipaikka", "leikki", "vapaa-aika"], "en": ["leisure time spending", "chidren", "children\u00bfs play park", "kids", "leisure time", "playground"]} | Point | 24.768171 | 60.191563 | Gamla Mankans parkens lekplats | 2 | 2 | 2 | 1 |
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 );