1 row where identifiers_2_namespace = "lipas" and short_description_en = "Nudist beach, separate areas for women and men."

View and edit SQL

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
40993 [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lis\u00e4tietoa", "sv": "Mer information", "en": "More information"}, "www": null, "email": null, "phone": "+358 9 310 1691", "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}] [] internal 18111 visithelsinki 1921 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.Ei uinninvalvontaa. Nudistiranta, naisille ja miehille erilliset, aidatut alueet. Uimala on yhteiskäytössä keskiviikkoisin ja sunnuntaisin, jolloin uima-asua on käytettävä. Palvelut: pukusuoja, ulkosuihku, WC. 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. No lifeguard on duty. Nudist beach, separate areas for women and men. The swimming pool is in mixed-sex use on Wednesdays and Sundays, so a bathing suit is mandatory.Services: cabin, toilet, showers.   Seurasaaren uimala Seurasaari baths Seurasaari Fölisön Seurasaari                           2014-09-05T13:29:49+03:00 00250 www.hel.fi kaikki helsinki 2020-11-05T16:32:05.061078+02:00   [1403] helsinki [688] [730] {} Point 24.879047 60.182514   99631       Fölisöns badhus Nudistiranta, naisille ja miehille erilliset, aidatut alueet.                     lipas   Naturistbadstrand, inhägnade områden för kvinnor och män. 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.Ingenbad bevakning. Naturistbadstrand, inhägnade områden för kvinnor och män. Badinrättningen används gemensamt på onsdagar och söndagar, och då är badkläder obligatoriska.Tjänster: dusch, omklädningsrum, WC.   Nudist beach, separate areas for women and men.    

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