unit_connection
14,121 rows sorted by name_fi descending
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
206918 | PHONE_OR_EMAIL | uimakoulut ja ohjattu liikunta | +358 50 401 3582 | 40823 | simskolor | swimming schools and supervised sports | |||||||
207045 | PHONE_OR_EMAIL | uimakoulut ja ohjattu liikunta | +358 50 401 3629 | 41047 | simskolor | swimming schools and supervised sports | |||||||
221720 | PHONE_OR_EMAIL | uimahallin kassa | +358 9 310 87916 | 45900 | simhalls kassa | cashier | |||||||
223068 | PHONE_OR_EMAIL | uimahallin kassa | +358 9 310 87202 | 40759 | kassa | cashier | |||||||
218067 | PHONE_OR_EMAIL | työnjohtaja | maija.nareneva@hel.fi | +358 9 310 74152 | Maija Näreneva | 56622 | arbetsledare | foreman | |||||
206797 | OTHER_INFO | toimisto@hkk-talviuimarit.fi | 40606 | toimisto@hkk-talviuimarit.fi | toimisto@hkk-talviuimarit.fi | ||||||||
208171 | PHONE_OR_EMAIL | tiimiesimies, ma - to 7.00 - 15.30, pe 7.00 - 13.45 | +358 9 310 87976 | Mika Riihola | 45657 | teamchef, må - to 7.00 - 15.30, fr 7.00 - 13.45 | manager, Mon - Thu 7.00 - 15.30, Fri 7.00 - 13.45 | ||||||
221326 | PHONE_OR_EMAIL | tiimiesimies ma- pe 7.00 - 15.00 | +358 9 310 71503 | 40354 | teamchef må - fr 7.00 - 15.00 | manager Mon - Fri 7.00 - 15.00 | |||||||
206468 | PHONE_OR_EMAIL | tiimiesimies ma - to 7.00 - 15.30, pe 7.00 - 13.45 | +358 9 310 87976 | Mika Riihola | 39956 | teamchef må - to 7.00 - 15.30, fr 7.00 - 13.45 | manager Mon - Thu 7.00 - 15.30, Fri 7.00 - 13.45 | ||||||
206667 | PHONE_OR_EMAIL | tiimiesimies ma - to 7.00 - 15.30, pe 7.00 - 13.45 | +358 9 310 87503 | 40353 | teamchef må - to 7.00 - 15.30, fr 7.00 - 13.45 | manager Mon - Thu 7.00 - 15.30, Fri 7.00 - 13.45 | |||||||
206753 | PHONE_OR_EMAIL | tiimiesimies ma - to 7.00 - 15.30, pe 7.00 - 13.45 | +358 9 310 71513 | 40531 | teamchef må - to 7.00 - 15.30, fr 7.00 - 13.45 | manager Mon - Thu 7.00 - 15.30, Fri 7.00 - 13.45 | |||||||
207127 | PHONE_OR_EMAIL | tiimiesimies ma - to 7.00 - 15.30, pe 7.00 - 13.45 | +358 9 310 87976 | Mika Riihola | 41173 | teamchef må - to 7.00 - 15.30, fr 7.00 - 13.45 | manager Mon - Thu 7.00 - 15.30, Fri 7.00 - 13.45 | ||||||
208177 | PHONE_OR_EMAIL | tiimiesimies ma - to 7.00 - 15.30, pe 7.00 - 13.45 | +358 9 310 87976 | 45658 | teamchef må - to 7.00 - 15.30, fr 7.00 - 13.45 | manager Mon - Thu7.00 - 15.30, Fri 7.00 - 13.45 | |||||||
221461 | PHONE_OR_EMAIL | tiimiesimies ma - to 7.00 - 15.30, pe 7.00 - 13.45 | +358 9 310 87976 | 42284 | teamchef må - to 7.00 - 15.30, fr 7.00 - 13.45 | Manager Mon - Thu 7.00 - 15.30, Fri 7.00 - 13.45 | |||||||
221319 | PHONE_OR_EMAIL | tiimiesimies ma - pe 8.00 - 15.30 | +358 9 310 32578 | 40338 | teamchef må - fr 8.00 - 15.30 | manager Mon - Fri 8.00 - 15.30 | |||||||
221348 | PHONE_OR_EMAIL | tiimiesimies ma - pe 8.00 - 15.30 | +358 9 310 32578 | 45604 | teamchef må - fr 8.00 - 15.30 | manager Mon - Fri 8.00 - 15.30 | |||||||
221353 | PHONE_OR_EMAIL | tiimiesimies ma - pe 8.00 - 15.30 | +358 9 310 32578 | 45655 | teamchef må - fr 8.00 - 15.30 | manager Mon - Fri 8.00 - 15.30 | |||||||
207007 | PHONE_OR_EMAIL | tiimiesimies ma - pe 8.00 - 15.00 | +358 9 310 87503 | 40965 | teamchef må - fr 8.00 - 15.00 | manager Mon - Fri 8.00 - 15.00 | |||||||
208123 | PHONE_OR_EMAIL | tiimiesimies ma - pe 8.00 - 15.00 | +358 9 310 87000 | Jarkko Rantanen | 45645 | teamchef må - fr 8.00 - 15.00 | manager Mon - Fri 8.00 - 15.00 | ||||||
208152 | PHONE_OR_EMAIL | tiimiesimies ma - pe 8.00 - 15.00 | +358 9 310 87000 | Jarkko Rantanen | 45652 | teamchef må - fr 8.00 - 15.00 | manager Mon - Fri 8.00 - 15.00 | ||||||
206698 | PHONE_OR_EMAIL | tiimiesimies ma - pe 7.00 - 15.30 | +358 9 310 87503 | 40400 | teamchef må - fr 7.00 - 15.30 | manager Mon - Fri 7.00 - 15.30 | |||||||
208205 | PHONE_OR_EMAIL | tiimiesimies ma - pe 7.00 - 15.30 | +358 9 310 87942 | Jani Kurvinen | 45664 | teamchef ma - pe 7.00 - 15.30 | manager ma - pe 7.00 - 15.30 | ||||||
213759 | PHONE_OR_EMAIL | tiimiesimies ma - pe 7.00 - 15.30 | +358 9 310 87942 | Jani Kurvinen | 45660 | teamchef må - fr 7.00 - 15.30 | manager Mon - Fri 7.00 - 15.30 | ||||||
224107 | PHONE_OR_EMAIL | tiimiesimies ma - pe 7.00 - 15.30 | +358 9 310 64069 | 42185 | teamchef må - fr 7.00 - 15.30 | manager Mon - Fri 7.00 - 15.30 | |||||||
206756 | PHONE_OR_EMAIL | tiimiesimies ma - pe 7.00 - 15.15 | +358 9 310 87503 | 40532 | teamchef må - fr 7.00 - 15.15 | manager Mon - Fri 7.00 - 15.15 | |||||||
206548 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87503 | 40140 | teamchef | manager | |||||||
206651 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87503 | 40323 | teamchef | manager | |||||||
206816 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87503 | 40654 | teamchef | manager | |||||||
206917 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 71525 | Maritta Harjapää | 40823 | teamchef | manager | ||||||
207194 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87503 | 41385 | teamchef | manager | |||||||
207480 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87768 | 42062 | teamchef | manager | |||||||
207564 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87503 | 42275 | teamchef | manager | |||||||
208076 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87915 | Teijo Korva | 45596 | teamchef | manager | ||||||
208086 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87942 | Jani Kurvinen | 45611 | teamchef | manager | ||||||
208115 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87976 | Mika Riihola | 45642 | teanchef | manager | ||||||
208120 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 71504 | Tapio Haimilahti | 45643 | teamchef | manager | ||||||
208131 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87200 | Teemu Raatikainen | 45648 | teamchef | manager | ||||||
208140 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87000 | Jarkko Rantanen | 45650 | teamchef | manager | ||||||
208157 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 71504 | Tapio Haimilahti | 45653 | teamchef | manager | ||||||
208166 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87000 | Jarkko Rantanen | 45656 | teamchef | manager | ||||||
208182 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 71504 | Tapio Haimilahti | 45659 | teamchef | manager | ||||||
208193 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 71504 | Tapio Haimilahti | 45662 | teamchef | manager | ||||||
208199 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87000 | Jarkko Rantanen | 45663 | teamchef | manager | ||||||
208210 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 71504 | Tapio Haimilahti | 45665 | teamchef | manager | ||||||
208215 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87976 | Mika Riihola | 45666 | teamchef | manager | ||||||
208220 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87200 | Teemu Raatikainen | 45667 | teamchef | manager | ||||||
208242 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87200 | Teemu Raatikainen | 45926 | teamchef | Manager | ||||||
208260 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87819 | Teemu Haukilahti | 45928 | teamchef | Manager | ||||||
208267 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87819 | Teemu Haukilahti | 45929 | teamchef | Hall Manager | ||||||
220914 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87000 | Jarkko Rantanen | 40029 | teamchef | Manager | ||||||
221041 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87200 | Teemu Raatikainen | 40838 | teamchef | Manager | ||||||
221059 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87819 | Teemu Haukilahti | 41062 | ||||||||
221109 | PHONE_OR_EMAIL | tiimiesimies | +358 9 931 087 200 | Teemu Raatikainen | 41318 | teamchef | Manager | ||||||
221147 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87942 | Jani Kurvinen | 41767 | teamchef | Manager | ||||||
221197 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 71504 | Tapio Haimilahti | 42144 | teamchef | manager | ||||||
221713 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87915 | Teijo Korva | 42084 | teamchef | Manager | ||||||
221855 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87915 | Teijo Korva | 40774 | teamchef | Manager | ||||||
223200 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87530 | Lauri Immonen | 41540 | teamchef | Manager | ||||||
223299 | PHONE_OR_EMAIL | tiimiesimies | +358 40 334 1891 | Tommi Niskanen | 45634 | teamchef | manager | ||||||
223943 | PHONE_OR_EMAIL | tiimiesimies | +358 40 587 0858 | Kristian Kosonen | 40619 | teamchef | Manager | ||||||
223960 | PHONE_OR_EMAIL | tiimiesimies | +358 40 587 0858 | Kristian Kosonen | 50040 | teamchef | Manager | ||||||
224049 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 71504 | 40402 | teamchef | manager | |||||||
224070 | PHONE_OR_EMAIL | tiimiesimies | +358 9 310 87976 | 40493 | teamchef | manager | |||||||
221042 | PHONE_OR_EMAIL | tiedustelut uimakouluista | +358 9 310 87501 | 40838 | simskolor | enquiries about the swimming schools | |||||||
198428 | OPENING_HOURS | suljettu poikkeuksellisesti alkaen 23.3.2020 ma-pe | 6451 | undantagsvis stängt från 23.3.2020 mån-fre | exceptionally closed from 23 Mar 2020 Mon-Fri | ||||||||
203693 | OPENING_HOURS | suljettu poikkeuksellisesti alkaen 20.3.2020 ma-to 07:15-14:30, pe 07:15-13 | 28902 | undantagsvis stängt från 20.3.2020 mån-tor 07:15-14:30, fre 07:15-13 | exceptionally closed from 20 Mar 2020 Mon-Thu 07:15-14:30, Fri 07:15-13 | ||||||||
198431 | OPENING_HOURS | suljettu poikkeuksellisesti alkaen 18.3.2020 ma-pe 07:45-15 | 6461 | undantagsvis stängt från 18.3.2020 mån-fre 07:45-15 | exceptionally closed from 18 Mar 2020 Mon-Fri 07:45-15 | ||||||||
198433 | OPENING_HOURS | suljettu poikkeuksellisesti alkaen 18.3.2020 ma-pe 07:45-15 | 6463 | undantagsvis stängt från 18.3.2020 mån-fre 07:45-15 | exceptionally closed from 18 Mar 2020 Mon-Fri 07:45-15 | ||||||||
221918 | OPENING_HOURS | suljettu poikkeuksellisesti 30.11.2020 - 10.1.2021 | 8672 | undantagsvis stängt 30.11.2020 - 10.1.2021 | exceptionally closed 30 Nov 2020 - 10 Jan 2021 | ||||||||
221866 | OPENING_HOURS | suljettu poikkeuksellisesti 23.12.2020 - 6.1.2021 | 4399 | undantagsvis stängt 23.12.2020 - 6.1.2021 | exceptionally closed 23 Dec 2020 - 6 Jan 2021 | ||||||||
223249 | OPENING_HOURS | suljettu la-su | 46080 | stängt lör-sön | closed Sat-Sun | ||||||||
199325 | OPENING_HOURS | suljettu joka päivä | 8231 | stängt varje dag | closed every day | ||||||||
199369 | OPENING_HOURS | suljettu joka päivä | 8294 | stängt varje dag | closed every day | ||||||||
199380 | OPENING_HOURS | suljettu joka päivä | 8306 | stängt varje dag | closed every day | ||||||||
212603 | OPENING_HOURS | suljettu joka päivä | 63115 | stängt varje dag | closed every day | ||||||||
215693 | OPENING_HOURS | suljettu joka päivä | 59325 | stängt varje dag | closed every day | ||||||||
219255 | OPENING_HOURS | suljettu joka päivä | 59357 | stängt varje dag | closed every day | ||||||||
219256 | OPENING_HOURS | suljettu joka päivä | 59358 | stängt varje dag | closed every day | ||||||||
219258 | OPENING_HOURS | suljettu joka päivä | 59361 | stängt varje dag | closed every day | ||||||||
220770 | OPENING_HOURS | suljettu joka päivä | 18855 | stängt varje dag | closed every day | ||||||||
223101 | OPENING_HOURS | suljettu joka päivä | 59328 | stängt varje dag | closed every day | ||||||||
223119 | OPENING_HOURS | suljettu joka päivä | 59362 | stängt varje dag | closed every day | ||||||||
223120 | OPENING_HOURS | suljettu joka päivä | 59363 | stängt varje dag | closed every day | ||||||||
223121 | OPENING_HOURS | suljettu joka päivä | 59364 | stängt varje dag | closed every day | ||||||||
223374 | OPENING_HOURS | suljettu joka päivä | 8254 | stängt varje dag | closed every day | ||||||||
206839 | OTHER_INFO | sherrala@luukku.com | 40701 | sherrala@luukku.com | sherrala@luukku.com | ||||||||
208474 | OTHER_INFO | ruotsinkielinen perusopetus luokille 6-9 | 46979 | grundläggande utbildning på svenska för årskurserna 6-9 | basic education for grades 6-9 in Swedish | ||||||||
207939 | OTHER_INFO | ruotsinkielinen perusopetus luokille 1-5 | 43924 | grundläggande utbildning på svenska för årskurserna 1-5 | basic education for grades 1-5 in Swedish | ||||||||
204158 | OTHER_INFO | ruotsinkielinen perusopetus luokille 1-2 | 34376 | grundläggande utbildning på svenska för årskurserna 1-2 | basic education for grades 1-2 in Swedish | ||||||||
84573 | PHONE_OR_EMAIL | rikosilmoitusten vastaanotto | +358 29 541 3719 | 17863 | rikosilmoitusten vastaanotto | rikosilmoitusten vastaanotto | |||||||
207285 | OTHER_INFO | riitta.k.lampela@kolumbus.fi | 41594 | riitta.k.lampela@kolumbus.fi | riitta.k.lampela@kolumbus.fi | ||||||||
206552 | PHONE_OR_EMAIL | rannan henkilökunta | +358 9 310 21416, +358 40 670 0176 | 40142 | strandpersonal | beach personnel | |||||||
206561 | PHONE_OR_EMAIL | rannan henkilökunta | +358 9 310 71530 | 40150 | strandpersonal | beach personnel | |||||||
206566 | PHONE_OR_EMAIL | rannan henkilökunta | +358 40 191 6685 | 40157 | strandpersonal | beach personnel | |||||||
206621 | PHONE_OR_EMAIL | rannan henkilökunta | +358 9 310 79600 | 40258 | strandpersonal | beach personnel | |||||||
206677 | PHONE_OR_EMAIL | rannan henkilökunta | +358 9 310 71543 | 40356 | strandpersonal | beach personnel | |||||||
206688 | PHONE_OR_EMAIL | rannan henkilökunta | +358 9 310 71446 | 40386 | strandpersonal | beach personnel | |||||||
207002 | PHONE_OR_EMAIL | rannan henkilökunta | +358 9 310 71437 | 40950 | strandpersonal | beach personnel | |||||||
207289 | PHONE_OR_EMAIL | rannan henkilökunta | +358 9 310 23668 | 41601 | strandpersonal | beach personnel | |||||||
207466 | OTHER_INFO | puh. 09 310 87503, tiimiesimies | 42026 | tfn 09 310 87503 | tel 09 310 87503 |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );