20 rows where "last_modified_time" is on date 2020-05-05

View and edit SQL

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   +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     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   +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         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   +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         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   +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         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         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         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         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         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         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         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         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   +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         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         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         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

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