1 row where short_description_en = "Sports Services has 14 sports halls; ski hall, ball hall, Football hall."

View and edit SQL

identifiers_2_namespace

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

CSV options:

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
);