unit
3 rows where accessibility_shortcoming_count_visually_impaired = 4 and data_source = "www.kauniainen.fi"
This data as json, CSV (advanced)
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14418 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://www.kauniainen.fi/kaupunki_ja_paatoksenteko/osallistu_ja_vaikuta"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Esiopetukseen hakeminen", "sv": "F\u00f6rskoleans\u00f6kan"}, "www": {"fi": "http://www.kauniainen.fi/kaupunki_ja_paatoksenteko/ajankohtaista/lomakkeet/k_-_o", "sv": "http://www.kauniainen.fi/sv/staden_och_beslutsfattande/aktuellt/blanketter/a-_j"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 34}, {"value": "true", "variable": 52}, {"value": "1_step", "variable": 39}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 37}, {"value": "false", "variable": 79}, {"value": "true", "variable": 105}, {"value": "true", "variable": 5}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 51}, {"value": "at_least_3600mm", "variable": 3}, {"value": "no_handrails", "variable": 47}, {"value": "false", "variable": 49}, {"value": "false", "variable": 107}, {"value": "false", "variable": 23}, {"value": "false", "variable": 102}, {"value": "true", "variable": 104}, {"value": "false", "variable": 21}, {"value": "false", "variable": 53}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 106}, {"value": "over_10m", "variable": 4}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 98}, {"value": "true", "variable": 6}, {"value": "true", "variable": 38}, {"value": "indoor_facility", "variable": 500}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 92}, {"value": "true", "variable": 22}, {"value": "false", "variable": 50}, {"value": "false", "variable": 33}, {"value": "false", "variable": 48}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 29}, {"value": "smooth", "variable": 17}, {"value": "1", "variable": 1}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 59}, {"value": "false", "variable": 46}, {"value": "true", "variable": 57}, {"value": "true", "variable": 44}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "true", "variable": 58}, {"value": "false", "variable": 84}, {"value": "false", "variable": 83}, {"value": "false", "variable": 103}, {"value": "false", "variable": 20}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 62}] | internal | 4376 | 8ba2f57e-0e4d-4050-b3ec-82f4dfc6c70c | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Pidämme tärkeänä hyvää, tasapainoista ja lapsilähtöistä arkea. Kiireetön ja säännöllinen päivärytmi mahdollistaa arjessa kasvun, kehityksen ja oppimisen. Lapsi voi oppia samanaikaisesti monia asioita usealta eri osa-alueelta. Toimintaa eriytetään pienryhmiin lasten ikä- ja kehitystaso huomioiden, sekä lasten omien kiinnostusten mukaan. Lapsen ohjatulla ja vapaalla leikillä on arjen toiminnassamme suuri merkitys. Lasten leikkejä ja mielikuvitusta tuetaan ja leikille annetaan aikaa, tilaa ja mahdollisuuksia. | Metsämajan päiväkoti | Asematie 24 | Stationsvägen 24 | Asematie 24 | http://www.kauniainen.fi/koulutus_ja_varhaiskasvatus/varhaiskasvatus/paivakodit/metsamajan_paivakoti | http://www.kauniainen.fi/koulutus_ja_varhaiskasvatus/varhaiskasvatus/paivakodit/metsamajan_paivakoti | http://www.kauniainen.fi/koulutus_ja_varhaiskasvatus/varhaiskasvatus/paivakodit/metsamajan_paivakoti | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 375 2448 | metsamaja@kauniainen.fi | 2014-03-26T16:39:26+02:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-10-05T10:00:57.165095+03: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"} | [1405] | kauniainen | [871, 870] | [663] | {"sv": ["dagv\u00e5rd", "dagis"], "fi": ["lastenhoito", "p\u00e4iv\u00e4hoito", "eskari", "tarha", "lastentarha"]} | Point | 24.7116 | 60.215397 | PL 52, 02700 Kauniainen | Metsämajan päiväkoti | suomenkielinen, ryhmä 1-3-vuotiaille ja ryhmä 4-6-vuotiaille, n. 27 paikkaa | 2 | 5 | 1 | P.O. Box 52, 02700 Kauniainen | 1 | 4 | PB 52, 02700 Grankulla | finskspråkigt daghem, två grupper; 1-3-åringar och 4-6-åringar, ca. 27 platser | 4 | |||||||||||||||||||||||||||||||
| 14434 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://www.kauniainen.fi/kaupunki_ja_paatoksenteko/osallistu_ja_vaikuta"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 109}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 83}, {"value": "true", "variable": 104}, {"value": "true", "variable": 75}, {"value": "false", "variable": 92}, {"value": "false", "variable": 62}, {"value": "true", "variable": 107}, {"value": "floor_0", "variable": 108}, {"value": "false", "variable": 116}, {"value": "2", "variable": 1}, {"value": "true", "variable": 51}, {"value": "true", "variable": 74}, {"value": "true", "variable": 52}, {"value": "guided_and_clear", "variable": 19}, {"value": "true", "variable": 76}, {"value": "true", "variable": 37}, {"value": "false", "variable": 49}, {"value": "true", "variable": 105}, {"value": "true", "variable": 5}, {"value": "opens_easily_manually", "variable": 54}, {"value": "0", "variable": 63}, {"value": "false", "variable": 53}, {"value": "false", "variable": 102}, {"value": "false", "variable": 106}, {"value": "false", "variable": 21}, {"value": "true", "variable": 80}, {"value": "false", "variable": 38}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 112}, {"value": "false", "variable": 44}, {"value": "false", "variable": 57}, {"value": "opens_automatically", "variable": 77}, {"value": "false", "variable": 22}, {"value": "true", "variable": 115}, {"value": "false", "variable": 98}, {"value": "true", "variable": 78}, {"value": "true", "variable": 114}, {"value": "false", "variable": 79}, {"value": "true", "variable": 50}, {"value": "at_least_3600mm", "variable": 3}, {"value": "false", "variable": 111}, {"value": "false", "variable": 117}, {"value": "sufficiently_wide", "variable": 18}, {"value": "on_door", "variable": 110}, {"value": "indoor_facility", "variable": 500}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 33}, {"value": "outdoors", "variable": 2}, {"value": "multipurpose_sport_hall", "variable": 61}, {"value": "true", "variable": 59}, {"value": "false", "variable": 34}, {"value": "true", "variable": 6}, {"value": "true", "variable": 113}, {"value": "… | internal | 4379 | 2cd6c260-07cc-43df-bc36-a737338ddda0 | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Uuden Paviljongin konserttisali, Seppo Kimanen -sali, on kaunis puusisusteinen huippuakustiikalla ja nykyaikaisella audiovisuaalisella tekniikalla varustettu tila. Sali soveltuu niin pienten kuin suurten konserttien, juhlien, esitysten, seminaarien ja kokousten areenaksi. Salissa on kiinteitä istumapaikkoja 220. Irtotuoleilla istumapaikkojen määrää voidaan kasvattaa aina 380 asti. Tarvittaessa salin katsomo saadaan siirrettyä sivuun nopeasti ja siististi, jolloin salin lattiatila kaksinkertaistuu.Konserttisalin huippuunsa hiotun akustiikan on suunnitellut akustiseen suunnitteluun erikoistunut suomalainen Insinööritoimisto Akukon Oy Konserttisalin akustiikka soveltuu erinomaisesti klassisen musiikin esittämiseen, erityisesti kamariorkesterikokoonpanoille. Salin korkeus, leveys ja luonnonmukaiset puupinnat antavat mahtavan ja harmonisen tilan tunnun sekä luonnollisen kaiun akustiselle musiikille. Akustiikka voidaan myös säätää saliin sijoitetuilla yhdeksällä akustiikkaverholla halutun soinnin aikaansaamiseksi. Uuden Paviljongin konserttisalin akustiikkaa on kehuttu Suomen ja jopa Pohjoismaiden parhaaksi monien muusikkojen, orkesterijohtajien, äänittäjien ja äänilevytuottajien toimesta. | Uusi Paviljonki | Läntinen Koulupolku 3 | Västra Skolstigen 3 | Läntinen Koulupolku 3 | http://www.kauniainen.fi/kulttuuri_ja_vapaa-aika/juhlatilat/uusi_paviljonki | http://www.kauniainen.fi/sv/kultur_och_fritid/lokaler_och_uthyrning/nya_paviljongen | http://www.kauniainen.fi/kulttuuri_ja_vapaa-aika/juhlatilat/uusi_paviljonki | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 559 9580 | richard.silin@kauniainen.fi | 2014-03-26T16:39:26+02:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-03-13T09:31:04.094036+02:00 | {"00": null, "11": "green", "12": "green", "13": "green", "21": "green", "22": "green", "23": "green", "31": "green", "32": "green", "33": "green", "41": "green", "51": "red", "52": "red", "61": "red"} | [1403] | kauniainen | [354] | [329] | {"sv": ["konsert", "musik", "evenamang", "f\u00f6rest\u00e4llning"], "fi": ["konsertit", "esitykset", "keikat", "musiikki", "tapahtumat"]} | Point | 24.724125 | 60.214394 | Läntinen Koulupolku 3, 02700 Kauniainen | Nya Paviljongen | Läntinen Koulupolku 3, 02700 Kauniainen | 1 | Västra Skolstigen 3, 02700 Grankulla | Nya Paviljongens konsertsal, Speldosan, är en vacker träinredd sal med förstklassig akustik och modern audiovisuell teknik. Salen lämpar sig för såväl små som stora konserter, fester, föreställningar, seminarier och möten. Det finns 220 fasta sittplatser i salen. Med flyttbara stolar kan antalet platser ökas till 380. Vid behov får man salens bänkutrymme förflyttat snabbt och snyggt ur vägen, vilket ger dubbla golvutrymme.Toppakustiken i salen har planerats av det finska företaget Insinööritoimisto Akukon Oy, som specialiserat sig på akustisk planering. Konsertsalens akustik lämpar sig utmärkt för framförande av klassisk musik, i synnerhet för kammarmusikensembler. Salens höjd och bredd och de naturliga träytorna ger en mäktig och harmonisk utrymmeskänsla och en naturlig klang åt akustisk musik. För att få fram önskad klang kan man också justera akustiken med de nio akustikdraperier som finns i salen. Ett stort antal musiker, kapellmästare, ljudtekniker och skivproducenter har ansett att Nya Paviljongens konsertsal har den bästa akustiken i Finland och t.o.m. i Norden. | 4 | ||||||||||||||||||||||||||||||||||||
| 14456 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://www.kauniainen.fi/kaupunki_ja_paatoksenteko/osallistu_ja_vaikuta"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 117}, {"value": "false", "variable": 33}, {"value": "false", "variable": 44}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "false", "variable": 82}, {"value": "false", "variable": 111}, {"value": "sufficiently_wide", "variable": 18}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 50}, {"value": "false", "variable": 55}, {"value": "false", "variable": 84}, {"value": "true", "variable": 118}, {"value": "short_term_stay", "variable": 60}, {"value": "at_least_3600mm", "variable": 3}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "true", "variable": 40}, {"value": "1", "variable": 1}, {"value": "true", "variable": 107}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 52}, {"value": "true", "variable": 112}, {"value": "true", "variable": 115}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 37}, {"value": "true", "variable": 113}, {"value": "true", "variable": 62}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "false", "variable": 79}, {"value": "false", "variable": 98}, {"value": "true", "variable": 51}, {"value": "false", "variable": 49}, {"value": "false", "variable": 42}, {"value": "true", "variable": 114}, {"value": "false", "variable": 5}, {"value": "false", "variable": 22}, {"value": "smooth", "variable": 17}, {"value": "requires_use_of_buzzer_and_is_heavy", "variable": 54}, {"value": "true", "variable": 109}, {"value": "false", "variable": 29}, {"value": "false", "variable": 116}, {"value": "false", "variable": 38}, {"value": "at_least_4_steps", "variable": 39}, {"value": "guided_and_clear", "variable": 19}, {"value": "true", "variable": 59}, {"value": "false", "variable": 57}, {"value": "false", "variable": 21}, {"value": "true", "variable": 20}, {"value": "false", "variable": 102}, {"value": "false", "variable": 92}, {"value": "true", "variable": 35}, {"value": "false", "variable": 103}, {"value": "false", "variable": 34}, {"value": "true", "variabl… | internal | 4399 | a5f020bf-45a7-41d4-b32c-9c9c24909ef5 | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kauniaisten kaupungintalo | City Hall | Kauniaistentie 10 | Grankullavägen 10 | Kauniaistentie 10 | http://www.kauniainen.fi/ | http://www.kauniainen.fi/sv/ | http://www.kauniainen.fi/en/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 505 61 | +358 9 505 6535 | kauniainen@kauniainen.fi | +358 9 505 6217 | monistamo@kauniainen.fi | http://www.kauniainen.fi | 2014-03-26T16:39:26+02:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-03-13T09:31:04.186270+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": "green"} | [1400, 1401, 1402] | kauniainen | [308, 223, 514, 2004, 315, 224, 225, 77, 277, 537, 538, 78, 758, 192, 2003, 194, 760, 227, 522, 282, 2005] | [744, 558, 404, 395, 274, 273, 271, 270, 253, 252, 237, 201, 64, 63, 60] | {"fi": ["kaupungintalo", "valtuusto", "hallinto"], "sv": ["fullm\u00e4ktige", "f\u00f6rvaltning", "stadshus"], "en": ["city hall", "infomation"]} | Point | 24.728857 | 60.208878 | Kauniaistentie 10, 02700 Kauniainen | Grankulla stadshus | 2 | 3 | 1 | Kauniaistentie 10, 02700 Kauniainen | 3 | Grankullavägen 10, 02700 Grankulla | 4 |
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 );