unit
1 row where identifiers_2_namespace = "lipas" and short_description_en = "Helsinki has two outdoor swimming pools; Helsinki Swimming Stadium and the Kumpula Outdoor Swimming Pool."
This data as json, CSV (advanced)
Suggested facets: last_modified_time (date)
short_description_en ✖
- Helsinki has two outdoor swimming pools; Helsinki Swimming Stadium and the Kumpula Outdoor Swimming Pool. · 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40823 | [{"section_type": "OPENING_HOURS", "name": {"fi": "SULJETTU", "sv": "ST\u00c4NGD", "en": "CLOSED"}, "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": "- Noudata turvav\u00e4lej\u00e4 ja hyv\u00e4\u00e4 hygieniaa\n- Ei varattuja vuoroja\n- Jonotus turvav\u00e4lein. Ei ohituksia.", "sv": "- F\u00f6lj s\u00e4kerhetsavst\u00e5nden och bra hygien\n- Inga reserverade turer\n- H\u00e5ll s\u00e4kerhetsavst\u00e5nd d\u00e5 du k\u00f6ar, passera inte andra personer i k\u00f6", "en": "- Please keep your distance to other customers and practice good hygiene\n- Everybody must queue while remaining at a safe distance from others"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Sis\u00e4\u00e4np\u00e4\u00e4syajat \n\n1.6. - 23.8.2020\n\nma - la 6.30 - 20.00 \nsu 9.00 - 20.00\n\nKassa suljetaan klo 20, uintiaika p\u00e4\u00e4ttyy klo 20.30 ja peseytymisaika klo 20.45. Alueelta on poistuttava klo 21.00\n\nHyppytornit (5m, 7m, 10m) avoinna \nklo 12.15-12.35\nklo 14.00-14.20\nklo 16.00-16.20\nklo 18.00-18.20\n\nPonnahduslaudat (1m, 3m) auki klo 10.00 alkaen.", "sv": "Intr\u00e4destider\n\n1.6. - 23.8.2020\n\nm\u00e5 - l\u00f6 6.30 - 20.00 \ns\u00f6 9.00 - 20.00 \n\nKassan st\u00e4ngs klockan 20.00. Bass\u00e4ngen \u00e4r \u00f6ppen till klockan 20.30 och duschutrymmena till klockan 20.45. Man m\u00e5ste l\u00e4mna omr\u00e5det klockan 21.00.", "en": "Entrance hours\n\n1.6. - 23.8.2020\n\nMon - Sat 6.30 - 20.00 \nSun 9.00 - 20.00 \n\nCash desks close at 20.00, swimming time ends at 20.30, and washing time at 20.45. Customers must leave the area by 21.00."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "kassa", "… | [{"value": "false", "variable": 48}, {"value": "false", "variable": 116}, {"value": "true", "variable": 117}, {"value": "false", "variable": 98}, {"value": "false", "variable": 105}, {"value": "true", "variable": 107}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "true", "variable": 104}, {"value": "false", "variable": 102}, {"value": "false", "variable": 103}, {"value": "true", "variable": 109}, {"value": "false", "variable": 83}, {"value": "false", "variable": 84}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 80}, {"value": "false", "variable": 79}, {"value": "on_door", "variable": 110}, {"value": "false", "variable": 92}, {"value": "true", "variable": 59}, {"value": "over_20mm", "variable": 56}, {"value": "sport_facility", "variable": 60}, {"value": "true", "variable": 50}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 51}, {"value": "false", "variable": 52}, {"value": "outdoor_swimming_pool", "variable": 61}, {"value": "false", "variable": 111}, {"value": "handrails_on_one_side", "variable": 47}, {"value": "true", "variable": 62}, {"value": "true", "variable": 37}, {"value": "false", "variable": 112}, {"value": "false", "variable": 57}, {"value": "false", "variable": 49}, {"value": "no_handrails", "variable": 41}, {"value": "false", "variable": 43}, {"value": "at_least_4_steps", "variable": 39}, {"value": "false", "variable": 34}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "true", "variable": 38}, {"value": "false", "variable": 33}, {"value": "true", "variable": 44}, {"value": "true", "variable": 29}, {"value": "ramp_over_6m_long_with_intermediate_landing", "variable": 30}, {"value": "true", "variable": 31}, {"value": "false", "variable": 28}, {"value": "false", "variable": 27}, {"value": "ramp_over_6m_long_with_intermediate_landing", "variable": 45}, {"value": "handrails_on_one_side", "variable": 26}, {"value": "true", "variable": 25}, {"value": "handrails_on_one_side", "variable": 32}, {"value": "true",… | internal | 18422 | visithelsinki | 412 | aea46dd4-caec-4f97-9206-10e939dc6b8d | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | HinnatAikuiset - kertamaksu 5 e - 10 krt / kuukausikortti 40 eMuut - kertamaksu 3 e- 10 krt / kuukausi 24 e Lapset- kertamaksu 2,50 e- 10 krt / kuukausi 20 e Sotaveteraanit, lapset alle 7v.: maksuton sisäänpääsy.- Henkilökohtainen asiakaskortti (sarjalippu) 4 e - Pyyhe 7 e - Uimapuku 7 e- Istuinalusta / saippua 1 ePukeutumistiloissa lukolliset kaapit. Varaa 50 sentin kolikko avainpantiksi.Palvelut: Pesutilat, saunat, katsomo/aurinkotasanne 25 m allas, lastenallas, kahluuallas, hyppyallas, hyppytelineet 1, 3, 5, 7,5 ja 10 m. Koripallokenttä, beach volley-kenttä, leikkialueHuom! Liikuntarajoitteisten allashissi epäkunnossa!Kahvilaavoinna ma-la klo 8-18su klo 10-18puh. 050 320 9801PysäköintialueMuuta: Puhdistusmenetelmänä toimii hiekkasuodatinpuhdistus (kloori)Huom! shortseissa uinti kielletty - lukuun ottamatta uintishortseja.Kumpulan maauimalan alueella ei ole ulkokuntosalia.Valokuvaukseen tarvitaan liikuntalaitososaston kuvauslupa. | ChargesAdults - one visit €5- 10 visits / 1 month €40 Others - one visit €3 - 10 visits / 1 month €24 Children- one visit €2,50 - 10 visits / 1 month €20War veterans, children (under 7): free of charge.- Personal customer card (10 visits) €4- costume €7 - Towel €7 - Seatcover / soap €1Services: Dressing rooms, showers, saunas, stands and sun plateau25-metre pool, children's pool, wading pool, diving pool, stands: 1, 3, 5, 7,5 and 10 m.Basketball court, volleyball court, children's play areaPlease note that the pool lift for the handicapped is out of order!Café open on Mon - Sat 8-18on Sun 10-18tel. 050 320 9801Parking lotOther info: Sand filter cleaning is used as the cleaning method (chlorine)note! Swimming in shorts is forbidden - with the exception of swimming trunks.There is no outdoor gym inside the Kumpula outdoor swimming pool area.A photography permit from the Sports Facilities Section is required for photography. | Kumpulan maauimala | Kumpula outdoor swimming pool | Allastie 1 | Bassängvägen 1 | Allastie 1 | 2014-09-05T13:29:49+03:00 | 00560 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:04.031087+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [1403] | helsinki | [686] | [426] | {} | Point | 24.958284 | 60.208702 | 98177 | Gumtäkts friluftsbad | Helsingissä on kaksi maauimalaa; Uimastadion ja Kumpulan maauimala. | 2 | 8 | 1 | 8 | lipas | I Helsingfors finns det två friluftsbad; Simstadion och Gumtäkts friluftsbad. | Priser Vuxna - engångsavgift 5 e - 10 gångers seriekort / 1 månad 40 e Andra- engångsavgift 3 e- 10 gångers seriekort / 1 månad 24 e Barn (7 - 17 år)- engångsavgift 2,50 e- 10 gångers seriekort / 1 månad 20 e Personell kundkortet (seriekort) 4 eTjänster: Omklädningsrum, duschrum, bastur, läktare/solterrass 25 m bassäng, barnbassäng, grund bassäng, hoppbassäng 1, 3, 5, 7,5 och 10 mBasketbollsplan, beach volleyplan, lekområdeObs! Bassänghissen för funktionshindrade är ur bruk!Kaféöppet må - lö 8-18sö 10-18tfn. 050 320 9801ParkeringsplatsÖvrigt: Rening med sandfilter (klor)Obs! Förbjudet att simma med andra shorts än badshorts.Inget utegym finns på friluftsbadets område.För fotografering behövs tillstånd av avdelningen för idrottsanläggningar. | 5 | Helsinki has two outdoor swimming pools; Helsinki Swimming Stadium and the Kumpula Outdoor Swimming Pool. |
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 );