unit
1 row where identifiers_2_namespace = "lipas" and short_description_en = "Sports Services has 14 sports halls; ski hall, ball hall, Football hall."
This data as json, CSV (advanced)
Suggested facets: created_time (date)
short_description_en ✖
- Sports Services has 14 sports halls; ski hall, ball hall, Football hall. · 1 ✖
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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40354 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Poikkeusaukioloajat -\n30.11-2020-10.1-2021 SULJETTU\n23.12. klo 07:00 - 15:00\n24.12. suljettu\n25.12. suljettu\n26.12. klo 12:00 - 21:00\n27.12. klo 07:00 - 21:00\n28.12. klo 07:00 - 21:00\n29.12. klo 07:00 - 21:00\n30.12. klo 07:00 - 21:00\n31.12. klo 07:00 - 15:00 \n01.01. klo 11:00 - 16:00\n02.01. - klo 07:00 - 21:00", "sv": "Avvikande \u00f6ppettider -", "en": "Exceptional opening hours -"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Hiihtokausi alkaen 5.10.2020\nma - su 7.00 - 20.00 \nhalli suljetaan klo 21.00", "sv": "Skids\u00e4songen b\u00f6rjar 5.10.2020\nm\u00e5 - s\u00f6 7.00 - 20.00 \nIng\u00e5ngstiden slutar kl. 20.00 och hallen st\u00e4ngs kl. 21.00", "en": "Open from 5.10.2020\nMon - Sun 7.00 - 20.00 \nSkiing track will be closed at 21.00 daily"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "HIGHLIGHT", "name": {"fi": "Helsingin kaupungin sis\u00e4liikuntapaikat suljettu koronarajoitusten takia 30.11.2020-10.1.2021", "sv": "Helsingfors stads idrotts- och motionslokaler \u00e4r st\u00e4ngda p\u00e5 grund av coronarestriktioner 30.11.2020 - 10.1.2021.", "en": "City of Helsinki's indoor sports facilities are closed due Covid-19 restrictions from November 30th, 2020 to January 10th, 2021."}, "www": {"fi": "https://www.hel.fi/uutiset/fi/kaupunginkanslia/pkseudun-koronakoordinaatioryhma-rajoitusten-jatkamisesta", "sv": "https://www.hel.fi/uutiset/fi/kaupunginkanslia/pkseudun-koronakoordinaatioryhma-rajoitusten-jatkamisesta", "en": "https://www.hel.fi/uutiset/fi/kaupunginkanslia/pkseudun-koronakoordinaatioryhma-rajoitusten-jatkamisesta"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "kassa", "sv": "kassa", "en": "cashier"}, "www": null, "email": null, "phone": "+358 9 224 5103", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "tiimiesimies ma- pe 7.00 - … | [{"value": "2", "variable": 1}, {"value": "true", "variable": 70}, {"value": "true", "variable": 80}, {"value": "true", "variable": 50}, {"value": "true", "variable": 104}, {"value": "false", "variable": 53}, {"value": "false", "variable": 103}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "false", "variable": 29}, {"value": "true", "variable": 115}, {"value": "false", "variable": 72}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "next_to_door_on_opening_side", "variable": 110}, {"value": "false", "variable": 84}, {"value": "false", "variable": 33}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 20}, {"value": "false", "variable": 48}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "true", "variable": 59}, {"value": "false", "variable": 62}, {"value": "false", "variable": 23}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 105}, {"value": "true", "variable": 112}, {"value": "true", "variable": 117}, {"value": "false", "variable": 38}, {"value": "false", "variable": 116}, {"value": "false", "variable": 79}, {"value": "false", "variable": 46}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 51}, {"value": "false", "variable": 49}, {"value": "true", "variable": 58}, {"value": "multipurpose_sport_hall", "variable": 61}, {"value": "false", "variable": 83}, {"value": "true", "variable": 74}, {"value": "true", "variable": 76}, {"value": "true", "variable": 78}, {"value": "no_handrails", "variable": 47}, {"value": "false", "variable": 98}, {"value": "2", "variable": 63}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 109}, {"value": "false", "variable": 118}, {"value": "true", "variable": 113}, {"value": "outdoors", "variable": 2}, {"value": "less_than_3600mm", "variable": 3}, {"value": "true", "variable": 107}, {"value": "false", "variable": 114}, {"value": "under_10m", "variable": 4}, {"value": "no… | internal | 20680 | visithelsinki | 1578 | ebcc794c-8f69-40f9-8214-89d972710d15 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | HinnatAikuiset - kerta 14 e - 5 krt 50 e + 3 e avainkortti- 10 krt 90 e + 3 e avainkorttiMuut - kerta 12 e - 5 krt 40 e + 3 e avainkortti- 10 krt 70 e + 3 e avainkorttiLapset (7 - 11 v.) - kerta 10 e - 5 krt 30 e + 3 e avainkortti- 10 krt 50 e + 3 e avainkortti - perhelippu yksi aikuinen ja yksi 7 - 11 v. lapsi 15 e- alle 7-vuotiaat lapset pääsevät hiihtämään maksutta pääsylipun lunastaneen ja hiihtävän aikuisen seurassa.Lippu oikeuttaa vain hallissa hiihtämiseen.Muihin aktiviteetteihin voi erikseen ostaa liput niitä hallissa järjestäviltä toimijoilta.Älykortille ostetut tuotteet ovat voimassa 540 päivää ostopäivästä lukien.Maksuvälineeksi käy Smartum- setelit, Smartum Saldo, Virike-setelit, Ticket Virike ja Ticket Duo, Tyky-Online (ei setelit), ePassi (vain verkkomaksu), Eazybreak -mobiiliseteli. Lisäksi käy käteinen, MasterCard, American Express, Visa, Visa Electron.Suksihuollon hinnat Perinteiset sukset - peruskunnostus 29 e - pitovoitelu 9 e Luistelusukset - peruskunnostus 25 e - lisäluisto 7 e Suksien uunitus 68 e sisältää peruskunnostuksen Pitopohja- ja muovipohjasuksien puhdistus 25 eHiihtoladun peruskierros on noin 850 metriä ja lisälenkki 200 metriä, ja latujen leveys on 6 - 8 metriä.Palvelut: Aulakahvila avoinna päivittäin klo 8.00 - 20.00, talvimaailma, kuntosali ja lasten liikuntapuisto. Hiihtohallin aukioloaikoina suksivuokrausta, suksien huoltopalvelu, suksivoiteita myynnissä. Sukset voi jättää huoltoon päivittäin, voideltujen suksien noudot tiistaisin ja perjantaisin. Suksivuokran hinta on 20 e /3 tuntia (sis. sukset, monot ja sauvat).Winter World, kuntosali, trampoliinipuisto ja telinevoimistelu ovat maksullisia ulkopuolisia palveluita.Hiihtoladun peruskierros on noin 850 metriä ja lisälenkki 200 metriä, ja latujen leveys on 6 - 8 metriä.Muuta: Varaa 1 euron kolikkopantti pukukaapille. | ChargesAdult - single €14 - 5 times €50 + €3 key card - 10 times €90 + €3 key card Other - single €12 - 5 times €40 + €3 key card - 10 times €70 + €3 key card Kids (7 - 11-yo) - single €10 - 5 times €30 + €3 key card - 10 times €50 + €3 key card - familyticket one adult and one 7 - 11-yo kid €15TIcket only entitles tos skiing in the hall.Tickets for other activities can be purchased separately from the other organizers.- products purchased on a Smart Card are valid for 540 days from the date of purchase.Payment methods available are: Smartum- and Virike-vouchers; MasterCard; American Express; Body & Mind-card; Visa and VisaElectron. Tyky-vouchers and Sportti passi only online payment.Services: Lobby Café is open every day 8.00 - 20.00, Winter World, the gym, the children's sports, The Ski Shop is Mon - Sun 8.00 - 21.00. Ski hire, ski maintenance service, ski waxes for sale. Skis can be left for servicing daily, waxed skis can be picked up on Tuesdays and Fridays.A basic circuit of the ski track is 850 metres, with the additional loop adding another 200 metres. The width of the tracks is 6-8 metres.Other info: Make sure you have a 1 euro coin as a deposit for the locker. | Kivikon hiihtohalli | Kivikko ski hall | Savikiekontie 4 | Lerduvevägen 4 | Savikiekontie 4 | 2014-09-05T13:29:49+03:00 | 00940 | www.hel.fi | kaikki | helsinki | 2020-12-14T10:31:30.575745+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [1403] | helsinki | [569] | [194] | {} | Point | 25.052113 | 60.238224 | 98157 | Stensböle skidhall | Liikuntapalvelulla on 14 liikuntahallia, mm. palloiluhalli, jalkapallohalli ja hiihtohalli. Liikuntahalleissa voi harrastaa monenlaista liikuntaa. | 2 | 4 | 1 | 4 | lipas | Idrott services förfogar över 14 idrottshallar; bollhall, skidhall och fotbollshall. | PriserVuxna - 1 gång 14 e - 5 ggr 50 e + 3 e nyckelkort- 10 ggr 90 e + 3 e nyckelkortAndra - 1 gång 12 e - 5 ggr 40 e + 3 e nyckelkort- 10 ggr 70 e + 3 e nyckelkortBarn (7 - 11 år) - 1 gång 10 e - 5 ggr 30 e + 3 e nyckelkort- 10 ggr 50 e + 3 e nyckelkort - familjebiljett nn fullvuxen och ett barn 7 - 11 år, 15 eBiljetten berättigar endast skidåkning i hallen.Biljetter till andra aktiviteter kan köpas separat från de andra arrangörerna.- produkter som köpts på smartkortet är i kraft 540 dagar efter köpet.Som betalningsmedel fungerar sedlarna Smartum och Virike samt MasterCard, American Express, Body & Mind-kort, Visa och VisaElectron. Tyky-sedlarna och Sportti passi bara nätbetalning.Tjänster: Kafé öppet alla dagar kl 8.00 - 20.00, vintervärlden, gymmet, idrottsparken för, Ski Shop är öppen må - sö kl. 8.00 - 21.00. Uthyrning och underhåll av skidor samt skidvalla till försäljning. Skidor kan lämnas in för underhåll varje dag och vallade skidor kan hämtas på tisdagar och fredagar.Basrundan längs skidspåret är cirka 850 meter och ett extra spår 200 meter. Skidbanorna är 6 - 8 meter breda.Övrigt: Ta med dig ett 1 euros mynt som pant i klädskåpen. | 4 | Sports Services has 14 sports halls; ski hall, ball hall, Football hall. |
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 );