2 rows where accessibility_shortcoming_count_visually_impaired = 4 and identifiers_2_namespace = "lipas"

View and edit SQL

Suggested facets: created_time (date)

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.    
41835 [{"section_type": "OPENING_HOURS", "name": {"fi": "Poikkeusaukioloajat:\n30.11.2020 - 10.1.2021 suljettu", "sv": "Avvikande \u00f6ppettider\n30.11.2020 - 10.1.2021 st\u00e4ngd", "en": "Exceptional opening hours:\n30.11.2020 - 10.1.2021 closed"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 11.8.2020 -\nma - ke, pe 6.15 - 20.30\nto 11.00 - 20.30\nla, su 8.00 - 20.30\n\nUintiaikaa on tunti kassan sulkeutumisesta. Sen j\u00e4lkeen 15 minuuttia peseytymisaikaa ja 15 minuuttia pukeutumisaikaa.", "sv": "Perioden 11.8.2020 -\nm\u00e5 - ons, fre 6.15 - 20.30\nto 11.00 - 20.30\nl\u00f6, s\u00f6 8.00 - 20.30\n\nD\u00f6rrarna och kassan st\u00e4ngs 60 minuter innan tr\u00e4ningstiden tar slut. Efter att bad- och tr\u00e4ningstiden tagit slut har ni 15 minuter p\u00e5 er att duscha och 15 minuter att kl\u00e4 p\u00e5 er.", "en": "Period 11.8.2020 -\nMon - Wed, Fri 6.15 - 20.30\nThu 11.00 - 20.30\nSat, Sun 8.00 - 20.30\n\nThe entrance and cash desk close an hour before the training time ends. You will have 15 minutes to wash and 15 minutes to get dressed after the swimming and training time ends."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Huom!\n- perhepukuhuoneiden siivoustauko la ja su klo 12.30-13.30\n\nYl\u00e4kerran kuntosali:\n- ma - pe 10.00 - 13.00 ainoastaan seniori-liikuntaa\n- ma - pe klo 13.00 - 13.30 suljettu siivoustauon ajaksi\n- ma 16.00 - 18.00 suljettu", "sv": "Obs!\n- omkl\u00e4dningsrummen f\u00f6r familjer st\u00e4ngs f\u00f6r st\u00e4dning l\u00f6r och s\u00f6n kl. 12.30-13.30\n\n\u00d6vre v\u00e5ningens gym:\n- m\u00e5n-fre kl. 10.00 - 13.00 endast seniormotion\n- m\u00e5n - fre kl. 13.00 - 13.30 st\u00e4ngt f\u00f6r st\u00e4dning \n- m\u00e5n kl. 16.00-18.00 st\u00e4ngt", "en": "Note!\n- The family changing room is closed for cleaning from 12.30 to 13.30 on Saturdays and Sundays\n\nUpstairs gym:\n- Mon - Fri 10.00 - 13.00 only senior exercise class… [{"value": "true", "variable": 114}, {"value": "true", "variable": 115}, {"value": "false", "variable": 83}, {"value": "true", "variable": 113}, {"value": "false", "variable": 22}, {"value": "false", "variable": 92}, {"value": "false", "variable": 5}, {"value": "false", "variable": 29}, {"value": "over_10m", "variable": 4}, {"value": "less_than_3600mm", "variable": 3}, {"value": "2", "variable": 1}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 23}, {"value": "true", "variable": 6}, {"value": "false", "variable": 21}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 20}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 38}, {"value": "false", "variable": 34}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 33}, {"value": "true", "variable": 35}, {"value": "false", "variable": 48}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "false", "variable": 44}, {"value": "false", "variable": 49}, {"value": "true", "variable": 53}, {"value": "true", "variable": 52}, {"value": "true", "variable": 50}, {"value": "true", "variable": 51}, {"value": "true", "variable": 80}, {"value": "true", "variable": 37}, {"value": "false", "variable": 57}, {"value": "1", "variable": 63}, {"value": "sport_facility", "variable": 60}, {"value": "false", "variable": 59}, {"value": "true", "variable": 72}, {"value": "false", "variable": 62}, {"value": "swimming_hall", "variable": 61}, {"value": "true", "variable": 74}, {"value": "false", "variable": 79}, {"value": "true", "variable": 70}, {"value": "true", "variable": 73}, {"value": "true", "variable": 75}, {"value": "true", "variable": 78}, {"value": "opens_automatically", "variable": 77}, {"value": "true", "variable": 76}, {"value": "false", "variable": 111}, {"value": "true", "variable": 107}, {"value": "false", "variable": 116}, {"value": "false", "variable": 106}, … internal 10530 visithelsinki 260 52729bbe-abb4-4825-a188-a6313fb3e41b 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1       https://farm2.staticflickr.com/1926/43971897605_a0f87fc8e6.jpg     Hinnat Aikuiset - kertamaksu 5,50 e - 10 kerran sarjakortti tai kk-kortti (30 pv) 44 e - kausikortti (120 pv) 132 e Muut - kertamaksu 3 e - 10 kerran sarjakortti tai kk-kortti (30 pv) 24 e - kausikortti (120 pv) 72 e Lapset (7 - 17v., kuntosali 15-17v.)- kertamaksu 2,50 e - 10 kerran sarjakortti tai kk-kortti (30 pv) 20 e - kausikortti (120 pv) 60 e - henkilökohtainen asiakaskortti (kausi-, kuukausi- ja sarjaliput) 4 e - pyyhe 7 e - uimapuku 7 e- pefletti 1 ePukuhuoneiden kaapit toimivat 50 sentin avainpantilla.Maan alla sijaitseva Itäkeskuksen uimahallissa on tiloja kahdessa kerroksessa, ja sinne mahtuu kerralla noin 1 000 kävijää. Palvelut: Iso allas kooltaan 19 m x 50 m, lämpötila + 27 - 28°C, sopii uintimatkaharjoitteluun, altaassa on allasnostin.Iso allas puolitetaan joka päivä klo 20.00. Altaan syvä pää tällöin on varattu uimaseurojen käyttöön.Opetusallas kooltaan 11 m x 14 m, lämpötila + 30°C . Allas on tarkoitettu yleisöuinnin lisäksi myös ohjattuun ryhmäkäyttöön esim. vesivoimisteluun ja uinninopetukseen. Allasta voi käyttää vapaasti esim. virtuaaliseen vesijumppaan varattujen aikojen ulkopuolella.Lastenallas kooltaan 10,5 m x 12,5 m, lämpötila + 29°C. Kylmävesiallas, lämpötila + 17°C. Poreallas, lämpötila + 33°C.Poreallas on auki klo 6.30 - 20.00. Poreet ovat päällä puoli tuntia kerrallaan. Iso ja pieni vesiliukumäki, hyppytorni jossa 3 m:n ponnahduslauta ja 5 m:n hyppytaso, 6 saunaa ja yksi höyrysauna. Höyrysauna on auki joka päivä 8.00 - 21.00.Hyppytornin aukioloajat:16.30, 17.30, 18.30Muuta: uima-asujen, pyyheliinojen ym. vuokrausta, säilytyskaappeja, perhe- ja vammaisosaston pukeutumistila (kassalta pyydettäessä) (siivoustauko la-su klo 12.30 - 13.30), hierontaa, puh. 09 343 3610, pysäköintialue vieressä, otsonipuhdistus.Kahvilan aukioloajat:ma - su klo 9.00 - 18.00 ChargesAdults - one visit €5.50 - 10 visits or 1 month €44 - season card €132 Others - one visit €3 - 10 visits or 1 month €24 - season card €72Children (7 - 17 years, gym 15-17 years)- one visit €2.50 - 10 visits or 1 month €20 - season card €60- personal customer card (10 visits, 1 month or season card) €4 - towel €7- swimming suit €7- sauna seat cover €1The lockers in the dressing rooms operate with a 50 cent deposit.The facilities of the underground swimming hall in Itäkeskus are spread across two floors, with space for approximately 1,000 visitors at a time.Services: Big pool 50 m x 19 m, temperature + 27°C (+ 28°C), suitable for training, pool lift.The big pool is divided in two every day at 20.00. The deeper end of the pool is reserved.Learner's pool 14 m x 11 m, temperature + 30°C, pool intended for supervised group use such as water gymnastics and swimming classes. However outside the reserved times it can be used by other customers i.e. for virtual water gymnastics. Suitable for handicapped persons.Children's pool 12,5 m x 10,5 m, temperature + 29°C . Cold water pool temperature + 17°C. Jacuzzi, temperature + 33°C.The jacuzzi is open 6.30 - 20.00. The jets are switched on every half hour.Big and small water slide, diving stages 3 metre board and 5 metre platform, 6 saunas, one of them is steam sauna. The steam sauna is open every day 8.00 - 21.00.Diving stages' opening hours:16.30, 17.30, 18.30Other info: massage, tel. 09 343 3610, locker rooms, parking lot, ozone purification, swimming costumes and towels are available to rent for €5, family and disabled section changing area (please ask at the cash desk) (cleaning break Sat-Sun 12.30 - 13.30).Café opening hours:Mon - Sun 9.00 - 18.00   Itäkeskuksen uimahalli Itäkeskus swimming hall Olavinlinnantie 6 Olofsborgsvägen 6 Olavinlinnantie 6         pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 87202         2014-09-05T13:29:49+03:00 00900 www.hel.fi kaikki helsinki 2020-12-21T08:31:18.603833+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 [2218, 2219, 2221, 2226, 693] [898, 897, 896, 895, 729] {} Point 25.076294 60.212757   505825 Itäkeskuksen uimahalli, kuva: Konsta Linkola     Östra centrums simhall Kaupungin hallinnassa on neljä uimahallia. Lisäksi Helsingissä on yhdeksän yhtiöpohjaista uimahallia, joiden toimintaa kaupunki avustaa. 2 3   Östra centrums simhall, foto: Konsta Linkola     1     3 lipas   Helsingfors stad förfogar över fyra simhallar. Därtill finns det i Helsingfors nio simhallar som drivs av bolag och vars verksamhet staden understöder Priser Vuxna - engångsavgift 5,50 e - 10 gångers seriekort eller månadskort 44 e - säsongkort 4 mån. 132 e Andra - engångsavgift 3 e - 10 gångers seriekort eller månadskort 24 e - säsongkort 4 mån. 72 eBarn (7 - 17 år, gym 15-17 år)- engångsavgift 2,50 e - 10 gångers seriekort eller månadskort 20 e - säsongkort 4 mån. 60 e - personell kundkortet (10 gångers seriekort, månadskort och säsongkort) 4 e- handduk 7 e- badkläder 7 e- situnderlag 1 eOmklädningsrums skåp fungerar med en 50 cents nyckelpant.Den underjordiska simhallen togs i bruk 1993. Utrymmena i hallen finns på två plan och rymmer cirka 1 000 besökare åt gången.Tjänster: Stora bassängen 50 x 19 m, (temperatur + 27°C, + 28°C), lämplig för träning, bassänghiss.Stora bassängen delas i hälften varje dag kl. 20.00. Bassängens djup ände är reserverad.Undervisningsbassängen 14 x 11 m, temperatur + 30°C, bassängen är avsedd för grupper med instruktör, t.ex. vattengymnastik eller simskola, lämplig för handikappmotion.Barnbassängen 10,5 x 12,5 m, temperatur + 29°C. Kallvattensbassängen, temperatur + 17°C. Bubbelpool, temperatur + 33°C. Hopptorn, 3 och 5 m.Bubbelpool är öppen kl. 6.30 - 20.00. Bubbelpoolens bubblor är igång i slutet av varje timme 30 minuter.En liten och en stor vattenrutschbana, vattenmassage, 6 bastur och ångbastu. Ångbastun är öppen varje dag kl. 8.00 - 21.00.Hoppturnets öppettider:16.30, 17.30, 18.30Övrigt: omklädningsrums, omklädningsrum på familje- och handikappavdelningen (på begäran vid kassan) (Vi städar lö-sö kl. 12.30 - 13.30), massage, tfn. 09 343 3610, intilliggande parkeringsplats, ozonrening används i bassängerna (utom kallvattensbassängen).Kafe öppettider:må - sö kl. 9.00 - 18.00 4 The City of Helsinki has four swimming halls. There are also nine swimming pools which are run by corporations with support from the City.   Itäkeskus swimming hall, foto: Konsta Linkola

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