2,760 rows sorted by ocd_id

View and edit SQL

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

end (date)

id origin_id ocd_id ▼ service_point_id start end modified_at type parent municipality name_fi name_sv name
306 20 ocd-division/country:fi/kunta:akaa       2020-06-15T15:05:56.752985+03:00 muni     Akaa Akaa  
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  
5256 49-010 ocd-division/country:fi/kunta:espoo/kaupunginosa:010       2020-10-02T09:50:45.815086+03:00 neighborhood 11 espoo Otaniemi Otnäs  
5257 49-012 ocd-division/country:fi/kunta:espoo/kaupunginosa:012       2020-10-02T09:50:45.832606+03:00 neighborhood 11 espoo Tapiola Hagalund  
5258 49-013 ocd-division/country:fi/kunta:espoo/kaupunginosa:013       2020-10-02T09:50:45.840055+03:00 neighborhood 11 espoo Westend Westend  
5259 49-014 ocd-division/country:fi/kunta:espoo/kaupunginosa:014       2020-10-02T09:50:45.846890+03:00 neighborhood 11 espoo Haukilahti Gäddvik  
5260 49-015 ocd-division/country:fi/kunta:espoo/kaupunginosa:015       2020-10-02T09:50:45.853459+03:00 neighborhood 11 espoo Niittykumpu Ängskulla  
5261 49-016 ocd-division/country:fi/kunta:espoo/kaupunginosa:016       2020-10-02T09:50:45.860433+03:00 neighborhood 11 espoo Pohjois-Tapiola Norra Hagalund  
5262 49-017 ocd-division/country:fi/kunta:espoo/kaupunginosa:017       2020-10-02T09:50:45.867770+03:00 neighborhood 11 espoo Laajalahti Bredvik  
5263 49-020 ocd-division/country:fi/kunta:espoo/kaupunginosa:020       2020-10-02T09:50:45.877304+03:00 neighborhood 11 espoo Kuurinniitty Kurängen  
5264 49-021 ocd-division/country:fi/kunta:espoo/kaupunginosa:021       2020-10-02T09:50:45.885626+03:00 neighborhood 11 espoo Henttaa Hemtans  
5265 49-022 ocd-division/country:fi/kunta:espoo/kaupunginosa:022       2020-10-02T09:50:45.894861+03:00 neighborhood 11 espoo Olari Olars  
5266 49-023 ocd-division/country:fi/kunta:espoo/kaupunginosa:023       2020-10-02T09:50:45.908089+03:00 neighborhood 11 espoo Matinkylä Mattby  
5267 49-026 ocd-division/country:fi/kunta:espoo/kaupunginosa:026       2020-10-02T09:50:45.916894+03:00 neighborhood 11 espoo Mankkaa Mankans  
5268 49-030 ocd-division/country:fi/kunta:espoo/kaupunginosa:030       2020-10-02T09:50:45.924743+03:00 neighborhood 11 espoo Nöykkiö Nöykis  
5269 49-031 ocd-division/country:fi/kunta:espoo/kaupunginosa:031       2020-10-02T09:50:45.933806+03:00 neighborhood 11 espoo Kaitaa Kaitans  
5270 49-032 ocd-division/country:fi/kunta:espoo/kaupunginosa:032       2020-10-02T09:50:45.941980+03:00 neighborhood 11 espoo Suvisaaristo Sommaröarna  
5271 49-033 ocd-division/country:fi/kunta:espoo/kaupunginosa:033       2020-10-02T09:50:45.951351+03:00 neighborhood 11 espoo Soukka Sökö  
5272 49-034 ocd-division/country:fi/kunta:espoo/kaupunginosa:034       2020-10-02T09:50:45.962510+03:00 neighborhood 11 espoo Espoonlahti Esboviken  
5273 49-040 ocd-division/country:fi/kunta:espoo/kaupunginosa:040       2020-10-02T09:50:45.973395+03:00 neighborhood 11 espoo Espoon Keskus Esbo Centrum  
5274 49-041 ocd-division/country:fi/kunta:espoo/kaupunginosa:041       2020-10-02T09:50:45.984418+03:00 neighborhood 11 espoo Kaupunginkallio Stadsberget  
5275 49-042 ocd-division/country:fi/kunta:espoo/kaupunginosa:042       2020-10-02T09:50:45.993547+03:00 neighborhood 11 espoo Saunalahti Bastvik  
5276 49-043 ocd-division/country:fi/kunta:espoo/kaupunginosa:043       2020-10-02T09:50:46.002215+03:00 neighborhood 11 espoo Vanttila Fantsby  
5277 49-044 ocd-division/country:fi/kunta:espoo/kaupunginosa:044       2020-10-02T09:50:46.010619+03:00 neighborhood 11 espoo Kauklahti Köklax  
5278 49-045 ocd-division/country:fi/kunta:espoo/kaupunginosa:045       2020-10-02T09:50:46.018119+03:00 neighborhood 11 espoo Kurttila Kurtby  
5279 49-046 ocd-division/country:fi/kunta:espoo/kaupunginosa:046       2020-10-02T09:50:46.026161+03:00 neighborhood 11 espoo Latokaski Ladusved  
5280 49-047 ocd-division/country:fi/kunta:espoo/kaupunginosa:047       2020-10-02T09:50:46.033331+03:00 neighborhood 11 espoo Muurala Morby  
5281 49-050 ocd-division/country:fi/kunta:espoo/kaupunginosa:050       2020-10-02T09:50:46.040559+03:00 neighborhood 11 espoo Lintuvaara Fågelberga  
5282 49-051 ocd-division/country:fi/kunta:espoo/kaupunginosa:051       2020-10-02T09:50:46.050032+03:00 neighborhood 11 espoo Leppävaara Alberga  
5283 49-054 ocd-division/country:fi/kunta:espoo/kaupunginosa:054       2020-10-02T09:50:46.060961+03:00 neighborhood 11 espoo Kilo Kilo  
5284 49-055 ocd-division/country:fi/kunta:espoo/kaupunginosa:055       2020-10-02T09:50:46.069040+03:00 neighborhood 11 espoo Sepänkylä Smedsby  
5285 49-057 ocd-division/country:fi/kunta:espoo/kaupunginosa:057       2020-10-02T09:50:46.076214+03:00 neighborhood 11 espoo Karakallio Karabacka  
5286 49-060 ocd-division/country:fi/kunta:espoo/kaupunginosa:060       2020-10-02T09:50:46.082812+03:00 neighborhood 11 espoo Laaksolahti Dalsvik  
5287 49-061 ocd-division/country:fi/kunta:espoo/kaupunginosa:061       2020-10-02T09:50:46.090743+03:00 neighborhood 11 espoo Viherlaakso Gröndal  
5288 49-062 ocd-division/country:fi/kunta:espoo/kaupunginosa:062       2020-10-02T09:50:46.098619+03:00 neighborhood 11 espoo Lippajärvi Klappträsk  
5289 49-063 ocd-division/country:fi/kunta:espoo/kaupunginosa:063       2020-10-02T09:50:46.108059+03:00 neighborhood 11 espoo Järvenperä Träskända  
5290 49-064 ocd-division/country:fi/kunta:espoo/kaupunginosa:064       2020-10-02T09:50:46.116476+03:00 neighborhood 11 espoo Karvasmäki Karvasbacka  
5291 49-065 ocd-division/country:fi/kunta:espoo/kaupunginosa:065       2020-10-02T09:50:46.123630+03:00 neighborhood 11 espoo Högnäs Högnäs  
5292 49-070 ocd-division/country:fi/kunta:espoo/kaupunginosa:070       2020-10-02T09:50:46.136665+03:00 neighborhood 11 espoo Espoonkartano Esbogård  
5293 49-071 ocd-division/country:fi/kunta:espoo/kaupunginosa:071       2020-10-02T09:50:46.149165+03:00 neighborhood 11 espoo Gumböle Gumböle  
5294 49-072 ocd-division/country:fi/kunta:espoo/kaupunginosa:072       2020-10-02T09:50:46.160256+03:00 neighborhood 11 espoo Karhusuo Björnkärr  
5295 49-073 ocd-division/country:fi/kunta:espoo/kaupunginosa:073       2020-10-02T09:50:46.172812+03:00 neighborhood 11 espoo Kunnarla Gunnars  
5296 49-074 ocd-division/country:fi/kunta:espoo/kaupunginosa:074       2020-10-02T09:50:46.181907+03:00 neighborhood 11 espoo Nupuri Nupurböle  
5297 49-075 ocd-division/country:fi/kunta:espoo/kaupunginosa:075       2020-10-02T09:50:46.193270+03:00 neighborhood 11 espoo Kolmperä Kolmpers  
5298 49-076 ocd-division/country:fi/kunta:espoo/kaupunginosa:076       2020-10-02T09:50:46.204615+03:00 neighborhood 11 espoo Siikajärvi Siikajärvi  
5299 49-078 ocd-division/country:fi/kunta:espoo/kaupunginosa:078       2020-10-02T09:50:46.212498+03:00 neighborhood 11 espoo Nuuksio Noux  
5300 49-080 ocd-division/country:fi/kunta:espoo/kaupunginosa:080       2020-10-02T09:50:46.220191+03:00 neighborhood 11 espoo Vanhakartano Gammelgård  
5301 49-081 ocd-division/country:fi/kunta:espoo/kaupunginosa:081       2020-10-02T09:50:46.226739+03:00 neighborhood 11 espoo Niipperi Nipert  
5302 49-082 ocd-division/country:fi/kunta:espoo/kaupunginosa:082       2020-10-02T09:50:46.233180+03:00 neighborhood 11 espoo Perusmäki Grandbacka  
5303 49-083 ocd-division/country:fi/kunta:espoo/kaupunginosa:083       2020-10-02T09:50:46.242303+03:00 neighborhood 11 espoo Bodom Bodom  
5304 49-084 ocd-division/country:fi/kunta:espoo/kaupunginosa:084       2020-10-02T09:50:46.249171+03:00 neighborhood 11 espoo Röylä Rödskog  
5305 49-085 ocd-division/country:fi/kunta:espoo/kaupunginosa:085       2020-10-02T09:50:46.256075+03:00 neighborhood 11 espoo Kalajärvi Kalajärvi  
5306 49-086 ocd-division/country:fi/kunta:espoo/kaupunginosa:086       2020-10-02T09:50:46.264258+03:00 neighborhood 11 espoo Luukki Luk  
5307 49-087 ocd-division/country:fi/kunta:espoo/kaupunginosa:087       2020-10-02T09:50:46.273226+03:00 neighborhood 11 espoo Lahnus Lahnus  
5308 49-088 ocd-division/country:fi/kunta:espoo/kaupunginosa:088       2020-10-02T09:50:46.282398+03:00 neighborhood 11 espoo Velskola Vällskog  
5309 49-089 ocd-division/country:fi/kunta:espoo/kaupunginosa:089       2020-10-02T09:50:46.290468+03:00 neighborhood 11 espoo Lakisto Lakisto  
5310 49-090 ocd-division/country:fi/kunta:espoo/kaupunginosa:090       2020-10-02T09:50:46.297831+03:00 neighborhood 11 espoo Vanha-Nuuksio Gamla Noux  
5311 49-091 ocd-division/country:fi/kunta:espoo/kaupunginosa:091       2020-10-02T09:50:46.308632+03:00 neighborhood 11 espoo Ämmässuo Käringmossen  
3913 131580844 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131580844   2020-08-01 2021-08-01 2020-09-16T22:30:51.716533+03:00 lower_comprehensive_school_district_sv 11 espoo   Rödskog  
3908 131580845 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131580845   2020-08-01 2021-08-01 2020-09-16T22:30:51.691351+03:00 lower_comprehensive_school_district_sv 11 espoo   Lagstad  
3904 131583486 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131583486   2020-08-01 2021-08-01 2020-09-16T22:30:51.671365+03:00 lower_comprehensive_school_district_sv 11 espoo   Bemböle  
3907 131583487 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131583487   2020-08-01 2021-08-01 2020-09-16T22:30:51.687145+03:00 lower_comprehensive_school_district_sv 11 espoo   Smedsby  
3905 131583488 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131583488   2020-08-01 2021-08-01 2020-09-16T22:30:51.676538+03:00 lower_comprehensive_school_district_sv 11 espoo   Karamalmen  
3902 131583489 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131583489   2020-08-01 2021-08-01 2020-09-16T22:30:51.661607+03:00 lower_comprehensive_school_district_sv 11 espoo   Boställ  
3906 131583490 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131583490   2020-08-01 2021-08-01 2020-09-16T22:30:51.682246+03:00 lower_comprehensive_school_district_sv 11 espoo   Kungsgård  
3912 131583641 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131583641   2020-08-01 2021-08-01 2020-09-16T22:30:51.712473+03:00 lower_comprehensive_school_district_sv 11 espoo   Storängen  
3911 131583642 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131583642   2020-08-01 2021-08-01 2020-09-16T22:30:51.703560+03:00 lower_comprehensive_school_district_sv 11 espoo   Finno  
3903 131583643 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131583643   2020-08-01 2021-08-01 2020-09-16T22:30:51.666667+03:00 lower_comprehensive_school_district_sv 11 espoo   Mattliden  
3909 131583644 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131583644   2020-08-01 2021-08-01 2020-09-16T22:30:51.695636+03:00 lower_comprehensive_school_district_sv 11 espoo   Vindängen  
3910 131584175 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:131584175   2020-08-01 2021-08-01 2020-09-16T22:30:51.699634+03:00 lower_comprehensive_school_district_sv 11 espoo   Bemböle  
3895 431976549 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:431976549   2020-08-01 2021-08-01 2020-09-16T22:30:47.985845+03:00 lower_comprehensive_school_district_fi 11 espoo Tapiolan oppilasalue    
3896 431976647 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:431976647   2020-08-01 2021-08-01 2020-09-16T22:30:47.995485+03:00 lower_comprehensive_school_district_fi 11 espoo Itäisen Leppävaaran oppilasalue    
3898 431976731 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:431976731   2020-08-01 2021-08-01 2020-09-16T22:30:48.002357+03:00 lower_comprehensive_school_district_fi 11 espoo Läntisen Leppävaaran oppilasalue    
3899 431976820 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:431976820   2020-08-01 2021-08-01 2020-09-16T22:30:48.005819+03:00 lower_comprehensive_school_district_fi 11 espoo Matinkylän-Olarin oppilasalue    
3897 431976899 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:431976899   2020-08-01 2021-08-01 2020-09-16T22:30:47.999099+03:00 lower_comprehensive_school_district_fi 11 espoo Espoonlahden oppilasalue    
3900 431977071 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:431977071   2020-08-01 2021-08-01 2020-09-16T22:30:48.009361+03:00 lower_comprehensive_school_district_fi 11 espoo Pohjois-Espoon oppilasalue    
3901 431977176 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:431977176   2020-08-01 2021-08-01 2020-09-16T22:30:48.012785+03:00 lower_comprehensive_school_district_fi 11 espoo Keski-Espoon oppilasalue    
3965 131580844_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131580844_1   2021-08-01 2022-08-01 2020-09-16T22:30:53.650003+03:00 lower_comprehensive_school_district_sv 11 espoo   Rödskog  
3960 131580845_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131580845_1   2021-08-01 2022-08-01 2020-09-16T22:30:53.633250+03:00 lower_comprehensive_school_district_sv 11 espoo   Lagstad  
3956 131583486_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131583486_1   2021-08-01 2022-08-01 2020-09-16T22:30:53.619093+03:00 lower_comprehensive_school_district_sv 11 espoo   Bemböle  
3959 131583487_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131583487_1   2021-08-01 2022-08-01 2020-09-16T22:30:53.629630+03:00 lower_comprehensive_school_district_sv 11 espoo   Smedsby  
3957 131583488_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131583488_1   2021-08-01 2022-08-01 2020-09-16T22:30:53.622508+03:00 lower_comprehensive_school_district_sv 11 espoo   Karamalmen  
3954 131583489_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131583489_1   2021-08-01 2022-08-01 2020-09-16T22:30:53.610784+03:00 lower_comprehensive_school_district_sv 11 espoo   Boställ  
3958 131583490_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131583490_1   2021-08-01 2022-08-01 2020-09-16T22:30:53.626358+03:00 lower_comprehensive_school_district_sv 11 espoo   Kungsgård  
3964 131583641_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131583641_1   2021-08-01 2022-08-01 2020-09-16T22:30:53.646809+03:00 lower_comprehensive_school_district_sv 11 espoo   Storängen  
3963 131583642_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131583642_1   2021-08-01 2022-08-01 2020-09-16T22:30:53.643741+03:00 lower_comprehensive_school_district_sv 11 espoo   Finno  
3955 131583643_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131583643_1   2021-08-01 2022-08-01 2020-09-16T22:30:53.615513+03:00 lower_comprehensive_school_district_sv 11 espoo   Mattliden  
3961 131583644_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131583644_1   2021-08-01 2022-08-01 2020-09-16T22:30:53.637062+03:00 lower_comprehensive_school_district_sv 11 espoo   Vindängen  
3962 131584175_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:131584175_1   2021-08-01 2022-08-01 2020-09-16T22:30:53.640450+03:00 lower_comprehensive_school_district_sv 11 espoo   Bemböle  
3947 431976549_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:431976549_1   2021-08-01 2022-08-01 2020-09-16T22:30:49.815630+03:00 lower_comprehensive_school_district_fi 11 espoo Tapiolan oppilasalue    

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