unit
2 rows where identifiers_2_namespace = "lipas" and short_description_en = "Ten artificial skating rinks all over Helsinki make the pleasures of skating and ice hockey available to people of all ages."
This data as json, CSV (advanced)
short_description_en ✖
- Ten artificial skating rinks all over Helsinki make the pleasures of skating and ice hockey available to people of all ages. · 2 ✖
accessibility_shortcoming_count_stroller ✖
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40550 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Huom!\nOtamme maksimissaan 450 henkil\u00f6\u00e4 tekoj\u00e4\u00e4kent\u00e4lle kerrallaan. Varauduthan odottamaan vuoroasi!\n\nSis\u00e4tilat on suljettu toistaiseksi. Pukeutuminen tapahtuu ulkona. Tiistaista perjantaihin yleis\u00f6 vasta klo 9.00.\n\nMuuta: pika- ja retkiluistimilla luistelu on kielletty yleis\u00f6luisteluaikoina\n\nYleis\u00f6luisteluajat:\nma. 8.00-15.00 ja 17.30-19.00\nti 9.00-15.00 \nke 9.00-15.00\nto 9.00-15.00, 16.00-17.30\npe 9.00-15.00 \nla 10.00-13.30, 19.00-22.00\nsu 10.00-11.30, 18.30-22.00", "sv": "Obs! Den maximala offentliga kapaciteten \u00e4r 450 personer. \nF\u00f6rbereda dig att v\u00e4nta p\u00e5 din turn.\n\nOmkl\u00e4dningsrummen \u00e4r tils vidare st\u00e4ngda. Ombyte sker utomhus.\n\n\u00d6vrigt: Att \u00e5ka med t\u00e4vlings- eller l\u00e5ngf\u00e4rdsskridskor \u00e4r f\u00f6rbjudet under skridsko\u00e5kning f\u00f6r allm\u00e4nheten\n\nSkridsko\u00e5kning tider:\nm\u00e5 8.00-15.00, 17.30-19.00\nti 9.00-15.00 \nons 9.00-15.00\nto 9.00-15.00, 16.00-17.30\nfre 9.00-15.00\nl\u00f6 10.00-13.30, 19.00-22.00\ns\u00f6 10.00-11.30, 18.30-22.00", "en": "Note! maximum public skating capacity 450. Prepare to wait for Your turn.\n\nInterior closed, dressing outdoors\n\nOther info: Skating on speed skates or tour skates is not allowed during public skating times\n\nPublic skating\nMon 8.00-15.00, 17.30-19.00\nTue 9.00-15.00\nWed 9.00-15.00\nThu 9.00-15.00, 16.00-17.30\nFri 9.00-15.00\nSat 10.00-13.30, 19.00-22.00\nSun 10.00-11.30, 18.30-22.0"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Poikkeusyleis\u00f6luisteluaukioloajat:\n\n5.1.2021 klo 9.00-15.00 ja 20.30-22.00\n6.1.2021 Loppiainen klo 9.00-15.00 ja 18.30-21.00\n9.1.2021 klo 10.00-15.00 ja 19.30-22.00\n10.1.2021 klo 10.30-15.00 ja 17.30-22.00", "sv": "Avvikkande skrisko\u00e5kningtider:\n\n3.1.2021 kl 10.30 -15.00 och 17.30-22.00\n5.1.2021 kl 9.00-15.00 och 20.30-22.00\n6.1.2021 Trettondag kl 9.00-… | [] | internal | 18897 | visithelsinki | 1614 | 8cd98729-58be-4a0f-a55a-aa146c068dd1 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | https://helsinki.emmi.fi/l/n87SW85Xd-9H | MaksutonPalvelut: Kahvila. Luistinten teroitusta (HIFK), Veikko Niemelä, puh. 0500 514 264, avoinna luistelukauden aikana: ma 7.00 - 19.00, ti 16.00 - 18.00, ke 12.00 - 15.00, to ja pe 16.00 - 19.00, la 10.00 - 13.30, su 10.00 - 12.00 ja 18.00 - 21.00. Hinta 8 euroa käteisellä. | Free of chargeServices: Café. Skate sharpening (HIFK), Veikko Niemelä, Tel. 0500 514 264, open: rMon 17.00 - 19.00, Tue 16.00 - 18.00, Thu, Fri 16.00 - 19.00, Sat 10.00 - 13.30, Sun 10.00 - 12.00 and 18.00 - 21.00. | Oulunkylän tekojääkenttä | Oulunkylä sports park artificial ice rink | Käskynhaltijantie 11 | Ståthållarvägen 11 | Käskynhaltijantie 11 | 2014-09-05T13:29:49+03:00 | 00640 | www.hel.fi | kaikki | helsinki | 2021-01-04T11:31:34.096203+02:00 | [1403] | helsinki | [645] | [695] | {} | Point | 24.958902 | 60.234463 | 76268 | Åggelby idrottsparks konstisbana | Kymmenen tekojääkenttää ympäri Helsingin tarjoavat luistelun ja pelaamisen riemua kaikenikäisille. | lipas | Tio konstisbanor runt om i Helsingfors får människor i alla åldrar uppleva glädjen med att åka skridskor och spela. | AvgiftsfriTjänster: Kafé. Vässning av skridskor (HIFK), Veikko Niemelä, tfn. 0500 514 264, öppet: må 17.00 - 19.00, ti 16.00 - 18.00, on 12.00 - 15.00, to och fr 16.00 - 19.00, lö 10.00 - 13.30, sö 10.00 - 12.00 och 18.00 - 21.00. | Ten artificial skating rinks all over Helsinki make the pleasures of skating and ice hockey available to people of all ages. | ||||||||||||||||||||||||||||||||||||||||
| 40725 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Huom! \nOtamme maksimissaan 150 henkil\u00f6\u00e4 tekoj\u00e4\u00e4kent\u00e4lle kerrallaan. Varauduthan odottamaan vuoroasi!"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Yleis\u00f6luistelu ja vapaaharjoittelu:\nma 8.00 - 15.00 ja 16.00 - 21.30\nti 8.00 - 15.00 \nke 8.00 - 15.00 ja 16.00 - 21.30\nto 8.00 - 15.00 \npe 8.00 - 15.00 ja 16.00 - 21.30\nla 9.00 - 15.00 ja 16.00 - 21.00\nsu 9.00 - 15.00 ja 16.00 - 21.00", "sv": "Skridsko\u00e5kning och fri \u00f6vning\nm\u00e5 8.00 - 15.00 och 16.00 - 21.30\nti 8.00 - 15.00 \non 8.00 - 15.00 och 16.00 - 21.30\nto 8.00 - 15.00 \nfr 8.00 - 15.00 och 16.00 - 21.30\nl\u00f6 9.00 - 15.00 och 16.00 - 21.00\ns\u00f6 9.00 - 15.00 och 16.00 - 21.00", "en": "Skating and free practice:\nMon 8.00 - 15.00 and 16.00 - 21.30\nTue 8.00 - 15.00 \nWed 8.00 - 15.00 and 16.00 - 21.30\nThu 8.00 - 15.00 \nFri 8.00 - 15.00 and 16.00 - 21.30\nSat 9.00 - 15.00 and 16.00 - 21.00\nSun 9.00 - 15.00 and 16.00 - 21.00"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Poikkeusaukioloajat:\n\n6.1. 2021 Loppiainen klo 9-15 ja 16-21", "sv": "Avvikkande \u00f6ppettider:\n\n6.1.2021 Trettondag kl 9-15 och 16-21", "en": "Exceptional opening hours:\n\n6.1.2021 Epiphany 9am-3pm and 4pm-9pm"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "liikuntapaikanhoitajat", "sv": "anl\u00e4ggningspersonalen", "en": "facility supervisors"}, "www": null, "email": null, "phone": "+358 9 310 62268", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "tiimiesimies ma - pe 7.00 - 13.00", "sv": "teamchef m\u00e5 - fr 7.00 - 13.00", "en": "manager Mon - Fri 7.00 - 13.00"}, "www": null, "email": null, "phone": "+358 9 310 87200", "contact_person": null}, {"section_type": "TOPICAL", "name": {"fi": "Lauantaista 5.12. l\u00e4htien p\u00e4\u… | [] | internal | 79 | visithelsinki | 2187 | 6816e19c-4591-41ba-94f2-18b997375018 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | MaksutonPalvelut: Emme lainaa luistimia tällä hetkellä koronan vuoksi. Muuta: pika- ja retkiluistimilla luistelu on kielletty yleisöluisteluaikoina, alueet erikseen ilman mailoja ja mailojen kanssa luisteleville. | Free of chargeServices: skates can not be borrowed.Other info: Skating on speed skates or tour skates is not allowed during public skating times f ields for skaters both without sticks and with sticks. | Kontulan liikuntapuisto / Tekojääkenttä | Kontula sports park artificial ice rink | Tanhuantie 4a | Tunvägen 4a | Tanhuantie 4a | 2014-09-05T13:29:49+03:00 | 00940 | www.hel.fi | kaikki | helsinki | 2021-01-03T13:01:20.793874+02:00 | [1403] | helsinki | [645] | [695] | {} | Point | 25.093456 | 60.23365 | 503469 | Gårdsbacka idrottsparks konstisbana | Kymmenen tekojääkenttää ympäri Helsingin tarjoavat luistelun ja pelaamisen riemua kaikenikäisille. | lipas | Tio konstisbanor runt om i Helsingfors får människor i alla åldrar uppleva glädjen med att åka skridskor och spela. | AvgiftsfriTjänster: Övrigt: Att åka med tävlings- eller långfärdsskridskor är förbjudet under skridskoåkning för allmänheten planer för skridskoåkare både utan klubbor och med klubbor. | Ten artificial skating rinks all over Helsinki make the pleasures of skating and ice hockey available to people of all ages. |
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 );