unit
2 rows where accessibility_shortcoming_count_wheelchair = 1 and identifiers_2_namespace = "kirkanta"
This data as json, CSV (advanced)
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | oulunkylan_kirjasto@hel.fi | +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 | ||||||||||||||||||||||||||
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 | 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. |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [unit] ( [id] INTEGER PRIMARY KEY, [connections] TEXT, [accessibility_properties] TEXT, [identifiers_0_namespace] TEXT, [identifiers_0_value] TEXT, [identifiers_1_namespace] TEXT, [identifiers_1_value] TEXT, [department] TEXT, [root_department] TEXT, [provider_type] TEXT, [organizer_type] TEXT, [contract_type_id] TEXT, [contract_type_description_fi] TEXT, [contract_type_description_sv] TEXT, [contract_type_description_en] TEXT, [is_active] INTEGER, [deleted_at] TEXT, [organizer_name] TEXT, [organizer_business_id] TEXT, [picture_url] TEXT, [picture_entrance_url] TEXT, [streetview_entrance_url] TEXT, [description_fi] TEXT, [description_en] TEXT, [short_description] TEXT, [name_fi] TEXT, [name_en] TEXT, [street_address_fi] TEXT, [street_address_sv] TEXT, [street_address_en] TEXT, [www_fi] TEXT, [www_sv] TEXT, [www_en] TEXT, [address_postal_full] TEXT, [call_charge_info_fi] TEXT, [call_charge_info_sv] TEXT, [call_charge_info_en] TEXT, [picture_caption] TEXT, [phone] TEXT, [fax] TEXT, [email] TEXT, [accessibility_phone] TEXT, [accessibility_email] TEXT, [accessibility_www] TEXT, [created_time] TEXT, [address_zip] TEXT, [data_source] TEXT, [extensions_maintenance_group] TEXT, [extensions_maintenance_organization] TEXT, [last_modified_time] TEXT, [accessibility_viewpoints] TEXT, [root_service_nodes] TEXT, [municipality] TEXT, [service_nodes] TEXT, [services] TEXT, [keywords] TEXT, [location_type] TEXT, [location_coordinates_0] FLOAT, [location_coordinates_1] FLOAT, [address_postal_full_fi] TEXT, [identifiers_2_value] TEXT, [picture_caption_fi] TEXT, [call_charge_info] TEXT, [www] TEXT, [name_sv] TEXT, [short_description_fi] TEXT, [accessibility_shortcoming_count_reduced_mobility] TEXT, [accessibility_shortcoming_count_wheelchair] TEXT, [location] TEXT, [picture_caption_sv] TEXT, [accessibility_shortcoming_count_stroller] TEXT, [address_postal_full_en] TEXT, [accessibility_shortcoming_count_hearing_aid] TEXT, [street_address] TEXT, [contract_type] TEXT, [accessibility_shortcoming_count_rollator] TEXT, [identifiers_2_namespace] TEXT, [address_postal_full_sv] TEXT, [short_description_sv] TEXT, [description_sv] TEXT, [accessibility_shortcoming_count_visually_impaired] TEXT, [short_description_en] TEXT, [description] TEXT, [picture_caption_en] TEXT );