unit_connection

14,121 rows sorted by name_fi

✎ View and edit SQL

This data as json, CSV (advanced)

id section_type name_fi ▼ www_fi phone contact_person unit www www_sv name_sv name_en www_en name
203838 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 30561     Regional koordinator Regional coordinator    
203842 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 30642     Regional koordinator Regional coordinator    
203846 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 30762     Regional koordinator Regional coordinator    
203852 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 30830     Regional koordinator Regional coordinator    
203966 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 32552     Regional koordinator Regional coordinator    
203972 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 32553     Regional koordinator Regional coordinator    
203976 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 32555     Regional koordinator Regional coordinator    
203981 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 32556     Regional koordinator Regional coordinator    
203986 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 32557     Regional koordinator Regional coordinator    
203991 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 32826     Regional koordinator Regional coordinator    
203995 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 32828     Regional koordinator Regional coordinator    
204139 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 34130     Regional koordinator Regional coordinator    
204144 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 34237     Regional koordinator Regional coordinator    
204148 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 34255     Regional koordinator Regional coordinator    
207863 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 43688     Regional koordinator Regional coordinator    
207874 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 43743     Regional koordinator Regional coordinator    
207880 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 43774     Regional koordinator Regional coordinator    
207915 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 43876     Regional koordinator Regional coordinator    
207920 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 43877     Regional koordinator Regional coordinator    
207925 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 43878     Regional koordinator Regional coordinator    
207930 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 43879     Regional koordinator Regional coordinator    
207935 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 43885     Regional koordinator Regional coordinator    
207971 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 44526     Regional koordinator Regional coordinator    
207978 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 44581     Regional koordinator Regional coordinator    
208402 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 46708     Regional koordinator Regional coordinator    
208407 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 46709     Regional koordinator Regional coordinator    
208412 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 46710     Regional koordinator Regional coordinator    
208417 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 46727     Regional koordinator Regional coordinator    
208422 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 46777     Regional koordinator Regional coordinator    
208425 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 46808     Regional koordinator Regional coordinator    
208429 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 46823     Regional koordinator Regional coordinator    
208433 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 46842     Regional koordinator Regional coordinator    
208437 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 46843     Regional koordinator Regional coordinator    
208441 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 46844     Regional koordinator Regional coordinator    
208445 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 46859     Regional koordinator Regional coordinator    
208457 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 46937     Regional koordinator Regional coordinator    
208461 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 46941     Regional koordinator Regional coordinator    
208465 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 46943     Regional koordinator Regional coordinator    
208478 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 47002     Regional koordinator Regional coordinator    
208482 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 47003     Regional koordinator Regional coordinator    
208486 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 47004     Regional koordinator Regional coordinator    
208498 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 47009     Regional koordinator Regional coordinator    
208893 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 52880     Regional koordinator Regional coordinator    
208898 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 52881     Regional koordinator Regional coordinator    
208903 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 52884     Regional koordinator Regional coordinator    
208907 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 52885     Regional koordinator Regional coordinator    
208915 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 52888     Regional koordinator Regional coordinator    
208919 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 52889     Regional koordinator Regional coordinator    
208924 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 52890     Regional koordinator Regional coordinator    
209035 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 54412     Regional koordinator Regional coordinator    
209041 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 54413     Regional koordinator Regional coordinator    
209047 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 54414     Regional koordinator Regional coordinator    
209053 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 54415     Regional koordinator Regional coordinator    
209063 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 54451     Regional koordinator Regional coordinator    
209068 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 54453     Regional koordinator Regional coordinator    
209073 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 54454     Regional koordinator Regional coordinator    
209672 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 57029     Regional koordinator Regional coordinator    
209678 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 57031     Regional koordinator Regional coordinator    
209684 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 57032     Regional koordinator Regional coordinator    
209688 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 57033     Regional koordinator Regional coordinator    
209704 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 57045     Regional koordinator Regional coordinator    
209722 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 57072     Regional koordinator Regional coordinator    
209776 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 57117     Regional koordinator Regional coordinator    
210016 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 57281     Regional koordinator Regional coordinator    
210884 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 59246     Regional koordinator Regional coordinator    
210892 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 59248     Regional koordinator Regional coordinator    
210896 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 59250     Regional koordinator Regional coordinator    
210900 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 59251     Regional koordinator Regional coordinator    
210904 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 59252     Regional koordinator Regional coordinator    
210924 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 59290     Regional koordinator Regional coordinator    
210939 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 59304     Regional koordinator Regional coordinator    
211112 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 59855     Regional koordinator Regional coordinator    
211117 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 59860     Regional koordinator Regional coordinator    
211121 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 59861     Regional koordinator Regional coordinator    
211149 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 59903     Regional koordinator Regional coordinator    
212188 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 62044     Regional koordinator Regional coordinator    
212200 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 62051     Regional koordinator Regional coordinator    
212204 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 62052     Regional koordinator Regional coordinator    
212208 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 62053     Regional koordinator Regional coordinator    
212212 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 62055     Regional koordinator Regional coordinator    
212221 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 62059     Regional koordinator Regional coordinator    
212225 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 62070     Regional koordinator Regional coordinator    
212229 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 62071     Regional koordinator Regional coordinator    
212233 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 62072     Regional koordinator Regional coordinator    
212367 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 62677     Regional koordinator Regional coordinator    
212373 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 62678     Regional koordinator Regional coordinator    
223192 PHONE_OR_EMAIL Aluekoordinaattori     Maija Jaskara 63356     Regional koordinator Regional coordinator    
219543 OPENING_HOURS Alvar Aallon kotitalo ja Alvar Aallon ateljee ovat suljettuina 30.11. - 20.12.2020 välisen ajan.       20974     Alvar Aaltos hem och Studio Aalto har stängt 30.11.-20.12.2020. The Aalto House and Studio Aalto are closed 30.11.-20.12.2020.    
202004 OPENING_HOURS American Bar on suljettu 12/2019 alkaen hotellin peruskorjauksen ajaksi.       21289     American Bar har stängt fr.o.m 12/2019 p.g.a. grundrenovering av hotellfastigheten. American Bar is closed from 12/2019 onwards due to renovation of the hotel building.    
219855 OPENING_HOURS Amos Rex on suljettu ajalla 30.11.-25.12. pääkaupunkiseudun korona-linjausten mukaisesti       55959     Amos Rex har stängt 30.11.-25.12. enligt huvudstadsregionens corona-föreskrifter. Amos Rex is closed during 30.11.-25.12. due to the metropolitan area Corona-regulations.    
17985 LINK Anna palautetta https://easiointi.espoo.fi/eFeedback/fi/Home     15303            
17988 LINK Anna palautetta https://easiointi.espoo.fi/eFeedback/fi/Home     15306            
17989 LINK Anna palautetta https://easiointi.espoo.fi/eFeedback/fi/Home     15307            
17990 LINK Anna palautetta https://easiointi.espoo.fi/eFeedback/fi/Home     15308            
18017 LINK Anna palautetta https://easiointi.espoo.fi/eFeedback/fi/Home     15323            
18020 LINK Anna palautetta https://easiointi.espoo.fi/eFeedback/fi/Home     15326            
18031 LINK Anna palautetta https://easiointi.espoo.fi/eFeedback/fi/Home     15335            
18034 LINK Anna palautetta https://easiointi.espoo.fi/eFeedback/fi/Home     15338            
18049 LINK Anna palautetta https://easiointi.espoo.fi/eFeedback/fi/Home     15351            
18050 LINK Anna palautetta https://easiointi.espoo.fi/eFeedback/fi/Home     15352            

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [unit_connection] (
   [id] INTEGER PRIMARY KEY,
   [section_type] TEXT,
   [name_fi] TEXT,
   [www_fi] TEXT,
   [email] TEXT,
   [phone] TEXT,
   [contact_person] TEXT,
   [unit] INTEGER,
   [www] TEXT,
   [www_sv] TEXT,
   [name_sv] TEXT,
   [name_en] TEXT,
   [www_en] TEXT,
   [name] TEXT
);