6 rows where identifiers_2_namespace = "kirkanta" sorted by accessibility_shortcoming_count_stroller

View and edit SQL

Suggested facets: contract_type_description_fi, contract_type_description_sv, contract_type_description_en, created_time, data_source, accessibility_viewpoints, root_service_nodes, service_nodes, services, keywords, accessibility_shortcoming_count_reduced_mobility, accessibility_shortcoming_count_wheelchair, accessibility_shortcoming_count_rollator, created_time (date), last_modified_time (date)

identifiers_2_namespace

  • kirkanta · 6
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
8154 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma, to 08-20, ti, pe 08-18, la 10-16, suljettu ke, su", "sv": "\u00f6ppet m\u00e5n, tor 08-20, tis, fre 08-18, l\u00f6r 10-16, st\u00e4ngt ons, s\u00f6n", "en": "open Mon, Thu 08-20, Tue, Fri 08-18, 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/84912/Aukioloajat/", "sv": "http://www.helmet.fi/bibliotek/84912/Kontaktuppgifter/", "en": "http://www.helmet.fi/library/84912/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/Rikhardinkadunkirjasto", "sv": "http://www.facebook.com/Rikhardinkadunkirjasto", "en": "http://www.facebook.com/Rikhardinkadunkirjasto"}, "email": null, "phone": null, "contact_person": null}] [{"value": "true", "variable": 37}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "true", "variable": 35}, {"value": "false", "variable": 34}, {"value": "false", "variable": 29}, {"value": "0", "variable": 1}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 23}, {"value": "true", "variable": 6}, {"value": "true", "variable": 5}, {"value": "true", "variable": 22}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 21}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 79}, {"value": "false", "variable": 48}, {"value": "false", "variable": 43}, {"value": "at_least_4_steps", "variable": 39}, {"value": "false", "variable": 38}, {"value": "true", "variable": 50}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 49}, {"value": "false", "variable": 44}, {"value": "false", "variable": 55}, {"value": "true", "variable": 51}, {"value": "requires_use_of_buzzer_opening_easily_manually", "variable": 54}, {"value": "false", "variable": 52}, {"value": "false", "variable": 58}, {"value": "true", "variable": 78}, {"value": "1", "variable": 63}, {"value": "false", "variable": 57}, {"value": "false", "variable": 62}, {"value": "false", "variable": 33}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 59}, {"value": "true", "variable": 70}, {"value": "is_heavy", "variable": 77}, {"value": "true", "variable": 73}, {"value": "true", "variable": 72}, {"value": "true", "variable": 20}, {"value": "true", "variable": 74}, {"value": "false", "variable": 76}, {"value": "false", "variable": 75}, {"value": "true", "variable": 80}, {"value": "floor_-1", "variable": 108}, {"value": "false", "variable": 84}, {"value": "false", "variable": 83}, {"value": "waiting_by_standing", "variable": 81}, {"value": "false", "variable": 82}, {"value": "false", "variable": 98}, {"value": "true", "variable": 105}, {"value": "false", "variable": 92}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variab… internal 3069 visithelsinki 644 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/rikhardinkatu-4f902417.jpg   https://maps.google.fi/?q=http:%2F%2Fwww.hel.fi%2Fpalvelukartta%2Fkml.aspx%3Flang%3Dfi%26id%3D8154&ll=60.166061,24.946228&spn=0.002044,0.014699&layer=c&cbll=60.166062,24.946224&cbp=12,65.78,,0,-2.97&t=h&panoid=NEGexoVuRwZyKbh9nmHD6A&z=17       Rikhardinkadun kirjasto Rikhardinkatu Library Rikhardinkatu 3 Richardsgatan 3 Rikhardinkatu 3 http://www.helmet.fi/rikhardinkadunkirjasto http://www.helmet.fi/richardsgatansbibliotek http://www.helmet.fi/richardsgatansbibliotek   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 85013   +358 9 310 85013 rikhardinkadun_kirjasto@hel.fi https://www.helmet.fi/rikhardinkadunkirjasto 2008-09-11T18:47:26+03:00 00130 www.hel.fi kaikki helsinki 2021-01-04T07:30:49.862804+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} [1402, 1403] helsinki [749, 357, 341, 337, 338, 331, 328, 349] [813, 806, 692, 691, 483, 474, 473] {} Point 24.946783 60.166336 PL 13455, 00099 HELSINGIN KAUPUNKI 84912       Richardsgatans bibliotek   3 4       P.O. Box 13455, 00099 HELSINGIN KAUPUNKI 1     4 kirkanta PB 13455, 00099 HELSINGIN KAUPUNKI     6      
8177 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma, to 09-20, ti, pe 09-18, la 10-16, suljettu ke, su", "sv": "\u00f6ppet m\u00e5n, tor 09-20, tis, fre 09-18, l\u00f6r 10-16, st\u00e4ngt ons, s\u00f6n", "en": "open Mon, Thu 09-20, Tue, Fri 09-18, 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/84862/Aukioloajat/", "sv": "http://www.helmet.fi/bibliotek/84862/Kontaktuppgifter/", "en": "http://www.helmet.fi/library/84862/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/Oulunkylankirjasto/", "sv": "http://www.facebook.com/Oulunkylankirjasto/", "en": "http://www.facebook.com/Oulunkylankirjasto/"}, "email": null, "phone": null, "contact_person": null}] [{"value": "false", "variable": 82}, {"value": "true", "variable": 44}, {"value": "false", "variable": 22}, {"value": "false", "variable": 103}, {"value": "true", "variable": 57}, {"value": "true", "variable": 104}, {"value": "true", "variable": 53}, {"value": "false", "variable": 92}, {"value": "true", "variable": 111}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "true", "variable": 114}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 33}, {"value": "true", "variable": 80}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 21}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "true", "variable": 117}, {"value": "false", "variable": 23}, {"value": "false", "variable": 48}, {"value": "true", "variable": 106}, {"value": "true", "variable": 115}, {"value": "false", "variable": 38}, {"value": "under_20mm", "variable": 91}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 112}, {"value": "false", "variable": 29}, {"value": "true", "variable": 5}, {"value": "false", "variable": 79}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 52}, {"value": "on_door", "variable": 110}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 83}, {"value": "false", "variable": 98}, {"value": "true", "variable": 109}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 46}, {"value": "true", "variable": 20}, {"value": "under_20mm", "variable": 56}, {"value": "0", "variable": 1}, {"value": "true", "variable": 51}, {"value": "false", "variable": 84}, {"value": "true", "variable": 116}, {"value": "false", "variable": 34}, {"value": "false", "variable": 49}, {"value": "true", "variable": 113}, {"value": "true", "variable": 37}, {"value": "false", "variable": 102}, {"value": "true", "variable": 62}, {"value": "true", "variable": 6}, {"value": "no_handrails", "variable": 47}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "tru… internal 3047 visithelsinki 3110 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/uusi-kuva-2016-rajattu-574eba64d0316.jpg   https://maps.google.fi/?q=http:%2F%2Fwww.hel.fi%2Fpalvelukartta%2Fkml.aspx%3Flang%3Dfi%26id%3D8177&ll=60.227997,24.962354&spn=0.00204,0.014699&layer=c&cbll=60.227999,24.96235&cbp=12,59.65,,0,0&t=h&z=17&panoid=9-jl0Ark0nho1PmCL3b1AA       Oulunkylän kirjasto Oulunkylä Library Kylänvanhimmantie 27 Byäldstevägen 27 Kylänvanhimmantie 27 http://www.helmet.fi/oulunkylankirjasto http://www.helmet.fi/aggelbybibliotek http://www.helmet.fi/aggelbybibliotek   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 85064   +358 9 310 85064 oulunkylan_kirjasto@hel.fi https://www.lib.hel.fi/fi-FI/oulunkyla/ 2008-09-11T18:47:26+03:00 00640 www.hel.fi kaikki helsinki 2021-01-04T07:30:49.889624+02:00 {"00": null, "11": "green", "12": "red", "13": "green", "21": "green", "22": "red", "23": "green", "31": "green", "32": "red", "33": "green", "41": "green", "51": "red", "52": "red", "61": "green"} [1402, 1403] helsinki [749, 341, 337, 338, 331, 328, 349] [813, 806, 692, 691, 483, 473] {} Point 24.962605 60.22807 PL 64455, 00099 HELSINGIN KAUPUNKI 84862       Åggelby bibliotek   1 1       P.O. Box 64455, 00099 HELSINGIN KAUPUNKI       1 kirkanta PB 64455, 00099 HELSINGIN KAUPUNKI     1      
21242 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-ti, to-pe 11-16, suljettu ke, la-su", "sv": "\u00f6ppet m\u00e5n-tis, tor-fre 11-16, st\u00e4ngt ons, l\u00f6r-s\u00f6n", "en": "open Mon-Tue, Thu-Fri 11-16, closed Wed, Sat-Sun"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Instagram", "sv": "Instagram", "en": "Instagram"}, "www": {"fi": "https://www.instagram.com/kansalliskirjasto/", "sv": "https://www.instagram.com/kansalliskirjasto/", "en": "https://www.instagram.com/kansalliskirjasto/"}, "email": null, "phone": null, "contact_person": null}] [] internal 6292 visithelsinki 332 506a2b5e-216a-4da6-90d3-db01bf42ff10 506a2b5e-216a-4da6-90d3-db01bf42ff10 SELF_PRODUCED   state_service valtion palvelu statlig tjänst state service 1       https://kirkanta.kirjastot.fi/files/photos/medium/kanki-k-590867ab71c76.jpg           Kansalliskirjasto The National Library Unioninkatu 36 Unionsgatan 36 Unioninkatu 36 https://www.facebook.com/Kansalliskirjasto/ https://twitter.com/NatLibFi http://www.kansalliskirjasto.fi/                     2011-05-25T14:54:37+03:00 00170 www.helsinki.fi kaikki helsinki 2021-01-04T07:30:58.652251+02:00   [1403] helsinki [749, 357, 2194, 2197] [879, 474, 473] {} Point 24.950335 60.17037 PL 15, 00014 HELSINGIN YLIOPISTO 86154       Nationalbiblioteket             P.O. Box 15, 00014 HELSINGIN YLIOPISTO         kirkanta PB 15, 00014 HELSINGIN YLIOPISTO            
51342 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-ti, to-pe 08-20, ke 12-18, la-su 10-18", "sv": "\u00f6ppet m\u00e5n-tis, tor-fre 08-20, ons 12-18, l\u00f6r-s\u00f6n 10-18", "en": "open Mon-Tue, Thu-Fri 08-20, Wed 12-18, Sat-Sun 10-18"}, "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/86476/Aukioloajat/", "sv": "http://www.helmet.fi/bibliotek/86476/Kontaktuppgifter/", "en": "http://www.helmet.fi/library/86476/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": "LINK", "name": {"fi": "Keskustakirjasto Oodin verkkosivut", "sv": "Keskustakirjasto Oodin verkkosivut", "en": "Keskustakirjasto Oodin verkkosivut"}, "www": {"fi": "https://www.oodihelsinki.fi/", "sv": "https://www.oodihelsinki.fi/", "en": "https://www.oodihelsinki.fi/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Oodin laite- ja tilavaraukset", "sv": "Oodin laite- ja tilavaraukset", "en": "Oodin laite- ja tilavaraukset"}, "www": {"fi": "https://varaamo.hel.fi/search?search=oodi", "sv": "https://varaamo.hel.fi/search?search=oodi", "en": "https://varaamo.hel.fi/search?search=oodi"}, "email": null, "phone": null, "contact_person": null}] [{"value": "true", "variable": 115}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 83}, {"value": "false", "variable": 103}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 80}, {"value": "false", "variable": 92}, {"value": "true", "variable": 114}, {"value": "false", "variable": 33}, {"value": "true", "variable": 58}, {"value": "false", "variable": 104}, {"value": "true", "variable": 107}, {"value": "false", "variable": 51}, {"value": "false", "variable": 49}, {"value": "true", "variable": 5}, {"value": "false", "variable": 38}, {"value": "true", "variable": 37}, {"value": "true", "variable": 109}, {"value": "false", "variable": 22}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "false", "variable": 29}, {"value": "true", "variable": 118}, {"value": "false", "variable": 98}, {"value": "true", "variable": 112}, {"value": "true", "variable": 116}, {"value": "true", "variable": 52}, {"value": "true", "variable": 117}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "true", "variable": 20}, {"value": "true", "variable": 6}, {"value": "false", "variable": 102}, {"value": "true", "variable": 59}, {"value": "false", "variable": 106}, {"value": "true", "variable": 57}, {"value": "next_to_door_on_opening_side", "variable": 110}, {"value": "true", "variable": 84}, {"value": "false", "variable": 23}, {"value": "true", "variable": 50}, {"value": "true", "variable": 111}, {"value": "false", "variable": 48}, {"value": "false", "variable": 34}, {"value": "indoor_facility", "variable": 500}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 82}, {"value": "true", "variable": 113}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "true", "variable": 105}, {"value": "false", "variable": 53}, {"value": "true", "variable": 79}, {"value": "under_20mm", "variable": 56}, {"value": "smooth", "variable": 17}, {"value": "sufficiently_wide", "variable": 18}, {"value": "under_20mm",… internal 9600 visithelsinki 3089 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/5d7147dd56b25029363143.JPG     Oodi on tapahtumapaikka, lukemisen talo ja monipuolinen kaupunkikokemus.Oodi tarjoaa tietoja, taitoja ja tarinoita, ja sinne on helppo tulla oppimaan,eläytymään, nauttimaan ja työskentelemään. Kaikille avoin uuden ajan kirjastoon elävä ja toiminnallinen kohtaamispaikka. Oodi is a venue for events, a house of reading and a diverse urban experience.It will provide its users with knowledge, new skills and stories, and will be aneasy place to access for learning, story immersion, work and relaxation. Oodiis a library of a new era, a living and functional meeting place open for all.   Keskustakirjasto Oodi Helsinki Central Library Oodi Töölönlahdenkatu 4 Tölöviksgatan 4 Töölönlahdenkatu 4 http://www.helmet.fi/fi-FI/Kirjastot_ja_palvelut/Keskustakirjasto_Oodi http://www.helmet.fi/fi-FI/Kirjastot_ja_palvelut/Keskustakirjasto_Oodi http://www.helmet.fi/fi-FI/Kirjastot_ja_palvelut/Keskustakirjasto_Oodi   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 85000     oodi@hel.fi http://www.helmet.fi/oodi 2016-09-22T10:17:58+03:00 00100 www.hel.fi kaikki helsinki 2021-01-04T07:31:36.261200+02:00 {"00": null, "11": "green", "12": "red", "13": "green", "21": "green", "22": "red", "23": "green", "31": "green", "32": "red", "33": "green", "41": "green", "51": "red", "52": "red", "61": "green"} [1402, 1403] helsinki [738, 355, 749, 341, 337, 338, 331, 328, 349] [813, 806, 692, 691, 483, 473, 345, 239] {"fi": ["Grafiikkaty\u00f6asema", "Monitoimisali", "Studio"]} Point 24.938158 60.17397 PL 10455, 00099 HELSINKI 86476       Helsingfors centrumbibliotek Ode Helsingin keskustakirjasto Oodi on elävä kohtaamispaikka Kansalaistorilla, aivan Helsingin sydämessä. 1 1       P.O. Box 10455, 00099 HELSINKI       1 kirkanta PB 10455, 00099 HELSINKI Ode, Helsingfors centrumbibliotek, är en levande mötesplats på Medborgarplatsen, i hjärtat av Helsingfors. Ode är en evenemangsplats, ett läsandets hus och en mångsidig stadsupplevelse. Det bjuder på kunskap, nya färdigheter och berättelser, och är lättillgänglig för inlärning, inlevelse, arbete och avkoppling. Det är ett modernt bibliotek och en levande och funktionell mötesplats till för alla stadsbor. 4 Helsinki Central Library Oodi is a living meeting place at Kansalaistori square, right at the heart of Helsinki.    
8149 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma, to 08-20, ti, pe 08-18, la 10-16, su 12-18, suljettu ke", "sv": "\u00f6ppet m\u00e5n, tor 08-20, tis, fre 08-18, l\u00f6r 10-16, s\u00f6n 12-18, st\u00e4ngt ons", "en": "open Mon, Thu 08-20, Tue, Fri 08-18, Sat 10-16, Sun 12-18, closed Wed"}, "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/84851/Aukioloajat/", "sv": "http://www.helmet.fi/bibliotek/84851/Kontaktuppgifter/", "en": "http://www.helmet.fi/library/84851/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/toolonkirjasto", "sv": "http://www.facebook.com/toolonkirjasto", "en": "http://www.facebook.com/toolonkirjasto"}, "email": null, "phone": null, "contact_person": null}] [{"value": "floor_4", "variable": 108}, {"value": "over_10m", "variable": 4}, {"value": "false", "variable": 38}, {"value": "under_20mm", "variable": 56}, {"value": "no_handrails", "variable": 95}, {"value": "true", "variable": 20}, {"value": "true", "variable": 109}, {"value": "false", "variable": 53}, {"value": "true", "variable": 37}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 58}, {"value": "false", "variable": 27}, {"value": "false", "variable": 102}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "at_least_4_steps", "variable": 24}, {"value": "true", "variable": 25}, {"value": "true", "variable": 92}, {"value": "true", "variable": 94}, {"value": "false", "variable": 103}, {"value": "false", "variable": 106}, {"value": "true", "variable": 80}, {"value": "false", "variable": 79}, {"value": "true", "variable": 104}, {"value": "true", "variable": 113}, {"value": "false", "variable": 28}, {"value": "false", "variable": 33}, {"value": "false", "variable": 97}, {"value": "short_term_stay", "variable": 60}, {"value": "3_consecutive_steps", "variable": 93}, {"value": "false", "variable": 22}, {"value": "false", "variable": 44}, {"value": "2", "variable": 1}, {"value": "waiting_by_standing", "variable": 81}, {"value": "false", "variable": 48}, {"value": "true", "variable": 6}, {"value": "true", "variable": 105}, {"value": "outdoors", "variable": 2}, {"value": "true", "variable": 59}, {"value": "true", "variable": 23}, {"value": "true", "variable": 35}, {"value": "false", "variable": 21}, {"value": "true", "variable": 50}, {"value": "true", "variable": 115}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 112}, {"value": "false", "variable": 84}, {"value": "rough", "variable": 17}, {"value": "true", "variable": 111}, {"value": "false", "variable": 49}, {"value": "true", "variable": 57}, {"value": "false", "variable": 83}, {"value": "less_than_3600mm", "variable": 3}, {"value": "true", "variable": 116}, {"value": "false", "variabl… internal 3068 visithelsinki 3055 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/toolo-4f9024bd.jpg   https://maps.google.fi/?q=http:%2F%2Fwww.hel.fi%2Fpalvelukartta%2Fkml.aspx%3Flang%3Dfi%26id%3D8149&ll=60.183568,24.917046&spn=0.002043,0.014699&layer=c&cbll=60.18357,24.917041&cbp=12,160.8,,0,-4.81&t=h&panoid=E8y4R2m32ZA38YfU9CpwZw&z=17       Töölön kirjasto Töölö Library Topeliuksenkatu 6 Topeliusgatan 6 Topeliuksenkatu 6 http://www.helmet.fi/toolonkirjasto http://www.helmet.fi/tolobibliotek http://www.helmet.fi/tolobibliotek   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 85025   +358 9 310 85025 toolon_kirjasto@hel.fi https://www.lib.hel.fi/toolo 2008-09-11T18:47:26+03:00 00250 www.hel.fi kaikki helsinki 2021-01-04T07:30:49.833685+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 [749, 341, 337, 338, 331, 328, 349] [813, 806, 692, 691, 483, 473] {} Point 24.917463 60.183304 PL 25455, 00099 HELSINGIN KAUPUNKI 84851       Tölö bibliotek   4 6     1 P.O. Box 25455, 00099 HELSINGIN KAUPUNKI 1     6 kirkanta PB 25455, 00099 HELSINGIN KAUPUNKI     8      
8215 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma, to 08-20, ti, pe 08-18, la 10-16, su 12-18, suljettu ke", "sv": "\u00f6ppet m\u00e5n, tor 08-20, tis, fre 08-18, l\u00f6r 10-16, s\u00f6n 12-18, st\u00e4ngt ons", "en": "open Mon, Thu 08-20, Tue, Fri 08-18, Sat 10-16, Sun 12-18, closed Wed"}, "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/84860/Aukioloajat/", "sv": "http://www.helmet.fi/bibliotek/84860/Kontaktuppgifter/", "en": "http://www.helmet.fi/library/84860/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": "LINK", "name": {"fi": "YouTube", "sv": "YouTube", "en": "YouTube"}, "www": {"fi": "http://www.youtube.com/user/kallionkirjasto", "sv": "http://www.youtube.com/user/kallionkirjasto", "en": "http://www.youtube.com/user/kallionkirjasto"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Pinterest", "sv": "Pinterest", "en": "Pinterest"}, "www": {"fi": "http://pinterest.com/kallionkirjasto/", "sv": "http://pinterest.com/kallionkirjasto/", "en": "http://pinterest.com/kallionkirjasto/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Instagram", "sv": "Instagram", "en": "Instagram"}, "www": {"fi": "https://www.instagram.com/kallionkirjasto", "sv": "https://www.instagram.com/kallionkirjasto", "en": "https://www.instagram.com/kallionkirjasto"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Facebook", "sv": "Facebook", "en": "Facebook"}, "… [{"value": "true", "variable": 62}, {"value": "at_least_4_steps", "variable": 39}, {"value": "true", "variable": 37}, {"value": "false", "variable": 79}, {"value": "true", "variable": 114}, {"value": "false", "variable": 49}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 52}, {"value": "false", "variable": 82}, {"value": "under_20mm", "variable": 91}, {"value": "on_door", "variable": 110}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 112}, {"value": "false", "variable": 43}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 20}, {"value": "under_20mm", "variable": 56}, {"value": "0", "variable": 1}, {"value": "false", "variable": 83}, {"value": "false", "variable": 111}, {"value": "false", "variable": 58}, {"value": "true", "variable": 59}, {"value": "true", "variable": 44}, {"value": "false", "variable": 50}, {"value": "false", "variable": 80}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "true", "variable": 5}, {"value": "false", "variable": 113}, {"value": "true", "variable": 116}, {"value": "false", "variable": 98}, {"value": "false", "variable": 103}, {"value": "false", "variable": 57}, {"value": "true", "variable": 109}, {"value": "false", "variable": 29}, {"value": "handrails_on_both_sides", "variable": 47}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 45}, {"value": "true", "variable": 107}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 46}, {"value": "true", "variable": 6}, {"value": "false", "variable": 92}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "false", "variable": 23}, {"value": "false", "variable": 22}, {"value": "true", "variable": 104}, {"value": "false", "variable": 48}, {"value": "true", "variable": 35}, {"value": "false", "variable": 38}, {"value": "waiting_by_standing", "variable": 81}, {"value": "false", "variable": 84}, {"value": "false", "variable": 105}, {"value": "opens_automatically_with_motion_se… internal 3266 visithelsinki 2916 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/kallio-4f901aa2.jpg   https://maps.google.fi/?q=http:%2F%2Fwww.hel.fi%2Fpalvelukartta%2Fkml.aspx%3Flang%3Dfi%26id%3D8215&ll=60.183222,24.953513&spn=0.002043,0.014699&layer=c&cbll=60.18322,24.953511&cbp=12,15.56,,0,-2.63&t=h&panoid=qS8PWG0EtAkcltniDok4Yw&z=17       Kallion kirjasto Kallio Library Viides linja 11 Femte linjen 11 Viides linja 11 http://www.helmet.fi/kallionkirjasto http://www.helmet.fi/kallionkirjasto http://www.helmet.fi/kallionkirjasto   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 85053   +358 9 310 85953 kallion_kirjasto@hel.fi https://www.lib.hel.fi/fi-FI/kallio/yhteystiedot/ 2008-09-11T18:47:26+03:00 00530 www.hel.fi kaikki helsinki 2021-01-04T07:30:49.975144+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 [749, 341, 337, 338, 331, 328, 349] [813, 806, 692, 691, 483, 473] {} Point 24.95356 60.18372 PL 53455, 00099 HELSINGIN KAUPUNKI 84860       Berghälls bibliotek   2 4     1 P.O. Box 53455, 00099 HELSINGIN KAUPUNKI 1     4 kirkanta PB 53455, 00099 HELSINGIN KAUPUNKI     2      

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