2,760 rows

View and edit SQL

Suggested facets: start, end, type, municipality, start (date), end (date), modified_at (date)

id ▼ origin_id ocd_id service_point_id start end modified_at type parent municipality name_fi name_sv name
1 5 ocd-division/country:fi/kunta:alajärvi       2020-06-15T15:05:54.583319+03:00 muni     Alajärvi Alajärvi  
2 9 ocd-division/country:fi/kunta:alavieska       2020-06-15T15:05:54.604123+03:00 muni     Alavieska Alavieska  
3 10 ocd-division/country:fi/kunta:alavus       2020-06-15T15:05:54.610677+03:00 muni     Alavus Alavus  
4 16 ocd-division/country:fi/kunta:asikkala       2020-06-15T15:05:54.618920+03:00 muni     Asikkala Asikkala  
5 18 ocd-division/country:fi/kunta:askola       2020-06-15T15:05:54.625382+03:00 muni     Askola Askola  
6 19 ocd-division/country:fi/kunta:aura       2020-06-15T15:05:54.631847+03:00 muni     Aura Aura  
7 35 ocd-division/country:fi/kunta:brändö       2020-06-15T15:05:54.640099+03:00 muni     Brändö Brändö  
8 43 ocd-division/country:fi/kunta:eckerö       2020-06-15T15:05:54.648288+03:00 muni     Eckerö Eckerö  
9 46 ocd-division/country:fi/kunta:enonkoski       2020-06-15T15:05:54.654712+03:00 muni     Enonkoski Enonkoski  
10 47 ocd-division/country:fi/kunta:enontekiö       2020-06-15T15:05:54.664501+03:00 muni     Enontekiö Enontekis  
11 49 ocd-division/country:fi/kunta:espoo       2020-06-15T15:05:54.673262+03:00 muni     Espoo Esbo  
12 50 ocd-division/country:fi/kunta:eura       2020-06-15T15:05:54.680361+03:00 muni     Eura Eura  
13 51 ocd-division/country:fi/kunta:eurajoki       2020-06-15T15:05:54.688272+03:00 muni     Eurajoki Euraåminne  
14 52 ocd-division/country:fi/kunta:evijärvi       2020-06-15T15:05:54.695707+03:00 muni     Evijärvi Evijärvi  
15 60 ocd-division/country:fi/kunta:finström       2020-06-15T15:05:54.703596+03:00 muni     Finström Finström  
16 61 ocd-division/country:fi/kunta:forssa       2020-06-15T15:05:54.710893+03:00 muni     Forssa Forssa  
17 62 ocd-division/country:fi/kunta:föglö       2020-06-15T15:05:54.717181+03:00 muni     Föglö Föglö  
18 65 ocd-division/country:fi/kunta:geta       2020-06-15T15:05:54.723234+03:00 muni     Geta Geta  
19 69 ocd-division/country:fi/kunta:haapajärvi       2020-06-15T15:05:54.730030+03:00 muni     Haapajärvi Haapajärvi  
20 71 ocd-division/country:fi/kunta:haapavesi       2020-06-15T15:05:54.737391+03:00 muni     Haapavesi Haapavesi  
21 72 ocd-division/country:fi/kunta:hailuoto       2020-06-15T15:05:54.743510+03:00 muni     Hailuoto Karlö  
22 74 ocd-division/country:fi/kunta:halsua       2020-06-15T15:05:54.749264+03:00 muni     Halsua Halsua  
23 75 ocd-division/country:fi/kunta:hamina       2020-06-15T15:05:54.756087+03:00 muni     Hamina Fredrikshamn  
24 76 ocd-division/country:fi/kunta:hammarland       2020-06-15T15:05:54.764159+03:00 muni     Hammarland Hammarland  
25 77 ocd-division/country:fi/kunta:hankasalmi       2020-06-15T15:05:54.771312+03:00 muni     Hankasalmi Hankasalmi  
26 78 ocd-division/country:fi/kunta:hanko       2020-06-15T15:05:54.777276+03:00 muni     Hanko Hangö  
27 79 ocd-division/country:fi/kunta:harjavalta       2020-06-15T15:05:54.782919+03:00 muni     Harjavalta Harjavalta  
28 81 ocd-division/country:fi/kunta:hartola       2020-06-15T15:05:54.789205+03:00 muni     Hartola Hartola  
29 82 ocd-division/country:fi/kunta:hattula       2020-06-15T15:05:54.796360+03:00 muni     Hattula Hattula  
30 86 ocd-division/country:fi/kunta:hausjärvi       2020-06-15T15:05:54.805027+03:00 muni     Hausjärvi Hausjärvi  
31 90 ocd-division/country:fi/kunta:heinävesi       2020-06-15T15:05:54.812768+03:00 muni     Heinävesi Heinävesi  
32 91 ocd-division/country:fi/kunta:helsinki       2020-06-15T15:05:54.819337+03:00 muni     Helsinki Helsingfors  
33 92 ocd-division/country:fi/kunta:vantaa       2020-06-15T15:05:54.825574+03:00 muni     Vantaa Vanda  
34 97 ocd-division/country:fi/kunta:hirvensalmi       2020-06-15T15:05:54.831295+03:00 muni     Hirvensalmi Hirvensalmi  
35 98 ocd-division/country:fi/kunta:hollola       2020-06-15T15:05:54.837308+03:00 muni     Hollola Hollola  
36 99 ocd-division/country:fi/kunta:honkajoki       2020-06-15T15:05:54.844842+03:00 muni     Honkajoki Honkajoki  
37 102 ocd-division/country:fi/kunta:huittinen       2020-06-15T15:05:54.850778+03:00 muni     Huittinen Huittinen  
38 103 ocd-division/country:fi/kunta:humppila       2020-06-15T15:05:54.856471+03:00 muni     Humppila Humppila  
39 105 ocd-division/country:fi/kunta:hyrynsalmi       2020-06-15T15:05:54.861850+03:00 muni     Hyrynsalmi Hyrynsalmi  
40 106 ocd-division/country:fi/kunta:hyvinkää       2020-06-15T15:05:54.867147+03:00 muni     Hyvinkää Hyvinge  
41 108 ocd-division/country:fi/kunta:hämeenkyrö       2020-06-15T15:05:54.872468+03:00 muni     Hämeenkyrö Tavastkyro  
42 109 ocd-division/country:fi/kunta:hämeenlinna       2020-06-15T15:05:54.878192+03:00 muni     Hämeenlinna Tavastehus  
43 139 ocd-division/country:fi/kunta:ii       2020-06-15T15:05:54.884256+03:00 muni     Ii Ii  
44 140 ocd-division/country:fi/kunta:iisalmi       2020-06-15T15:05:54.890684+03:00 muni     Iisalmi Idensalmi  
45 142 ocd-division/country:fi/kunta:iitti       2020-06-15T15:05:54.898685+03:00 muni     Iitti Iitti  
46 143 ocd-division/country:fi/kunta:ikaalinen       2020-06-15T15:05:54.904609+03:00 muni     Ikaalinen Ikalis  
47 145 ocd-division/country:fi/kunta:ilmajoki       2020-06-15T15:05:54.910112+03:00 muni     Ilmajoki Ilmajoki  
48 146 ocd-division/country:fi/kunta:ilomantsi       2020-06-15T15:05:54.915836+03:00 muni     Ilomantsi Ilomants  
49 148 ocd-division/country:fi/kunta:inari       2020-06-15T15:05:54.921817+03:00 muni     Inari Enare  
50 149 ocd-division/country:fi/kunta:inkoo       2020-06-15T15:05:54.928267+03:00 muni     Inkoo Ingå  
51 151 ocd-division/country:fi/kunta:isojoki       2020-06-15T15:05:54.933721+03:00 muni     Isojoki Storå  
52 152 ocd-division/country:fi/kunta:isokyrö       2020-06-15T15:05:54.939662+03:00 muni     Isokyrö Storkyro  
53 153 ocd-division/country:fi/kunta:imatra       2020-06-15T15:05:54.946056+03:00 muni     Imatra Imatra  
54 165 ocd-division/country:fi/kunta:janakkala       2020-06-15T15:05:54.953398+03:00 muni     Janakkala Janakkala  
55 167 ocd-division/country:fi/kunta:joensuu       2020-06-15T15:05:54.959264+03:00 muni     Joensuu Joensuu  
56 169 ocd-division/country:fi/kunta:jokioinen       2020-06-15T15:05:54.965852+03:00 muni     Jokioinen Jockis  
57 170 ocd-division/country:fi/kunta:jomala       2020-06-15T15:05:54.971936+03:00 muni     Jomala Jomala  
58 171 ocd-division/country:fi/kunta:joroinen       2020-06-15T15:05:54.978318+03:00 muni     Joroinen Jorois  
59 172 ocd-division/country:fi/kunta:joutsa       2020-06-15T15:05:54.985508+03:00 muni     Joutsa Joutsa  
60 174 ocd-division/country:fi/kunta:juankoski       2020-06-15T15:05:54.991851+03:00 muni     Juankoski Juankoski  
61 176 ocd-division/country:fi/kunta:juuka       2020-06-15T15:05:54.998117+03:00 muni     Juuka Juuka  
62 177 ocd-division/country:fi/kunta:juupajoki       2020-06-15T15:05:55.004714+03:00 muni     Juupajoki Juupajoki  
63 178 ocd-division/country:fi/kunta:juva       2020-06-15T15:05:55.010338+03:00 muni     Juva Juva  
64 179 ocd-division/country:fi/kunta:jyväskylä       2020-06-15T15:05:55.015946+03:00 muni     Jyväskylä Jyväskylä  
65 181 ocd-division/country:fi/kunta:jämijärvi       2020-06-15T15:05:55.021432+03:00 muni     Jämijärvi Jämijärvi  
66 182 ocd-division/country:fi/kunta:jämsä       2020-06-15T15:05:55.026596+03:00 muni     Jämsä Jämsä  
67 186 ocd-division/country:fi/kunta:järvenpää       2020-06-15T15:05:55.032407+03:00 muni     Järvenpää Träskända  
68 202 ocd-division/country:fi/kunta:kaarina       2020-06-15T15:05:55.040937+03:00 muni     Kaarina S:t Karins  
69 204 ocd-division/country:fi/kunta:kaavi       2020-06-15T15:05:55.048523+03:00 muni     Kaavi Kaavi  
70 205 ocd-division/country:fi/kunta:kajaani       2020-06-15T15:05:55.056278+03:00 muni     Kajaani Kajana  
71 208 ocd-division/country:fi/kunta:kalajoki       2020-06-15T15:05:55.064122+03:00 muni     Kalajoki Kalajoki  
72 211 ocd-division/country:fi/kunta:kangasala       2020-06-15T15:05:55.073069+03:00 muni     Kangasala Kangasala  
73 213 ocd-division/country:fi/kunta:kangasniemi       2020-06-15T15:05:55.080977+03:00 muni     Kangasniemi Kangasniemi  
74 214 ocd-division/country:fi/kunta:kankaanpää       2020-06-15T15:05:55.089289+03:00 muni     Kankaanpää Kankaanpää  
75 216 ocd-division/country:fi/kunta:kannonkoski       2020-06-15T15:05:55.097708+03:00 muni     Kannonkoski Kannonkoski  
76 217 ocd-division/country:fi/kunta:kannus       2020-06-15T15:05:55.105279+03:00 muni     Kannus Kannus  
77 218 ocd-division/country:fi/kunta:karijoki       2020-06-15T15:05:55.113069+03:00 muni     Karijoki Bötom  
78 224 ocd-division/country:fi/kunta:karkkila       2020-06-15T15:05:55.120781+03:00 muni     Karkkila Högfors  
79 226 ocd-division/country:fi/kunta:karstula       2020-06-15T15:05:55.128686+03:00 muni     Karstula Karstula  
80 230 ocd-division/country:fi/kunta:karvia       2020-06-15T15:05:55.137628+03:00 muni     Karvia Karvia  
81 231 ocd-division/country:fi/kunta:kaskinen       2020-06-15T15:05:55.147035+03:00 muni     Kaskinen Kaskö  
82 232 ocd-division/country:fi/kunta:kauhajoki       2020-06-15T15:05:55.155806+03:00 muni     Kauhajoki Kauhajoki  
83 233 ocd-division/country:fi/kunta:kauhava       2020-06-15T15:05:55.164619+03:00 muni     Kauhava Kauhava  
84 235 ocd-division/country:fi/kunta:kauniainen       2020-06-15T15:05:55.172303+03:00 muni     Kauniainen Grankulla  
85 236 ocd-division/country:fi/kunta:kaustinen       2020-06-15T15:05:55.179019+03:00 muni     Kaustinen Kaustby  
86 239 ocd-division/country:fi/kunta:keitele       2020-06-15T15:05:55.185228+03:00 muni     Keitele Keitele  
87 240 ocd-division/country:fi/kunta:kemi       2020-06-15T15:05:55.191447+03:00 muni     Kemi Kemi  
88 241 ocd-division/country:fi/kunta:keminmaa       2020-06-15T15:05:55.197978+03:00 muni     Keminmaa Keminmaa  
89 244 ocd-division/country:fi/kunta:kempele       2020-06-15T15:05:55.206483+03:00 muni     Kempele Kempele  
90 245 ocd-division/country:fi/kunta:kerava       2020-06-15T15:05:55.213885+03:00 muni     Kerava Kervo  
91 249 ocd-division/country:fi/kunta:keuruu       2020-06-15T15:05:55.221049+03:00 muni     Keuruu Keuruu  
92 250 ocd-division/country:fi/kunta:kihniö       2020-06-15T15:05:55.228789+03:00 muni     Kihniö Kihniö  
93 256 ocd-division/country:fi/kunta:kinnula       2020-06-15T15:05:55.237160+03:00 muni     Kinnula Kinnula  
94 257 ocd-division/country:fi/kunta:kirkkonummi       2020-06-15T15:05:55.244739+03:00 muni     Kirkkonummi Kyrkslätt  
95 260 ocd-division/country:fi/kunta:kitee       2020-06-15T15:05:55.251141+03:00 muni     Kitee Kitee  
96 261 ocd-division/country:fi/kunta:kittilä       2020-06-15T15:05:55.258913+03:00 muni     Kittilä Kittilä  
97 263 ocd-division/country:fi/kunta:kiuruvesi       2020-06-15T15:05:55.265000+03:00 muni     Kiuruvesi Kiuruvesi  
98 265 ocd-division/country:fi/kunta:kivijärvi       2020-06-15T15:05:55.271141+03:00 muni     Kivijärvi Kivijärvi  
99 271 ocd-division/country:fi/kunta:kokemäki       2020-06-15T15:05:55.277269+03:00 muni     Kokemäki Kumo  
100 272 ocd-division/country:fi/kunta:kokkola       2020-06-15T15:05:55.283428+03:00 muni     Kokkola Karleby  

Next page

Advanced export

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

CSV options:

CREATE TABLE [administrative_division] (
   [id] INTEGER PRIMARY KEY,
   [origin_id] TEXT,
   [ocd_id] TEXT,
   [service_point_id] TEXT,
   [start] TEXT,
   [end] TEXT,
   [modified_at] TEXT,
   [type] TEXT,
   [parent] INTEGER,
   [municipality] TEXT,
   [name_fi] TEXT,
   [name_sv] TEXT,
   [name] TEXT
);