10 rows where accessibility_shortcoming_count_visually_impaired = 7 and accessibility_shortcoming_count_wheelchair = 1

View and edit SQL

Suggested facets: municipality

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
326 [{"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 47204", "contact_person": "Pulliainen Kaisa"}, {"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": 23}, {"value": "false", "variable": 49}, {"value": "long_term_stay", "variable": 60}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 105}, {"value": "false", "variable": 79}, {"value": "true", "variable": 115}, {"value": "true", "variable": 52}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "handrails_on_one_side", "variable": 32}, {"value": "false", "variable": 33}, {"value": "no_handrails", "variable": 41}, {"value": "true", "variable": 62}, {"value": "under_20mm", "variable": 91}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 114}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 112}, {"value": "false", "variable": 22}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 46}, {"value": "false", "variable": 98}, {"value": "true", "variable": 113}, {"value": "3_consecutive_steps", "variable": 39}, {"value": "smooth", "variable": 17}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 38}, {"value": "true", "variable": 37}, {"value": "floor_0", "variable": 108}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 44}, {"value": "0", "variable": 1}, {"value": "false", "variable": 83}, {"value": "true", "variable": 29}, {"value": "true", "variable": 109}, {"value": "true", "variable": 50}, {"value": "true", "variable": 20}, {"value": "true", "variable": 57}, {"value": "true", "variable": 40}, {"value": "true", "variable": 59}, {"value": "false", "variable": 92}, {"value": "false", "variable": 34}, {"value": "handrails_on_one_side", "variable": 47}, {"value": "false", "variable": 106}, {"value": "true", "variable": 58}, {"value": "requires_use_of_door_phone_opening_automatically", "variable": 54}, {"value": "false", "variable": 116}, {"value": "false", "variable": 111}, {"value": "true", "variable": 118}, {"value": "false", "variable": 48}, {"value": "true", "variable": 117}, {"value": "false", "variable": 53}, … internal 699     a1a3a5ea-39bd-482b-b90d-7dfc436c3afb 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Päiväkoti Pacius Day care Pacius Vesikuja 8 A Vattengränden 8 A Vesikuja 8 A https://www.hel.fi/varhaiskasvatus/fi/paivakodit/pacius https://www.hel.fi/varhaiskasvatus/fi/paivakodit/pacius https://www.hel.fi/varhaiskasvatus/fi/paivakodit/pacius   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 47204, +358 9 310 41787   +358 9 310 47206, +358 9 310 47204 pk.pacius@hel.fi   2007-11-15T00:00:00+02:00 00270 www.hel.fi kaikki helsinki 2020-12-03T13:00:53.999234+02:00 {"00": null, "11": "green", "12": "red", "13": "green", "21": "red", "22": "red", "23": "red", "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", "eskari", "varhaiskasvatus", "tarha", "lastentarha", "Esiopetus 2021-2022"], "en": ["day care", "preprimaryeducation", "pre-primary education", "preschool", "daycare"]} Point 24.893631 60.196407 PL 27913, 00099 Helsingin kaupunki         Päiväkoti Pacius   2 1       P.O. Box 27913, 00099 City of Helsinki 1     1   PB 27913, 00099 Helsingfors stad     7      
4215 [{"section_type": "HIGHLIGHT", "name": {"fi": "Jos sinulla on koronavirustartunnan oireita ja tarvitset toimintaohjeet, soita Helsingin koronavirusneuvontaan p. 09\u202f310 10024 (p\u00e4ivitt\u00e4in klo 8-18). Koronavirusneuvonnasta voit varata ajan koronavirustestiin. Sinut ohjataan my\u00f6s tarvittaessa koronaterveysasemalle.\nJos asia ei voi odottaa koronaneuvonnan aukeamista tai kyse on muusta kiireellisest\u00e4 sairaudesta, soita P\u00e4ivystysapuun, p. 116\u202f117.", "sv": "Om du har symtom p\u00e5 coronavirus och beh\u00f6ver r\u00e5d om vad du ska g\u00f6ra, ring Helsingfors coronavirusr\u00e5dgivning p\u00e5 09 310 10024 (dagligen kl. 8-18). Via coronavirusr\u00e5dgivningen kan du boka tid f\u00f6r ett coronavirustest. Vid behov kan du ocks\u00e5 h\u00e4nvisas till en h\u00e4lsostation f\u00f6r coronapatienter.\nOm \u00e4rendet inte kan v\u00e4nta tills coronavirusr\u00e5dgivningen \u00f6ppnar eller om det \u00e4r fr\u00e5ga om n\u00e5gon annan akut sjukdom, betj\u00e4nar jourhj\u00e4lpen p\u00e5 tfn 116 117.", "en": "If you have symptoms indicative of a coronavirus infection and need instructions on what to do, call Helsinki's Coronavirus Helpline, open every day of the week from 8 am to 6 pm at tel. 09 310 10024. You can book an appointment for a coronavirus test via the helpline. If necessary, you will also be directed to a coronavirus health station.\nIf you cannot wait for the Coronavirus Helpline to open or need assistance with an urgent health concern, please contact the Medical Helpline at tel. 116 11"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_ADDRESS", "name": {"fi": "Sis\u00e4taudit L\u00e4\u00e4k\u00e4rinkatu 6 B"}, "www": null, "email": null, "phone": null, "contact_person": null}] [{"value": "true", "variable": 74}, {"value": "false", "variable": 103}, {"value": "false", "variable": 82}, {"value": "true", "variable": 100}, {"value": "true", "variable": 113}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 114}, {"value": "false", "variable": 44}, {"value": "true", "variable": 20}, {"value": "true", "variable": 76}, {"value": "false", "variable": 33}, {"value": "false", "variable": 83}, {"value": "true", "variable": 117}, {"value": "true", "variable": 58}, {"value": "false", "variable": 22}, {"value": "false", "variable": 84}, {"value": "false", "variable": 79}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "less_than_3600mm", "variable": 3}, {"value": "false", "variable": 59}, {"value": "true", "variable": 72}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 75}, {"value": "false", "variable": 29}, {"value": "true", "variable": 104}, {"value": "ramp_under_6m_long", "variable": 99}, {"value": "true", "variable": 73}, {"value": "true", "variable": 57}, {"value": "false", "variable": 23}, {"value": "true", "variable": 50}, {"value": "false", "variable": 21}, {"value": "true", "variable": 6}, {"value": "no_handrails", "variable": 101}, {"value": "true", "variable": 98}, {"value": "true", "variable": 105}, {"value": "false", "variable": 48}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 34}, {"value": "true", "variable": 70}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 92}, {"value": "false", "variable": 106}, {"value": "false", "variable": 102}, {"value": "8", "variable": 1}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 53}, {"value": "floor_4", "variable": 108}, {"value": "true", "variable": 52}, {"value": "true", "variable": 115}, {"value": "guided_and_clear", "variable": 19}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 37}, {"value": "opens_automatically", "variable": 77}, {"value": "suffic… internal 1805     d4b3a166-9fa0-4846-9d63-ff1fdab670b6 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1           https://maps.google.fi/?q=http:%2F%2Fwww.hel.fi%2Fpalvelukartta%2Fkml.aspx%3Flang%3Dfi%26id%3D4215&ll=60.193169,24.917593&spn=0.002043,0.014699&layer=c&cbll=60.193168,24.917597&cbp=12,201.2,,0,-3.22&t=h&z=17&panoid=N4TfotP_A6CHg4UFqa3j5Q       Laakson sisätautien poliklinikka Laakso Consultation Outpatient Clinic Lääkärinkatu 8 Läkaregatan 8 Lääkärinkatu 8 https://www.hel.fi/Helsinki/fi/sosiaali-ja-terveyspalvelut/terveyspalvelut/sairaalat/laakson-sairaala/ https://www.hel.fi/Helsinki/fi/sosiaali-ja-terveyspalvelut/terveyspalvelut/sairaalat/laakson-sairaala/ https://www.hel.fi/Helsinki/fi/sosiaali-ja-terveyspalvelut/terveyspalvelut/sairaalat/laakson-sairaala/   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 4701 +358 9 310 47690 +358 9 310 47744 neuvonta.laakso@hel.fi   2008-07-10T22:13:17+03:00 00250 www.hel.fi kaikki helsinki 2020-12-29T12:00:48.237803+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"} [986] helsinki [1015] [610] {} Point 24.917477 60.193058 PL 6600, 00099 Helsingin kaupunki         Dals inremedicinska poliklinik   1 1       P.O. Box 6600, 00099 City of Helsinki 1     1   PB 6600, 00099 Helsingfors stad     7      
5347 [{"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": 21}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 92}, {"value": "true", "variable": 107}, {"value": "true", "variable": 50}, {"value": "false", "variable": 23}, {"value": "true", "variable": 73}, {"value": "false", "variable": 116}, {"value": "false", "variable": 51}, {"value": "true", "variable": 117}, {"value": "false", "variable": 34}, {"value": "false", "variable": 102}, {"value": "true", "variable": 37}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 6}, {"value": "true", "variable": 57}, {"value": "over_10m", "variable": 4}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "false", "variable": 62}, {"value": "true", "variable": 115}, {"value": "true", "variable": 5}, {"value": "less_than_3600mm", "variable": 3}, {"value": "false", "variable": 104}, {"value": "false", "variable": 44}, {"value": "floor_2", "variable": 120}, {"value": "false", "variable": 79}, {"value": "4", "variable": 64}, {"value": "false", "variable": 98}, {"value": "true", "variable": 112}, {"value": "true", "variable": 114}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 113}, {"value": "false", "variable": 33}, {"value": "8", "variable": 1}, {"value": "false", "variable": 38}, {"value": "true", "variable": 59}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 74}, {"value": "false", "variable": 22}, {"value": "true", "variable": 58}, {"value": "false", "variable": 75}, {"value": "false", "variable": 106}, {"value": "true", "variable": 20}, {"value": "false", "variable": 118}, {"value": "true", "variable": 70}, {"value": "floor_0", "variable": 108}, {"value": "true", "variable": 76}, {"value": "false", "variable": 48}, {"value": "floor_1", "variable": 119}, {"value": "false", "variable": 103}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 72}, {"value": "opens_automatically", "variable": 77}, {"value": "false", "variable": 53}, {"value":… internal 2197     d4b3a166-9fa0-4846-9d63-ff1fdab670b6 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1           https://maps.google.fi/?q=http:%2F%2Fwww.hel.fi%2Fpalvelukartta%2Fkml.aspx%3Flang%3Dfi%26id%3D5347&ll=60.193169,24.917593&spn=0.002043,0.014699&layer=c&cbll=60.193168,24.917597&cbp=12,201.2,,0,-3.22&t=h&z=17&panoid=N4TfotP_A6CHg4UFqa3j5Q       Laakson vuodeosastot Laakso Hospital Acute Wards Lääkärinkatu 8 Läkaregatan 8 Lääkärinkatu 8         pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 4701 +358 9 310 47400 +358 9 310 47744 neuvonta.laakso@hel.fi   2008-07-10T22:13:17+03:00 00250 www.hel.fi kaikki helsinki 2020-11-27T13:01:04.546881+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": null} [986] helsinki [1012] [264] {} Point 24.917477 60.193058 PL 6600, 00099 Helsingin kaupunki         Dals vårdavdelningar   1 1       P.O. Box 6600, 00099 City of Helsinki       1   PB 6600, 00099 Helsingfors stad     7      
6302 [{"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": "true", "variable": 37}, {"value": "true", "variable": 107}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "true", "variable": 117}, {"value": "false", "variable": 62}, {"value": "false", "variable": 82}, {"value": "false", "variable": 59}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 45}, {"value": "true", "variable": 75}, {"value": "false", "variable": 53}, {"value": "true", "variable": 104}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 92}, {"value": "true", "variable": 50}, {"value": "false", "variable": 106}, {"value": "false", "variable": 103}, {"value": "0", "variable": 1}, {"value": "true", "variable": 35}, {"value": "true", "variable": 105}, {"value": "opens_automatically_with_button", "variable": 54}, {"value": "true", "variable": 80}, {"value": "true", "variable": 29}, {"value": "true", "variable": 73}, {"value": "false", "variable": 34}, {"value": "true", "variable": 57}, {"value": "false", "variable": 84}, {"value": "false", "variable": 31}, {"value": "true", "variable": 70}, {"value": "true", "variable": 113}, {"value": "opens_with_access_control_key", "variable": 77}, {"value": "true", "variable": 6}, {"value": "false", "variable": 21}, {"value": "floor_0", "variable": 108}, {"value": "handrails_on_both_sides", "variable": 47}, {"value": "false", "variable": 79}, {"value": "true", "variable": 118}, {"value": "true", "variable": 74}, {"value": "false", "variable": 51}, {"value": "false", "variable": 49}, {"value": "true", "variable": 72}, {"value": "false", "variable": 33}, {"value": "false", "variable": 102}, {"value": "true", "variable": 78}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 98}, {"value": "false", "variable": 116}, {"value": "false", "variable": 23}, {"value": "false", "variable": 76}, {"value": "handrails_on_both_sides", "variable": 32}, {"value": "1", "variable": 63}, {"value": "true", "variable": 20}, {"value": "true", "variable": 58}, {"value": "false", "variab… internal 2738     d4b3a166-9fa0-4846-9d63-ff1fdab670b6 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Tahvonlahden ala-aste, kouluterveydenhuolto Tahvonlahti Comprehensive School, Lower Stage, school health care Gunillankuja 3 Gunillagränden 3 Gunillankuja 3         pvm/mpm lna/msa local network charge/mobile call charge   +358 50 402 2743   +358 50 310 5581 Johanna.Helenius@hel.fi   2008-07-10T22:13:17+03:00 00870 www.hel.fi kaikki helsinki 2020-11-27T13:01:05.988512+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"} [986, 1087] helsinki [2164, 2165] [339] {} Point 25.03653 60.166897 PL 87301, 00099 Helsingin kaupunki         Lågstadieskolan Tahvonlahden ala-aste, skolhälsovård   1 1       P.O. Box 87301, 00099 City of Helsinki 1     1   PB 87301, 00099 Helsingfors stad     7      
15798 [{"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": 57}, {"value": "0", "variable": 1}, {"value": "false", "variable": 22}, {"value": "ramp_under_6m_long", "variable": 99}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 102}, {"value": "true", "variable": 114}, {"value": "true", "variable": 59}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 23}, {"value": "false", "variable": 31}, {"value": "true", "variable": 6}, {"value": "false", "variable": 38}, {"value": "false", "variable": 48}, {"value": "false", "variable": 33}, {"value": "true", "variable": 109}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 103}, {"value": "true", "variable": 52}, {"value": "true", "variable": 20}, {"value": "true", "variable": 117}, {"value": "false", "variable": 106}, {"value": "true", "variable": 112}, {"value": "true", "variable": 29}, {"value": "true", "variable": 37}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "false", "variable": 46}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "handrails_on_one_side", "variable": 47}, {"value": "true", "variable": 118}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 62}, {"value": "false", "variable": 116}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 79}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "false", "variable": 51}, {"value": "true", "variable": 5}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 107}, {"value": "false", "variable": 49}, {"value": "true", "variable": 115}, {"value": "handrails_on_one_side", "variable": 32}, {"value": "false", "variable": 100}, {"value": "false", "variable": 53}, {"value": "false", "variable": 104}, {"value": "true", "variable": 98}, {"value": "handrails_on_one_side", "variable": 101}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 21}, {"value": "true", "variable": 113}, {"value": "true", "variable": 44}, {"value": … internal 4675     d8dab34f-a68f-4244-b906-84e7f651b8e1 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Lintulan päiväkoti   Peipontie 3a Bofinksvägen 3a Peipontie 3a http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Kunnalliset_paivakodit/Leppavaara/Lintulan_paivakoti http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Kunnalliset_paivakodit/Leppavaara/Lintulan_paivakoti http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Kunnalliset_paivakodit/Leppavaara/Lintulan_paivakoti   pvm/mpm lna/msa local network charge/mobile call charge   +358 40 774 9998   +358 46 877 3595 sari-nina.kaidesoja@espoof.i   2015-11-03T12:03:45+02:00 02660 www.espoo.fi kaikki espoo 2020-03-13T09:31:07.162335+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"} [1405] espoo [871, 870] [663] {"fi": ["tarha", "lastentarha"]} Point 24.82129 60.23114             päiväkoti 1 1         1     1         7      
18841 [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://asiointi.vantaa.fi/anna-palautetta"}, "email": null, "phone": null, "contact_person": null}] [{"value": "true", "variable": 104}, {"value": "true", "variable": 37}, {"value": "false", "variable": 75}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 103}, {"value": "false", "variable": 105}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 22}, {"value": "false", "variable": 80}, {"value": "false", "variable": 78}, {"value": "true", "variable": 109}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "true", "variable": 107}, {"value": "false", "variable": 59}, {"value": "handrails_on_one_side", "variable": 101}, {"value": "false", "variable": 48}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 49}, {"value": "chairs_available", "variable": 81}, {"value": "true", "variable": 98}, {"value": "false", "variable": 21}, {"value": "true", "variable": 20}, {"value": "false", "variable": 116}, {"value": "true", "variable": 74}, {"value": "true", "variable": 76}, {"value": "ramp_under_6m_long", "variable": 99}, {"value": "opens_automatically", "variable": 77}, {"value": "on_door", "variable": 110}, {"value": "smooth", "variable": 17}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 102}, {"value": "false", "variable": 62}, {"value": "false", "variable": 5}, {"value": "true", "variable": 113}, {"value": "false", "variable": 117}, {"value": "true", "variable": 72}, {"value": "true", "variable": 73}, {"value": "false", "variable": 38}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 52}, {"value": "false", "variable": 51}, {"value": "true", "variable": 115}, {"value": "2", "variable": 63}, {"value": "at_least_3600mm", "variable": 3}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 111}, {"value": "false", "variable": 83}, {"value": "false", "variable": 29}, {"value": "true", "variable": 114}, {"value": "true", "variable": 57}, {"value": "false", "variable": 33}, {"value": "true", "variable": 70}, {"value": "false", "variable": 82}, {"v… internal 5173     751d7ecd-b8f3-40ad-b46e-2630fb31543c 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Perheoikeudellisten asioiden yksikkö Family Law Unit Peltolantie 2 D, 2. krs Peltolavägen 2 D, 2. vån. Peltolantie 2 D, 2. floor https://www.vantaa.fi/terveys-_ja_sosiaalipalvelut/lapsiperheiden_palvelut/perheoikeudelliset_asiat https://www.vanda.fi/halsovard_och_sociala_tjanster/tjanster_till_barnfamiljer/familjerattsliga_arenden https://www.vantaa.fi/health_care_and_social_services/support_for_families_with_children/family_law   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8393 5716         2014-11-19T17:01:21+02:00 01300 www.vantaa.fi kaikki vantaa 2020-06-24T11:31:10.777778+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"} [783] vantaa [792, 796] [505, 373] {} Point 25.031317 60.29338 PL 1701, 01030 Vantaan kaupunki         Enheten för familjerättsliga frågor Yksikkö palvelee isyyden vahvistamista, lapsen huoltajuutta, lapsen asumista ja tapaamisoikeutta elatusta koskevissa asioissa. 1 1       P.O. Box 1701, 01030 Vantaan kaupunki 1     1   PB 1701, 01030 Vantaan kaupunki Familjerättsliga ärenden berör utredning av faderskap, barnets vårdnad och boende, barnets umgängesrätt, barnets underhåll och adoption.   7 Issues related to family law entail establishing paternity, custody, living arrangements and right of access child's maintenance and adoption.    
19446 [{"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": 83}, {"value": "sufficiently_wide", "variable": 18}, {"value": "over_20mm", "variable": 56}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 109}, {"value": "false", "variable": 117}, {"value": "false", "variable": 102}, {"value": "true", "variable": 115}, {"value": "false", "variable": 104}, {"value": "true", "variable": 62}, {"value": "false", "variable": 44}, {"value": "false", "variable": 116}, {"value": "true", "variable": 107}, {"value": "false", "variable": 51}, {"value": "false", "variable": 92}, {"value": "true", "variable": 37}, {"value": "true", "variable": 5}, {"value": "true", "variable": 112}, {"value": "4", "variable": 1}, {"value": "false", "variable": 22}, {"value": "false", "variable": 34}, {"value": "false", "variable": 98}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 57}, {"value": "at_least_3600mm", "variable": 3}, {"value": "true", "variable": 114}, {"value": "true", "variable": 59}, {"value": "true", "variable": 20}, {"value": "false", "variable": 23}, {"value": "false", "variable": 106}, {"value": "false", "variable": 21}, {"value": "false", "variable": 53}, {"value": "true", "variable": 105}, {"value": "false", "variable": 33}, {"value": "outdoors", "variable": 2}, {"value": "true", "variable": 113}, {"value": "opens_automatically_with_button", "variable": 54}, {"value": "false", "variable": 29}, {"value": "true", "variable": 6}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 48}, {"value": "false", "variable": 79}, {"value": "true", "variable": 50}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 84}, {"value": "false", "variable": 38}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 52}, {"value": "true", "variable": 58}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 103}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "under_10m", "variable": 4}, {"value": "false",… internal 5391     d6c56752-dec1-4e56-9113-10975030cd75 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Keltamokoti Keltamokoti Savikkatie 13 Mållavägen 13   http://www.vantaa.fi/terveys-_ja_sosiaalipalvelut/vammaisten_palvelut/asuminen/asumisen_vaihtoehdot#Keltamokoti http://www.vanda.fi/halsovard_och_sociala_tjanster/tjanster_for_funktionshindrade http://www.vantaa.fi/en/social_and_health_care_services   pvm/mpm lna/msa local network charge/mobile call charge   +358 43 825 8096   +358 9 8392 0127 keltamokoti@vantaa.fi   2014-11-19T17:01:21+02:00 01300 www.vantaa.fi kaikki vantaa 2020-06-12T14:01:01.038338+03:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "green", "23": "green", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} [783] vantaa [847, 816, 803, 801] [751, 746, 276, 49] {"fi": ["asumispalvelu", "vammaispalvelu"], "sv": ["boendeservice", "handikappservice"], "en": ["housing service", "service for the disabled"]} Point 25.025677 60.295685 Savikkatie 13, 01300 Vantaa         Keltamokoti Tehostettu palveluasuminen vammaisille   1         1     1         7      
33084 [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Sosiaali- ja kriisip\u00e4ivystys"}, "www": null, "email": null, "phone": "+358 9 8392 4005", "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": 38}, {"value": "over_10m", "variable": 4}, {"value": "true", "variable": 74}, {"value": "false", "variable": 83}, {"value": "at_least_3600mm", "variable": 3}, {"value": "false", "variable": 117}, {"value": "false", "variable": 22}, {"value": "2", "variable": 63}, {"value": "false", "variable": 78}, {"value": "false", "variable": 5}, {"value": "opens_easily_manually", "variable": 54}, {"value": "opens_automatically", "variable": 77}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "true", "variable": 107}, {"value": "false", "variable": 33}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 79}, {"value": "false", "variable": 44}, {"value": "true", "variable": 20}, {"value": "false", "variable": 75}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 58}, {"value": "false", "variable": 82}, {"value": "true", "variable": 70}, {"value": "false", "variable": 49}, {"value": "false", "variable": 103}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 104}, {"value": "true", "variable": 115}, {"value": "false", "variable": 100}, {"value": "true", "variable": 112}, {"value": "true", "variable": 72}, {"value": "true", "variable": 114}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 62}, {"value": "false", "variable": 80}, {"value": "true", "variable": 113}, {"value": "false", "variable": 21}, {"value": "true", "variable": 76}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 37}, {"value": "ramp_under_6m_long", "variable": 99}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "true", "variable": 50}, {"value": "true", "variable": 98}, {"value": "false", "variable": 48}, {"value": "chairs_available", "variable": 81}, {"value": "handrails_on_one_side", "variable": 101}, {"value": "true", "variable": 53}, {"value": "false", "variable": 59}, {"value": "4", "variable": 1}, {"value": "false", "variable": 23}, {"value": "false", "variable": 34}, {"va… internal 15049     751d7ecd-b8f3-40ad-b46e-2630fb31543c 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Lastensuojelun virka-aikainen päivystys, Tikkurila   Vernissakatu 8 C Fernissagatan 8 C Vernissakatu 8 C http://www.vantaa.fi/terveys-_ja_sosiaalipalvelut/lapsiperheiden_palvelut/lastensuojelu http://www.vanda.fi/halsovard_och_sociala_tjanster/tjanster_till_barnfamiljer/barnskyddet http://www.vantaa.fi/health_care_and_social_services/support_for_families_with_children/child_welfare   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8393 3337         2014-11-19T17:01:21+02:00 01300 www.vantaa.fi kaikki vantaa 2020-11-05T16:31:36.718156+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"} [783] vantaa [788] [382] {} Point 25.031984 60.2934 Vernissakatu 8 C, 01300 Vantaa         Jouren, barnskyddet Sosiaalityöntekijät hoitavat lasten ja nuorten asioita. Tarjolla apua tilanteiden selvittelyyn, perheiden tukemiseen sekä neuvontaa ja ohjausta. 1 1       Vernissakatu 8 C, 01300 Vantaa 1     1   Fernissagatan 8 C, 01300 Vanda     7      
58560 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 09-14", "sv": "\u00f6ppet m\u00e5n-fre 09-14", "en": "open Mon-Fri 09-14"}, "www": null, "email": null, "phone": null, "contact_person": null}] [{"value": "on_door", "variable": 110}, {"value": "true", "variable": 5}, {"value": "true", "variable": 58}, {"value": "false", "variable": 103}, {"value": "true", "variable": 109}, {"value": "under_20mm", "variable": 91}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "true", "variable": 50}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "5", "variable": 1}, {"value": "at_least_3600mm", "variable": 3}, {"value": "false", "variable": 111}, {"value": "false", "variable": 106}, {"value": "false", "variable": 48}, {"value": "false", "variable": 84}, {"value": "true", "variable": 115}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 117}, {"value": "true", "variable": 37}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 97}, {"value": "false", "variable": 21}, {"value": "true", "variable": 96}, {"value": "false", "variable": 34}, {"value": "true", "variable": 59}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 49}, {"value": "false", "variable": 104}, {"value": "false", "variable": 23}, {"value": "true", "variable": 6}, {"value": "false", "variable": 114}, {"value": "false", "variable": 51}, {"value": "false", "variable": 83}, {"value": "short_term_stay", "variable": 60}, {"value": "under_10m", "variable": 4}, {"value": "true", "variable": 20}, {"value": "under_20mm", "variable": 56}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 118}, {"value": "false", "variable": 22}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 29}, {"value": "false", "variable": 79}, {"value": "true", "variable": 107}, {"value": "true", "variable": 57}, {"value": "false", "variable": 33}, {"value": "false", "variable": 44}, {"value": "true", "variable": 62}, {"value": "false", "variable": 82}, {"value": "false", "variable": 38}, {"value": "true", "variable": 94}, {"value": "true", "variable": 102}, {"value": "3_consecutive_steps", "variable": 93}, {"… internal 27417     84075c47-a8e4-4a45-a109-65221f63b3bf 84075c47-a8e4-4a45-a109-65221f63b3bf SELF_PRODUCED   service_by_joint_municipal_authority kuntayhtymän palvelu tjänst från samkommunen service by joint municipal authority 1                   HUS Kuvantaminen Meilahden sairaalan kliininen fysiologia HUS Medical Imaging Meilahti Hospital clinical physiology Haartmaninkatu 4 Haartmansgatan 4 Haartmaninkatu 4 https://www.hus.fi/Sivut/default.aspx https://www.hus.fi/sv/sjukvard/bilddiagnostik-och-fysiologi/Sidor/default.aspx https://www.hus.fi/en/medical-care/medical-imaging-and-physiology/Pages/default.aspx   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 4717 2552         2019-02-04T17:03:02+02:00 00290 www.hus.fi kaikki helsinki 2020-11-05T16:32:45.913780+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "green", "23": "green", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} [986] helsinki [1010] [820] {} Point 24.906034 60.18889 PL 340, 00029 HUS         HUS Bilddiagnostik Mejlans sjukhus klinisk fysiologi     1       P.O. Box 340, 00029 HUS 1     1   PB 340, 00029 HUS     7      
59215 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-to 08-15, pe 08-13:30", "sv": "\u00f6ppet m\u00e5n-tor 08-15, fre 08-13:30", "en": "open Mon-Thu 08-15, Fri 08-13:30"}, "www": null, "email": null, "phone": null, "contact_person": null}] [{"value": "smooth", "variable": 17}, {"value": "false", "variable": 34}, {"value": "under_10m", "variable": 4}, {"value": "outdoors", "variable": 2}, {"value": "true", "variable": 113}, {"value": "true", "variable": 5}, {"value": "false", "variable": 92}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "true", "variable": 52}, {"value": "true", "variable": 104}, {"value": "true", "variable": 6}, {"value": "true", "variable": 10}, {"value": "false", "variable": 80}, {"value": "true", "variable": 20}, {"value": "true", "variable": 12}, {"value": "false", "variable": 33}, {"value": "true", "variable": 11}, {"value": "false", "variable": 21}, {"value": "true", "variable": 50}, {"value": "opens_automatically", "variable": 15}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 43}, {"value": "true", "variable": 70}, {"value": "false", "variable": 103}, {"value": "1", "variable": 1}, {"value": "chairs_available", "variable": 81}, {"value": "true", "variable": 58}, {"value": "false", "variable": 48}, {"value": "false", "variable": 29}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 111}, {"value": "true", "variable": 35}, {"value": "false", "variable": 83}, {"value": "2", "variable": 63}, {"value": "true", "variable": 105}, {"value": "true", "variable": 72}, {"value": "true", "variable": 109}, {"value": "true", "variable": 114}, {"value": "opens_automatically", "variable": 77}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "false", "variable": 102}, {"value": "false", "variable": 117}, {"value": "true", "variable": 16}, {"value": "handrails_on_one_side", "variable": 41}, {"value": "true", "variable": 76}, {"value": "true", "variable": 13}, {"value": "false", "variable": 84}, {"value": "true", "variable": 40}, {"value": "false", "variable": 59}, {"value": "true", "variable": 116}, {"value": "false", "variable": 51}, {"value": "true", "variable": 73}, {"value": "false", "variable": 106}, {"value": "short_te… internal 28046     84075c47-a8e4-4a45-a109-65221f63b3bf 84075c47-a8e4-4a45-a109-65221f63b3bf SELF_PRODUCED   service_by_joint_municipal_authority kuntayhtymän palvelu tjänst från samkommunen service by joint municipal authority 1                   HUS Kuvantaminen Jorvin sairaalan kliininen neurofysiologia HUS Medical Imaging Jorvi Hospital Clinical Neurophysiology Karvasmäentie 10 C Karvasbackavägen 10 C Karvasmäentie 10 C http://www.hus-kuvantaminen.fi https://www.hus.fi/sv/sjukvard/bilddiagnostik-och-fysiologi/Sidor/default.aspx https://www.hus.fi/en/medical-care/medical-imaging-and-physiology/Pages/default.aspx   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 4718 2010         2019-03-07T13:06:49+02:00 02740 www.hus.fi kaikki espoo 2021-01-02T07:31:42.086755+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "green", "23": "green", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [986] espoo [1010] [820] {"fi": ["neurofysiologia"]} Point 24.687738 60.220436           HUS Bilddiagnostik Jorv sjukhus klinisk neurofysiologi     1     1   1     1         7      

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