unit_connection
14,121 rows sorted by name_en 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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
197948 | OPENING_HOURS | avoinna alkaen 8.8.2019 ma-pe 09-16 | 358 | öppet från 8.8.2019 mån-fre 09-16 | open from 8 Aug 2019 Mon-Fri 09-16 | ||||||||
217450 | OPENING_HOURS | avoinna alkaen 7.9.2020 ma-pe 08-16 | 5552 | öppet från 7.9.2020 mån-fre 08-16 | open from 7 Sep 2020 Mon-Fri 08-16 | ||||||||
198430 | OPENING_HOURS | avoinna alkaen 7.10.2020 ma-pe 07-15 | 6460 | öppet från 7.10.2020 mån-fre 07-15 | open from 7 Oct 2020 Mon-Fri 07-15 | ||||||||
203695 | OPENING_HOURS | avoinna alkaen 6.10.2020 ma-to 08-15:30, pe 08-14:30 | 28904 | öppet från 6.10.2020 mån-tor 08-15:30, fre 08-14:30 | open from 6 Oct 2020 Mon-Thu 08-15:30, Fri 08-14:30 | ||||||||
212466 | OPENING_HOURS | avoinna alkaen 4.8.2020 ti, to 07:30-12 | 62830 | öppet från 4.8.2020 tis, tor 07:30-12 | open from 4 Aug 2020 Tue, Thu 07:30-12 | ||||||||
212429 | OPENING_HOURS | avoinna alkaen 20.7.2020 ma-pe 07:15-14 | 62798 | öppet från 20.7.2020 mån-fre 07:15-14 | open from 20 Jul 2020 Mon-Fri 07:15-14 | ||||||||
207835 | OPENING_HOURS | avoinna alkaen 19.11.2014 ma-pe 08- | 43435 | öppet från 19.11.2014 mån-fre 08- | open from 19 Nov 2014 Mon-Fri 08- | ||||||||
212452 | OPENING_HOURS | avoinna alkaen 18.8.2020 ti, to 08-11 | 62818 | öppet från 18.8.2020 tis, tor 08-11 | open from 18 Aug 2020 Tue, Thu 08-11 | ||||||||
212461 | OPENING_HOURS | avoinna alkaen 1.7.2020 ma-pe 07-14:30 | 62825 | öppet från 1.7.2020 mån-fre 07-14:30 | open from 1 Jul 2020 Mon-Fri 07-14:30 | ||||||||
201421 | OPENING_HOURS | avoinna joka päivä ympäri vuorokauden | 19747 | öppet dygnet runt varje dag | open every day around the clock | ||||||||
209168 | OPENING_HOURS | avoinna joka päivä ympäri vuorokauden | 54608 | öppet dygnet runt varje dag | open every day around the clock | ||||||||
210245 | OPENING_HOURS | avoinna joka päivä ympäri vuorokauden | 58033 | öppet dygnet runt varje dag | open every day around the clock | ||||||||
212594 | OPENING_HOURS | avoinna joka päivä ympäri vuorokauden | 63082 | öppet dygnet runt varje dag | open every day around the clock | ||||||||
223990 | OPENING_HOURS | avoinna joka päivä ympäri vuorokauden | 35002 | öppet dygnet runt varje dag | open every day around the clock | ||||||||
201630 | OPENING_HOURS | avoinna joka päivä 22-05 | 20431 | öppet varje dag 22-05 | open every day 22-05 | ||||||||
201827 | OPENING_HOURS | avoinna joka päivä 20-05 | 20892 | öppet varje dag 20-05 | open every day 20-05 | ||||||||
219585 | OPENING_HOURS | avoinna joka päivä 18-01 | 57614 | öppet varje dag 18-01 | open every day 18-01 | ||||||||
210160 | OPENING_HOURS | avoinna joka päivä 17-23 | 57630 | öppet varje dag 17-23 | open every day 17-23 | ||||||||
211315 | OPENING_HOURS | avoinna joka päivä 17-04:30 | 60322 | öppet varje dag 17-04:30 | open every day 17-04:30 | ||||||||
208607 | OPENING_HOURS | avoinna joka päivä 16-02 | 50142 | öppet varje dag 16-02 | open every day 16-02 | ||||||||
201641 | OPENING_HOURS | avoinna joka päivä 14-05 | 20454 | öppet varje dag 14-05 | open every day 14-05 | ||||||||
221416 | OPENING_HOURS | avoinna joka päivä 14-02 | 63334 | öppet varje dag 14-02 | open every day 14-02 | ||||||||
203988 | OPENING_HOURS | avoinna joka päivä 12-23 | 32822 | öppet varje dag 12-23 | open every day 12-23 | ||||||||
209567 | OPENING_HOURS | avoinna joka päivä 12-04 | 56518 | öppet varje dag 12-04 | open every day 12-04 | ||||||||
209242 | OPENING_HOURS | avoinna joka päivä 12-02 | 54727 | öppet varje dag 12-02 | open every day 12-02 | ||||||||
209352 | OPENING_HOURS | avoinna joka päivä 12-02 | 54907 | öppet varje dag 12-02 | open every day 12-02 | ||||||||
209358 | OPENING_HOURS | avoinna joka päivä 12-02 | 54917 | öppet varje dag 12-02 | open every day 12-02 | ||||||||
210161 | OPENING_HOURS | avoinna joka päivä 11-22 | 57631 | öppet varje dag 11-22 | open every day 11-22 | ||||||||
201954 | OPENING_HOURS | avoinna joka päivä 11-18 | 21190 | öppet varje dag 11-18 | open every day 11-18 | ||||||||
210180 | OPENING_HOURS | avoinna joka päivä 11-18 | 57681 | öppet varje dag 11-18 | open every day 11-18 | ||||||||
201996 | OPENING_HOURS | avoinna joka päivä 11-17 | 21274 | öppet varje dag 11-17 | open every day 11-17 | ||||||||
221915 | OPENING_HOURS | avoinna joka päivä 11-16:30 | 20587 | öppet varje dag 11-16:30 | open every day 11-16:30 | ||||||||
209210 | OPENING_HOURS | avoinna joka päivä 11-15 | 54669 | öppet varje dag 11-15 | open every day 11-15 | ||||||||
209220 | OPENING_HOURS | avoinna joka päivä 10-24 | 54690 | öppet varje dag 10-24 | open every day 10-24 | ||||||||
215713 | OPENING_HOURS | avoinna joka päivä 10-22:30 | 54867 | öppet varje dag 10-22:30 | open every day 10-22:30 | ||||||||
209711 | OPENING_HOURS | avoinna joka päivä 10-19 | 57051 | öppet varje dag 10-19 | open every day 10-19 | ||||||||
201804 | OPENING_HOURS | avoinna joka päivä 10-18 | 20841 | öppet varje dag 10-18 | open every day 10-18 | ||||||||
210177 | OPENING_HOURS | avoinna joka päivä 10-16 | 57672 | öppet varje dag 10-16 | open every day 10-16 | ||||||||
212624 | OPENING_HOURS | avoinna joka päivä 09-23 | 54891 | öppet varje dag 09-23 | open every day 09-23 | ||||||||
209288 | OPENING_HOURS | avoinna joka päivä 09-21 | 54814 | öppet varje dag 09-21 | open every day 09-21 | ||||||||
211308 | OPENING_HOURS | avoinna joka päivä 09-21 | 60310 | öppet varje dag 09-21 | open every day 09-21 | ||||||||
212051 | OPENING_HOURS | avoinna joka päivä 09-21 | 61459 | öppet varje dag 09-21 | open every day 09-21 | ||||||||
208947 | OPENING_HOURS | avoinna joka päivä 09-20 | 53152 | öppet varje dag 09-20 | open every day 09-20 | ||||||||
209797 | OPENING_HOURS | avoinna joka päivä 09-20 | 57126 | öppet varje dag 09-20 | open every day 09-20 | ||||||||
209799 | OPENING_HOURS | avoinna joka päivä 09-20 | 57127 | öppet varje dag 09-20 | open every day 09-20 | ||||||||
207762 | OPENING_HOURS | avoinna joka päivä 09-18 | 43181 | öppet varje dag 09-18 | open every day 09-18 | ||||||||
201951 | OPENING_HOURS | avoinna joka päivä 09-17 | 21185 | öppet varje dag 09-17 | open every day 09-17 | ||||||||
212157 | OPENING_HOURS | avoinna joka päivä 08-22 | 62003 | öppet varje dag 08-22 | open every day 08-22 | ||||||||
214889 | OPENING_HOURS | avoinna joka päivä 08-22 | 50546 | öppet varje dag 08-22 | open every day 08-22 | ||||||||
214894 | OPENING_HOURS | avoinna joka päivä 08-22 | 50548 | öppet varje dag 08-22 | open every day 08-22 | ||||||||
214901 | OPENING_HOURS | avoinna joka päivä 08-22 | 50551 | öppet varje dag 08-22 | open every day 08-22 | ||||||||
214910 | OPENING_HOURS | avoinna joka päivä 08-22 | 50555 | öppet varje dag 08-22 | open every day 08-22 | ||||||||
214917 | OPENING_HOURS | avoinna joka päivä 08-22 | 50558 | öppet varje dag 08-22 | open every day 08-22 | ||||||||
214939 | OPENING_HOURS | avoinna joka päivä 08-22 | 50570 | öppet varje dag 08-22 | open every day 08-22 | ||||||||
199761 | OPENING_HOURS | avoinna joka päivä 08-20 | 10953 | öppet varje dag 08-20 | open every day 08-20 | ||||||||
199862 | OPENING_HOURS | avoinna joka päivä 08-16 | 14428 | öppet varje dag 08-16 | open every day 08-16 | ||||||||
209184 | OPENING_HOURS | avoinna joka päivä 07-22 | 54635 | öppet varje dag 07-22 | open every day 07-22 | ||||||||
212084 | OPENING_HOURS | avoinna joka päivä 07-22 | 61489 | öppet varje dag 07-22 | open every day 07-22 | ||||||||
209954 | OPENING_HOURS | avoinna joka päivä 07-21 | 57197 | öppet varje dag 07-21 | open every day 07-21 | ||||||||
201807 | OPENING_HOURS | avoinna joka päivä 07-19 | 20852 | öppet varje dag 07-19 | open every day 07-19 | ||||||||
208026 | OPENING_HOURS | avoinna joka päivä 06-22 | 45159 | öppet varje dag 06-22 | open every day 06-22 | ||||||||
201308 | OPENING_HOURS | avoinna joka päivä 06-06 | 19637 | öppet varje dag 06-06 | open every day 06-06 | ||||||||
208307 | OPENING_HOURS | avoinna joka päivä 00-23:59 | 46124 | öppet varje dag 00-23:59 | open every day 00-23:59 | ||||||||
215704 | OPENING_HOURS | avoinna ke-to 21-04, pe-la 21-04:30 | 33149 | öppet ons-tor 21-04, fre-lör 21-04:30 | open Wed-Thu 21-04, Fri-Sat 21-04:30 | ||||||||
215714 | OPENING_HOURS | avoinna ke-to 17-24, pe-la 16-24 | 54931 | öppet ons-tor 17-24, fre-lör 16-24 | open Wed-Thu 17-24, Fri-Sat 16-24 | ||||||||
202014 | OPENING_HOURS | avoinna ke-to 17-24, pe 17-03, la 14-03 | 21311 | öppet ons-tor 17-24, fre 17-03, lör 14-03 | open Wed-Thu 17-24, Fri 17-03, Sat 14-03 | ||||||||
223720 | OPENING_HOURS | avoinna ke-to 17-23, pe-la 17-24, su 16-21 | 57210 | öppet ons-tor 17-23, fre-lör 17-24, sön 16-21 | open Wed-Thu 17-23, Fri-Sat 17-24, Sun 16-21 | ||||||||
210069 | OPENING_HOURS | avoinna ke-to 16-24, pe-la 18-02 | 57376 | öppet ons-tor 16-24, fre-lör 18-02 | open Wed-Thu 16-24, Fri-Sat 18-02 | ||||||||
215711 | OPENING_HOURS | avoinna ke-to 16-24, pe-la 16-02 | 54858 | öppet ons-tor 16-24, fre-lör 16-02 | open Wed-Thu 16-24, Fri-Sat 16-02 | ||||||||
215709 | OPENING_HOURS | avoinna ke-to 16-23, pe-la 14-23 | 54561 | öppet ons-tor 16-23, fre-lör 14-23 | open Wed-Thu 16-23, Fri-Sat 14-23 | ||||||||
211093 | OPENING_HOURS | avoinna ke-to 16-22, pe-la 16-02 | 59808 | öppet ons-tor 16-22, fre-lör 16-02 | open Wed-Thu 16-22, Fri-Sat 16-02 | ||||||||
212900 | OPENING_HOURS | avoinna ke-to 16-22, pe 16-23, la 13-23 | 54922 | öppet ons-tor 16-22, fre 16-23, lör 13-23 | open Wed-Thu 16-22, Fri 16-23, Sat 13-23 | ||||||||
212593 | OPENING_HOURS | avoinna ke-to 16-21, pe 16-24, la 14-24, su 16-20 | 63078 | öppet ons-tor 16-21, fre 16-24, lör 14-24, sön 16-20 | open Wed-Thu 16-21, Fri 16-24, Sat 14-24, Sun 16-20 | ||||||||
219858 | OPENING_HOURS | avoinna ke-to 16-21, pe 16-23, la 14-23, su 14-20 | 61446 | öppet ons-tor 16-21, fre 16-23, lör 14-23, sön 14-20 | open Wed-Thu 16-21, Fri 16-23, Sat 14-23, Sun 14-20 | ||||||||
220339 | OPENING_HOURS | avoinna ke-to 11-18, pe-la 11-20, su 11-17 | 54911 | öppet ons-tor 11-18, fre-lör 11-20, sön 11-17 | open Wed-Thu 11-18, Fri-Sat 11-20, Sun 11-17 | ||||||||
212920 | OPENING_HOURS | avoinna ke-to 08-24, pe 08-00:30, la 09-00:30 | 57615 | öppet ons-tor 08-24, fre 08-00:30, lör 09-00:30 | open Wed-Thu 08-24, Fri 08-00:30, Sat 09-00:30 | ||||||||
211071 | OPENING_HOURS | avoinna ke-su 12-18 | 59444 | öppet ons-sön 12-18 | open Wed-Sun 12-18 | ||||||||
201831 | OPENING_HOURS | avoinna ke-su 11-17 | 20897 | öppet ons-sön 11-17 | open Wed-Sun 11-17 | ||||||||
210275 | OPENING_HOURS | avoinna ke-su 11-16 | 58475 | öppet ons-sön 11-16 | open Wed-Sun 11-16 | ||||||||
204229 | OPENING_HOURS | avoinna ke-su 07-11 | 35004 | öppet ons-sön 07-11 | open Wed-Sun 07-11 | ||||||||
209366 | OPENING_HOURS | avoinna ke-la 18:30-23 | 54926 | öppet ons-lör 18:30-23 | open Wed-Sat 18:30-23 | ||||||||
215702 | OPENING_HOURS | avoinna ke-la 18-04:30, su 20-04:30 | 21218 | öppet ons-lör 18-04:30, sön 20-04:30 | open Wed-Sat 18-04:30, Sun 20-04:30 | ||||||||
209621 | OPENING_HOURS | avoinna ke-la 17-23 | 56693 | öppet ons-lör 17-23 | open Wed-Sat 17-23 | ||||||||
211316 | OPENING_HOURS | avoinna ke-la 17-23 | 60323 | öppet ons-lör 17-23 | open Wed-Sat 17-23 | ||||||||
209357 | OPENING_HOURS | avoinna ke-la 17-22 | 54915 | öppet ons-lör 17-22 | open Wed-Sat 17-22 | ||||||||
211273 | OPENING_HOURS | avoinna ke-la 16-24 | 60198 | öppet ons-lör 16-24 | open Wed-Sat 16-24 | ||||||||
223652 | OPENING_HOURS | avoinna ke-la 16-23 | 61447 | öppet ons-lör 16-23 | open Wed-Sat 16-23 | ||||||||
201998 | OPENING_HOURS | avoinna ke-la 12-18 | 21284 | öppet ons-lör 12-18 | open Wed-Sat 12-18 | ||||||||
223644 | OPENING_HOURS | avoinna ke-pe 17-23, la 14:30-23 | 57166 | öppet ons-fre 17-23, lör 14:30-23 | open Wed-Fri 17-23, Sat 14:30-23 | ||||||||
201647 | OPENING_HOURS | avoinna ke-pe 16-22, la 14-22 | 20461 | öppet ons-fre 16-22, lör 14-22 | open Wed-Fri 16-22, Sat 14-22 | ||||||||
223732 | OPENING_HOURS | avoinna ke-pe 15-23, la 12-23, su 12-20 | 63370 | öppet ons-fre 15-23, lör 12-23, sön 12-20 | open Wed-Fri 15-23, Sat 12-23, Sun 12-20 | ||||||||
209193 | OPENING_HOURS | avoinna ke-pe 13-18, la 12-18 | 54650 | öppet ons-fre 13-18, lör 12-18 | open Wed-Fri 13-18, Sat 12-18 | ||||||||
202015 | OPENING_HOURS | avoinna ke-pe 12-18, la 11-16 | 21312 | öppet ons-fre 12-18, lör 11-16 | open Wed-Fri 12-18, Sat 11-16 | ||||||||
209207 | OPENING_HOURS | avoinna ke-pe 12-18, la 11-15 | 54667 | öppet ons-fre 12-18, lör 11-15 | open Wed-Fri 12-18, Sat 11-15 | ||||||||
208609 | OPENING_HOURS | avoinna ke-pe 12-17, la 12-16 | 50145 | öppet ons-fre 12-17, lör 12-16 | open Wed-Fri 12-17, Sat 12-16 | ||||||||
211095 | OPENING_HOURS | avoinna ke-pe 12-17, la 11-15 | 59822 | öppet ons-fre 12-17, lör 11-15 | open Wed-Fri 12-17, Sat 11-15 | ||||||||
201825 | OPENING_HOURS | avoinna ke-pe 11:30-24, la 18-24 | 20891 | öppet ons-fre 11:30-24, lör 18-24 | open Wed-Fri 11:30-24, Sat 18-24 | ||||||||
223649 | OPENING_HOURS | avoinna ke-pe 11:30-24, la 17-24 | 60335 | öppet ons-fre 11:30-24, lör 17-24 | open Wed-Fri 11:30-24, Sat 17-24 | ||||||||
223704 | OPENING_HOURS | avoinna ke-pe 11:30-23, la-su 16-23 | 34782 | öppet ons-fre 11:30-23, lör-sön 16-23 | open Wed-Fri 11:30-23, Sat-Sun 16-23 | ||||||||
212170 | OPENING_HOURS | avoinna ke-pe 11-22, la 12-22, su 12-19 | 62017 | öppet ons-fre 11-22, lör 12-22, sön 12-19 | open Wed-Fri 11-22, Sat 12-22, Sun 12-19 |
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 );