5 rows where accessibility_shortcoming_count_visually_impaired = 8 and identifiers_1_namespace = "kirkanta"

View and edit SQL

Suggested facets: address_postal_full_en

provider_type

identifiers_1_namespace

  • kirkanta · 5

accessibility_shortcoming_count_visually_impaired

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      
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      
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      
18620 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-ti 13-20, to-pe 08-16, suljettu ke, la-su", "sv": "\u00f6ppet m\u00e5n-tis 13-20, tor-fre 08-16, st\u00e4ngt ons, l\u00f6r-s\u00f6n", "en": "open Mon-Tue 13-20, Thu-Fri 08-16, 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/84875/Aukioloajat/", "sv": "http://www.helmet.fi/bibliotek/84875/Kontaktuppgifter/", "en": "http://www.helmet.fi/library/84875/Contact_information/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Facebook", "sv": "Facebook", "en": "Facebook"}, "www": {"fi": "https://www.facebook.com/lansimaenkirjasto", "sv": "https://www.facebook.com/lansimaenkirjasto", "en": "https://www.facebook.com/lansimaenkirjasto"}, "email": null, "phone": null, "contact_person": null}] [{"value": "false", "variable": 103}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 49}, {"value": "false", "variable": 34}, {"value": "true", "variable": 52}, {"value": "false", "variable": 20}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 53}, {"value": "true", "variable": 62}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 107}, {"value": "handrails_on_both_sides", "variable": 32}, {"value": "false", "variable": 5}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 45}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 98}, {"value": "false", "variable": 79}, {"value": "true", "variable": 29}, {"value": "false", "variable": 48}, {"value": "true", "variable": 57}, {"value": "false", "variable": 105}, {"value": "false", "variable": 38}, {"value": "true", "variable": 59}, {"value": "false", "variable": 31}, {"value": "false", "variable": 23}, {"value": "false", "variable": 21}, {"value": "false", "variable": 104}, {"value": "false", "variable": 80}, {"value": "false", "variable": 33}, {"value": "false", "variable": 102}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 92}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 58}, {"value": "false", "variable": 22}, {"value": "false", "variable": 46}, {"value": "0", "variable": 1}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 50}, {"value": "no_handrails", "variable": 47}, {"value": "false", "variable": 84}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 30}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 37}, {"value": "false", "variable": 82}, {"value": "true", "variable": 44}, {"value": "waiting_by_standing", "variable": 81}, {"value": "false", "variable": 83}, {"value": "true", "variable": 51}, {"value": "smooth", "variable": 17}] internal 5123 kirkanta 84875 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/kirjasto-5b1546cd47a9f9-30697554.png     Kirjastossa on lehtiä, kirjoja, musiikkia, elokuvia ja muita aineistoja, joihin voit tutustua paikan päällä tai lainata kotiin. Kirjaston tiloissa voit opiskella, harrastaa ja oleskella. Siellä järjestetään myös opastuksia, neuvontaa, tapahtumia ja näyttelyitä. Kirjastossa on käytössä langaton verkko, tietokoneita ja yleisimmät tietokoneohjelmat.     Länsimäen kirjasto Länsimäki Library Suunnistajankuja 2 Orienterargränden 2 Suunnistajankuja 2 http://www.helmet.fi/lansimaenkirjasto http://www.helmet.fi/ http://www.helmet.fi/   pvm/mpm lna/msa local network charge/mobile call charge   +358 43 825 1548   +358 9 8393 1017 margarita.vidinovska@vantaa.fi http://www.vantaa.fi/fi/kirjasto/kirjastot_ja_aukioloajat_/lansimaen_kirjasto 2011-05-11T12:25:37+03:00 01280 www.vantaa.fi kaikki vantaa 2021-01-04T07:30:55.064279+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.11454 60.24641 PL 20, 01030 VANTAAN KAUPUNKI         Västerkulla bibliotek   4 5     1 P.O. Box 20, 01030 VANTAAN KAUPUNKI 1     5   PB 20, 01030 VANTAAN KAUPUNKI     8      
45317 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma 09-20, ti, to 09-18, pe 09-16, la 10-16, suljettu ke, su", "sv": "\u00f6ppet m\u00e5n 09-20, tis, tor 09-18, fre 09-16, l\u00f6r 10-16, st\u00e4ngt ons, s\u00f6n", "en": "open Mon 09-20, Tue, Thu 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/86406/Aukioloajat/", "sv": "http://www.helmet.fi/bibliotek/86406/Kontaktuppgifter/", "en": "http://www.helmet.fi/library/86406/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": "https://www.facebook.com/jatkasaarenkirjasto", "sv": "https://www.facebook.com/jatkasaarenkirjasto", "en": "https://www.facebook.com/jatkasaarenkirjasto"}, "email": null, "phone": null, "contact_person": null}] [{"value": "false", "variable": 92}, {"value": "true", "variable": 115}, {"value": "true", "variable": 73}, {"value": "true", "variable": 112}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 113}, {"value": "0", "variable": 1}, {"value": "false", "variable": 79}, {"value": "false", "variable": 48}, {"value": "false", "variable": 82}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 74}, {"value": "false", "variable": 23}, {"value": "false", "variable": 44}, {"value": "false", "variable": 31}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 50}, {"value": "false", "variable": 22}, {"value": "false", "variable": 34}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 106}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 84}, {"value": "floor_1", "variable": 108}, {"value": "true", "variable": 29}, {"value": "false", "variable": 62}, {"value": "false", "variable": 59}, {"value": "true", "variable": 52}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "smooth", "variable": 17}, {"value": "opens_automatically_with_button", "variable": 54}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 53}, {"value": "false", "variable": 83}, {"value": "true", "variable": 105}, {"value": "true", "variable": 107}, {"value": "true", "variable": 117}, {"value": "true", "variable": 116}, {"value": "opens_automatically", "variable": 77}, {"value": "true", "variable": 118}, {"value": "true", "variable": 58}, {"value": "false", "variable": 76}, {"value": "true", "variable": 72}, {"value": "false", "variable": 33}, {"value": "false", "variable": 102}, {"value": "true", "variable": 114}, {"value": "false", "variable": 21}, {"value": "true", "variable": 78}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "false", "variable": 49}, {"value": "true", "variable": 75}, {"value": "false", "variable": 98}, {"value": "true", "variable": 104}, {"value": "true", "v… internal 17137 kirkanta 86406 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/jätkäsaari-käsitelty-596310e396894.jpg           Jätkäsaaren kirjasto ja infokeskus Jätkäsaari Library Tyynenmerenkatu 1 Stillahavsgatan 1 Tyynenmerenkatu 1 www.helmet.fi/jätkäsaari www.helmet.fi/busholmen www.helmet.fi/busholmen   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 85815   +358 9 310 85815 jatkasaaren_kirjasto@hel.fi https://www.helmet.fi/fi-FI/Kirjastot_ja_palvelut/Jatkasaaren_kirjasto_ja_infokeskus 2015-06-22T09:58:27+03:00 00220 www.hel.fi kaikki helsinki 2021-01-04T07:31:30.683681+02:00 {"00": null, "11": "green", "12": "red", "13": "red", "21": "green", "22": "red", "23": "red", "31": "green", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} [1402, 1403] helsinki [341, 337, 338, 331, 328, 349] [813, 806, 692, 691, 483] {} Point 24.920868 60.159977 PL 22455, 00099 HELSINGIN KAUPUNKI         Busholmens bibliotek och infocenter   2 2       P.O. Box 22455, 00099 HELSINGIN KAUPUNKI 1     2   PB 22455, 00099 HELSINGIN 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
);