unit
11 rows where organizer_type = "JOINT_MUNICIPAL_AUTHORITY"
This data as json, CSV (advanced)
Suggested facets: connections, accessibility_properties, department, root_department, provider_type, contract_type_id, contract_type_description_fi, contract_type_description_sv, contract_type_description_en, name_fi, name_en, www_fi, www_sv, www_en, phone, address_zip, data_source, extensions_maintenance_organization, root_service_nodes, services, keywords, name_sv, created_time (date), last_modified_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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14460 | [] | [] | internal | 4407 | 309b5d67-d3b2-49b5-966a-8a3f984158ac | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | OTHER_PRODUCTION_METHOD | JOINT_MUNICIPAL_AUTHORITY | service_by_joint_municipal_authority | kuntayhtymän palvelu | tjänst från samkommunen | service by joint municipal authority | 1 | HSY | Jätekeruupiste | Waste sorting and recycling | Helsingintie 1 | Helsingforsvägen 1 | Helsingintie 1 | https://www.hsy.fi/fi/asukkaalle/Sivut/default.aspx | https://www.hsy.fi/sv/invanare/Sidor/default.aspx | https://www.hsy.fi/en/residents/pages/default.aspx | 2014-03-26T16:39:26+02:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2021-01-04T23:01:12.595407+02:00 | [1400] | kauniainen | [38, 40, 41, 44, 45, 48] | [617, 496, 491, 436, 374, 246] | {"fi": ["j\u00e4tteet", "ker\u00e4yspiste", "kierr\u00e4tys", "lasi", "v\u00e4rillinen lasi", "paristot"], "sv": ["avfall", "batterier", "glas", "insamling", "\u00e5tervinning"]} | Point | 24.730417 | 60.212425 | Återvinningspunkt | ||||||||||||||||||||||||||||||||||||||||||||||
| 53459 | [] | [] | internal | 23130 | 309b5d67-d3b2-49b5-966a-8a3f984158ac | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | OTHER_PRODUCTION_METHOD | JOINT_MUNICIPAL_AUTHORITY | service_by_joint_municipal_authority | kuntayhtymän palvelu | tjänst från samkommunen | service by joint municipal authority | 1 | HSY | Jätekeruupiste | Waste sorting and recycling | Kasavuorentie 4 | Kasabergsvägen 4 | Kasavuorentie 4 | https://www.hsy.fi/fi/asukkaalle/Sivut/default.aspx | https://www.hsy.fi/sv/invanare/Sidor/default.aspx | https://www.hsy.fi/en/residents/pages/default.aspx | 2017-06-08T15:06:01+03:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-03-13T09:32:26.535899+02:00 | [1400] | kauniainen | [38, 52, 40, 41, 42, 44, 45] | [496, 491, 454, 436, 374, 298, 246] | {"sv": ["kl\u00e4dinsamling"], "en": ["recycling point"], "fi": ["vaateker\u00e4ys"]} | Point | 24.70493 | 60.21525 | Återvinningspunkt | ||||||||||||||||||||||||||||||||||||||||||||||
| 53501 | [] | [] | internal | 23175 | 0acf3879-4eed-45f6-8346-8bb86de203e0 | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | PURCHASED_SERVICE | JOINT_MUNICIPAL_AUTHORITY | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Jätekeruupiste, uimahallin P-alue | Recycling point, swimming hall p-area | Asematie 26 | Stationsvägen 26 | Asematie 26 | http://www.kauniainen.fi/asuminen_ja_ymparisto/ymparisto/jatehuolto_ja_kierratys/kierratyspisteet | http://www.kauniainen.fi/sv/boende_och_miljo/miljo/avfallshantering_och_atervinning/atervinningspunkter | http://www.kauniainen.fi/asuminen_ja_ymparisto/ymparisto/jatehuolto_ja_kierratys/kierratyspisteet | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 1561 2110 | 2017-06-15T11:06:52+03:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-03-13T09:32:26.797034+02:00 | [1400] | kauniainen | [32, 40, 45] | [496, 374, 232] | {"sv": ["\u00e5tervinning"], "fi": ["kierr\u00e4tys"], "en": ["recycling"]} | Point | 24.71048 | 60.21643 | Återvinningspunkt, simhallens P-område | |||||||||||||||||||||||||||||||||||||||||||
| 53504 | [] | [] | internal | 23180 | 0acf3879-4eed-45f6-8346-8bb86de203e0 | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | PURCHASED_SERVICE | JOINT_MUNICIPAL_AUTHORITY | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Jätekeruupiste | Recycling point | Smedsintie/Leantie, urheilukenttä | Smedsvägen/Leavägen, sportplan | Smedsintie/Leantie, urheilukenttä | http://www.kauniainen.fi/asuminen_ja_ymparisto/ymparisto/jatehuolto_ja_kierratys/kierratyspisteet | http://www.kauniainen.fi/sv/boende_och_miljo/miljo/avfallshantering_och_atervinning/atervinningspunkter | http://www.kauniainen.fi/asuminen_ja_ymparisto/ymparisto/jatehuolto_ja_kierratys/kierratyspisteet | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 1561 2110 | 2017-06-15T12:38:15+03:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-03-13T09:32:26.821840+02:00 | [1400] | kauniainen | [45] | [496] | {} | Point | 24.72998 | 60.206715 | Återvinningspunkt | |||||||||||||||||||||||||||||||||||||||||||
| 53505 | [] | [] | internal | 23178 | 0acf3879-4eed-45f6-8346-8bb86de203e0 | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | PURCHASED_SERVICE | JOINT_MUNICIPAL_AUTHORITY | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Jätekeruupiste | Recycling point | Bembölentie 1 | Bembölevägen 1 | Bembölentie 1 | http://www.kauniainen.fi/asuminen_ja_ymparisto/ymparisto/jatehuolto_ja_kierratys/kierratyspisteet | http://www.kauniainen.fi/sv/boende_och_miljo/miljo/avfallshantering_och_atervinning/atervinningspunkter | http://www.kauniainen.fi/asuminen_ja_ymparisto/ymparisto/jatehuolto_ja_kierratys/kierratyspisteet | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 1561 2110 | 2017-06-15T12:32:04+03:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-03-13T09:32:26.828855+02:00 | [1400] | kauniainen | [45] | [496] | {} | Point | 24.708736 | 60.21579 | Återvinningspunkt | |||||||||||||||||||||||||||||||||||||||||||
| 53506 | [] | [] | internal | 23182 | 0acf3879-4eed-45f6-8346-8bb86de203e0 | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | PURCHASED_SERVICE | JOINT_MUNICIPAL_AUTHORITY | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Jätekeruupiste | Recycling point | Vanha Turuntie 42 | Gamla Åbovägen 42 | Vanha Turuntie 42 | http://www.kauniainen.fi/asuminen_ja_ymparisto/ymparisto/jatehuolto_ja_kierratys/kierratyspisteet | http://www.kauniainen.fi/sv/boende_och_miljo/miljo/avfallshantering_och_atervinning/atervinningspunkter | http://www.kauniainen.fi/asuminen_ja_ymparisto/ymparisto/jatehuolto_ja_kierratys/kierratyspisteet | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 1561 2110 | 2017-06-15T12:44:15+03:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-03-13T09:32:26.835887+02:00 | [1400] | kauniainen | [45] | [496] | {} | Point | 24.69933 | 60.221718 | Återvinningspunkt | |||||||||||||||||||||||||||||||||||||||||||
| 53507 | [] | [] | internal | 23181 | 0acf3879-4eed-45f6-8346-8bb86de203e0 | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | PURCHASED_SERVICE | JOINT_MUNICIPAL_AUTHORITY | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Jätekeruupiste | Recycling point | Marcus Collininkuja/Kasavuorentie | Marcus Collingränden/Kasabergsvägen | Marcus Collininkuja/Kasavuorentie | http://www.kauniainen.fi/asuminen_ja_ymparisto/ymparisto/jatehuolto_ja_kierratys/kierratyspisteet | http://www.kauniainen.fi/sv/boende_och_miljo/miljo/avfallshantering_och_atervinning/atervinningspunkter | http://www.kauniainen.fi/asuminen_ja_ymparisto/ymparisto/jatehuolto_ja_kierratys/kierratyspisteet | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 1561 2110 | 2017-06-15T12:42:10+03:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-03-13T09:32:26.842654+02:00 | [1400] | kauniainen | [45] | [496] | {} | Point | 24.692343 | 60.21094 | Återvinningspunkt | |||||||||||||||||||||||||||||||||||||||||||
| 53508 | [] | [] | internal | 23179 | 0acf3879-4eed-45f6-8346-8bb86de203e0 | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | PURCHASED_SERVICE | JOINT_MUNICIPAL_AUTHORITY | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Jätekeruupiste | Recycling point | Jollakuja 1 | Jollegränden 1 | Jollakuja 1 | http://www.kauniainen.fi/asuminen_ja_ymparisto/ymparisto/jatehuolto_ja_kierratys/kierratyspisteet | http://www.kauniainen.fi/sv/boende_och_miljo/miljo/avfallshantering_och_atervinning/atervinningspunkter | http://www.kauniainen.fi/asuminen_ja_ymparisto/ymparisto/jatehuolto_ja_kierratys/kierratyspisteet | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 1561 2110 | 2017-06-15T12:35:54+03:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-03-13T09:32:26.849402+02:00 | [1400] | kauniainen | [45] | [496] | {} | Point | 24.735613 | 60.21848 | Återvinningspunkt | |||||||||||||||||||||||||||||||||||||||||||
| 53509 | [] | [] | internal | 23177 | 0acf3879-4eed-45f6-8346-8bb86de203e0 | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | PURCHASED_SERVICE | JOINT_MUNICIPAL_AUTHORITY | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Jätekeruupiste | Recycling point | Kylätie 21 | Byvägen 21 | Kylätie 21 | http://www.kauniainen.fi/asuminen_ja_ymparisto/ymparisto/jatehuolto_ja_kierratys/kierratyspisteet | http://www.kauniainen.fi/sv/boende_och_miljo/miljo/avfallshantering_och_atervinning/atervinningspunkter | http://www.kauniainen.fi/asuminen_ja_ymparisto/ymparisto/jatehuolto_ja_kierratys/kierratyspisteet | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 1561 2110 | 2017-06-15T12:29:42+03:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-03-13T09:32:26.856552+02:00 | [1400] | kauniainen | [45] | [496] | {} | Point | 24.73702 | 60.211693 | Jätekeruupiste | |||||||||||||||||||||||||||||||||||||||||||
| 53529 | [] | [] | internal | 23205 | 0acf3879-4eed-45f6-8346-8bb86de203e0 | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | PURCHASED_SERVICE | JOINT_MUNICIPAL_AUTHORITY | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Lähibussilinjat (entiset palvelulinjat) ovat erityisesti ikäihmisille ja liikuntarajoitteisille suunniteltua liikennettä, joka kuljettaa lähiympäristön palveluihin, kuten kauppoihin, kirjastoon, terveysasemalle ja uimahalliin. Linjojen suunnittelussa on huomioitu erityisryhmien tarpeet, mutta niitä voivat käyttää kaikki matkustajat. Autoina käytetään matalalattiaisia pikkubusseja. | Lähibussi | Neighborhood route | Kirkkotie | Kyrkovägen | Kirkkotie | http://www.kauniainen.fi/asuminen_ja_ymparisto/kadut_ja_viheralueet_liikenne_joukkoliikenne/lahibussi | http://www.kauniainen.fi/sv/boende_och_miljo/gator_och_gronomraden_trafik_kollektivtrafik/narbuss | http://www.kauniainen.fi/asuminen_ja_ymparisto/kadut_ja_viheralueet_liikenne_joukkoliikenne/lahibussi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 4766 4000 | hsl@hsl.fi | 2017-06-16T09:11:15+03:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-03-13T09:32:26.943036+02:00 | [1402] | kauniainen | [515] | [209] | {"fi": ["l\u00e4hibussi", "palvelulinja"], "sv": ["n\u00e4rbuss", "servicelinje"], "en": ["neigborhood route"]} | Point | 24.722025 | 60.20874 | Närbuss | Lähibussi joka kuljettaa lähiympäristön palveluihin. | Närbuss som kör till affärer, hälsostationer osv i närområdet. | Närbusslinjerna (tidigare servicelinjerna) är planerade i synnerhet med tanke på seniorer och rörelsehindrade. Närbussarna kör till viktiga ställen i närområdet: till affärer, hälsostationer, bibliotek, simhall osv. I planeringen av linjerna har man beaktat de behov som specialgrupperna har, men alla passagerare kan använda dem. Linjerna körs med små bussar med lågt golv. | ||||||||||||||||||||||||||||||||||||||
| 58466 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 08-15:30", "sv": "\u00f6ppet m\u00e5n-fre 08-15:30", "en": "open Mon-Fri 08-15:30"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [{"value": "smooth", "variable": 17}, {"value": "false", "variable": 44}, {"value": "true", "variable": 57}, {"value": "true", "variable": 107}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "true", "variable": 5}, {"value": "false", "variable": 51}, {"value": "true", "variable": 117}, {"value": "true", "variable": 113}, {"value": "true", "variable": 109}, {"value": "true", "variable": 62}, {"value": "5", "variable": 1}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 59}, {"value": "true", "variable": 20}, {"value": "false", "variable": 23}, {"value": "false", "variable": 22}, {"value": "false", "variable": 116}, {"value": "false", "variable": 82}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 6}, {"value": "false", "variable": 79}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 48}, {"value": "true", "variable": 94}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 106}, {"value": "true", "variable": 96}, {"value": "false", "variable": 38}, {"value": "true", "variable": 105}, {"value": "false", "variable": 21}, {"value": "false", "variable": 84}, {"value": "true", "variable": 111}, {"value": "false", "variable": 98}, {"value": "true", "variable": 102}, {"value": "true", "variable": 37}, {"value": "true", "variable": 50}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 29}, {"value": "true", "variable": 118}, {"value": "true", "variable": 92}, {"value": "true", "variable": 115}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "false", "variable": 34}, {"value": "under_20mm", "variable": 56}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 33}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "3_consecutive_steps", "variable": 93}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 52}, {"value": "false", "variable": 97}, {"value": "on_door", "va… | internal | 27323 | 84075c47-a8e4-4a45-a109-65221f63b3bf | 84075c47-a8e4-4a45-a109-65221f63b3bf | UNKNOWN_PRODUCTION_METHOD | JOINT_MUNICIPAL_AUTHORITY | 1 | HUS Kuvantaminen Meilahden sairaalan kliininen neurofysiologia | HUS Medical Imaging Meilahti hospital's Clinical Neurophysiology | Haartmaninkatu 4 | Haartmansgatan 4 | Haartmaninkatu 4 | http://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 | hus-kuvantaminen.viestinta@hus.fi | 2019-01-10T15:17:02+02:00 | 00290 | www.hus.fi | kaikki | helsinki | 2020-11-05T16:32:45.078159+02:00 | {"00": null, "11": "green", "12": "green", "13": "green", "21": "green", "22": "green", "23": "green", "31": "green", "32": "green", "33": "green", "41": "green", "51": "red", "52": "red", "61": "red"} | [986] | helsinki | [1010] | [820] | {} | Point | 24.906033 | 60.188915 | PL 340, 00029 HUS | HUS Bilddiagnostik Mejlans sjukhus klinisk neurofysiologi | P.O. Box 340, 00029 HUS | 1 | PB 340, 00029 HUS | 5 |
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 );