8 rows where accessibility_shortcoming_count_stroller = 2 and "last_modified_time" is on date 2021-01-04

View and edit SQL

Suggested facets: root_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
8244 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma 12:30-18:45, ti, to 09:30-16, suljettu ke, pe-su", "sv": "\u00f6ppet m\u00e5n 12:30-18:45, tis, tor 09:30-16, st\u00e4ngt ons, fre-s\u00f6n", "en": "open Mon 12:30-18:45, Tue, Thu 09:30-16, closed Wed, Fri-Sun"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Aukioloajat", "sv": "\u00d6ppettider", "en": "Opening hours"}, "www": {"fi": "http://www.helmet.fi/kirjasto/84871/Aukioloajat/", "sv": "http://www.helmet.fi/bibliotek/84871/Kontaktuppgifter/", "en": "http://www.helmet.fi/library/84871/Contact_information/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "HIGHLIGHT", "name": {"fi": "COVID-19: Kirjastojen ohjeita epidemiakaudelle."}, "www": {"fi": "https://www.helmet.fi/fi-FI/Tapahtumat_ja_vinkit/Uutispalat/Kirjastoasioinnista_koronavirusepidemian(208997)"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Facebook", "sv": "Facebook", "en": "Facebook"}, "www": {"fi": "http://www.facebook.com/Suomenlinnankirjasto", "sv": "http://www.facebook.com/Suomenlinnankirjasto", "en": "http://www.facebook.com/Suomenlinnankirjasto"}, "email": null, "phone": null, "contact_person": null}] [{"value": "false", "variable": 48}, {"value": "false", "variable": 52}, {"value": "true", "variable": 57}, {"value": "false", "variable": 98}, {"value": "false", "variable": 104}, {"value": "false", "variable": 105}, {"value": "false", "variable": 103}, {"value": "false", "variable": 107}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 92}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 102}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "false", "variable": 83}, {"value": "false", "variable": 80}, {"value": "false", "variable": 82}, {"value": "false", "variable": 84}, {"value": "false", "variable": 79}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 51}, {"value": "false", "variable": 58}, {"value": "false", "variable": 44}, {"value": "false", "variable": 49}, {"value": "true", "variable": 59}, {"value": "true", "variable": 50}, {"value": "true", "variable": 40}, {"value": "no_handrails", "variable": 41}, {"value": "true", "variable": 38}, {"value": "true", "variable": 22}, {"value": "false", "variable": 37}, {"value": "false", "variable": 43}, {"value": "short_term_stay", "variable": 60}, {"value": "at_least_4_steps", "variable": 39}, {"value": "false", "variable": 23}, {"value": "false", "variable": 29}, {"value": "false", "variable": 21}, {"value": "false", "variable": 33}, {"value": "sufficiently_wide", "variable": 18}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 34}, {"value": "true", "variable": 20}, {"value": "0", "variable": 1}, {"value": "false", "variable": 5}, {"value": "rough", "variable": 17}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 62}] internal 3285 kirkanta 84871 dc7d39db-b35a-4612-a921-1b7b24b0baa3 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1       https://kirkanta.kirjastot.fi/files/photos/medium/suomenlinna-4f902488.jpg           Suomenlinnan kirjasto Suomenlinna Library Suomenlinna C 31 Sveaborg C 31 Suomenlinna C 31 http://www.helmet.fi/suomenlinnankirjasto http://www.helmet.fi/sveaborgbibliotek http://www.helmet.fi/sveaborgbibliotek   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 85019   +358 9 310 85019 suomenlinnan_kirjasto@hel.fi https://www.helmet.fi/suomenlinnankirjasto 2008-09-11T18:47:26+03:00 00190 www.hel.fi kaikki helsinki 2021-01-04T07:30:50.033088+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1402, 1403] helsinki [341, 337, 338, 331, 328, 349] [813, 806, 692, 691, 483] {} Point 24.986555 60.146717 PL 19455, 00099 HELSINGIN KAUPUNKI         Sveaborgs bibliotek   7 9     2 P.O. Box 19455, 00099 HELSINGIN KAUPUNKI 1     9   PB 19455, 00099 HELSINGIN KAUPUNKI     8      
8302 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma, to 09-20, ti 09-18, pe 09-16, la 10-16, suljettu ke, su", "sv": "\u00f6ppet m\u00e5n, tor 09-20, tis 09-18, fre 09-16, l\u00f6r 10-16, st\u00e4ngt ons, s\u00f6n", "en": "open Mon, Thu 09-20, Tue 09-18, Fri 09-16, Sat 10-16, closed Wed, Sun"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Aukioloajat", "sv": "\u00d6ppettider", "en": "Opening hours"}, "www": {"fi": "http://www.helmet.fi/kirjasto/84861/Aukioloajat/", "sv": "http://www.helmet.fi/bibliotek/84861/Kontaktuppgifter/", "en": "http://www.helmet.fi/library/84861/Contact_information/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "HIGHLIGHT", "name": {"fi": "COVID-19: Kirjastojen ohjeita epidemiakaudelle."}, "www": {"fi": "https://www.helmet.fi/fi-FI/Tapahtumat_ja_vinkit/Uutispalat/Kirjastoasioinnista_koronavirusepidemian(208997)"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Facebook", "sv": "Facebook", "en": "Facebook"}, "www": {"fi": "http://www.facebook.com/Kapylankirjasto", "sv": "http://www.facebook.com/Kapylankirjasto", "en": "http://www.facebook.com/Kapylankirjasto"}, "email": null, "phone": null, "contact_person": null}] [{"value": "ramp_under_6m_long", "variable": 30}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 49}, {"value": "false", "variable": 22}, {"value": "narrow", "variable": 18}, {"value": "false", "variable": 53}, {"value": "false", "variable": 103}, {"value": "true", "variable": 29}, {"value": "true", "variable": 5}, {"value": "false", "variable": 98}, {"value": "at_least_4_steps", "variable": 24}, {"value": "true", "variable": 50}, {"value": "over_20mm", "variable": 56}, {"value": "no_handrails", "variable": 32}, {"value": "true", "variable": 51}, {"value": "false", "variable": 31}, {"value": "true", "variable": 58}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 116}, {"value": "true", "variable": 113}, {"value": "true", "variable": 107}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 44}, {"value": "false", "variable": 20}, {"value": "false", "variable": 83}, {"value": "false", "variable": 102}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 104}, {"value": "true", "variable": 80}, {"value": "true", "variable": 6}, {"value": "true", "variable": 59}, {"value": "true", "variable": 23}, {"value": "false", "variable": 105}, {"value": "false", "variable": 48}, {"value": "false", "variable": 21}, {"value": "false", "variable": 92}, {"value": "chairs_available", "variable": 81}, {"value": "true", "variable": 25}, {"value": "true", "variable": 37}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 62}, {"value": "false", "variable": 84}, {"value": "false", "variable": 33}, {"value": "0", "variable": 1}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 57}, {"value": "false", "variable": 79}, {"value": "false", "variable": 38}, {"value": "true", "variable": 115}, {"value": "false", "variable": 82}, {"value": "true", "variable": 112}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "over_20mm", "variable": 91}… internal 3227 kirkanta 84861 dc7d39db-b35a-4612-a921-1b7b24b0baa3 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1       https://kirkanta.kirjastot.fi/files/photos/medium/kapyla-4f901e36.jpg   https://maps.google.fi/?q=http:%2F%2Fwww.hel.fi%2Fpalvelukartta%2Fkml.aspx%3Flang%3Dfi%26id%3D8302&ll=60.21094,24.946893&spn=0.002041,0.014699&layer=c&cbll=60.210939,24.946887&cbp=12,143.57,,0,0&t=h&z=17&panoid=Bv4Yke-D0coS5kvoqnzw1w       Käpylän kirjasto Käpylä Library Väinölänkatu 5 Väinölägatan 5 Väinölänkatu 5 http://www.helmet.fi/kapylankirjasto http://www.helmet.fi/kottbybibliotek http://www.helmet.fi/kottbybibliotek   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 85061   +358 9 310 85061 kapylan_kirjasto@hel.fi https://www.lib.hel.fi/kapyla 2008-09-11T18:47:26+03:00 00610 www.hel.fi kaikki helsinki 2021-01-04T07:30:50.151088+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1402, 1403] helsinki [341, 337, 338, 331, 328, 349] [813, 806, 692, 691, 483] {} Point 24.94715 60.21072 PL 61455, 00099 HELSINGIN KAUPUNKI         Kottby bibliotek   2 6     2 P.O. Box 61455, 00099 HELSINGIN KAUPUNKI 1     5   PB 61455, 00099 HELSINGIN KAUPUNKI     3      
8308 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-ti, to-pe 11-18, suljettu ke, la-su", "sv": "\u00f6ppet m\u00e5n-tis, tor-fre 11-18, st\u00e4ngt ons, l\u00f6r-s\u00f6n", "en": "open Mon-Tue, Thu-Fri 11-18, closed Wed, Sat-Sun"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Aukioloajat", "sv": "\u00d6ppettider", "en": "Opening hours"}, "www": {"fi": "http://www.helmet.fi/kirjasto/84919/Aukioloajat/", "sv": "http://www.helmet.fi/bibliotek/84919/Kontaktuppgifter/", "en": "http://www.helmet.fi/library/84919/Contact_information/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "HIGHLIGHT", "name": {"fi": "COVID-19: Kirjastojen ohjeita epidemiakaudelle."}, "www": {"fi": "https://www.helmet.fi/fi-FI/Tapahtumat_ja_vinkit/Uutispalat/Kirjastoasioinnista_koronavirusepidemian(208997)"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Facebook", "sv": "Facebook", "en": "Facebook"}, "www": {"fi": "http://www.facebook.com/Viikinkirjasto", "sv": "http://www.facebook.com/Viikinkirjasto", "en": "http://www.facebook.com/Viikinkirjasto"}, "email": null, "phone": null, "contact_person": null}] [{"value": "true", "variable": 74}, {"value": "at_least_3600mm", "variable": 3}, {"value": "true", "variable": 73}, {"value": "outdoors", "variable": 2}, {"value": "2", "variable": 1}, {"value": "over_10m", "variable": 4}, {"value": "true", "variable": 57}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "false", "variable": 20}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 5}, {"value": "sufficiently_wide", "variable": 18}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 23}, {"value": "false", "variable": 34}, {"value": "true", "variable": 22}, {"value": "false", "variable": 21}, {"value": "false", "variable": 33}, {"value": "false", "variable": 29}, {"value": "false", "variable": 44}, {"value": "true", "variable": 72}, {"value": "false", "variable": 53}, {"value": "false", "variable": 37}, {"value": "true", "variable": 52}, {"value": "false", "variable": 49}, {"value": "false", "variable": 51}, {"value": "false", "variable": 50}, {"value": "true", "variable": 58}, {"value": "true", "variable": 70}, {"value": "over_20mm", "variable": 56}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "4", "variable": 63}, {"value": "false", "variable": 59}, {"value": "false", "variable": 62}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 103}, {"value": "false", "variable": 78}, {"value": "opens_automatically", "variable": 77}, {"value": "true", "variable": 76}, {"value": "false", "variable": 75}, {"value": "waiting_by_standing", "variable": 81}, {"value": "false", "variable": 102}, {"value": "false", "variable": 80}, {"value": "false", "variable": 79}, {"value": "false", "variable": 92}, {"value": "false", "variable": 82}, {"value": "false", "variable": 84}, {"value": "false", "variable": 83}, {"value": "false", "variable": 106}, {"value": "true", "variable": 112}, {"value": "true", "variable": 104}, {"value": "false", "variable": 109}, {"value": "true", "variable": 107}, {"value": "true", "variable… internal 3283 kirkanta 84919 dc7d39db-b35a-4612-a921-1b7b24b0baa3 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1       https://kirkanta.kirjastot.fi/files/photos/medium/viikki-4fd53186.jpg   https://maps.google.fi/?q=http:%2F%2Fwww.hel.fi%2Fpalvelukartta%2Fkml.aspx%3Flang%3Dfi%26id%3D8308&ll=60.227507,25.013702&spn=0.00204,0.014699&layer=c&cbll=60.22751,25.013702&cbp=12,249.85,,0,-7.55&t=h&panoid=5CU0lvpmY6g9xGCPNmhFdw&z=17       Viikin kirjasto Viikki Library Viikinkaari 11 B Viksbågen 11 B Viikinkaari 11 B http://www.helmet.fi/viikinkirjasto http://www.helmet.fi/viksbibliotek http://www.helmet.fi/viikkilibrary   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 85071   +358 9 310 85071 viikin_kirjasto@hel.fi https://www.lib.hel.fi/fi-FI/viikki/ 2008-09-11T18:47:26+03:00 00790 www.hel.fi kaikki helsinki 2021-01-04T07:30:50.170119+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1402, 1403] helsinki [341, 337, 338, 331, 328, 349] [813, 806, 692, 691, 483] {} Point 25.012651 60.227364 PL 71455, 00099 HELSINGIN KAUPUNKI         Viks bibliotek   4 8     2 P.O. Box 71455, 00099 HELSINGIN KAUPUNKI 1     8   PB 71455, 00099 HELSINGIN KAUPUNKI     11      
8324 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma, to 09-20, ti 09-18, pe 09-16, la 10-16, suljettu ke, su", "sv": "\u00f6ppet m\u00e5n, tor 09-20, tis 09-18, fre 09-16, l\u00f6r 10-16, st\u00e4ngt ons, s\u00f6n", "en": "open Mon, Thu 09-20, Tue 09-18, Fri 09-16, Sat 10-16, closed Wed, Sun"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Aukioloajat", "sv": "\u00d6ppettider", "en": "Opening hours"}, "www": {"fi": "http://www.helmet.fi/kirjasto/84854/Aukioloajat/", "sv": "http://www.helmet.fi/bibliotek/84854/Kontaktuppgifter/", "en": "http://www.helmet.fi/library/84854/Contact_information/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "HIGHLIGHT", "name": {"fi": "COVID-19: Kirjastojen ohjeita epidemiakaudelle."}, "www": {"fi": "https://www.helmet.fi/fi-FI/Tapahtumat_ja_vinkit/Uutispalat/Kirjastoasioinnista_koronavirusepidemian(208997)"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Facebook", "sv": "Facebook", "en": "Facebook"}, "www": {"fi": "http://www.facebook.com/jakomaenkirjasto", "sv": "http://www.facebook.com/jakomaenkirjasto", "en": "http://www.facebook.com/jakomaenkirjasto"}, "email": null, "phone": null, "contact_person": null}] [{"value": "over_20mm", "variable": 56}, {"value": "waiting_by_standing", "variable": 81}, {"value": "false", "variable": 44}, {"value": "false", "variable": 102}, {"value": "false", "variable": 80}, {"value": "false", "variable": 92}, {"value": "false", "variable": 107}, {"value": "at_least_4_steps", "variable": 24}, {"value": "true", "variable": 58}, {"value": "false", "variable": 105}, {"value": "false", "variable": 5}, {"value": "true", "variable": 23}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 28}, {"value": "false", "variable": 53}, {"value": "false", "variable": 49}, {"value": "true", "variable": 57}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 27}, {"value": "false", "variable": 37}, {"value": "false", "variable": 50}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 20}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 30}, {"value": "false", "variable": 84}, {"value": "false", "variable": 33}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 31}, {"value": "false", "variable": 79}, {"value": "true", "variable": 59}, {"value": "true", "variable": 62}, {"value": "true", "variable": 29}, {"value": "true", "variable": 51}, {"value": "0", "variable": 1}, {"value": "false", "variable": 82}, {"value": "true", "variable": 22}, {"value": "true", "variable": 52}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 98}, {"value": "false", "variable": 48}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "no_handrails", "variable": 32}, {"value": "false", "variable": 34}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "false", "variable": 25}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 38}, {"value": "false", "variable": 103}, {"value": "false", "variable": 104}, {"value": "false", "variable": 83}, {"value": "true", "variable": 21}] internal 3208 kirkanta 84854 dc7d39db-b35a-4612-a921-1b7b24b0baa3 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1       https://kirkanta.kirjastot.fi/files/photos/medium/jakomaki-4f901a81.jpg   https://maps.google.fi/?q=http:%2F%2Fwww.hel.fi%2Fpalvelukartta%2Fkml.aspx%3Flang%3Dfi%26id%3D8324&ll=60.26076,25.07653&spn=0.002038,0.014699&layer=c&cbll=60.260762,25.076529&cbp=12,211.05,,0,-2.85&t=h&panoid=0tUMQHUdgZuzh6hXnjeOaw&z=17       Jakomäen kirjasto Jakomäki Library Jakomäenpolku 3 Jakobackastigen 3 Jakomäenpolku 3 http://www.helmet.fi/jakomaenkirjasto http://www.helmet.fi/jakobackabibliotek http://www.helmet.fi/jakobackabibliotek   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 85077 +358 9 310 85977       2008-09-11T18:47:26+03:00 00770 www.hel.fi kaikki helsinki 2021-01-04T07:30:50.202806+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1402, 1403] helsinki [341, 337, 338, 331, 328, 349] [813, 806, 692, 691, 483] {} Point 25.076054 60.260307 PL 77455, 00099 HELSINGIN KAUPUNKI         Jakobacka bibliotek   6 9     2 P.O. Box 77455, 00099 HELSINGIN KAUPUNKI 1     8   PB 77455, 00099 HELSINGIN KAUPUNKI     8      
8350 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma, to 09-20, ti 09-18, pe 09-16, la 10-16, suljettu ke, su", "sv": "\u00f6ppet m\u00e5n, tor 09-20, tis 09-18, fre 09-16, l\u00f6r 10-16, st\u00e4ngt ons, s\u00f6n", "en": "open Mon, Thu 09-20, Tue 09-18, Fri 09-16, Sat 10-16, closed Wed, Sun"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Aukioloajat", "sv": "\u00d6ppettider", "en": "Opening hours"}, "www": {"fi": "http://www.helmet.fi/kirjasto/84857/Aukioloajat/", "sv": "http://www.helmet.fi/bibliotek/84857/Kontaktuppgifter/", "en": "http://www.helmet.fi/library/84857/Contact_information/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "HIGHLIGHT", "name": {"fi": "COVID-19: Kirjastojen ohjeita epidemiakaudelle."}, "www": {"fi": "https://www.helmet.fi/fi-FI/Tapahtumat_ja_vinkit/Uutispalat/Kirjastoasioinnista_koronavirusepidemian(208997)"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Facebook", "sv": "Facebook", "en": "Facebook"}, "www": {"fi": "http://www.facebook.com/Maunulankirjasto", "sv": "http://www.facebook.com/Maunulankirjasto", "en": "http://www.facebook.com/Maunulankirjasto"}, "email": null, "phone": null, "contact_person": null}] [{"value": "false", "variable": 117}, {"value": "false", "variable": 44}, {"value": "true", "variable": 76}, {"value": "false", "variable": 22}, {"value": "true", "variable": 72}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "true", "variable": 40}, {"value": "true", "variable": 114}, {"value": "opens_automatically", "variable": 77}, {"value": "true", "variable": 113}, {"value": "false", "variable": 116}, {"value": "false", "variable": 82}, {"value": "true", "variable": 107}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 51}, {"value": "handrails_on_one_side", "variable": 41}, {"value": "true", "variable": 5}, {"value": "true", "variable": 20}, {"value": "1", "variable": 63}, {"value": "false", "variable": 78}, {"value": "waiting_by_standing", "variable": 81}, {"value": "false", "variable": 33}, {"value": "false", "variable": 53}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 29}, {"value": "short_term_stay", "variable": 60}, {"value": "indoor_facility", "variable": 500}, {"value": "guided_and_clear", "variable": 19}, {"value": "true", "variable": 73}, {"value": "false", "variable": 83}, {"value": "0", "variable": 1}, {"value": "false", "variable": 79}, {"value": "false", "variable": 92}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 34}, {"value": "true", "variable": 38}, {"value": "false", "variable": 80}, {"value": "false", "variable": 98}, {"value": "true", "variable": 104}, {"value": "at_least_4_turning_steps", "variable": 39}, {"value": "false", "variable": 103}, {"value": "true", "variable": 50}, {"value": "false", "variable": 57}, {"value": "true", "variable": 112}, {"value": "true", "variable": 75}, {"value": "false", "variable": 48}, {"value": "false", "variable": 102}, {"value": "false", "variable": 23}, {"value": "false", "variable": 21}, {"value": "false", "variable": 49}, {"value": "true", "variable": 70}, {"value": "false", "variable": 62}, {"value": "sufficiently_wide", "variable": 18… internal 3177 kirkanta 84857 dc7d39db-b35a-4612-a921-1b7b24b0baa3 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1       https://kirkanta.kirjastot.fi/files/photos/medium/maunula-talo-maarit-hohteri-7-5a45f00b23fa86-93126689.jpg   https://maps.google.fi/?q=http:%2F%2Fwww.hel.fi%2Fpalvelukartta%2Fkml.aspx%3Flang%3Dfi%26id%3D8350&ll=60.234341,24.933064&spn=0.00204,0.014699&layer=c&cbll=60.234342,24.933061&cbp=12,220.53,,0,-0.37&t=h&panoid=DIvoEOrnKsJDxlUNvY-z8A&z=17       Maunulan kirjasto Maunula Library Metsäpurontie 4 Skogsbäcksvägen 4 Metsäpurontie 4 http://www.helmet.fi/maunulankirjasto http://www.helmet.fi/maunulankirjasto http://www.helmet.fi/maunulankirjasto   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 85063   +358 9 310 85663 maunulan_kirjasto@hel.fi   2008-09-11T18:47:26+03:00 00630 www.hel.fi kaikki helsinki 2021-01-04T07:30:50.265048+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1402, 1403] helsinki [341, 337, 338, 331, 328, 349] [813, 806, 692, 691, 483] {} Point 24.933672 60.231285 PL 63455, 00099 HELSINGIN KAUPUNKI         Månsas bibliotek   2 3     2 P.O. Box 63455, 00099 HELSINGIN KAUPUNKI 1     3   PB 63455, 00099 HELSINGIN KAUPUNKI     4      
9301 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-ti, to-pe 10-15, ke 09-14", "sv": "\u00f6ppet m\u00e5n-tis, tor-fre 10-15, ons 09-14", "en": "open Mon-Tue, Thu-Fri 10-15, Wed 09-14"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "HIGHLIGHT", "name": {"fi": "P\u00e4ihteet\u00f6nt\u00e4 p\u00e4iv\u00e4toimintaa ei tilap\u00e4isesti j\u00e4rjestet\u00e4.", "sv": "Missbrukarfri dagverksamhet ordnas f\u00f6r tillf\u00e4llet inte.", "en": "Substance-free day activities are not organised at present."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "HIGHLIGHT", "name": {"fi": "Jos sinulla on koronavirustartunnan oireita ja tarvitset toimintaohjeet, soita Helsingin koronavirusneuvontaan p. 09\u202f310 10024 (p\u00e4ivitt\u00e4in klo 8-18). Koronavirusneuvonnasta voit varata ajan koronavirustestiin. Sinut ohjataan my\u00f6s tarvittaessa koronaterveysasemalle.\nJos asia ei voi odottaa koronaneuvonnan aukeamista tai kyse on muusta kiireellisest\u00e4 sairaudesta, soita P\u00e4ivystysapuun, p. 116\u202f117.", "sv": "Om du har symtom p\u00e5 coronavirus och beh\u00f6ver r\u00e5d om vad du ska g\u00f6ra, ring Helsingfors coronavirusr\u00e5dgivning p\u00e5 09 310 10024 (dagligen kl. 8-18). Via coronavirusr\u00e5dgivningen kan du boka tid f\u00f6r ett coronavirustest. Vid behov kan du ocks\u00e5 h\u00e4nvisas till en h\u00e4lsostation f\u00f6r coronapatienter.\nOm \u00e4rendet inte kan v\u00e4nta tills coronavirusr\u00e5dgivningen \u00f6ppnar eller om det \u00e4r fr\u00e5ga om n\u00e5gon annan akut sjukdom, betj\u00e4nar jourhj\u00e4lpen p\u00e5 tfn 116 117.", "en": "If you have symptoms indicative of a coronavirus infection and need instructions on what to do, call Helsinki's Coronavirus Helpline, open every day of the week from 8 am to 6 pm at tel. 09 310 10024. You can book an appointment for a coronavirus test via the helpline. If necessary, you will also be directed to a coronavirus health station.\nIf you cannot wait for the Coronav… [{"value": "false", "variable": 115}, {"value": "false", "variable": 83}, {"value": "true", "variable": 109}, {"value": "false", "variable": 58}, {"value": "true", "variable": 59}, {"value": "false", "variable": 106}, {"value": "true", "variable": 52}, {"value": "false", "variable": 102}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 49}, {"value": "true", "variable": 50}, {"value": "on_door", "variable": 110}, {"value": "false", "variable": 103}, {"value": "true", "variable": 105}, {"value": "false", "variable": 21}, {"value": "false", "variable": 48}, {"value": "false", "variable": 53}, {"value": "narrow", "variable": 18}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 62}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 23}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 44}, {"value": "true", "variable": 37}, {"value": "false", "variable": 113}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "false", "variable": 22}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "false", "variable": 33}, {"value": "true", "variable": 29}, {"value": "false", "variable": 98}, {"value": "false", "variable": 112}, {"value": "false", "variable": 38}, {"value": "true", "variable": 6}, {"value": "false", "variable": 20}, {"value": "true", "variable": 5}, {"value": "true", "variable": 114}, {"value": "true", "variable": 107}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 118}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 116}, {"value": "handrails_on_both_sides", "variable": 32}, {"value": "handrails_on_both_sides", "variable": 47}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 117}, {"value": "false", "variable": 46}, {"value": "true", "variable": 51}, {"value": "true", "variable": 104}, {"val… internal 3701     d4b3a166-9fa0-4846-9d63-ff1fdab670b6 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Päivätoiminta Itiksen Symppis Itiksen Symppis Turunlinnantie 14 A Åbohusvägen 14 A Turunlinnantie 14 A https://www.hel.fi/helsinki/fi/sosiaali-ja-terveyspalvelut/mielenterveys-ja-paihdepalvelut/paihdepalvelut/paivatoiminta/symppikset/ https://www.hel.fi/helsinki/fi/sosiaali-ja-terveyspalvelut/mielenterveys-ja-paihdepalvelut/paihdepalvelut/paivatoiminta/symppikset/ https://www.hel.fi/helsinki/en/socia-health/mental/day/smile/   pvm/mpm lna/msa local network charge/mobile call charge   +358 40 637 8837   +358 9 310 45287 seppo.paakkinen@hel.fi   2009-03-02T10:04:22+02:00 00930 www.hel.fi kaikki helsinki 2021-01-04T11:30:59.127989+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [783, 986] helsinki [835, 1056] [547] {} Point 25.078781 60.210663 PL 93734, 00099 Helsingin kaupunki         Itiksen Symppis   3 8     2 P.O. Box 93734, 00099 City of Helsinki 1     8   PB 93734, 00099 Helsingfors stad     4      
15376 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-ti, to-pe 11-18, suljettu ke, la-su", "sv": "\u00f6ppet m\u00e5n-tis, tor-fre 11-18, st\u00e4ngt ons, l\u00f6r-s\u00f6n", "en": "open Mon-Tue, Thu-Fri 11-18, closed Wed, Sat-Sun"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Aukioloajat", "sv": "\u00d6ppettider", "en": "Opening hours"}, "www": {"fi": "http://www.helmet.fi/kirjasto/84916/Aukioloajat/", "sv": "http://www.helmet.fi/bibliotek/84916/Kontaktuppgifter/", "en": "http://www.helmet.fi/library/84916/Contact_information/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Flickr", "sv": "Flickr", "en": "Flickr"}, "www": {"fi": "http://www.flickr.com/photos/helmetkirjasto/collections/72157629932096035/", "sv": "http://www.flickr.com/photos/helmetkirjasto/collections/72157629932096035/", "en": "http://www.flickr.com/photos/helmetkirjasto/collections/72157629932096035/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "YouTube", "sv": "YouTube", "en": "YouTube"}, "www": {"fi": "http://www.youtube.com/user/Soukankirjasto", "sv": "http://www.youtube.com/user/Soukankirjasto", "en": "http://www.youtube.com/user/Soukankirjasto"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Facebook", "sv": "Facebook", "en": "Facebook"}, "www": {"fi": "http://www.facebook.com/soukankirjasto", "sv": "http://www.facebook.com/soukankirjasto", "en": "http://www.facebook.com/soukankirjasto"}, "email": null, "phone": null, "contact_person": null}] [{"value": "false", "variable": 84}, {"value": "true", "variable": 62}, {"value": "false", "variable": 50}, {"value": "true", "variable": 37}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 35}, {"value": "false", "variable": 49}, {"value": "true", "variable": 29}, {"value": "false", "variable": 5}, {"value": "true", "variable": 23}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 48}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 22}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 38}, {"value": "false", "variable": 102}, {"value": "false", "variable": 20}, {"value": "handrails_on_one_side", "variable": 32}, {"value": "true", "variable": 80}, {"value": "false", "variable": 82}, {"value": "true", "variable": 51}, {"value": "0", "variable": 1}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 33}, {"value": "true", "variable": 104}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "smooth", "variable": 17}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 83}, {"value": "false", "variable": 57}, {"value": "false", "variable": 103}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "at_least_4_steps", "variable": 24}, {"value": "false", "variable": 98}, {"value": "false", "variable": 92}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 21}, {"value": "true", "variable": 25}, {"value": "false", "variable": 44}, {"value": "true", "variable": 31}, {"value": "false", "variable": 52}, {"value": "false", "variable": 105}, {"value": "false", "variable": 34}, {"value": "false", "variable": 28}, {"value": "false", "variable": 107}, {"value": "true", "variable": 59}, {"value": "false", "variable": 79}] internal 4431 kirkanta 84916 d8dab34f-a68f-4244-b906-84e7f651b8e1 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1       https://kirkanta.kirjastot.fi/files/photos/medium/5f7adf0dda7b0384704212.jpg           Soukan kirjasto Soukka Library Soukantie 4 Sökövägen 4 Soukantie 4 http://www.helmet.fi/sokobibliotek http://www.helmet.fi/sokobibliotek http://www.helmet.fi/sokobibliotek   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8165 7736   +358 9 8165 7736 kirjasto.soukka@espoo.fi http://www.helmet.fi/fi-FI/Kirjastot_ja_palvelut/Soukan_kirjasto 2010-03-16T16:09:31+02:00 02360 www.espoo.fi kaikki espoo 2021-01-04T07:30:52.918517+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1402, 1403] espoo [328, 349] [813] {"fi": ["helmet", "kaunokirjallisuus", "kirjallisuus", "langaton verkko", "lasten nurkka", "tietokirjallisuus", "WLAN", "kirjasto"], "sv": ["barnh\u00f6rna", "bibliotek", "bok", "CD", "datorer", "DVD", "facklitteratur", "helmet", "sk\u00f6nlitteratur"]} Point 24.672998 60.13772 PL 3614, 02070 ESPOON KAUPUNKI         Sökö bibliotek   5 7     2 P.O. Box 3614, 02070 ESPOON KAUPUNKI 1     7   PB 3614, 02070 ESPOON KAUPUNKI     7      
18584 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna to 12-17, pe 09-12, suljettu ma-ke, la-su", "sv": "\u00f6ppet tor 12-17, fre 09-12, st\u00e4ngt m\u00e5n-ons, l\u00f6r-s\u00f6n", "en": "open Thu 12-17, Fri 09-12, closed Mon-Wed, Sat-Sun"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Aukioloajat", "sv": "\u00d6ppettider", "en": "Opening hours"}, "www": {"fi": "http://www.helmet.fi/kirjasto/84872/Aukioloajat/", "sv": "http://www.helmet.fi/bibliotek/84872/Kontaktuppgifter/", "en": "http://www.helmet.fi/library/84872/Contact_information/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "YouTube", "sv": "YouTube", "en": "YouTube"}, "www": {"fi": "http://www.youtube.com/user/HelMetVantaa", "sv": "http://www.youtube.com/user/HelMetVantaa", "en": "http://www.youtube.com/user/HelMetVantaa"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Flickr", "sv": "Flickr", "en": "Flickr"}, "www": {"fi": "http://www.flickr.com/photos/vantaankaupunginkirjasto", "sv": "http://www.flickr.com/photos/vantaankaupunginkirjasto", "en": "http://www.flickr.com/photos/vantaankaupunginkirjasto"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Twitter", "sv": "Twitter", "en": "Twitter"}, "www": {"fi": "http://twitter.com/vantaankirjasto", "sv": "http://twitter.com/vantaankirjasto", "en": "http://twitter.com/vantaankirjasto"}, "email": null, "phone": null, "contact_person": null}] [{"value": "over_10m", "variable": 4}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 57}, {"value": "on_door", "variable": 110}, {"value": "false", "variable": 44}, {"value": "soft", "variable": 17}, {"value": "true", "variable": 113}, {"value": "false", "variable": 34}, {"value": "false", "variable": 42}, {"value": "true", "variable": 118}, {"value": "true", "variable": 117}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 115}, {"value": "true", "variable": 104}, {"value": "false", "variable": 28}, {"value": "1", "variable": 1}, {"value": "false", "variable": 111}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 22}, {"value": "true", "variable": 50}, {"value": "true", "variable": 52}, {"value": "false", "variable": 92}, {"value": "narrow", "variable": 18}, {"value": "false", "variable": 33}, {"value": "true", "variable": 116}, {"value": "true", "variable": 38}, {"value": "true", "variable": 62}, {"value": "false", "variable": 20}, {"value": "handrails_on_both_sides", "variable": 32}, {"value": "true", "variable": 109}, {"value": "true", "variable": 5}, {"value": "false", "variable": 83}, {"value": "handrails_on_one_side", "variable": 41}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 30}, {"value": "true", "variable": 112}, {"value": "true", "variable": 37}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "true", "variable": 51}, {"value": "true", "variable": 114}, {"value": "at_least_4_steps", "variable": 39}, {"value": "false", "variable": 43}, {"value": "true", "variable": 40}, {"value": "true", "variable": 107}, {"value": "false", "variable": 98}, {"value": "false", "variable": 84}, {"value": "false", "variable": 80}, {"value": "true", "variable": 29}, {"value": "false", "variable": 21}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 59}, {"value": "false", "variable": 102}, {"value": "false",… internal 5264 kirkanta 84872 a897af2b-1f42-4772-b19a-ca7fe20a6704 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1       https://kirkanta.kirjastot.fi/files/photos/medium/hiekkaharju-3543x2362-tony-rintamaki-56a88175438a4.jpg           Hiekkaharjun kirjasto Hiekkaharju Library Urheilutie 4 Idrottsvägen 4 Urheilutie 4 http://www.helmet.fi/hiekkaharjunkirjasto http://www.helmet.fi/ http://www.helmet.fi/   pvm/mpm lna/msa local network charge/mobile call charge   +358 43 825 7498   +358 50 302 8673 lisbet.muurinen@vantaa.fi   2011-05-11T12:25:37+03:00 01370 www.vantaa.fi kaikki vantaa 2021-01-04T07:30:55.026637+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1402, 1403] vantaa [328, 349] [813] {} Point 25.058722 60.296253 PL 20, 01030 VANTAAN KAUPUNKI         Sandkulla bibliotek   2 6     2 P.O. Box 20, 01030 VANTAAN KAUPUNKI 1     6   PB 20, 01030 VANTAAN KAUPUNKI     8      

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