11 rows where organizer_type = "JOINT_MUNICIPAL_AUTHORITY"

View and edit SQL

Suggested facets: connections, department, root_department, provider_type, contract_type_id, contract_type_description_fi, contract_type_description_sv, contract_type_description_en, www_fi, www_sv, www_en, last_modified_time (date)

organizer_type

  • JOINT_MUNICIPAL_AUTHORITY · 11
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         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

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