unit

17 rows where organizer_type = "OTHER_REGIONAL_COOPERATION_ORGANIZATION"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: connections, department, root_department, provider_type, contract_type_id, contract_type_description_fi, contract_type_description_sv, contract_type_description_en, created_time, data_source, extensions_maintenance_organization, root_service_nodes, municipality, service_nodes, services, keywords, created_time (date), last_modified_time (date)

organizer_type ✖

  • OTHER_REGIONAL_COOPERATION_ORGANIZATION · 17 ✖
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         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       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       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         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         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         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         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         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       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         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         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       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         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         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         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

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