37 rows where "last_modified_time" is on date 2020-09-04

View and edit SQL

Suggested facets: connections, accessibility_properties, department, root_department, provider_type, contract_type_id, contract_type_description_fi, contract_type_description_sv, contract_type_description_en, street_address_en, www_fi, www_sv, www_en, call_charge_info_fi, call_charge_info_sv, call_charge_info_en, phone, accessibility_phone, created_time, address_zip, data_source, extensions_maintenance_organization, accessibility_viewpoints, root_service_nodes, municipality, service_nodes, services, keywords, accessibility_shortcoming_count_reduced_mobility, accessibility_shortcoming_count_wheelchair, accessibility_shortcoming_count_rollator, accessibility_shortcoming_count_visually_impaired, created_time (date)

last_modified_time (date)

  • 2020-09-04 · 37

picture_entrance_url

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
15462 [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] [{"value": "true", "variable": 51}, {"value": "true", "variable": 20}, {"value": "false", "variable": 21}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 33}, {"value": "false", "variable": 23}, {"value": "false", "variable": 29}, {"value": "false", "variable": 22}, {"value": "false", "variable": 98}, {"value": "false", "variable": 34}, {"value": "true", "variable": 37}, {"value": "true", "variable": 50}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 44}, {"value": "false", "variable": 49}, {"value": "false", "variable": 48}, {"value": "false", "variable": 53}, {"value": "short_term_stay", "variable": 60}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "true", "variable": 52}, {"value": "true", "variable": 59}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 58}, {"value": "true", "variable": 57}, {"value": "false", "variable": 84}, {"value": "true", "variable": 62}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 79}, {"value": "false", "variable": 92}, {"value": "false", "variable": 80}, {"value": "false", "variable": 38}, {"value": "false", "variable": 82}, {"value": "false", "variable": 83}, {"value": "true", "variable": 115}, {"value": "false", "variable": 103}, {"value": "true", "variable": 109}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "false", "variable": 102}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 107}, {"value": "true", "variable": 104}, {"value": "false", "variable": 106}, {"value": "true", "variable": 105}, {"value": "true", "variable": 117}, {"value": "true", "variable": 114}, {"value": "true", "variable": 113}, {"value": "true", "variable": 112}, {"value": "true", "variable": 116}, {"value": "false", "variable": 111}, {"value": "on_door", "variable": 110}, {"value": "indoor_facility", "variable": 500}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 118}, {"… internal 4539     828201f3-df6c-42e5-8239-fac577c3b248 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Nöykkiön hammashoitola   Oxfotintie 8 Oxfotvägen 8   https://www.espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Hammashoito https://www.esbo.fi/sv-FI/Social_och_halsovard/Sjuk_och_halsovard/Tandvard https://www.espoo.fi/en-US/Social_and_health_services/Health_Services/Dental_care   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8163 0300   +358 9 8163 0300     2015-11-03T12:03:45+02:00 02070 www.espoo.fi kaikki espoo 2020-09-04T14:30:56.363649+03:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "red", "23": "green", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} [986] espoo [995] [184] {"fi": ["hammasl\u00e4\u00e4k\u00e4ri", "hammashoitolat", "suun terveydenhoito"]} Point 24.66458 60.166016               1 3         1     3         6      
15475 [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] [{"value": "false", "variable": 80}, {"value": "false", "variable": 29}, {"value": "false", "variable": 59}, {"value": "true", "variable": 78}, {"value": "true", "variable": 5}, {"value": "0", "variable": 1}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 23}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 6}, {"value": "false", "variable": 22}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 21}, {"value": "true", "variable": 20}, {"value": "true", "variable": 113}, {"value": "false", "variable": 33}, {"value": "true", "variable": 58}, {"value": "false", "variable": 44}, {"value": "false", "variable": 34}, {"value": "false", "variable": 38}, {"value": "false", "variable": 48}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 57}, {"value": "false", "variable": 49}, {"value": "true", "variable": 50}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 51}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "false", "variable": 53}, {"value": "false", "variable": 76}, {"value": "true", "variable": 72}, {"value": "false", "variable": 79}, {"value": "true", "variable": 112}, {"value": "2", "variable": 63}, {"value": "false", "variable": 62}, {"value": "true", "variable": 70}, {"value": "true", "variable": 75}, {"value": "opens_automatically", "variable": 77}, {"value": "true", "variable": 73}, {"value": "true", "variable": 74}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 111}, {"value": "true", "variable": 82}, {"value": "false", "variable": 98}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 92}, {"value": "false", "variable": 83}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 84}, {"value": "false", "variable": 102}, {"value": "false", "variable": 105}, {"value": "true", "variable": 104}, {"value": "false", "variable": 103}, {"value": "on_door", "variable": 110}, {"v… internal 4650     828201f3-df6c-42e5-8239-fac577c3b248 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Kivenlahden hammashoitola   Meriusva 3 Sjöröken 3   https://www.espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Hammashoito https://www.esbo.fi/sv-FI/Social_och_halsovard/Sjuk_och_halsovard/Tandvard https://www.espoo.fi/en-US/Social_and_health_services/Health_Services/Dental_care   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8163 0300   +358 9 8163 5200     2015-11-03T12:03:45+02:00 02070 www.espoo.fi kaikki espoo 2020-09-04T14:30:56.401730+03:00 {"00": null, "11": "green", "12": "red", "13": "green", "21": "green", "22": "red", "23": "green", "31": "green", "32": "red", "33": "green", "41": "green", "51": "red", "52": "red", "61": "red"} [986] espoo [995] [184] {"fi": ["hammasl\u00e4\u00e4k\u00e4ri", "hammashoitolat", "suun terveydenhoito"]} Point 24.635641 60.154816               1 1         1     1         5      
15480 [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] [{"value": "true", "variable": 57}, {"value": "true", "variable": 20}, {"value": "outdoors", "variable": 2}, {"value": "true", "variable": 115}, {"value": "false", "variable": 92}, {"value": "2", "variable": 1}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 5}, {"value": "under_10m", "variable": 4}, {"value": "less_than_3600mm", "variable": 3}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 6}, {"value": "smooth", "variable": 17}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 22}, {"value": "false", "variable": 21}, {"value": "false", "variable": 23}, {"value": "false", "variable": 34}, {"value": "false", "variable": 29}, {"value": "false", "variable": 52}, {"value": "false", "variable": 48}, {"value": "false", "variable": 38}, {"value": "false", "variable": 33}, {"value": "false", "variable": 44}, {"value": "false", "variable": 49}, {"value": "true", "variable": 51}, {"value": "true", "variable": 50}, {"value": "true", "variable": 114}, {"value": "under_20mm", "variable": 91}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 70}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 58}, {"value": "false", "variable": 62}, {"value": "false", "variable": 59}, {"value": "true", "variable": 78}, {"value": "true", "variable": 74}, {"value": "true", "variable": 73}, {"value": "true", "variable": 72}, {"value": "2", "variable": 63}, {"value": "true", "variable": 75}, {"value": "opens_automatically", "variable": 77}, {"value": "true", "variable": 76}, {"value": "true", "variable": 113}, {"value": "true", "variable": 104}, {"value": "false", "variable": 84}, {"value": "false", "variable": 83}, {"value": "true", "variable": 82}, {"value": "false", "variable": 79}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 80}, {"value": "floor_2", "variable": 108}, {"value": "true", "variabl… internal 4809     828201f3-df6c-42e5-8239-fac577c3b248 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Leppävaaran hammashoitola   Konstaapelinkatu 2, 2. krs Konstapelsgatan 2, 2. vån. Konstaapelinkatu 2, 2. floor https://www.espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Hammashoito https://www.esbo.fi/sv-FI/Social_och_halsovard/Sjuk_och_halsovard/Tandvard https://www.espoo.fi/en-US/Social_and_health_services/Health_Services/Dental_care   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8163 0300   +358 9 8163 0300     2015-11-03T12:03:45+02:00 02650 www.espoo.fi kaikki espoo 2020-09-04T13:30:51.669266+03:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "red", "23": "green", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} [986] espoo [995] [184] {"fi": ["hammasl\u00e4\u00e4k\u00e4ri", "hammashoitolat", "suun terveydenhoito"]} Point 24.813969 60.221733 PL 2119, 02070 Espoon kaupunki           Oikomishoito 1 2       P.O. Box 2119, 02070 Espoon kaupunki 1     2   PB 2119, 02070 Espoon kaupunki Tandreglering   2 Orthodontics    
15589 [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] [{"value": "true", "variable": 105}, {"value": "false", "variable": 102}, {"value": "false", "variable": 104}, {"value": "false", "variable": 103}, {"value": "false", "variable": 98}, {"value": "less_than_3600mm", "variable": 3}, {"value": "outdoors", "variable": 2}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "narrow", "variable": 18}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 70}, {"value": "true", "variable": 6}, {"value": "true", "variable": 5}, {"value": "under_10m", "variable": 4}, {"value": "false", "variable": 21}, {"value": "false", "variable": 34}, {"value": "true", "variable": 20}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 23}, {"value": "false", "variable": 33}, {"value": "false", "variable": 29}, {"value": "false", "variable": 22}, {"value": "2", "variable": 63}, {"value": "false", "variable": 53}, {"value": "false", "variable": 38}, {"value": "true", "variable": 37}, {"value": "false", "variable": 51}, {"value": "false", "variable": 48}, {"value": "false", "variable": 49}, {"value": "true", "variable": 50}, {"value": "false", "variable": 44}, {"value": "false", "variable": 62}, {"value": "requires_use_of_buzzer_opening_easily_manually", "variable": 54}, {"value": "true", "variable": 52}, {"value": "false", "variable": 59}, {"value": "false", "variable": 55}, {"value": "false", "variable": 57}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 84}, {"value": "false", "variable": 75}, {"value": "true", "variable": 74}, {"value": "true", "variable": 72}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 73}, {"value": "false", "variable": 83}, {"value": "true", "variable": 82}, {"value": "true", "variable": 76}, {"value": "opens_automatically", "variable": 77}, {"value": "chairs_available", "variable": 81}, {"value": "true", "variable": 78}, {"value": "false", "variable": 80}, {"value": "false", "variable": 79}, {"value": "indoor_facility", "variable": 500}, {"value"… internal 4490     828201f3-df6c-42e5-8239-fac577c3b248 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Espoonlahden hammashoitola Espoonlahti Dental Clinic Merikansantie 4 Sjöfolksvägen 4 Merikansantie 4 https://www.espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Hammashoito https://www.esbo.fi/sv-FI/Social_och_halsovard/Sjuk_och_halsovard/Tandvard https://www.espoo.fi/en-US/Social_and_health_services/Health_Services/Dental_care   Esim. 1 €/puhelu + 0,90€/min + pvm/mpm Esim. 1 €/telefonsamtal + 0,90€/min + msa/lna Esim. 1 €/call + 0,90€/min + mobile call charge / local network charge   +358 9 8163 0300   +358 9 8163 0300     2015-11-03T12:03:45+02:00 02320 www.espoo.fi kaikki espoo 2020-09-04T14:30:56.720801+03:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "red", "23": "green", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [986] espoo [995] [184] {"fi": ["hammasl\u00e4\u00e4k\u00e4ri", "hammashoitolat", "suun terveydenhoito"]} Point 24.66203 60.149155 PL 2400, 02070 PL 2402, 02070 ESPOON KAUPUNKI         Esbovikens tandklinik   1 2     1 P.O. Box 2400, 02070 P.O. Box 2400, 02070 City of Espoo 1     2   PB 2400, 02070 PB 2400, 02070 ESBO STAD     8      
15671 [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] [{"value": "true", "variable": 107}, {"value": "true", "variable": 113}, {"value": "true", "variable": 105}, {"value": "false", "variable": 106}, {"value": "true", "variable": 112}, {"value": "under_10m", "variable": 4}, {"value": "opens_easily_manually", "variable": 15}, {"value": "false", "variable": 103}, {"value": "false", "variable": 22}, {"value": "at_least_3600mm", "variable": 3}, {"value": "parking_hall", "variable": 2}, {"value": "9", "variable": 1}, {"value": "indoors_but_not_service_point", "variable": 9}, {"value": "true", "variable": 5}, {"value": "true", "variable": 20}, {"value": "true", "variable": 14}, {"value": "true", "variable": 6}, {"value": "true", "variable": 8}, {"value": "false", "variable": 7}, {"value": "true", "variable": 13}, {"value": "true", "variable": 11}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 10}, {"value": "true", "variable": 12}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 16}, {"value": "false", "variable": 23}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 111}, {"value": "true", "variable": 104}, {"value": "false", "variable": 29}, {"value": "false", "variable": 34}, {"value": "false", "variable": 33}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 49}, {"value": "true", "variable": 52}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 44}, {"value": "true", "variable": 37}, {"value": "true", "variable": 50}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "false", "variable": 53}, {"value": "true", "variable": 51}, {"value": "true", "variable": 80}, {"value": "true", "variable": 58}, {"value": "false", "variable": 102}, {"value": "true", "variable": 57}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 59}, {"value": "false", "variable": 79}, {"value": "true", "variable": 62}, {"value": "false", "variable": 48}, {"value": "false", "variable": 98}, {"value": "wait… internal 4497     828201f3-df6c-42e5-8239-fac577c3b248 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Espoo hammashoidon arkipäivystys   Karvasmäentie 6, 1. krs Karvasbackavägen 6, 1. vån. Karvasmäentie 6, 1. floor https://www.espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Hammashoito https://www.esbo.fi/sv-FI/Social_och_halsovard/Sjuk_och_halsovard/Tandvard https://www.espoo.fi/en-US/Social_and_health_services/Health_Services/Dental_care   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8163 5900         2015-11-03T12:03:45+02:00 02740 www.espoo.fi kaikki espoo 2020-09-04T14:30:56.993080+03:00 {"00": null, "11": "green", "12": "green", "13": "green", "21": "green", "22": "green", "23": "green", "31": "green", "32": "green", "33": "green", "41": "green", "51": "red", "52": "red", "61": "green"} [986] espoo [995] [184] {"fi": ["arkip\u00e4ivystys", "hammashoitolat", "suun terveydenhoito", "p\u00e4ivystys"]} Point 24.684149 60.221165 PL 2550, 02070 Espoon kaupunki         Tandvårdens vardagsjour i Esbo Hammashoidon arkipäivystys           P.O. Box 2550, 02070 Espoon kaupunki           PB 2550, 02070 ESBO STAD     3      
15688 [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] [{"value": "false", "variable": 100}, {"value": "false", "variable": 111}, {"value": "false", "variable": 94}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 112}, {"value": "true", "variable": 113}, {"value": "false", "variable": 106}, {"value": "true", "variable": 107}, {"value": "floor_2", "variable": 108}, {"value": "true", "variable": 105}, {"value": "no_handrails", "variable": 101}, {"value": "false", "variable": 102}, {"value": "false", "variable": 103}, {"value": "true", "variable": 104}, {"value": "false", "variable": 96}, {"value": "false", "variable": 97}, {"value": "true", "variable": 98}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "true", "variable": 109}, {"value": "true", "variable": 114}, {"value": "ramp_under_6m_long", "variable": 99}, {"value": "false", "variable": 83}, {"value": "false", "variable": 84}, {"value": "false", "variable": 33}, {"value": "at_least_4_turning_steps", "variable": 93}, {"value": "true", "variable": 82}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 79}, {"value": "true", "variable": 80}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 62}, {"value": "short_term_stay", "variable": 60}, {"value": "2", "variable": 63}, {"value": "false", "variable": 59}, {"value": "false", "variable": 58}, {"value": "true", "variable": 57}, {"value": "false", "variable": 70}, {"value": "true", "variable": 52}, {"value": "requires_use_of_buzzer_and_is_heavy", "variable": 54}, {"value": "false", "variable": 46}, {"value": "false", "variable": 53}, {"value": "false", "variable": 49}, {"value": "false", "variable": 50}, {"value": "true", "variable": 92}, {"value": "false", "variable": 51}, {"value": "false", "variable": 55}, {"value": "true", "variable": 44}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "no_handrails", "variable": 47}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 115}, {"value": "false", "variable": 48}, {"value": "at_least_4_turning_steps", … internal 4527     828201f3-df6c-42e5-8239-fac577c3b248 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Samarian hammashoitola   Terveyskuja 2 Hälsogränden 2   https://www.espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Hammashoito https://www.esbo.fi/sv-FI/Social_och_halsovard/Sjuk_och_halsovard/Tandvard https://www.espoo.fi/en-US/Social_and_health_services/Health_Services/Dental_care   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8163 0300   +358 9 8163 0300     2015-11-03T12:03:45+02:00 02070 www.espoo.fi kaikki espoo 2020-09-04T14:30:57.074148+03:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [986] espoo [995] [184] {"fi": ["hammasl\u00e4\u00e4k\u00e4ri", "hammashoitolat", "suun terveydenhoito"]} Point 24.653416 60.20247               8 12     2   1     9         17      
15725 [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] [{"value": "true", "variable": 114}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 92}, {"value": "true", "variable": 115}, {"value": "false", "variable": 116}, {"value": "true", "variable": 109}, {"value": "on_door", "variable": 110}, {"value": "false", "variable": 111}, {"value": "false", "variable": 102}, {"value": "false", "variable": 106}, {"value": "true", "variable": 107}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "true", "variable": 117}, {"value": "true", "variable": 112}, {"value": "false", "variable": 98}, {"value": "false", "variable": 103}, {"value": "true", "variable": 104}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 113}, {"value": "true", "variable": 105}, {"value": "false", "variable": 79}, {"value": "true", "variable": 80}, {"value": "chairs_available", "variable": 81}, {"value": "true", "variable": 62}, {"value": "true", "variable": 59}, {"value": "true", "variable": 57}, {"value": "false", "variable": 82}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 49}, {"value": "under_20mm", "variable": 56}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "false", "variable": 38}, {"value": "true", "variable": 52}, {"value": "false", "variable": 83}, {"value": "true", "variable": 58}, {"value": "false", "variable": 53}, {"value": "true", "variable": 37}, {"value": "false", "variable": 44}, {"value": "false", "variable": 48}, {"value": "false", "variable": 22}, {"value": "false", "variable": 33}, {"value": "false", "variable": 34}, {"value": "true", "variable": 50}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 20}, {"value": "false", "variable": 23}, {"value": "false", "variable": 21}, {"value": "false", "variable": 51}, {"value": "false", "variable": 84}, {"value": "false", "variable": 29}, {"value": "less_than_3600mm", "variable": 3}, {"value": "over_10m", "variable": 4}, {"value": "true", "variable": 5}, {"value": "2", "… internal 4787     828201f3-df6c-42e5-8239-fac577c3b248 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Kalajärven hammashoitola   Ruskaniitty 4 Höstglödsängen 4   https://www.espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Hammashoito https://www.espoo.fi/en-US/Social_and_health_services/Health_Services/Dental_care https://www.espoo.fi/en-US/Social_and_health_services/Health_Services/Dental_care   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8163 0300   +358 9 8163 0300     2015-11-03T12:03:45+02:00 02070 www.espoo.fi kaikki espoo 2020-09-04T14:30:57.163714+03:00 {"00": null, "11": "green", "12": "red", "13": "green", "21": "green", "22": "red", "23": "green", "31": "green", "32": "red", "33": "green", "41": "green", "51": "red", "52": "red", "61": "red"} [986] espoo [995] [184] {"fi": ["hammasl\u00e4\u00e4k\u00e4ri", "hammashoitolat", "suun terveydenhoito"]} Point 24.740208 60.306164               1 1         1     1         5      
15764 [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] [{"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 98}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "true", "variable": 109}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 107}, {"value": "false", "variable": 102}, {"value": "true", "variable": 104}, {"value": "true", "variable": 111}, {"value": "false", "variable": 105}, {"value": "false", "variable": 84}, {"value": "true", "variable": 20}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 82}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 92}, {"value": "true", "variable": 112}, {"value": "false", "variable": 83}, {"value": "opens_automatically", "variable": 77}, {"value": "false", "variable": 38}, {"value": "true", "variable": 78}, {"value": "true", "variable": 76}, {"value": "true", "variable": 74}, {"value": "true", "variable": 70}, {"value": "true", "variable": 75}, {"value": "false", "variable": 79}, {"value": "false", "variable": 62}, {"value": "2", "variable": 63}, {"value": "true", "variable": 72}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 113}, {"value": "true", "variable": 73}, {"value": "true", "variable": 80}, {"value": "false", "variable": 59}, {"value": "true", "variable": 52}, {"value": "true", "variable": 53}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "true", "variable": 51}, {"value": "false", "variable": 48}, {"value": "false", "variable": 49}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 50}, {"value": "false", "variable": 34}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 37}, {"value": "false", "variable": 33}, {"value": "false", "variable": 23}, {"value": "false", "variable": 44}, {"value": "true", "variable": 57}, {"value": "false", "variable": 29}, {"value": "sufficiently_wide", "variable": 18}, {"value": "guided_and_clear", "variable": 19}, {"value": "smooth", "variable": 17}, {"… internal 4655     828201f3-df6c-42e5-8239-fac577c3b248 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Tapiolan hammashoitola   Ahertajantie 2 Flitarvägen 2   https://www.espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Hammashoito https://www.esbo.fi/sv-FI/Social_och_halsovard/Sjuk_och_halsovard/Tandvard https://www.espoo.fi/en-US/Social_and_health_services/Health_Services/Dental_care   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8163 0300   +358 9 8163 0300 reima.wagg@espoo.fi   2015-11-03T12:03:45+02:00 02070 www.espoo.fi kaikki espoo 2020-09-04T14:30:57.247453+03:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "red", "23": "green", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} [986] espoo [995] [184] {"fi": ["hammasl\u00e4\u00e4k\u00e4ri", "hammashoitolat", "suun terveydenhoito"]} Point 24.797804 60.178467               1 2         1     2         2      
15808 [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] [{"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 94}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 6}, {"value": "true", "variable": 5}, {"value": "0", "variable": 1}, {"value": "false", "variable": 22}, {"value": "3_consecutive_steps", "variable": 93}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 20}, {"value": "false", "variable": 29}, {"value": "false", "variable": 23}, {"value": "false", "variable": 21}, {"value": "true", "variable": 37}, {"value": "true", "variable": 53}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 34}, {"value": "true", "variable": 51}, {"value": "true", "variable": 50}, {"value": "false", "variable": 44}, {"value": "false", "variable": 49}, {"value": "false", "variable": 48}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "false", "variable": 38}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 52}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 59}, {"value": "true", "variable": 58}, {"value": "true", "variable": 57}, {"value": "true", "variable": 80}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 79}, {"value": "true", "variable": 62}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 84}, {"value": "false", "variable": 83}, {"value": "false", "variable": 82}, {"value": "true", "variable": 106}, {"value": "false", "variable": 97}, {"value": "true", "variable": 109}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "true", "variable": 96}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "true", "variable": 105}, {"value": "false", "variable": 100}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 99}, {"value": "true", "variable": 92}, {"value": "true", "variable": 104}, {"value": "handrails_on_one_side", "variable": 101}, {"value": "false", "variable": 103}, {"value": "… internal 4717     828201f3-df6c-42e5-8239-fac577c3b248 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Ruusulinnan hammashoitola   Huvilinnantie 4 Lustslottsvägen 4   https://www.espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Hammashoito https://www.esbo.fi/sv-FI/Social_och_halsovard/Sjuk_och_halsovard/Tandvard https://www.espoo.fi/en-US/Social_and_health_services/Health_Services/Dental_care   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8163 0300   +358 9 8163 0300     2015-11-03T12:03:45+02:00 02070 www.espoo.fi kaikki espoo 2020-09-04T14:30:57.397967+03:00 {"00": null, "11": "green", "12": "red", "13": "green", "21": "green", "22": "red", "23": "green", "31": "green", "32": "red", "33": "green", "41": "green", "51": "red", "52": "red", "61": "red"} [986] espoo [995] [184] {"fi": ["hammasl\u00e4\u00e4k\u00e4ri", "hammashoitolat", "suun terveydenhoito"]} Point 24.806664 60.214886               1 1         1     1         2      
15831 [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] [{"value": "false", "variable": 21}, {"value": "true", "variable": 23}, {"value": "guided_and_clear", "variable": 19}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 20}, {"value": "2_consecutive_steps", "variable": 24}, {"value": "true", "variable": 25}, {"value": "true", "variable": 5}, {"value": "true", "variable": 6}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 98}, {"value": "less_than_3600mm", "variable": 3}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 106}, {"value": "false", "variable": 107}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 103}, {"value": "true", "variable": 104}, {"value": "true", "variable": 105}, {"value": "true", "variable": 88}, {"value": "false", "variable": 92}, {"value": "false", "variable": 102}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 79}, {"value": "false", "variable": 83}, {"value": "true", "variable": 62}, {"value": "true", "variable": 57}, {"value": "true", "variable": 58}, {"value": "true", "variable": 84}, {"value": "true", "variable": 59}, {"value": "true", "variable": 53}, {"value": "opens_easily_manually", "variable": 54}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 52}, {"value": "true", "variable": 86}, {"value": "true", "variable": 40}, {"value": "true", "variable": 51}, {"value": "false", "variable": 85}, {"value": "false", "variable": 46}, {"value": "no_handrails", "variable": 47}, {"value": "false", "variable": 48}, {"value": "ramp_over_6m_long_with_intermediate_landing", "variable": 45}, {"value": "no_handrails", "variable": 41}, {"value": "false", "variable": 43}, {"value": "false", "variable": 49}, {"value": "true", "variable": 44}, {"value": "false", "variable": 33}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 38}, {"value": "false", "variable": 34}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "true", "variable": 37}, {"value": "true",… internal 4870     828201f3-df6c-42e5-8239-fac577c3b248 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Haukilahden hammashoitola   Haukilahdenkatu 19 Gäddviksgatan 19   https://www.espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Hammashoito https://www.esbo.fi/sv-FI/Social_och_halsovard/Sjuk_och_halsovard/Tandvard https://www.espoo.fi/en-US/Social_and_health_services/Health_Services/Dental_care   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8163 0300   +358 9 8163 0300     2015-11-03T12:03:45+02:00 02070 www.espoo.fi kaikki espoo 2020-09-04T13:30:52.554475+03: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": "green"} [986] espoo [995] [184] {"fi": ["hammasl\u00e4\u00e4k\u00e4ri", "hammashoitolat", "suun terveydenhoito"]} Point 24.777496 60.162254               4 4               2         6      
53070 [] [{"value": "true", "variable": 10}, {"value": "true", "variable": 13}, {"value": "at_least_3600mm", "variable": 3}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 7}, {"value": "parking_hall", "variable": 2}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 84}, {"value": "true", "variable": 115}, {"value": "true", "variable": 37}, {"value": "true", "variable": 105}, {"value": "false", "variable": 103}, {"value": "false", "variable": 79}, {"value": "true", "variable": 62}, {"value": "short_term_stay", "variable": 60}, {"value": "more_than_10", "variable": 1}, {"value": "false", "variable": 5}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 34}, {"value": "true", "variable": 50}, {"value": "under_10m", "variable": 4}, {"value": "true", "variable": 11}, {"value": "true", "variable": 8}, {"value": "true", "variable": 14}, {"value": "true", "variable": 12}, {"value": "true", "variable": 106}, {"value": "false", "variable": 33}, {"value": "false", "variable": 23}, {"value": "false", "variable": 92}, {"value": "true", "variable": 51}, {"value": "true", "variable": 53}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 21}, {"value": "false", "variable": 38}, {"value": "true", "variable": 57}, {"value": "false", "variable": 29}, {"value": "true", "variable": 59}, {"value": "true", "variable": 58}, {"value": "false", "variable": 49}, {"value": "false", "variable": 48}, {"value": "false", "variable": 44}, {"value": "true", "variable": 52}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 82}, {"value": "false", "variable": 111}, {"value": "chairs_available", "variable": 81}, {"value": "true", "variable": 80}, {"value": "on_door", "variable": 110}, {"value": "false", "variable": 83}, {"value": "true", "variable": 109}, {"value": "false", "variable": 98}, {"value": "same_floor_as_service_point", "variable": 108}, {"val… internal 22779     828201f3-df6c-42e5-8239-fac577c3b248 520a4492-cb78-498b-9c82-86504de88dce             1                   Espoon sairaalan hammashoitola   Karvasmäentie 6 Karvasbackavägen 6 Karvasmäentie 6 http://www.espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Suun_terveydenhuolto/Hammashoitolat http://www.esbo.fi/sv-FI/Social_och_halsovard/Sjuk_och_halsovard/Munhalsovard/Tandkliniker http://www.espoo.fi/en-US/Social_and_health_services/Health_Services/Dentists/Dental_clinics               +358 9 8163 0300     2017-03-24T12:58:58+02:00 02740 www.espoo.fi kaikki espoo 2020-09-04T13:31:35.855286+03: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": "green"} [986] espoo [995] [184] {} Point 24.684149 60.221165               2 2               2         3      
56627 [{"section_type": "OPENING_HOURS", "name": {"fi": "Ks. ravintoloiden aukioloajat kotisivuilta", "en": "Please see restaurant opening hours on the webpages"}, "www": null, "email": null, "phone": null, "contact_person": null}] [] internal 25713 visithelsinki 3226 0c71aa86-f76c-466b-b6f3-81143bd9eecc 83e74666-0836-4c1d-948a-4b34a8b90301 UNKNOWN_PRODUCTION_METHOD   private_service yksityinen palvelu privat tjänst private service 1             Kaupungin sydämessä kattojen ylle avautuvassa Korttelissa voit nousta arjen yläpuolelle nauttimaan herkullisista ruoista ja juomista, huippupalveluista sekä upeista näkymistä.Bar Cón, Beijing8, Bastardo, Fisken På Disken, Hoku, La Torrefazione, Lie Mi, Lopez y Lopez, Maxine, Pobre, Sandro, Soup & More, The Souk & Story. Kortteli is a block ("kortteli") of restaurants in Kamppi shopping centre. Enjoy the tasty treats of the restaurants, the quality services and the exceptional views over the city. Bar Cón, Beijing8, Bastardo, Fisken På Disken, Hoku, La Torrefazione, Lie Mi, Lopez y Lopez, Maxine, Pobre, Sandro, Soup & More, The Souk & Story.   Kortteli Kortteli Urho Kekkosenkatu 1, Kampin Kauppakeskus 5 krs   Urho Kekkosenkatu 1, Kamppi shopping centre 5.fl https://kamppihelsinki.fi/fi/kortteli https://kamppihelsinki.fi/fi/kortteli https://kamppihelsinki.fi/en                     2018-03-08T01:21:32+02:00 00100 www.myhelsinki.fi kaikki helsinki 2020-09-04T07:31:52.551069+03:00   [1403] helsinki [751] [577] {} Point 24.93365 60.1694                                                  
62935 [] [{"value": "true", "variable": 75}, {"value": "true", "variable": 20}, {"value": "true", "variable": 115}, {"value": "false", "variable": 62}, {"value": "3", "variable": 63}, {"value": "false", "variable": 34}, {"value": "true", "variable": 80}, {"value": "outdoors", "variable": 2}, {"value": "chairs_available", "variable": 81}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 33}, {"value": "false", "variable": 103}, {"value": "false", "variable": 53}, {"value": "true", "variable": 117}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 6}, {"value": "under_10m", "variable": 4}, {"value": "2", "variable": 1}, {"value": "false", "variable": 49}, {"value": "true", "variable": 118}, {"value": "false", "variable": 29}, {"value": "false", "variable": 102}, {"value": "true", "variable": 37}, {"value": "true", "variable": 82}, {"value": "true", "variable": 73}, {"value": "guided_and_clear", "variable": 19}, {"value": "sufficiently_wide", "variable": 18}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "true", "variable": 106}, {"value": "false", "variable": 23}, {"value": "true", "variable": 50}, {"value": "false", "variable": 48}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 109}, {"value": "true", "variable": 70}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 84}, {"value": "true", "variable": 105}, {"value": "true", "variable": 111}, {"value": "over_20mm", "variable": 56}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 104}, {"value": "true", "variable": 113}, {"value": "false", "variable": 38}, {"value": "true", "variable": 72}, {"value": "true", "variable": 107}, {"value": "true", "variable": 51}, {"value": "true", "variable": 52}, {"value": "false", "variable": 83}, {"value": "false", "variable": 98}, {"value": "true", "variable": 57}, {"value": "true", "variable": 58}, {"value": "true", "variable": 78}, {"value": "opens_automatically", "variable": 77}, {… internal 31737     828201f3-df6c-42e5-8239-fac577c3b248 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Kilon hammashoitola Kilo Dental Clinic Trillakatu 5 (3. ja, 4. krs) Trillagatan 5 (3. ja, 4. vån.) Trillakatu 5 (3. ja, 4. floor) https://www.espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Hammashoito https://www.esbo.fi/sv-FI/Social_och_halsovard/Sjuk_och_halsovard/Tandvard https://www.espoo.fi/en-US/Social_and_health_services/Health_Services/Dental_care   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8163 0300   +358 9 8163 0300     2020-08-04T10:57:25+03:00 02610 www.espoo.fi kaikki espoo 2020-09-04T13:32:00.086434+03:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "red", "23": "green", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "green"} [986] espoo [995] [184] {} Point 24.785938 60.218117           Kilo tandklinik   1 2               2         3      
63001 [] [] internal 31803     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Katri Valan puisto Chessboard, Katri Valan puisto Katri Valan puisto Katri Valas park Katri Valan puisto                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:09.564699+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 24.962854 60.18682           Schackbräde, Katri Valan puisto                                      
63002 [] [] internal 31804     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilaudat, Kaivopuisto Chessboards, Kaivopuisto Kaivopuisto Brunnsparken Kaivopuisto                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:09.586587+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 24.952223 60.1554           Schackbräden, Kaivopuisto                                      
63003 [] [] internal 31805     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Ruoholahdentori Chessboard, Ruoholahdentori Ruoholahdentori Gräsvikstorget Ruoholahdentori                           2020-09-04T05:22:19+03:00 00180 www.hel.fi kaikki helsinki 2020-09-04T08:32:09.607124+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 24.91292 60.161972           Schackbräde, Ruoholahdentori                                      
63004 [] [] internal 31806     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilaudat, Rastilankallio Chessboards, Rastilankallio Rastilankallio Rastböleberget Rastilankallio                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:09.627103+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 25.123037 60.206528           Schackbräden, Rastilankallio                                      
63005 [] [] internal 31807     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Taloustirehtöörinpuisto Chessboard, Taloustirehtöörinpuisto Taloustirehtöörinpuisto Ekonomidirektörsparken Taloustirehtöörinpuisto                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:09.650811+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 24.924284 60.197258           Schackbräde, Taloustirehtöörinpuisto                                      
63006 [] [] internal 31808     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilaudat, Tuorinniemenpuisto Chessboards, Tuorinniemenpuisto Tuorinniemenpuisto Torsnäsparken Tuorinniemenpuisto                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:09.670541+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 25.035769 60.185673           Schackbräden, Tuorinniemenpuisto                                      
63007 [] [] internal 31809     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Kumtähdenkenttä Chessboard, Kumtähdenkenttä Kumtähdenkenttä Gumtäkts äng Kumtähdenkenttä                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:09.690946+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 24.966797 60.20356           Schackbräde, Kumtähdenkenttä                                      
63008 [] [] internal 31810     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Linnanpuisto Chessboard, Linnanpuisto Linnanpuisto Slottsparken Linnanpuisto                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:09.709665+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 24.968748 60.167606           Schackbräde, Linnanpuisto                                      
63009 [] [] internal 31811     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Tilkantori Chessboard, Tilkantori Tilkantori Tilktorget Tilkantori                           2020-09-04T05:22:19+03:00 00300 www.hel.fi kaikki helsinki 2020-09-04T08:32:09.729090+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 24.8937 60.202652           Schackbräde, Tilkantori                                      
63010 [] [] internal 31812     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Mustankivenpuisto Chessboard, Mustankivenpuisto Mustankivenpuisto Svartstensparken Mustankivenpuisto                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:09.746444+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 25.143642 60.20532           Schackbräde, Mustankivenpuisto                                      
63011 [] [] internal 31813     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Von Glanin puisto Chessboard, Von Glanin puisto Von Glanin puisto von Glansparken von Glanin puisto                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:09.763759+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 24.867647 60.247047           Schackbräde, Von Glanin puisto                                      
63012 [] [] internal 31814     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Leikkipuisto Roihuvuori Chessboard, Leikkipuisto Roihuvuori Leikkipuisto Roihuvuori   Helsinki                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:09.782531+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 25.061424 60.20262           Schackbräde, Leikkipuisto Roihuvuori                                      
63013 [] [] internal 31815     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Puistometsä Chessboard, Puistometsä Puistometsä   Helsinki                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:09.803760+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 24.898638 60.232067           Schackbräde, Puistometsä                                      
63014 [] [] internal 31816     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Leikkipuisto Tervapääsky Chessboard, Leikkipuisto Tervapääsky Leikkipuisto Tervapääsky   Helsinki                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:09.822258+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 24.992298 60.261044           Schackbräde, Leikkipuisto Tervapääsky                                      
63015 [] [] internal 31817     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Vuorimiehenpuistikko Chessboard, Vuorimiehenpuistikko Vuorimiehenpuistikko Bergmansskvären Vuorimiehenpuistikko                           2020-09-04T05:22:19+03:00 00140 www.hel.fi kaikki helsinki 2020-09-04T08:32:09.842879+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 24.946993 60.159206           Schackbräde, Vuorimiehenpuistikko                                      
63016 [] [] internal 31818     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilaudat, Hesperianpuisto Chessboards, Hesperianpuisto Hesperianpuisto   Helsinki                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:09.862106+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 24.930431 60.178135           Schackbräden, Hesperianpuisto                                      
63017 [] [] internal 31819     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Leikkipuisto Nurkka Chessboard, Leikkipuisto Nurkka Leikkipuisto Nurkka   Helsinki                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:09.884796+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 25.057623 60.27118           Schackbräde, Leikkipuisto Nurkka                                      
63018 [] [] internal 31820     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Pasilan puistotie Chessboard, Pasilan puistotie Pasilan puistotie Böle parkväg Pasilan puistotie                           2020-09-04T05:22:19+03:00 00240 www.hel.fi kaikki helsinki 2020-09-04T08:32:09.914785+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 24.924208 60.20017           Schackbräde, Pasilan puistotie                                      
63019 [] [] internal 31821     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Niittyvillanpuisto Chessboard, Niittyvillanpuisto Niittyvillanpuisto   Helsinki                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:09.940271+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 25.089174 60.208855           Schackbräde, Niittyvillanpuisto                                      
63020 [] [] internal 31822     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Myllynsiipi kirkkopuisto Chessboard, Myllynsiipi kirkkopuisto Myllynsiipi kirkkopuisto   Helsinki                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:09.961607+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 25.066212 60.223972           Schackbräde, Myllynsiipi kirkkopuisto                                      
63021 [] [] internal 31823     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Satumaanpuisto Chessboard, Satumaanpuisto Satumaanpuisto   Helsinki                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:09.978802+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 25.057695 60.196426           Schackbräde, Satumaanpuisto                                      
63022 [] [] internal 31824     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilaudat, Muusantori Chessboards, Muusantori Muusantori Musans torg Muusantori                           2020-09-04T05:22:19+03:00 00350 www.hel.fi kaikki helsinki 2020-09-04T08:32:09.995203+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 24.855682 60.20701           Schackbräden, Muusantori                                      
63023 [] [] internal 31825     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Leikkipaikka Savela Chessboard, Leikkipaikka Savela Leikkipaikka Savela   Helsinki                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:10.013314+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 24.989841 60.23834           Schackbräde, Leikkipaikka Savela                                      
63024 [] [] internal 31826     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Shakkilauta, Leikkipuisto Viikkari Chessboard, Leikkipuisto Viikkari Leikkipuisto Viikkari   Helsinki                           2020-09-04T05:22:19+03:00   www.hel.fi kaikki helsinki 2020-09-04T08:32:10.030432+03:00   [1400, 1403] helsinki [2236, 2237] [912] {} Point 25.033325 60.230114           Schackbräde, Leikkipuisto Viikkari                                      

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