unit
9 rows where organizer_type = "MUNICIPALITY" sorted by id descending
This data as json, CSV (advanced)
Suggested facets: department, root_department, www_fi, www_sv, www_en, created_time, address_zip, data_source, root_service_nodes, service_nodes, services, keywords, short_description_fi, created_time (date)
| id ▲ | connections | accessibility_properties | identifiers_0_namespace | identifiers_0_value | identifiers_1_namespace | identifiers_1_value | department | root_department | provider_type | organizer_type | contract_type_id | contract_type_description_fi | contract_type_description_sv | contract_type_description_en | is_active | deleted_at | organizer_name | organizer_business_id | picture_url | picture_entrance_url | streetview_entrance_url | description_fi | description_en | short_description | name_fi | name_en | street_address_fi | street_address_sv | street_address_en | www_fi | www_sv | www_en | address_postal_full | call_charge_info_fi | call_charge_info_sv | call_charge_info_en | picture_caption | phone | fax | accessibility_phone | accessibility_email | accessibility_www | created_time | address_zip | data_source | extensions_maintenance_group | extensions_maintenance_organization | last_modified_time | accessibility_viewpoints | root_service_nodes | municipality | service_nodes | services | keywords | location_type | location_coordinates_0 | location_coordinates_1 | address_postal_full_fi | identifiers_2_value | picture_caption_fi | call_charge_info | www | name_sv | short_description_fi | accessibility_shortcoming_count_reduced_mobility | accessibility_shortcoming_count_wheelchair | location | picture_caption_sv | accessibility_shortcoming_count_stroller | address_postal_full_en | accessibility_shortcoming_count_hearing_aid | street_address | contract_type | accessibility_shortcoming_count_rollator | identifiers_2_namespace | address_postal_full_sv | short_description_sv | description_sv | accessibility_shortcoming_count_visually_impaired | short_description_en | description | picture_caption_en | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 57560 | [] | [] | internal | 26583 | 828201f3-df6c-42e5-8239-fac577c3b248 | 520a4492-cb78-498b-9c82-86504de88dce | PURCHASED_SERVICE | MUNICIPALITY | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Hoivakodit | Tapiolan Aallotar | Kivennavantie 15 | Kivinebbsvägen 15 | Kivennavantie 15 | http://www.seniorikodit.fi/hoivakodit/tapiolan-aallotar/ | http://www.seniorikodit.fi/hoivakodit/tapiolan-aallotar/ | http://www.seniorikodit.fi/hoivakodit/tapiolan-aallotar/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 470 3789 | 2018-08-28T12:12:32+03:00 | 02130 | www.espoo.fi | kaikki | espoo | 2020-03-13T09:32:44.072691+02:00 | [783] | espoo | [825] | [760] | {} | Point | 24.796062 | 60.191803 | PL 86, Espoo | Uudenmaan Seniorikodit | P.O. Box 86, Espoo | PB 86, Esbo | ||||||||||||||||||||||||||||||||||||||||
| 56718 | [] | [] | internal | 25752 | 828201f3-df6c-42e5-8239-fac577c3b248 | 520a4492-cb78-498b-9c82-86504de88dce | PURCHASED_SERVICE | MUNICIPALITY | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Mainiokoti Kaisla | Suurpellon puistokatu 14-16 | Storåkerns parkgata 14-16 | Suurpellon puistokatu 14-16 | https://www.hoivamehilainen.fi/mainiokoti-kaisla | https://www.hoivamehilainen.fi/mainiokoti-kaisla | https://www.hoivamehilainen.fi/mainiokoti-kaisla | 2018-03-20T15:56:16+02:00 | 02250 | www.espoo.fi | kaikki | espoo | 2020-03-13T09:32:38.832110+02:00 | [783] | espoo | [825] | [760] | {} | Point | 24.74281 | 60.18656 | Mainiokoti Kaisla | Hoivakoti tarjoaa ympärivuorokautista apua tai hoivaa tarvitseville ikäihmisille | |||||||||||||||||||||||||||||||||||||||||||||||
| 53484 | [] | [] | internal | 23145 | 7bf9f508-7534-427d-9229-09d5400fa5bc | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | PURCHASED_SERVICE | MUNICIPALITY | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Espoon sairaalassa hoidetaan espoolaisten lisäksi Kirkkonummen ja Kauniaisten ikääntyneitä kuntalaisia. Espoon sairaalassa työskentelee yli 400 hoidon ja kuntoutuksen ammattilaista. Yhden hengen potilashuoneita on 270.Sairaala on osa Jorvin sairaalakampusta, jossa Espoon sairaala ja HUS-Jorvin erikoissairaanhoito tekevät tiivistä yhteistyötä.Espoon sairaalassa periaatteena on kotoa kotiin: Sairaalassaolon aikana potilas itse sekä jokainen ammattilainen työskentelevät kotiutumisen edellytysten saavuttamiseksi. Kaikkea kuntoutusta ohjaavat potilaan tarpeet ja yhdessä sovitut tavoitteet. | We treat elderly residents of Espoo, Kirkkonummi and Kauniainen. We have over 400 skilled professionals in care and rehabilitation. We have 270 single rooms for the patients.Espoo Hospital is located in Jorvi and cooperates intensively with the specialized medical care at Jorvi Hospital (which is operated by the Helsinki and Uusimaa hospital district HUS).We rehabilitate patients so that they can return home. The hospital aims both patient and staff towards this goal. All rehabilitation is guided by the patient's needs and jointly agreed objectives. | Espoon sairaala | Espoo Hospital | Karvasmäentie 6 | Karvasbackavägen 6 | Karvasmäentie 6 | http://www.espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Espoon_sairaala#contactInfo | http://www.esbo.fi/sv-FI/Social_och_halsovard/Sjuk_och_halsovard/Esbo_sjukhus | http://www.espoo.fi/en-US/Social_and_health_services/Health_Services/Espoo_Hospital | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 4711 | 2017-06-12T10:35:52+03:00 | 02740 | www.kauniainen.fi | kaikki | espoo | 2020-03-13T09:32:26.685503+02:00 | [986] | espoo | [1001, 1002, 1003] | [550, 378, 43] | {"fi": ["vuodeosasto", "vuodeosastohoito"], "sv": ["b\u00e4ddavdelning"]} | Point | 24.684149 | 60.221165 | Esbo sjukhus | Espoon sairaala on ikääntyneiden hoidon ja kuntoutuksen osaaja sekä kotona asumisen tukipalvelu. | Esbo sjukhus är ett kompetenscentrum för vård och rehabilitering av äldre och en stödtjänst för hemmaboende. | I Esbo sjukhus vårdas seniorer från Esbo, Kyrkslätt och Grankulla. I Esbo sjukhus jobbar över 400 yrkeskunniga personer inom vård och rehabilitering. Det finns 270 enkelrum för patienterna.Esbo sjukhus ligger på sjukhusområdet i Jorv och samarbetar intensivt med den specialiserade sjukvården som finns på Jorvs sjukhus som drivs av Helsingfors och Nylands sjukvårdsdistrikt HNS.Vi rehabiliterar patienterna så att de kan återvända hem. På sjukhuset strävar både patienten och personalen mot detta mål. All rehabilitering styrs av patientens behov och de tillsammans överenskomna målen. | Espoo Hospital is a centre of excellence for treatment and rehabilitation of the elderly and a support service for patients returning home. | |||||||||||||||||||||||||||||||||||||
| 20255 | [] | [] | internal | 5859 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | PURCHASED_SERVICE | MUNICIPALITY | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Päiväkoti Satumetsä | Päiväkoti Satumetsä | Tietäjäntie 13 | Siarvägen 13 | Tietäjäntie 13 | http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Ostopalvelut/Tapiola | http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Ostopalvelut/Tapiola | http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Ostopalvelut/Tapiola | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 453 575 494 | 2015-11-03T12:03:45+02:00 | 02130 | www.espoo.fi | kaikki | espoo | 2020-03-13T09:31:11.585287+02:00 | [1405] | espoo | [871, 870] | [663] | {"fi": ["ostopalvelu", "tarha", "lastentarha"]} | Point | 24.803204 | 60.186703 | Päiväkoti Satumetsä | varhaiskasvatus | ||||||||||||||||||||||||||||||||||||||||||
| 20254 | [] | [] | internal | 5858 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | PURCHASED_SERVICE | MUNICIPALITY | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Päiväkoti Sateenkaari | Päiväkoti Sateenkaari | Ruukinrannantie 21 | Brukstrandsvägen 21 | Ruukinrannantie 21 | http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Ostopalvelut/Tapiola | http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Ostopalvelut/Tapiola | http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Ostopalvelut/Tapiola | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 40 759 6942 | 2015-11-03T12:03:45+02:00 | 02600 | www.espoo.fi | kaikki | espoo | 2020-10-19T13:01:02.470142+03:00 | [1405] | espoo | [871, 870] | [663] | {"fi": ["ostopalvelu", "tarha", "lastentarha"]} | Point | 24.824476 | 60.20404 | Päiväkoti Sateenkaari | varhaiskasvatus | ||||||||||||||||||||||||||||||||||||||||||
| 20252 | [] | [] | internal | 5836 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | PURCHASED_SERVICE | MUNICIPALITY | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Päiväkoti Petunia | Päiväkoti Petunia | Servin Maijan tie 8 | Servi-Maijas väg 8 | Servin Maijan tie 8 | https://paivakotipetunia.fi/ | https://paivakotipetunia.fi/ | https://paivakotipetunia.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 44 055 6852 | 2015-11-03T12:03:45+02:00 | 02150 | www.espoo.fi | kaikki | espoo | 2020-03-13T09:31:11.559036+02:00 | [1405] | espoo | [871, 870] | [663] | {"fi": ["ostopalveu", "tarha", "lastentarha"]} | Point | 24.837313 | 60.19081 | Päiväkoti Petunia | Varhaiskasvatus | ||||||||||||||||||||||||||||||||||||||||||
| 20251 | [] | [] | internal | 5835 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | PURCHASED_SERVICE | MUNICIPALITY | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Otsolahden päiväkoti | Otsolahden päiväkoti | Otsolahdentie 16 C | Björnviksvägen 16 C | Otsolahdentie 16 C | https://sites.google.com/view/otsolahdenpaivakoti/ | https://sites.google.com/view/otsolahdenpaivakoti/ | https://sites.google.com/view/otsolahdenpaivakoti/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 44 046 2327 | 2015-11-03T12:03:45+02:00 | 02110 | www.espoo.fi | kaikki | espoo | 2020-03-13T09:31:11.551127+02:00 | [1405] | espoo | [871, 870] | [663] | {"fi": ["ostopalvelu", "tarha", "lastentarha"]} | Point | 24.818104 | 60.177715 | Otsolahden päiväkoti | varhaiskasvatus | ||||||||||||||||||||||||||||||||||||||||||
| 20250 | [] | [] | internal | 5671 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | PURCHASED_SERVICE | MUNICIPALITY | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Lasten montessorikoulu Laajalahti | Lasten montessorikoulu Laajalahti | Kirvuntie 22 | Kirvusvägen 22 | Kirvuntie 22 | https://www.laajalahdenmontessori.fi/ | https://www.laajalahdenmontessori.fi/ | https://www.laajalahdenmontessori.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 541 8538 | 2015-11-03T12:03:45+02:00 | 02140 | www.espoo.fi | kaikki | espoo | 2020-12-30T14:01:05.016847+02:00 | [1087, 1405] | espoo | [879, 1090, 2125, 871, 870] | [861, 663, 160] | {"fi": ["eskari", "montessori", "ostopalvelu"]} | Point | 24.804781 | 60.204147 | Lasten montessorikoulu Laajalahti | varhaiskasvatus | ||||||||||||||||||||||||||||||||||||||||||
| 20247 | [] | [] | internal | 5620 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | PURCHASED_SERVICE | MUNICIPALITY | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Keilaniemen päiväkoti | Keilaniemen päiväkoti | Jämeräntaival 11 j | Bistervägen 11 j | Jämeräntaival 11 j | http://www.keilaniemenpaivakoti.fi/ | http://www.keilaniemenpaivakoti.fi/ | http://www.keilaniemenpaivakoti.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 376 2562 | 2015-11-03T12:03:45+02:00 | 02150 | www.espoo.fi | kaikki | espoo | 2020-10-08T09:01:04.223823+03:00 | [1405] | espoo | [871, 870] | [663] | {"fi": ["ostopalvelu", "lastentarha"]} | Point | 24.839397 | 60.189823 | Keilaniemen päiväkoti | varhaiskasvatusostopalvelu |
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 );