unit
4 rows where accessibility_shortcoming_count_visually_impaired = 8 and accessibility_shortcoming_count_wheelchair = 1
This data as json, CSV (advanced)
Suggested facets: root_department
provider_type ✖
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1331 | [{"section_type": "HIGHLIGHT", "name": {"fi": "Jos sinulla on koronavirustartunnan oireita ja tarvitset toimintaohjeet, soita Helsingin koronavirusneuvontaan p. 09\u202f310 10024 (p\u00e4ivitt\u00e4in klo 8-18). Koronavirusneuvonnasta voit varata ajan koronavirustestiin. Sinut ohjataan my\u00f6s tarvittaessa koronaterveysasemalle.\nJos asia ei voi odottaa koronaneuvonnan aukeamista tai kyse on muusta kiireellisest\u00e4 sairaudesta, soita P\u00e4ivystysapuun, p. 116\u202f117.", "sv": "Om du har symtom p\u00e5 coronavirus och beh\u00f6ver r\u00e5d om vad du ska g\u00f6ra, ring Helsingfors coronavirusr\u00e5dgivning p\u00e5 09 310 10024 (dagligen kl. 8-18). Via coronavirusr\u00e5dgivningen kan du boka tid f\u00f6r ett coronavirustest. Vid behov kan du ocks\u00e5 h\u00e4nvisas till en h\u00e4lsostation f\u00f6r coronapatienter.\nOm \u00e4rendet inte kan v\u00e4nta tills coronavirusr\u00e5dgivningen \u00f6ppnar eller om det \u00e4r fr\u00e5ga om n\u00e5gon annan akut sjukdom, betj\u00e4nar jourhj\u00e4lpen p\u00e5 tfn 116 117.", "en": "If you have symptoms indicative of a coronavirus infection and need instructions on what to do, call Helsinki's Coronavirus Helpline, open every day of the week from 8 am to 6 pm at tel. 09 310 10024. You can book an appointment for a coronavirus test via the helpline. If necessary, you will also be directed to a coronavirus health station.\nIf you cannot wait for the Coronavirus Helpline to open or need assistance with an urgent health concern, please contact the Medical Helpline at tel. 116 11"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [{"value": "0", "variable": 1}, {"value": "true", "variable": 79}, {"value": "true", "variable": 57}, {"value": "false", "variable": 22}, {"value": "true", "variable": 50}, {"value": "true", "variable": 52}, {"value": "false", "variable": 48}, {"value": "true", "variable": 114}, {"value": "false", "variable": 31}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "true", "variable": 59}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 30}, {"value": "true", "variable": 35}, {"value": "false", "variable": 49}, {"value": "opens_with_access_control_key", "variable": 54}, {"value": "true", "variable": 38}, {"value": "true", "variable": 70}, {"value": "true", "variable": 115}, {"value": "false", "variable": 103}, {"value": "false", "variable": 20}, {"value": "true", "variable": 104}, {"value": "false", "variable": 33}, {"value": "true", "variable": 72}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 21}, {"value": "false", "variable": 98}, {"value": "false", "variable": 75}, {"value": "false", "variable": 62}, {"value": "false", "variable": 92}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 53}, {"value": "false", "variable": 28}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 6}, {"value": "false", "variable": 43}, {"value": "false", "variable": 84}, {"value": "6", "variable": 64}, {"value": "false", "variable": 34}, {"value": "true", "variable": 105}, {"value": "true", "variable": 23}, {"value": "false", "variable": 106}, {"value": "no_handrails", "variable": 41}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 45}, {"value": "true", "variable": 112}, {"value": "no_handrails", "variable": 26}, {"value": "true", "variable": 29}, {"value": "3_consecutive_steps", "variable": 24}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 102}, {"value": "true", "variable": 25}, {"value": "true", "variable": 73}, {"value": "true", "variable": 74}, {"value": "true… | internal | 1187 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Tilkan ryhmäkoti | Tilkka group home | Tilkankatu 1 A | Tilkgatan 1 A | Tilkankatu 1 A | https://www.hel.fi/vammaiset/fi/asuminen/kehitysvammaisten-asumispalvelut/ryhmakodit/tilkka | https://www.hel.fi/vammaiset/fi/asuminen/kehitysvammaisten-asumispalvelut/ryhmakodit/tilkka | https://www.hel.fi/vammaiset/fi/asuminen/kehitysvammaisten-asumispalvelut/ryhmakodit/tilkka | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 41743 | +358 9 310 73987 | jarmo-ahti.karppinen@hel.fi | 2007-11-15T00:00:00+02:00 | 00300 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:00.473820+02:00 | {"00": null, "11": "green", "12": "red", "13": "green", "21": "red", "22": "red", "23": "red", "31": "green", "32": "red", "33": "green", "41": "green", "51": "red", "52": "red", "61": "red"} | [783] | helsinki | [815] | [275] | {} | Point | 24.894983 | 60.204018 | PL 30811, 00099 Helsingin kaupunki | Tilkka grupphem | 3 | 1 | P.O. Box 30811, 00099 City of Helsinki | 1 | 1 | PB 30811, 00099 Helsingfors stad | 8 | |||||||||||||||||||||||||||||||||
| 6669 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Kuraattori", "sv": "Kuraattori", "en": "Kuraattori"}, "www": null, "email": null, "phone": "+358 50 401 3267", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Psykologi", "sv": "Psykologi", "en": "Psykologi"}, "www": null, "email": null, "phone": "+358 40 164 7585", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Koulujen tilojen ilta- ja vapaa-ajank\u00e4yt\u00f6n neuvonta ja varaukset: liikuntasalit 09 310 87800, muut tilat 09 310 12001"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Tarjolla sali", "sv": "Tillg\u00e4nglig: sal", "en": "Available: hall"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Tilanvaraus", "sv": "Lokalbokning", "en": "Reservation of premises"}, "www": {"fi": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/fi/palvelut/tilojen-varaaminen/koulutilojen-kaytto", "sv": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/sv/tjanster/anvandning-skollokaler", "en": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/en/services/renting-facilities/school-facilities"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hakemus varhaiskasvatukseen tai esiopetukseen", "sv": "Ans\u00f6kan om sm\u00e5barnspedagogik eller f\u00f6rskoleundervisning", "en": "Application for early education or pre-primary education"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=506", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=506", "en": "https://www.hel.fi/helsinki/en/administration/administration/services/eservices?id=506"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 118}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 107}, {"value": "true", "variable": 74}, {"value": "false", "variable": 116}, {"value": "false", "variable": 22}, {"value": "true", "variable": 5}, {"value": "true", "variable": 114}, {"value": "false", "variable": 51}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "true", "variable": 117}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 92}, {"value": "false", "variable": 33}, {"value": "false", "variable": 21}, {"value": "true", "variable": 37}, {"value": "true", "variable": 75}, {"value": "true", "variable": 52}, {"value": "false", "variable": 104}, {"value": "true", "variable": 113}, {"value": "true", "variable": 94}, {"value": "true", "variable": 78}, {"value": "handrails_on_both_sides", "variable": 101}, {"value": "true", "variable": 98}, {"value": "2_consecutive_steps", "variable": 93}, {"value": "handrails_on_both_sides", "variable": 32}, {"value": "true", "variable": 72}, {"value": "true", "variable": 20}, {"value": "false", "variable": 100}, {"value": "true", "variable": 44}, {"value": "no_handrails", "variable": 95}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 53}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 70}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 73}, {"value": "true", "variable": 112}, {"value": "false", "variable": 34}, {"value": "false", "variable": 62}, {"value": "false", "variable": 102}, {"value": "false", "variable": 38}, {"value": "false", "variable": 103}, {"value": "false", "variable": 48}, {"value": "false", "variable": 79}, {"value": "opens_automatically_with_button", "variable": 54}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 35}, {"value": "0", "variable": 1}, {"value": "ramp_over_6m_long_with_intermediate_landing", "variable": 99}, {"value": "true", "variable": 58}, {"value": "false", "variable":… | internal | 20387 | c3e35724-76f1-406e-bac3-9dd16ca0d164 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Tahvonlahden ala-asteen koulu | Tahvonlahti Comprehensive School, Lower Stage | Gunillantie 12 | Gunillavägen 12 | Gunillantie 12 | http://www.tahvoaa.edu.hel.fi | http://www.tahvoaa.edu.hel.fi | http://www.tahvoaa.edu.hel.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 82651 | +358 9 310 80487 | Tuuli.Forsberg@hel.fi | 2015-11-27T12:11:49+02:00 | 00870 | www.hel.fi | kaikki | helsinki | 2020-12-03T13:00:57.763059+02:00 | {"00": null, "11": "green", "12": "red", "13": "green", "21": "red", "22": "red", "23": "red", "31": "green", "32": "red", "33": "green", "41": "green", "51": "red", "52": "red", "61": "red"} | [1087, 1402] | helsinki | [1171, 1123, 1124, 1135, 1136, 1134, 1146, 1100, 331] | [806, 661, 108, 34, 28, 27, 16, 15, 2] | {"fi": ["sali", "tilanvaraus", "tilavaraus", "koulu", "peruskoulu", "peruskoulut"], "sv": ["lokalbokning"], "en": ["reservation of premises", "basiceducation", "basic education"]} | Point | 25.036829 | 60.167908 | PL 87301, 00099 Helsingin kaupunki | Lågstadieskolan Tahvonlahden ala-asteen koulu | Gunilantie 12 koulurakennus on väliaikaisesti pois käytöstä. Koulu toimii muussa osoitteessa. | 2 | 1 | P.O. Box 87301, 00099 City of Helsinki | 1 | 1 | PB 87301, 00099 Helsingfors stad | 8 | ||||||||||||||||||||||||||||||||
| 33321 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://asiointi.vantaa.fi/anna-palautetta"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 58}, {"value": "false", "variable": 38}, {"value": "opens_automatically", "variable": 77}, {"value": "under_20mm", "variable": 91}, {"value": "over_10m", "variable": 4}, {"value": "false", "variable": 49}, {"value": "true", "variable": 109}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 5}, {"value": "false", "variable": 62}, {"value": "true", "variable": 16}, {"value": "indoors_but_not_service_point", "variable": 9}, {"value": "true", "variable": 12}, {"value": "true", "variable": 115}, {"value": "false", "variable": 83}, {"value": "true", "variable": 112}, {"value": "true", "variable": 107}, {"value": "true", "variable": 52}, {"value": "false", "variable": 84}, {"value": "true", "variable": 114}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 7}, {"value": "true", "variable": 10}, {"value": "false", "variable": 29}, {"value": "false", "variable": 34}, {"value": "true", "variable": 78}, {"value": "true", "variable": 50}, {"value": "false", "variable": 98}, {"value": "indoor_facility", "variable": 500}, {"value": "floor_2", "variable": 108}, {"value": "2", "variable": 1}, {"value": "guided_and_clear", "variable": 19}, {"value": "true", "variable": 111}, {"value": "true", "variable": 20}, {"value": "false", "variable": 106}, {"value": "false", "variable": 92}, {"value": "true", "variable": 57}, {"value": "opens_automatically", "variable": 15}, {"value": "true", "variable": 105}, {"value": "true", "variable": 73}, {"value": "false", "variable": 53}, {"value": "false", "variable": 80}, {"value": "true", "variable": 6}, {"value": "false", "variable": 104}, {"value": "false", "variable": 59}, {"value": "false", "variable": 103}, {"value": "false", "variable": 48}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 23}, {"value": "true", "variable": 70}, {"value": "false", "variable": 21}, {"value": "true", "variable": 72}, {"value": "parking_hall", "variable": 2}, {"value": "false", "variable": 1… | internal | 14876 | a415e9df-7d93-43e7-bc97-4e12e1192a0e | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Tarjoamme yrityksille ja muille työnantajille maksuttomia palveluita, joilla autetaan työnantajia löytämään osaavaa työvoimaa sekä rahanarvoisia tukia työllistämiseen. -Työllistämisen Vantaa-lisä yrityksille -Työllistämisen Vantaa-lisä järjestöille -Rekrytointituki- Nuorten kesätyöseteliLäytössä on tukia, joilla autetaan työtöntä saamaan ote työelämästä. Erilaisilla ja eri-ikäisille räätälöidyillä tuilla kehitetään osaamista, tuetaan palaamista työelämään pitkän tauon jälkeen sekä autetaan nuoria alkuun urapolulla.Yritysohjaamon palvelut:-Rekrytreffit: työnantajan ja työnhakijat kohtaavat toisensa pikahaastattelussa.-Yritysohjaamon sähköisten kanavien hyödyntäminen: avointen työpaikkojen markkinointi kanavissamme.-Osaajahaku Vantaa -palvelu: tukea rekrytointiprosessin suunnitteluun ja toteutukseen.-Tietoa ja neuvontaa työllistämisen taloudellisista tuista. | Työllisyyspalvelut, hallinto | City of Vantaa employment services, administration | Vernissakatu 1, 2. krs | Fernissagatan 1, 2. vån. | Vernissakatu 1, 2. floor | http://www.vantaa.fi/hallinto_ja_talous/tyo_ja_elinkeinot/tyollisyysasiat | http://www.vanda.fi/forvaltning_och_ekonomi/arbete_och_naringsliv | http://www.vantaa.fi/en/work_and_business_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 314 5583 | eija.korpimaki@vantaa.fi | +358 40 701 3849 | etunimi.sukunimi@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01300 | www.vantaa.fi | kaikki | vantaa | 2020-03-13T09:31:31.477245+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "green", "23": "green", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [783, 1401] | vantaa | [168, 866, 850, 163, 167] | [833, 723, 638, 180, 48] | {"fi": ["ty\u00f6llisyyspalvelut", "hallinto"]} | Point | 25.045877 | 60.29073 | Vernissakatu 1, 2. krs, 01300 Vantaa | Sysselsättninsservicen, förvaltning | Yritysten ja muiden työnantajien palvelu, jolla pyritään saavuttamaan työvoimaa ja tukia työllistymiseen. | 1 | Vernissakatu 1, 2. floor, 01300 Vantaa | 1 | 1 | Fernissagatan 1, 2. vån., 01300 Vanda | 8 | |||||||||||||||||||||||||||||||
| 59213 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-to 07:30-15:50, pe 07:30-15", "sv": "\u00f6ppet m\u00e5n-tor 07:30-15:50, fre 07:30-15", "en": "open Mon-Thu 07:30-15:50, Fri 07:30-15"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [{"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 111}, {"value": "false", "variable": 48}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 22}, {"value": "true", "variable": 73}, {"value": "true", "variable": 116}, {"value": "false", "variable": 83}, {"value": "true", "variable": 74}, {"value": "true", "variable": 78}, {"value": "false", "variable": 23}, {"value": "false", "variable": 80}, {"value": "true", "variable": 107}, {"value": "false", "variable": 72}, {"value": "true", "variable": 109}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 113}, {"value": "true", "variable": 57}, {"value": "true", "variable": 79}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 102}, {"value": "true", "variable": 5}, {"value": "true", "variable": 112}, {"value": "opens_automatically", "variable": 77}, {"value": "true", "variable": 105}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "true", "variable": 6}, {"value": "true", "variable": 50}, {"value": "-1", "variable": 63}, {"value": "false", "variable": 98}, {"value": "false", "variable": 75}, {"value": "false", "variable": 38}, {"value": "false", "variable": 49}, {"value": "true", "variable": 76}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 58}, {"value": "true", "variable": 52}, {"value": "false", "variable": 33}, {"value": "true", "variable": 114}, {"value": "false", "variable": 21}, {"value": "false", "variable": 92}, {"value": "on_door", "variable": 110}, {"value": "false", "variable": 104}, {"value": "true", "variable": 115}, {"value": "false", "variable": 59}, {"value": "false", "variable": 106}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 37}, {"value": "false", "variable": 118}, {"value": "true", "variable": 117}, {"value": "false", "variable": 103}, {"value": "false", "variable": 84}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 62}, {"value": "… | internal | 28044 | 84075c47-a8e4-4a45-a109-65221f63b3bf | 84075c47-a8e4-4a45-a109-65221f63b3bf | SELF_PRODUCED | service_by_joint_municipal_authority | kuntayhtymän palvelu | tjänst från samkommunen | service by joint municipal authority | 1 | HUS Kuvantaminen Hyvinkään sairaalan kliininen neurofysiologia | HUS Medical Imaging Hyvinkää Hospital's Clinical Neurophysiology | Sairaalankatu 1 | Sjukhusgatan 1 | Sairaalankatu 1 | http://www.hus-kuvantaminen.fi | https://www.hus.fi/sv/sjukvard/bilddiagnostik-och-fysiologi/Sidor/default.aspx | https://www.hus.fi/en/medical-care/medical-imaging-and-physiology/Pages/default.aspx | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 19 4587 2747 | 2019-03-07T11:16:08+02:00 | www.hus.fi | kaikki | hyvinkää | 2020-11-05T16:32:50.922393+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": null, "23": "green", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [986] | hyvinkää | [1010] | [820] | {"fi": ["kuvantaminen", "hyvink\u00e4\u00e4n sairaala", "kliininen neurofysiologia"]} | Point | 24.828123 | 60.61013 | HUS Bilddiagnostik Hyvinge sjukhus klinisk fysiologi | 1 | 1 | 1 | 8 |
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 );