4 rows where accessibility_shortcoming_count_visually_impaired = 3 and data_source = "www.kauniainen.fi"

View and edit SQL

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
14401 [{"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": "false", "variable": 33}, {"value": "true", "variable": 50}, {"value": "true", "variable": 78}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 115}, {"value": "false", "variable": 22}, {"value": "true", "variable": 113}, {"value": "false", "variable": 34}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "true", "variable": 20}, {"value": "true", "variable": 53}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 98}, {"value": "true", "variable": 114}, {"value": "true", "variable": 57}, {"value": "false", "variable": 29}, {"value": "opens_easily_manually", "variable": 54}, {"value": "3", "variable": 64}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 111}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 102}, {"value": "true", "variable": 118}, {"value": "true", "variable": 105}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 59}, {"value": "false", "variable": 62}, {"value": "1", "variable": 1}, {"value": "true", "variable": 51}, {"value": "false", "variable": 21}, {"value": "false", "variable": 49}, {"value": "true", "variable": 106}, {"value": "opens_automatically", "variable": 77}, {"value": "false", "variable": 48}, {"value": "true", "variable": 52}, {"value": "false", "variable": 23}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 70}, {"value": "on_door", "variable": 110}, {"value": "floor_2", "variable": 119}, {"value": "true", "variable": 112}, {"value": "true", "variable": 58}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 103}, {"value": "true", "variable": 74}, {"value": "false", "variable": 92}, {"value": "true", "variable": 107}, {"value": "under_10m", "variable": 4}, {"value": "false", "variable": 5}, {"value": "true", "variable": 73}, {"value": "true", "variable": 116}, {"value": "false", "variable": 83}, {"value": "true", "variable": 76}, {"value": "true", "variable": 72},… internal 4358     4a87368d-4a78-40ea-8a18-2a944f713ab5 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Granhultsskolan   Oppilaskodintie 23 Elevhemsvägen 23 Oppilaskodintie 23 http://www.granhultsskolan.fi/fi http://www.granhultsskolan.fi/ http://www.granhultsskolan.fi/fi   pvm/mpm lna/msa local network charge/mobile call charge   +358 50 469 4653         2014-03-26T16:39:26+02:00 02700 www.kauniainen.fi kaikki kauniainen 2020-06-01T07:31:10.583211+03:00 {"00": null, "11": "green", "12": "green", "13": "red", "21": "green", "22": "green", "23": "red", "31": "green", "32": "green", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} [986, 1087] kauniainen [1374, 2164, 2165] [340, 339] {"sv": ["klass ett", "l\u00e5gstadium"], "fi": ["ruotsinkielinen ala-aste", "ruotsinkielinen alakoulu"]} Point 24.712973 60.21668 Oppilaskodintie 23, 02700 Kauniainen         Granhultsskolan Ruotsinkielinen alakoulu Kauniaisissa. 1 1       Oppilaskodintie 23, 02700 Kauniainen 1     1   Elevhemsvägen 23, 02700 Grankulla Svenskspråkig lågstadieskola i Grankulla.   3      
14412 [{"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": "over_10m", "variable": 4}, {"value": "true", "variable": 50}, {"value": "false", "variable": 34}, {"value": "false", "variable": 98}, {"value": "false", "variable": 31}, {"value": "2", "variable": 1}, {"value": "false", "variable": 84}, {"value": "true", "variable": 37}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 111}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 52}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 112}, {"value": "true", "variable": 20}, {"value": "sufficiently_wide", "variable": 18}, {"value": "indoor_facility", "variable": 500}, {"value": "on_door", "variable": 110}, {"value": "false", "variable": 22}, {"value": "true", "variable": 115}, {"value": "true", "variable": 53}, {"value": "true", "variable": 116}, {"value": "false", "variable": 79}, {"value": "true", "variable": 117}, {"value": "false", "variable": 106}, {"value": "true", "variable": 62}, {"value": "true", "variable": 82}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 38}, {"value": "false", "variable": 49}, {"value": "true", "variable": 57}, {"value": "true", "variable": 109}, {"value": "false", "variable": 35}, {"value": "false", "variable": 83}, {"value": "true", "variable": 105}, {"value": "true", "variable": 80}, {"value": "false", "variable": 48}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 23}, {"value": "false", "variable": 5}, {"value": "true", "variable": 104}, {"value": "false", "variable": 103}, {"value": "false", "variable": 102}, {"value": "false", "variable": 44}, {"value": "outdoors", "variable": 2}, {"value": "true", "variable": 107}, {"value": "false", "variable": 92}, {"value": "true", "variable": 51}, {"value": "true", "variable": 113}, {"value": "true", "variable": 118}, {"value": "true", "variable": 29}, {"value": "false", "variable": 33},… internal 4390     7bf9f508-7534-427d-9229-09d5400fa5bc 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1             Kauniaisten terveyspalvelut tarjoavat ihmisläheistä, asianmukaista ja ammattitaitoista palvelua, joilla pyritään vahvistamaan ihmisen omia voimavaroja ja edistämään asukkaiden terveyttä. The health centre has a doctor's, nurse's and public health nurse's practice. The health centre is open on weekdays at 8 am-4 pm. If you need treatment on the same day, contact the health centre as soon as it opens in the morning.   Kauniaisten terveysasema Kauniainen Health Centre Asematie 19 Stationsvägen 19 Asematie 19 http://www.kauniainen.fi/sosiaali-_ja_terveyspalvelut/terveyspalvelut/terveysasema http://www.kauniainen.fi/sv/social-_och_halsovard/halsovardstjanster/halsovardscentralen http://www.kauniainen.fi/sosiaali-_ja_terveyspalvelut/terveyspalvelut/terveysasema   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8789 1300 +358 9 505 6363       2014-03-26T16:39:26+02:00 02700 www.kauniainen.fi kaikki kauniainen 2020-03-13T09:31:03.956085+02:00 {"00": null, "11": "green", "12": "green", "13": "red", "21": "green", "22": "green", "23": "red", "31": "green", "32": "green", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} [783, 986, 1087] kauniainen [1001, 1029, 1031, 995, 996, 829, 2165, 2164, 1033, 1017, 1005, 1002, 1034, 992, 1043, 2167, 2166, 793, 1006, 1041, 1036, 1037, 993, 991, 1008] [863, 835, 703, 702, 635, 583, 527, 525, 507, 504, 477, 417, 416, 379, 378, 366, 355, 352, 339, 184, 172, 43] {"fi": ["hemv\u00e5rd", "fysioterapia", "huslab", "h\u00e4lsocentral", "kotihoito", "kotisairaanhoito", "laboratorio", "l\u00e4\u00e4k\u00e4ri", "l\u00e4\u00e4k\u00e4rinvastaanotto", "n\u00e4ytteenotto", "terveysasema", "terveyskeskus", "hammasl\u00e4\u00e4k\u00e4ri", "hammass\u00e4rky", "kuntoutus", "hammashoito", "hemsjukv\u00e5rd", "terveysasemat"], "sv": ["fysioterapi", "h\u00e4lsostation", "laboratorium", "l\u00e4kare", "l\u00e4karmottagning", "provtagning", "rehabilitering", "tandl\u00e4kare", "tandv\u00e5rd", "tandv\u00e4rk"], "en": ["dentist", "doctor", "health care", "health care center", "health care centre", "laboratory", "nurse", "rehabilitation"]} Point 24.716194 60.21447 PL 52, 02701 Kauniainen         Grankulla hälsovårdscentral   1 1       P.O. Box 52, 02701 Kauniainen 1     1   PB 52, 02701 Grankulla   Hälsovården i Grankulla erbjuder människonära, ändamålsenlig och yrkeskunnig service, som syftar till att stärka människans egna resurser och främja invånarnas hälsa. 3      
14431 [{"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": 105}, {"value": "false", "variable": 33}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 106}, {"value": "false", "variable": 111}, {"value": "1", "variable": 1}, {"value": "false", "variable": 29}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 23}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 57}, {"value": "true", "variable": 52}, {"value": "false", "variable": 84}, {"value": "true", "variable": 51}, {"value": "false", "variable": 114}, {"value": "true", "variable": 107}, {"value": "under_10m", "variable": 4}, {"value": "true", "variable": 112}, {"value": "true", "variable": 109}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 104}, {"value": "false", "variable": 79}, {"value": "false", "variable": 44}, {"value": "sufficiently_wide", "variable": 18}, {"value": "smooth", "variable": 17}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 20}, {"value": "false", "variable": 83}, {"value": "false", "variable": 98}, {"value": "false", "variable": 92}, {"value": "true", "variable": 62}, {"value": "true", "variable": 55}, {"value": "false", "variable": 22}, {"value": "true", "variable": 117}, {"value": "true", "variable": 115}, {"value": "false", "variable": 48}, {"value": "true", "variable": 118}, {"value": "true", "variable": 6}, {"value": "at_least_3600mm", "variable": 3}, {"value": "false", "variable": 102}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 103}, {"value": "false", "variable": 49}, {"value": "true", "variable": 21}, {"value": "true", "variable": 5}, {"value": "true", "variable": 59}, {"value": "false", "variable": 38}, {"value": "outdoors", "variable": 2}, {"value": "true", "variable": 37}, {"value": "false", "variable": 53}, {"value": "true", "variable": 113}, {"value": "false", "variable": 34}, {"value": "under_20mm", "variable": 91}, {"valu… internal 4370     7bf9f508-7534-427d-9229-09d5400fa5bc 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1             Kauniaisten kaupungin vanhuspalvelun kautta voi hakea kuuden hengen ryhmäkoti Villa Apolloon. Ryhmäkoti on tarkoitettu vanhuksille, jotka tarvitsevat runsaasti apua päivittäisissä toimissa, mutta eivät kuitenkaan ympärivuorokautista tai sairaalahoitoa. Ryhmäkodissa asukkailla on oma huone, jonka he kalustavat itse, huoneen yhteydessä on omat WC- ja peseytymistilat sekä kaikille yhteinen tila oleskelua ja ruokailuja varten. Asukkailta peritään maksuna vuokra, ateriamaksu, perusmaksu, mahdollinen turvapuhelinmaksu sekä yksilöllinen palvelumaksu, joka kattaa jokapäiväisen hoidon ja hoivan. Ryhmäkodin hoidosta sekä sen asukkaista huolehtii kotihoidon henkilökunta. Ryhmäkotiin voi hakea ottamalla yhteyttä kotihoidon esimieheen.     Ryhmäkoti Villa Apollo   Palokunnantie 7 Brandkårsvägen 7 Palokunnantie 7 https://www.kauniainen.fi/sosiaali-_ja_terveyspalvelut/ikaantyneiden_palvelut/asumis-_ja_hoivapalvelut/villa_apollo https://www.kauniainen.fi/sv/social-_och_halsovard/aldreomsorg/boende_och_vard/villa_apollo https://www.kauniainen.fi/sosiaali-_ja_terveyspalvelut/ikaantyneiden_palvelut/asumis-_ja_hoivapalvelut/villa_apollo   pvm/mpm lna/msa local network charge/mobile call charge   +358 50 500 4137         2014-03-26T16:39:26+02:00 02700 www.kauniainen.fi kaikki kauniainen 2020-03-13T09:31:04.068917+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"} [783, 986] kauniainen [829, 996, 1043, 853, 827, 824, 825] [760, 759, 757, 640, 635, 477] {"fi": ["ryhm\u00e4asuminen"], "sv": ["gruppboende"]} Point 24.718046 60.21303 PL 52, 02700 Kauniainen         Grupphemmet Villa Apollo   1 2     1 P.O. Box 52, 02700 Kauniainen 1     2   PB 52, 02700 Grankulla   Grupphemmet Villa ApolloVia äldreomsorgen i Grankulla stad kan man söka till grupphemmet Villa Apollo med sex platser. Grupphemmet är avsett för åldringar som behöver mycket hjälp i sina dagliga sysslor men inte omsorg dygnet runt eller sjukhusvård. I grupphemmet har de boende var sitt rum, som de möblerar själv, och i anslutning till rummet egen toalett och eget badrum. Dessutom finns en gemensam sal där man kan äta och vistas. Av de boende uppbärs hyra, måltidsavgift, grundavgift, avgift för en eventuell trygghetstelefon samt en individuell serviceavgift som täcker den dagliga vården och omsorgen.För skötseln av grupphemmet och för de boende ansvarar hemvårdens personal.Avdelningsskötaren, tfn (09) 5056 536 ger närmare information om grupphemmet. 3      
14435 [{"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": "false", "variable": 34}, {"value": "true", "variable": 62}, {"value": "false", "variable": 29}, {"value": "true", "variable": 37}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 6}, {"value": "false", "variable": 103}, {"value": "false", "variable": 48}, {"value": "false", "variable": 84}, {"value": "true", "variable": 59}, {"value": "true", "variable": 104}, {"value": "true", "variable": 52}, {"value": "under_20mm", "variable": 91}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 83}, {"value": "false", "variable": 58}, {"value": "false", "variable": 22}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 20}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 49}, {"value": "under_10m", "variable": 4}, {"value": "long_term_stay", "variable": 60}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 33}, {"value": "false", "variable": 98}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 44}, {"value": "true", "variable": 51}, {"value": "true", "variable": 38}, {"value": "false", "variable": 107}, {"value": "2", "variable": 1}, {"value": "false", "variable": 102}, {"value": "true", "variable": 57}, {"value": "true", "variable": 5}, {"value": "at_least_3600mm", "variable": 3}, {"value": "false", "variable": 21}, {"value": "false", "variable": 105}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 79}, {"value": "false", "variable": 92}, {"value": "1_step", "variable": 39}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 53}, {"value": "true", "variable": 50}, {"value": "false", "variable": 23}] internal 4380     2cd6c260-07cc-43df-bc36-a737338ddda0 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1             Tervetuloa nauttimaan 1900-luvun alun taiteilijakodin hengestä, herkullisesta ruoasta ja hyvästä palvelusta kulttuurihistorialliseen ympäristöön Vallmogårdiin Kauniaisiin. Vallmogård on arkkitehti Lars Sonckin suunnittelema tyylikäs jugend- huvila Kauniaisten keskustassa, jolla pitkä ja merkittävä historia osana kauniaislaista elämää.Vallmogårdia vuokrataan ulkopuoliseen käyttöön. Juhlakerros soveltuu erinomaisesti 20-70 henkilön juhlatilaisuuksiin. Vallmogårdin entinen kahvilatila on nykyisin myös kunnostettu ja kalustettu kokous- ja kokoontumistilaksi enintään 15 henkilölle.     Vallmogård   Valmukuja 3 Vallmogränden 3 Valmukuja 3 http://www.kauniainen.fi/kulttuuri_ja_vapaa-aika/juhlatilat/vallmogard http://www.kauniainen.fi/sv/kultur_och_fritid/lokaler_och_uthyrning/vallmogard http://www.kauniainen.fi/kulttuuri_ja_vapaa-aika/juhlatilat/vallmogard   pvm/mpm lna/msa local network charge/mobile call charge   +358 50 559 9580 +358 9 9505 6535       2014-03-26T16:39:26+02:00 02700 www.kauniainen.fi kaikki kauniainen 2020-03-13T09:31:04.106864+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} [1400, 1401, 1403] kauniainen [259, 150, 506, 737, 152, 261, 508, 355, 357] [799, 474, 345, 214] {"sv": ["konsert", "fest", "fester", "festlokal", "gigs", "lokalhyrning", "spelningar", "musik", "evenamang"], "fi": ["juhla", "juhlapaikka", "juhlat", "tilavuokraus", "konsertit", "musiikki", "tapahtumat"]} Point 24.732403 60.213978 Valmukuja 3, 02700 Kauniainen         Vallmogård   1 3       Valmukuja 3, 02700 Kauniainen 1     3   Vallmogränden 3, 02700 Grankulla   Vallmogård, som ritats av arkitekten Lars Sonck, är en av Grankulla stad ägd stilig jugendvilla i Grankulla centrum.Välkommen att njuta av atmosfären i ett konstnärshem från början av 1900-talet, av läcker mat och god service i en kulturhistorisk miljö. Vallmogårds mötes- och festlokaliteter och en unik omgivning som representerar jugendstilen bjuder på ramar för oförglömliga evenemang allt från några personers möten och kurser till middags- och bröllopsfester för 20-70 personer. Ta kontakt så berättar vi gärna mer om bokningen av Vallmogård. 3      

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