unit
26 rows where "last_modified_time" is on date 2020-11-11
This data as json, CSV (advanced)
Suggested facets: connections, address_zip, root_service_nodes, municipality, service_nodes, keywords, accessibility_shortcoming_count_wheelchair, accessibility_shortcoming_count_stroller, 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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||||
7046 | [] | [] | internal | 20447 | 6bc1d12f-88cc-46c0-a5b0-bd8286082e12 | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | PRIVATE_ENTERPRISE | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Eiran aikuislukio | Eiran aikuislukio | Eira High School for Adults | Laivurinkatu 3 | Skepparegatan 3 | Laivurinkatu 3 | http://www.eiraedu.com/ | http://www.eiraedu.com/ | http://www.eiraedu.com/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 454 2270 | 2015-11-27T12:11:49+02:00 | 00150 | www.hel.fi | kaikki | helsinki | 2020-11-11T16:00:53.347717+02:00 | [1087] | helsinki | [1340, 1341, 1338] | [652, 651, 649] | {"fi": ["lukio", "lukiot"]} | Point | 24.942871 | 60.155666 | Vuxengymnasiet Eiran aikuislukio | ||||||||||||||||||||||||||||||||||||||||||
7071 | [] | [] | internal | 20453 | 6bc1d12f-88cc-46c0-a5b0-bd8286082e12 | 83e74666-0836-4c1d-948a-4b34a8b90301 | OTHER_PRODUCTION_METHOD | PRIVATE_ENTERPRISE | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Töölön yhteiskoulun aikuislukio | Töölön yhteiskoulun aikuislukio | Töölö Coeducational School, Upper Secondary School for Adults | Urheilukatu 10-12 | Idrottsgatan 10-12 | Urheilukatu 10-12 | http://www.tyk.fi | http://www.tyk.fi | http://www.tyk.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 4342 0236 | 2015-11-27T12:11:49+02:00 | 00250 | www.hel.fi | kaikki | helsinki | 2020-11-11T16:00:53.430616+02:00 | [1087] | helsinki | [1340, 1337, 1341, 1338] | [652, 651, 650, 649] | {"fi": ["lukio", "lukiot"]} | Point | 24.92388 | 60.18538 | Vuxengymnasiet vid Töölön yhteiskoulu | ||||||||||||||||||||||||||||||||||||||||||
15061 | [{"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}] | [{"value": "true", "variable": 105}, {"value": "smooth", "variable": 17}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 51}, {"value": "false", "variable": 44}, {"value": "false", "variable": 92}, {"value": "true", "variable": 5}, {"value": "true", "variable": 104}, {"value": "true", "variable": 58}, {"value": "true", "variable": 102}, {"value": "true", "variable": 20}, {"value": "false", "variable": 21}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 57}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 103}, {"value": "false", "variable": 33}, {"value": "false", "variable": 23}, {"value": "false", "variable": 98}, {"value": "true", "variable": 50}, {"value": "false", "variable": 38}, {"value": "false", "variable": 34}, {"value": "false", "variable": 79}, {"value": "false", "variable": 48}, {"value": "guided_and_clear", "variable": 19}, {"value": "true", "variable": 59}, {"value": "true", "variable": 52}, {"value": "false", "variable": 29}, {"value": "true", "variable": 62}, {"value": "false", "variable": 106}, {"value": "sufficiently_wide", "variable": 18}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "true", "variable": 6}, {"value": "0", "variable": 1}, {"value": "false", "variable": 22}, {"value": "false", "variable": 53}, {"value": "long_term_stay", "variable": 60}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 49}, {"value": "false", "variable": 107}, {"value": "true", "variable": 37}] | internal | 17846 | 154af650-9860-4994-b746-e10abb660203 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Helsingin aikuislukio, Itä-Helsingin toimipaikka | Helsinki Upper Secondary School for Adults, Itäkeskus Branch | Kajaaninlinnantie 10 | Kajaneborgsvägen 10 | Kajaaninlinnantie 10 | http://www.helsinginaikuislukio.fi | http://www.helsinginaikuislukio.fi | http://www.helsinginaikuislukio.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 82118 | 2015-11-27T12:11:49+02:00 | 00900 | www.hel.fi | kaikki | helsinki | 2020-11-11T16:00:57.547350+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": null} | [1087] | helsinki | [1340, 1337, 1341, 1338, 1342] | [652, 651, 650, 649, 408, 96, 10, 5, 4] | {"fi": ["koulu", "lukio", "lukiot"]} | Point | 25.071552 | 60.212967 | PL 90304, 00099 Helsingin kaupunki | Helsingfors vuxengymnasier, Östra centrums enhet | 2 | 2 | P.O. Box 90304, 00099 City of Helsinki | 2 | PB 90304, 00099 Helsingfors stad | 4 | ||||||||||||||||||||||||||||||||||||
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. | |||||||||||||||||||||||||
20618 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 10-20, la 10-19", "sv": "\u00f6ppet m\u00e5n-fre 10-20, l\u00f6r 10-19", "en": "open Mon-Fri 10-20, Sat 10-19"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [] | internal | 26418 | visithelsinki | 1505 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | private_service | yksityinen palvelu | privat tjänst | private service | 1 | BOSS Store Helsingin valikoimista löytyy viimeisimmät Hugo Boss vaatteet, niin miehille kuin naisillekin. | The BOSS Store Helsinki offers collections for both men and women. | BOSS Store Helsinki | BOSS Store Helsinki | Urho Kekkosen katu 1 | Urho Kekkonens gata 1 | Urho Kekkosen katu 1 | https://www.hugoboss.com/fi/en/storedetail?storeid=9925728 | https://www.hugoboss.com/fi/en/storedetail?storeid=9925728 | https://www.hugoboss.com/fi/en/storedetail?storeid=9925728 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 40 713 5120 | BOSS_Helsinki@hugoboss.com | 2011-05-25T14:54:37+03:00 | 00100 | www.myhelsinki.fi | kaikki | helsinki | 2020-11-11T08:01:03.375539+02:00 | [1403] | helsinki | [750] | [490] | {} | Point | 24.933638 | 60.169014 | BOSS Store Helsinki | I BOSS Store Helsinki hittar man kollektioner för både män och kvinnor. | ||||||||||||||||||||||||||||||||||||||
21230 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-la 10-18", "sv": "\u00f6ppet m\u00e5n-l\u00f6r 10-18", "en": "open Mon-Sat 10-18"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [] | internal | 6323 | visithelsinki | 1230 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Marttiini on Suomen tunnetuin veitsien valmistaja. Sen tuotevalikoimaan kuuluu lukuisia erilaisia veitsiä koti- ja ulkokäyttöön. Marttiini tunnetaan korkeasta laadustaan ja mm. sen Lapinpuukot ovat suosittuja lahjaesineitä. Tällä hetkellä Marttiini valmistaa kaikkiaan yli 400 erilaista veitsimallia ja niitä myydään yli 20 maahan. | Marttiini is the most famous knife manufacturer in Finland. Marttiini's product selection consists of all kinds of knives for home and outdoor use. Marttiini is known for high quality, and their Lappish knives are also very popular gift items. | Marttiini | Marttiini | Aleksanterinkatu 28 | Alexandersgatan 28 | Aleksanterinkatu 28 | https://www.marttiini.fi/ | https://www.marttiini.fi/ | https://www.marttiini.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 40 311 0605 | senaatti@marttiini.fi | 2011-05-25T14:54:37+03:00 | 00170 | www.myhelsinki.fi | kaikki | helsinki | 2020-11-11T08:01:04.905672+02:00 | [1403] | helsinki | [750] | [490] | {} | Point | 24.951525 | 60.168934 | Marttiini | Finska Marttiini är känd för sina slitstarka och elegant formgivna kvalitetsknivar, -ett givet val för många yrkesmän och jägare. | ||||||||||||||||||||||||||||||||||||||
23797 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-la 11-22, su 12-20", "sv": "\u00f6ppet m\u00e5n-l\u00f6r 11-22, s\u00f6n 12-20", "en": "open Mon-Sat 11-22, Sun 12-20"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [] | internal | 7178 | visithelsinki | 2025 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Italialainen pikaruokaravintola jossa pastat, pizzat, alkuruoat ja salaatit tilataan tiskin yli suoraan kokeilta, jotka valmistavat ruoan asiakkaan silmien edessä. Vapianon pitkät tammipöydät kutsuvat keskustelemaan yhdessä ystävien, perheen tai muiden ravintolavieraiden kanssa. Vapiano on täydellinen paikka nopealle lounaalle, iltapäivän kahvitauolle tai illalliselle perheen ja ystävien kanssa. Vapianoja on jo yli 190 maassa. | Italian fast food restaurant where pasta, pizzas, antipasti and salads are ordered directly from the chefs at the individual stations in the middle of the Vapiano. The chefs then prepare all of the dishes to order in front of the guests. The long oak tables in the Vapianos are an open invitation to communication-with friends, family, or simply with other guests. Vapiano is the perfect setting for a quick lunch, an afternoon break, or a pleasant dinner with friends or family.Today there are over 190 Vapianos around the world. | Vapiano | Vapiano | Mikonkatu 15 | Mikaelsgatan 15 | Mikonkatu 15 | https://fi.vapiano.com/fi/etusivu/ | https://fi.vapiano.com/fi/etusivu/ | https://fi.vapiano.com/en/home/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 698 1225 | helsinki1@vapiano.fi | 2011-07-08T02:40:37+03:00 | 00100 | www.myhelsinki.fi | kaikki | helsinki | 2020-11-11T08:01:07.986677+02:00 | [1403] | helsinki | [751] | [577] | {} | Point | 24.94556 | 60.17094 | Vapiano | Italiensk snabbmatsrestaurang där pizza, pasta, sallader osv. beställs direkt vid disken och vidare tillreds av kockarna framför kundens ögon. Vapianos långa ekbord lockar till samtal mellan vänner, familj eller andra restauranggäster.Vapiano är en perfekt restaurang för snabba luncher, eftermiddagskaffet eller middag med familj eller vänner.Det finns Vapiano-restauranger redan i över 190 länder runtom världen. | ||||||||||||||||||||||||||||||||||||||
24437 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 11-19", "sv": "\u00f6ppet m\u00e5n-fre 11-19", "en": "open Mon-Fri 11-19"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [] | internal | 7206 | visithelsinki | 596 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | UniCafe on opiskelijaruokala ja se toimii Helsingin yliopiston kaikilla kampuksilla.Terveellisiä lounaita, virkistäviä juomia, herkullisia leivonnaisia ja maukkaita välipaloja. | UniCafe is a student restaurant at each campus of the University of Helsinki.Healthy lunches, refreshing beverages, delicious pastries and tasty snacks. | UniCafe Kaivopiha | UniCafe Kaivopiha | Mannerheimintie 3 B | Mannerheimvägen 3 B | Mannerheimintie 3 B | https://unicafe.fi/ | https://unicafe.fi/ | https://unicafe.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 557 6051 | Kaivopiha@unicafe.fi | 2011-10-06T02:40:39+03:00 | 00100 | www.myhelsinki.fi | kaikki | helsinki | 2020-11-11T08:01:09.002784+02:00 | [1403] | helsinki | [751] | [577] | {} | Point | 24.9408 | 60.16919 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
30853 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Kuraattori", "sv": "Kuraattori", "en": "Kuraattori"}, "www": null, "email": null, "phone": "+358 40 537 7016", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Psykologi", "sv": "Psykologi", "en": "Psykologi"}, "www": null, "email": null, "phone": "+358 40 336 0344", "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": "smooth", "variable": 17}, {"value": "true", "variable": 105}, {"value": "true", "variable": 58}, {"value": "false", "variable": 106}, {"value": "at_least_4_steps", "variable": 93}, {"value": "0", "variable": 1}, {"value": "false", "variable": 5}, {"value": "false", "variable": 29}, {"value": "true", "variable": 107}, {"value": "true", "variable": 57}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 34}, {"value": "true", "variable": 103}, {"value": "true", "variable": 94}, {"value": "false", "variable": 21}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 102}, {"value": "true", "variable": 112}, {"value": "handrails_on_both_sides", "variable": 95}, {"value": "false", "variable": 49}, {"value": "false", "variable": 48}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 70}, {"value": "false", "variable": 33}, {"value": "true", "variable": 59}, {"value": "false", "variable": 38}, {"value": "3", "variable": 64}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 92}, {"value": "false", "variable": 51}, {"value": "false", "variable": 23}, {"value": "false", "variable": 62}, {"value": "true", "variable": 115}, {"value": "true", "variable": 113}, {"value": "false", "variable": 22}, {"value": "false", "variable": 79}, {"value": "true", "variable": 37}, {"value": "true", "variable": 52}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 98}, {"value": "true", "variable": 114}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "true", "variable": 118}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 116}, {"value": "true", "variable": 20}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 117}, {"value": "false", "variable": 53}, {"value": "true", "variable": 104}, {"value": "true", "variable": 50}, {"value": "false", "variable": 44}, {"value": "indoor_facility", "variable": 500}] | internal | 20907 | 154af650-9860-4994-b746-e10abb660203 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Helsingin medialukio | North-Eastern Helsinki Upper Secondary School | Moisiontie 3 | Moisiovägen 3 | Moisiontie 3 | http://www.medialukio.fi | http://www.medialukio.fi | http://www.medialukio.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 82918 | +358 9 310 82918 | pekka.luoma@hel.fi | 2015-11-27T12:11:49+02:00 | 00730 | www.hel.fi | kaikki | helsinki | 2020-11-11T16:01:16.877866+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": null} | [1087] | helsinki | [1274, 1273, 1286, 1292, 1284, 1293, 1294, 1296, 1259, 1269] | [816, 658, 493, 99, 97, 96, 95, 89, 11, 4] | {"fi": ["sali", "Kampus-2", "auditorio", "tilanvaraus", "tilavaraus", "koulu", "lukio", "lukiot"], "en": ["reservation of premises"], "sv": ["lokalbokning"]} | Point | 25.029835 | 60.26961 | PL 73301, 00099 Helsingin kaupunki | Gymnasiet Helsingin medialukio | 3 | 4 | P.O. Box 73301, 00099 City of Helsinki | 4 | PB 73301, 00099 Helsingfors stad | 8 | ||||||||||||||||||||||||||||||||||
30854 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Kuraattori", "sv": "Kuraattori", "en": "Kuraattori"}, "www": null, "email": null, "phone": "+358 40 681 6867", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Psykologi", "sv": "Psykologi", "en": "Psykologi"}, "www": null, "email": null, "phone": "+358 40 681 6845", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Koulujen tilojen ilta- ja vapaa-ajank\u00e4yt\u00f6n neuvonta ja varaukset: liikuntasalit 310 87800, muut tilat 09 310 12001"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 34}, {"value": "false", "variable": 21}, {"value": "true", "variable": 114}, {"value": "true", "variable": 117}, {"value": "false", "variable": 22}, {"value": "false", "variable": 76}, {"value": "true", "variable": 113}, {"value": "false", "variable": 83}, {"value": "false", "variable": 38}, {"value": "true", "variable": 107}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 118}, {"value": "true", "variable": 20}, {"value": "false", "variable": 109}, {"value": "false", "variable": 44}, {"value": "over_20mm", "variable": 56}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 116}, {"value": "floor_1", "variable": 108}, {"value": "true", "variable": 5}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 58}, {"value": "true", "variable": 25}, {"value": "false", "variable": 51}, {"value": "true", "variable": 115}, {"value": "opens_automatically", "variable": 77}, {"value": "smooth", "variable": 17}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 98}, {"value": "true", "variable": 37}, {"value": "false", "variable": 79}, {"value": "false", "variable": 29}, {"value": "no_handrails", "variable": 26}, {"value": "true", "variable": 74}, {"value": "true", "variable": 52}, {"value": "false", "variable": 62}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 49}, {"value": "false", "variable": 33}, {"value": "true", "variable": 105}, {"value": "false", "variable": 78}, {"value": "true", "variable": 6}, {"value": "false", "variable": 106}, {"value": "false", "variable": 48}, {"value": "true", "variable": 104}, {"value": "true", "variable": 59}, {"value": "false", "variable": 92}, {"value": "true", "variable": 112}, {"value": "true", "variable": 57}, {"value": "true", "variable": 50}, {"value": "0", "variable": 1}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 70}, {"value": "indoor_facility", "variable": 500}, {"value": … | internal | 20942 | 154af650-9860-4994-b746-e10abb660203 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Helsingin luonnontiedelukio | Helsinki School of Natural Sciences, Upper Secondary School | Mäkelänkatu 84 | Backasgatan 84 | Mäkelänkatu 84 | http://www.heltiedelu.edu.hel.fi | http://www.heltiedelu.edu.hel.fi | http://www.heltiedelu.edu.hel.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 80458 | +358 9 310 82062 | timo.hartikka@hel.fi | 2015-11-27T12:11:49+02:00 | 00610 | www.hel.fi | kaikki | helsinki | 2020-11-11T16:01:16.892540+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"} | [1087] | helsinki | [1274, 1280, 1273, 1281, 1282, 1286, 1292, 1284, 1293, 1294, 1270, 1296, 1259, 1269] | [816, 658, 493, 157, 99, 97, 96, 95, 89, 14, 12, 11, 10, 4] | {"fi": ["Kampus-2", "koulu", "lukio", "lukiot"]} | Point | 24.943846 | 60.210148 | PL 61303, 00099 Helsingin kaupunki | Gymnasiet Helsingin luonnontiedelukio | 2 | 4 | P.O. Box 61303, 00099 City of Helsinki | 1 | 4 | PB 61303, 00099 Helsingfors stad | 9 | |||||||||||||||||||||||||||||||||
30855 | [{"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 336 0859", "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}] | [{"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 92}, {"value": "false", "variable": 70}, {"value": "3_consecutive_steps", "variable": 93}, {"value": "false", "variable": 83}, {"value": "5", "variable": 64}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 105}, {"value": "false", "variable": 103}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "handrails_on_one_side", "variable": 47}, {"value": "false", "variable": 21}, {"value": "false", "variable": 58}, {"value": "true", "variable": 104}, {"value": "false", "variable": 46}, {"value": "false", "variable": 23}, {"value": "false", "variable": 107}, {"value": "false", "variable": 102}, {"value": "false", "variable": 5}, {"value": "true", "variable": 22}, {"value": "true", "variable": 51}, {"value": "false", "variable": 34}, {"value": "true", "variable": 44}, {"value": "true", "variable": 38}, {"value": "false", "variable": 52}, {"value": "true", "variable": 94}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 84}, {"value": "3_consecutive_steps", "variable": 39}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 20}, {"value": "true", "variable": 59}, {"value": "no_handrails", "variable": 41}, {"value": "0", "variable": 1}, {"value": "false", "variable": 62}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 50}, {"value": "false", "variable": 49}, {"value": "false", "variable": 98}, {"value": "true", "variable": 40}, {"value": "false", "variable": 48}, {"value": "false", "variable": 79}, {"value": "indoor_facility", "variable": 500}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 29}, {"value": "sufficiently_wide", "variable": 18}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "false", "variable": 33}, {"value": "true", "variable": 57}, {"value": "true", "variable": 37}] | internal | 21111 | 154af650-9860-4994-b746-e10abb660203 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Helsingin kuvataidelukio | Visual Arts School of Helsinki, Upper Secondary School | Torkkelinkatu 6 | Torkelsgatan 6 | Torkkelinkatu 6 | http://www.kuvatl.edu.hel.fi | http://www.kuvatl.edu.hel.fi | http://www.kuvatl.edu.hel.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 82367 | 2015-11-27T12:11:49+02:00 | 00500 | www.hel.fi | kaikki | helsinki | 2020-11-11T16:01:16.906475+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, 1280, 1286, 1287, 1284, 1270, 1296, 1259, 1269] | [816, 658, 493, 157, 96, 90, 89, 10, 4] | {"fi": ["Kampus-1", "koulu", "lukio", "lukiot"]} | Point | 24.958448 | 60.185745 | PL 50301, 00099 Helsingin kaupunki | Gymnasiet Helsingin kuvataidelukio | 7 | 10 | 2 | P.O. Box 50301, 00099 City of Helsinki | 1 | 10 | PB 50301, 00099 Helsingfors stad | 5 | ||||||||||||||||||||||||||||||||||
30858 | [{"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}] | [{"value": "true", "variable": 70}, {"value": "at_least_4_steps", "variable": 24}, {"value": "true", "variable": 6}, {"value": "true", "variable": 73}, {"value": "false", "variable": 102}, {"value": "true", "variable": 58}, {"value": "false", "variable": 22}, {"value": "true", "variable": 51}, {"value": "true", "variable": 20}, {"value": "false", "variable": 92}, {"value": "false", "variable": 49}, {"value": "true", "variable": 40}, {"value": "true", "variable": 112}, {"value": "false", "variable": 83}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 116}, {"value": "under_20mm", "variable": 56}, {"value": "opens_easily_manually", "variable": 77}, {"value": "false", "variable": 117}, {"value": "true", "variable": 5}, {"value": "true", "variable": 104}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "false", "variable": 44}, {"value": "false", "variable": 62}, {"value": "true", "variable": 75}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "true", "variable": 50}, {"value": "true", "variable": 52}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 84}, {"value": "true", "variable": 38}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 74}, {"value": "false", "variable": 33}, {"value": "true", "variable": 114}, {"value": "false", "variable": 34}, {"value": "true", "variable": 113}, {"value": "false", "variable": 53}, {"value": "true", "variable": 25}, {"value": "true", "variable": 57}, {"value": "true", "variable": 76}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 23}, {"value": "false", "variable": 98}, {"value": "5", "variable": 64}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 29}, {"value": "no_handrails", "variable": 32}, {"value": "false", "variable": 106}, {"value": "true", "v… | internal | 20759 | 154af650-9860-4994-b746-e10abb660203 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kallion lukio | Kallio Upper Secondary School | Lehtikuusentie 4 | Lärkträdsvägen 4 | Lehtikuusentie 4 | http://www.kallil.edu.hel.fi | http://www.kallil.edu.hel.fi | http://www.kallil.edu.hel.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 84426 | +358 50 401 3752 | jukka.lampi@palmia.fi | 2015-11-27T12:11:49+02:00 | 00270 | www.hel.fi | kaikki | helsinki | 2020-11-11T16:01:16.930899+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, 1280, 1281, 1286, 1292, 1284, 1293, 1294, 1270, 1296, 1259, 1269] | [816, 658, 493, 157, 99, 97, 96, 95, 89, 12, 10, 4] | {"fi": ["Kampus-1", "koulu", "lukio", "lukiot"]} | Point | 24.905302 | 60.19558 | PL 53302, 00099 Helsingin kaupunki | Gymnasiet Kallion lukio | 2 | 4 | 2 | P.O. Box 53302, 00099 City of Helsinki | 1 | 3 | PB 53302, 00099 Helsingfors stad | 2 | ||||||||||||||||||||||||||||||||
30862 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Kuraattori", "sv": "Kuraattori", "en": "Kuraattori"}, "www": null, "email": null, "phone": "+358 40 160 7694", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Psykologi", "sv": "Psykologi", "en": "Psykologi"}, "www": null, "email": null, "phone": "+358 40 668 4099", "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}] | [{"value": "false", "variable": 34}, {"value": "true", "variable": 117}, {"value": "true", "variable": 44}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 46}, {"value": "1_step", "variable": 24}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 75}, {"value": "false", "variable": 48}, {"value": "false", "variable": 98}, {"value": "true", "variable": 73}, {"value": "true", "variable": 107}, {"value": "outdoors", "variable": 2}, {"value": "true", "variable": 51}, {"value": "true", "variable": 115}, {"value": "true", "variable": 59}, {"value": "false", "variable": 62}, {"value": "false", "variable": 97}, {"value": "floor_0", "variable": 108}, {"value": "true", "variable": 72}, {"value": "true", "variable": 74}, {"value": "false", "variable": 102}, {"value": "true", "variable": 5}, {"value": "true", "variable": 70}, {"value": "true", "variable": 116}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "true", "variable": 118}, {"value": "true", "variable": 92}, {"value": "opens_automatically", "variable": 77}, {"value": "true", "variable": 104}, {"value": "handrails_on_one_side", "variable": 47}, {"value": "false", "variable": 21}, {"value": "true", "variable": 78}, {"value": "false", "variable": 103}, {"value": "false", "variable": 49}, {"value": "3_consecutive_steps", "variable": 93}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 6}, {"value": "true", "variable": 38}, {"value": "true", "variable": 23}, {"value": "true", "variable": 37}, {"value": "false", "variable": 111}, {"value": "false", "variable": 33}, {"value": "true", "variable": 53}, {"value": "false", "variable": 79}, {"value": "true", "variable": 106}, {"value": "true", "variable": 76}, {"value": "false", "variable": 96}, {"value": "under_20mm", "variable": 91}, {"value": "handrails_on_one_side", "variable": 32}, {"value": "false", "variable": 22}, {"value": "false", "variable": 84}, {"value": "1_step", "variable": 39}, {"value": "1", "variable": 1}, {"value": "true",… | internal | 17790 | 154af650-9860-4994-b746-e10abb660203 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Mäkelänrinteen lukio | Mäkelänrinne Upper Secondary School | Mäkelänkatu 47 | Backasgatan 47 | Mäkelänkatu 47 | http://www.mrl.edu.hel.fi | http://www.mrl.edu.hel.fi | http://www.mrl.edu.hel.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 82343 | +358 50 401 3797 | 2015-11-27T12:11:49+02:00 | 00550 | www.hel.fi | kaikki | helsinki | 2020-11-11T16:01:16.958452+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "red", "23": "green", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [1087] | helsinki | [1274, 1280, 1273, 1281, 1282, 1286, 1287, 1292, 1284, 1293, 1294, 1270, 1296, 1259, 1269] | [816, 658, 493, 157, 99, 97, 96, 95, 90, 89, 14, 12, 11, 10, 4] | {"fi": ["Kampus-2", "koulu", "lukio", "lukiot"]} | Point | 24.948334 | 60.198414 | PL 55304, 00099 Helsingin kaupunki | Gymnasiet Mäkelänrinteen lukio | 1 | 4 | P.O. Box 55304, 00099 City of Helsinki | 1 | 4 | PB 55304, 00099 Helsingfors stad | 3 | ||||||||||||||||||||||||||||||||||
30863 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Kuraattori", "sv": "Kuraattori", "en": "Kuraattori"}, "www": null, "email": null, "phone": "+358 40 661 7175", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Psykologi", "sv": "Psykologi", "en": "Psykologi"}, "www": null, "email": null, "phone": "+358 50 401 3277", "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}] | [] | internal | 17812 | 154af650-9860-4994-b746-e10abb660203 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Ressun lukio | Ressu Upper Secondary School | Kalevankatu 8-10 | Kalevagatan 8-10 | Kalevankatu 8-10 | http://www.ressul.edu.hel.fi | http://www.ressul.edu.hel.fi | http://www.ressul.edu.hel.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 82122 | 2015-11-27T12:11:49+02:00 | 00100 | www.hel.fi | kaikki | helsinki | 2020-11-11T16:01:16.972722+02:00 | [1087] | helsinki | [1274, 1280, 1273, 1281, 1292, 1284, 1293, 1260, 1270, 1296, 1259, 1269] | [816, 658, 493, 493, 157, 148, 97, 96, 95, 12, 11, 10, 4] | {"fi": ["Kampus-3", "koulu", "lukio", "lukiot"]} | Point | 24.938286 | 60.167324 | PL 10304, 00099 Helsingin kaupunki | Gymnasiet Ressun lukio | P.O. Box 10304, 00099 City of Helsinki | PB 10304, 00099 Helsingfors stad | |||||||||||||||||||||||||||||||||||||||||
30864 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Kuraattori", "sv": "Kuraattori", "en": "Kuraattori"}, "www": null, "email": null, "phone": "+358 40 537 6852", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Psykologi", "sv": "Psykologi", "en": "Psykologi"}, "www": null, "email": null, "phone": "+358 40 637 4414", "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}] | [{"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 104}, {"value": "false", "variable": 84}, {"value": "1_step", "variable": 93}, {"value": "true", "variable": 35}, {"value": "false", "variable": 103}, {"value": "true", "variable": 23}, {"value": "true", "variable": 70}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 50}, {"value": "true", "variable": 115}, {"value": "true", "variable": 107}, {"value": "true", "variable": 38}, {"value": "opens_automatically", "variable": 77}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 62}, {"value": "false", "variable": 78}, {"value": "narrow", "variable": 18}, {"value": "false", "variable": 114}, {"value": "true", "variable": 74}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "false", "variable": 112}, {"value": "0", "variable": 1}, {"value": "false", "variable": 49}, {"value": "false", "variable": 25}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 43}, {"value": "false", "variable": 109}, {"value": "false", "variable": 42}, {"value": "false", "variable": 116}, {"value": "true", "variable": 20}, {"value": "false", "variable": 76}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 40}, {"value": "at_least_4_steps", "variable": 39}, {"value": "true", "variable": 37}, {"value": "false", "variable": 22}, {"value": "over_20mm", "variable": 56}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "false", "variable": 44}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "false", "variable": 58}, {"value": "true", "variable": 113}, {"value": "false", "variable": 5}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 117}, {"value": "false", "variable": 98}, {"value": "true", "variable": 51}, {"value": "false", "variable": 79}, {"value": "false", "variable": 83}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 105}, {"value": "fa… | internal | 17836 | 154af650-9860-4994-b746-e10abb660203 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Sibelius-lukio | Sibelius Upper Secondary School | Liisankatu 13 | Elisabetsgatan 13 | Liisankatu 13 | http://www.sibel.edu.hel.fi | http://www.sibel.edu.hel.fi | http://www.sibel.edu.hel.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 86761 | +358 50 401 3813 | 2015-11-27T12:11:49+02:00 | 00170 | www.hel.fi | kaikki | helsinki | 2020-11-11T16:01:16.987816+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, 1280, 1273, 1281, 1292, 1284, 1293, 1294, 1270, 1296, 1259, 1269] | [816, 658, 493, 493, 157, 99, 97, 96, 95, 12, 11, 10, 4] | {"fi": ["Kampus-3", "koulu", "lukio", "lukiot"]} | Point | 24.956425 | 60.174496 | PL 17304, 00099 Helsingin kaupunki | Gymnasiet Sibelius-lukio | 6 | 15 | 5 | P.O. Box 17304, 00099 City of Helsinki | 1 | 15 | PB 17304, 00099 Helsingfors stad | 12 | |||||||||||||||||||||||||||||||||
30865 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Kuraattori", "sv": "Kuraattori", "en": "Kuraattori"}, "www": null, "email": null, "phone": "+358 40 681 6861", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Psykologi", "sv": "Psykologi", "en": "Psykologi"}, "www": null, "email": null, "phone": "+358 50 402 5562", "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", "sv": "Tillg\u00e4nglig: auditorium", "en": "Available: auditorium"}, "www": {"fi": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/fi/palvelut/tilojen-varaaminen/koulutilojen-kaytto"}, "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/", "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": "handrails_on_one_side", "variable": 95}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 102}, {"value": "false", "variable": 46}, {"value": "at_least_4_steps", "variable": 93}, {"value": "true", "variable": 58}, {"value": "true", "variable": 92}, {"value": "true", "variable": 44}, {"value": "1_step", "variable": 24}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 21}, {"value": "false", "variable": 83}, {"value": "true", "variable": 104}, {"value": "false", "variable": 22}, {"value": "false", "variable": 103}, {"value": "true", "variable": 37}, {"value": "false", "variable": 70}, {"value": "false", "variable": 107}, {"value": "true", "variable": 29}, {"value": "no_handrails", "variable": 32}, {"value": "opens_with_access_control_key", "variable": 54}, {"value": "true", "variable": 79}, {"value": "false", "variable": 94}, {"value": "false", "variable": 51}, {"value": "false", "variable": 53}, {"value": "over_20mm", "variable": 91}, {"value": "2", "variable": 64}, {"value": "true", "variable": 5}, {"value": "true", "variable": 105}, {"value": "true", "variable": 38}, {"value": "true", "variable": 59}, {"value": "false", "variable": 62}, {"value": "false", "variable": 48}, {"value": "true", "variable": 52}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "no_handrails", "variable": 47}, {"value": "true", "variable": 6}, {"value": "1_step", "variable": 39}, {"value": "true", "variable": 23}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 33}, {"value": "false", "variable": 49}, {"value": "false", "variable": 31}, {"value": "true", "variable": 57}, {"value": "false", "variable": 34}, {"value": "0", "variable": 1}, {"value": "false", "variable": 98}, {"value": "long_term_stay", "variable": 60}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "false", "variable": 106}, {"value": "true", "variable": 20}, {"value": "false", "variable": 84}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "indoor_faci… | internal | 17609 | 154af650-9860-4994-b746-e10abb660203 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Vuosaaren lukio | Vuosaari Upper Secondary School | Vuosaarentie 7 | Nordsjövägen 7 | Vuosaarentie 7 | https://www.hel.fi/vuolu/fi | https://www.hel.fi/vuolu/fi | https://www.hel.fi/vuolu/fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 86800 | +358 50 373 7983 | 2015-11-27T12:11:49+02:00 | 00980 | www.hel.fi | kaikki | helsinki | 2020-11-11T16:01:17.002590+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"} | [1087] | helsinki | [1274, 1273, 1286, 1292, 1284, 1293, 1296, 1259, 1269] | [816, 658, 493, 97, 96, 95, 89, 11, 4] | {"fi": ["sali", "Kampus-3", "kuninkaankolmio", "tilanvaraus", "tilavaraus", "koulu", "lukio", "lukiot"], "sv": ["lokalbokning"], "en": ["reservation of premises"]} | Point | 25.14523 | 60.20915 | PL 98306, 00099 Helsingin kaupunki | Gymnasiet Vuosaaren lukio | 4 | 8 | P.O. Box 98306, 00099 City of Helsinki | 1 | 6 | PB 98306, 00099 Helsingfors stad | 5 | ||||||||||||||||||||||||||||||||||
43355 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 11-19, la 11-18", "sv": "\u00f6ppet m\u00e5n-fre 11-19, l\u00f6r 11-18", "en": "open Mon-Fri 11-19, Sat 11-18"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [] | internal | 19150 | visithelsinki | 2377 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Kluuvin kauppakeskuksessa sijaitseva konseptiliike jossa muotia nuorekkaille aikuisille. | A concept store that offers todays fashion for youthful adults. | Maranello | Maranello | Aleksanterinkatu 9, Kauppakeskus Kluuvi | Alexandersgatan 9, Kauppakeskus Kluuvi | Aleksanterinkatu 9, Kauppakeskus Kluuvi | http://www.maranello.fi/maranello-men-women/ | http://www.maranello.fi/maranello-men-women/ | http://www.maranello.fi/maranello-men-women/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 622 1062 | 2014-11-14T01:06:24+02:00 | 00100 | www.myhelsinki.fi | kaikki | helsinki | 2020-11-11T08:01:37.601369+02:00 | [1403] | helsinki | [750] | [490] | {} | Point | 24.948473 | 60.1693 | |||||||||||||||||||||||||||||||||||||||||
54897 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-la 07-18", "sv": "\u00f6ppet m\u00e5n-l\u00f6r 07-18", "en": "open Mon-Sat 07-18"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Lounas ma-pe 11-14", "sv": "Lunch m\u00e5-fre 11-14", "en": "Lunch Mon-Fri 11-14"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [] | internal | 24314 | visithelsinki | 2859 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Tukkutorin Kala on laajan ja tuoreen valikoiman asiantunteva kala- ja äyriäiskauppa sekä lounasravintola. Palvelutiskiovat täynnä herkullisia tuoreita kaloja ja muita mereneläviä. Tukkutorin kalaan voi poiketa myös aamukahville, arkisin lounaalle, brunssille lauantaisin, herkulliselle bliniannokselle tai vaikkapa syömaan pari osteria. | Tukkutorin Kala in Teurastamo area is a shop selling fish and seafood, as well as a lunch restaurant serving lunch on weekdays and brunch on Saturdays. | Tukkutorin kala | Tukkutorin kala | Työpajankatu 2b | Verkstadsgatan 2b | Työpajankatu 2b | http://www.tukkutorinkala.fi/ | http://www.tukkutorinkala.fi | http://www.tukkutorinkala.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 10 311 3666 | info@tukkutorinkala.fi | 2017-10-31T01:06:37+02:00 | 00580 | www.myhelsinki.fi | kaikki | helsinki | 2020-11-11T08:01:53.265897+02:00 | [1403] | helsinki | [750, 751] | [577, 490] | {} | Point | 24.971699 | 60.189613 | Tukkutorin kala | Tukkutorin Kala är en fiskbutik med brett sortiment, även skaldjur. I samband med butiken finns en lunchrestaurang som serverar lunch på vardagar och brunch på lördagar. | ||||||||||||||||||||||||||||||||||||||
54922 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ke-to 16-22, pe 16-23, la 13-23", "sv": "\u00f6ppet ons-tor 16-22, fre 16-23, l\u00f6r 13-23", "en": "open Wed-Thu 16-22, Fri 16-23, Sat 13-23"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [] | internal | 24210 | visithelsinki | 2689 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Umeshu on intohimoisesti japanilaiselle ruoalle ja juomalle omistautunut intiimi ravintola Töölössä. Jo vuodesta 2008 Umeshussa sushit kuin lämpimätkin annokset valmistettu käsityönä huippulaatuisista raaka-aineista avokeittiössä suoraan asiakkaiden silmien edessä. Sesonkien mukaan vaihtuvalta ruokalistalta löytyy perinteisiä japanilaisia annoksia, sekä tietenkin Umeshun tyyliin hiottuja kokonaisuuksia. | Umeshu is an intimate Japanese restaurant in Töölö. Umeshu has been serving handmade sushi and other Japanese dishes, made out of quality ingredients, since 2008. The seasonally changing menu includes both traditional Japanese dishes as well as menus with an Umeshu touch. | Umeshu | Umeshu | Pohjoinen Hesperiankatu 15 | Norra Hesperiagatan 15 | Pohjoinen Hesperiankatu 15 | https://www.umeshu.fi/ | https://www.umeshu.fi/ | https://www.umeshu.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 454 3670 | info@umeshu.fi | 2017-10-31T01:06:37+02:00 | 00260 | www.myhelsinki.fi | kaikki | helsinki | 2020-11-11T08:01:53.359762+02:00 | [1403] | helsinki | [751] | [577] | {} | Point | 24.92447 | 60.17745 | Umeshu | Umeshu är en intim japansk restaurang i Tölö. Allt sedan 2008 har restaurangen bjudit på sushi och varma rätter, handgjorda av högklassiga råvaror i det öppna köket. På menyn, som byter enligt säsong, finns traditionella japanska rätter samt menyhelheter i Umeshu stil. | ||||||||||||||||||||||||||||||||||||||
57225 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Ks. tapahtumat ja aukioloajat kotisivuilta.", "sv": "V\u00e4nligen se \u00f6ppettider och evenemang p\u00e5 hemsidan.", "en": "Please check opening hours and events on webpages"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [] | internal | 26281 | visithelsinki | 3332 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Väinö Kallio on tilausravintola ja tapahtumatila jossa järjestetään myös yleisölle avoimia tapahtumia. Väinö Kalliossa koet mm.konsertteja, teatteria, tanssia, iloja ja draamoja. Rakennus on Väinö Vähäkallion suunnittelema, vuonna 1928 rakennettu entinen Elannon pääkonttori. | Väinö Kallio is a restaurant and an event venue. There are different events organized here, eg. concerts, theatre, dancing etc. The building was designed By Väinö Vähäkallio in 1928, and served as the Elanto head quarters. | Väinö Kallio | Väinö Kallio | Hämeentie 11 | Tavastvägen 11 | Hämeentie 11 | https://www.vainokallio.fi/ | https://www.vainokallio.fi/ | https://www.vainokallio.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 534 5257 | myynti@foodcampfinland.fi | 2018-06-12T01:21:50+03:00 | 00530 | www.myhelsinki.fi | kaikki | helsinki | 2020-11-11T08:01:58.123635+02:00 | [1403] | helsinki | [751] | [577] | {} | Point | 24.958893 | 60.18322 | Väinö Kallio | Väinö Kallio är en beställningsrestaurang och evenemangsplats. Här ordnas det bl.a. konserter, teater, dans och andra evenemang. Byggnaden planerades av Väinö Vähäkallio år 1928, och har fungerat som Elantos huvudkontor. | ||||||||||||||||||||||||||||||||||||||
57504 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 11-14:30", "sv": "\u00f6ppet m\u00e5n-fre 11-14:30", "en": "open Mon-Fri 11-14:30"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [] | internal | 26540 | visithelsinki | 3393 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Twisted Street Kitchen on Aasia-vaikutteinen lounasravintola Helsingin keskustassa joka on tunnettu raikkaasta aasialaisen katukeittiön mausta ja rennosta meiningistä. Lounasaikaan listalta löytyy jo klassikoiksi muodostuneet lämpimän mausteiset kookos-curryt, liharuuat ja salaatit. Kaikissa annoksissa maistuu ravintolan oma twisti. | Twisted Street Kitchen is an Asian inspired lunch restaurant in the city centre known for its fresh Asian street food flavours and a relaxed atmosphere. | Twisted Street Kitchen | Twisted Street Kitchen | Fredrikinkatu 58 | Fredriksgatan 58 | Fredrikinkatu 58 | https://www.twistedhelsinki.fi/ | https://www.twistedhelsinki.fi/ | https://www.twistedhelsinki.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 44 085 5566 | 2018-08-21T01:21:21+03:00 | 00100 | www.myhelsinki.fi | kaikki | helsinki | 2020-11-11T07:31:57.123449+02:00 | [1403] | helsinki | [751] | [577] | {} | Point | 24.92791 | 60.17065 | |||||||||||||||||||||||||||||||||||||||||
59415 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-la 10-19", "sv": "\u00f6ppet m\u00e5n-l\u00f6r 10-19", "en": "open Mon-Sat 10-19"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [] | internal | 28246 | visithelsinki | 3698 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Trendikäs naistenvaateliike Mall of Triplassa. | Trendy women's clothing store at Mall of Tripla. | BCS Of Fashion | BCS Of Fashion | Fredikanterassi 1, Mall of Tripla, 3. krs | Fredriksbergsterrassen 1, Mall of Tripla, 3. vån. | Fredikanterassi 1, Mall of Tripla, 3. floor | https://www.bcsfashion.fi/ | https://www.bcsfashion.fi/ | https://www.bcsfashion.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 20 734 0734 | info@bcsfashion.fi | 2019-04-16T05:21:29+03:00 | 00520 | www.myhelsinki.fi | kaikki | helsinki | 2020-11-11T08:02:04.961336+02:00 | [1403] | helsinki | [750] | [490] | {} | Point | 24.931267 | 60.19866 | BCS OF Fashion | Klädaffär med trendiga kläder för kvinnor i Mall of Tripla. | ||||||||||||||||||||||||||||||||||||||
61827 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-la 10-23, su 11-19", "sv": "\u00f6ppet m\u00e5n-l\u00f6r 10-23, s\u00f6n 11-19", "en": "open Mon-Sat 10-23, Sun 11-19"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [] | internal | 30658 | visithelsinki | 3960 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Urban Rabbit on sopivasti rosoinen ja sielukas kohtaamispaikka Triplassa. Tiskin takana intohimoiset ammattilaiset loihtivat maailmanluokan cocktailit ja vinkkaavat parhaat erikoisoluet, joiden kanssa maistuu urbaani bistroruoka. | Urban Rabbit is a suitably laid-back and soulful meeting place in Tripla shopping centre. Behind the counter, the skilled bar staff conjure up world-class cocktails and give tips on the best speciality beers to go with urban bistro food. | Urban Rabbit | Urban Rabbit | Fredikanterassi 1, Mall of Tripla | Fredriksbergsterrassen 1, Mall of Tripla | Fredikanterassi 1, Mall of Tripla | https://www.raflaamo.fi/fi/helsinki/urban-rabbit | https://www.raflaamo.fi/fi/helsinki/urban-rabbit | https://www.raflaamo.fi/en/helsinki/urban-rabbit | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 10 766 3610 | 2020-01-29T05:21:36+02:00 | 00520 | www.myhelsinki.fi | kaikki | helsinki | 2020-11-11T08:02:13.215559+02:00 | [1403] | helsinki | [751] | [577] | {} | Point | 24.93116 | 60.19837 |
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 );