unit
1 row where accessibility_shortcoming_count_wheelchair = 3 and identifiers_2_namespace = "lipas"
This data as json, CSV (advanced)
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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
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 );