1 row where identifiers_2_namespace = "lipas" and short_description_en = "In Helsinki is two outdoor swimming pools; Helsinki Swimming Stadium and the Kumpula Outdoor Swimming Pool."

View and edit SQL

Suggested facets: created_time (date), last_modified_time (date)

short_description_en

  • In Helsinki is two outdoor swimming pools; Helsinki Swimming Stadium and the Kumpula Outdoor Swimming Pool. · 1

identifiers_2_namespace

  • lipas · 1

accessibility_shortcoming_count_stroller

  • 1 1
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
41047 [{"section_type": "OPENING_HOURS", "name": {"fi": "SULJETTU\n\nKiitos kes\u00e4st\u00e4 2020!", "sv": "ST\u00c4NGD\n\nTack f\u00f6r sommaren 2020!", "en": "CLOSED\n\nThank you for the summer 2020!"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Poikkeusaukioloajat -", "sv": "Avvikande \u00f6ppettider -", "en": "Exceptional opening hours -"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Sis\u00e4\u00e4np\u00e4\u00e4syajat \n\n1.6. - 13.9.2020\n\nma - la 6.30 - 20.00 \nsu 9.00 - 20.00 \n\nKassa suljetaan ja sis\u00e4\u00e4np\u00e4\u00e4syaika p\u00e4\u00e4ttyy klo 20, uintiaika p\u00e4\u00e4ttyy klo 20.30 ja peseytymisaika klo 20.45. \nAlueelta on poistuttava klo 21.00 menness\u00e4.", "sv": "Intr\u00e4destider \n\n1.6 - 13.9.2020\n\nm\u00e5 - l\u00f6 6.30 - 20.00 \ns\u00f6 9.00 - 20.00 \n\nKassan st\u00e4ngs och intr\u00e4destid \u00e4nds klockan 20.00.\nBass\u00e4ngen \u00e4r \u00f6ppen till klockan 20.30 och duschutrymmena till klockan 20.45. \nMan m\u00e5ste l\u00e4mna omr\u00e5det klockan 21.00.", "en": "Entrance hours \n\n1.6. - 13.9.2020\n\nMon - Sat 6.30 - 20.00 \nSun 9.00 - 20.00 \n\nCashier closes and entry time ends at 20.00, swimming time ends at 20.30, and washing time at 20.45. \nCustomers must leave the area by 21.00."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "- Noudata turvav\u00e4lej\u00e4 ja hyv\u00e4\u00e4 hygieniaa\n- Ei varattuja vuoroja\n- Jonotus turvav\u00e4lein", "sv": "- F\u00f6lj s\u00e4kerhetsavst\u00e5nden och bra hygien\n- Inga reserverade turer\n- H\u00e5ll s\u00e4kerhetsavst\u00e5nd d\u00e5 du k\u00f6ar", "en": "- Please keep your distance to other customers and practice good hygiene\n- Maintain a safe distance from others while queueing"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "kassa"… [{"value": "true", "variable": 20}, {"value": "true", "variable": 37}, {"value": "true", "variable": 72}, {"value": "false", "variable": 73}, {"value": "1", "variable": 63}, {"value": "false", "variable": 62}, {"value": "false", "variable": 92}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 102}, {"value": "false", "variable": 98}, {"value": "true", "variable": 103}, {"value": "false", "variable": 104}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 105}, {"value": "false", "variable": 107}, {"value": "false", "variable": 83}, {"value": "false", "variable": 84}, {"value": "true", "variable": 80}, {"value": "false", "variable": 48}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 57}, {"value": "false", "variable": 38}, {"value": "false", "variable": 44}, {"value": "false", "variable": 49}, {"value": "false", "variable": 34}, {"value": "true", "variable": 50}, {"value": "false", "variable": 33}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 22}, {"value": "true", "variable": 21}, {"value": "false", "variable": 23}, {"value": "true", "variable": 51}, {"value": "false", "variable": 29}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "at_least_3600mm", "variable": 3}, {"value": "over_10m", "variable": 4}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 5}, {"value": "3", "variable": 1}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 52}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 79}, {"value": "false", "variable": 53}, {"value": "over_20mm", "variable": 56}, {"value": "opens_easily_manually", "variable": 77}, {"value": "false", "variable": 78}, {"value": "false", "variable": 58}, {"value": "true", "variable": 59}, {"value": "false", "variable": 76}, {"value": "false", "variable": 75}, {"value": "true", "variable": 70}, {"value": "sport_facility", "variable": 60}, {"value": "outdoor_… internal 18832 visithelsinki 310 13ae764e-0ccc-4125-8d1c-0ef1e50bed35 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1             HinnatAikuiset - kertamaksu 5 e - 10 krt 40 e- 1 kuukausi (30 päivää) 40 e Muut - kertamaksu 3 e - 10 krt 24 e- 1 kuukausi (30 päivää) 24 e Lapset (7 - 17v.)- kertamaksu 2,50 e - 10 krt 20 e- 1 kuukausi (30 päivää) 20 e Sotaveteraanit, lapset alle 7v.- maksuton sisäänpääsy- Henkilökohtainen asiakaskortti (sarjakortti) 4 e - Pyyhe 7 e - Uimapuku 7 e- Istuinalusta / saippua 1 ePukeutumistiloissa lukolliset kaapit. Varaa 50 sentin kolikko avainpantiksi. Huom! Emme anna tietoa löytötavaroista puhelimitse. Tavaroita voi tulla kysymään paikan päältä.Palvelut:Vesiliukumäki Vesiliukumäkilippu 5 eLiukumäki avoinna 1.7. - 23.8. kl 12.00 - 18.00Vesiliukumäen käyttäjän on oltava uimataitoinen. Päärakennuksessa saunat, aurinkokatsomo, kokoustilat noin 20 hengelleIso allas 50 m, lastenallas, kahluuallas,- hyppyallas, hyppytelineet 1, 3, 5, 7,5 ja 10 m, ponnahduslaudat 2 x 1 m, 3 mHyppytorni on avoinna pääsääntöisesti säännöllisin väliajoin kello 12.00 - 18.00 välisenä aikana.Räpylöiden ja snorkkelien käyttö on kielletty.Leikkialue, voimailupaikka, 2 beachvolleykenttää, koripallokenttäKioski avoinna päivittäin puh. 050 524 3493 Kahvila avoinna koulujen loma-aikana joka päivä 10-16 (säävarauksella pidempään) puh. 050 598 8185Muuta: Puhdistusmenetelmänä toimii hiekkasuodatinpuhdistus (kloori)Shortseissa uinti kielletty - lukuun ottamatta uintishortseja.Valokuvaukseen tarvitaan liikuntapaikat-palvelun kuvauslupa.Helsingissä on kaksi maauimalaa; Uimastadion ja Kumpulan maauimala.Arkkitehti Jorma Järven suunnittelema uimastadion rakennettiin 1940 olympiakisoja varten, jotka sodan vuoksi jouduttiin perumaan. Kilpa-areenana se toimi Helsingin vuoden 1952 olympialaisissa. ChargesAdults - one visit €5 - 10 visits €40- 1 month (30 days) €40 Others - one visit €3 - 10 visits €24- 1 month (30 days) €24 Children (7 - 17 y/o)- one visit €2,50 - 10 visits €20- 1 month (30 days) €20War veterans, children under 7- free of charge- Personal customer card (serial cards) €4 - Swimming costume €7 - Towel €7 - Seat cover / soap €1Lockers are available in the changing rooms. Make sure you have a 50 cent coin as a key deposit.Please note that we do not provide information about lost and found items over the phone. You can enquire for your items by visiting the Swimming Stadium.Services: Water slide Open 1.7. - 23.8. 12.00 - 18.00Ticket €5Water slide user must be able to swim.50-metre pool, children's pool, wading pool, diving pool, diving stands: 1, 3, 5, 7,5 and 10 m, spring boards: 2 x 1 m, 3 m.The jump tower is opened regularly between 12.00 - 18.00.The use of fins and snorkels is prohibited.Children's play area, outdoor gym area, 2 beachvolley fields, basketball fieldThe kiosk is open every day tel 050 524 3493The café is open during the school holiday season 10.00 - 16.00 (or longer; weather permitting) tel 050 598 8185Main building: saunas, sundeck stands, meeting facilities for approximately 20 peopleOther info: Sand filter cleaning is used as the cleaning method (chlorine) Note! Swimming in shorts is forbidden - with the exception of swimming trunks.A photography permit from the Sports Facilities Section is required for photography.There are two outdoor swimming pools in Helsinki; Helsinki Swimming Stadium and the Kumpula Outdoor Swimming Pool.Designed by architect Jorma Järvi, the Swimming Stadium was built for the 1940 Olympic Games, which - due to the outbreak of war - were cancelled. It later went on to host part of the 1952 Helsinki Olympic Games.   Uimastadion / Maauimala Swimming Stadium Hammarskjöldintie 5 Hammarskjöldsvägen 5 Hammarskjöldintie 5                           2014-09-05T13:29:49+03:00 00250 www.hel.fi kaikki helsinki 2020-11-05T16:32:05.346986+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1403] helsinki [686] [426] {"fi": ["stadikka", "stadika", "uimastadika", "uimastadikka"]} Point 24.930822 60.188812   98185       Simstadion / Friluftsbad Helsingissä on kaksi maauimalaa; Uimastadion ja Kumpulan maauimala. 3 7     1   1     7 lipas   I Helsingfors är två friluftsbad; Simstadion och Gumtäkts friluftsbad. Priser Vuxna - engångsavgift 5 e - 10 gångers seriekort 40 e - 1 månad (30 dagar) 40 e Andra- engångsavgift 3 e - 10 gångers seriekort 24 e- 1 månad (30 dagar) 24 e Barn (7 - 17 år)- engångsavgift 2,50 e - 10 gångers 20 e- 1 månad (30 dagar) 20 e Personell kundkortet (seriekorten) 4 eSkåpen i omklädningsrummen kan låsas. Ta med dig ett 50 cents mynt som pant.Obs! Vi ger inte information om hittegods per telefon. Ni kan fråga efter hittegods på plats.Tjänster: Stora bassängen 50 m, barnbassäng, plaskdamm, hoppbassäng, hopptorn 5m, 7,5m och 10 m, språngbrädor 2 x 1 m, 3 mHopptornet öppnas med jämna mellanrum mellan kl 12.00 - 18.00.Användning av fenor och snorkel är förbjudet.LekområdeVattenrutschbana Öppen 1.7 - 23.8 kl 12.00 - 18.00Avgift 5 eStyrketräningområde, beachvolleyplan x 2, basketbollsplanHuvudbyggnaden: bastur, solläktare, möteslokal för cirka 20 personer.Kiosken är öppen alla dagar tfn. 050 524 3493Kaféet med väderreservation tfn. 050 598 8185 Övrigt: Rening med sandfilter (klor)Obs! Förbjudet att simma med andra shorts än badshorts.För fotografering behövs tillstånd av avdelningen för idrottsanläggningar.I Helsingfors är två friluftsbad; Simstadion och Gumtäkts friluftsbad.Simstadion, som planerades av arkitekt Jorma Järvi, byggdes inför de olympiska spelen 1940. På grund av kriget var man tvungen att inhibera OS. Den fungerade dock som tävlingsarena under OS i Helsingfors 1952. 6 In Helsinki is two outdoor swimming pools; Helsinki Swimming Stadium and the Kumpula Outdoor Swimming Pool.    

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