4 rows where accessibility_shortcoming_count_stroller = 2 and accessibility_shortcoming_count_wheelchair = 11

View and edit SQL

accessibility_shortcoming_count_wheelchair

accessibility_shortcoming_count_stroller

identifiers_2_namespace

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
62 [{"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 44813", "contact_person": "Julin-Lumio Mia"}, {"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": "over_20mm", "variable": 56}, {"value": "2", "variable": 64}, {"value": "true", "variable": 105}, {"value": "true", "variable": 57}, {"value": "true", "variable": 59}, {"value": "0", "variable": 1}, {"value": "false", "variable": 106}, {"value": "narrow", "variable": 18}, {"value": "false", "variable": 23}, {"value": "false", "variable": 98}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 44}, {"value": "false", "variable": 62}, {"value": "false", "variable": 107}, {"value": "false", "variable": 48}, {"value": "true", "variable": 51}, {"value": "true", "variable": 52}, {"value": "false", "variable": 102}, {"value": "false", "variable": 79}, {"value": "false", "variable": 5}, {"value": "false", "variable": 49}, {"value": "false", "variable": 92}, {"value": "false", "variable": 83}, {"value": "false", "variable": 84}, {"value": "true", "variable": 22}, {"value": "false", "variable": 103}, {"value": "false", "variable": 58}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 20}, {"value": "false", "variable": 50}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 29}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 33}, {"value": "false", "variable": 34}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 53}, {"value": "false", "variable": 38}, {"value": "false", "variable": 70}, {"value": "rough", "variable": 17}, {"value": "true", "variable": 104}, {"value": "true", "variable": 37}, {"value": "false", "variable": 21}] internal 396     d5945a79-ff50-4823-b320-187b22f4f41c 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Daghemmet Ågeli Day care Ågeli Kivalterinpolku 3 Gevaldigerstigen 3 Kivalterinpolku 3 https://www.hel.fi/varhaiskasvatus/sv/daghem/ageli https://www.hel.fi/varhaiskasvatus/sv/daghem/ageli https://www.hel.fi/varhaiskasvatus/sv/daghem/ageli   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 44869, +358 40 334 4367 +358 9 310 44813 +358 9 310 44869 pk.ageli@hel.fi https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/sv/respons-kontakt/daghem/dh-ageli 2007-11-15T00:00:00+02:00 00640 www.hel.fi kaikki helsinki 2020-12-03T13:00:51.823425+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1405] helsinki [882, 881] [603] {"fi": ["varhaiskasvatus", "tarha"], "en": ["daycare", "day care"]} Point 24.957916 60.23089 PL 64311, 00099 Helsingin kaupunki         Daghemmet Ågeli   6 11     2 P.O. Box 64311, 00099 City of Helsinki 1     11   PB 64311, 00099 Helsingfors stad     7      
15470 [{"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": 102}, {"value": "false", "variable": 37}, {"value": "false", "variable": 21}, {"value": "true", "variable": 51}, {"value": "false", "variable": 53}, {"value": "false", "variable": 5}, {"value": "false", "variable": 48}, {"value": "false", "variable": 107}, {"value": "true", "variable": 105}, {"value": "false", "variable": 79}, {"value": "1_step", "variable": 24}, {"value": "true", "variable": 52}, {"value": "true", "variable": 59}, {"value": "false", "variable": 103}, {"value": "true", "variable": 23}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 35}, {"value": "false", "variable": 83}, {"value": "false", "variable": 57}, {"value": "false", "variable": 104}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "false", "variable": 44}, {"value": "false", "variable": 84}, {"value": "false", "variable": 92}, {"value": "false", "variable": 33}, {"value": "rough", "variable": 17}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 38}, {"value": "indoor_facility", "variable": 500}, {"value": "0", "variable": 1}, {"value": "true", "variable": 22}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 29}, {"value": "false", "variable": 106}, {"value": "false", "variable": 98}, {"value": "false", "variable": 49}, {"value": "long_term_stay", "variable": 60}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "narrow", "variable": 18}, {"value": "false", "variable": 34}, {"value": "false", "variable": 50}, {"value": "true", "variable": 62}, {"value": "true", "variable": 20}, {"value": "1_step", "variable": 39}] internal 4778     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 Hovinarri   Hovitie 23 B 9 Hovvägen 23 B 9 Hovitie 23 B 9 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 1509   +358 9 8164 3569     2015-11-03T12:03:45+02:00 02940 www.espoo.fi kaikki espoo 2020-03-13T09:31:05.558703+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\u00e4hoito", "lastentarha"]} Point 24.703339 60.242374 PL 94305, 02070 ESPOON KAUPUNKI             5 11     2 P.O. Box 94305, 02070 ESPOON KAUPUNKI 1     11   PB 94305, 02070 ESPOON KAUPUNKI     8      
18264 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-to 08-16, pe 08-15", "sv": "\u00f6ppet m\u00e5n-tor 08-16, fre 08-15", "en": "open Mon-Thu 08-16, Fri 08-15"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodin johtaja"}, "www": null, "email": "eeva.pursimo@vantaa.fi", "phone": "+358 50 310 5978", "contact_person": "Eeva Pursimo"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Asukaspuisto"}, "www": null, "email": null, "phone": "+358 50 318 1446", "contact_person": "Korson asukaspuisto"}, {"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}, {"section_type": "LINK", "name": {"fi": "Korson asukaspuiston nettisivut"}, "www": {"fi": "https://sivistysvantaa.fi/korsonasukaspuisto/index.html", "sv": "https://sivistysvantaa.fi/korsonasukaspuisto/index.html", "en": "https://sivistysvantaa.fi/korsonasukaspuisto/index.html"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Korson asukaspuiston Facebook -sivut"}, "www": {"fi": "https://www.facebook.com/Korson-Asukaspuisto-131748693662193/", "sv": "https://www.facebook.com/Korson-Asukaspuisto-131748693662193/", "en": "https://www.facebook.com/Korson-Asukaspuisto-131748693662193/"}, "email": null, "phone": null, "contact_person": null}] [{"value": "ramp_under_6m_long", "variable": 45}, {"value": "false", "variable": 106}, {"value": "true", "variable": 22}, {"value": "true", "variable": 57}, {"value": "true", "variable": 37}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 84}, {"value": "false", "variable": 46}, {"value": "no_handrails", "variable": 41}, {"value": "true", "variable": 104}, {"value": "false", "variable": 53}, {"value": "true", "variable": 44}, {"value": "true", "variable": 62}, {"value": "false", "variable": 92}, {"value": "false", "variable": 33}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 29}, {"value": "false", "variable": 58}, {"value": "false", "variable": 50}, {"value": "false", "variable": 103}, {"value": "false", "variable": 34}, {"value": "false", "variable": 83}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 40}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 52}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 5}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "false", "variable": 49}, {"value": "true", "variable": 51}, {"value": "true", "variable": 20}, {"value": "no_handrails", "variable": 47}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 79}, {"value": "false", "variable": 98}, {"value": "false", "variable": 107}, {"value": "false", "variable": 43}, {"value": "true", "variable": 59}, {"value": "false", "variable": 102}, {"value": "0", "variable": 1}, {"value": "false", "variable": 48}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 105}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 21}, {"value": "true", "variable": 38}, {"value": "false", "variable": 23}] internal 5196     ab4f37d0-3e53-462e-ad40-c73b57e3e39e 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1             Korson asukaspuisto järjestämme kerhotoimintaa ja avointa toimintaa.     Korson asukaspuisto Korson asukaspuisto Korsontie 11 Korsovägen 11 Korsontie 11 http://www.vantaa.fi/varhaiskasvatus_ja_koulutus/varhaiskasvatus/palvelut/asukaspuistot_ja_avoimet_paivakodit/korso http://www.vanda.fi/smabarnspedagogik_och_utbildning/smabarnspedagogik/olika_alternativ/klubbar_och_oppna_daghem http://www.vantaa.fi/day_care_and_education/early_childhood_education/early_childhood_education_options/residential_parks_and_open_day_care_centers   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 839 11   +358 50 318 1446   USRHSELGRU 2014-11-19T17:01:21+02:00 01450 www.vantaa.fi kaikki vantaa 2020-11-05T16:31:11.351330+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1400, 1403, 1405] vantaa [976, 978, 69, 500, 981] [475, 288, 86] {"fi": ["asukaspuisto", "kerhotoiminta", "avoin varhaiskasvatus"]} Point 25.06948 60.353107 PL 6551, 01030 Vantaan kaupunki         Korson asukaspuisto Korson asukaspuisto järjestämme kerhotoimintaa ja avointa toimintaa. 7 11     2 P.O. Box 6551, 01030 City of Vantaa 1     10   PB 6551, 01030 Vanda stad     6      
18788 [{"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": "Aukioloaika on klo 6-18 ennalta sovitun tarpeen mukaan."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodin johtaja"}, "www": null, "email": "johanna.sandholm@vantaa.fi", "phone": "+358 43 825 4750", "contact_person": "Johanna Sandholm"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4t"}, "www": null, "email": "pk.ita-hakkila@vantaa.fi", "phone": "+358 50 314 5706", "contact_person": "Auringons\u00e4teet ja Kuunsirpit"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4t"}, "www": null, "email": "pk.ita-hakkila@vantaa.fi", "phone": "+358 50 312 1713", "contact_person": "Lounatuulet ja P\u00e4iv\u00e4ns\u00e4teet"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4t"}, "www": null, "email": "pk.ita-hakkila@vantaa.fi", "phone": "+358 50 304 1997", "contact_person": "Kumpupilvet ja Poutapilvet"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.ita-hakkila@vantaa.fi", "phone": "+358 50 3030 8744", "contact_person": "Revontulet"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4t"}, "www": null, "email": "pk.ita-hakkila@vantaa.fi", "phone": "+358 50 312 1604", "contact_person": "T\u00e4hdenlennot ja T\u00e4htisumut"}, {"section_type": "LINK", "name": {"fi": "Anna palautetta", "sv": "Ber\u00e4tt\u00e4 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": "false", "variable": 92}, {"value": "true", "variable": 107}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "2_consecutive_steps", "variable": 24}, {"value": "false", "variable": 50}, {"value": "false", "variable": 103}, {"value": "false", "variable": 84}, {"value": "true", "variable": 23}, {"value": "false", "variable": 28}, {"value": "true", "variable": 37}, {"value": "true", "variable": 25}, {"value": "false", "variable": 52}, {"value": "soft", "variable": 17}, {"value": "false", "variable": 115}, {"value": "true", "variable": 20}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 44}, {"value": "true", "variable": 62}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 79}, {"value": "false", "variable": 38}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 58}, {"value": "false", "variable": 112}, {"value": "no_handrails", "variable": 32}, {"value": "true", "variable": 59}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 57}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 105}, {"value": "true", "variable": 22}, {"value": "sufficiently_wide", "variable": 18}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 48}, {"value": "false", "variable": 33}, {"value": "false", "variable": 49}, {"value": "true", "variable": 114}, {"value": "on_door", "variable": 110}, {"value": "false", "variable": 117}, {"value": "false", "variable": 111}, {"value": "false", "variable": 83}, {"value": "0", "variable": 1}, {"value": "true", "variable": 109}, {"value": "true", "variable": 113}, {"value": "false", "variable": 98}, {"value": "true", "variable": 104}, {"value": "true", "variable": 116}, {"value": "false", "variable": 31}, {"value": "false", "variable": 102}, {"value": "true", "variable": 29}, {"value": "false", "variable": 5}… internal 5286     ab4f37d0-3e53-462e-ad40-c73b57e3e39e 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1             Päiväkotimme tarjoaa varhaiskasvatusta ja esiopetusta kahdeksassa lapsiryhmässä sekä kerhotoimintaa jokaisena arkipäivänä.Päiväkodissa on kahdeksan ryhmää ja kerhoryhmä. Kerhotoimintaa jokaisena arkipäivänä klo 8.30-11 (2-3 -vuotiaat) ja klo 12-15 (4-5 -vuotiaat).Päiväkotimme sijaitsee viihtyisässä kasvuympäristössä metsän ympäröimänä. Toiminta-ajatuksenamme on tarjota lapselle kokemuksellista ja elämyksellistä varhaiskasvatusta yhteistyössä vanhempien kanssa. Tarjoamme monipuolista toimintaa, sopivasti haasteita ja onnistumisen kokemuksia kaikille. Päiväkodissamme lapsia ohjaavat motivoituneet ja ammattitaitoiset kasvattajat, joilla on halu kehittää työtä ja intoa uusille asioille. Pidämme tärkeänä, että vanhemmat voivat luottavaisin ja rauhallisin mielin tuoda lapsensa meille päivähoitoon.     Itä-Hakkilan päiväkoti Itä-Hakkilan päiväkoti Keskustie 1-3 Centralvägen 1-3 Keskustie 1-3 https://www.vantaa.fi/varhaiskasvatus_ja_koulutus/varhaiskasvatus/palvelut/paivakodit/hakunila/ita-hakkilan_paivakoti https://www.vanda.fi/smabarnspedagogik_och_utbildning/smabarnspedagogik/olika_alternativ/daghem https://www.vantaa.fi/day_care_and_education/early_childhood_education/early_childhood_education_options/day_care_centers   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 839 11   +358 9 8393 0871 etunimi.sukunimi@vantaa.fi   2014-11-19T17:01:21+02:00 01260 www.vantaa.fi kaikki vantaa 2020-11-05T16:31:12.910009+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, 978, 1090, 2125, 871, 1089, 2122, 870] [861, 663, 288, 160] {"fi": ["varhaiskasvatus", "p\u00e4iv\u00e4koti", "kerho", "p\u00e4iv\u00e4hoito", "esiopetus", "eskari", "tarha", "lastentarha"]} Point 25.111595 60.29504 PL 8421, 01030 Vantaan kaupunki         Itä-Hakkilan päiväkoti Päiväkotimme tarjoaa varhaiskasvatusta ja esiopetusta kahdeksassa lapsiryhmässä sekä kerhotoimintaa jokaisena arkipäivänä. 7 11     2 P.O. Box 8421, 01030 City of Vantaa 1     10   PB 8421, 01030 Vanda stad     4      

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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
);