unit
12 rows where accessibility_shortcoming_count_rollator = 12
This data as json, CSV (advanced)
Suggested facets: department, accessibility_phone, accessibility_email, created_time, address_zip, data_source, extensions_maintenance_organization, accessibility_viewpoints, root_service_nodes, municipality, service_nodes, services, keywords, accessibility_shortcoming_count_reduced_mobility, accessibility_shortcoming_count_wheelchair, accessibility_shortcoming_count_stroller, 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 123 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodinjohtaja", "sv": "Daghemsf\u00f6rest\u00e5ndare", "en": "Manager of daycare centre"}, "www": null, "email": null, "phone": "+358 9 310 64132", "contact_person": "Ivakko Tiina"}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hakemus ruotsinkieliseen varhaiskasvatukseen", "sv": "Ans\u00f6kan om svenskspr\u00e5kig sm\u00e5barnspedagogik"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=4512", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=4512"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hakemus varhaiskasvatukseen tai esiopetukseen", "sv": "Ans\u00f6kan om sm\u00e5barnspedagogik eller f\u00f6rskoleundervisning", "en": "Application for early education or pre-primary education"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=506", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=506", "en": "https://www.hel.fi/helsinki/en/administration/administration/services/eservices?id=506"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "handrails_on_both_sides", "variable": 95}, {"value": "1_step", "variable": 24}, {"value": "false", "variable": 70}, {"value": "0", "variable": 1}, {"value": "false", "variable": 103}, {"value": "narrow", "variable": 18}, {"value": "true", "variable": 92}, {"value": "false", "variable": 62}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "true", "variable": 59}, {"value": "false", "variable": 44}, {"value": "false", "variable": 49}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 48}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 79}, {"value": "false", "variable": 98}, {"value": "false", "variable": 29}, {"value": "true", "variable": 113}, {"value": "false", "variable": 112}, {"value": "true", "variable": 114}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 116}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 5}, {"value": "guided_and_clear", "variable": 19}, {"value": "true", "variable": 51}, {"value": "true", "variable": 115}, {"value": "false", "variable": 118}, {"value": "false", "variable": 33}, {"value": "true", "variable": 107}, {"value": "true", "variable": 50}, {"value": "true", "variable": 20}, {"value": "true", "variable": 52}, {"value": "floor_1", "variable": 108}, {"value": "true", "variable": 37}, {"value": "true", "variable": 38}, {"value": "true", "variable": 105}, {"value": "false", "variable": 22}, {"value": "true", "variable": 23}, {"value": "false", "variable": 58}, {"value": "2", "variable": 64}, {"value": "rough", "variable": 17}, {"value": "1_step", "variable": 39}, {"value": "false", "variable": 21}, {"value": "true", "variable": 104}, {"value": "requires_use_of_buzzer_and_is_heavy", "variable": 54}, {"value": "floor_0", "variable": 119}, {"value": "true", "variable": 57}, {"value": "true", "variable": 117}, {"value": "false", "variable": 34}, {"value": "at_least_4_turning_steps", "variable": 93}, {"value": "true", "variable": 94}, {"value": "false", "varia… | internal | 608 | 05067af6-b1b7-47bf-a93d-56cacc9bf668 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | https://maps.google.fi/?q=http:%2F%2Fwww.hel.fi%2Fpalvelukartta%2Fkml.aspx%3Flang%3Dfi%26id%3D123&ll=60.167011,24.926734&spn=0.000011,0.013036&layer=c&cbll=60.16704,24.92649&cbp=12,185.38,,0,-3.56&t=h&z=17&panoid=6LAXzKxDkEx9aIgWjA9Tgg | Päiväkoti Lappi | Day care Lappi | Lapinlahdenkatu 6 G | Lappviksgatan 6 G | Lapinlahdenkatu 6 G | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/lappi | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/lappi | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/lappi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 64132 | pk.lappi@hel.fi | +358 9 310 64131 | tiina.ivakko@hel.fi | 2007-11-15T00:00:00+02:00 | 00180 | www.hel.fi | kaikki | helsinki | 2020-12-03T13:00:52.426072+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": null} | [1087, 1405] | helsinki | [879, 1090, 2125, 871, 870, 874] | [861, 861, 831, 663, 160, 160] | {"fi": ["kes\u00e4aukiolo - avoinna l\u00e4pi kes\u00e4n", "eskari", "varhaiskasvatus", "tarha", "lastentarha", "Esiopetus 2021-2022"], "en": ["day care", "preprimaryeducation", "pre-primary education", "preschool", "daycare"]} | Point | 24.926613 | 60.16692 | PL18912, 00099 Helsingin kaupunki | Päiväkoti Lappi | 5 | 12 | 2 | 12 | 6 | |||||||||||||||||||||||||||||||||
| 147 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodinjohtaja", "sv": "Daghemsf\u00f6rest\u00e5ndare", "en": "Manager of daycare centre"}, "www": null, "email": null, "phone": "+358 9 310 44622", "contact_person": "Andersen Satu"}, {"section_type": "LINK", "name": {"fi": "T\u00e4yt\u00e4 p\u00e4iv\u00e4hoitohakemus", "sv": "Ans\u00f6kan om barndagv\u00e5rd", "en": "Application for day care"}, "www": {"fi": "https://www.hel.fi/Helsinki/fi/paivahoito-ja-koulutus/paivahoito/paivakotihoito/hakeminen", "sv": "https://www.hel.fi/helsinki/sv/dagvard-och-utbildning/dagvord/ansokan/ansokan-dagvard", "en": "https://www.hel.fi/helsinki/en/day-care-education/day-care/options/applying"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hakemus ruotsinkieliseen varhaiskasvatukseen", "sv": "Ans\u00f6kan om svenskspr\u00e5kig sm\u00e5barnspedagogik"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=4512", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=4512"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hakemus varhaiskasvatukseen tai esiopetukseen", "sv": "Ans\u00f6kan om sm\u00e5barnspedagogik eller f\u00f6rskoleundervisning", "en": "Application for early education or pre-primary education"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=506", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=506", "en": "https://www.hel.fi/helsinki/en/administration/administration/services/eservices?id=506"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 48}, {"value": "true", "variable": 92}, {"value": "true", "variable": 52}, {"value": "true", "variable": 104}, {"value": "false", "variable": 34}, {"value": "at_least_4_turning_steps", "variable": 24}, {"value": "false", "variable": 59}, {"value": "false", "variable": 103}, {"value": "true", "variable": 57}, {"value": "false", "variable": 70}, {"value": "false", "variable": 29}, {"value": "2", "variable": 63}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "handrails_on_both_sides", "variable": 95}, {"value": "false", "variable": 50}, {"value": "false", "variable": 102}, {"value": "indoor_facility", "variable": 500}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 33}, {"value": "false", "variable": 79}, {"value": "false", "variable": 5}, {"value": "false", "variable": 62}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "true", "variable": 106}, {"value": "true", "variable": 40}, {"value": "sufficiently_wide", "variable": 18}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 23}, {"value": "false", "variable": 20}, {"value": "true", "variable": 53}, {"value": "false", "variable": 58}, {"value": "false", "variable": 49}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "0", "variable": 1}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 105}, {"value": "false", "variable": 107}, {"value": "at_least_4_turning_steps", "variable": 39}, {"value": "smooth", "variable": 17}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "false", "variable": 98}, {"value": "true", "variable": 25}, {"value": "false", "variable": 44}, {"value": "true", "variable": 38}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 22}, {"value": "false", "variable": 21}, {"value": "false", "variable": 37}, {"value": "true", "variable": 51}, {"value": "true", "variable": 94}, {"value": "at_least_4_turning_steps", "variable": 93}] | internal | 658 | 05067af6-b1b7-47bf-a93d-56cacc9bf668 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Päiväkoti Riikka | Day care Riikka | Runeberginkatu 63 | Runebergsgatan 63 | Runeberginkatu 63 | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/riikka | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/riikka | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/riikka | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 44622, +358 9 310 24623 | pk.riikka@hel.fi | 2007-11-15T00:00:00+02:00 | 00260 | www.hel.fi | kaikki | helsinki | 2020-12-03T13:00:52.627143+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": null} | [1087, 1405] | helsinki | [879, 1090, 2125, 871, 870] | [861, 861, 663, 160, 160] | {"fi": ["kes\u00e4aukiolo", "eskari", "varhaiskasvatus", "tarha", "lastentarha", "Esiopetus 2021-2022"], "en": ["day care", "preprimaryeducation", "pre-primary education", "preschool", "daycare"]} | Point | 24.925694 | 60.18065 | PL 26911, 00099 Helsingin kaupunki | Päiväkoti Riikka | 5 | 12 | 4 | P.O. Box 26911, 00099 City of Helsinki | 12 | PB 26911, 00099 Helsingfors stad | 6 | ||||||||||||||||||||||||||||||||||
| 269 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodinjohtaja", "sv": "Daghemsf\u00f6rest\u00e5ndare", "en": "Manager of daycare centre"}, "www": null, "email": null, "phone": "+358 9 310 73497", "contact_person": "Vesanen Maarit"}, {"section_type": "LINK", "name": {"fi": "T\u00e4yt\u00e4 p\u00e4iv\u00e4hoitohakemus", "sv": "Ans\u00f6kan om barndagv\u00e5rd", "en": "Application for day care"}, "www": {"fi": "https://www.hel.fi/Helsinki/fi/paivahoito-ja-koulutus/paivahoito/paivakotihoito/hakeminen", "sv": "https://www.hel.fi/helsinki/sv/dagvard-och-utbildning/dagvord/ansokan/ansokan-dagvard", "en": "https://www.hel.fi/helsinki/en/day-care-education/day-care/options/applying"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hakemus ruotsinkieliseen varhaiskasvatukseen", "sv": "Ans\u00f6kan om svenskspr\u00e5kig sm\u00e5barnspedagogik"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=4512", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=4512"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hakemus varhaiskasvatukseen tai esiopetukseen", "sv": "Ans\u00f6kan om sm\u00e5barnspedagogik eller f\u00f6rskoleundervisning", "en": "Application for early education or pre-primary education"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=506", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=506", "en": "https://www.hel.fi/helsinki/en/administration/administration/services/eservices?id=506"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 103}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 62}, {"value": "false", "variable": 51}, {"value": "narrow", "variable": 18}, {"value": "false", "variable": 49}, {"value": "false", "variable": 52}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 37}, {"value": "true", "variable": 57}, {"value": "false", "variable": 21}, {"value": "0", "variable": 1}, {"value": "true", "variable": 59}, {"value": "false", "variable": 29}, {"value": "false", "variable": 92}, {"value": "false", "variable": 50}, {"value": "false", "variable": 105}, {"value": "false", "variable": 33}, {"value": "false", "variable": 102}, {"value": "true", "variable": 20}, {"value": "false", "variable": 48}, {"value": "false", "variable": 98}, {"value": "true", "variable": 23}, {"value": "false", "variable": 79}, {"value": "true", "variable": 104}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "false", "variable": 107}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "soft", "variable": 17}, {"value": "false", "variable": 84}, {"value": "false", "variable": 5}, {"value": "false", "variable": 22}, {"value": "false", "variable": 58}, {"value": "1_step", "variable": 39}, {"value": "false", "variable": 44}, {"value": "indoor_facility", "variable": 500}, {"value": "1_step", "variable": 24}, {"value": "true", "variable": 38}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 34}, {"value": "false", "variable": 83}] | internal | 470 | 203f6084-59f4-4498-975a-3bc2d73d9012 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Päiväkoti Kumina | Day care Kumina | Pikkaraistie 7 | Kortmansvägen 7 | Pikkaraistie 7 | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/kumina | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/kumina | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/kumina | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 73497, +358 9 310 69564 | pk.kumina@hel.fi | +358 9 310 72958 | soili.issakainen@hel.fi | 2007-11-15T00:00:00+02:00 | 00750 | www.hel.fi | kaikki | helsinki | 2020-12-03T13:00:53.501129+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] | helsinki | [871, 870] | [663] | {"fi": ["kes\u00e4aukiolo", "eskari", "varhaiskasvatus", "tarha", "lastentarha"], "en": ["day care", "preprimaryeducation", "pre-primary education", "preschool", "daycare"]} | Point | 25.026985 | 60.279385 | PL 75993, 00099 Helsingin kaupunki | Päiväkoti Kumina | 5 | 12 | 3 | P.O. Box 75993, 00099 City of Helsinki | 1 | 12 | PB 75993, 00099 Helsingfors stad | 6 | |||||||||||||||||||||||||||||||
| 4541 | [{"section_type": "HIGHLIGHT", "name": {"fi": "Jos sinulla on koronavirustartunnan oireita ja tarvitset toimintaohjeet, soita Helsingin koronavirusneuvontaan p. 09\u202f310 10024 (p\u00e4ivitt\u00e4in klo 8-18). Koronavirusneuvonnasta voit varata ajan koronavirustestiin. Sinut ohjataan my\u00f6s tarvittaessa koronaterveysasemalle.\nJos asia ei voi odottaa koronaneuvonnan aukeamista tai kyse on muusta kiireellisest\u00e4 sairaudesta, soita P\u00e4ivystysapuun, p. 116\u202f117.", "sv": "Om du har symtom p\u00e5 coronavirus och beh\u00f6ver r\u00e5d om vad du ska g\u00f6ra, ring Helsingfors coronavirusr\u00e5dgivning p\u00e5 09 310 10024 (dagligen kl. 8-18). Via coronavirusr\u00e5dgivningen kan du boka tid f\u00f6r ett coronavirustest. Vid behov kan du ocks\u00e5 h\u00e4nvisas till en h\u00e4lsostation f\u00f6r coronapatienter.\nOm \u00e4rendet inte kan v\u00e4nta tills coronavirusr\u00e5dgivningen \u00f6ppnar eller om det \u00e4r fr\u00e5ga om n\u00e5gon annan akut sjukdom, betj\u00e4nar jourhj\u00e4lpen p\u00e5 tfn 116 117.", "en": "If you have symptoms indicative of a coronavirus infection and need instructions on what to do, call Helsinki's Coronavirus Helpline, open every day of the week from 8 am to 6 pm at tel. 09 310 10024. You can book an appointment for a coronavirus test via the helpline. If necessary, you will also be directed to a coronavirus health station.\nIf you cannot wait for the Coronavirus Helpline to open or need assistance with an urgent health concern, please contact the Medical Helpline at tel. 116 11"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [{"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 34}, {"value": "opens_easily_manually", "variable": 54}, {"value": "0", "variable": 1}, {"value": "false", "variable": 84}, {"value": "false", "variable": 49}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 33}, {"value": "over_20mm", "variable": 91}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "false", "variable": 98}, {"value": "false", "variable": 44}, {"value": "2", "variable": 63}, {"value": "false", "variable": 83}, {"value": "false", "variable": 58}, {"value": "false", "variable": 70}, {"value": "false", "variable": 107}, {"value": "false", "variable": 80}, {"value": "false", "variable": 79}, {"value": "at_least_4_steps", "variable": 24}, {"value": "at_least_4_steps", "variable": 39}, {"value": "false", "variable": 21}, {"value": "true", "variable": 92}, {"value": "false", "variable": 5}, {"value": "true", "variable": 104}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 103}, {"value": "false", "variable": 51}, {"value": "rough", "variable": 17}, {"value": "true", "variable": 52}, {"value": "at_least_4_turning_steps", "variable": 93}, {"value": "false", "variable": 40}, {"value": "false", "variable": 29}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "false", "variable": 53}, {"value": "false", "variable": 62}, {"value": "true", "variable": 57}, {"value": "false", "variable": 20}, {"value": "false", "variable": 94}, {"value": "false", "variable": 22}, {"value": "false", "variable": 59}, {"value": "true", "variable": 38}, {"value": "true", "variable": 23}, {"value": "false", "variable": 37}, {"value": "false", "variable": 105}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 50}, {"value": "false", "variable": 25}, {"value": "false", "variable": 102}, {"value": "no_handrails", "variable": 41}, {"value": "indoor_faci… | internal | 1987 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Paloheinä 1 lähipalvelualue | Paloheinä 1 home care unit | Välitalontie 71 | Mellangårdsvägen 71 | Välitalontie 71 | https://www.hel.fi/sote/toimipisteet-fi/aakkosittain/pohjoinen-kotihoitoyksikko | https://www.hel.fi/helsinki/sv/social-och-halso/aldre/hem/kontaktuppgifter/norra | https://www.hel.fi/sote/toimipisteet-fi/aakkosittain/pohjoinen-kotihoitoyksikko | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 69587 | +358 9 310 69191 | +358 40 334 6811 | 2008-07-10T22:13:17+03:00 | 00660 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:03.090126+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"} | [783, 986] | helsinki | [829, 996] | [635] | {} | Point | 24.92611 | 60.24608 | PL 6725, 00099 Helsingin kaupunki | Svedängen 1 närserviceområde | 10 | 12 | 3 | P.O. Box 6725, 00099 City of Helsinki | 1 | 12 | PB 6725, 00099 Helsingfors stad | 15 | ||||||||||||||||||||||||||||||||
| 5015 | [{"section_type": "HIGHLIGHT", "name": {"fi": "Jos sinulla on koronavirustartunnan oireita ja tarvitset toimintaohjeet, soita Helsingin koronavirusneuvontaan p. 09\u202f310 10024 (p\u00e4ivitt\u00e4in klo 8-18). Koronavirusneuvonnasta voit varata ajan koronavirustestiin. Sinut ohjataan my\u00f6s tarvittaessa koronaterveysasemalle.\nJos asia ei voi odottaa koronaneuvonnan aukeamista tai kyse on muusta kiireellisest\u00e4 sairaudesta, soita P\u00e4ivystysapuun, p. 116\u202f117.", "sv": "Om du har symtom p\u00e5 coronavirus och beh\u00f6ver r\u00e5d om vad du ska g\u00f6ra, ring Helsingfors coronavirusr\u00e5dgivning p\u00e5 09 310 10024 (dagligen kl. 8-18). Via coronavirusr\u00e5dgivningen kan du boka tid f\u00f6r ett coronavirustest. Vid behov kan du ocks\u00e5 h\u00e4nvisas till en h\u00e4lsostation f\u00f6r coronapatienter.\nOm \u00e4rendet inte kan v\u00e4nta tills coronavirusr\u00e5dgivningen \u00f6ppnar eller om det \u00e4r fr\u00e5ga om n\u00e5gon annan akut sjukdom, betj\u00e4nar jourhj\u00e4lpen p\u00e5 tfn 116 117.", "en": "If you have symptoms indicative of a coronavirus infection and need instructions on what to do, call Helsinki's Coronavirus Helpline, open every day of the week from 8 am to 6 pm at tel. 09 310 10024. You can book an appointment for a coronavirus test via the helpline. If necessary, you will also be directed to a coronavirus health station.\nIf you cannot wait for the Coronavirus Helpline to open or need assistance with an urgent health concern, please contact the Medical Helpline at tel. 116 11"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hammashoidon asiointipalvelu", "sv": "Tandv\u00e5rdens e-tj\u00e4nster", "en": "Dental care e-service"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=562", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=562", "en": "https://www.hel.fi/helsinki/en/administration/administra… | [{"value": "true", "variable": 25}, {"value": "false", "variable": 79}, {"value": "false", "variable": 105}, {"value": "false", "variable": 22}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 59}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 70}, {"value": "true", "variable": 38}, {"value": "false", "variable": 21}, {"value": "true", "variable": 37}, {"value": "false", "variable": 103}, {"value": "false", "variable": 52}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "false", "variable": 49}, {"value": "2_consecutive_steps", "variable": 24}, {"value": "true", "variable": 20}, {"value": "true", "variable": 5}, {"value": "false", "variable": 48}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 62}, {"value": "false", "variable": 80}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 102}, {"value": "false", "variable": 98}, {"value": "false", "variable": 107}, {"value": "narrow", "variable": 18}, {"value": "false", "variable": 50}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "true", "variable": 94}, {"value": "true", "variable": 51}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 104}, {"value": "rough", "variable": 17}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 83}, {"value": "at_least_4_steps", "variable": 93}, {"value": "true", "variable": 40}, {"value": "false", "variable": 57}, {"value": "no_handrails", "variable": 41}, {"value": "false", "variable": 34}, {"value": "false", "variable": 33}, {"value": "true", "variable": 23}, {"value": "guided_and_clear", "variable": 19}, {"value": "true", "variable": 92}, {"value": "false", "variable": 44}, {"value": "0", "variable": 1}, {"value": "false", "variable": 82}, {"value": "true", "variable": 6}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 29}, {"value": "2", … | internal | 2060 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Porolahden hammashoitola | Porolahti Dental Clinic | Roihuvuorentie 2 | Kasbergsvägen 2 | Roihuvuorentie 2 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 51400 | +358 9 310 55517 | +358 9 310 61450 | 2008-07-10T22:13:17+03:00 | 00820 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:03.964610+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"} | [986] | helsinki | [995] | [184] | {} | Point | 25.051582 | 60.194855 | PL 6340, 00099 Helsingin kaupunki | Porovikens tandklinik | 7 | 12 | 3 | P.O. Box 6340, 00099 City of Helsinki | 1 | 12 | PB 6340, 00099 Helsingfors stad | 7 | |||||||||||||||||||||||||||||||||||
| 6742 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Kuraattori", "sv": "Kuraattori", "en": "Kuraattori"}, "www": null, "email": null, "phone": "+358 50 501 5221", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Psykologi", "sv": "Psykologi", "en": "Psykologi"}, "www": null, "email": null, "phone": "+358 50 401 3366", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Koulujen tilojen ilta- ja vapaa-ajank\u00e4yt\u00f6n neuvonta ja varaukset: liikuntasalit 09 310 87800, muut tilat 09 310 12001"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Tarjolla sali", "sv": "Tillg\u00e4nglig: sal", "en": "Available: hall"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Tilanvaraus", "sv": "Lokalbokning", "en": "Reservation of premises"}, "www": {"fi": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/fi/palvelut/tilojen-varaaminen/koulutilojen-kaytto", "sv": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/sv/tjanster/anvandning-skollokaler", "en": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/en/services/renting-facilities/school-facilities"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hakemus varhaiskasvatukseen tai esiopetukseen", "sv": "Ans\u00f6kan om sm\u00e5barnspedagogik eller f\u00f6rskoleundervisning", "en": "Application for early education or pre-primary education"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=506", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=506", "en": "https://www.hel.fi/helsinki/en/administration/administration/services/eservices?id=506"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 21}, {"value": "false", "variable": 90}, {"value": "false", "variable": 97}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 104}, {"value": "false", "variable": 44}, {"value": "false", "variable": 70}, {"value": "false", "variable": 107}, {"value": "false", "variable": 103}, {"value": "over_20mm", "variable": 56}, {"value": "handrails_on_both_sides", "variable": 95}, {"value": "false", "variable": 51}, {"value": "false", "variable": 102}, {"value": "true", "variable": 40}, {"value": "spiral_staircase", "variable": 93}, {"value": "false", "variable": 5}, {"value": "true", "variable": 92}, {"value": "true", "variable": 52}, {"value": "3_consecutive_steps", "variable": 24}, {"value": "false", "variable": 88}, {"value": "false", "variable": 28}, {"value": "false", "variable": 58}, {"value": "false", "variable": 87}, {"value": "false", "variable": 79}, {"value": "long_term_stay", "variable": 60}, {"value": "3_consecutive_steps", "variable": 39}, {"value": "no_handrails", "variable": 41}, {"value": "false", "variable": 105}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 85}, {"value": "false", "variable": 62}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 38}, {"value": "false", "variable": 50}, {"value": "false", "variable": 22}, {"value": "indoor_facility", "variable": 500}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 48}, {"value": "true", "variable": 25}, {"value": "true", "variable": 59}, {"value": "true", "variable": 37}, {"value": "false", "variable": 34}, {"value": "false", "variable": 49}, {"value": "true", "variable": 94}, {"value": "true", "variable": 20}, {"value": "true", "variable": 57}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 86}, {"value": "true", "variable": 96}, {"value": "true", "variable": 23}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 43}, {"value": "false", "variabl… | internal | 16090 | cfe981a5-3493-4432-b3b1-7945dc2c7fa3 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Pakilan ala-asteen koulu | Pakila Comprehensive School, Lower Stage | Paloheinäntie 40 B | Svedängsvägen 40 B | Paloheinäntie 40 B | http://www.pakia.edu.hel.fi | http://www.pakia.edu.hel.fi | http://www.pakia.edu.hel.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 82428 | +358 50 401 3968 | pakilan.ala-aste@hel.fi | 2015-11-27T12:11:49+02:00 | 00670 | www.hel.fi | kaikki | helsinki | 2020-12-03T13:00:57.884022+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": "green"} | [1087, 1402] | helsinki | [1123, 1134, 1142, 1146, 1100, 331] | [806, 661, 108, 35, 34, 15] | {"fi": ["sali", "tilanvaraus", "tilavaraus", "koulu", "peruskoulu", "peruskoulut"], "sv": ["lokalbokning"], "en": ["reservation of premises", "basiceducation", "basic education"]} | Point | 24.936245 | 60.249226 | PL 66301, 00099 Helsingin kaupunki | Lågstadieskolan Pakilan ala-asteen koulu | 8 | 12 | 4 | P.O. Box 66301, 00099 City of Helsinki | 12 | PB 66301, 00099 Helsingfors stad | 13 | |||||||||||||||||||||||||||||||||
| 7073 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Kuraattori", "sv": "Kuraattori", "en": "Kuraattori"}, "www": null, "email": null, "phone": "+358 50 401 3286", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Psykologi", "sv": "Psykologi", "en": "Psykologi"}, "www": null, "email": null, "phone": "+358 50 512 5097", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Koulujen tilojen ilta- ja vapaa-ajank\u00e4yt\u00f6n neuvonta ja varaukset: liikuntasalit 09 310 87800, muut tilat 09 310 12001"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Tarjolla sali", "sv": "Tillg\u00e4nglig: sal", "en": "Available: hall"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Tilanvaraus", "sv": "Lokalbokning", "en": "Reservation of premises"}, "www": {"fi": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/fi/palvelut/tilojen-varaaminen/koulutilojen-kaytto", "sv": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/sv/tjanster/anvandning-skollokaler", "en": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/en/services/renting-facilities/school-facilities"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hakemus varhaiskasvatukseen tai esiopetukseen", "sv": "Ans\u00f6kan om sm\u00e5barnspedagogik eller f\u00f6rskoleundervisning", "en": "Application for early education or pre-primary education"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=506", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=506", "en": "https://www.hel.fi/helsinki/en/administration/administration/services/eservices?id=506"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 87}, {"value": "false", "variable": 86}, {"value": "false", "variable": 107}, {"value": "0", "variable": 1}, {"value": "true", "variable": 51}, {"value": "false", "variable": 23}, {"value": "1_step", "variable": 39}, {"value": "3", "variable": 64}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 57}, {"value": "false", "variable": 5}, {"value": "true", "variable": 20}, {"value": "false", "variable": 48}, {"value": "true", "variable": 92}, {"value": "false", "variable": 88}, {"value": "false", "variable": 102}, {"value": "false", "variable": 70}, {"value": "false", "variable": 21}, {"value": "false", "variable": 104}, {"value": "at_least_4_steps", "variable": 93}, {"value": "false", "variable": 103}, {"value": "handrails_on_both_sides", "variable": 95}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 79}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 58}, {"value": "false", "variable": 105}, {"value": "true", "variable": 89}, {"value": "false", "variable": 85}, {"value": "false", "variable": 98}, {"value": "true", "variable": 84}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 50}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 29}, {"value": "false", "variable": 33}, {"value": "false", "variable": 49}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 62}, {"value": "true", "variable": 38}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 22}, {"value": "true", "variable": 52}, {"value": "true", "variable": 37}, {"value": "sufficiently_wide", "variable": 18}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 34}, {"value": "false", "variable": 44}, {"value": "false", "variable": 53}, {"value": "true", "variable": 83}, {"value": "true", "variable": 94}, {"value": "true", "variable": 90}, {"value": "true", "variable": 59}] | internal | 16339 | 5431c750-9d5d-4b46-9655-5fa6c83f56aa | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hietakummun ala-asteen koulu | Hietakumpu Comprehensive School, Lower Stage | Hietakummuntie 1 | Sandkullavägen 1 | Hietakummuntie 1 | http://www.hietaaa.edu.hel.fi | http://www.hietaaa.edu.hel.fi | http://www.hietaaa.edu.hel.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 82807 | 2015-11-27T12:11:49+02:00 | 00700 | www.hel.fi | kaikki | helsinki | 2020-12-03T13:00:58.612552+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": "green"} | [1087, 1402] | helsinki | [1123, 1124, 1135, 1136, 1142, 1143, 1147, 1146, 1100, 331] | [806, 661, 108, 101, 37, 35, 28, 27, 16, 15] | {"fi": ["sali", "tilanvaraus", "tilavaraus", "koulu", "peruskoulu", "peruskoulut"], "sv": ["lokalbokning"], "en": ["reservation of premises", "basiceducation", "basic education"]} | Point | 25.016394 | 60.24671 | PL 70301, 00099 Helsingin kaupunki | Lågstadieskolan Hietakummun ala-asteen koulu | 6 | 12 | 2 | P.O. Box 70301, 00099 City of Helsinki | 12 | PB 70301, 00099 Helsingfors stad | 7 | |||||||||||||||||||||||||||||||||||
| 7980 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Aukioloajat"}, "www": {"fi": "http://herttoniemenranta.munstadi.fi/tietoa-meista/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": "false", "variable": 105}, {"value": "at_least_4_turning_steps", "variable": 93}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 102}, {"value": "false", "variable": 79}, {"value": "true", "variable": 92}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 34}, {"value": "false", "variable": 23}, {"value": "0", "variable": 1}, {"value": "true", "variable": 37}, {"value": "false", "variable": 21}, {"value": "true", "variable": 62}, {"value": "false", "variable": 53}, {"value": "false", "variable": 112}, {"value": "false", "variable": 111}, {"value": "false", "variable": 48}, {"value": "false", "variable": 104}, {"value": "false", "variable": 33}, {"value": "false", "variable": 98}, {"value": "true", "variable": 22}, {"value": "false", "variable": 114}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 38}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 58}, {"value": "true", "variable": 109}, {"value": "false", "variable": 44}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 113}, {"value": "true", "variable": 52}, {"value": "true", "variable": 20}, {"value": "false", "variable": 116}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 83}, {"value": "false", "variable": 96}, {"value": "false", "variable": 117}, {"value": "true", "variable": 59}, {"value": "over_20mm", "variable": 56}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 5}, {"value": "false", "variable": 29}, {"value": "true", "variable": 51}, {"value": "false", "variable": 49}, {"value": "true", "variable": 107}, {"value": "indoor_facility", "variable": 500}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "next_to_door_on_opening_side", "variable": 110}, {"value": "false", "variable": 97}, {"value": "false", "variable": 50}, {"value": "true", "variable": 57}, {"v… | internal | 3029 | cfe4d81b-7366-4ae2-b87b-b986e10cd220 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Herttoniemenrannan nuorisotalo | Herttoniemenranta Youth Centre | Paasivaarankatu 6 | Paasivaaragatan 6 | Paasivaarankatu 6 | http://herttoniemenranta.munstadi.fi/ | http://herttoniemenranta.munstadi.fi/ | http://herttoniemenranta.munstadi.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 757 0384 | herttoniemenrannan.nuorisotalo@hel.fi | +358 9 757 0384 | herttoniemenrannan.nuorisotalo@hnk.fi | 2008-09-09T20:14:31+03:00 | 00810 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:01.832172+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 | [375, 399, 367, 366] | [468, 254, 231, 85] | {} | Point | 25.028568 | 60.190857 | PL 80403, 00099 Helsingin kaupunki | Hertonäs strands ungdomsgård | 4 | 12 | 2 | P.O. Box 80403, 00099 City of Helsinki | 1 | 12 | PB 80403, 00099 Helsingfors stad | 8 | |||||||||||||||||||||||||||||||
| 14442 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodinjohtaja", "sv": "Daghemsf\u00f6rest\u00e5ndare", "en": "Manager of daycare centre"}, "www": null, "email": "sirpa.mikkola@hel.fi", "phone": "+358 9 310 73711", "contact_person": "Sirpa Mikkola"}, {"section_type": "LINK", "name": {"fi": "T\u00e4yt\u00e4 p\u00e4iv\u00e4hoitohakemus", "sv": "Ans\u00f6kan om barndagv\u00e5rd", "en": "Application for day care"}, "www": {"fi": "https://www.hel.fi/Helsinki/fi/paivahoito-ja-koulutus/paivahoito/paivakotihoito/hakeminen", "sv": "https://www.hel.fi/helsinki/sv/dagvard-och-utbildning/dagvord/ansokan/ansokan-dagvard", "en": "https://www.hel.fi/helsinki/en/day-care-education/day-care/options/applying"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hakemus ruotsinkieliseen varhaiskasvatukseen", "sv": "Ans\u00f6kan om svenskspr\u00e5kig sm\u00e5barnspedagogik"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=4512", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=4512"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hakemus varhaiskasvatukseen tai esiopetukseen", "sv": "Ans\u00f6kan om sm\u00e5barnspedagogik eller f\u00f6rskoleundervisning", "en": "Application for early education or pre-primary education"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=506", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=506", "en": "https://www.hel.fi/helsinki/en/administration/administration/services/eservices?id=506"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 103}, {"value": "true", "variable": 37}, {"value": "false", "variable": 83}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 53}, {"value": "true", "variable": 52}, {"value": "0", "variable": 1}, {"value": "false", "variable": 33}, {"value": "false", "variable": 29}, {"value": "false", "variable": 79}, {"value": "true", "variable": 20}, {"value": "false", "variable": 49}, {"value": "indoor_facility", "variable": 500}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "true", "variable": 51}, {"value": "true", "variable": 57}, {"value": "false", "variable": 62}, {"value": "false", "variable": 98}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 50}, {"value": "1_step", "variable": 39}, {"value": "false", "variable": 59}, {"value": "false", "variable": 105}, {"value": "true", "variable": 38}, {"value": "false", "variable": 21}, {"value": "false", "variable": 48}, {"value": "at_least_4_steps", "variable": 93}, {"value": "false", "variable": 22}, {"value": "handrails_on_both_sides", "variable": 95}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 102}, {"value": "false", "variable": 84}, {"value": "false", "variable": 97}, {"value": "true", "variable": 94}, {"value": "true", "variable": 23}, {"value": "false", "variable": 34}, {"value": "false", "variable": 104}, {"value": "false", "variable": 70}, {"value": "1", "variable": 63}, {"value": "false", "variable": 44}, {"value": "1_step", "variable": 24}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 58}, {"value": "false", "variable": 107}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 92}, {"value": "false", "variable": 96}, {"value": "false", "variable": 5}, {"value": "over_20mm", "variable": 91}] | internal | 4372 | 203f6084-59f4-4498-975a-3bc2d73d9012 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | https://maps.google.fi/?q=http:%2F%2Fwww.hel.fi%2Fpalvelukartta%2Fkml.aspx%3Flang%3Dfi%26id%3D14442&ll=60.276015,25.032434&spn=0.000011,0.013036&layer=c&cbll=60.276081,25.03184&cbp=12,195.62,,0,-7.81&t=h&z=17&panoid=YgnSmlW5W6N3G5CqLWPWfw | Päiväkoti Neilikka | Day care Neilikka | Palokuja 4, 2. krs | Brandgränden 4, 2. vån. | Palokuja 4, 2. floor | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/neilikka | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/neilikka | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/neilikka | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 73711, +358 9 310 69582 | pk.neilikka@hel.fi | +358 9 310 72958 | soili.issakainen@hel.fi | 2010-02-16T16:54:35+02:00 | 00750 | www.hel.fi | kaikki | helsinki | 2020-12-03T13:01:03.118877+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, 1405] | helsinki | [879, 1090, 2125, 871, 870] | [861, 861, 663, 160, 160] | {"fi": ["kes\u00e4aukiolo", "eskari", "varhaiskasvatus", "tarha", "lastentarha", "Esiopetus 2021-2022"], "en": ["day care", "preprimaryeducation", "pre-primary education", "preschool", "daycare"]} | Point | 25.031487 | 60.27551 | PL 75996, 00099 Helsingin kaupunki | Päiväkoti Neilikka | 5 | 12 | 2 | P.O. Box 75996, 00099 City of Helsinki | 1 | 12 | PB 75996, 00099 Helsingfors stad | 9 | ||||||||||||||||||||||||||||||
| 15372 | [{"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": 92}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 44}, {"value": "false", "variable": 97}, {"value": "true", "variable": 42}, {"value": "true", "variable": 27}, {"value": "false", "variable": 28}, {"value": "false", "variable": 84}, {"value": "true", "variable": 104}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 83}, {"value": "at_least_4_steps", "variable": 93}, {"value": "false", "variable": 43}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "true", "variable": 23}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 6}, {"value": "3", "variable": 64}, {"value": "false", "variable": 49}, {"value": "true", "variable": 96}, {"value": "false", "variable": 20}, {"value": "false", "variable": 29}, {"value": "false", "variable": 48}, {"value": "false", "variable": 98}, {"value": "false", "variable": 21}, {"value": "true", "variable": 94}, {"value": "false", "variable": 107}, {"value": "false", "variable": 34}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 57}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "false", "variable": 102}, {"value": "true", "variable": 59}, {"value": "true", "variable": 105}, {"value": "false", "variable": 50}, {"value": "false", "variable": 58}, {"value": "true", "variable": 5}, {"value": "at_least_4_steps", "variable": 24}, {"value": "0", "variable": 1}, {"value": "over_20mm", "variable": 56}, {"value": "handrails_on_both_sides", "variable": 95}, {"value": "false", "variable": 103}, {"value": "false", "variable": 106}, {"value": "true", "variable": 38}, {"value": "false", "variable": 70}, {"value": "false", "variable": 62}, {"value": "true", "variable": 40}, {"value": "false", "variable": 79}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 52}, {"value": "true", "variable": 37}, {"value": "indoor_facility", "variable": 500}, {"value": "rough", "variable": 17}… | internal | 4423 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Pakankylän koulu on iloinen ja turvallinen koulu, jossa lapsi saa perustiedot ja taidot elämäänsä varten omista tarpeistaan lähtien. Erityisen tärkeinä taitoina pidämme toisen kunnioittamista ja kannustamista sekä erilaisuuden hyväksymistä.Yhdessä tekemällä luomme yhteenkuuluvuuden ja yhteisöllisyyden tunteen kaikkien kouluyhteisöön kuuluvien välille. Ympäristöystävällisyys on koulumme arkea.Koulussamme on noin 107 oppilasta eskareista kuudesluokkalaisiin. | Pakankylän koulu | Snettansintie 9 | Snettansvägen 9 | Snettansintie 9 | http://espoo.fi/fi-FI/Kasvatus_ja_opetus/Perusopetus/Peruskoulut/Alakoulut/Pakankylan_koulu | http://espoo.fi/fi-FI/Kasvatus_ja_opetus/Perusopetus/Peruskoulut/Alakoulut/Pakankylan_koulu | http://www.espoo.fi/en-US/Childcare_and_education/Comprehensive_education | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 43 825 3753 | +358 9 8164 0417 | matti.jokela@espoo.fi | 2015-11-03T12:03:45+02:00 | 02740 | www.espoo.fi | kaikki | espoo | 2020-03-13T09:31:04.966733+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] | espoo | [1123, 1134, 1146, 1100] | [661, 108, 34, 15] | {"fi": ["ala-aste", "koulu"]} | Point | 24.677307 | 60.283375 | PL 74302, 02070 ESPOON KAUPUNKI | Pakankylän koulu on iloinen ja turvallinen koulu, jossa lapsi saa perustiedot ja taidot elämäänsä varten omista tarpeistaan lähtien. | 5 | 12 | 4 | P.O. Box 74302, 02070 ESPOO CITY | 1 | 12 | PB 74302, 02070 ESBO STAD | 7 | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 20048 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Harrastushaku.fi"}, "www": {"fi": "http://www.espoo.fi/fi-FI/Kulttuuri_ja_liikunta/Liikunta/Ohjattu_liikunta/Lapset_nuoret_perheet"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Nuorisoj\u00e4rjest\u00f6t ja avustukset", "sv": "Ungdomsf\u00f6reningar och underst\u00f6d"}, "www": {"fi": "https://www.espoo.fi/fi-FI/Nuoret/Yhteystiedot(756)", "sv": "https://www.esbo.fi/sv-FI/Unga/Kontaktuppgifter(7942)"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 38}, {"value": "false", "variable": 48}, {"value": "2", "variable": 64}, {"value": "true", "variable": 23}, {"value": "1_step", "variable": 39}, {"value": "true", "variable": 52}, {"value": "0", "variable": 1}, {"value": "true", "variable": 57}, {"value": "true", "variable": 6}, {"value": "false", "variable": 105}, {"value": "false", "variable": 79}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 22}, {"value": "false", "variable": 62}, {"value": "true", "variable": 37}, {"value": "true", "variable": 51}, {"value": "false", "variable": 49}, {"value": "false", "variable": 107}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "handrails_on_both_sides", "variable": 95}, {"value": "false", "variable": 98}, {"value": "false", "variable": 70}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 5}, {"value": "true", "variable": 59}, {"value": "false", "variable": 103}, {"value": "true", "variable": 20}, {"value": "1_step", "variable": 24}, {"value": "false", "variable": 84}, {"value": "false", "variable": 102}, {"value": "true", "variable": 104}, {"value": "false", "variable": 21}, {"value": "true", "variable": 92}, {"value": "false", "variable": 83}, {"value": "false", "variable": 29}, {"value": "false", "variable": 44}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "over_20mm", "variable": 56}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 96}, {"value": "false", "variable": 50}, {"value": "soft", "variable": 17}, {"value": "true", "variable": 94}, {"value": "false", "variable": 58}, {"value": "false", "variable": 34}, {"value": "false", "variable": 33}, {"value": "true", "variable": 53}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 97}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "at_least_4_steps", "variable": 93}] | internal | 5650 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Toimintaa pyöritetään yhdessä vapaaehtoisten kanssa, pääsääntöisesti perjantai- ja lauantai-iltaisin. Jos olet kiinnostunut vapaaehtoisena toimimisesta, ota yhteyttä Mankkaan nuorisonohjaajaan.Mankkaan Makasiini tarjoaa myös toimivat puitteet yhdistysten käyttöön kokouksia tai tilaisuuksia varten. Vuokraamme tiloja myös asukastoimintaan. | Mankkaan makasiini / nuorisotila | Vanhan-Mankkaan kuja 2 C | Gamla Mankans gränd 2 C | Vanhan-Mankkaan kuja 2 C | http://www.espoo.fi/fi-FI/Nuoret/Kivaa_tekemista/Nuorisotilat/Mankkaan_Makasiini | http://www.espoo.fi/fi-FI/Nuoret/Kivaa_tekemista/Nuorisotilat/Mankkaan_Makasiini | http://www.espoo.fi/fi-FI/Nuoret/Kivaa_tekemista/Nuorisotilat/Mankkaan_Makasiini | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 43 825 2329 | 2015-11-03T12:03:45+02:00 | 02180 | www.espoo.fi | kaikki | espoo | 2020-11-12T12:30:59.643790+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, 1401, 1403] | espoo | [375, 154, 263, 510] | [803, 85] | {} | Point | 24.768368 | 60.1932 | 6 | 12 | 2 | 1 | 12 | 4 |
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 );