unit_connection

2,016 rows where section_type = "PHONE_OR_EMAIL" sorted by name_fi

✎ View and edit SQL

This data as json, CSV (advanced)

section_type ✖

  • PHONE_OR_EMAIL · 2,016 ✖
id section_type name_fi ▼ www_fi phone contact_person unit www www_sv name_sv name_en www_en name
130086 PHONE_OR_EMAIL AKOS 1   +358 9 4716 6836   33429            
130087 PHONE_OR_EMAIL AKOS 2   +358 9 4716 6591   33429            
221476 PHONE_OR_EMAIL Aikido       63337            
221479 PHONE_OR_EMAIL Aikido       63338            
199089 PHONE_OR_EMAIL Aino Avoin Oppimiskeskus   +358 9 310 88588   7606            
203557 PHONE_OR_EMAIL Aino, avoin oppimiskeskus   +358 9 310 88588   26150            
197086 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 139     Regional koordinator Regional coordinator    
197435 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 233     Regional koordinator Regional coordinator    
197711 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 299     Regional koordinator Regional coordinator    
197875 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 337     Regional koordinator Regional coordinator    
198141 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 443     Regional koordinator Regional coordinator    
198475 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 6668     Regional koordinator Regional coordinator    
198552 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 6750     Regional koordinator Regional coordinator    
198588 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 6790     Regional koordinator Regional coordinator    
198596 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 6793     Regional koordinator Regional coordinator    
198660 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 6905     Regional koordinator Regional coordinator    
198676 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 6914     Regional koordinator Regional coordinator    
198705 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 6928     Regional koordinator Regional coordinator    
198721 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 6966     Regional koordinator Regional coordinator    
198748 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 6986     Regional koordinator Regional coordinator    
198782 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 7037     Regional koordinator Regional coordinator    
198831 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 7090     Regional koordinator Regional coordinator    
198887 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 7181     Regional koordinator Regional coordinator    
198974 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 7338     Regional koordinator Regional coordinator    
198978 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 7340     Regional koordinator Regional coordinator    
198982 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 7341     Regional koordinator Regional coordinator    
198986 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 7343     Regional koordinator Regional coordinator    
198990 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 7345     Regional koordinator Regional coordinator    
198994 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 7348     Regional koordinator Regional coordinator    
198998 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 7355     Regional koordinator Regional coordinator    
199002 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 7357     Regional koordinator Regional coordinator    
199010 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 7365     Regional koordinator Regional coordinator    
199669 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 9704     Regional koordinator Regional coordinator    
199673 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 9750     Regional koordinator Regional coordinator    
199682 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 10008     Regional koordinator Regional coordinator    
199703 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 10048     Regional koordinator Regional coordinator    
199707 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 10053     Regional koordinator Regional coordinator    
199711 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 10342     Regional koordinator Regional coordinator    
199884 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 14808     Regional koordinator Regional coordinator    
199892 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 14825     Regional koordinator Regional coordinator    
199896 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 14860     Regional koordinator Regional coordinator    
199915 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 15011     Regional koordinator Regional coordinator    
200007 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 79638, +358 40 728 5607 Elina Kauppinen 17004     Regional koordinator Regional coordinator    
200036 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 17758     Regional koordinator Regional coordinator    
200046 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 17847     Regional koordinator Regional coordinator    
203474 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 24955     Regional koordinator Regional coordinator    
203478 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 24967     Regional koordinator Regional coordinator    
203482 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 82249, +358 40 531 9718 Anni Löppönen 24973     Regional koordinator Regional coordinator    
203486 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 24992     Regional koordinator Regional coordinator    
203490 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 24993     Regional koordinator Regional coordinator    
203494 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 25075     Regional koordinator Regional coordinator    
203498 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 89205, +358 40 334 5825 Eeva Elsinen 25077     Regional koordinator Regional coordinator    
203502 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 25229     Regional koordinator Regional coordinator    
203506 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 25230     Regional koordinator Regional coordinator    
203510 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 25231     Regional koordinator Regional coordinator    
203514 PHONE_OR_EMAIL Aluekoordinaattori   +358 9 310 87103, +358 40 334 5826 Maija Jaskara 25235     Regional koordinator Regional coordinator    
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    

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