3 rows where accessibility_shortcoming_count_stroller = 1 and identifiers_2_namespace = "lipas"

View and edit SQL

Suggested facets: accessibility_viewpoints, keywords, accessibility_shortcoming_count_wheelchair, accessibility_shortcoming_count_rollator, accessibility_shortcoming_count_visually_impaired, created_time (date), last_modified_time (date)

identifiers_2_namespace

  • lipas · 3

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
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.    
41102 [{"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": "HUOM! Valitettavasti hissiremontin johdosta uimahalliin ei ole esteet\u00f6nt\u00e4 p\u00e4\u00e4sy\u00e4 liikuntarajoitteisille ja muille hissi\u00e4 tarvitseville asiakkaille.", "sv": "OBS! Under hissrenoveringen \u00e4r simhallen tyv\u00e4rr inte tillg\u00e4nglig f\u00f6r personer med fysiska funktionsneds\u00e4ttningar eller andra som beh\u00f6ver anv\u00e4nda hiss.", "en": "NB! Unfortunately, due to an elevator renovation project, the swimming hall is not accessible to persons with reduced mobility or other persons who need to use the elevator."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Sis\u00e4\u00e4np\u00e4\u00e4syajat 31.8.2020 alkaen\n\nNaiset (uintiaika 2 h)\nmaanantaisin \n1. krs 12.00 - 20.00\n2. krs suljettu \nkeskiviikkoisin \n1. krs 6.30 - 20.00\n2. krs 13.00 - 20.00 \nperjantaisin \n1. krs 6.30 - 20.00\n2. krs 13.00 - 20.00 \nsunnuntaisin \n1. krs 11.00 - 20.00\n2. krs 13.00 - 20.00 \nerityisuimakortilla \n1. krs 9.00 - 10.00", "sv": "\u00d6ppettider fr\u00e5n 31.8.2020\n\nDamer (simningstid 2 timmar)\nM\u00e5ndag \n1. v\u00e5n 12.00 - 20.00\n2. v\u00e5n st\u00e4ngd\nOnsdag \n1. v\u00e5n 6.30 - 20.00\n2. v\u00e5n 13.00 - 20.00\nFredag\n1. v\u00e5n 6.30 - 20.00\n2. v\u00e5n 13.00 - 20.00\nS\u00f6ndag\n1. v\u00e5n 11.00 - 20.00\n2. v\u00e5n 13.00 - 20.00\nmed specialsimningskortet\n1. v\u00e5n 9.00 - 10.00", "en": "Entrance hours from 31.8.2020 onwards\n\nWomen (swimming time 2 hrs)\nMonday\n1st floor 12.00 - 20.00 \n2nd floor closed\nWednesday \n1st floor 6.30 - 20.00\n2nd floor 13.00 - 20.00\nFriday \n1st floor 6.30 - 20.00\n2nd floor 13.00 - 20.00\nSunday\n1st fl… [{"value": "true", "variable": 51}, {"value": "true", "variable": 70}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 52}, {"value": "false", "variable": 44}, {"value": "false", "variable": 22}, {"value": "false", "variable": 118}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 117}, {"value": "false", "variable": 116}, {"value": "false", "variable": 112}, {"value": "false", "variable": 98}, {"value": "true", "variable": 113}, {"value": "true", "variable": 114}, {"value": "next_to_door_on_opening_side", "variable": 110}, {"value": "false", "variable": 111}, {"value": "floor_2", "variable": 108}, {"value": "false", "variable": 105}, {"value": "true", "variable": 115}, {"value": "true", "variable": 107}, {"value": "true", "variable": 109}, {"value": "no_handrails", "variable": 95}, {"value": "false", "variable": 97}, {"value": "false", "variable": 38}, {"value": "true", "variable": 94}, {"value": "true", "variable": 92}, {"value": "3_consecutive_steps", "variable": 93}, {"value": "false", "variable": 102}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 79}, {"value": "true", "variable": 80}, {"value": "false", "variable": 83}, {"value": "true", "variable": 78}, {"value": "false", "variable": 104}, {"value": "true", "variable": 76}, {"value": "false", "variable": 84}, {"value": "opens_automatically", "variable": 77}, {"value": "false", "variable": 72}, {"value": "false", "variable": 73}, {"value": "-1", "variable": 63}, {"value": "false", "variable": 48}, {"value": "false", "variable": 62}, {"value": "swimming_hall", "variable": 61}, {"value": "false", "variable": 74}, {"value": "false", "variable": 103}, {"value": "true", "variable": 59}, {"value": "sport_facility", "variable": 60}, {"value": "false", "variable": 75}, {"value": "sufficiently_wide", "variable": 18}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 5}, {"value": "false", "variable": 21}, {"value": "rough", "variable… internal 20744 visithelsinki 262 aea46dd4-caec-4f97-9206-10e939dc6b8d 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1       https://farm2.staticflickr.com/1965/29943632177_4784db2340.jpg     HinnatAikuiset - kertamaksu 5,50 e - 10 kerran sarjakortti tai kk-kortti (30 pv) 44 e- kausikortti (120 pv) 132 eMuut - kertamaksu 3 e- 10 kerran sarjakortti tai kk-kortti (30 pv) 24 e- kausikortti (120 pv) 72 eLapset- 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- kylpytakki 10 e- pefletti, saippua, shampoo 1 e/kpl- istumahyttilisä 1 e2. krs (uinti 1. kerroksen altaassa)Aikuiset- kertamaksu 16 eMuut - kertamaksu 11 eLapset- kertamaksu 8 eLisätunti - 9 e per tuntiSisältää: lepohytti, pyyhe, kylpytakki (saatavuuden mukaan), pefletti, uinti, höyrysauna, puulämmitteinen sauna ja infrapunasauna.Uimahalli vihittiin käyttöön 4.6.1928. Se oli vuosikymmeniä Suomen ainoa julkisessa käytössä ollut uimahalli. Uinti hallissa tapahtuu erikseen naisten ja miesten vuoroilla uima-asussa tai ilman. 7-vuotiaiden ja sitä vanhempien tulee vierailla oman sukupuolensa mukaisilla uintivuoroilla.Hallissa on yksi 25 metriä pitkä allas, syvyys 0,9 - 3,4 m. Uimataito pakollinen.Kaikkina aukioloaikoina työvuorossa saattaa olla sekä nais- että miespuolista henkilökuntaa. 23.11. alkaen uimahallin kävijämäärää rajoitetaan ja pukukaapeista puolet suljetaan.Palvelut: Cafe Yrjö, puh. 09 677 318ti - su 14.00 - 20.00Kokoushuone:20 henkilölle ma - su klo 8.00 - 21.00Käytössä kahvinkeitin, vedenkeitin, mikro ja jääkaappi.Cafe Yrjön palvelut käytettävissä.Vain kokouskäyttöön.Saunat: 1. krs: kaksi sähkösaunaa2. krs: puulämmitteinen sauna, höyrysauna, infrapunasauna ja tilaussauna4. krs: tilaussaunaMuuta:Forumin parkkihalli, otsonipuhdistus PricesAdults - one visit €5.50 - 10 visits or 1 month €44 - season card (120 days) €132 Others - one visit €3 - 10 visits or 1 month €24 - season card €72Children- 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- seat cover, shampoo €1/each- cabins, per visit + €12nd floor cabins (swimming in 1st floor pool) Adults - one visit €16Others - one visit €11Children- one visit €8Extra hour- €9 per hourIncludes: cabin with bed, towel, bathrobe (subject to availability), seat cover, swimming, steam sauna, infrared sauna, wood-heated saunaThe swimming hall was inaugurated on 4 June 1928 For decades it was Finland's only public swimming hall. There are separate swimming sessions for men and women, with bathers having the choice of wearing a swimming costume or not.Children who are under the age of seven can visit on both men and women's days. However, please note that the swimming hall only has one 25 metre pool (depth 0,9 - 3,4m) and thus everyone using the pool must be able to swim.Please note that our staff may consist of both men and women during all opening hours.Starting on November 23rd, the number of customers at the swimming hall will be reduced, and half of the changing room lockers will be made off-limits.Services: Cafe Yrjö, tel. 09 677 318Tue - Sun 14.00 - 20.00Meeting room:for 20 persons Mon - Sun 8.00 - 21.00Coffee maker, kettle, microwave and fridgeCafe Yrjö's services are available.Only for meeting use. Saunas:1st floor: two electric saunas2nd floor: infrared sauna, wood-heated sauna, steam sauna, private sauna4th floor: private sauna. Other info:Forum's parking hall, Ozone purification.   Yrjönkadun uimahalli Yrjönkatu swimming hall Yrjönkatu 21 b Georgsgatan 21 b Yrjönkatu 21 b         pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 87401         2014-09-05T13:29:49+03:00 00100 www.hel.fi kaikki helsinki 2020-12-16T09:01:33.931734+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 [2168, 749, 2218, 2219, 2221, 2226, 693] [898, 897, 896, 895, 864, 729, 473] {} Point 24.93896 60.16835   506031 Yrjönkadun uimahalli, kuva: Helsingin kaupunki     Georgsgatans simhall Kaupungin hallinnassa on neljä uimahallia. Lisäksi Helsingissä on yhdeksän yhtiöpohjaista uimahallia, joiden toimintaa kaupunki avustaa. 5 10   Georgsgatans simhall, foto: Helsingfors stad 1   1     10 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 1. våningen skåpVuxna - engångsavgift 5,50 e- 10 gångers seriekort eller månadskort 44 e- säsongkort (120 dagar) 132 eAndra - engångsavgift 3 e- 10 gångers seriekort eller månadskort 24 e- säsongkort (120 dagar) 72 eBarn (7 - 17 år)- engångsavgift 2,50 e- 10 gångers seriekort eller månadskort 20 e- säsongkort (120 dagar) 60 e- personligt kundkort (10 gångers seriekort, månadskort och säsongkort) 4 e- handduk 7 e- badkläder 7 e- hytt plus 1 e2. våningen Vuxna - engångsavgift 16 eAndra- engångsavgift 11 eBarn (7 - 17 år)- engångsavgift 8 eExtratimme- 9 e per timmeHytt, hyra för badrock (i mån av möjlighet) och badhandduk och sittunderlag samt tillgång till ång-, infraröd- och vedbastun ingår i priset.Simhallen invigdes den 4 juni 1928. I flera årtionden var simhallen den enda som var öppen för allmänheten i Finland. Badtiderna i simhallen är uppdelade i separata turer för damer och herrar som kan bada med eller utan baddräkt. Barn från och med åldern 7 ska inte vistas i simhallen på det motsatta könets simtur.I hallen finns en 25 meter lång bassäng, djupet 0,9 - 3,4m. Observera att alla som använder simbassängen måste vara simkunniga.På alla öppettider kan personalen bestå av både kvinnor och män.Från och med 23.11 begränsas antalet besökare i simhallen och samtidigt stängs hälften av klädskåpen.Tjänster: Cafe Yrjö, tfn. 09 677 318ti - sö 14.00 - 20.00Mötesrum:må - sö kl. 8.00 - 21.00 för 20 personerKaffekokare, vattenkokare, mikrovågsugn och kylskåp.Café Yrjös tjänster finns tillgängliga.Endast för möten.Bastur:1. våningen: två elbastur2. våningen: infraröd bastu, vedeldad bastu, ångbastu och beställningsbastu4. våningen: beställningsbastuÖvrigt:Forums parkeringshall, ozonrening 8 The City of Helsinki has four swimming halls. There are also nine swimming pools which are run by corporations with support from the City.   Yrjönkatu swimming hall, foto: City of Helsinki

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