unit
2 rows where short_description_sv = "Vi ger råd när du söker information om stadens tjänster eller invandringsfrågor."
This data as json, CSV (advanced)
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28457 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-to 09-16, pe 10-15", "sv": "\u00f6ppet m\u00e5n-tor 09-16, fre 10-15", "en": "open Mon-Thu 09-16, Fri 10-15"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "COVID-19: Palvelupisteemme IHH:ssa on avoinna ma 31.8 alkaen ma-to klo 9-16, pe klo 10-16 toistaiseksi vain IHH:n muiden toimijoiden ajanvarausasiakkaille.\n\nHelsinki Infon Ode-palvelupiste tarjoaa henkil\u00f6kohtaisia neuvoja ma-to klo 9-18 ja pe klo 10-18. Pahoittelemme tilannetta.", "sv": "COVID-19: V\u00e5r servicepunkt i IHH betj\u00e4nar fr.o.m. m\u00e5 den 31.8. m\u00e5-to kl. 9-16, fre kl. 10-16 f\u00f6r tillf\u00e4llet bara kunder med tidsbest\u00e4llning till v\u00e5ra samarbetspartner i IHH.\n\nHelsingfors-infos Ode-servicepunkt bjuder p\u00e5 ansikte-till-ansikte-r\u00e5d. M\u00e5-to kl. 9-18, fre kl. 10-18.", "en": "COVID 19: The Helsinki-info's service point in International House Helsinki (IHH) is open Monday-Thursday at 9-16, Friday at 10-16 ). Our service at IHH is only for appointment customers of other IHH partners. \nFor the face-to-face advice, you can visit our service point at Central library Oodi Mon-Thu 9-18 & Fri 10-18. You can also contact us by telephone or chat Mon-Thu 9-16 & Fri 10-15. We apologize for the situation."}, "www": null, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 23}, {"value": "true", "variable": 104}, {"value": "false", "variable": 111}, {"value": "chairs_available", "variable": 81}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 103}, {"value": "true", "variable": 57}, {"value": "true", "variable": 80}, {"value": "true", "variable": 59}, {"value": "true", "variable": 58}, {"value": "true", "variable": 115}, {"value": "true", "variable": 5}, {"value": "true", "variable": 105}, {"value": "true", "variable": 46}, {"value": "false", "variable": 106}, {"value": "false", "variable": 92}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "false", "variable": 83}, {"value": "false", "variable": 43}, {"value": "true", "variable": 116}, {"value": "false", "variable": 84}, {"value": "false", "variable": 21}, {"value": "true", "variable": 50}, {"value": "no_handrails", "variable": 47}, {"value": "false", "variable": 34}, {"value": "true", "variable": 44}, {"value": "false", "variable": 48}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 102}, {"value": "false", "variable": 49}, {"value": "true", "variable": 38}, {"value": "next_to_door_on_opening_side", "variable": 110}, {"value": "true", "variable": 112}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 79}, {"value": "false", "variable": 33}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 52}, {"value": "true", "variable": 20}, {"value": "at_least_4_steps", "variable": 39}, {"value": "true", "variable": 37}, {"value": "true", "variable": 82}, {"value": "guided_and_clear", "variable": 19}, {"value": "true", "variable": 62}, {"value": "handrails_on_one_side", "variable": 41}, {"value": "short_term_stay", "variable": 60}, {"value": "sufficiently_wide", "variable": 18}, {"value": "smooth", "variable": 17}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 107}, {"value": "0", "variable": 1}, {"value": "false", "variable": 117}, {"value": … | internal | 8587 | c45ac068-2e9b-44c8-a93a-4eef7320ff90 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Helsinki-info neuvoo kaikissa Helsingin kaupungin palveluihin liittyvissä kysymyksissä ja maahanmuuttoon liittyvissä asioissa. Palvelumme on maksutonta, asiantuntevaa, luotettavaa, monikanavaista ja monikielistä. Henkilökohtainen neuvonta palvelupisteissä: International House Helsinki IHH, osoite: Lintulahdenkuja 2 D, 2 krs. Palvelupisteemme IHH:ssa on avoinna ma 31.8 alkaen ma-to klo 9-16, pe klo 10-16 toistaiseksi vain IHH:n muiden toimijoiden ajanvarausasiakkaille.Keskustakirjasto Oodi, osoite: Töölönlahdenkatu 4, ensimmäinen kerros (ma-to klo 9-18 ja pe klo 10-18).Sähköiset palvelukanavat:Puhelin 09-310 11111 (puhelin- ja chat ma-to 9-16 ja pe klo 10-15).chat: https://www.hel.fi/kanslia/neuvonta-fi | Helsinki-info provides general information and advice on all Helsinki City services and immigration related matters. Our service is free of charge, confidential and based on years of experiences. We advise in several languages. Face- to- face service point: International House Helsinki (IHH), Address: Lintulahdenkuja 2, 2nd floor, Helsinki Our service point at International House Helsinki (IHH) is open Monday-Thursday at 9-16, Friday at 10-16 starting 31st of August. For the time being our service at IHH is only for appointment customers of other IHH partners.Central Library Oodi, First Floor, Helsinki-info's Service Point (Mon-Thu 9-18 & Fri 10-18). Address: Töölönlahdenkatu 4, Helsinki.You can also call or chat with us.- Tel. 09-310 11111 (Mon-Thu 9-16 & Fri 10-15)- chat: https://www.hel.fi/kanslia/neuvonta-en | Helsinki-info - International House Helsinki -palvelupiste | Helsinki-info - International House Helsinki | Lintulahdenkuja 2 D, 2. krs Helsinki | Fågelviksgränden 2 D, 2. vån. Helsinki | Lintulahdenkuja 2 D, 2. floor Helsinki | https://www.hel.fi/kanslia/neuvonta-fi/ | https://www.hel.fi/kanslia/neuvonta-sv | https://www.hel.fi/kanslia/neuvonta-en | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 11111 | +358 9 310 36064 | helsinki.palaute@hel.fi | 2013-12-05T08:08:14+02:00 | 00530 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:33.518829+02: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"} | [783, 1401, 1402] | helsinki | [319, 189, 857] | [809, 420] | {"fi": ["opastus", "Helsinki-info", "info", "kaupungin neuvontapalvelu", "maahanmuuttoneuvonta", "ohjaus", "neuvonta"], "sv": ["Helsingfors-info", "r\u00e5dgivning", "Helsingfors stads r\u00e5dgivings service"], "en": ["Helsinki-info", "Advice", "Guidance", "Info", "City Service Point", "Immigration Advisory Service"]} | Point | 24.960548 | 60.182697 | PL 1, 00099 Helsingin kaupunki | Helsingfors-info - International House Helsinki | Helsinki-infon neuvonjat antavat henkilökohtaista neuvontaa International House Helsinki - palvelupisteellä Lintulahdenkuja 2:ssa. | 2 | 7 | 1 | P.O. Box 1, 00099 City of Helsinki | 1 | 6 | PB 1, 00099 Helsingfors stad | Vi ger råd när du söker information om stadens tjänster eller invandringsfrågor. | Vi ger råd när du söker information om stadens tjänster eller invandringsfrågor. Vi betjänar dig på flera språk, med många års erfarenhet och via flera kanaler. Vill du konsultera ansikte mot ansikte, kan du besöka centrumbiblioteket Odet eller vår servicepunkt vid Internaltional House Helsinki (IHH). Internaltional House HelsinkiVår servicepunkt i IHH betjänar fr.o.m. må den 31.8. må-to kl. 9-16, fre kl. 10-16 för tillfället bara kunder med tidsbeställning till våra samarbetspartner i IHH.Centrumbibliotek Ode, Helsingfors-info (må-to kl. 9-18, fre kl. 10-18) Du kan också kontakta oss via chatt eller telefon.Tel. 09 31011 111 chatt: https://www.hel.fi/kanslia/neuvonta-sv Telefon- och chattservice öppet må-to 9-16, fre 10-15. | 7 | Helsinki-info provides general information and advice on all Helsinki City services and immigration related matters. | ||||||||||||||||||||||||||
| 62001 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-to 09-16, pe 10-15", "sv": "\u00f6ppet m\u00e5n-tor 09-16, fre 10-15", "en": "open Mon-Thu 09-16, Fri 10-15"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "COVID-19: Koronavirustilanteesta johtuen palvelemme 30.11 alkaen ainoastaan chat- sek\u00e4 puhelinneuvonnan kautta. Muut palvelupisteemme ovat toistaiseksi suljettu. Pahoittelemme t\u00e4st\u00e4 aiheutuvaa vaivaa.", "sv": "COVID-19: P\u00e5 grund av coronal\u00e4get, betj\u00e4nar vi fr\u00e5n och med 30 november endast via chatt och telefonr\u00e5dgivning. V\u00e5ra andra servicepunkter \u00e4r tillsvidare st\u00e4ngda. Vi beklagar eventuella ol\u00e4genheter som detta medf\u00f6r.", "en": "COVID-19: Due to the coronavirus situation, starting from November 30th, our advisory service will be available by chat and telephone only. Our other service points are closed until further notice. We apologize for the inconvenience."}, "www": null, "email": null, "phone": null, "contact_person": null}] | [] | internal | 30801 | c45ac068-2e9b-44c8-a93a-4eef7320ff90 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Helsinki-info neuvoo kaikissa Helsingin kaupungin palveluihin liittyvissä kysymyksissä ja maahanmuuttoon liittyvissä asioissa. Palvelumme on maksutonta, asiantuntevaa, luotettavaa, monikanavaista ja monikielistä. COVID-19: Koronavirustilanteesta johtuen palvelemme 30.11 alkaen ainoastaan chat- sekä puhelinneuvonnan kautta. Muut palvelupisteemme ovat toistaiseksi suljettu. Pahoittelemme tästä aiheutuvaa vaivaa.Henkilökohtainen neuvonta palvelupisteissä: 1. Keskustakirjasto Oodi (toistaiseksi suljettu), osoite: Töölönlahdenkatu 4, ensimmäinen kerros2. International House Helsinki IHH (toistaiseksi suljettu), osoite: Lintulahdenkuja 2 D, toinen kerros.Sähköiset palvelukanavat:- Puhelin 09-310 11111 (puhelin- ja chat ma-to 9-16 ja pe klo 10-15)- chat: https://www.hel.fi/kanslia/neuvonta-fi Poikkeusaukioloajat: Keskiviikkona 23.12. Helsinki-infon puhelinneuvonta ja chat suljetaan jo klo 15.Torstaina 31.12. Helsinki-infon puhelinneuvonta ja chat suljetaan klo 15.Tiistaina 5.1.2021 Helsinki-infon puhelinneuvonta ja chat suljetaan klo 15. | Helsinki-info provides general information and advice on all Helsinki City services and immigration related matters. Our service is free of charge, confidential and based on years of experiences. We advise in several languages. COVID-19: Due to the coronavirus situation, starting from November 30th, our advisory service will be available by chat and telephone only. Our other service points are closed until further notice. We apologize for the inconvenience. Face- to- face service point: 1. Central Library Oodi, First Floor, Helsinki-info Service Point. Address: Töölönlahdenkatu 4, Helsinki, closed until further notice.2. International House Helsinki (IHH), Address: Lintulahdenkuja 2D, 2nd floor. Helsinki, closed until further notice.You can call or chat with us.- Tel. 09-310 11111 (open Mon-Thu 9-16, Fri 10-15)- chat: https://www.hel.fi/kanslia/neuvonta-en Exceptional opening hours: On Wednesday December 23rd, Helsinki-info telephone and chat advisory service will close at 3 pm.On Thursday December 31st, Helsinki-info telephone and chat advisory service will close at 3 pm.On Tuesday January 5th, 2021, Helsinki-info telephone and chat advisory service will close at 3 pm. | Helsinki-info | Helsinki-info | Töölönlahdenkatu 4 | Tölöviksgatan 4 | Töölönlahdenkatu 4 | https://www.hel.fi/kanslia/neuvonta-fi | https://www.hel.fi/kanslia/neuvonta-sv | https://www.hel.fi/kanslia/neuvonta-en | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 11111 | 2020-02-11T17:01:10+02:00 | 00100 | www.hel.fi | kaikki | helsinki | 2020-12-21T12:01:53.722105+02:00 | [1402] | helsinki | [319] | [809] | {"en": ["guidance", "immigration advisory service", "Helsinki info", "advice", "info", "city information service"], "fi": ["opastus", "Helsinki-info", "info", "kaupungin neuvontapalvelu", "maahanmuuttoneuvonta", "ohjaus", "neuvonta"], "sv": ["Helsingfors-info", "r\u00e5dgivning", "Helsingfors stads r\u00e5dgivings service", "Helsingfors stads r\u00e5dgivings p"]} | Point | 24.938255 | 60.173855 | Helsingfors-info | Neuvomme ja opastamme, kun etsit tietoa kaupungin palveluista tai maahanmuuttoon liittyvistä asioista. | Vi ger råd när du söker information om stadens tjänster eller invandringsfrågor. | Vi ger råd när du söker information om stadens tjänster eller invandringsfrågor. Vi betjänar dig på flera språk, med många års erfarenhet och via flera kanaler. Vill du konsultera ansikte mot ansikte, kan du besöka centrumbiblioteket Odet eller vår servicepunkt vid Internaltional House Helsinki (IHH). COVID-19: På grund av coronaläget, betjänar vi från och med 30 november endast via chatt och telefonrådgivning. Våra andra servicepunkter är tillsvidare stängda. Vi beklagar eventuella olägenheter som detta medför.1. Centrumbibliotek Ode, Helsingfors-info (stängt tillsvidare)2. Internaltional House Helsinki (stängt tillsvidare) Du kan också kontakta oss via chatt eller telefon.Tel. 09 31011 111 chatt: https://www.hel.fi/kanslia/neuvonta-sv Telefon- och chattservice öppet må-to kl. 9-16, fre kl. 10-15Särskilda öppettider: På onsdagen den 23.12. stänger Helsingfors-infos telefon- och chatrådgivning kl. 15.På torsdagen den 31.12. stänger Helsingfors-infos telefon- och chatrådgivning kl. 15. På tisdagen den 5.1.21 stänger Helsingfors-infos telefon- och chatrådgivning kl. 15. | We advise and guide you when looking for information on the city services and immigration related matters. |
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 );