unit
10 rows where accessibility_shortcoming_count_visually_impaired = 6 and accessibility_shortcoming_count_wheelchair = 1
This data as json, CSV (advanced)
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 155 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodinjohtaja"}, "www": null, "email": null, "phone": "+358 9 310 56492", "contact_person": "Heidi-Maria Akkala"}, {"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": 83}, {"value": "true", "variable": 59}, {"value": "long_term_stay", "variable": 60}, {"value": "3", "variable": 64}, {"value": "false", "variable": 38}, {"value": "false", "variable": 29}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 74}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 52}, {"value": "true", "variable": 109}, {"value": "true", "variable": 37}, {"value": "elsewhere", "variable": 110}, {"value": "true", "variable": 112}, {"value": "true", "variable": 113}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 49}, {"value": "true", "variable": 115}, {"value": "floor_1", "variable": 108}, {"value": "false", "variable": 48}, {"value": "true", "variable": 78}, {"value": "false", "variable": 23}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 34}, {"value": "false", "variable": 22}, {"value": "true", "variable": 6}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 70}, {"value": "true", "variable": 104}, {"value": "false", "variable": 103}, {"value": "true", "variable": 73}, {"value": "opens_easily_manually", "variable": 54}, {"value": "opens_with_access_control_key", "variable": 77}, {"value": "false", "variable": 75}, {"value": "true", "variable": 116}, {"value": "false", "variable": 57}, {"value": "false", "variable": 102}, {"value": "false", "variable": 84}, {"value": "false", "variable": 72}, {"value": "0", "variable": 1}, {"value": "false", "variable": 76}, {"value": "false", "variable": 106}, {"value": "true", "variable": 5}, {"value": "false", "variable": 92}, {"value": "true", "variable": 21}, {"value": "true", "variable": 50}, {"value": "true", "variable": 107}, {"value": "false", "variable": 111}, {"value": "false", "variable": 117}, {"value": "false", "variable": 44}, {"value": "true", "variable": 51}, {"value": "false", "variable": 33}, {"value": "false", "variable": 62}, {"value": "false", "variable": 98}, {"… | internal | 468 | ff8cf2e5-13c7-4da8-80e9-1d44da854d32 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Päiväkoti Herttoniemi | Day care Herttoniemi | Susitie 2 - 6 O | Vargvägen 2 - 6 O | Susitie 2 - 6 O | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/herttoniemi | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/herttoniemi | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/herttoniemi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 56492, +358 9 310 69719 | pk.herttoniemi@hel.fi | 2007-11-15T00:00:00+02:00 | 00800 | www.hel.fi | kaikki | helsinki | 2020-12-03T13:00:52.709282+02: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"} | [1087, 1405] | helsinki | [879, 978, 1090, 2125, 871, 870] | [861, 861, 663, 288, 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 | 25.03456 | 60.198948 | PL 80958, 00099 Helsingin kaupunki | Päiväkoti Herttoniemi | 1 | 1 | P.O. Box 80958, 00099 City of Helsinki | 1 | 1 | PB 80958, 00099 Helsingfors stad | 6 | ||||||||||||||||||||||||||||||||||
| 1417 | [{"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": "false", "variable": 23}, {"value": "false", "variable": 51}, {"value": "true", "variable": 50}, {"value": "false", "variable": 117}, {"value": "false", "variable": 103}, {"value": "false", "variable": 116}, {"value": "false", "variable": 104}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 21}, {"value": "true", "variable": 5}, {"value": "false", "variable": 102}, {"value": "false", "variable": 83}, {"value": "chairs_available", "variable": 81}, {"value": "true", "variable": 107}, {"value": "false", "variable": 80}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 92}, {"value": "false", "variable": 22}, {"value": "true", "variable": 114}, {"value": "true", "variable": 112}, {"value": "false", "variable": 57}, {"value": "false", "variable": 82}, {"value": "true", "variable": 113}, {"value": "false", "variable": 38}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 20}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "true", "variable": 52}, {"value": "true", "variable": 6}, {"value": "false", "variable": 49}, {"value": "false", "variable": 53}, {"value": "false", "variable": 79}, {"value": "false", "variable": 29}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 84}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 98}, {"value": "false", "variable": 105}, {"value": "true", "variable": 37}, {"value": "true", "variable": 59}, {"value": "short_term_stay", "variable": 60}, {"value": "requires_use_of_door_phone_and_is_heavy", "variable": 54}, {"value": "false", "variable": 33}, {"value": "0", "variable": 1}, {"value": "true", "variable": 115}, {"value": "false", "variable": 48}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 34}, {"value": "true", "variable": 62}, {"value": "false", "variable": 44}] | internal | 1005 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Tuetun työllistymisen palvelu | Supported employment service | Säästöpankinranta 2 A | Sparbankskajen 2 A | Säästöpankinranta 2 A | https://www.hel.fi/vammaiset/fi/tyollistyminen/tuettu-tyollistyminen/ | https://www.hel.fi/vammaiset/fi/tyollistyminen/tuettu-tyollistyminen/ | https://www.hel.fi/vammaiset/fi/tyollistyminen/tuettu-tyollistyminen/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 69597 | +358 9 445 53 | niina.pajala@hel.fi | 2007-11-15T00:00:00+02:00 | 00530 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:00.636450+02: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"} | [783] | helsinki | [814, 850] | [638, 282] | {} | Point | 24.94925 | 60.179405 | PL 8515, 00099 Helsingin kaupunki | Stödd sysselsättningsservice | 1 | 1 | P.O. Box 8515, 00099 City of Helsinki | 1 | 1 | PB 8515, 00099 Helsingfors stad | 6 | |||||||||||||||||||||||||||||||||
| 6540 | [{"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 24292", "contact_person": "Sirkka P\u00e4ivi"}, {"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": 33}, {"value": "next_to_door_on_opening_side", "variable": 110}, {"value": "1", "variable": 1}, {"value": "true", "variable": 112}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 107}, {"value": "true", "variable": 86}, {"value": "true", "variable": 52}, {"value": "true", "variable": 23}, {"value": "true", "variable": 116}, {"value": "true", "variable": 84}, {"value": "true", "variable": 20}, {"value": "long_term_stay", "variable": 60}, {"value": "at_least_3600mm", "variable": 3}, {"value": "true", "variable": 89}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 111}, {"value": "true", "variable": 118}, {"value": "true", "variable": 35}, {"value": "true", "variable": 113}, {"value": "true", "variable": 57}, {"value": "true", "variable": 115}, {"value": "true", "variable": 114}, {"value": "false", "variable": 87}, {"value": "false", "variable": 29}, {"value": "false", "variable": 102}, {"value": "false", "variable": 48}, {"value": "false", "variable": 21}, {"value": "true", "variable": 6}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 28}, {"value": "true", "variable": 109}, {"value": "outdoors", "variable": 2}, {"value": "true", "variable": 90}, {"value": "false", "variable": 103}, {"value": "true", "variable": 58}, {"value": "true", "variable": 59}, {"value": "false", "variable": 44}, {"value": "at_least_4_steps", "variable": 24}, {"value": "true", "variable": 117}, {"value": "false", "variable": 79}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 49}, {"value": "false", "variable": 92}, {"value": "false", "variable": 98}, {"value": "under_10m", "variable": 4}, {"value": "false", "variable": 38}, {"value": "true", "variable": 104}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 88}, {"value": "true", "variable": 62}, {"value": "false", "variable": 83}, {"value": "false", "variable": 22}, {"value": "false", "variable": 34}, {"value": "true",… | internal | 2749 | 0806282e-23c6-418a-ad9b-1ff39152ca5d | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Päiväkoti Inkivääri | Day care Inkivääri | Inkiväärikuja 3 | Ingefärgränden 3 | Inkiväärikuja 3 | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/inkivaari | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/inkivaari | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/inkivaari | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 24292, +358 9 310 41365 | +358 9 310 24175 | paivakoti.inkivaari@hel.fi | 2008-08-08T10:14:19+03:00 | 00990 | www.hel.fi | kaikki | helsinki | 2020-12-03T13:00:57.685569+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, 1405] | helsinki | [879, 1090, 2125, 871, 870] | [861, 663, 160] | {"fi": ["kes\u00e4aukiolo", "eskari", "varhaiskasvatus", "tarha", "lastentarha"], "en": ["day care", "preprimaryeducation", "pre-primary education", "preschool", "daycare"]} | Point | 25.15708 | 60.207348 | PL 99932, 00099 Helsingin kaupunki | Päiväkoti Inkivääri | 1 | 1 | 1 | P.O. Box 99932, 00099 City of Helsinki | 1 | PB 99932, 00099 Helsingfors stad | 6 | |||||||||||||||||||||||||||||||||
| 7986 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Aukioloajat"}, "www": {"fi": "http://kipina.munstadi.fi/aukioloajat/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Kysymys & vastauspalsta Pulmakulma", "sv": "Fr\u00e5ge- & svarspalten Pulmakulma", "en": "Forum for questions and answers"}, "www": {"fi": "http://www.nuoret.info/", "sv": "http://www.nuoret.info/", "en": "http://www.nuoret.info/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Harrastushaku.fi", "sv": "Harrastushaku.fi", "en": "Harrastushaku.fi"}, "www": {"fi": "http://nk.hel.fi/harrastushaku/", "sv": "http://nk.hel.fi/harrastushaku/", "en": "http://nk.hel.fi/harrastushaku/"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 20}, {"value": "true", "variable": 112}, {"value": "false", "variable": 98}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 59}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 115}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "true", "variable": 52}, {"value": "false", "variable": 49}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 48}, {"value": "at_least_3600mm", "variable": 3}, {"value": "false", "variable": 79}, {"value": "true", "variable": 113}, {"value": "true", "variable": 37}, {"value": "true", "variable": 105}, {"value": "floor_0", "variable": 119}, {"value": "false", "variable": 44}, {"value": "false", "variable": 29}, {"value": "guided_and_clear", "variable": 19}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 117}, {"value": "false", "variable": 53}, {"value": "true", "variable": 109}, {"value": "false", "variable": 106}, {"value": "false", "variable": 83}, {"value": "false", "variable": 34}, {"value": "true", "variable": 114}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "false", "variable": 21}, {"value": "false", "variable": 111}, {"value": "false", "variable": 5}, {"value": "floor_0", "variable": 120}, {"value": "outdoors", "variable": 2}, {"value": "true", "variable": 50}, {"value": "true", "variable": 107}, {"value": "false", "variable": 84}, {"value": "false", "variable": 103}, {"value": "false", "variable": 92}, {"value": "false", "variable": 116}, {"value": "true", "variable": 57}, {"value": "false", "variable": 118}, {"value": "false", "variable": 23}, {"value": "false", "variable": 102}, {"value": "true", "variable": 51}, {"value": "false", "variable": 22}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 38}, {"value": "long_term_stay", "variable": 60}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 33}, {"value": "true", "variable": 62}, {"valu… | internal | 2988 | cfe4d81b-7366-4ae2-b87b-b986e10cd220 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | http://kipina.munstadi.fi/files/2014/03/K%C3%A4yt%C3%A4v%C3%A42.jpg | Itäkeskuksen nuorten toimintatalo Kipinä | Vartiokylä Youth Work Unit | Turunlinnantie 1 A | Åbohusvägen 1 A | Turunlinnantie 1 A | http://kipina.munstadi.fi/ | http://kipina.munstadi.fi/ | http://kipina.munstadi.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 71643 | kipinan.nuorisotalo@hel.fi | +358 9 310 71643 | kipinan.nuorisotalo@hel.fi | https://www.nuoriso.hel.fi | 2008-09-09T20:14:31+03:00 | 00900 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:01.854808+02:00 | {"00": null, "11": "green", "12": "green", "13": "red", "21": "green", "22": "green", "23": "red", "31": "green", "32": "green", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [1403] | helsinki | [375] | [85] | {} | Point | 25.07989 | 60.212097 | PL 90406, 00099 Helsingin kaupunki | De ungas aktivitetshus Kipinä i Östra centrum | 1 | 1 | P.O. Box 90406, 00099 City of Helsinki | 1 | 1 | PB 90406, 00099 Helsingfors stad | 6 | ||||||||||||||||||||||||||||||
| 18699 | [{"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\u00e4koti on auki klo 6-18, ennalta sovitun hoitotarpeen mukaan."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodin johtaja"}, "www": null, "email": "tiina.hotinen@vantaa.fi", "phone": "+358 50 314 6316", "contact_person": "Tiina Hotinen"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "auringot.lipunkantaja@eduvantaa.fi", "phone": "+358 43 827 2057", "contact_person": "Auringot"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "kuut.lipunkantaja@eduvantaa.fi", "phone": "+358 40 171 4916", "contact_person": "Kuut"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "sateenkaaret.lipunkantaja@eduvantaa.fi", "phone": "+358 43 827 2059", "contact_person": "Sateenkaaret"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "salamat.lipunkantaja@eduvantaa.fi", "phone": "+358 40 171 4918", "contact_person": "Salamat"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "tahdet.lipunkantaja@eduvantaa.fi", "phone": "+358 43 827 2058", "contact_person": "T\u00e4hdet"}, {"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": "indoor_facility", "variable": 500}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "true", "variable": 50}, {"value": "false", "variable": 23}, {"value": "1", "variable": 1}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 57}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 104}, {"value": "at_least_3600mm", "variable": 3}, {"value": "false", "variable": 92}, {"value": "false", "variable": 84}, {"value": "true", "variable": 40}, {"value": "true", "variable": 115}, {"value": "true", "variable": 118}, {"value": "true", "variable": 6}, {"value": "true", "variable": 117}, {"value": "false", "variable": 48}, {"value": "false", "variable": 21}, {"value": "true", "variable": 59}, {"value": "false", "variable": 102}, {"value": "true", "variable": 62}, {"value": "true", "variable": 116}, {"value": "true", "variable": 37}, {"value": "handrails_on_both_sides", "variable": 47}, {"value": "false", "variable": 29}, {"value": "outdoors", "variable": 2}, {"value": "true", "variable": 105}, {"value": "true", "variable": 114}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "true", "variable": 44}, {"value": "false", "variable": 33}, {"value": "true", "variable": 113}, {"value": "true", "variable": 20}, {"value": "true", "variable": 51}, {"value": "true", "variable": 58}, {"value": "under_10m", "variable": 4}, {"value": "smooth", "variable": 17}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 22}, {"value": "true", "variable": 5}, {"value": "false", "variable": 109}, {"value": "true", "variable": 107}, {"value": "no_handrails", "variable": 41}, {"value": "guided_and_clear", "variable": 19}, {"value": "true", "variable": 38}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 46}, {"value": "false", "variable": 83}, {"value": "false", "variable": 98}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "long_term_stay", "var… | internal | 5258 | ab4f37d0-3e53-462e-ad40-c73b57e3e39e | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | https://vantaa.emmi.fi/l/DJnxwd_Zpp6w | Lipunkantajan päiväkoti on viisiryhmäinen päiväkoti, jossa tarjotaan kokopäiväistä varhaiskasvatusta ja esiopetusta. Me lipunkantajat olemme värikäs ja erilaisista ihmisistä koostuva onnellinen seikkailijoiden joukko joiden, vasta alussa olevat, tutkimusmatkat ja seikkailut suuntautuvat kasvamisen saloihin. Meillä jokainen päivä on seikkailua uusien ihmeellisten asioiden maailmassa. Matkamme varrella kohtaamme iloja, riemua, kyyneleitä, hämmennystä, kaipuuta ja joskus onneakin. Kaikkea kokemaamme kannamme ylpeinä mukanamme kartuttaessamme kokemusten aarrearkkua. | Lipunkantajan päiväkoti | Tapparakuja 6 | Stridsyxgränden 6 | Tapparakuja 6 | https://www.vantaa.fi/varhaiskasvatus_ja_koulutus/varhaiskasvatus/palvelut/paivakodit/kivisto/lipunkantajan_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_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 839 11 | etunimi.sukunimi@vantaa.fi | +358 9 8393 4113 | pk.lipunkantaja@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01700 | www.vantaa.fi | kaikki | vantaa | 2020-11-05T16:31:12.654970+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] | vantaa | [879, 1090, 2125, 871, 1089, 2122, 870] | [861, 663, 160] | {"fi": ["varhaiskasvatus", "p\u00e4iv\u00e4koti", "eskari", "tarha", "lastentarha", "p\u00e4iv\u00e4hoito", "esiopetus"]} | Point | 24.850693 | 60.322617 | PL 2437, 01030 Vantaan kaupunki | Lipunkantajan päiväkoti. Kuva: Vantaan kaupunki. | Lipunkantajan päiväkoti on viisiryhmäinen päiväkoti, jossa tarjotaan kokopäiväistä varhaiskasvatusta ja esiopetusta. | 2 | 1 | Lipunkantajan päiväkoti. Bild: Vanda stad. | 1 | P.O. Box 2437, 01030 City of Vantaa | 1 | 1 | PB 2437, 01030 Vanda stad | 6 | Lipunkantajan päiväkoti. Photo: City of Vantaa. | |||||||||||||||||||||||||||
| 19271 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Rehtori"}, "www": null, "email": "sami.suomela@vantaa.fi", "phone": "+358 400 297 424", "contact_person": "Sami Suomela"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Apulaisrehtori"}, "www": null, "email": null, "phone": "+358 50 312 1712", "contact_person": "Johanna Kaario"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Koulusihteeri"}, "www": null, "email": null, "phone": "+358 40 652 9034", "contact_person": "Irina Ilola"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Opettajainhuone"}, "www": null, "email": "Opettajat: etunimi.sukunimi@eduvantaa.fi", "phone": "+358 40 823 4338", "contact_person": null}, {"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": 114}, {"value": "false", "variable": 31}, {"value": "false", "variable": 34}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 59}, {"value": "false", "variable": 84}, {"value": "true", "variable": 57}, {"value": "false", "variable": 106}, {"value": "false", "variable": 23}, {"value": "handrails_on_one_side", "variable": 32}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "false", "variable": 48}, {"value": "indoor_facility", "variable": 500}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 50}, {"value": "false", "variable": 111}, {"value": "true", "variable": 29}, {"value": "2", "variable": 1}, {"value": "true", "variable": 70}, {"value": "true", "variable": 112}, {"value": "under_10m", "variable": 4}, {"value": "true", "variable": 107}, {"value": "false", "variable": 21}, {"value": "false", "variable": 5}, {"value": "false", "variable": 118}, {"value": "on_door", "variable": 110}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 117}, {"value": "opens_easily_manually", "variable": 77}, {"value": "false", "variable": 62}, {"value": "handrails_on_both_sides", "variable": 47}, {"value": "at_least_3600mm", "variable": 3}, {"value": "false", "variable": 104}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 58}, {"value": "long_term_stay", "variable": 60}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 51}, {"value": "true", "variable": 109}, {"value": "true", "variable": 37}, {"value": "false", "variable": 46}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "false", "variable": 102}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 73}, {"value": "false", "variable": 76}, {"value": "true", "variable": 75}, {"value": "true", "variable": 52}, {"value": "false", "variable": 92}, {"value": "true", "variable": 74}, {"value": "true", "variable": 44}, {"value": "true", "variable": 115}, {"value": "false", "var… | internal | 5522 | c6e828d9-9f7c-43ee-91fc-085d9a122b04 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Jokivarren koulun Nikimäen opetuspiste tarjoaa perusopetusta 1-5 luokkalaisille.Jokivarren koulu on noin 640 oppilaan lähikoulu Korsossa, jonka toinen opetuspiste on Nikinmäen opetuspiste.Nikinmäen opetuspiste, luokat 1-5 (Perhotie 27, 01490 Vantaa).Tarkempaa tietoa Jokivarren koulusta löydät kotisivulta. | Jokivarren koulu Nikinmäen opetuspiste | Jokivarren koulu Nikinmäen opetuspiste | Perhotie 27 | Fjärilsvägen 27 | Perhotie 27 | https://sivistysvantaa.fi/jokivarrenkoulu/index.html | https://www.vanda.fi/framsida# | https://www.vantaa.fi/front_page# | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 839 11 | etunimi.sukunimi@vantaa.fi | +358 9 8392 1238 | ilkka.tarjo@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01490 | www.vantaa.fi | kaikki | vantaa | 2020-11-05T16:31:13.913007+02:00 | {"00": null, "11": "green", "12": "green", "13": "red", "21": "green", "22": "green", "23": "red", "31": "green", "32": "green", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [1087] | vantaa | [1100] | [661] | {"fi": ["koulu", "perusopetus", "alakoulu", "peruskoulu", "ala-aste"]} | Point | 25.13524 | 60.345253 | PL 6516, 01030 Vantaan kaupunki | Jokivarren koulu Nikinmäen opetuspiste | Jokivarren koulun Nikimäen opetuspiste tarjoaa perusopetusta 1-5 luokkalaisille. | 1 | 1 | P.O. Box 6516, 01030 City of Vantaa | 1 | 1 | PB 6516, 01030 Vanda stad | 6 | ||||||||||||||||||||||||||||||
| 24025 | [{"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}] | [{"value": "false", "variable": 98}, {"value": "false", "variable": 103}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "false", "variable": 21}, {"value": "floor_0", "variable": 108}, {"value": "true", "variable": 75}, {"value": "true", "variable": 115}, {"value": "true", "variable": 73}, {"value": "2", "variable": 64}, {"value": "false", "variable": 92}, {"value": "false", "variable": 23}, {"value": "false", "variable": 46}, {"value": "false", "variable": 106}, {"value": "under_10m", "variable": 4}, {"value": "2", "variable": 1}, {"value": "true", "variable": 58}, {"value": "true", "variable": 50}, {"value": "true", "variable": 70}, {"value": "false", "variable": 111}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 107}, {"value": "false", "variable": 62}, {"value": "handrails_on_both_sides", "variable": 47}, {"value": "false", "variable": 76}, {"value": "true", "variable": 112}, {"value": "true", "variable": 109}, {"value": "false", "variable": 116}, {"value": "true", "variable": 37}, {"value": "on_door", "variable": 110}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "at_least_3600mm", "variable": 3}, {"value": "under_20mm", "variable": 91}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 29}, {"value": "true", "variable": 44}, {"value": "true", "variable": 113}, {"value": "true", "variable": 117}, {"value": "false", "variable": 31}, {"value": "false", "variable": 49}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 79}, {"value": "false", "variable": 78}, {"value": "false", "variable": 5}, {"value": "true", "variable": 57}, {"value": "opens_easily_manually", "variable": 77}, {"value": "handrails_on_one_side", "variable": 32}, {"value": "false", "variable": 118}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 83}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 74}, {"value": "true", "variable": 20}, {"value": "true", "variable": 51}, {… | internal | 6965 | 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 / Nikinmäen opetuspiste | School and student health care / Nikimäen opetuspiste | Perhotie 27 | Fjärilsvägen 27 | 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 2146 | etunimi.sukunimi@vantaa.fi | +358 40 532 7344 | tiina.turkia@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01490 | www.vantaa.fi | kaikki | vantaa | 2020-05-22T11:01:15.368028+03:00 | {"00": null, "11": "green", "12": "green", "13": "red", "21": "green", "22": "green", "23": "red", "31": "green", "32": "green", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [986, 1087] | vantaa | [2164, 2165, 2166, 2167] | [863, 339] | {"fi": ["koulu- ja opiskeluterveydenhuollon palvelut"]} | Point | 25.13524 | 60.345253 | Perhotie 27, 01490 Vantaa | Skol- och studenthälsovård / Nikimäen opetuspiste | Koulu- ja opiskeluterveydenhuolto | 1 | 1 | 1 | 1 | 6 | ||||||||||||||||||||||||||||||||||
| 24030 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://asiointi.vantaa.fi/anna-palautetta"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 46}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 73}, {"value": "true", "variable": 58}, {"value": "false", "variable": 103}, {"value": "false", "variable": 21}, {"value": "false", "variable": 38}, {"value": "true", "variable": 107}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 109}, {"value": "true", "variable": 37}, {"value": "true", "variable": 51}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 102}, {"value": "at_least_3600mm", "variable": 3}, {"value": "false", "variable": 104}, {"value": "on_door", "variable": 110}, {"value": "under_10m", "variable": 4}, {"value": "false", "variable": 22}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 113}, {"value": "false", "variable": 118}, {"value": "false", "variable": 33}, {"value": "handrails_on_both_sides", "variable": 47}, {"value": "true", "variable": 50}, {"value": "handrails_on_one_side", "variable": 32}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "true", "variable": 74}, {"value": "indoor_facility", "variable": 500}, {"value": "2", "variable": 1}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 112}, {"value": "false", "variable": 23}, {"value": "false", "variable": 111}, {"value": "false", "variable": 34}, {"value": "true", "variable": 114}, {"value": "false", "variable": 53}, {"value": "true", "variable": 52}, {"value": "true", "variable": 72}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "true", "variable": 105}, {"value": "false", "variable": 49}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 78}, {"value": "false", "variable": 31}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 29}, {"value": "false", "variable": 98}, {"value": "true", "variable": 117}, {"value": "true", "variable": 57}, {"value": "false", "variable": 116}, {"value": "false", "variable": 79}, {"value": "true", "variable": 115}, {"value"… | internal | 7102 | 744852ab-9425-4329-9d1d-96fe0f132f63 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kuraattori auttaa lasta ja nuorta esimerkiksi perhetilanteeseen liittyvissä asioissa, kaverisuhteissa ja koulunkäyntiin liittyvissä kysymyksissä. Oppilaan tilannetta helpottavia ratkaisuja etsitään yhdessä oppilaan ja huoltajien kanssa. Kuraattori voi tavata oppilasta koulussa kahden kesken tai yhdessä perheen tai muiden läheisten kanssa. Tapaamisten sisältö muotoutuu oppilaan tarpeiden mukaan. | Kuraattoripalvelut / Jokivarren koulu Nikinmäen opetuspiste | Perhotie 27 | Fjärilsvägen 27 | Perhotie 27 | http://www.vantaa.fi/varhaiskasvatus_ja_koulutus/perusopetus/koululaisen_hyvinvointi_ja_terveys/koulukuraattoripalvelut | http://www.vanda.fi/smabarnspedagogik_och_utbildning/grundlaggande_utbildning/valmaende_och_halsa/skolkuratorstjanster | http://www.vantaa.fi/en/social_and_health_care_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8392 0234 | etunimi.sukunimi@vantaa.fi | +358 40 532 7344 | tiina.turkia@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01490 | www.vantaa.fi | kaikki | vantaa | 2020-03-13T09:31:21.734647+02:00 | {"00": null, "11": "green", "12": "green", "13": "red", "21": "green", "22": "green", "23": "red", "31": "green", "32": "green", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [1087] | vantaa | [1374] | [340] | {} | Point | 25.13524 | 60.345253 | Perhotie 27, 01490 Vantaa | Kuratorservice / Jokivarren koulu | Kuraattoreiden tehtävänä on tukea lasten ja nuorten koulunkäyntiä, hyvinvointia sekä kasvua ja kehitystä. | 1 | 1 | 1 | 1 | 6 | |||||||||||||||||||||||||||||||||
| 39237 | [{"section_type": "OPENING_HOURS", "name": {"fi": "ma, ti, to, pe klo. 6-20.00\nke klo. 9-20.00\nla-su klo.10-17.00", "sv": "m\u00e5, ti, to, fre kl. 6.00-20.00\nons kl. 9.00-20.00\nl\u00f6-s\u00f6 kl. 10.00-17.00"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://www.kauniainen.fi/kaupunki_ja_paatoksenteko/osallistu_ja_vaikuta"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 114}, {"value": "true", "variable": 107}, {"value": "true", "variable": 118}, {"value": "over_10m", "variable": 4}, {"value": "false", "variable": 116}, {"value": "0", "variable": 63}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 117}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 51}, {"value": "false", "variable": 44}, {"value": "false", "variable": 83}, {"value": "true", "variable": 62}, {"value": "true", "variable": 104}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 23}, {"value": "true", "variable": 113}, {"value": "2", "variable": 1}, {"value": "floor_0", "variable": 108}, {"value": "false", "variable": 48}, {"value": "true", "variable": 109}, {"value": "true", "variable": 59}, {"value": "guided_and_clear", "variable": 19}, {"value": "true", "variable": 105}, {"value": "swimming_hall", "variable": 61}, {"value": "true", "variable": 50}, {"value": "false", "variable": 49}, {"value": "false", "variable": 79}, {"value": "true", "variable": 103}, {"value": "sufficiently_wide", "variable": 18}, {"value": "outdoors", "variable": 2}, {"value": "true", "variable": 115}, {"value": "false", "variable": 102}, {"value": "at_least_3600mm", "variable": 3}, {"value": "false", "variable": 92}, {"value": "true", "variable": 20}, {"value": "true", "variable": 80}, {"value": "true", "variable": 37}, {"value": "false", "variable": 70}, {"value": "on_door", "variable": 110}, {"value": "false", "variable": 21}, {"value": "true", "variable": 52}, {"value": "indoor_facility", "variable": 500}, {"value": "sport_facility", "variable": 60}, {"value": "false", "variable": 34}, {"value": "false", "variable": 98}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "true", "variable": 112}, {"value": "false", "variable": 53}, {"value": "false", "variable": 22}, {"value": "false", "variable": 29}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 111}, {"value": "fals… | internal | 14595 | lipas | 505838 | 2cd6c260-07cc-43df-bc36-a737338ddda0 | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Iso allas (6 rataa) ja lastenallas. Neljä tavallista saunaa ja tilaussauna, joka sopii liikuntarajoitteisille. | One outdoor pool (12,4 m) and 2 indoor pools. | Uimahalli | Kauniainen Swimming Pool | Asematie 26 | Stationsvägen 26 | Asematie 26 | https://www.kauniainen.fi/kulttuuri_ja_vapaa-aika/liikuntapalvelut/liikuntapaikat/sisaliikuntapaikat/uimahalli | http://www.kauniainen.fi/sv/kultur_och_fritid/idrottstjanster/idrottsplatser/simhallen | http://www.kauniainen.fi/kulttuuri_ja_vapaa-aika/liikuntapalvelut/liikuntapaikat/uimahalli | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 411 6346 | 2014-09-05T13:29:17+03:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-12-18T07:31:20.874474+02:00 | {"00": null, "11": "green", "12": "green", "13": "red", "21": "green", "22": "green", "23": "red", "31": "green", "32": "green", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [1403] | kauniainen | [693] | [729] | {"fi": ["ulkoallas", "lastenallas", "uimahalli"], "sv": ["barnbass\u00e4ng", "simhall", "utebass\u00e4ng"], "en": ["childrens pool", "outdoor pool", "swimming hall"]} | Point | 24.71015 | 60.21625 | Simhall | Hallissa 25 m sisäallas ja lastenallas. | 1 | 1 | 1 | 1 | 25 m innebassäng och barnbassäng. | Utebassäng (12,4 m), 2 innebassänger. | 6 | 25 m swimming pool and pool for children | ||||||||||||||||||||||||||||||
| 54459 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 08-20, la 10-18, su 11-18", "sv": "\u00f6ppet m\u00e5n-fre 08-20, l\u00f6r 10-18, s\u00f6n 11-18", "en": "open Mon-Fri 08-20, Sat 10-18, Sun 11-18"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/efeedback/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "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": "false", "variable": 33}, {"value": "true", "variable": 8}, {"value": "false", "variable": 92}, {"value": "true", "variable": 5}, {"value": "parking_hall", "variable": 2}, {"value": "false", "variable": 103}, {"value": "false", "variable": 23}, {"value": "false", "variable": 107}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 98}, {"value": "true", "variable": 52}, {"value": "false", "variable": 29}, {"value": "true", "variable": 62}, {"value": "false", "variable": 34}, {"value": "false", "variable": 79}, {"value": "false", "variable": 7}, {"value": "false", "variable": 49}, {"value": "false", "variable": 106}, {"value": "at_least_3600mm", "variable": 3}, {"value": "true", "variable": 59}, {"value": "true", "variable": 16}, {"value": "true", "variable": 6}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 20}, {"value": "false", "variable": 13}, {"value": "4", "variable": 1}, {"value": "true", "variable": 37}, {"value": "false", "variable": 38}, {"value": "under_20mm", "variable": 91}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "true", "variable": 14}, {"value": "false", "variable": 84}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 104}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 105}, {"value": "false", "variable": 83}, {"value": "false", "variable": 21}, {"value": "true", "variable": 12}, {"value": "false", "variable": 102}, {"value": "under_10m", "variable": 4}, {"value": "true", "variable": 10}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 57}, {"value": "true", "variable": 11}, {"value": "true", "variable": 50}, {"value": "true", "variable": 58}, {"value": "false", "variable": 22}, {"value": "false", "variable": 44}, {"value": "false", "variable": 53}, {"value": "indoors_but_not_service_point", "variable": 9}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 51}, {"value": "false", "variable": 48}, {"val… | internal | 24102 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Pointin nuorisotila | Leppävaarankatu 9 | Albergagatan 9 | Leppävaarankatu 9 | http://espoo.fi/nuoret | http://espoo.fi/nuoret | http://espoo.fi/nuoret | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 46 877 2205 | pointti.nuoriso@espoo.fi | 2017-09-30T12:50:21+03:00 | 02600 | www.espoo.fi | kaikki | espoo | 2020-11-12T12:31:48.595621+02: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"} | [1403] | espoo | [375, 366] | [468, 85] | {} | Point | 24.809319 | 60.21728 | Nuorisotila Sellon kirjaston nuortenosastolla | 1 | 1 | 1 | 1 | 6 |
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 );