unit
4 rows where accessibility_shortcoming_count_stroller = 1 and "last_modified_time" is on date 2020-11-11
This data as json, CSV (advanced)
Suggested facets: department, root_department, provider_type, municipality, accessibility_shortcoming_count_reduced_mobility
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6880 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Kuraattori", "sv": "Kuraattori", "en": "Kuraattori"}, "www": null, "email": null, "phone": "+358 40 661 7717", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Psykologi", "sv": "Psykologi", "en": "Psykologi"}, "www": null, "email": null, "phone": "+358 40 661 5282", "contact_person": null}] | [{"value": "false", "variable": 83}, {"value": "true", "variable": 106}, {"value": "true", "variable": 107}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 103}, {"value": "false", "variable": 84}, {"value": "true", "variable": 104}, {"value": "true", "variable": 105}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 102}, {"value": "false", "variable": 92}, {"value": "false", "variable": 98}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 58}, {"value": "true", "variable": 115}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 116}, {"value": "true", "variable": 117}, {"value": "floor_3", "variable": 120}, {"value": "true", "variable": 118}, {"value": "floor_2", "variable": 119}, {"value": "true", "variable": 113}, {"value": "true", "variable": 59}, {"value": "true", "variable": 76}, {"value": "true", "variable": 114}, {"value": "opens_with_access_control_key", "variable": 77}, {"value": "true", "variable": 112}, {"value": "true", "variable": 78}, {"value": "false", "variable": 79}, {"value": "true", "variable": 73}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 74}, {"value": "true", "variable": 75}, {"value": "false", "variable": 62}, {"value": "true", "variable": 72}, {"value": "3", "variable": 64}, {"value": "true", "variable": 70}, {"value": "true", "variable": 57}, {"value": "true", "variable": 37}, {"value": "true", "variable": 51}, {"value": "true", "variable": 52}, {"value": "false", "variable": 53}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 48}, {"value": "false", "variable": 38}, {"value": "false", "variable": 49}, {"value": "true", "variable": 50}, {"value": "true", "variable": 44}, {"value": "no_handrails", "variable": 47}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "false", "variable": 46}, {"value": "false", "variable": 34}, {"value": "false", "variable": 21}, {"value": "canopy_above_entranc… | internal | 20628 | b790e389-104f-4100-9769-f4fbfef313de | 83e74666-0836-4c1d-948a-4b34a8b90301 | CONTRACT_SCHOOL | GOVERNMENT | 1 | Helsingin yliopiston Viikin normaalikoulu | 0313471-7 | Helsingin yliopiston Viikin normaalikoulu | University of Helsinki Viikki Normal School | Kevätkatu 2 | Vårgatan 2 | Kevätkatu 2 | http://www.vink.helsinki.fi/ | http://www.vink.helsinki.fi/ | http://www.vink.helsinki.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 29 419 11 | +358 9 1915 7934 | vink-kanslia@helsinki.fi | 2015-11-27T12:11:49+02:00 | 00790 | www.helsinki.fi | kaikki | helsinki | 2020-11-11T16:30:53.322311+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"} | [1087] | helsinki | [1259, 1100, 1110] | [662, 661, 658] | {"fi": ["eskari", "lukio", "lukiot"]} | Point | 25.030207 | 60.22731 | PL 3, 00014 Helsingin yliopisto | Samskolan Helsingin yliopiston Viikin normaalikoulu | 2 | 4 | 1 | P.O. Box 3, 00014 University of Helsinki | 1 | 4 | PB 3, 00014 Helsingfors universitet | 2 | |||||||||||||||||||||||||||||||||
| 19274 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Rehtori"}, "www": null, "email": "kirsi.heikkila1@vantaa.fi", "phone": "+358 43 825 4071", "contact_person": "Marianne Heikkil\u00e4"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Apulaisrehtori"}, "www": null, "email": "saija.tynkkynen@vantaa.fi", "phone": "+358 40 551 8302", "contact_person": "Saija Tynkkynen"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Vararehtori"}, "www": null, "email": "nanna.oinonen@vantaa.fi", "phone": "+358 50 310 4992", "contact_person": "Nanna Oinonen"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Opettajainhuone"}, "www": null, "email": null, "phone": "+358 50 303 0257", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "IB-koordinaattori"}, "www": null, "email": "maarit.berg@vantaa.fi", "phone": "+358 40 505 3314", "contact_person": "Maarit Berg"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lukiosihteeri (yo-asiat/taloushallinto)"}, "www": null, "email": "sirpa.malva@vantaa.fi ", "phone": "+358 50 302 9605", "contact_person": "Sirpa Malva"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lukiosihteeri (opiskelija-asiat/Wilma)"}, "www": null, "email": "kirsi.paaso@vantaa.fi", "phone": "+358 50 302 9734", "contact_person": "Kirsi Paaso"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Kouluis\u00e4nt\u00e4"}, "www": null, "email": "kai.raitolehto@vantaa.fi", "phone": "+358 40 838 2840", "contact_person": "Kai Raitolehto"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Tekninen kouluis\u00e4nt\u00e4 (arkisin 7.00 - 15.30)"}, "www": null, "email": "sakari.pietarila@vantti.fi", "phone": "+358 40 715 3240", "contact_person": "Sakari Pietarila"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Iltavahtimestari"}, "www": null, "email": "juha.korhonen@vantaa.fi", "phone": "+358 400 450 787", "contact_person": "Juha Korhonen"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "IB-lukio (IB1 applications)"}, "www": null, "email": "anu.kinnunen@vantaa.fi", "phone": null, "… | [{"value": "false", "variable": 38}, {"value": "true", "variable": 37}, {"value": "true", "variable": 78}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 49}, {"value": "false", "variable": 83}, {"value": "true", "variable": 52}, {"value": "true", "variable": 114}, {"value": "false", "variable": 79}, {"value": "true", "variable": 72}, {"value": "false", "variable": 98}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 76}, {"value": "next_to_door_on_opening_side", "variable": 110}, {"value": "true", "variable": 107}, {"value": "true", "variable": 74}, {"value": "false", "variable": 102}, {"value": "true", "variable": 51}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 5}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 23}, {"value": "false", "variable": 21}, {"value": "false", "variable": 20}, {"value": "false", "variable": 22}, {"value": "false", "variable": 117}, {"value": "false", "variable": 33}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 113}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "over_10m", "variable": 4}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 58}, {"value": "false", "variable": 62}, {"value": "true", "variable": 6}, {"value": "false", "variable": 48}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "3", "variable": 64}, {"value": "true", "variable": 112}, {"value": "true", "variable": 109}, {"value": "false", "variable": 84}, {"value": "false", "variable": 44}, {"value": "true", "variable": 59}, {"value": "true", "variable": 73}, {"value": "false", "variable": 75}, {"value": "false", "variable": 106}, {"value": "3", "variable": 1}, {"value": "false", "variable": 34}, {"value": "false", "variable": 103}, {"value": "false", "variable": 53}, {"value": "true", "variable": 105}, {"value": "true", "variable": 50}, {"value": "false", "variable": 29}, {"value": "true", "variable": 104}, {"value": "false", "variable":… | internal | 5315 | fef822d5-7a4e-47da-ba94-f6f4b0a7c759 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | https://vantaa.emmi.fi/l/rx67jWkxV9MR | Tikkurilan lukio on viihtyisä ja aktiivinen työyhteisö, jossa korostetaan suvaitsevaisuutta, yhteisöllisyyttä ja opiskelijan omaa vastuuta. Koulumme on suuri (noin 1190 opiskelijaa), joten kurssivalikoimamme on laaja ja monipuolinen. Meillä on moderni koulurakennus, joka sijaitsee hyvien kulkuyhteyksien varrella. Lukiossamme on mahdollista opiskella myös IB-linjalla ja suorittaa kansainvälinen ylioppilastutkinto. 1.1.2016 alkaen Vantaan aikuislukio on ollut osa Tikkurilan lukiota.Tilu on erinomainen oppimisympäristö. Kaikissa luokissa on oppimisen ja opetuksen tukena uusinta tieto- ja viestintätekniikkaa. Tilussa on valoisat tilat, avarat aulat, toimiva kirjasto ja lukusali, iso auditorio, ravintola ja kahvio. Luonnontieteitä opetetaan hyvin varustetuissa biologian, fysiikan ja kemian laboratorioissa. Lähes ammattiteatteritasoinen auditorio tarjoaa monipuolisia mahdollisuuksia. Musiikin, kuvataiteen ja liikunnan harrastajillekin on omat hyvät tilansa ja välineensä. Opiskelijoitamme ohjaa ja opastaa valintoihin ja jatko-opintoihin neljä päätoimista opinto-ohjaa.Vaikka Tilu on suuri lukio, opiskelijat Tilussa eivät ole eksyksissä, koska heistä pidetään hyvää huolta. Lukiossamme on välitön tunnelma ja mahdollisuuksia löytää uusia samanhenkisiä ystäviä. Aktiivinen oppilaskunta ja tutorit auttavat tutustumaan ja viihtymään. | Tikkurilan lukio | Tikkurila Upper Secondary School | Valkoisenlähteentie 53 | Vitbäcksvägen 53 | Valkoisenlähteentie 53 | https://sivistysvantaa.fi/tikkurilanlukio/index.html | https://sivistysvantaa.fi/tikkurilanlukio/index.html | https://www.sivistysvantaa.fi/tikkurilaib/index.html | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 839 11 | etunimi.sukunimi@vantaa.fi | +358 9 8392 5119 | ari.ranki@vantaa.fi | http://www.edu.vantaa.fi/tilu | 2014-11-19T17:01:21+02:00 | 01370 | www.vantaa.fi | kaikki | vantaa | 2020-11-11T08:01:01.020134+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"} | [1087] | vantaa | [1274, 1280, 1273, 1281, 1286, 1287, 1290, 1292, 1284, 1293, 1294, 1260, 1270, 1296, 1259, 1269] | [816, 658, 493, 157, 148, 99, 97, 96, 95, 93, 90, 89, 12, 11, 10, 4] | {"fi": ["koulu", "IB", "IB-tutkinto", "Tikkurilan lukio", "tilu", "lukio-opetus", "lukiokoulutus", "lukio"]} | Point | 25.049885 | 60.299076 | PL 4515, 01030 Vantaan kaupunki | Tikkurilan lukio. Kuva: Vantaan kaupunki, Heli Toivonen. | Tikkurilan lukio on viihtyisä ja aktiivinen työyhteisö, jossa korostetaan suvaitsevaisuutta, yhteisöllisyyttä ja opiskelijan omaa vastuuta. | 1 | 1 | Tikkurilan lukio. Bild: Vanda stad, Heli Toivonen. | 1 | P.O. Box 4515, 01030 City of Vantaa | 1 | 1 | PB 4515, 01030 Vanda stad | 5 | Tikkurilan lukio. Photo: City of Vantaa, Heli Toivonen. | |||||||||||||||||||||||||
| 30851 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Kuraattori", "sv": "Kuraattori", "en": "Kuraattori"}, "www": null, "email": null, "phone": "+358 40 160 8018", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Psykologi", "sv": "Psykologi", "en": "Psykologi"}, "www": null, "email": null, "phone": "+358 40 668 3318", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Koulujen tilojen ilta- ja vapaa-ajank\u00e4yt\u00f6n neuvonta ja varaukset: liikuntasalit 09 310 87800, muut tilat 09 310 12001"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Tilanvaraus", "sv": "Lokalbokning", "en": "Reservation of premises"}, "www": {"fi": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/fi/palvelut/tilojen-varaaminen/koulutilojen-kaytto", "sv": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/sv/tjanster/anvandning-skollokaler", "en": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/en/services/renting-facilities/school-facilities"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 57}, {"value": "true", "variable": 51}, {"value": "true", "variable": 105}, {"value": "false", "variable": 29}, {"value": "false", "variable": 49}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 94}, {"value": "true", "variable": 20}, {"value": "false", "variable": 34}, {"value": "true", "variable": 52}, {"value": "false", "variable": 53}, {"value": "false", "variable": 115}, {"value": "true", "variable": 37}, {"value": "false", "variable": 106}, {"value": "false", "variable": 111}, {"value": "true", "variable": 25}, {"value": "0", "variable": 1}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 27}, {"value": "true", "variable": 50}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 33}, {"value": "indoor_facility", "variable": 500}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 23}, {"value": "long_term_stay", "variable": 60}, {"value": "2", "variable": 64}, {"value": "true", "variable": 114}, {"value": "floor_1", "variable": 108}, {"value": "true", "variable": 113}, {"value": "false", "variable": 84}, {"value": "false", "variable": 98}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 112}, {"value": "false", "variable": 116}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 22}, {"value": "false", "variable": 79}, {"value": "at_least_4_steps", "variable": 24}, {"value": "true", "variable": 92}, {"value": "true", "variable": 5}, {"value": "true", "variable": 107}, {"value": "false", "variable": 97}, {"value": "handrails_on_one_side", "variable": 26}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 62}, {"value": "at_least_4_steps", "variable": 93}, {"value": "false", "variable": 28}, {"value": "false", "variable": 38}, {"value": "false", "variable": 96}, {"value": "true", "variable": 109}, {"value": "false", "variable": 21}, {"value": "false", "var… | internal | 131 | 154af650-9860-4994-b746-e10abb660203 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Alppilan lukio | Alppila Upper Secondary School | Viipurinkatu 21 | Viborgsgatan 21 | Viipurinkatu 21 | http://www.alppl.edu.hel.fi | http://www.alppl.edu.hel.fi | http://www.alppl.edu.hel.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 84455 | 2015-11-27T12:11:49+02:00 | 00510 | www.hel.fi | kaikki | helsinki | 2020-11-11T16:01:16.856406+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"} | [1087] | helsinki | [1274, 1275, 1273, 1286, 1292, 1284, 1293, 1296, 1259, 1269] | [816, 658, 493, 97, 96, 95, 89, 11, 5, 4] | {"fi": ["Kampus-1", "tilanvaraus", "tilavaraus", "koulu", "lukio", "lukiot"], "sv": ["lokalbokning"], "en": ["reservation of premises"]} | Point | 24.938997 | 60.19222 | PL 51311, 00099 Helsingin kaupunki | Gymnasiet Alppilan lukio | 3 | 5 | 1 | P.O. Box 51311, 00099 City of Helsinki | 1 | 5 | PB 51311, 00099 Helsingfors stad | 10 | ||||||||||||||||||||||||||||||||||
| 30852 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Kuraattori", "sv": "Kuraattori", "en": "Kuraattori"}, "www": null, "email": null, "phone": "+358 40 668 3536", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Psykologi", "sv": "Psykologi", "en": "Psykologi"}, "www": null, "email": null, "phone": "+358 40 336 0377", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Koulujen tilojen ilta- ja vapaa-ajank\u00e4yt\u00f6n neuvonta ja varaukset: liikuntasalit 09 310 87800, muut tilat 09 310 12001"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Tarjolla auditorio ja sali", "sv": "Tillg\u00e4nglig: auditorium och sal", "en": "Available: auditorium and hall"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Tilanvaraus", "sv": "Lokalbokning", "en": "Reservation of premises"}, "www": {"fi": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/fi/palvelut/tilojen-varaaminen/koulutilojen-kaytto", "sv": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/sv/tjanster/anvandning-skollokaler", "en": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/en/services/renting-facilities/school-facilities"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 34}, {"value": "false", "variable": 52}, {"value": "true", "variable": 57}, {"value": "true", "variable": 113}, {"value": "true", "variable": 73}, {"value": "true", "variable": 74}, {"value": "true", "variable": 76}, {"value": "true", "variable": 20}, {"value": "true", "variable": 5}, {"value": "false", "variable": 49}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 33}, {"value": "false", "variable": 114}, {"value": "false", "variable": 22}, {"value": "true", "variable": 107}, {"value": "true", "variable": 78}, {"value": "false", "variable": 44}, {"value": "1_step", "variable": 39}, {"value": "true", "variable": 58}, {"value": "true", "variable": 115}, {"value": "true", "variable": 117}, {"value": "false", "variable": 79}, {"value": "false", "variable": 83}, {"value": "true", "variable": 38}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 59}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 112}, {"value": "false", "variable": 62}, {"value": "true", "variable": 37}, {"value": "false", "variable": 92}, {"value": "1_step", "variable": 24}, {"value": "floor_3", "variable": 120}, {"value": "false", "variable": 116}, {"value": "false", "variable": 84}, {"value": "true", "variable": 51}, {"value": "true", "variable": 70}, {"value": "false", "variable": 21}, {"value": "false", "variable": 103}, {"value": "true", "variable": 72}, {"value": "4", "variable": 64}, {"value": "false", "variable": 102}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "opens_with_access_control_key", "variable": 77}, {"value": "true", "variable": 104}, {"value": "true", "variable": 118}, {"value": "false", "variable": 105}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 75}, {"value": "false", "variable": 48}, {"value": "0", "variable": 1}, {"value": "true", "variable": 23}, {"value": "true", "variable": 50}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "false", "variab… | internal | 20876 | 154af650-9860-4994-b746-e10abb660203 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Etu-Töölön lukio | Etu-Töölö Upper Secondary School | Arkadiankatu 26 | Arkadiagatan 26 | Arkadiankatu 26 | http://www.tyly.edu.hel.fi | http://www.tyly.edu.hel.fi | http://www.tyly.edu.hel.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 86511 | +358 50 401 3723 | harry.wikstrom@palmia.fi | 2015-11-27T12:11:49+02:00 | 00100 | www.hel.fi | kaikki | helsinki | 2020-11-11T16:01:16.866920+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"} | [1087] | helsinki | [1274, 1275, 1273, 1281, 1286, 1292, 1284, 1293, 1296, 1259, 1269] | [816, 658, 493, 97, 96, 95, 89, 12, 11, 5, 4] | {"fi": ["sali", "auditorio", "Kampus-3", "tilanvaraus", "tilavaraus", "koulu", "lukio", "lukiot"], "sv": ["lokalbokning"], "en": ["reservation of premises"]} | Point | 24.922325 | 60.171154 | PL 10302, 00099 Helsingin kaupunki | Gymnasiet Etu-Töölön lukio | 2 | 7 | 1 | P.O. Box 10302, 00099 City of Helsinki | 1 | 7 | PB 10302, 00099 Helsingfors stad | 1 |
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 );