unit
9 rows where accessibility_shortcoming_count_stroller = 1 and accessibility_shortcoming_count_wheelchair = 11
This data as json, CSV (advanced)
Suggested facets: municipality, accessibility_shortcoming_count_rollator
id ▼ | connections | accessibility_properties | identifiers_0_namespace | identifiers_0_value | identifiers_1_namespace | identifiers_1_value | department | root_department | provider_type | organizer_type | contract_type_id | contract_type_description_fi | contract_type_description_sv | contract_type_description_en | is_active | deleted_at | organizer_name | organizer_business_id | picture_url | picture_entrance_url | streetview_entrance_url | description_fi | description_en | short_description | name_fi | name_en | street_address_fi | street_address_sv | street_address_en | www_fi | www_sv | www_en | address_postal_full | call_charge_info_fi | call_charge_info_sv | call_charge_info_en | picture_caption | phone | fax | accessibility_phone | accessibility_email | accessibility_www | created_time | address_zip | data_source | extensions_maintenance_group | extensions_maintenance_organization | last_modified_time | accessibility_viewpoints | root_service_nodes | municipality | service_nodes | services | keywords | location_type | location_coordinates_0 | location_coordinates_1 | address_postal_full_fi | identifiers_2_value | picture_caption_fi | call_charge_info | www | name_sv | short_description_fi | accessibility_shortcoming_count_reduced_mobility | accessibility_shortcoming_count_wheelchair | location | picture_caption_sv | accessibility_shortcoming_count_stroller | address_postal_full_en | accessibility_shortcoming_count_hearing_aid | street_address | contract_type | accessibility_shortcoming_count_rollator | identifiers_2_namespace | address_postal_full_sv | short_description_sv | description_sv | accessibility_shortcoming_count_visually_impaired | short_description_en | description | picture_caption_en | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
352 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Vs.P\u00e4iv\u00e4kodinjohtaja", "sv": "Daghemsf\u00f6rest\u00e5ndare", "en": "Manager of daycare centre"}, "www": null, "email": "saija.juusti@hel.fi", "phone": "+358 9 310 29181", "contact_person": "Saija Juusti"}, {"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": "smooth", "variable": 17}, {"value": "false", "variable": 106}, {"value": "false", "variable": 70}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 83}, {"value": "false", "variable": 22}, {"value": "at_least_4_steps", "variable": 93}, {"value": "false", "variable": 98}, {"value": "false", "variable": 44}, {"value": "false", "variable": 33}, {"value": "false", "variable": 104}, {"value": "false", "variable": 113}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 84}, {"value": "true", "variable": 92}, {"value": "false", "variable": 112}, {"value": "false", "variable": 109}, {"value": "false", "variable": 96}, {"value": "false", "variable": 103}, {"value": "true", "variable": 50}, {"value": "true", "variable": 59}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 34}, {"value": "false", "variable": 29}, {"value": "false", "variable": 48}, {"value": "true", "variable": 37}, {"value": "false", "variable": 102}, {"value": "false", "variable": 21}, {"value": "true", "variable": 57}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "false", "variable": 49}, {"value": "2", "variable": 64}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 23}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 116}, {"value": "false", "variable": 79}, {"value": "false", "variable": 117}, {"value": "true", "variable": 52}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 51}, {"value": "false", "variable": 38}, {"value": "true", "variable": 107}, {"value": "true", "variable": 114}, {"value": "false", "variable": 5}, {"value": "false", "variable": 62}, {"value": "false", "variable": 97}, {"value": "true", "variable": 20}, {"value": "false", "variable": 58}, {"value": "false", "variable": 115}, {"value": "0", "variable": 1}, {"value": "false", "variable": 53}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "va… | internal | 525 | 8c67fdec-0c89-4dfa-8cfd-5de677c66a4d | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Päiväkoti Susanna | Day care Susanna | Susannanpenger 1 | Susannaterrassen 1 | Susannanpenger 1 | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/susanna | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/susanna | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/susanna | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 29181, +358 9 310 42200 | pk.susanna@hel.fi | +358 9 310 29545 | pk.susanna@hel.fi | 2007-11-15T00:00:00+02:00 | 00240 | www.hel.fi | kaikki | helsinki | 2020-12-03T13:00:54.191379+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 | [895, 879, 1090, 2125, 890, 871, 889, 870] | [861, 861, 663, 607, 160, 160] | {"fi": ["kes\u00e4aukiolo", "eskari", "varhaiskasvatus", "tarha", "lastentarha", "Esiopetus 2021-2022"], "en": ["day care", "preprimaryeducation", "pre-primary education", "preschool", "daycare"]} | Point | 24.922241 | 60.197613 | PL 24970, 00099 Helsingin kaupunki | Päiväkoti Susanna | 5 | 11 | 1 | P.O. Box 24970, 00099 City of Helsinki | 1 | 11 | PB 24970, 00099 Helsingfors stad | 8 | |||||||||||||||||||||||||||||||
8089 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Aukioloajat"}, "www": {"fi": "http://luontotalo.munstadi.fi/aukioloajat/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Kysymys & vastauspalsta Pulmakulma", "sv": "Fr\u00e5ge- & svarspalten Pulmakulma", "en": "Forum for questions and answers"}, "www": {"fi": "http://www.nuoret.info/", "sv": "http://www.nuoret.info/", "en": "http://www.nuoret.info/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Harrastushaku.fi", "sv": "Harrastushaku.fi", "en": "Harrastushaku.fi"}, "www": {"fi": "http://nk.hel.fi/harrastushaku/", "sv": "http://nk.hel.fi/harrastushaku/", "en": "http://nk.hel.fi/harrastushaku/"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 105}, {"value": "sufficiently_wide", "variable": 18}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 21}, {"value": "true", "variable": 37}, {"value": "false", "variable": 48}, {"value": "false", "variable": 62}, {"value": "true", "variable": 59}, {"value": "false", "variable": 107}, {"value": "true", "variable": 44}, {"value": "true", "variable": 38}, {"value": "spiral_staircase", "variable": 93}, {"value": "false", "variable": 96}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 25}, {"value": "false", "variable": 58}, {"value": "false", "variable": 42}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 50}, {"value": "false", "variable": 43}, {"value": "false", "variable": 106}, {"value": "false", "variable": 94}, {"value": "false", "variable": 34}, {"value": "0", "variable": 1}, {"value": "false", "variable": 53}, {"value": "false", "variable": 84}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "opens_easily_manually", "variable": 54}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 57}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "3", "variable": 64}, {"value": "true", "variable": 23}, {"value": "false", "variable": 29}, {"value": "false", "variable": 70}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 6}, {"value": "false", "variable": 33}, {"value": "true", "variable": 35}, {"value": "false", "variable": 79}, {"value": "false", "variable": 102}, {"value": "false", "variable": 52}, {"value": "false", "variable": 40}, {"value": "false", "variable": 22}, {"value": "rough", "variable": 17}, {"value": "true", "variable": 5}, {"value": "true", "variable": 92}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 97}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "true", "variable": 104}, {"value": "false", "variable": 4… | internal | 3041 | cfe4d81b-7366-4ae2-b87b-b986e10cd220 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | http://luontotalo.munstadi.fi/files/2014/01/Luontotalo_talokaruselli_900x300px.jpg | Meriharjun luontotalo | Young People's Nature House, Villa Paulig | Uutelantie 32 | Nybondasvägen 32 | Uutelantie 32 | http://luontotalo.munstadi.fi/ | http://luontotalo.munstadi.fi/ | http://luontotalo.munstadi.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 89038 | +358 9 310 89038 | luonto.talo@hel.fi | +358 9 310 89038 | luonto.talo@hel.fi | 2008-09-09T20:14:31+03:00 | 00990 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:02.553804+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} | [1403] | helsinki | [426, 458] | [580, 391] | {} | PL 84404, 00099 Helsingin kaupunki | Meriharju naturhus | 9 | 11 | 1 | P.O. Box 84404, 00099 City of Helsinki | 1 | 10 | PB 84404, 00099 Helsingfors stad | 13 | ||||||||||||||||||||||||||||||||
15336 | [{"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": 59}, {"value": "false", "variable": 62}, {"value": "false", "variable": 48}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "3", "variable": 64}, {"value": "long_term_stay", "variable": 60}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 104}, {"value": "true", "variable": 52}, {"value": "false", "variable": 106}, {"value": "requires_use_of_buzzer_and_is_heavy", "variable": 54}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 5}, {"value": "true", "variable": 37}, {"value": "false", "variable": 58}, {"value": "false", "variable": 83}, {"value": "true", "variable": 50}, {"value": "false", "variable": 34}, {"value": "over_20mm", "variable": 56}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 97}, {"value": "1_step", "variable": 39}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 55}, {"value": "true", "variable": 92}, {"value": "false", "variable": 29}, {"value": "true", "variable": 105}, {"value": "true", "variable": 57}, {"value": "false", "variable": 21}, {"value": "at_least_4_turning_steps", "variable": 93}, {"value": "true", "variable": 23}, {"value": "false", "variable": 33}, {"value": "false", "variable": 70}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 94}, {"value": "false", "variable": 84}, {"value": "1_step", "variable": 24}, {"value": "false", "variable": 79}, {"value": "true", "variable": 51}, {"value": "false", "variable": 102}, {"value": "false", "variable": 103}, {"value": "false", "variable": 107}, {"value": "false", "variable": 22}, {"value": "false", "variable": 49}, {"value": "false", "variable": 53}, {"value": "true", "variable": 20}, {"value": "false", "variable": 98}, {"value": "0", "variable": 1}, {"value": "false", "variable": 96}, {"value": "true", "variable": 38}, {"value": "false", "variable": 44}, {"value": "sufficiently_wide", "variable": 18}] | internal | 4434 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Niittykummun koulu on Etelä-Espoon vanhin alakoulu, joka on varustettu tämän päivän esitystekniikalla. Koulu on monimuotoinen alakoulu, jossa on noin 400 oppilasta.Koulussa on yleisopetuksen lisäksi painotettua opetusta: kaksikielisilllä suomi-englanti -luokilla ja montessoriluokilla ensimmäisestä luokasta kuudenteen. Niittykummun koulussa on myös erityisopetusta autisminkirjon oppilaille luokilla 1.-6.A1-kielinä koulussa opiskellaan englantia ja A2-kielenä ruotsia ja saksaa. B1-kieltä ruotsia opiskellaan 6. luokasta lähtien.Opetus tapahtuu lukuvuonna 2020-2021 kahdessa toimipisteessä; päärakennus sijaitsee osoitteessa Niittyportti 3 ja lisäksi opetusta järjestetään osoitteessa Riihitontuntie 7C. | Niittykummun koulu | Niittyportti 3 | Ängsporten 3 | Niittyportti 3 | http://espoo.fi/fi-FI/Kasvatus_ja_opetus/Perusopetus/Peruskoulut/Alakoulut/Niittykummun_koulu | http://espoo.fi/fi-FI/Kasvatus_ja_opetus/Perusopetus/Peruskoulut/Alakoulut/Niittykummun_koulu | http://www.espoo.fi/en-US/Childcare_and_education/Comprehensive_education | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8163 0175 | +358 9 8163 0175 | 2015-11-03T12:03:45+02:00 | 02200 | www.espoo.fi | kaikki | espoo | 2020-11-10T10:31:04.644254+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, 1142, 1146, 2229, 1100] | [904, 661, 108, 35, 34, 15] | {"fi": ["ala-aste", "koulu"]} | Point | 24.767801 | 60.170197 | PL 3201, 02070 ESPOON KAUPUNKI | Niittykummun koulu on Etelä-Espoon vanhin alakoulu, joka on varustettu tämän päivän esitystekniikalla. | 6 | 11 | 1 | P.O. Box 3201, 02070 ESPOO CITY | 1 | 11 | PB 3201, 02070 ESBO STAD | 10 | |||||||||||||||||||||||||||||||||
15631 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 84}, {"value": "no_handrails", "variable": 26}, {"value": "true", "variable": 25}, {"value": "true", "variable": 50}, {"value": "true", "variable": 57}, {"value": "false", "variable": 79}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 20}, {"value": "true", "variable": 22}, {"value": "false", "variable": 98}, {"value": "false", "variable": 33}, {"value": "false", "variable": 5}, {"value": "false", "variable": 34}, {"value": "soft", "variable": 17}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 83}, {"value": "1_step", "variable": 39}, {"value": "false", "variable": 107}, {"value": "false", "variable": 29}, {"value": "false", "variable": 103}, {"value": "long_term_stay", "variable": 60}, {"value": "over_20mm", "variable": 56}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "2_consecutive_steps", "variable": 24}, {"value": "false", "variable": 104}, {"value": "false", "variable": 58}, {"value": "false", "variable": 105}, {"value": "false", "variable": 44}, {"value": "false", "variable": 102}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 23}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 92}, {"value": "false", "variable": 52}, {"value": "true", "variable": 59}, {"value": "false", "variable": 37}, {"value": "false", "variable": 28}, {"value": "false", "variable": 49}, {"value": "false", "variable": 48}, {"value": "true", "variable": 62}, {"value": "false", "variable": 21}, {"value": "false", "variable": 51}, {"value": "indoor_facility", "variable": 500}, {"value": "0", "variable": 1}, {"value": "true", "variable": 38}] | internal | 4517 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Ryhmäperhepäiväkoti Ramsay | Venepellonmäki 5-7 D 2 | Båtåkersbacken 5-7 D 2 | Venepellonmäki 5-7 D 2 | http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Perhe_ja_ryhmaperhepaivahoito/Espoon_keskus/Ryhmaperhepaivahoito | http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Perhe_ja_ryhmaperhepaivahoito/Espoon_keskus/Ryhmaperhepaivahoito | http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Perhe_ja_ryhmaperhepaivahoito/Espoon_keskus/Ryhmaperhepaivahoito | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 46 877 2609 | 2015-11-03T12:03:45+02:00 | 02780 | www.espoo.fi | kaikki | espoo | 2020-03-13T09:31:06.375256+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] | espoo | [871, 870, 963] | [664, 663] | {"fi": ["ryhmis", "varhaiskasvatus", "p\u00e4iv\u00e4koti", "lastentarha"]} | Point | 24.596392 | 60.197514 | PL 87306, 02070 ESPOON KAUPUNKI | 7 | 11 | 1 | P.O. Box 87306, 02070 ESPOON KAUPUNKI | 1 | 11 | PB 87306, 02070 ESPOON KAUPUNKI | 9 | ||||||||||||||||||||||||||||||||||||
15863 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "2_consecutive_steps", "variable": 39}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 28}, {"value": "false", "variable": 44}, {"value": "true", "variable": 23}, {"value": "false", "variable": 104}, {"value": "true", "variable": 105}, {"value": "false", "variable": 83}, {"value": "false", "variable": 21}, {"value": "false", "variable": 102}, {"value": "true", "variable": 59}, {"value": "false", "variable": 92}, {"value": "no_handrails", "variable": 41}, {"value": "soft", "variable": 17}, {"value": "false", "variable": 48}, {"value": "2_consecutive_steps", "variable": 24}, {"value": "false", "variable": 106}, {"value": "false", "variable": 107}, {"value": "true", "variable": 57}, {"value": "false", "variable": 52}, {"value": "false", "variable": 84}, {"value": "true", "variable": 51}, {"value": "true", "variable": 22}, {"value": "true", "variable": 40}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 62}, {"value": "true", "variable": 38}, {"value": "false", "variable": 49}, {"value": "false", "variable": 29}, {"value": "true", "variable": 37}, {"value": "no_handrails", "variable": 26}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 20}, {"value": "false", "variable": 79}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "long_term_stay", "variable": 60}, {"value": "indoor_facility", "variable": 500}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 50}, {"value": "false", "variable": 58}, {"value": "false", "variable": 43}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 98}, {"value": "false", "variable": 33}, {"value": "0", "variable": 1}, {"value": "false", "variable": 5}, {"value": "true", "variable": 25}, {"value": "false", "variable": 103}, {"value": "false", "variable": 34}] | internal | 4816 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Portängens gruppfamiljedaghem on pieni ryhmäperhepäiväkoti, jossa on kotoinen tunnelma. Meillä on 8 lapsen ryhmä 1-5 vuotiaille jota vetää 2 aikuista.Olemme turvallisessa ja luonnonläheisessä ympäristössä Mankkaalla, jossa meillä on paljon aktiviteetteja lähiympäristössä. Viihdymme metsässä, käymme kirjastossa ja lähipuistoissa.Meillä on hyvä yhteityö Portängens daghemin kanssa. Siellä meillä on mahdollisuus käyttää tiloja ja yhdessä viettää juhlapäiviä. Meillä on mukava ja aktiivinen vanhempainyhdistys.Portängens gruppfamiljedaghem on perustettu 1987 ja se sijaitsee entisessä talonmiehen rakennuksessa. | Portängens gruppfamiljedaghem | Porttiniityntie 12 | Portängsvägen 12 | Porttiniityntie 12 | https://www.esbo.fi/sv-FI/Utbildning_och_fostran/Smabarnspedagogik/Kommunal_smabarnspedagogik/Hagalund__Mattby__Olars/Portangens_gruppfamiljedaghem(3314) | https://www.esbo.fi/sv-FI/Utbildning_och_fostran/Smabarnspedagogik/Kommunal_smabarnspedagogik/Hagalund__Mattby__Olars/Portangens_gruppfamiljedaghem(3314) | https://www.esbo.fi/sv-FI/Utbildning_och_fostran/Smabarnspedagogik/Kommunal_smabarnspedagogik/Hagalund__Mattby__Olars/Portangens_gruppfamiljedaghem(3314) | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 46 877 1828 | +358 9 8163 0691 | marika.melen@espoo.fi | 2015-11-03T12:03:45+02:00 | 02180 | www.espoo.fi | kaikki | espoo | 2020-12-04T15:01:08.151253+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] | espoo | [882, 881, 964] | [604, 603] | {"sv": ["dagv\u00e5rd", "ruotsinkielinen p\u00e4iv\u00e4hoito", "daghem", "esbo stads daghem", "kommunal daghem", "daghem i mankans", "gruppfamiljedaghem", "gruppfamiljedaghem i mankans", "dagis"], "fi": ["ruotsinkielinen p\u00e4iv\u00e4hoito", "ruotsinkielinen p\u00e4iv\u00e4koti", "ruotsinkielinen ryhm\u00e4perhep\u00e4iv\u00e4koti", "ryhm\u00e4perhep\u00e4iv\u00e4koti mankkaalla"]} | Point | 24.768583 | 60.197723 | Portängens gruppfamiljedaghem | Portängens gruppfamiljedaghem on pieni ryhmäperhepäiväkoti, jossa on kotoinen tunnelma. Meillä on 8 lapsen ryhmä 1-5 vuotiaille jota vetää 2 aikuista. | 7 | 11 | 1 | 1 | 11 | Portängens gruppfamiljedaghem är litet och hemmalikt med hemtrevlig stämning. Vi är en grupp med 8 barn i ålder 1-5 och 2 vuxna. | Portängens gruppfamiljedaghem är litet och hemmalikt med hemtrevlig stämning. Vi är en grupp med 8 barn i ålder 1-5 och 2 vuxna.Vi befinner oss i en trygg och naturnära miljö i Mankans, med flera aktiviteter i vår närmiljö. Vi trivs i skogen, besöker bibliotek och parker i vår närhet.Vi har gott sammarbete med Portängens daghem, där vi har möjlighet att använda oss av utrymmen och fira högtider tillsammans. Vi har en trevlig och aktiv föräldraförening.Vi arbetar för en uppmuntrande och inspirerande atmosfär och bemöter alla barn jämnlikt. Hos oss är barnen en stor del av vår planering och genomförande av verksamhet och vi strävar långt efter barnens delaktighet, genom att lyssna på barnens behov och intressen.Våra målge en trygg och stimulerande omgivning och verksamhetlära barnen att ta hänsyn både till barn och vuxnahjälpa barnen att bli självständigastöda svenska språket genom sagor, rim och ramsortemainriktat arbetssättstöda barnens utveckling genom rörelse och rytmikett bra föräldrasamarbetePortängens gruppfamiljedaghem är grundat 1987. Våra utrymmen befinner sig i en f.d. gårdskarlsbyggnad. | 10 | ||||||||||||||||||||||||||||||||
20044 | [{"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": "false", "variable": 105}, {"value": "false", "variable": 44}, {"value": "true", "variable": 59}, {"value": "true", "variable": 92}, {"value": "false", "variable": 94}, {"value": "false", "variable": 97}, {"value": "false", "variable": 57}, {"value": "over_20mm", "variable": 56}, {"value": "no_handrails", "variable": 95}, {"value": "false", "variable": 70}, {"value": "false", "variable": 21}, {"value": "false", "variable": 103}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 52}, {"value": "indoor_facility", "variable": 500}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 25}, {"value": "false", "variable": 98}, {"value": "true", "variable": 37}, {"value": "false", "variable": 62}, {"value": "false", "variable": 22}, {"value": "no_handrails", "variable": 41}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 29}, {"value": "true", "variable": 50}, {"value": "false", "variable": 33}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 84}, {"value": "false", "variable": 5}, {"value": "false", "variable": 49}, {"value": "false", "variable": 79}, {"value": "true", "variable": 38}, {"value": "true", "variable": 51}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 107}, {"value": "sufficiently_wide", "variable": 18}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "false", "variable": 20}, {"value": "0", "variable": 1}, {"value": "2_consecutive_steps", "variable": 24}, {"value": "false", "variable": 102}, {"value": "false", "variable": 28}, {"value": "true", "variable": 23}, {"value": "false", "variable": 83}, {"value": "false", "variable": 43}, {"value": "2_consecutive_steps", "variable": 93}, {"value": "false", "variable": 48}, {"value": "rough", "variable": 17}, {"value": "2", "variable": 64}, {"value": "false", "variable": 40}, {"value": "false", "variable": 34}, {"value": "false", "varia… | internal | 5838 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kattilaniemen leirikeskus | Kattilajärventie 30 | Kattilajärvivägen 30 | Kattilajärventie 30 | http://www.espoo.fi/fi-FI/Nuoret/Vuokrattavia_tiloja_ja_avustuksia/Vuokrattavat_tilat | http://www.espoo.fi/fi-FI/Nuoret/Vuokrattavia_tiloja_ja_avustuksia/Vuokrattavat_tilat | http://www.espoo.fi/fi-FI/Nuoret/Vuokrattavia_tiloja_ja_avustuksia/Vuokrattavat_tilat | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 322 3568 | nuoriso@espoo.fi | +358 9 8162 6753 | nuoriso@espoo.fi | 2015-11-03T12:03:45+02:00 | 02820 | www.espoo.fi | kaikki | espoo | 2020-11-12T12:30:59.615301+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 | [426, 154, 263, 510, 458] | [803, 580, 391] | {"fi": ["kattila", "kattis"]} | Point | 24.62174 | 60.298695 | 12 | 11 | 1 | 1 | 11 | 16 | ||||||||||||||||||||||||||||||||||||
20303 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 48}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 49}, {"value": "true", "variable": 37}, {"value": "1_step", "variable": 24}, {"value": "true", "variable": 23}, {"value": "false", "variable": 103}, {"value": "false", "variable": 79}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 62}, {"value": "false", "variable": 104}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 29}, {"value": "true", "variable": 59}, {"value": "true", "variable": 57}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 50}, {"value": "false", "variable": 52}, {"value": "false", "variable": 21}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 34}, {"value": "false", "variable": 105}, {"value": "false", "variable": 102}, {"value": "false", "variable": 84}, {"value": "true", "variable": 92}, {"value": "1_step", "variable": 39}, {"value": "0", "variable": 1}, {"value": "true", "variable": 38}, {"value": "true", "variable": 51}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 5}, {"value": "false", "variable": 44}, {"value": "soft", "variable": 17}, {"value": "false", "variable": 20}, {"value": "false", "variable": 58}, {"value": "false", "variable": 22}, {"value": "false", "variable": 107}, {"value": "over_20mm", "variable": 91}, {"value": "1_step", "variable": 93}, {"value": "false", "variable": 33}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 98}, {"value": "false", "variable": 83}] | internal | 5873 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kissankulma ryhmäperhepäiväkoti | Laaksolahdentie 1 A | Dalsvikvägen 1 A | Laaksolahdentie 1 A | http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Perhe_ja_ryhmaperhepaivahoito/Leppavaara/Ryhmaperhepaivahoito | http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Perhe_ja_ryhmaperhepaivahoito/Leppavaara/Ryhmaperhepaivahoito | http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Perhe_ja_ryhmaperhepaivahoito/Leppavaara/Ryhmaperhepaivahoito | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 46 877 1502 | sirkka.lehto@espoo.fi | 2015-11-03T12:03:45+02:00 | 02720 | www.espoo.fi | kaikki | espoo | 2020-03-13T09:31:11.847954+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] | espoo | [871, 870, 963] | [664, 663] | {"fi": ["ryhmis", "lastentarha"]} | Point | 24.747349 | 60.240055 | päiväkotiryhmäperhepäiväkoti | 4 | 11 | 1 | 1 | 11 | 6 | |||||||||||||||||||||||||||||||||||||
33158 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 79}, {"value": "false", "variable": 103}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "1_step", "variable": 24}, {"value": "false", "variable": 33}, {"value": "false", "variable": 92}, {"value": "false", "variable": 98}, {"value": "false", "variable": 21}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 102}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 104}, {"value": "1_step", "variable": 39}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 20}, {"value": "false", "variable": 83}, {"value": "true", "variable": 114}, {"value": "false", "variable": 115}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 62}, {"value": "true", "variable": 23}, {"value": "true", "variable": 37}, {"value": "true", "variable": 57}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 22}, {"value": "false", "variable": 44}, {"value": "false", "variable": 48}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 38}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 34}, {"value": "false", "variable": 117}, {"value": "false", "variable": 105}, {"value": "false", "variable": 116}, {"value": "0", "variable": 1}, {"value": "false", "variable": 109}, {"value": "true", "variable": 59}, {"value": "false", "variable": 51}, {"value": "true", "variable": 6}, {"value": "true", "variable": 107}, {"value": "false", "variable": 113}, {"value": "false", "variable": 58}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 5}, {"value": "true", "variable": 50}, {"value": "false", "variable": 52}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 49}, {"value": "false", "variable": 84}, {"value": "false", "variable": 112}, {"value": "false", "variable": 29}] | internal | 15469 | 828201f3-df6c-42e5-8239-fac577c3b248 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Auroran tehostettu perhetyö ja tukityö | Lippajärventie 44 D 1 | Klappträskvägen 44 D 1 | http://www.espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Lapsiperheiden_palvelut/Lastensuojelu/Sijaishuolto | http://www.esbo.fi/sv-FI/Social_och_halsovard/Tjanster_for_barnfamiljer/Barnskydd/Vard_av_barn_utom_hemmet | http://www.espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Lapsiperheiden_palvelut/Lastensuojelu/Sijaishuolto | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8163 0426 | +358 9 8163 0426 | kari.hurme@espoo.fi | 2015-11-03T12:03:45+02:00 | 02070 | www.espoo.fi | kaikki | espoo | 2020-03-13T09:31:30.865241+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] | espoo | [789] | [380] | {"fi": ["sijaishuolto"]} | Point | 24.715841 | 60.23174 | 4 | 11 | 1 | 1 | 11 | 4 | ||||||||||||||||||||||||||||||||||||||
43924 | [{"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", "sv": "Information g\u00e4llande reservationer av skolornas utrymmen p\u00e5 kv\u00e4llar och helger: gymnastiksalar 09 310 87800, \u00f6vriga utrymmen 09 310 12001"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "ruotsinkielinen perusopetus luokille 1-5", "sv": "grundl\u00e4ggande utbildning p\u00e5 svenska f\u00f6r \u00e5rskurserna 1-5", "en": "basic education for grades 1-5 in Swedish"}, "www": null, "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": "no_handrails", "variable": 26}, {"value": "false", "variable": 22}, {"value": "true", "variable": 37}, {"value": "no_handrails", "variable": 41}, {"value": "false", "variable": 49}, {"value": "true", "variable": 105}, {"value": "true", "variable": 25}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 79}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 51}, {"value": "true", "variable": 50}, {"value": "true", "variable": 5}, {"value": "false", "variable": 106}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 94}, {"value": "false", "variable": 21}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 48}, {"value": "true", "variable": 40}, {"value": "true", "variable": 59}, {"value": "false", "variable": 97}, {"value": "true", "variable": 92}, {"value": "false", "variable": 44}, {"value": "false", "variable": 6}, {"value": "false", "variable": 58}, {"value": "false", "variable": 102}, {"value": "false", "variable": 104}, {"value": "2_consecutive_steps", "variable": 24}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 70}, {"value": "false", "variable": 53}, {"value": "false", "variable": 28}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 52}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 62}, {"value": "false", "variable": 34}, {"value": "false", "variable": 96}, {"value": "7", "variable": 64}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "true", "variable": 23}, {"value": "true", "variable": 20}, {"value": "false", "variable": 33}, {"value": "true", "variable": 38}, {"value": "false", "variable": 43}, {"value": "sufficiently_wide", "variable": 18}, {"value": "0", "variable": 1}, {"value": "false", "variable": 98}, {"value": "false", "variable": 84}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 29}, {"value": "false… | internal | 20696 | e61d617e-26a0-4fd1-b7db-ccebfecfb95b | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hoplaxskolan: Munksnäs-enheten 0-5 | Hoplaxskolan: Munksnäs-enheten 0-5 | Lokkalantie 9 | Locklaisvägen 9 | Lokkalantie 9 | https://www.hel.fi/peruskoulut/sv/skolor/hoplaxskolan/hoplaxskolan | https://www.hel.fi/peruskoulut/sv/skolor/hoplaxskolan/hoplaxskolan | https://www.hel.fi/peruskoulut/sv/skolor/hoplaxskolan/hoplaxskolan | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 86678 | 2015-11-27T12:11:49+02:00 | 00330 | www.hel.fi | kaikki | helsinki | 2020-12-03T13:01:46.544945+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 | [1194, 1208, 1214, 2128, 1095, 2126, 1093, 1189] | [862, 601, 159, 33, 27, 24] | {"fi": ["eskari"], "en": ["basiceducation", "basic education"]} | Point | 24.880447 | 60.19969 | PL 33302, 00099 Helsingin kaupunki | Hoplaxskolan: Munksnäs-enheten 0-5 | 7 | 11 | 1 | P.O. Box 33302, 00099 City of Helsinki | 1 | 11 | PB 33302, 00099 Helsingfors stad | 14 |
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 );