unit
5 rows where accessibility_viewpoints = "{"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"}" and identifiers_1_namespace = "ptvout"
This data as json, CSV (advanced)
Suggested facets: created_time (date), last_modified_time (date)
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17879 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-to 09-15, pe 10-15", "sv": "\u00f6ppet m\u00e5n-tor 09-15, fre 10-15", "en": "open Mon-Thu 09-15, Fri 10-15"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Palvelut Suomi.fi-verkkopalvelussa", "sv": "Tj\u00e4nsterna i Suomi.fi-webbtj\u00e4nsten", "en": "Services in the Suomi.fi Web Service"}, "www": {"fi": "https://www.suomi.fi/palvelut/palvelupiste/xxx/f29b27ed-bd8f-4f63-8e3d-936571ec40bf/palvelut?p=0", "sv": "https://www.suomi.fi/service/servicestalle/xxx/f29b27ed-bd8f-4f63-8e3d-936571ec40bf/service?p=0", "en": "https://www.suomi.fi/services/servicepoint/xxx/f29b27ed-bd8f-4f63-8e3d-936571ec40bf/services?p=0"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 98}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 103}, {"value": "true", "variable": 104}, {"value": "false", "variable": 102}, {"value": "true", "variable": 106}, {"value": "true", "variable": 105}, {"value": "false", "variable": 107}, {"value": "false", "variable": 92}, {"value": "true", "variable": 79}, {"value": "false", "variable": 80}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "true", "variable": 70}, {"value": "true", "variable": 76}, {"value": "opens_automatically", "variable": 77}, {"value": "false", "variable": 82}, {"value": "true", "variable": 78}, {"value": "true", "variable": 72}, {"value": "true", "variable": 73}, {"value": "false", "variable": 62}, {"value": "3", "variable": 63}, {"value": "true", "variable": 74}, {"value": "false", "variable": 83}, {"value": "true", "variable": 75}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 59}, {"value": "true", "variable": 51}, {"value": "true", "variable": 52}, {"value": "false", "variable": 84}, {"value": "true", "variable": 53}, {"value": "false", "variable": 48}, {"value": "false", "variable": 44}, {"value": "false", "variable": 49}, {"value": "true", "variable": 50}, {"value": "true", "variable": 37}, {"value": "false", "variable": 57}, {"value": "false", "variable": 38}, {"value": "false", "variable": 22}, {"value": "false", "variable": 23}, {"value": "false", "variable": 29}, {"value": "true", "variable": 21}, {"value": "false", "variable": 34}, {"value": "sufficiently_wide", "variable": 18}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 20}, {"value": "false", "variable": 33}, {"value": "true", "variable": 14}, {"value": "opens_automatically", "variable": 15}, {"value": "true", "variable": 16}, {"value": "true", "variable": 12}, {"value": "true", "variable": 13}, {"value": "otherwise_stands_o… | internal | 4957 | ptvout | f29b27ed-bd8f-4f63-8e3d-936571ec40bf | c5f6914f-302e-41cc-bed7-4d4215aac640 | c5f6914f-302e-41cc-bed7-4d4215aac640 | SELF_PRODUCED | state_service | valtion palvelu | statlig tjänst | state service | 1 | Kelan palvelupisteessä opastetaan ja neuvotaan kaikissa Kelan etuuksiin liittyvissä asioissa. Voit hakea etuuksia ja toimittaa liitteet myös asiointipalvelussamme osoitteessa www.kela.fi/asiointi. Lue myös mahdollisuudesta ajanvaraukseen: www.kela.fi/ajanvaraus. | Kela, Matinkylän palvelupiste | Suomenlahdentie 1 | Finnviksvägen 1 | Suomenlahdentie 1 | http://www.kela.fi | http://www.fpa.fi | http://www.kela.fi | 2011-03-25T14:21:10+02:00 | 02230 | www.kela.fi | kaikki | espoo | 2020-11-05T16:31:11.036730+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"} | [783, 1087, 1400, 1401] | espoo | [4, 130, 188, 797, 1377, 843, 809] | [755, 711, 485, 370, 286, 143, 75] | {} | Point | 24.740162 | 60.15998 | PL 10, 00056 FPA | FPA, Servicestället i Mattby-Olars | Kelan palvelupiste | 1 | 1 | P.O. Box 10, 00056 FPA | 1 | 1 | PB 10, 00056 FPA | Fpa:s serviceställe | På FPA:s serviceställe kan du få information och rådgivning om alla FPA-förmåner. Du kan också ansöka om förmåner och lämna in bilagor i vår e-tjänst på adressen www.fpa.fi/etjanst. Läs mer om hur du bokar tid på adressen www.fpa.fi/tidsbokning. | 2 | ||||||||||||||||||||||||||||||||||
| 17885 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-to 09-15, pe 10-15", "sv": "\u00f6ppet m\u00e5n-tor 09-15, fre 10-15", "en": "open Mon-Thu 09-15, Fri 10-15"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Palvelut Suomi.fi-verkkopalvelussa", "sv": "Tj\u00e4nsterna i Suomi.fi-webbtj\u00e4nsten", "en": "Services in the Suomi.fi Web Service"}, "www": {"fi": "https://www.suomi.fi/palvelut/palvelupiste/xxx/3a33914c-50de-4f34-85ea-fec6c72fa03d/palvelut?p=0", "sv": "https://www.suomi.fi/service/servicestalle/xxx/3a33914c-50de-4f34-85ea-fec6c72fa03d/service?p=0", "en": "https://www.suomi.fi/services/servicepoint/xxx/3a33914c-50de-4f34-85ea-fec6c72fa03d/services?p=0"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 92}, {"value": "true", "variable": 105}, {"value": "true", "variable": 106}, {"value": "false", "variable": 103}, {"value": "true", "variable": 104}, {"value": "false", "variable": 107}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 83}, {"value": "false", "variable": 84}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 82}, {"value": "false", "variable": 79}, {"value": "false", "variable": 80}, {"value": "false", "variable": 33}, {"value": "chairs_available", "variable": 81}, {"value": "true", "variable": 59}, {"value": "true", "variable": 58}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 62}, {"value": "false", "variable": 98}, {"value": "false", "variable": 44}, {"value": "true", "variable": 51}, {"value": "true", "variable": 52}, {"value": "true", "variable": 53}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 49}, {"value": "false", "variable": 38}, {"value": "false", "variable": 48}, {"value": "true", "variable": 50}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 20}, {"value": "false", "variable": 34}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 23}, {"value": "false", "variable": 29}, {"value": "true", "variable": 37}, {"value": "false", "variable": 22}, {"value": "smooth", "variable": 17}, {"value": "sufficiently_wide", "variable": 18}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 102}, {"value": "false", "variable": 21}, {"value": "true", "variable": 57}, {"value": "0", "variable": 1}, {"value": "true", "variable": 5}, {"value": "true", "variable": 6}] | internal | 5005 | ptvout | 3a33914c-50de-4f34-85ea-fec6c72fa03d | c5f6914f-302e-41cc-bed7-4d4215aac640 | c5f6914f-302e-41cc-bed7-4d4215aac640 | SELF_PRODUCED | state_service | valtion palvelu | statlig tjänst | state service | 1 | Kelan palvelupisteessä opastetaan ja neuvotaan kaikissa Kelan etuuksiin liittyvissä asioissa. Voit hakea etuuksia ja toimittaa liitteet myös asiointipalvelussamme osoitteessa www.kela.fi/asiointi. Lue myös mahdollisuudesta ajanvaraukseen: www.kela.fi/ajanvaraus. | Kela, Leppävaaran palvelupiste | Leppävaarankatu 10 | Albergagatan 10 | Leppävaarankatu 10 | http://www.kela.fi/ | http://www.fpa.fi | http://www.kela.fi/ | 2011-03-25T14:21:10+02:00 | 02600 | www.kela.fi | kaikki | espoo | 2020-11-05T16:31:11.061925+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"} | [783, 1087, 1400, 1401] | espoo | [4, 130, 188, 797, 1377, 843, 809] | [755, 711, 485, 370, 286, 143, 75] | {} | Point | 24.811256 | 60.21692 | PL 10, 00056 FPA | FPA, Servicestället i Alberga | Kelan palvelupiste | 2 | 2 | P.O. Box 10, 00056 FPA | 1 | 2 | PB 10, 00056 FPA | Fpa:s serviceställe | På FPA:s serviceställe kan du få information och rådgivning om alla FPA-förmåner. Du kan också ansöka om förmåner och lämna in bilagor i vår e-tjänst på adressen www.fpa.fi/etjanst. Läs mer om hur du bokar tid på adressen www.fpa.fi/tidsbokning. | 2 | ||||||||||||||||||||||||||||||||||
| 17894 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 09-16:15", "sv": "\u00f6ppet m\u00e5n-fre 09-16:15", "en": "open Mon-Fri 09-16:15"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Palvelut Suomi.fi-verkkopalvelussa", "sv": "Tj\u00e4nsterna i Suomi.fi-webbtj\u00e4nsten", "en": "Services in the Suomi.fi Web Service"}, "www": {"fi": "https://www.suomi.fi/palvelut/palvelupiste/xxx/946e5f17-c121-455f-b8f5-8932a39695af/palvelut?p=0", "sv": "https://www.suomi.fi/service/servicestalle/xxx/946e5f17-c121-455f-b8f5-8932a39695af/service?p=0", "en": "https://www.suomi.fi/services/servicepoint/xxx/946e5f17-c121-455f-b8f5-8932a39695af/services?p=0"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 37}, {"value": "false", "variable": 98}, {"value": "false", "variable": 105}, {"value": "false", "variable": 92}, {"value": "false", "variable": 102}, {"value": "true", "variable": 104}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 83}, {"value": "false", "variable": 84}, {"value": "false", "variable": 103}, {"value": "false", "variable": 48}, {"value": "false", "variable": 80}, {"value": "true", "variable": 52}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 79}, {"value": "true", "variable": 62}, {"value": "false", "variable": 82}, {"value": "false", "variable": 107}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 58}, {"value": "true", "variable": 53}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 57}, {"value": "true", "variable": 50}, {"value": "true", "variable": 59}, {"value": "true", "variable": 51}, {"value": "true", "variable": 20}, {"value": "false", "variable": 38}, {"value": "false", "variable": 44}, {"value": "indoor_facility", "variable": 500}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 49}, {"value": "false", "variable": 22}, {"value": "false", "variable": 23}, {"value": "false", "variable": 29}, {"value": "false", "variable": 21}, {"value": "false", "variable": 5}, {"value": "0", "variable": 1}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "smooth", "variable": 17}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 34}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 33}] | internal | 4980 | ptvout | 946e5f17-c121-455f-b8f5-8932a39695af | 62d0b5fa-aa79-4c83-af48-7847f12ad285 | 62d0b5fa-aa79-4c83-af48-7847f12ad285 | SELF_PRODUCED | state_service | valtion palvelu | statlig tjänst | state service | 1 | Maanmittauslaitoksen palvelupisteissä saat neuvoja maanmittaus- ja kirjaamisasioissa. Voit myös ostaa rekisteriotteita ja todistuksia, asiakirjakopioita sekä erilaisia karttoja ja karttatulosteita. Palvelupisteissämme on käytössä koko maan kattavat rekisterit, sähköiset arkistot ja paikkatietoaineistot. Voit siis asioida missä tahansa palvelupisteessä riippumatta siitä missä päin Suomea asiointisi kohteena oleva kiinteistö tai muu alue sijaitsee. | Maanmittauslaitos Helsinki | Opastinsilta 12 K | Semaforbron 12 K | Opastinsilta 12 K | http://www.maanmittauslaitos.fi | http://www.maanmittauslaitos.fi | http://www.maanmittauslaitos.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 29 530 1110 | asiakaspalvelu@maanmittauslaitos.fi | 2011-03-25T14:21:10+02:00 | 00520 | www.maanmittauslaitos.fi | kaikki | helsinki | 2020-11-05T16:31:11.074716+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, 1402] | helsinki | [322, 244] | [367, 247] | {} | Point | 24.93526 | 60.199146 | Lantmäteriverket Helsingfors | Maanmittauslaitoksen valtakunnallinen palvelupiste Helsingissä | 3 | 5 | 1 | 5 | Lantmäteriverkets riksomfattande serviceställe i Helsingfors | Vid Lantmäteriverkets serviceställen kan du få råd i lantmäteri- och inskrivningsärenden. Du kan också köpa registerutdrag och intyg, dokumentkopior och olika kartor och kartutskrifter. Våra serviceställen har tillgång till riksomfattande register, elektroniska arkiv och geodatamaterial. Du kan alltså få dina ärenden skötta vid vilket som helst av våra serviceställen oavsett var fastigheten eller området som ditt ärende gäller finns. | 5 | ||||||||||||||||||||||||||||||||
| 17904 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-to 09-15, pe 10-15", "sv": "\u00f6ppet m\u00e5n-tor 09-15, fre 10-15", "en": "open Mon-Thu 09-15, Fri 10-15"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Palvelut Suomi.fi-verkkopalvelussa", "sv": "Tj\u00e4nsterna i Suomi.fi-webbtj\u00e4nsten", "en": "Services in the Suomi.fi Web Service"}, "www": {"fi": "https://www.suomi.fi/palvelut/palvelupiste/xxx/b22da1ef-2a47-47ae-ab5d-d412958da965/palvelut?p=0", "sv": "https://www.suomi.fi/service/servicestalle/xxx/b22da1ef-2a47-47ae-ab5d-d412958da965/service?p=0", "en": "https://www.suomi.fi/services/servicepoint/xxx/b22da1ef-2a47-47ae-ab5d-d412958da965/services?p=0"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 31}, {"value": "false", "variable": 107}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 105}, {"value": "true", "variable": 104}, {"value": "false", "variable": 98}, {"value": "true", "variable": 106}, {"value": "false", "variable": 82}, {"value": "false", "variable": 84}, {"value": "false", "variable": 83}, {"value": "false", "variable": 80}, {"value": "short_term_stay", "variable": 60}, {"value": "under_20mm", "variable": 91}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "true", "variable": 57}, {"value": "false", "variable": 44}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "true", "variable": 53}, {"value": "true", "variable": 62}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 92}, {"value": "false", "variable": 79}, {"value": "false", "variable": 48}, {"value": "false", "variable": 49}, {"value": "true", "variable": 50}, {"value": "false", "variable": 38}, {"value": "true", "variable": 51}, {"value": "false", "variable": 34}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 102}, {"value": "true", "variable": 37}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 30}, {"value": "true", "variable": 58}, {"value": "handrails_on_both_sides", "variable": 32}, {"value": "true", "variable": 52}, {"value": "false", "variable": 33}, {"value": "at_least_4_steps", "variable": 24}, {"value": "true", "variable": 25}, {"value": "handrails_on_one_side", "variable": 26}, {"value": "true", "variable": 23}, {"value": "true", "variable": 20}, {"value": "false", "variable": 21}, {"value": "false", "variable": 27}, {"value": "false", "variable": 22}, {"value": "false", "variable": 28}, {"value": "true", "variable": 6}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 5}, {"value": "smooth", "variable": 17}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 59}, {"value": "false", "… | internal | 5086 | ptvout | b22da1ef-2a47-47ae-ab5d-d412958da965 | c5f6914f-302e-41cc-bed7-4d4215aac640 | c5f6914f-302e-41cc-bed7-4d4215aac640 | SELF_PRODUCED | state_service | valtion palvelu | statlig tjänst | state service | 1 | Kelan palvelupisteessä opastetaan ja neuvotaan kaikissa Kelan etuuksiin liittyvissä asioissa. Voit hakea etuuksia ja toimittaa liitteet myös asiointipalvelussamme osoitteessa www.kela.fi/asiointi. Lue myös mahdollisuudesta ajanvaraukseen: www.kela.fi/ajanvaraus. | Kela, Itäkeskuksen palvelupiste | Turunlinnantie 6 A | Åbohusvägen 6 A | Turunlinnantie 6 A | http://www.kela.fi/ | http://www.kela.fi/ | http://www.kela.fi/ | 2011-03-25T14:21:10+02:00 | 00930 | www.kela.fi | kaikki | helsinki | 2020-11-05T16:31:11.111803+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"} | [783, 1087, 1400, 1401] | helsinki | [4, 130, 188, 797, 1377, 843, 809] | [755, 711, 485, 370, 286, 143, 75] | {} | Point | 25.078514 | 60.210598 | PL 10, 00056 FPA | FPA, Servicestället i Östra centrum | Kelan palvelupiste | 2 | 2 | P.O. Box 10, 00056 FPA | 1 | 2 | PB 10, 00056 FPA | Fpa:s serviceställe | På FPA:s serviceställe kan du få information och rådgivning om alla FPA-förmåner. Du kan också ansöka om förmåner och lämna in bilagor i vår e-tjänst på adressen www.fpa.fi/etjanst. Läs mer om hur du bokar tid på adressen www.fpa.fi/tidsbokning. | 4 | ||||||||||||||||||||||||||||||||||
| 17911 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-to 09-15, pe 10-15", "sv": "\u00f6ppet m\u00e5n-tor 09-15, fre 10-15", "en": "open Mon-Thu 09-15, Fri 10-15"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Palvelut Suomi.fi-verkkopalvelussa", "sv": "Tj\u00e4nsterna i Suomi.fi-webbtj\u00e4nsten", "en": "Services in the Suomi.fi Web Service"}, "www": {"fi": "https://www.suomi.fi/palvelut/palvelupiste/xxx/ca992f8f-b674-48f2-881d-a6e4e69ffb45/palvelut?p=0", "sv": "https://www.suomi.fi/service/servicestalle/xxx/ca992f8f-b674-48f2-881d-a6e4e69ffb45/service?p=0", "en": "https://www.suomi.fi/services/servicepoint/xxx/ca992f8f-b674-48f2-881d-a6e4e69ffb45/services?p=0"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 37}, {"value": "false", "variable": 103}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 107}, {"value": "true", "variable": 105}, {"value": "true", "variable": 106}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 92}, {"value": "false", "variable": 98}, {"value": "false", "variable": 82}, {"value": "true", "variable": 57}, {"value": "false", "variable": 83}, {"value": "false", "variable": 84}, {"value": "false", "variable": 102}, {"value": "over_20mm", "variable": 56}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 62}, {"value": "true", "variable": 104}, {"value": "chairs_available", "variable": 81}, {"value": "true", "variable": 59}, {"value": "true", "variable": 58}, {"value": "false", "variable": 49}, {"value": "true", "variable": 50}, {"value": "false", "variable": 48}, {"value": "false", "variable": 44}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 22}, {"value": "true", "variable": 51}, {"value": "false", "variable": 38}, {"value": "false", "variable": 23}, {"value": "false", "variable": 29}, {"value": "true", "variable": 20}, {"value": "false", "variable": 21}, {"value": "false", "variable": 33}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 34}, {"value": "true", "variable": 52}, {"value": "over_10m", "variable": 4}, {"value": "false", "variable": 5}, {"value": "outdoors", "variable": 2}, {"value": "less_than_3600mm", "variable": 3}, {"value": "smooth", "variable": 17}, {"value": "sufficiently_wide", "variable": 18}, {"value": "2", "variable": 1}, {"value": "true", "variable": 53}, {"value": "true", "variable": 79}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 80}] | internal | 4981 | ptvout | ca992f8f-b674-48f2-881d-a6e4e69ffb45 | c5f6914f-302e-41cc-bed7-4d4215aac640 | c5f6914f-302e-41cc-bed7-4d4215aac640 | SELF_PRODUCED | state_service | valtion palvelu | statlig tjänst | state service | 1 | Kelan palvelupisteessä opastetaan ja neuvotaan kaikissa Kelan etuuksiin liittyvissä asioissa. Voit hakea etuuksia ja toimittaa liitteet myös asiointipalvelussamme osoitteessa www.kela.fi/asiointi. Lue myös mahdollisuudesta ajanvaraukseen: www.kela.fi/ajanvaraus. | Kela, Malmin palvelupiste | Soidintie 4 b | Orrspelsvägen 4 b | Soidintie 4 b | http://www.kela.fi | http://www.kela.fi | http://www.kela.fi | 2011-03-25T14:21:10+02:00 | 00700 | www.kela.fi | kaikki | helsinki | 2020-11-05T16:31:11.134491+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"} | [783, 1087, 1400, 1401] | helsinki | [4, 130, 188, 797, 1377, 843, 809] | [755, 711, 485, 370, 286, 143, 75] | {} | Point | 25.016256 | 60.252262 | PL 10, 00056 FPA | FPA, Servicestället i Malm | Kelan palvelupiste | 3 | 4 | P.O. Box 10, 00056 FPA | 1 | 4 | PB 10, 00056 FPA | Fpa:s serviceställe | På FPA:s serviceställe kan du få information och rådgivning om alla FPA-förmåner. Du kan också ansöka om förmåner och lämna in bilagor i vår e-tjänst på adressen www.fpa.fi/etjanst. Läs mer om hur du bokar tid på adressen www.fpa.fi/tidsbokning. | 2 |
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 );