unit
20 rows where "last_modified_time" is on date 2020-05-05
This data as json, CSV (advanced)
Suggested facets: www_fi, www_sv, www_en, email, accessibility_viewpoints, municipality, service_nodes, accessibility_shortcoming_count_wheelchair, accessibility_shortcoming_count_rollator
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18321 | [{"section_type": "OPENING_HOURS", "name": {"fi": "COVID-19: Kiirreellinen hammashoito puh. 09 8393 5300 ma-to klo 7.30-15.00, pe klo 7.30-14.00."}, "www": null, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 80}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 103}, {"value": "true", "variable": 6}, {"value": "false", "variable": 21}, {"value": "true", "variable": 52}, {"value": "false", "variable": 106}, {"value": "sufficiently_wide", "variable": 18}, {"value": "0", "variable": 1}, {"value": "true", "variable": 105}, {"value": "1_step", "variable": 24}, {"value": "true", "variable": 23}, {"value": "false", "variable": 53}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 84}, {"value": "false", "variable": 79}, {"value": "true", "variable": 57}, {"value": "true", "variable": 62}, {"value": "false", "variable": 104}, {"value": "1_step", "variable": 39}, {"value": "false", "variable": 29}, {"value": "false", "variable": 48}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 59}, {"value": "false", "variable": 92}, {"value": "false", "variable": 37}, {"value": "true", "variable": 50}, {"value": "false", "variable": 49}, {"value": "false", "variable": 34}, {"value": "true", "variable": 38}, {"value": "true", "variable": 20}, {"value": "false", "variable": 33}, {"value": "true", "variable": 51}, {"value": "false", "variable": 22}, {"value": "false", "variable": 102}, {"value": "short_term_stay", "variable": 60}, {"value": "no_handrails", "variable": 47}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 107}, {"value": "false", "variable": 82}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 98}, {"value": "false", "variable": 46}, {"value": "true", "variable": 44}, {"value": "over_20mm", "variable": 56}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 58}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 5}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "false", "variable": 83}] | internal | 5291 | 8809b663-71b1-43bd-a894-ac7d0c503427 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | service_by_municipally_owned_company | kunnan liikelaitoksen palvelu | tjänst från kommunalt affärsverk | service by municipally owned company | 1 | Päiväkummun koulun hammashoitola | Dental clinic at Päiväkummun koulu | Ismontie 2 | Ismovägen 2 | http://www.vantaa.fi/terveys-_ja_sosiaalipalvelut/terveyspalvelut/hammashoito/hammashoitolat | http://www.vanda.fi/halsovard_och_sociala_tjanster/halsovardstjanster/tandvard/tandklinikerna | http://www.vantaa.fi/en/social_and_health_care_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8393 5300 | etunimi.sukunimi@vantaa.fi | +358 9 8392 3805 | 2014-11-19T17:01:21+02:00 | 01420 | www.vantaa.fi | kaikki | vantaa | 2020-05-05T09:30:54.868500+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": "red"} | [986] | vantaa | [995] | [184] | {} | Point | 25.09906 | 60.32455 | Ismontie 2, 01420 Vantaa | Tandkliniken vid Päiväkummun koulu | 2 | 6 | 1 | 5 | 6 | ||||||||||||||||||||||||||||||||||||
18504 | [{"section_type": "OPENING_HOURS", "name": {"fi": "COVID-19: Kiirreellinen hammashoito puh. 09 8393 5300 ma-to klo 7.30-15.00, pe klo 7.30-14.00."}, "www": null, "email": null, "phone": null, "contact_person": null}] | [{"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 107}, {"value": "true", "variable": 52}, {"value": "false", "variable": 117}, {"value": "at_least_3600mm", "variable": 3}, {"value": "over_10m", "variable": 4}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 5}, {"value": "false", "variable": 49}, {"value": "false", "variable": 38}, {"value": "false", "variable": 79}, {"value": "true", "variable": 109}, {"value": "true", "variable": 113}, {"value": "true", "variable": 114}, {"value": "false", "variable": 78}, {"value": "true", "variable": 112}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 105}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "on_door", "variable": 110}, {"value": "false", "variable": 22}, {"value": "sufficiently_wide", "variable": 18}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 74}, {"value": "false", "variable": 98}, {"value": "true", "variable": 115}, {"value": "false", "variable": 83}, {"value": "false", "variable": 23}, {"value": "false", "variable": 20}, {"value": "false", "variable": 62}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 33}, {"value": "false", "variable": 44}, {"value": "under_20mm", "variable": 91}, {"value": "1", "variable": 63}, {"value": "false", "variable": 84}, {"value": "opens_easily_manually", "variable": 77}, {"value": "true", "variable": 73}, {"value": "false", "variable": 21}, {"value": "false", "variable": 29}, {"value": "false", "variable": 116}, {"value": "true", "variable": 37}, {"value": "true", "variable": 75}, {"value": "true", "variable": 72}, {"value": "false", "variable": 59}, {"value": "false", "variable": 102}, {"value": "true", "variable": 70}, {"value": "false", "variable": 76}, {"value": "false", "variable": 53}, {"value": "outdoors", "variable": 2}, {"value": "true", "variable": 57}, {"value": "false", "variable": 48}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable… | internal | 5219 | 8809b663-71b1-43bd-a894-ac7d0c503427 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | service_by_municipally_owned_company | kunnan liikelaitoksen palvelu | tjänst från kommunalt affärsverk | service by municipally owned company | 1 | Peltolan koulun hammashoitola | Dental clinic at Peltolan koulu | Lummetie 27 | Näckrosvägen 27 | http://www.vantaa.fi/terveys-_ja_sosiaalipalvelut/terveyspalvelut/hammashoito/hammashoitolat | http://www.vanda.fi/halsovard_och_sociala_tjanster/halsovardstjanster/tandvard/tandklinikerna | http://www.vantaa.fi/en/social_and_health_care_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 839 11 | etunimi.sukunimi@vantaa.fi | taru.etelamaki@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01300 | www.vantaa.fi | kaikki | vantaa | 2020-05-05T09:30:55.079246+03: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"} | [986] | vantaa | [995] | [184] | {} | Point | 25.027994 | 60.298367 | Lummetie 27, 01300 Vantaa | Tandkliniken vid Peltolan koulu | 1 | 1 | 1 | 5 | |||||||||||||||||||||||||||||||||||||
19117 | [{"section_type": "OPENING_HOURS", "name": {"fi": "COVID-19: Kiirreellinen hammashoito puh. 09 8393 5300 ma-to klo 7.30-15.00, pe klo 7.30-14.00."}, "www": null, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 34}, {"value": "true", "variable": 31}, {"value": "true", "variable": 94}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 49}, {"value": "true", "variable": 37}, {"value": "true", "variable": 38}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 50}, {"value": "0", "variable": 1}, {"value": "false", "variable": 82}, {"value": "false", "variable": 43}, {"value": "false", "variable": 106}, {"value": "true", "variable": 22}, {"value": "short_term_stay", "variable": 60}, {"value": "no_handrails", "variable": 32}, {"value": "true", "variable": 57}, {"value": "false", "variable": 33}, {"value": "true", "variable": 25}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 105}, {"value": "sufficiently_wide", "variable": 18}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "true", "variable": 20}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 53}, {"value": "true", "variable": 35}, {"value": "rough", "variable": 17}, {"value": "2_consecutive_steps", "variable": 24}, {"value": "true", "variable": 5}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 79}, {"value": "false", "variable": 97}, {"value": "true", "variable": 52}, {"value": "true", "variable": 100}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "false", "variable": 28}, {"value": "true", "variable": 40}, {"value": "no_handrails", "variable": 95}, {"value": "true", "variable": 62}, {"value": "true", "variable": 92}, {"value": "over_20mm", "variable": 91}, {"value": "2_consecutive_steps", "variable": 93}, {"value": "true", "variable": 51}, {"value": "true", "variable": 104}, {"value": "false", "variable": 107}, {"value": "false", "variable": 83}, {"value": "true", "variable": 44}, {"value": "true", "variable": 58}, {"value": "no_handrails", "variable": 47}, {"value": "under_20mm", "variable": 56}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "true"… | internal | 5443 | 8809b663-71b1-43bd-a894-ac7d0c503427 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | service_by_municipally_owned_company | kunnan liikelaitoksen palvelu | tjänst från kommunalt affärsverk | service by municipally owned company | 1 | Sotungin koulun hammashoitola | Dental clinic at Sotungin koulu | Sotungintie 19 | Sottungsbyvägen 19 | http://www.vantaa.fi/terveys-_ja_sosiaalipalvelut/terveyspalvelut/hammashoito/hammashoitolat | http://www.vanda.fi/halsovard_och_sociala_tjanster/halsovardstjanster/tandvard/tandklinikerna | http://www.vantaa.fi/en/social_and_health_care_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 839 11 | etunimi.sukunimi@vantaa.fi | +358 9 8393 0874 | jaana.nissinen | vantaa.fi | 2014-11-19T17:01:21+02:00 | 01200 | www.vantaa.fi | kaikki | vantaa | 2020-05-05T09:30:55.737729+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] | vantaa | [995] | [184] | {} | Point | 25.121601 | 60.28021 | Sotungintie 19, 01200 Vantaa | Tandkliniken vid Sotungin koulu | 8 | 13 | 2 | 1 | 10 | 9 | |||||||||||||||||||||||||||||||||
19151 | [{"section_type": "OPENING_HOURS", "name": {"fi": "COVID-19: Kiirreellinen hammashoito puh. 09 8393 5300 ma-to klo 7.30-15.00, pe klo 7.30-14.00."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://asiointi.vantaa.fi/anna-palautetta"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 5387 | de363a63-45be-487c-bbec-e98accf372a2 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kulomäen koulu/ siirtyvä hoitola | Kulomäen koulu / ambulatory clinic | Maauuninpolku 3 | Ryssugnsstigen 3 | http://www.vantaa.fi/terveys-_ja_sosiaalipalvelut/terveyspalvelut/hammashoito/hammashoitolat | www.vanda.fi/halsovard_och_sociala_tjanster/halsovardstjanster/tandvard/tandklinikerna | http://www.vantaa.fi/en/social_and_health_care_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 839 11 | etunimi.sukunimi@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01450 | www.vantaa.fi | kaikki | vantaa | 2020-05-05T09:30:55.772509+03:00 | [986] | vantaa | [995] | [184] | {} | Point | 25.064875 | 60.345497 | Maauuninpolku 3, 01450 Vantaa | Kulomäen koulu / ambulerande klinik | |||||||||||||||||||||||||||||||||||||||||||
19341 | [{"section_type": "OPENING_HOURS", "name": {"fi": "COVID-19: Kiirreellinen hammashoito puh. 09 8393 5300 ma-to klo 7.30-15.00, pe klo 7.30-14.00."}, "www": null, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 35}, {"value": "true", "variable": 38}, {"value": "false", "variable": 21}, {"value": "no_handrails", "variable": 95}, {"value": "true", "variable": 57}, {"value": "true", "variable": 6}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 79}, {"value": "false", "variable": 43}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 23}, {"value": "false", "variable": 22}, {"value": "false", "variable": 105}, {"value": "true", "variable": 20}, {"value": "2_consecutive_steps", "variable": 93}, {"value": "false", "variable": 29}, {"value": "false", "variable": 97}, {"value": "false", "variable": 94}, {"value": "true", "variable": 92}, {"value": "false", "variable": 52}, {"value": "false", "variable": 102}, {"value": "false", "variable": 82}, {"value": "false", "variable": 48}, {"value": "false", "variable": 33}, {"value": "false", "variable": 28}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 84}, {"value": "true", "variable": 59}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 83}, {"value": "false", "variable": 80}, {"value": "2_consecutive_steps", "variable": 24}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 49}, {"value": "0", "variable": 1}, {"value": "false", "variable": 40}, {"value": "false", "variable": 98}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 50}, {"value": "true", "variable": 62}, {"value": "false", "variable": 34}, {"value": "over_20mm", "variable": 91}, {"value": "no_handrails", "variable": 41}, {"value": "true", "variable": 37}, {"value": "false", "variable": 25}, {"value": "true", "variable": 51}, {"value": "no_handrails", "variable": 26}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 107}, {"value": "tr… | internal | 5512 | 8809b663-71b1-43bd-a894-ac7d0c503427 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | service_by_municipally_owned_company | kunnan liikelaitoksen palvelu | tjänst från kommunalt affärsverk | service by municipally owned company | 1 | Simonkallion koulun hammashoitola | Dental clinic at Simonkallion koulu | Simonkalliontie 1 | Simonsbergsvägen 1 | http://www.vantaa.fi/terveys-_ja_sosiaalipalvelut/terveyspalvelut/hammashoito/hammashoitolat | http://www.vanda.fi/halsovard_och_sociala_tjanster/halsovardstjanster/tandvard/tandklinikerna | http://www.vantaa.fi/en/social_and_health_care_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8393 5300 | etunimi.sukunimi@vantaa.fi | +358 9 8392 3805 | 2014-11-19T17:01:21+02:00 | 01350 | www.vantaa.fi | kaikki | vantaa | 2020-05-05T09:30:55.948613+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] | vantaa | [995] | [184] | {} | Point | 25.023745 | 60.307026 | Simonkalliontie 1, 01350 Vantaa | Tandkliniken vid Simonkallion koulu | 9 | 9 | 2 | 1 | 9 | 12 | |||||||||||||||||||||||||||||||||||
19398 | [{"section_type": "OPENING_HOURS", "name": {"fi": "COVID-19: Kiirreellinen hammashoito puh. 09 8393 5300 ma-to klo 7.30-15.00, pe klo 7.30-14.00."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://asiointi.vantaa.fi/anna-palautetta"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 5410 | de363a63-45be-487c-bbec-e98accf372a2 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kivistön koulu/ siirtyvä hoitola | Kivistön koulu / ambulatory clinic | Vanha Nurmijärventie 132 | Gamla Nurmijärvivägen 132 | http://www.vantaa.fi/terveys-_ja_sosiaalipalvelut/terveyspalvelut/hammashoito/hammashoitolat | www.vanda.fi/halsovard_och_sociala_tjanster/halsovardstjanster/tandvard/tandklinikerna | http://www.vantaa.fi/en/social_and_health_care_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 839 11 | etunimi.sukunimi@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01700 | www.vantaa.fi | kaikki | vantaa | 2020-05-05T09:30:56.008049+03:00 | [986] | vantaa | [995] | [184] | {} | Point | 24.845423 | 60.31657 | Vanha Nurmijärventie 132, 01700 Vantaa | Kivistön koulu / ambulerande klinik | |||||||||||||||||||||||||||||||||||||||||||
19432 | [{"section_type": "OPENING_HOURS", "name": {"fi": "COVID-19: Kiirreellinen hammashoito puh. 09 8393 5300 ma-to klo 7.30-15.00, pe klo 7.30-14.00."}, "www": null, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 103}, {"value": "true", "variable": 115}, {"value": "false", "variable": 80}, {"value": "true", "variable": 105}, {"value": "false", "variable": 34}, {"value": "indoor_facility", "variable": 500}, {"value": "0", "variable": 1}, {"value": "false", "variable": 23}, {"value": "false", "variable": 111}, {"value": "false", "variable": 79}, {"value": "requires_use_of_buzzer_opening_easily_manually", "variable": 54}, {"value": "false", "variable": 20}, {"value": "false", "variable": 22}, {"value": "false", "variable": 33}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 116}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 82}, {"value": "false", "variable": 21}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 92}, {"value": "short_term_stay", "variable": 60}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 83}, {"value": "false", "variable": 117}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 104}, {"value": "true", "variable": 109}, {"value": "false", "variable": 55}, {"value": "true", "variable": 113}, {"value": "false", "variable": 102}, {"value": "false", "variable": 58}, {"value": "next_to_door_on_opening_side", "variable": 110}, {"value": "false", "variable": 38}, {"value": "true", "variable": 62}, {"value": "false", "variable": 44}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 5}, {"value": "true", "variable": 59}, {"value": "false", "variable": 51}, {"value": "true", "variable": 6}, {"value": "floor_0", "variable": 108}, {"value": "false", "variable": 48}, {"value": "false", "variable": 98}, {"value": "false", "variable": 49}, {"value": "true", "variable": 114}, {"value": "true", "variable": 112}, {"value": "true", "variable": 107}, {"value": "false", "variable": 29}, {"value": "true", "variable": 57}, {"value": "false", "variable": 37}, {"value": "false", "variable": 53}, {"value": "true", "variable": 52}, {"value":… | internal | 5406 | 8809b663-71b1-43bd-a894-ac7d0c503427 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | service_by_municipally_owned_company | kunnan liikelaitoksen palvelu | tjänst från kommunalt affärsverk | service by municipally owned company | 1 | Vierumäen koulun hammashoitola | Dental clinic at Vierumäen koulu | Lehmustontie 9 | Lehmustovägen 9 | Lehmustontie 9 | http://www.vantaa.fi/terveys-_ja_sosiaalipalvelut/terveyspalvelut/hammashoito/hammashoitolat | http://www.vanda.fi/halsovard_och_sociala_tjanster/halsovardstjanster/tandvard/tandklinikerna | http://www.vantaa.fi/en/social_and_health_care_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8393 5300 | etunimi.sukunimi@vantaa.fi | +358 9 8392 3805 | 2014-11-19T17:01:21+02:00 | 01450 | www.vantaa.fi | kaikki | vantaa | 2020-05-05T09:30:56.063844+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] | vantaa | [995] | [184] | {} | Point | 25.055725 | 60.35641 | Lehmustontie 9, 01450 Vantaa | Tandkliniken vid Vierumäen koulu | 2 | 4 | 1 | 1 | 4 | 8 | ||||||||||||||||||||||||||||||||||
20469 | [] | [] | internal | 5952 | visithelsinki | 1301 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Rake Sali on ihastuttanut Helsingin sydämessä jo 1800-luvulta saakka ja tarjoaa tänäkin päivänä viehättävät puitteet erilaisiin tapahtumiin. Sali soveltuu erinomaisesti kokouksiin, hääjuhliin, koulutuspäiviin sekä merkkipäivien viettoon. Tilassa on moderni kokoustekniikka ja AV-välineet.Kansallisromanttiselta aikakaudelta peräisin oleva hotellirakennus sijaitsee Helsingin Bulevardilla, Esplanadin päässä ja muiden pääkatujen, Mannerheimintien ja Erottajan, liitoskohdassa. Kaupungin parhaat ostospaikat odottavat kivenheiton päässä. | Rake Sali Ball Room, in connection with the Klaus K hotel, is perfect for example for seminars, conferences, weddings, birthday parties, dinners and other celebrations with all banquet services provided by Klaus K Hotel. The venue is set in a national romantic era building, at the top of Helsinki's Esplanadi and the crossroads of the city center main streets Mannerheimintie and Erottaja. All the best shopping in the city is just across the street. | Rake-Sali | Rake Sali Ball Room | Bulevardi 2-4 | Bulevarden 2-4 | Bulevardi 2-4 | https://www.klauskhotel.com/kokoukset/rake-sali | https://www.klauskhotel.com/en/meetings-venues/rake-ballroom | https://www.klauskhotel.com/en/meetings-venues/rake-ballroom | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 20 770 4700 | events@klauskhotel.com | 2011-05-25T14:54:37+03:00 | 00120 | www.myhelsinki.fi | kaikki | helsinki | 2020-05-05T08:00:54.226190+03:00 | [1400, 1401, 1403] | helsinki | [152, 508, 737, 261, 742, 260, 507, 151] | [326, 214] | {} | Point | 24.942896 | 60.16625 | Rake-Salen | |||||||||||||||||||||||||||||||||||||||
20492 | [] | [] | internal | 5888 | visithelsinki | 56 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Boutique Hotel Rivoli Jardin sijaitsee aivan Helsingin ydinkeskustassa,kivenheiton päässä Esplanadeista. Huoneet ovat yksilöllisesti sisustettuja ja kaikissa 55 huoneessa on ilmainen WiFi sekä huonekohtainen ilmastointi. Design District Helsinki, Kauppatori, museot ja kaupungin parhaat ravintolat ovat kävelymatkan etäisyydellä. | Rivoli Jardin is located at the very heart of Helsinki, just a stone's throw from the Esplanade Park, and the most beautiful shopping and walking streets. Design District Helsinki, as well as the best restaurants, are within walking distance. The hotel has wireless Internet access and all rooms are individually air-conditioned. | Hotel Rivoli Jardin | Hotel Rivoli Jardin | Kasarmikatu 40 | Kaserngatan 40 | Kasarmikatu 40 | https://rivoli.fi/ | https://rivoli.fi/ | https://rivoli.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 681 500 | info@rivoli.fi | 2011-05-25T14:54:37+03:00 | 00130 | www.myhelsinki.fi | kaikki | helsinki | 2020-05-05T08:00:54.274245+03:00 | [1403] | helsinki | [736] | [197] | {} | Point | 24.947605 | 60.165592 | Hotel Rivoli Jardin | Rivoli Jardin är beläget mitt i stadens affärscentrum. 55 stycken individuellt inredda rum med WiFi och luftkonditionering. Design District Helsinki, sevärdheter och stans bästa restauranger finns inom promenadavstånd. | ||||||||||||||||||||||||||||||||||||||
20704 | [] | [] | internal | 5804 | visithelsinki | 26 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Hotel Rantapuiston näyttävä päärakennus valmistui 1960-luvulla pankin koulutuskeskukseksi keskelle itähelsinkiläistä luontoa. Paljon on tapahtunut sen jälkeen, mutta talo viestii edelleen aikakautensa mielenkiintoisia arkkitehtonisia piirteitä: kokonaisuus muodostuu useista siivistä, tilat ovat suuria ja käytävät avaria. Jäljellä on myös useita sisustuksen helmiä kuten valaisimia, takkoja ja kattorakenteita. Rantapuiston vetovoimaa vahvistaa sen sijainti luonnonkauniissa ympäristössä. Valtavista ikkunoista avautuu esteetön näkymä lähiluontoon ja merelle.Hotel Rantapuistossa on 67 valoisaa huonetta, sekä seitsemän huoneistoa. Kaikki huoneet ovat savuttomia. Viihtyisä ja avara 120-paikkainen Ravintola Rantapuisto sijaitsee hotellin ensimmäisessä kerroksessa. Tilaa koristaa hauska takka ja suurista ikkunoista aukeaa upea näkymä Itämerelle. Ravintolan à la carte -lista tarjoaa suomalaista ruokaa pientuottajatiloilta ja lähialueelta, kansainvälisiä klassikkoja unohtamatta.Hotel Rantapuistossa on myös 10 erikokoista kokoustilaa sekä auditorio erilaisiin tarpeisiin. | The Hotel Rantapuisto main building was completed in the 1960's as a bank's training center in the middle of east Helsinki nature.A lot has happened since then, but the hotel continues to communicate the era of interesting architectural features: it consists of several wings, rooms are large and glass corridors are wide. A number of gems from the 60's era remain such as interior lighting, fireplaces and original wooden ceiling structures. Rantapuisto's attraction is its location in a beautiful natural environment. The huge windows offer unobstructed view of the local nature and the sea.There are 67 bright hotel rooms and 7 apartments. All rooms are non-smoking.The comfortable and spacious 120-seat restaurant Rantapuisto is located on the first floor of the hotel. The space is decorated with a merry fireplace and big windows open to a gorgeous view over the Baltic Sea. The à la carte menu offers Finnish food originating from small producer's farms and from neighboring areas without leaving international classics behind. Rantapuisto houses also 10 meeting rooms of various sizes and an auditorium. | Hotel Rantapuisto | Hotel Rantapuisto | Furuborginkatu 3 | Furuborgsgatan 3 | Furuborginkatu 3 | https://www.rantapuisto.fi/ | https://www.rantapuisto.fi/en/ | https://www.rantapuisto.fi/en/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 319 11 | reception@rantapuisto.fi | 2011-05-25T14:54:37+03:00 | 00980 | www.myhelsinki.fi | kaikki | helsinki | 2020-05-05T08:00:54.753375+03:00 | [1400, 1401, 1403] | helsinki | [736, 508, 737, 261, 152, 742, 260, 507, 151] | [326, 214, 197] | {} | Point | 25.112251 | 60.195766 | Hotel Rantapuisto | Hotel Rantapuistos huvudbyggand, ursprungligen byggd som bankens skolningscentrum, blev färdigt på 1960-talet och byggdes mitt i naturen i östra Helsingfors.Mycket har hänt sedan dess, men byggnaden fortsätter att kommunicera erans intressanta arkitektoniska drag; byggnaden består av flera längor, stora rum och vida glaskorridorer. Kvar finns även flera pärlor från 60-talet som armaturer, öppna spisar och takstrukturer. Rantapuistos attraktion är dess naturnära läge. Från de stora fönstren öppnas en obehindrad vy över naturen och havet.Hotel Rantapuisto har 67 ljusa rum och 7 lägenheter. Alla rum är rökfria.Den trivsamma restaurangen Rantapuisto, som har 120 kundplatser, finns i gatuplan. Utrymmet utsmyckas av en skojig öppen spis och de stora fönstren öppnar sig mot Östersjön. Á la carte menyn erbjuder finska rätter, som tillagas av närproducerade råvaror och råvaror från småproducenter, samt endel klassiska, internationella rätter.Hotellet har dessutom 10 konferensrum och ett auditorium för olika tillställningar. | ||||||||||||||||||||||||||||||||||||||
21201 | [] | [] | internal | 6407 | visithelsinki | 102 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Nuorekas Hotelli Finn tarjoaa vierailleen kohtuuhintaista ja laadukasta majoitusta aivan Helsingin ydinkeskustassa. Ammattitaitoinen ja ystävällinen henkilökunta tuntee kaupunkinsa ja on valmiina auttamaan asiakkaita kaikissa heidän ongelmissaan ja kysymyksissään.Hotellissa on 37 uniikkia ja rauhallista huonetta, joiden sisustuksessa kohtaavat leikkisän värikkäät elementit ja pohjoismainen käytännöllisyys. Kaikissa huoneissa on oma televisio, suihku ja WC, sekä näkymä joko kadulle tai sisäpihalle.Rauhallinen sijainti arvokkaan keskustakivitalon ylimmissä kerroksissa. | Situated on the top floors of a historical building the young and regenerating hotel Finn offers you a modern and intimate setting during your stay in Helsinki.Enjoy the convenience of staying in a lively quarter within walking distance to Helsinki's shopping areas, tourist attractions and parks, theaters and restaurants, while experiencing a calm and serene atmosphere.The Hotel consists of 27 bedrooms of different sizes and prices. Each of the rooms are equipped with the essential amenities to ensure a comfortable stay. | Hotel Finn | Hotel Finn | Kalevankatu 3 B | Kalevagatan 3 B | Kalevankatu 3 B | https://hotellifinn.fi/ | https://hotellifinn.fi/en/home/ | https://hotellifinn.fi/en/home/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 684 4360 | info@hotelfinn.com | 2011-05-25T14:54:37+03:00 | 00100 | www.myhelsinki.fi | kaikki | helsinki | 2020-05-05T08:00:55.887128+03:00 | [1403] | helsinki | [736] | [197] | {} | Point | 24.939611 | 60.16801 | Hotell Finn | Litet, hemtrevligt hotell i Helsingfors centrum. | ||||||||||||||||||||||||||||||||||||||
21283 | [] | [] | internal | 6422 | visithelsinki | 11 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Hartwall Arena on viihdekeskus, joka on täynnä erilaisia tapahtumia. Hartwall Areenalla järjestetään konsertteja, oopperoita, tanssiesityksiä sekä jääkiekko- ja urheilutapahtumia. Hartwall Arena on toiminut jääkiekkojoukkue Jokereiden kotihallina vuodesta 1997 lähtien. | The Hartwall Arena is a lively entertainment centre: concerts, operas, dance performances, top ice-hockey and other sporting events.Hartwall Arena is also the home arena for icehockey team Jokerit since 1997. | Hartwall Arena | Hartwall Arena | Areenankuja 1 | Arenagränden 1 | Areenankuja 1 | http://www.hartwallarena.fi | https://hartwallarena.fi/en | https://hartwallarena.fi/en | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 20 419 97 | info@hartwallarena.fi | 2011-05-25T14:54:37+03:00 | 00240 | www.myhelsinki.fi | kaikki | helsinki | 2020-05-05T08:00:56.060740+03:00 | [1400, 1401, 1403] | helsinki | [737, 152, 508, 261, 151, 260, 507, 742, 354, 2173] | [868, 329, 326, 214] | {} | Point | 24.929167 | 60.20566 | Hartwall Arena | Hartwall Arena är vad man kan kalla ett underhållningscenter för allehanda evenemang. På Hartwall Arena arrangeras konserter, operor, dansuppvisningar samt ishockeymatcher och andra idrottsevenemang. Hartwall Arenan har även fungerat som hemmaplan för ishockeylaget Jokerit sedan 1997. | ||||||||||||||||||||||||||||||||||||||
21317 | [] | [] | internal | 6122 | visithelsinki | 70 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Keskellä Helsinkiä monipuolinen kokouskeskus, jossa lounasravintola avoinna kaikille ma-pe 10.30-13.30. Lounasajan ulkopuolella kaunis lasikattoinen ravintolasali on käytettävissä mm. brunssi-, näyttely- yritys- ja yksityistilaisuuksiin. Valoisat ja mukavat kabinetit tarjoaa laadukkaat puitteet niin onnistuneelle kokoukselle kuin muillekin tilaisuuksille. Käytössä on myös auditorio 75 hengelle. Hulppea edustussaunatila 10. kerroksessa Postitalon tornissa on oiva paikka neuvotteluihin sekä erilaisiin illanistujaisiin. | The Pääposti Restaurant and its conference facilities are situated right in the heart of the city centre: the main railway station, Kiasma Museum of contemporary Art, Sanoma House and Sokos department store around the main Post office in the busy downtown district. Under the glass ceiling of the restaurant, it is possible to enjoy a variety of truly memorable parties. | Ravintola Pääposti | Restaurant Pääposti | Mannerheiminaukio 1 B | Mannerheimplatsen 1 B | Mannerheiminaukio 1 B | https://www.fazerfoodco.fi/ravintolat/Ravintolat-kaupungeittain/helsinki/paaposti/ | https://foodandco.fi/ravintolat/Ravintolat-kaupungeittain/helsinki/paaposti/ | https://foodandco.fi/ravintolat/Ravintolat-kaupungeittain/helsinki/paaposti/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 20 729 6712 | paaposti@foodandco.fi | 2011-05-25T14:54:37+03:00 | 00100 | www.myhelsinki.fi | kaikki | helsinki | 2020-05-05T08:00:56.139512+03:00 | [1400, 1401, 1403] | helsinki | [152, 508, 737, 261, 742, 260, 507, 151] | [326, 214] | {} | Point | 24.937643 | 60.17125 | Restaurang Pääposti | Restaurang Pääposti är en lunchrestaurang i centrum av Helsingfors. Restaurangen är öppen för alla måndag - fredag kl. 10.30-13.30. Utöver lunchtiden är den vackra restaurangen med glastak brukbar för bl.a. bruncher, utställningar och företags- samt privattillställningar. Restaurangens ljusa och bekväma kabinetter erbjuder en högklassig omgivning för både lyckade möten och tillställningar. Lokalen har även ett auditorium för 75 personer. Den lyxiga representationsbastun i 10. våningen är en väl fungerande plats för såväl konferenser som olika kvällstillställningar. | ||||||||||||||||||||||||||||||||||||||
21335 | [] | [] | internal | 6325 | visithelsinki | 1292 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Hotel Midpoint Helsinki on pieni ja sympaattinen 21 huoneen hotelli erinomaisella paikalla aivan Helsingin ydinkeskustassa. Perheomisteisessa hotellissa yhdistyvät rento ilmapiiri, helppo majoittuminen ja ystävällinen palvelu. Hotelli sopii mainiosti niin lomalaisille, kuin työn merkeissä matkustavillekin.Taulu-TV:llä sekä omalla kylpyhuoneella varustetuista huoneista löytyy varmasti mieleinen - valikoimaan kuuluvat niin yhden hengen, kahden hengen (twin) kuin parivuotteellisetkin huoneet (queen). | Hotel Midpoint Helsinki is a small and cozy hotel with 21 rooms, centrally located at the very heart of Helsinki. The family-owned hotel is a merge of a laid-back atmosphere, easy accommodation and genuine customer service. The hotel is suitable for both leisure and business travelers. All the rooms come with a flat screen tv, as well as a fully equipped shower and WC. The three different room types (queen, double and single) are sure to suit all kinds of accommodation needs. | Hotel Midpoint Helsinki | Hotel Midpoint Helsinki | Kaisaniemenkatu 3 | Kajsaniemigatan 3 | Kaisaniemenkatu 3 | https://www.midpointhelsinki.fi/index_fi.html | https://www.midpointhelsinki.fi | https://www.midpointhelsinki.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 10 212 9730 | reception@midpointhelsinki.fi | 2011-05-25T14:54:37+03:00 | 00100 | www.myhelsinki.fi | kaikki | helsinki | 2020-05-05T08:00:56.180127+03:00 | [1403] | helsinki | [736] | [197] | {} | Point | 24.94696 | 60.17099 | Hotel Midpoint Helsinki | Hotel Midpoint Helsinki är ett litet, sympatiskt hotel med 21 rum mitt I Helsingfors centrum. I det familjeägda hotellet förenas en avslappnad atmosfär, lätt logi och äkta kundservice. Hotellet passar såväl för fritids- och businessresenärer.Alla rum har platt-tv och fullt utrustade badrum. I de tre rumskategorierna finns olika alternativ för alla logibehov. | ||||||||||||||||||||||||||||||||||||||
23964 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://asiointi.vantaa.fi/anna-palautetta"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 7181 | 4738c8e5-8bab-40c2-865d-5b28e64d7591 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kuulontutkimus | Hearing examination | Vernissakatu 8 C | Fernissagatan 8 C | Vernissakatu 8 C | http://www.vantaa.fi/terveys-_ja_sosiaalipalvelut/terveyspalvelut/muita_terveyspalveluita/kuulontutkimus_ja_naonhuolto | http://www.vanda.fi/halsovard_och_sociala_tjanster/halsovardstjanster/rehabilitering_och_terapi | http://www.vantaa.fi/en/social_and_health_care_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 43 827 0116 | etunimi.sukunimi@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01300 | www.vantaa.fi | kaikki | vantaa | 2020-05-05T16:31:10.129760+03:00 | [986] | vantaa | [1042] | [357] | {} | Point | 25.059193 | 60.31943 | Karsikkokuja 15, 01360 Vantaa | Hörselundersökning | Kuulontutkimus. | |||||||||||||||||||||||||||||||||||||||||
23990 | [{"section_type": "OPENING_HOURS", "name": {"fi": "COVID-19: Kiirreellinen hammashoito puh. 09 8393 5300 ma-to klo 7.30-15.00, pe klo 7.30-14.00."}, "www": null, "email": null, "phone": null, "contact_person": null}] | [{"value": "same_floor_as_entrance", "variable": 108}, {"value": "true", "variable": 52}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 37}, {"value": "false", "variable": 98}, {"value": "true", "variable": 105}, {"value": "true", "variable": 20}, {"value": "on_door", "variable": 110}, {"value": "guided_and_clear", "variable": 19}, {"value": "true", "variable": 112}, {"value": "true", "variable": 113}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 38}, {"value": "true", "variable": 23}, {"value": "false", "variable": 33}, {"value": "false", "variable": 48}, {"value": "false", "variable": 44}, {"value": "false", "variable": 49}, {"value": "no_handrails", "variable": 26}, {"value": "true", "variable": 62}, {"value": "true", "variable": 25}, {"value": "true", "variable": 59}, {"value": "false", "variable": 22}, {"value": "true", "variable": 35}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 79}, {"value": "true", "variable": 114}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 117}, {"value": "true", "variable": 50}, {"value": "true", "variable": 51}, {"value": "false", "variable": 29}, {"value": "true", "variable": 116}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 107}, {"value": "true", "variable": 115}, {"value": "true", "variable": 58}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 83}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 109}, {"value": "false", "variable": 84}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 57}, {"value": "false", "variable": 5}, {"value": "true", "variable": 104}, {"value": "0", "variable": 1}, {"value": "false", "variable": 102}, {"value": "true", "variable": 53}, {"value": "false", "variable": 28}, {"value": "false", "variable": 111}, {"value": "false", "variable": 106}, {"value": "false", "variable": 21}, {"value": "false", "variable": 10… | internal | 6973 | 8809b663-71b1-43bd-a894-ac7d0c503427 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | service_by_municipally_owned_company | kunnan liikelaitoksen palvelu | tjänst från kommunalt affärsverk | service by municipally owned company | 1 | Itä-Hakkilan koulun hammashoitola | Dental clinic at Itä-Hakkilan koulu | Koulutie 8 | Skolvägen 8 | http://www.vantaa.fi/terveys-_ja_sosiaalipalvelut/terveyspalvelut/hammashoito/hammashoitolat | http://www.vanda.fi/halsovard_och_sociala_tjanster/halsovardstjanster/tandvard/tandklinikerna | http://www.vantaa.fi/en/social_and_health_care_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8393 5300 | etunimi.sukunimi@vantaa.fi | +358 40 524 2887 | tarja.narhi-kantanen@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01260 | www.vantaa.fi | kaikki | vantaa | 2020-05-05T09:31:02.082106+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] | vantaa | [995] | [184] | {} | Point | 25.10891 | 60.29485 | Koulutie 8, 01260 Vantaa | Tandkliniken vid Itä-Hakkilan koulu | Hammashoitola | 3 | 3 | 1 | 1 | 3 | 6 | |||||||||||||||||||||||||||||||||
24363 | [] | [] | internal | 7349 | visithelsinki | 1369 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Regus Luna House sijaitsee aivan Helsingin ydinkeskustassa, kauniissa ja edustavassa rakennuksessa. Regus Luna House tarjoaa laadukkaat kokous- ja koulutustilat, jotka täyttävät kaikkien kokousten asettamat vaatimukset. Viisi erilaista kokous- ja koulutustilaa sekä ammattitaitoinen henkilökunta, joka varmistaa kokouksen onnistumisen. Tarvittaessa henkilökunta hoitaa kokousmateriaalien valmistamisen sekä järjestää kahvi- ja ruokatarjoilut toiveiden mukaan. | Regus Luna House is based in a beautiful, impressive building ideally located in the very heart of the city. The centre has five conference and meeting rooms and the professional team can help to ensure the success of meetings. | Regus Luna House | Regus Luna House | Mannerheimintie 12 B, 5. kerros | Mannerheimvägen 12 B, 5. kerros | Mannerheimintie 12 B, 5. kerros | https://www.regus.fi/coworking-space/finland/helsinki/helsinki-luna-house | https://www.regus.fi/coworking-space/finland/helsinki/helsinki-luna-house | https://www.regus.fi/en-fi/workspace/finland/helsinki/helsinki-luna-house | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 4245 0005 | 2011-10-06T02:40:39+03:00 | 00100 | www.myhelsinki.fi | kaikki | helsinki | 2020-05-05T08:00:59.438899+03:00 | [1400, 1401, 1403] | helsinki | [151, 260, 507, 742] | [326] | {} | Point | 24.940695 | 60.167984 | |||||||||||||||||||||||||||||||||||||||||
24454 | [] | [] | internal | 7244 | visithelsinki | 803 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Ravintolan yhteydessä on käytössä 3 kpl neuvottelutiloja 6-8 henkilölleEnsimmäisen kerroksen Briefing Center on mitoitettu noin 30 henkilölleToisen kerroksen Showroom tarjoaa koulutus- ja neuvottelutilat jopa 60 henkilölle. Lisäksi 8. kerroksessa on uusittu saunatila sekä kokoustamiseen että saunomiseen 15-24 henkilölle | Arabianrannan Portaali | Arabiankatu 12 | Arabiagatan 12 | Arabiankatu 12 | http://www.arabianrannanportaali.fi/# | http://www.arabianrannanportaali.fi/# | http://www.arabianrannanportaali.fi/# | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 46 921 1490 | portaali.palvelutiimi@fi.issworld.com | 2011-10-06T02:40:39+03:00 | 00560 | www.myhelsinki.fi | kaikki | helsinki | 2020-05-05T08:00:59.627963+03:00 | [1400, 1401, 1403] | helsinki | [152, 508, 737, 261, 742, 260, 507, 151] | [326, 214] | {} | Point | 24.978657 | 60.209354 | ||||||||||||||||||||||||||||||||||||||||||
28880 | [{"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": 52}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 112}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 98}, {"value": "false", "variable": 5}, {"value": "true", "variable": 117}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "false", "variable": 82}, {"value": "false", "variable": 80}, {"value": "false", "variable": 79}, {"value": "false", "variable": 103}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 104}, {"value": "false", "variable": 49}, {"value": "false", "variable": 83}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 105}, {"value": "false", "variable": 48}, {"value": "false", "variable": 23}, {"value": "false", "variable": 22}, {"value": "true", "variable": 113}, {"value": "true", "variable": 59}, {"value": "false", "variable": 38}, {"value": "false", "variable": 84}, {"value": "true", "variable": 50}, {"value": "false", "variable": 29}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "false", "variable": 34}, {"value": "true", "variable": 20}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 57}, {"value": "0", "variable": 1}, {"value": "false", "variable": 116}, {"value": "true", "variable": 53}, {"value": "false", "variable": 44}, {"value": "true", "variable": 114}, {"value": "false", "variable": 109}, {"value": "true", "variable": 37}, {"value": "true", "variable": 58}, {"value": "true", "variable": 62}, {"value": "true", "variable": 118}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 51}, {"value": "false", "variable": 33}, {"value": "false", "variable": 102}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 107}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 21}, {"value": "true", "variable": 115}, {"value": "false", "variable": 92}] | internal | 9356 | 4738c8e5-8bab-40c2-865d-5b28e64d7591 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Ravitsemusterapia | Nutritional therapy | Kielotie 11, 3. krs | Konvaljvägen 11, 3. vån. | Kielotie 11, 3. floor | http://www.vantaa.fi/terveys-_ja_sosiaalipalvelut/terveyspalvelut/kuntoutus_ja_terapiat/ravitsemusterapia | http://www.vanda.fi/terveys-_ja_sosiaalipalvelut/terveyspalvelut/kuntoutus_ja_terapiat/ravitsemusterapia | http://www.vantaa.fi/en/social_and_health_care_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 40 185 6730 | etunimi.sukunimi@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01300 | www.vantaa.fi | kaikki | vantaa | 2020-05-05T16:31:14.842395+03:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [986] | vantaa | [1039] | [579] | {} | Point | 25.039515 | 60.29727 | Kielotie 11, 01300 Vantaa | Näringsterapi | Ravitsemusterapia. | 2 | 4 | 1 | 4 | 3 | |||||||||||||||||||||||||||||||||||
32471 | [] | [] | internal | 14114 | visithelsinki | 2213 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Haikon Kartano on tyylikäs hotelli Porvoossa, vain 7 kilometrin päässä Porvoon vanhasta kaupungista ja noin 30 minuutin ajomatkan päässä Helsingistä tai Helsinki-Vantaan lentokentältä.Hotelli koostuu kahdesta eri hotellirakennuksesta: modernista kylpylähotellista ja historiallisesta kartanohotellista. Hotellissa on yhteensä 208 huonetta, joista 184 kylpylähotellin puolella ja 24 sijaitsee kartanohotellissa. Huonehintaan sisältyy aina kartanoravintolassa tarjottava aamiainen, kylpylän ja kuntosalin sisäänpääsy sekä ilmainen pysäköinti hotellin parkkipaikalla.Hotellihuoneiden ja kylpylän lisäksi Haikon Kartanossa on myös muuntuvat ja monipuoliset kokoustilat jopa 400 henkilölle ja juhlatiloja jopa 200 henkilölle.Hotelli sijaitsee kauniissa kartanopuistossa meren rannalla. | The elegant Hotel Haikko Manor & Spa is located in Porvoo, only half an hour's drive from Helsinki and from Helsinki-Vantaa airport.The picturesque old town of Porvoo is located within 7 km from Haikko.The hotel functions in two separate buildings, there are 24 luxurious rooms at the Haikko Manor Hotel and 184 modern rooms at the Spa Hotel. The room prices include breakfast in the Manor, entrance to the spa and gym as well as free parking. There's also a wide variety of different conference and meeting premises for meetings, events and other private occasions. Hotel Haikko Manor & Spa is located in a beautiful park setting by the sea. | Hotelli Haikon Kartano & Spa | Hotel Haikko Manor & Spa | Haikkoontie 114 | Haikovägen 114 | Haikkoontie 114 | https://www.haikko.fi/ | https://www.haikko.fi/sv | https://www.haikko.fi/en | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 19 576 01 | reception@haikko.fi | 2013-03-27T02:41:34+02:00 | 06400 | www.myhelsinki.fi | kaikki | porvoo | 2020-05-05T08:01:03.632908+03:00 | [1400, 1401, 1403] | porvoo | [736, 151, 260, 507, 742] | [326, 197] | {} | Point | 25.622759 | 60.35204 | Hotell Haiko Gård & Spa | Haiko Gård är ett elegant hotell i Borgå, beläget endast 7 km från Gamla stan i Borgå och ca 30 minuters bilresa från Helsingfors eller Helsingfors-Vanda flygfält. Hotellet består av två olika hotellbyggnader, det moderna spahotellet och historiska herrgårdshotellet. Hotellet har sammanlagt 208 rum, varav 24 är belägna i herrgårdens huvudbyggnad och 184 på badhotellets sida. I inkvarteringen ingår frukostbuffé på Herrgården, inträde till Spa-avdelningen och gymmet samt gratis parkering.Förutom hotellrum och spat har Haiko Gård även mångsidiga och modifierbara mötesutrymmen med plats för 400 personer och festurymmen för upp till 200 personer. Hotellet är beläget i en vacker herrgårdspark vid havet. |
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 );