administrative_division
2,760 rows sorted by id descending
This data as json, CSV (advanced)
id ▲ | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
---|---|---|---|---|---|---|---|---|---|---|---|---|
5607 | 49-02940 | ocd-division/country:fi/kunta:espoo/postinumero:02940 | 2020-10-02T09:50:52.767218+03:00 | postcode_area | 11 | espoo | 02940 | |||||
5606 | 49-02920 | ocd-division/country:fi/kunta:espoo/postinumero:02920 | 2020-10-02T09:50:52.759990+03:00 | postcode_area | 11 | espoo | 02920 | |||||
5605 | 49-02860 | ocd-division/country:fi/kunta:espoo/postinumero:02860 | 2020-10-02T09:50:52.751588+03:00 | postcode_area | 11 | espoo | 02860 | |||||
5604 | 49-02820 | ocd-division/country:fi/kunta:espoo/postinumero:02820 | 2020-10-02T09:50:52.743566+03:00 | postcode_area | 11 | espoo | 02820 | |||||
5603 | 49-02810 | ocd-division/country:fi/kunta:espoo/postinumero:02810 | 2020-10-02T09:50:52.736667+03:00 | postcode_area | 11 | espoo | 02810 | |||||
5602 | 49-02780 | ocd-division/country:fi/kunta:espoo/postinumero:02780 | 2020-10-02T09:50:52.728825+03:00 | postcode_area | 11 | espoo | 02780 | |||||
5601 | 49-02770 | ocd-division/country:fi/kunta:espoo/postinumero:02770 | 2020-10-02T09:50:52.721605+03:00 | postcode_area | 11 | espoo | 02770 | |||||
5600 | 49-02760 | ocd-division/country:fi/kunta:espoo/postinumero:02760 | 2020-10-02T09:50:52.714690+03:00 | postcode_area | 11 | espoo | 02760 | |||||
5599 | 49-02750 | ocd-division/country:fi/kunta:espoo/postinumero:02750 | 2020-10-02T09:50:52.707855+03:00 | postcode_area | 11 | espoo | 02750 | |||||
5598 | 49-02740 | ocd-division/country:fi/kunta:espoo/postinumero:02740 | 2020-10-02T09:50:52.700810+03:00 | postcode_area | 11 | espoo | 02740 | |||||
5597 | 49-02730 | ocd-division/country:fi/kunta:espoo/postinumero:02730 | 2020-10-02T09:50:52.694894+03:00 | postcode_area | 11 | espoo | 02730 | |||||
5596 | 49-02720 | ocd-division/country:fi/kunta:espoo/postinumero:02720 | 2020-10-02T09:50:52.689020+03:00 | postcode_area | 11 | espoo | 02720 | |||||
5595 | 49-02710 | ocd-division/country:fi/kunta:espoo/postinumero:02710 | 2020-10-02T09:50:52.682380+03:00 | postcode_area | 11 | espoo | 02710 | |||||
5594 | 49-02700 | ocd-division/country:fi/kunta:espoo/postinumero:02700 | 2020-10-02T09:50:52.675327+03:00 | postcode_area | 11 | espoo | 02700 | |||||
5593 | 49-02680 | ocd-division/country:fi/kunta:espoo/postinumero:02680 | 2020-10-02T09:50:52.667680+03:00 | postcode_area | 11 | espoo | 02680 | |||||
5592 | 49-02660 | ocd-division/country:fi/kunta:espoo/postinumero:02660 | 2020-10-02T09:50:52.659467+03:00 | postcode_area | 11 | espoo | 02660 | |||||
5591 | 49-02650 | ocd-division/country:fi/kunta:espoo/postinumero:02650 | 2020-10-02T09:50:52.650889+03:00 | postcode_area | 11 | espoo | 02650 | |||||
5590 | 49-02630 | ocd-division/country:fi/kunta:espoo/postinumero:02630 | 2020-10-02T09:50:52.642415+03:00 | postcode_area | 11 | espoo | 02630 | |||||
5589 | 49-02620 | ocd-division/country:fi/kunta:espoo/postinumero:02620 | 2020-10-02T09:50:52.635326+03:00 | postcode_area | 11 | espoo | 02620 | |||||
5588 | 49-02610 | ocd-division/country:fi/kunta:espoo/postinumero:02610 | 2020-10-02T09:50:52.628867+03:00 | postcode_area | 11 | espoo | 02610 | |||||
5587 | 49-02600 | ocd-division/country:fi/kunta:espoo/postinumero:02600 | 2020-10-02T09:50:52.622118+03:00 | postcode_area | 11 | espoo | 02600 | |||||
5586 | 49-02510 | ocd-division/country:fi/kunta:espoo/postinumero:02510 | 2020-10-02T09:50:52.615716+03:00 | postcode_area | 11 | espoo | 02510 | |||||
5585 | 49-02380 | ocd-division/country:fi/kunta:espoo/postinumero:02380 | 2020-10-02T09:50:52.609548+03:00 | postcode_area | 11 | espoo | 02380 | |||||
5584 | 49-02360 | ocd-division/country:fi/kunta:espoo/postinumero:02360 | 2020-10-02T09:50:52.603809+03:00 | postcode_area | 11 | espoo | 02360 | |||||
5583 | 49-02340 | ocd-division/country:fi/kunta:espoo/postinumero:02340 | 2020-10-02T09:50:52.597889+03:00 | postcode_area | 11 | espoo | 02340 | |||||
5582 | 49-02330 | ocd-division/country:fi/kunta:espoo/postinumero:02330 | 2020-10-02T09:50:52.591942+03:00 | postcode_area | 11 | espoo | 02330 | |||||
5581 | 49-02320 | ocd-division/country:fi/kunta:espoo/postinumero:02320 | 2020-10-02T09:50:52.585792+03:00 | postcode_area | 11 | espoo | 02320 | |||||
5580 | 49-02300 | ocd-division/country:fi/kunta:espoo/postinumero:02300 | 2020-10-02T09:50:52.579606+03:00 | postcode_area | 11 | espoo | 02300 | |||||
5579 | 49-02290 | ocd-division/country:fi/kunta:espoo/postinumero:02290 | 2020-10-02T09:50:52.573807+03:00 | postcode_area | 11 | espoo | 02290 | |||||
5578 | 49-02280 | ocd-division/country:fi/kunta:espoo/postinumero:02280 | 2020-10-02T09:50:52.566619+03:00 | postcode_area | 11 | espoo | 02280 | |||||
5577 | 49-02270 | ocd-division/country:fi/kunta:espoo/postinumero:02270 | 2020-10-02T09:50:52.554521+03:00 | postcode_area | 11 | espoo | 02270 | |||||
5576 | 49-02260 | ocd-division/country:fi/kunta:espoo/postinumero:02260 | 2020-10-02T09:50:52.548028+03:00 | postcode_area | 11 | espoo | 02260 | |||||
5575 | 49-02250 | ocd-division/country:fi/kunta:espoo/postinumero:02250 | 2020-10-02T09:50:52.541676+03:00 | postcode_area | 11 | espoo | 02250 | |||||
5574 | 49-02240 | ocd-division/country:fi/kunta:espoo/postinumero:02240 | 2020-10-02T09:50:52.534294+03:00 | postcode_area | 11 | espoo | 02240 | |||||
5573 | 49-02230 | ocd-division/country:fi/kunta:espoo/postinumero:02230 | 2020-10-02T09:50:52.527087+03:00 | postcode_area | 11 | espoo | 02230 | |||||
5572 | 49-02210 | ocd-division/country:fi/kunta:espoo/postinumero:02210 | 2020-10-02T09:50:52.519523+03:00 | postcode_area | 11 | espoo | 02210 | |||||
5571 | 49-02200 | ocd-division/country:fi/kunta:espoo/postinumero:02200 | 2020-10-02T09:50:52.513112+03:00 | postcode_area | 11 | espoo | 02200 | |||||
5570 | 49-02180 | ocd-division/country:fi/kunta:espoo/postinumero:02180 | 2020-10-02T09:50:52.506798+03:00 | postcode_area | 11 | espoo | 02180 | |||||
5569 | 49-02170 | ocd-division/country:fi/kunta:espoo/postinumero:02170 | 2020-10-02T09:50:52.500313+03:00 | postcode_area | 11 | espoo | 02170 | |||||
5568 | 49-02160 | ocd-division/country:fi/kunta:espoo/postinumero:02160 | 2020-10-02T09:50:52.493684+03:00 | postcode_area | 11 | espoo | 02160 | |||||
5567 | 49-02150 | ocd-division/country:fi/kunta:espoo/postinumero:02150 | 2020-10-02T09:50:52.486799+03:00 | postcode_area | 11 | espoo | 02150 | |||||
5566 | 49-02140 | ocd-division/country:fi/kunta:espoo/postinumero:02140 | 2020-10-02T09:50:52.479210+03:00 | postcode_area | 11 | espoo | 02140 | |||||
5565 | 49-02130 | ocd-division/country:fi/kunta:espoo/postinumero:02130 | 2020-10-02T09:50:52.468973+03:00 | postcode_area | 11 | espoo | 02130 | |||||
5564 | 49-02120 | ocd-division/country:fi/kunta:espoo/postinumero:02120 | 2020-10-02T09:50:52.458904+03:00 | postcode_area | 11 | espoo | 02120 | |||||
5563 | 49-02110 | ocd-division/country:fi/kunta:espoo/postinumero:02110 | 2020-10-02T09:50:52.451383+03:00 | postcode_area | 11 | espoo | 02110 | |||||
5562 | 49-02100 | ocd-division/country:fi/kunta:espoo/postinumero:02100 | 2020-10-02T09:50:52.444846+03:00 | postcode_area | 11 | espoo | 02100 | |||||
5561 | 92-01770 | ocd-division/country:fi/kunta:vantaa/postinumero:01770 | 2020-10-02T09:50:52.436878+03:00 | postcode_area | 33 | vantaa | 01770 | |||||
5560 | 92-01760 | ocd-division/country:fi/kunta:vantaa/postinumero:01760 | 2020-10-02T09:50:52.430026+03:00 | postcode_area | 33 | vantaa | 01760 | |||||
5559 | 92-01750 | ocd-division/country:fi/kunta:vantaa/postinumero:01750 | 2020-10-02T09:50:52.423573+03:00 | postcode_area | 33 | vantaa | 01750 | |||||
5558 | 92-01740 | ocd-division/country:fi/kunta:vantaa/postinumero:01740 | 2020-10-02T09:50:52.416798+03:00 | postcode_area | 33 | vantaa | 01740 | |||||
5557 | 92-01730 | ocd-division/country:fi/kunta:vantaa/postinumero:01730 | 2020-10-02T09:50:52.408837+03:00 | postcode_area | 33 | vantaa | 01730 | |||||
5556 | 92-01720 | ocd-division/country:fi/kunta:vantaa/postinumero:01720 | 2020-10-02T09:50:52.401024+03:00 | postcode_area | 33 | vantaa | 01720 | |||||
5555 | 92-01710 | ocd-division/country:fi/kunta:vantaa/postinumero:01710 | 2020-10-02T09:50:52.393826+03:00 | postcode_area | 33 | vantaa | 01710 | |||||
5554 | 92-01700 | ocd-division/country:fi/kunta:vantaa/postinumero:01700 | 2020-10-02T09:50:52.387852+03:00 | postcode_area | 33 | vantaa | 01700 | |||||
5553 | 92-01690 | ocd-division/country:fi/kunta:vantaa/postinumero:01690 | 2020-10-02T09:50:52.381249+03:00 | postcode_area | 33 | vantaa | 01690 | |||||
5552 | 92-01680 | ocd-division/country:fi/kunta:vantaa/postinumero:01680 | 2020-10-02T09:50:52.375413+03:00 | postcode_area | 33 | vantaa | 01680 | |||||
5551 | 92-01670 | ocd-division/country:fi/kunta:vantaa/postinumero:01670 | 2020-10-02T09:50:52.369707+03:00 | postcode_area | 33 | vantaa | 01670 | |||||
5550 | 92-01660 | ocd-division/country:fi/kunta:vantaa/postinumero:01660 | 2020-10-02T09:50:52.363608+03:00 | postcode_area | 33 | vantaa | 01660 | |||||
5549 | 92-01650 | ocd-division/country:fi/kunta:vantaa/postinumero:01650 | 2020-10-02T09:50:52.357951+03:00 | postcode_area | 33 | vantaa | 01650 | |||||
5548 | 92-01640 | ocd-division/country:fi/kunta:vantaa/postinumero:01640 | 2020-10-02T09:50:52.351418+03:00 | postcode_area | 33 | vantaa | 01640 | |||||
5547 | 92-01630 | ocd-division/country:fi/kunta:vantaa/postinumero:01630 | 2020-10-02T09:50:52.344216+03:00 | postcode_area | 33 | vantaa | 01630 | |||||
5546 | 92-01620 | ocd-division/country:fi/kunta:vantaa/postinumero:01620 | 2020-10-02T09:50:52.338460+03:00 | postcode_area | 33 | vantaa | 01620 | |||||
5545 | 92-01610 | ocd-division/country:fi/kunta:vantaa/postinumero:01610 | 2020-10-02T09:50:52.332290+03:00 | postcode_area | 33 | vantaa | 01610 | |||||
5544 | 92-01600 | ocd-division/country:fi/kunta:vantaa/postinumero:01600 | 2020-10-02T09:50:52.326769+03:00 | postcode_area | 33 | vantaa | 01600 | |||||
5543 | 92-01530 | ocd-division/country:fi/kunta:vantaa/postinumero:01530 | 2020-10-02T09:50:52.321425+03:00 | postcode_area | 33 | vantaa | 01530 | |||||
5542 | 92-01520 | ocd-division/country:fi/kunta:vantaa/postinumero:01520 | 2020-10-02T09:50:52.315823+03:00 | postcode_area | 33 | vantaa | 01520 | |||||
5541 | 92-01510 | ocd-division/country:fi/kunta:vantaa/postinumero:01510 | 2020-10-02T09:50:52.309723+03:00 | postcode_area | 33 | vantaa | 01510 | |||||
5540 | 92-01490 | ocd-division/country:fi/kunta:vantaa/postinumero:01490 | 2020-10-02T09:50:52.303832+03:00 | postcode_area | 33 | vantaa | 01490 | |||||
5539 | 92-01480 | ocd-division/country:fi/kunta:vantaa/postinumero:01480 | 2020-10-02T09:50:52.298186+03:00 | postcode_area | 33 | vantaa | 01480 | |||||
5538 | 92-01450 | ocd-division/country:fi/kunta:vantaa/postinumero:01450 | 2020-10-02T09:50:52.292396+03:00 | postcode_area | 33 | vantaa | 01450 | |||||
5537 | 92-01420 | ocd-division/country:fi/kunta:vantaa/postinumero:01420 | 2020-10-02T09:50:52.286594+03:00 | postcode_area | 33 | vantaa | 01420 | |||||
5536 | 92-01400 | ocd-division/country:fi/kunta:vantaa/postinumero:01400 | 2020-10-02T09:50:52.280427+03:00 | postcode_area | 33 | vantaa | 01400 | |||||
5535 | 92-01390 | ocd-division/country:fi/kunta:vantaa/postinumero:01390 | 2020-10-02T09:50:52.274926+03:00 | postcode_area | 33 | vantaa | 01390 | |||||
5534 | 92-01380 | ocd-division/country:fi/kunta:vantaa/postinumero:01380 | 2020-10-02T09:50:52.269148+03:00 | postcode_area | 33 | vantaa | 01380 | |||||
5533 | 92-01370 | ocd-division/country:fi/kunta:vantaa/postinumero:01370 | 2020-10-02T09:50:52.263146+03:00 | postcode_area | 33 | vantaa | 01370 | |||||
5532 | 92-01360 | ocd-division/country:fi/kunta:vantaa/postinumero:01360 | 2020-10-02T09:50:52.257054+03:00 | postcode_area | 33 | vantaa | 01360 | |||||
5531 | 92-01350 | ocd-division/country:fi/kunta:vantaa/postinumero:01350 | 2020-10-02T09:50:52.251008+03:00 | postcode_area | 33 | vantaa | 01350 | |||||
5530 | 92-01340 | ocd-division/country:fi/kunta:vantaa/postinumero:01340 | 2020-10-02T09:50:52.244738+03:00 | postcode_area | 33 | vantaa | 01340 | |||||
5529 | 92-01300 | ocd-division/country:fi/kunta:vantaa/postinumero:01300 | 2020-10-02T09:50:52.237720+03:00 | postcode_area | 33 | vantaa | 01300 | |||||
5528 | 92-01280 | ocd-division/country:fi/kunta:vantaa/postinumero:01280 | 2020-10-02T09:50:52.230616+03:00 | postcode_area | 33 | vantaa | 01280 | |||||
5527 | 92-01260 | ocd-division/country:fi/kunta:vantaa/postinumero:01260 | 2020-10-02T09:50:52.224612+03:00 | postcode_area | 33 | vantaa | 01260 | |||||
5526 | 92-01230 | ocd-division/country:fi/kunta:vantaa/postinumero:01230 | 2020-10-02T09:50:52.218327+03:00 | postcode_area | 33 | vantaa | 01230 | |||||
5525 | 92-01200 | ocd-division/country:fi/kunta:vantaa/postinumero:01200 | 2020-10-02T09:50:52.211852+03:00 | postcode_area | 33 | vantaa | 01200 | |||||
5524 | 91-00990 | ocd-division/country:fi/kunta:helsinki/postinumero:00990 | 2020-10-02T09:50:52.206029+03:00 | postcode_area | 32 | helsinki | 00990 | |||||
5523 | 91-00980 | ocd-division/country:fi/kunta:helsinki/postinumero:00980 | 2020-10-02T09:50:52.200091+03:00 | postcode_area | 32 | helsinki | 00980 | |||||
5522 | 91-00970 | ocd-division/country:fi/kunta:helsinki/postinumero:00970 | 2020-10-02T09:50:52.194468+03:00 | postcode_area | 32 | helsinki | 00970 | |||||
5521 | 91-00960 | ocd-division/country:fi/kunta:helsinki/postinumero:00960 | 2020-10-02T09:50:52.188904+03:00 | postcode_area | 32 | helsinki | 00960 | |||||
5520 | 91-00950 | ocd-division/country:fi/kunta:helsinki/postinumero:00950 | 2020-10-02T09:50:52.183131+03:00 | postcode_area | 32 | helsinki | 00950 | |||||
5519 | 91-00940 | ocd-division/country:fi/kunta:helsinki/postinumero:00940 | 2020-10-02T09:50:52.177051+03:00 | postcode_area | 32 | helsinki | 00940 | |||||
5518 | 91-00930 | ocd-division/country:fi/kunta:helsinki/postinumero:00930 | 2020-10-02T09:50:52.171229+03:00 | postcode_area | 32 | helsinki | 00930 | |||||
5517 | 91-00920 | ocd-division/country:fi/kunta:helsinki/postinumero:00920 | 2020-10-02T09:50:52.166023+03:00 | postcode_area | 32 | helsinki | 00920 | |||||
5516 | 91-00910 | ocd-division/country:fi/kunta:helsinki/postinumero:00910 | 2020-10-02T09:50:52.160897+03:00 | postcode_area | 32 | helsinki | 00910 | |||||
5515 | 91-00900 | ocd-division/country:fi/kunta:helsinki/postinumero:00900 | 2020-10-02T09:50:52.155073+03:00 | postcode_area | 32 | helsinki | 00900 | |||||
5514 | 91-00890 | ocd-division/country:fi/kunta:helsinki/postinumero:00890 | 2020-10-02T09:50:52.147201+03:00 | postcode_area | 32 | helsinki | 00890 | |||||
5513 | 91-00880 | ocd-division/country:fi/kunta:helsinki/postinumero:00880 | 2020-10-02T09:50:52.141527+03:00 | postcode_area | 32 | helsinki | 00880 | |||||
5512 | 91-00870 | ocd-division/country:fi/kunta:helsinki/postinumero:00870 | 2020-10-02T09:50:52.135892+03:00 | postcode_area | 32 | helsinki | 00870 | |||||
5511 | 91-00860 | ocd-division/country:fi/kunta:helsinki/postinumero:00860 | 2020-10-02T09:50:52.130133+03:00 | postcode_area | 32 | helsinki | 00860 | |||||
5510 | 91-00850 | ocd-division/country:fi/kunta:helsinki/postinumero:00850 | 2020-10-02T09:50:52.124212+03:00 | postcode_area | 32 | helsinki | 00850 | |||||
5509 | 91-00840 | ocd-division/country:fi/kunta:helsinki/postinumero:00840 | 2020-10-02T09:50:52.117808+03:00 | postcode_area | 32 | helsinki | 00840 | |||||
5508 | 91-00830 | ocd-division/country:fi/kunta:helsinki/postinumero:00830 | 2020-10-02T09:50:52.112202+03:00 | postcode_area | 32 | helsinki | 00830 |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );