unit_connection

14,121 rows sorted by name_sv descending

✎ View and edit SQL

This data as json, CSV (advanced)

section_type ✖

id section_type name_fi www_fi phone contact_person unit www www_sv name_sv ▲ name_en www_en name
198444 OPENING_HOURS ​Perusröntgentutkimuksia vain sairaalan potilaille sekä päivystyspotilaille luustokuvauksia traumaepäilyissä.       6476     ​Konventionella röntgenundersökningar endast på sjukhuset patienter samt på akutpatienter med remiss till skelettröntgen på grund av misstänkt trauma. General radiography examinations only on patients in treatment at the hospital and on emergency patients with a referral for general radiography due to a suspected trauma.    
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    
223653 OPENING_HOURS avoinna to-la 17-23       63359     öppet tor-lör 17-23 open Thu-Sat 17-23    
210271 OPENING_HOURS avoinna to-la 17-22       58469     öppet tor-lör 17-22 open Thu-Sat 17-22    
223647 OPENING_HOURS avoinna to-la 17-01       57834     öppet tor-lör 17-01 open Thu-Sat 17-01    
221504 OPENING_HOURS avoinna to-pe 18-02, la 16-02       20922     öppet tor-fre 18-02, lör 16-02 open Thu-Fri 18-02, Sat 16-02    
209251 OPENING_HOURS avoinna to-pe 14-18, la-su 12-16       54743     öppet tor-fre 14-18, lör-sön 12-16 open Thu-Fri 14-18, Sat-Sun 12-16    
211103 OPENING_HOURS avoinna to-pe 14-18, la-su 12-16       59842     öppet tor-fre 14-18, lör-sön 12-16 open Thu-Fri 14-18, Sat-Sun 12-16    
211096 OPENING_HOURS avoinna to-pe 12-19, la 11-16       59823     öppet tor-fre 12-19, lör 11-16 open Thu-Fri 12-19, Sat 11-16    
211161 OPENING_HOURS avoinna to-pe 12-18, la 13-16       59933     öppet tor-fre 12-18, lör 13-16 open Thu-Fri 12-18, Sat 13-16    
211394 OPENING_HOURS avoinna to-pe 11-18, la 11-15       60821     öppet tor-fre 11-18, lör 11-15 open Thu-Fri 11-18, Sat 11-15    
224436 OPENING_HOURS avoinna to-pe 10-16, suljettu ma-ke, la-su       59367     öppet tor-fre 10-16, stängt mån-ons, lör-sön open Thu-Fri 10-16, closed Mon-Wed, Sat-Sun    
224442 OPENING_HOURS avoinna to-pe 08-20, suljettu ma-ke, la-su       62988     öppet tor-fre 08-20, stängt mån-ons, lör-sön open Thu-Fri 08-20, closed Mon-Wed, Sat-Sun    
224427 OPENING_HOURS avoinna to-pe 07:30-20, suljettu ma-ke, la-su       59350     öppet tor-fre 07:30-20, stängt mån-ons, lör-sön open Thu-Fri 07:30-20, closed Mon-Wed, Sat-Sun    
223988 OPENING_HOURS avoinna to 21-03, pe-la 21-04:30       20739     öppet tor 21-03, fre-lör 21-04:30 open Thu 21-03, Fri-Sat 21-04:30    
220838 OPENING_HOURS avoinna to 21-03, pe-la 18-04:30       20441     öppet tor 21-03, fre-lör 18-04:30 open Thu 21-03, Fri-Sat 18-04:30    
212404 OPENING_HOURS avoinna to 18-21, su 13-18       62759     öppet tor 18-21, sön 13-18 open Thu 18-21, Sun 13-18    
223655 OPENING_HOURS avoinna to 17-22, pe-la 17-23       63361     öppet tor 17-22, fre-lör 17-23 open Thu 17-22, Fri-Sat 17-23    
210247 OPENING_HOURS avoinna to 14-18       58036     öppet tor 14-18 open Thu 14-18    
203810 OPENING_HOURS avoinna to 12-20, pe-su 12-16       30092     öppet tor 12-20, fre-sön 12-16 open Thu 12-20, Fri-Sun 12-16    
224415 OPENING_HOURS avoinna to 08-18, pe 08-15, suljettu ma-ke, la-su       59344     öppet tor 08-18, fre 08-15, stängt mån-ons, lör-sön open Thu 08-18, Fri 08-15, closed Mon-Wed, Sat-Sun    
223626 OPENING_HOURS avoinna ti-to, su 17-23, pe-la 16-23       28362     öppet tis-tor, sön 17-23, fre-lör 16-23 open Tue-Thu, Sun 17-23, Fri-Sat 16-23    
210255 OPENING_HOURS avoinna ti-to, la 10-19, pe, su 10-18       58168     öppet tis-tor, lör 10-19, fre, sön 10-18 open Tue-Thu, Sat 10-19, Fri, Sun 10-18    
204118 OPENING_HOURS avoinna ti-to 18-24, pe-la 17:30-24       33483     öppet tis-tor 18-24, fre-lör 17:30-24 open Tue-Thu 18-24, Fri-Sat 17:30-24    
209428 OPENING_HOURS avoinna ti-to 18-22, pe-la 18-23       56094     öppet tis-tor 18-22, fre-lör 18-23 open Tue-Thu 18-22, Fri-Sat 18-23    
203448 OPENING_HOURS avoinna ti-to 17-24, pe-la 17-02       24589     öppet tis-tor 17-24, fre-lör 17-02 open Tue-Thu 17-24, Fri-Sat 17-02    
204219 OPENING_HOURS avoinna ti-to 17-24, pe-la 17-02       34986     öppet tis-tor 17-24, fre-lör 17-02 open Tue-Thu 17-24, Fri-Sat 17-02    
223637 OPENING_HOURS avoinna ti-to 17-23, pe-la 16-23       54819     öppet tis-tor 17-23, fre-lör 16-23 open Tue-Thu 17-23, Fri-Sat 16-23    
223646 OPENING_HOURS avoinna ti-to 17-23, pe-la 13-23, su 13-21       57371     öppet tis-tor 17-23, fre-lör 13-23, sön 13-21 open Tue-Thu 17-23, Fri-Sat 13-23, Sun 13-21    
223638 OPENING_HOURS avoinna ti-to 17-22, pe-la 17-23, su 16-21       54895     öppet tis-tor 17-22, fre-lör 17-23, sön 16-21 open Tue-Thu 17-22, Fri-Sat 17-23, Sun 16-21    
211144 OPENING_HOURS avoinna ti-to 17-22, pe-la 17-23       59895     öppet tis-tor 17-22, fre-lör 17-23 open Tue-Thu 17-22, Fri-Sat 17-23    
211321 OPENING_HOURS avoinna ti-to 17-22, pe-la 17-23       60334     öppet tis-tor 17-22, fre-lör 17-23 open Tue-Thu 17-22, Fri-Sat 17-23    
223700 OPENING_HOURS avoinna ti-to 17-21, pe 11-21:30, la 15-21:30       24374     öppet tis-tor 17-21, fre 11-21:30, lör 15-21:30 open Tue-Thu 17-21, Fri 11-21:30, Sat 15-21:30    
209304 OPENING_HOURS avoinna ti-to 16-24, pe 16-02, la 15-02       54836     öppet tis-tor 16-24, fre 16-02, lör 15-02 open Tue-Thu 16-24, Fri 16-02, Sat 15-02    
211146 OPENING_HOURS avoinna ti-to 16-23, pe-la 16-24       59902     öppet tis-tor 16-23, fre-lör 16-24 open Tue-Thu 16-23, Fri-Sat 16-24    
211097 OPENING_HOURS avoinna ti-to 16-23, pe-la 16-01       59826     öppet tis-tor 16-23, fre-lör 16-01 open Tue-Thu 16-23, Fri-Sat 16-01    
215692 OPENING_HOURS avoinna ti-to 16-23, pe-la 15-23       54598     öppet tis-tor 16-23, fre-lör 15-23 open Tue-Thu 16-23, Fri-Sat 15-23    
210117 OPENING_HOURS avoinna ti-to 16-23, pe 16-00:30, la 13-23:30       57514     öppet tis-tor 16-23, fre 16-00:30, lör 13-23:30 open Tue-Thu 16-23, Fri 16-00:30, Sat 13-23:30    
210233 OPENING_HOURS avoinna ti-to 16-22, pe-la 16-23       57886     öppet tis-tor 16-22, fre-lör 16-23 open Tue-Thu 16-22, Fri-Sat 16-23    
201770 OPENING_HOURS avoinna ti-to 16-22, pe-la 14-22       20744     öppet tis-tor 16-22, fre-lör 14-22 open Tue-Thu 16-22, Fri-Sat 14-22    
213553 OPENING_HOURS avoinna ti-to 15-22, pe-la 15-23       60860     öppet tis-tor 15-22, fre-lör 15-23 open Tue-Thu 15-22, Fri-Sat 15-23    
213545 OPENING_HOURS avoinna ti-to 15-22, pe-la 12-23, su 12-20       54668     öppet tis-tor 15-22, fre-lör 12-23, sön 12-20 open Tue-Thu 15-22, Fri-Sat 12-23, Sun 12-20    
208312 OPENING_HOURS avoinna ti-to 15-21:30, pe-la 15-23       46154     öppet tis-tor 15-21:30, fre-lör 15-23 open Tue-Thu 15-21:30, Fri-Sat 15-23    
203758 OPENING_HOURS avoinna ti-to 15-19       29981     öppet tis-tor 15-19 open Tue-Thu 15-19    
210285 OPENING_HOURS avoinna ti-to 12-18, pe-la 12-16       58489     öppet tis-tor 12-18, fre-lör 12-16 open Tue-Thu 12-18, Fri-Sat 12-16    
204240 OPENING_HOURS avoinna ti-to 12-18       35202     öppet tis-tor 12-18 open Tue-Thu 12-18    
201888 OPENING_HOURS avoinna ti-to 12-17, pe-su 12-16       21034     öppet tis-tor 12-17, fre-sön 12-16 open Tue-Thu 12-17, Fri-Sun 12-16    
204116 OPENING_HOURS avoinna ti-to 11-24, pe 11-01, la 12-01       33478     öppet tis-tor 11-24, fre 11-01, lör 12-01 open Tue-Thu 11-24, Fri 11-01, Sat 12-01    
212628 OPENING_HOURS avoinna ti-to 11-22, pe-la 11-23       60333     öppet tis-tor 11-22, fre-lör 11-23 open Tue-Thu 11-22, Fri-Sat 11-23    
203450 OPENING_HOURS avoinna ti-to 11-21, pe 11-22, la 12-22, su 12-21       24610     öppet tis-tor 11-21, fre 11-22, lör 12-22, sön 12-21 open Tue-Thu 11-21, Fri 11-22, Sat 12-22, Sun 12-21    
209434 OPENING_HOURS avoinna ti-to 11-20, pe-la 12-22, su 12-18       56102     öppet tis-tor 11-20, fre-lör 12-22, sön 12-18 open Tue-Thu 11-20, Fri-Sat 12-22, Sun 12-18    
203431 OPENING_HOURS avoinna ti-to 11-20, pe 11-21, la 12-21       24486     öppet tis-tor 11-20, fre 11-21, lör 12-21 open Tue-Thu 11-20, Fri 11-21, Sat 12-21    

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