unit
17 rows where organizer_type = "OTHER_REGIONAL_COOPERATION_ORGANIZATION"
This data as json, CSV (advanced)
Suggested facets: connections, department, root_department, provider_type, contract_type_id, contract_type_description_fi, contract_type_description_en, data_source, extensions_maintenance_organization, root_service_nodes, municipality, services, keywords, last_modified_time (date)
service_nodes ✖
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9139 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4\u00e4llikk\u00f6", "sv": "Chef", "en": "Manager"}, "www": null, "email": "tuliaura@haaganvpk.com", "phone": null, "contact_person": null}] | [] | internal | 3533 | 420121e5-e673-4549-b4fb-1d9347fb2cc1 | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | OTHER_REGIONAL_COOPERATION_ORGANIZATION | service_by_regional_cooperation_organization | alueellisen yhteistoimintaorganisaation palvelu | tjänst från regional samarbetsorganisation | service by regional cooperation organization | 1 | Haagan VPK | Haagan VPK | Haaga Voluntary Fire Brigade | Kylänevankuja 5 | Bymossagränd 5 | Kylänevankuja 5 | http://www.haaganvpk.com | http://www.haaganvpk.com | http://www.haaganvpk.com | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 587 8423 | tuliaura@haaganvpk.com | 2009-03-25T09:21:54+02:00 | 00320 | www.hel.fi | kaikki | helsinki | 2021-01-04T23:01:10.314508+02:00 | [1061] | helsinki | [1074] | [633] | {} | Point | 24.893173 | 60.21452 | Haga FBK | |||||||||||||||||||||||||||||||||||||||||
9145 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4\u00e4llikk\u00f6", "sv": "Chef", "en": "Manager"}, "www": null, "email": null, "phone": "+358 50 551 5157", "contact_person": "Kari Kiiski"}] | [] | internal | 3544 | 420121e5-e673-4549-b4fb-1d9347fb2cc1 | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | OTHER_REGIONAL_COOPERATION_ORGANIZATION | service_by_regional_cooperation_organization | alueellisen yhteistoimintaorganisaation palvelu | tjänst från regional samarbetsorganisation | service by regional cooperation organization | 1 | Helsingin VPK | Helsingin VPK | Helsinki Voluntary Fire Brigade | Albertinkatu 29 | Albertsgatan 29 | Albertinkatu 29 | http://www.helsinginvpk.net | http://www.helsinginvpk.net | http://www.helsinginvpk.net | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 693 1285 | +358 9 693 1585 | paloasema@helsinginvpk.net | 2009-03-25T09:21:54+02:00 | 00180 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:05.428288+02:00 | [1061] | helsinki | [1074] | [633] | {} | Point | 24.933128 | 60.164757 | Helsingfors FBK | ||||||||||||||||||||||||||||||||||||||||
9146 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4\u00e4llikk\u00f6", "sv": "Chef", "en": "Manager"}, "www": null, "email": null, "phone": "+358 400 431 663", "contact_person": "Koivunen Aki"}] | [] | internal | 3599 | 420121e5-e673-4549-b4fb-1d9347fb2cc1 | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | OTHER_REGIONAL_COOPERATION_ORGANIZATION | service_by_regional_cooperation_organization | alueellisen yhteistoimintaorganisaation palvelu | tjänst från regional samarbetsorganisation | service by regional cooperation organization | 1 | Laajasalon VPK | Laajasalon VPK | Laajasalo Voluntary Fire Brigade | Yliskylänkaari 10 | Uppbysvängen 10 | Yliskylänkaari 10 | http://www.laajasalonvpk.com | http://www.laajasalonvpk.com | http://www.laajasalonvpk.com | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 698 0000 | +358 9 6877 6060 | vpk@laajasalonvpk.com | 2009-03-25T09:21:54+02:00 | 00840 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:05.438529+02:00 | [1061] | helsinki | [1074] | [633] | {} | Point | 25.050644 | 60.18543 | Degerö FBK | ||||||||||||||||||||||||||||||||||||||||
9147 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4\u00e4llikk\u00f6", "sv": "Chef", "en": "Manager"}, "www": null, "email": "paallikko@lvpk.fi", "phone": null, "contact_person": "Marko Palokangas"}] | [] | internal | 3607 | 420121e5-e673-4549-b4fb-1d9347fb2cc1 | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | OTHER_REGIONAL_COOPERATION_ORGANIZATION | service_by_regional_cooperation_organization | alueellisen yhteistoimintaorganisaation palvelu | tjänst från regional samarbetsorganisation | service by regional cooperation organization | 1 | Lauttasaaren VPK | Lauttasaaren VPK | Lauttasaari Voluntary Fire Brigade | Tallbergin puistotie 10 | Tallbergs allén 10 | Tallbergin puistotie 10 | http://www.lvpk.fi | http://www.lvpk.fi | http://www.lvpk.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 678 318 | lvpk@lvpk.fi | 2009-03-25T09:21:54+02:00 | 00200 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:05.448360+02:00 | [1061] | helsinki | [1074] | [633] | {} | Point | 24.878555 | 60.157455 | Drumsö FBK | |||||||||||||||||||||||||||||||||||||||||
9148 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4\u00e4llikk\u00f6", "sv": "Chef", "en": "Manager"}, "www": null, "email": null, "phone": "+358 40 767 9191", "contact_person": "Nyberg Petri"}] | [] | internal | 3608 | 420121e5-e673-4549-b4fb-1d9347fb2cc1 | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | OTHER_REGIONAL_COOPERATION_ORGANIZATION | service_by_regional_cooperation_organization | alueellisen yhteistoimintaorganisaation palvelu | tjänst från regional samarbetsorganisation | service by regional cooperation organization | 1 | Malmin VPK | Malmin VPK | Malmi Voluntary Fire Brigade | Askartie 8 | Askarslättsvägen 8 | Askartie 8 | http://www.malminvpk.fi | http://www.malminvpk.fi | http://www.malminvpk.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 385 2290 | franpe.nyberg@netti.fi | 2009-03-25T09:21:54+02:00 | 00700 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:05.457462+02:00 | [1061] | helsinki | [1074] | [633] | {} | Point | 25.007034 | 60.25356 | Malm FBK | |||||||||||||||||||||||||||||||||||||||||
9149 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4\u00e4llikk\u00f6", "sv": "Chef", "en": "Manager"}, "www": null, "email": null, "phone": "+358 40 502 2083", "contact_person": "Jonsson Henrik"}] | [] | internal | 3609 | 420121e5-e673-4549-b4fb-1d9347fb2cc1 | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | OTHER_REGIONAL_COOPERATION_ORGANIZATION | service_by_regional_cooperation_organization | alueellisen yhteistoimintaorganisaation palvelu | tjänst från regional samarbetsorganisation | service by regional cooperation organization | 1 | Marjaniemen VPK | Marjaniemen VPK | Marjaniemi Voluntary Fire Brigade | Palopirtintie 6 | Brandpörtsvägen 6 | Palopirtintie 6 | http://www.marjaniemenvpk.fi | http://www.marjaniemenvpk.fi | http://www.marjaniemenvpk.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 323 1100 | palokunta@marjaniemenvpk.fi | 2009-03-25T09:21:54+02:00 | 00930 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:05.466877+02:00 | [1061] | helsinki | [1074] | [633] | {} | Point | 25.08894 | 60.202656 | Marudds FBK | |||||||||||||||||||||||||||||||||||||||||
9150 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Palokunnan p\u00e4\u00e4llikk\u00f6", "sv": "Chef", "en": "Manager"}, "www": null, "email": null, "phone": "+358 40 720 3270", "contact_person": "Halttunen Taina"}] | [] | internal | 3616 | 420121e5-e673-4549-b4fb-1d9347fb2cc1 | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | OTHER_REGIONAL_COOPERATION_ORGANIZATION | service_by_regional_cooperation_organization | alueellisen yhteistoimintaorganisaation palvelu | tjänst från regional samarbetsorganisation | service by regional cooperation organization | 1 | Oulunkylän VPK | Oulunkylän VPK | Oulunkylä Voluntary Fire Brigade | Otto Brandtin tie 2 | Otto Brandts väg 2 | Otto Brandtin tie 2 | http://www.oulunkylanvpk.fi | http://www.oulunkylanvpk.fi | http://www.oulunkylanvpk.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 40 962 8147 | palokunta@oulunkylanvpk.fi | 2009-03-25T09:21:54+02:00 | 00650 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:05.476235+02:00 | [1061] | helsinki | [1074] | [633] | {} | Point | 24.974438 | 60.230057 | Åggelby FBK | |||||||||||||||||||||||||||||||||||||||||
9151 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4\u00e4llikk\u00f6", "sv": "Chef", "en": "Manager"}, "www": null, "email": null, "phone": "+358 400 467 828", "contact_person": "Airio Pekka"}] | [] | internal | 3617 | 420121e5-e673-4549-b4fb-1d9347fb2cc1 | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | OTHER_REGIONAL_COOPERATION_ORGANIZATION | service_by_regional_cooperation_organization | alueellisen yhteistoimintaorganisaation palvelu | tjänst från regional samarbetsorganisation | service by regional cooperation organization | 1 | Pakinkylän VPK | Pakinkylän VPK | Pakinkylä Voluntary Fire Brigade | Pakilantie 64 | Baggbölevägen 64 | Pakilantie 64 | http://www.pakinkylanvpk.net | http://www.pakinkylanvpk.net | http://www.pakinkylanvpk.net | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 724 8821 | pakinkylan.vpk@kolumbus.fi | 2009-03-25T09:21:54+02:00 | 00660 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:05.485218+02:00 | [1061] | helsinki | [1074] | [633] | {} | Point | 24.927055 | 60.24024 | Baggböle FBK | |||||||||||||||||||||||||||||||||||||||||
9152 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4\u00e4llikk\u00f6", "sv": "Chef", "en": "Manager"}, "www": null, "email": null, "phone": "+358 50 061 0783", "contact_person": "Helenius Henrik"}] | [] | internal | 3618 | 420121e5-e673-4549-b4fb-1d9347fb2cc1 | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | OTHER_REGIONAL_COOPERATION_ORGANIZATION | service_by_regional_cooperation_organization | alueellisen yhteistoimintaorganisaation palvelu | tjänst från regional samarbetsorganisation | service by regional cooperation organization | 1 | Pitäjänmäen VPK | Pitäjänmäen VPK | Pitäjänmäki Voluntary Fire Brigade | Viinentie 6 | Kogervägen 6 | Viinentie 6 | http://kotisivu.mtv3.fi/pitajanmaen.vpk/ | http://kotisivu.mtv3.fi/pitajanmaen.vpk/ | http://kotisivu.mtv3.fi/pitajanmaen.vpk/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 349 8860 | +358 9 349 8860 | pitajanmaen.vpk@kolumbus.fi | 2009-03-25T09:21:54+02:00 | 00370 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:05.495821+02:00 | [1061] | helsinki | [1074] | [633] | {} | Point | 24.861513 | 60.2275 | Sockenbacka FBK | ||||||||||||||||||||||||||||||||||||||||
9153 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4\u00e4llikk\u00f6", "sv": "Chef", "en": "Manager"}, "www": null, "email": null, "phone": "+358 40 548 4980", "contact_person": "Markus Sarlin"}] | [] | internal | 3528 | 420121e5-e673-4549-b4fb-1d9347fb2cc1 | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | OTHER_REGIONAL_COOPERATION_ORGANIZATION | service_by_regional_cooperation_organization | alueellisen yhteistoimintaorganisaation palvelu | tjänst från regional samarbetsorganisation | service by regional cooperation organization | 1 | Puistolan VPK | Puistolan VPK | Puistola Voluntary Fire Brigade | Puistolan raitti 5 | Parkstads bygata 5 | Puistolan raitti 5 | http://www.puistolanvpk.fi | http://www.puistolanvpk.fi | http://www.puistolanvpk.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 388 3594 | puistolanvpk@puistolanvpk.fi | 2009-03-25T09:21:54+02:00 | 00760 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:05.505745+02:00 | [1061] | helsinki | [1074] | [633] | {} | Point | 25.057747 | 60.270603 | Parkstad FBK | |||||||||||||||||||||||||||||||||||||||||
9154 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4\u00e4llikk\u00f6", "sv": "Chef", "en": "Manager"}, "www": null, "email": null, "phone": "+358 50 306 3173", "contact_person": "Ruusuvuori Kimmo"}] | [] | internal | 3573 | 420121e5-e673-4549-b4fb-1d9347fb2cc1 | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | OTHER_REGIONAL_COOPERATION_ORGANIZATION | service_by_regional_cooperation_organization | alueellisen yhteistoimintaorganisaation palvelu | tjänst från regional samarbetsorganisation | service by regional cooperation organization | 1 | Pukinmäen VPK | Pukinmäen VPK | Pukinmäki Voluntary Fire Brigade | Eskolankuja 4 | Eskosgränden 4 | Eskolankuja 4 | http://www.pukinmaenvpk.fi | http://www.pukinmaenvpk.fi | http://www.pukinmaenvpk.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 40 735 6157 | vpk@pukinmaenvpk.fi | 2009-03-25T09:21:54+02:00 | 00720 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:05.515061+02:00 | [1061] | helsinki | [1074] | [633] | {} | Point | 24.993921 | 60.24692 | Bocksbacka FBK | |||||||||||||||||||||||||||||||||||||||||
9155 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4\u00e4llikk\u00f6", "sv": "Chef", "en": "Manager"}, "www": null, "email": null, "phone": "+358 50 084 9596", "contact_person": "Nurmi Mikko"}] | [] | internal | 3574 | 420121e5-e673-4549-b4fb-1d9347fb2cc1 | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | OTHER_REGIONAL_COOPERATION_ORGANIZATION | service_by_regional_cooperation_organization | alueellisen yhteistoimintaorganisaation palvelu | tjänst från regional samarbetsorganisation | service by regional cooperation organization | 1 | Tammisalon VPK | Tammisalon VPK | Tammisalo Voluntary Fire Brigade | Tammisalontie 7 | Tammelundsvägen 7 | Tammisalontie 7 | http://www.tammisalonvpk.fi | http://www.tammisalonvpk.fi | http://www.tammisalonvpk.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 785 066 | +358 9 785 066 | tammisalonvpk@tammisalonvpk.fi | 2009-03-25T09:21:54+02:00 | 00830 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:05.524935+02:00 | [1061] | helsinki | [1074] | [633] | {} | Point | 25.059147 | 60.19138 | Tammelunds FBK | ||||||||||||||||||||||||||||||||||||||||
9156 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4\u00e4llikk\u00f6", "sv": "Chef", "en": "Manager"}, "www": null, "email": null, "phone": "+358 50 550 4202", "contact_person": "Nyman Rolf"}] | [] | internal | 3575 | visithelsinki | 808 | 420121e5-e673-4549-b4fb-1d9347fb2cc1 | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | OTHER_REGIONAL_COOPERATION_ORGANIZATION | service_by_regional_cooperation_organization | alueellisen yhteistoimintaorganisaation palvelu | tjänst från regional samarbetsorganisation | service by regional cooperation organization | 1 | Tapanilan VPK | Tapanilan VPK | Tapanila Voluntary Fire Brigade | Päivöläntie 50 | Päivölävägen 50 | Päivöläntie 50 | http://www.tapanilanvpk.fi/ | http://www.tapanilanvpk.fi/ | http://www.tapanilanvpk.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 44 386 2433 | tapanilanvpk@gmail.com | 2009-03-25T09:21:54+02:00 | 00730 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:05.537198+02:00 | [1061, 1400, 1401, 1403] | helsinki | [152, 261, 508, 737, 1074] | [633, 214] | {} | Point | 25.024174 | 60.266617 | Mosabacka FBK | |||||||||||||||||||||||||||||||||||||||
9157 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4\u00e4llikk\u00f6", "sv": "Chef", "en": "Manager"}, "www": null, "email": null, "phone": "+358 400 548 377", "contact_person": "Hallb\u00e4ck Dick"}] | [] | internal | 3556 | 420121e5-e673-4549-b4fb-1d9347fb2cc1 | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | OTHER_REGIONAL_COOPERATION_ORGANIZATION | service_by_regional_cooperation_organization | alueellisen yhteistoimintaorganisaation palvelu | tjänst från regional samarbetsorganisation | service by regional cooperation organization | 1 | Vanhan Käpylän VPK | Vanhan Käpylän VPK | Vanha Käpylä Voluntary Fire Brigade | Krämertintie 8 | Krämertsvägen 8 | Krämertintie 8 | http://www.vanhankapylanvpk.fi | http://www.vanhankapylanvpk.fi | http://www.vanhankapylanvpk.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 792 237 | palokunta@vanhankapylanvpk.fi | 2009-03-25T09:21:54+02:00 | 00620 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:05.548291+02:00 | [1061] | helsinki | [1074] | [633] | {} | Point | 24.938063 | 60.223488 | Gamla Kottby FBK | |||||||||||||||||||||||||||||||||||||||||
9158 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4\u00e4llikk\u00f6", "sv": "Chef", "en": "Manager"}, "www": null, "email": null, "phone": "+358 400 889 999", "contact_person": "Merikivi Jenni"}] | [] | internal | 3557 | 420121e5-e673-4549-b4fb-1d9347fb2cc1 | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | OTHER_REGIONAL_COOPERATION_ORGANIZATION | service_by_regional_cooperation_organization | alueellisen yhteistoimintaorganisaation palvelu | tjänst från regional samarbetsorganisation | service by regional cooperation organization | 1 | Vuosaaren VPK | Vuosaaren VPK | Vuosaari Voluntary Fire Brigade | Kaivonkatsojantie 14 | Brunnsökarvägen 14 | Kaivonkatsojantie 14 | http://www.vuosaarenvpk.fi | http://www.vuosaarenvpk.fi | http://www.vuosaarenvpk.fi | 2009-03-25T09:21:54+02:00 | 00980 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:05.558938+02:00 | [1061] | helsinki | [1074] | [633] | {} | Point | 25.137224 | 60.203934 | Nordsjö FBK | ||||||||||||||||||||||||||||||||||||||||||||||
33306 | [] | [] | internal | 15054 | b4e07809-a34e-4476-b210-2c29c1fd52cb | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | OTHER_PRODUCTION_METHOD | OTHER_REGIONAL_COOPERATION_ORGANIZATION | service_by_regional_cooperation_organization | alueellisen yhteistoimintaorganisaation palvelu | tjänst från regional samarbetsorganisation | service by regional cooperation organization | 1 | Pääkaupunkiseudun Kierrätyskeskus Oy | Kierrätyskeskus | Reuse Centre | Hosantie 2 | Släckruskvägen 2 | Hosantie 2 | http://www.kierratyskeskus.fi/ | http://www.kierratyskeskus.fi/pa_svenska | http://www.kierratyskeskus.fi/in_english | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 400 348 113 | info@kierratyskeskus.fi | 2014-11-19T17:01:21+02:00 | 01360 | www.vantaa.fi | kaikki | vantaa | 2020-03-26T09:03:36.910299+02:00 | [1400] | vantaa | [52] | [298] | {"fi": ["ymp\u00e4rist\u00f6kasvatus", "kierr\u00e4tys", "s\u00e4hk\u00f6", "noutopalvelu", "ymp\u00e4rist\u00f6koulutus", "4v", "ekoarki", "elektroniikka", "huonekalu", "kauppa", "kierr\u00e4tyskeskus", "komposti", "kylm\u00e4laitteet", "per\u00e4k\u00e4rry", "plan b", "p\u00e4\u00e4kaupunkiseudun kierr\u00e4tys", "romu", "verstas"]} | Point | 25.061468 | 60.3171 | Återanvändningscentral | |||||||||||||||||||||||||||||||||||||||||
54941 | [] | [] | internal | 24581 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | PURCHASED_SERVICE | OTHER_REGIONAL_COOPERATION_ORGANIZATION | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Pilke päiväkodit Oy | 1600658-9 | Päiväkoti Nallentupa | Niipperintie 33 | Nipertvägen 33 | Niipperintie 33 | http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Ostopalvelut/Espoon_keskus | http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Ostopalvelut/Espoon_keskus | http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Ostopalvelut/Espoon_keskus | 2017-10-31T13:34:02+02:00 | 02920 | www.espoo.fi | kaikki | espoo | 2021-01-04T23:02:24.194522+02:00 | [1087, 1405] | espoo | [879, 1090, 2125, 871, 870] | [861, 663, 160] | {"fi": ["eskari", "lastentarha"]} | Point | 24.747059 | 60.284245 | Päivähoitoa ja esiopetusta |
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 );