unit
2 rows where accessibility_shortcoming_count_visually_impaired = 8 and "last_modified_time" is on date 2020-12-16
This data as json, CSV (advanced)
data_source ✖
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||||||||||||||||||||||
| 43417 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 08-16", "sv": "\u00f6ppet m\u00e5n-fre 08-16", "en": "open Mon-Fri 08-16"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "COVID-19: Koronatilanteen vuoksi voit asioida terveysasemalla vain ajanvarauksella p. 009 839 35928. Koronaneuvontapuhelin palvelee arkisin klo 8-18 ja viikonloppuisin klo 9-18 numerossa 09 839 50070."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4ivystysapu (Terveysneuvonta virka-ajan ulkopuolella)"}, "www": null, "email": null, "phone": "116 117", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Koronaviruksen neuvontanumero vantaalaisille"}, "www": null, "email": null, "phone": "+358 9 8395 0070", "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://asiointi.vantaa.fi/anna-palautetta"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 44}, {"value": "true", "variable": 57}, {"value": "true", "variable": 117}, {"value": "false", "variable": 48}, {"value": "true", "variable": 107}, {"value": "false", "variable": 53}, {"value": "true", "variable": 5}, {"value": "false", "variable": 34}, {"value": "2", "variable": 63}, {"value": "false", "variable": 84}, {"value": "true", "variable": 72}, {"value": "false", "variable": 111}, {"value": "true", "variable": 29}, {"value": "false", "variable": 59}, {"value": "true", "variable": 31}, {"value": "2", "variable": 1}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 105}, {"value": "true", "variable": 73}, {"value": "true", "variable": 6}, {"value": "false", "variable": 104}, {"value": "true", "variable": 109}, {"value": "true", "variable": 80}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 103}, {"value": "on_door", "variable": 110}, {"value": "false", "variable": 28}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 50}, {"value": "true", "variable": 25}, {"value": "true", "variable": 70}, {"value": "true", "variable": 74}, {"value": "false", "variable": 21}, {"value": "false", "variable": 33}, {"value": "false", "variable": 102}, {"value": "over_10m", "variable": 4}, {"value": "false", "variable": 92}, {"value": "ramp_over_6m_long_with_intermediate_landing", "variable": 30}, {"value": "true", "variable": 75}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 27}, {"value": "handrails_on_one_side", "variable": 26}, {"value": "at_least_4_turning_steps", "variable": 24}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 76}, {"value": "at_least_3600mm", "variable": 3}, {"value": "true", "variable": 118}, {"value": "true", "variable": 35}, {"value": "is_heavy", "variable": 77}, {"value": "true", "variable": 23}, {"value": "false", "variable": 116}, {"value": "true", "variable": 1… | internal | 18982 | 4738c8e5-8bab-40c2-865d-5b28e64d7591 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hakunilan sosiaali- ja terveysasema | Hakunila Health Centre | Laukkarinne 4 | Galoppbrinken 4 | Laukkarinne 4 | http://www.vantaa.fi/terveys-_ja_sosiaalipalvelut/terveyspalvelut/terveysasemat/hakunilan_terveysasema | http://www.vanda.fi/halsovard_och_sociala_tjanster/halsovardstjanster/halsostationer/hakansbole_halsostation | http://www.vantaa.fi/en/social_and_health_care_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8393 5928 | +358 9 8393 0140 | etunimi.sukunimi@vantaa.fi | +358 9 8393 0048 | hilppa.skoonila@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01200 | www.vantaa.fi | kaikki | vantaa | 2020-12-16T14:01:51.233179+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"} | [986] | vantaa | [990, 992, 1035, 993, 991] | [703, 702, 462, 417, 57] | {"en": ["health care center", "emergency", "doctor's appointment", "nurse's appointment", "public health nurse's appointment"], "fi": ["terveyskeskus", "p\u00e4ivystys", "depressiohoitaja", "p\u00e4iv\u00e4poliklinikka", "verenpaineen itsemittaus", "sairaanhoitajan vastaanotto", "terveydenhoitajan vastaanotto", "psykiatrinen sairaanhoitaja", "l\u00e4\u00e4k\u00e4rin vastaanotto", "fysioterapian suoravastaanotto"], "sv": ["h\u00e4lsostation", "dejourering", "dagpoliklinik", "h\u00e4lsov\u00e5rdare", "l\u00e4kar mottagning", "sjuksk\u00f6tare mottagning"]} | Point | 25.105133 | 60.27851 | Laukkarinne 4, 01200 Vantaa | Håkansböle hälsostation | Sosiaali- ja terveysasema | 2 | 3 | 1 | 1 | 3 | social och hälsostation | 8 | social and health centre |
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 );