unit
4 rows where accessibility_shortcoming_count_visually_impaired = 3 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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | granhults.skolan@edu.grankulla.fi | 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 | hemvarden@grankulla.fi | 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
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 );