unit
2 rows where accessibility_shortcoming_count_visually_impaired = 6 and identifiers_2_namespace = "lipas"
This data as json, CSV (advanced)
Suggested facets: last_modified_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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40559 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 1.6. - 9.8.2020\nklo 10.00 - 18.00", "sv": "Perioden 1.6. - 9.8.2020\nkl 10.00 - 18.00", "en": "Period 1.6. - 9.8.2020\n10.00 - 18.00"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Uimarantakausi alkaa normaalisti 1.6."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "rannan henkil\u00f6kunta", "sv": "strandpersonal", "en": "beach personnel"}, "www": null, "email": null, "phone": "+358 9 310 71462", "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Ulkoliikunta.fi -karttapalvelu", "sv": "Tj\u00e4nsten Utemotionskarta", "en": "The Outdoor Exercise Map"}, "www": {"fi": "https://ulkoliikunta.fi/", "sv": "https://ulkoliikunta.fi/", "en": "https://ulkoliikunta.fi/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/uimarantojen-jarjestyssaannot", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/ordningsstadga-for-badstrander", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-beaches"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 563}, {"value": "false", "variable": 550}, {"value": "true", "variable": 537}, {"value": "true", "variable": 538}, {"value": "true", "variable": 525}, {"value": "smooth", "variable": 543}, {"value": "more_than_200m", "variable": 502}, {"value": "outdoors", "variable": 2}, {"value": "at_least_4_steps", "variable": 512}, {"value": "false", "variable": 551}, {"value": "false", "variable": 522}, {"value": "false", "variable": 560}, {"value": "no_handrails", "variable": 548}, {"value": "false", "variable": 530}, {"value": "true", "variable": 510}, {"value": "false", "variable": 509}, {"value": "false", "variable": 558}, {"value": "true", "variable": 542}, {"value": "not_guided_not_clear", "variable": 504}, {"value": "under_20mm", "variable": 557}, {"value": "true", "variable": 565}, {"value": "true", "variable": 535}, {"value": "true", "variable": 505}, {"value": "false", "variable": 513}, {"value": "outdoor_sport_facility", "variable": 60}, {"value": "cubicle_with_bench", "variable": 571}, {"value": "false", "variable": 529}, {"value": "true", "variable": 533}, {"value": "false", "variable": 516}, {"value": "true", "variable": 566}, {"value": "true", "variable": 527}, {"value": "at_least_3600mm", "variable": 3}, {"value": "flush_toilet_separate", "variable": 536}, {"value": "false", "variable": 564}, {"value": "true", "variable": 511}, {"value": "reachable_by_car", "variable": 501}, {"value": "opens_easily_manually", "variable": 556}, {"value": "3", "variable": 521}, {"value": "no_handrails", "variable": 514}, {"value": "true", "variable": 567}, {"value": "outdoor_facility", "variable": 500}, {"value": "true", "variable": 528}, {"value": "false", "variable": 547}, {"value": "false", "variable": 539}, {"value": "false", "variable": 517}, {"value": "true", "variable": 545}, {"value": "smooth", "variable": 507}, {"value": "sufficiently_wide", "variable": 544}, {"value": "beach", "variable": 61}, {"value": "true", "variable": 534}, {"value": "false", "variable": 568}, {"value": "true", "var… | internal | 18540 | visithelsinki | 1920 | 5647f05f-5c30-43ee-9309-e0c7f75d88c9 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kaupunki valvoo uimarantoja uimakaudella ja ottaa rantojen vedestä vesinäytteitä näytteenottosuunnitelman mukaan. Ulkoliikunta.fi -palvelusta löydät reaaliaikaista tietoa pääkaupunkiseudun uimarantojen kunnosta - sinilevätilanteesta ja veden lämpötilasta.Uinninvalvonta. Palvelut: pukusuoja (suljetaan 17.30), suihku, WC, kuntovälineet, leikkipaikka, kioskivaunu | The City of Helsinki supervises the beaches during the swimming season and takes samples of the beach water in accordance with the sampling plan. In the Outdoor Exercise Map service you can find information on the beaches in the metropolitan area - the algae situation and the water temperature.Lifeguard on duty. Services: cabin (closed 17.30), toilet, shower, weightlifting area, kiosk cart | Mustikkamaan uimaranta | Mustikkamaa beach | Mustikkamaanpolku 2 | Blåbärslandsstigen 2 | Mustikkamaanpolku 2 | 2014-09-05T13:29:49+03:00 | 00570 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:02.365036+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"} | [1403] | helsinki | [689] | [731] | {} | Point | 24.99305 | 60.17906 | 100470 | Blåbärslandets badstrand | Kaupunki valvoo uimarantoja uimakaudella ja ottaa rantojen vedestä vesinäytteitä näytteenottosuunnitelman mukaan. | 8 | 7 | 1 | 7 | lipas | Helsingfors stad övervakar badstränder under säsongen för simning utomhus och tar vattenprover på stränder enligt vattenprovtagningsplanet. | Helsingfors stad övervakar badstränder under säsongen för simning utomhus och tar vattenprover på stränder enligt vattenprovtagningsplanet. I tjänsten Utemotionskarta hittar du information i realtid om badstränderna i huvudstadsregionen - algläget och vattnets temperatur.Badbevakning. Tjänster: omklädningsrum (stängs kl. 17.30), WC, dusch, motionsredskap, kioskvagn | 6 | The City of Helsinki supervises the beaches during the swimming season and takes samples of the beach water in accordance with the sampling plan. | |||||||||||||||||||||||||||||||||||
| 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
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 );