administrative_division
171 rows where type = "postcode_area"
This data as json, CSV (advanced)
modified_at (date) ✖
- 2020-10-02 71
id ▼ | origin_id | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
---|---|---|---|---|---|---|---|---|---|---|---|---|
5541 | 92-01510 | ocd-division/country:fi/kunta:vantaa/postinumero:01510 | 2020-10-02T09:50:52.309723+03:00 | postcode_area | 33 | vantaa | 01510 | |||||
5542 | 92-01520 | ocd-division/country:fi/kunta:vantaa/postinumero:01520 | 2020-10-02T09:50:52.315823+03:00 | postcode_area | 33 | vantaa | 01520 | |||||
5543 | 92-01530 | ocd-division/country:fi/kunta:vantaa/postinumero:01530 | 2020-10-02T09:50:52.321425+03:00 | postcode_area | 33 | vantaa | 01530 | |||||
5544 | 92-01600 | ocd-division/country:fi/kunta:vantaa/postinumero:01600 | 2020-10-02T09:50:52.326769+03:00 | postcode_area | 33 | vantaa | 01600 | |||||
5545 | 92-01610 | ocd-division/country:fi/kunta:vantaa/postinumero:01610 | 2020-10-02T09:50:52.332290+03:00 | postcode_area | 33 | vantaa | 01610 | |||||
5546 | 92-01620 | ocd-division/country:fi/kunta:vantaa/postinumero:01620 | 2020-10-02T09:50:52.338460+03:00 | postcode_area | 33 | vantaa | 01620 | |||||
5547 | 92-01630 | ocd-division/country:fi/kunta:vantaa/postinumero:01630 | 2020-10-02T09:50:52.344216+03:00 | postcode_area | 33 | vantaa | 01630 | |||||
5548 | 92-01640 | ocd-division/country:fi/kunta:vantaa/postinumero:01640 | 2020-10-02T09:50:52.351418+03:00 | postcode_area | 33 | vantaa | 01640 | |||||
5549 | 92-01650 | ocd-division/country:fi/kunta:vantaa/postinumero:01650 | 2020-10-02T09:50:52.357951+03:00 | postcode_area | 33 | vantaa | 01650 | |||||
5550 | 92-01660 | ocd-division/country:fi/kunta:vantaa/postinumero:01660 | 2020-10-02T09:50:52.363608+03:00 | postcode_area | 33 | vantaa | 01660 | |||||
5551 | 92-01670 | ocd-division/country:fi/kunta:vantaa/postinumero:01670 | 2020-10-02T09:50:52.369707+03:00 | postcode_area | 33 | vantaa | 01670 | |||||
5552 | 92-01680 | ocd-division/country:fi/kunta:vantaa/postinumero:01680 | 2020-10-02T09:50:52.375413+03:00 | postcode_area | 33 | vantaa | 01680 | |||||
5553 | 92-01690 | ocd-division/country:fi/kunta:vantaa/postinumero:01690 | 2020-10-02T09:50:52.381249+03:00 | postcode_area | 33 | vantaa | 01690 | |||||
5554 | 92-01700 | ocd-division/country:fi/kunta:vantaa/postinumero:01700 | 2020-10-02T09:50:52.387852+03:00 | postcode_area | 33 | vantaa | 01700 | |||||
5555 | 92-01710 | ocd-division/country:fi/kunta:vantaa/postinumero:01710 | 2020-10-02T09:50:52.393826+03:00 | postcode_area | 33 | vantaa | 01710 | |||||
5556 | 92-01720 | ocd-division/country:fi/kunta:vantaa/postinumero:01720 | 2020-10-02T09:50:52.401024+03:00 | postcode_area | 33 | vantaa | 01720 | |||||
5557 | 92-01730 | ocd-division/country:fi/kunta:vantaa/postinumero:01730 | 2020-10-02T09:50:52.408837+03:00 | postcode_area | 33 | vantaa | 01730 | |||||
5558 | 92-01740 | ocd-division/country:fi/kunta:vantaa/postinumero:01740 | 2020-10-02T09:50:52.416798+03:00 | postcode_area | 33 | vantaa | 01740 | |||||
5559 | 92-01750 | ocd-division/country:fi/kunta:vantaa/postinumero:01750 | 2020-10-02T09:50:52.423573+03:00 | postcode_area | 33 | vantaa | 01750 | |||||
5560 | 92-01760 | ocd-division/country:fi/kunta:vantaa/postinumero:01760 | 2020-10-02T09:50:52.430026+03:00 | postcode_area | 33 | vantaa | 01760 | |||||
5561 | 92-01770 | ocd-division/country:fi/kunta:vantaa/postinumero:01770 | 2020-10-02T09:50:52.436878+03:00 | postcode_area | 33 | vantaa | 01770 | |||||
5562 | 49-02100 | ocd-division/country:fi/kunta:espoo/postinumero:02100 | 2020-10-02T09:50:52.444846+03:00 | postcode_area | 11 | espoo | 02100 | |||||
5563 | 49-02110 | ocd-division/country:fi/kunta:espoo/postinumero:02110 | 2020-10-02T09:50:52.451383+03:00 | postcode_area | 11 | espoo | 02110 | |||||
5564 | 49-02120 | ocd-division/country:fi/kunta:espoo/postinumero:02120 | 2020-10-02T09:50:52.458904+03:00 | postcode_area | 11 | espoo | 02120 | |||||
5565 | 49-02130 | ocd-division/country:fi/kunta:espoo/postinumero:02130 | 2020-10-02T09:50:52.468973+03:00 | postcode_area | 11 | espoo | 02130 | |||||
5566 | 49-02140 | ocd-division/country:fi/kunta:espoo/postinumero:02140 | 2020-10-02T09:50:52.479210+03:00 | postcode_area | 11 | espoo | 02140 | |||||
5567 | 49-02150 | ocd-division/country:fi/kunta:espoo/postinumero:02150 | 2020-10-02T09:50:52.486799+03:00 | postcode_area | 11 | espoo | 02150 | |||||
5568 | 49-02160 | ocd-division/country:fi/kunta:espoo/postinumero:02160 | 2020-10-02T09:50:52.493684+03:00 | postcode_area | 11 | espoo | 02160 | |||||
5569 | 49-02170 | ocd-division/country:fi/kunta:espoo/postinumero:02170 | 2020-10-02T09:50:52.500313+03:00 | postcode_area | 11 | espoo | 02170 | |||||
5570 | 49-02180 | ocd-division/country:fi/kunta:espoo/postinumero:02180 | 2020-10-02T09:50:52.506798+03:00 | postcode_area | 11 | espoo | 02180 | |||||
5571 | 49-02200 | ocd-division/country:fi/kunta:espoo/postinumero:02200 | 2020-10-02T09:50:52.513112+03:00 | postcode_area | 11 | espoo | 02200 | |||||
5572 | 49-02210 | ocd-division/country:fi/kunta:espoo/postinumero:02210 | 2020-10-02T09:50:52.519523+03:00 | postcode_area | 11 | espoo | 02210 | |||||
5573 | 49-02230 | ocd-division/country:fi/kunta:espoo/postinumero:02230 | 2020-10-02T09:50:52.527087+03:00 | postcode_area | 11 | espoo | 02230 | |||||
5574 | 49-02240 | ocd-division/country:fi/kunta:espoo/postinumero:02240 | 2020-10-02T09:50:52.534294+03:00 | postcode_area | 11 | espoo | 02240 | |||||
5575 | 49-02250 | ocd-division/country:fi/kunta:espoo/postinumero:02250 | 2020-10-02T09:50:52.541676+03:00 | postcode_area | 11 | espoo | 02250 | |||||
5576 | 49-02260 | ocd-division/country:fi/kunta:espoo/postinumero:02260 | 2020-10-02T09:50:52.548028+03:00 | postcode_area | 11 | espoo | 02260 | |||||
5577 | 49-02270 | ocd-division/country:fi/kunta:espoo/postinumero:02270 | 2020-10-02T09:50:52.554521+03:00 | postcode_area | 11 | espoo | 02270 | |||||
5578 | 49-02280 | ocd-division/country:fi/kunta:espoo/postinumero:02280 | 2020-10-02T09:50:52.566619+03:00 | postcode_area | 11 | espoo | 02280 | |||||
5579 | 49-02290 | ocd-division/country:fi/kunta:espoo/postinumero:02290 | 2020-10-02T09:50:52.573807+03:00 | postcode_area | 11 | espoo | 02290 | |||||
5580 | 49-02300 | ocd-division/country:fi/kunta:espoo/postinumero:02300 | 2020-10-02T09:50:52.579606+03:00 | postcode_area | 11 | espoo | 02300 | |||||
5581 | 49-02320 | ocd-division/country:fi/kunta:espoo/postinumero:02320 | 2020-10-02T09:50:52.585792+03:00 | postcode_area | 11 | espoo | 02320 | |||||
5582 | 49-02330 | ocd-division/country:fi/kunta:espoo/postinumero:02330 | 2020-10-02T09:50:52.591942+03:00 | postcode_area | 11 | espoo | 02330 | |||||
5583 | 49-02340 | ocd-division/country:fi/kunta:espoo/postinumero:02340 | 2020-10-02T09:50:52.597889+03:00 | postcode_area | 11 | espoo | 02340 | |||||
5584 | 49-02360 | ocd-division/country:fi/kunta:espoo/postinumero:02360 | 2020-10-02T09:50:52.603809+03:00 | postcode_area | 11 | espoo | 02360 | |||||
5585 | 49-02380 | ocd-division/country:fi/kunta:espoo/postinumero:02380 | 2020-10-02T09:50:52.609548+03:00 | postcode_area | 11 | espoo | 02380 | |||||
5586 | 49-02510 | ocd-division/country:fi/kunta:espoo/postinumero:02510 | 2020-10-02T09:50:52.615716+03:00 | postcode_area | 11 | espoo | 02510 | |||||
5587 | 49-02600 | ocd-division/country:fi/kunta:espoo/postinumero:02600 | 2020-10-02T09:50:52.622118+03:00 | postcode_area | 11 | espoo | 02600 | |||||
5588 | 49-02610 | ocd-division/country:fi/kunta:espoo/postinumero:02610 | 2020-10-02T09:50:52.628867+03:00 | postcode_area | 11 | espoo | 02610 | |||||
5589 | 49-02620 | ocd-division/country:fi/kunta:espoo/postinumero:02620 | 2020-10-02T09:50:52.635326+03:00 | postcode_area | 11 | espoo | 02620 | |||||
5590 | 49-02630 | ocd-division/country:fi/kunta:espoo/postinumero:02630 | 2020-10-02T09:50:52.642415+03:00 | postcode_area | 11 | espoo | 02630 | |||||
5591 | 49-02650 | ocd-division/country:fi/kunta:espoo/postinumero:02650 | 2020-10-02T09:50:52.650889+03:00 | postcode_area | 11 | espoo | 02650 | |||||
5592 | 49-02660 | ocd-division/country:fi/kunta:espoo/postinumero:02660 | 2020-10-02T09:50:52.659467+03:00 | postcode_area | 11 | espoo | 02660 | |||||
5593 | 49-02680 | ocd-division/country:fi/kunta:espoo/postinumero:02680 | 2020-10-02T09:50:52.667680+03:00 | postcode_area | 11 | espoo | 02680 | |||||
5594 | 49-02700 | ocd-division/country:fi/kunta:espoo/postinumero:02700 | 2020-10-02T09:50:52.675327+03:00 | postcode_area | 11 | espoo | 02700 | |||||
5595 | 49-02710 | ocd-division/country:fi/kunta:espoo/postinumero:02710 | 2020-10-02T09:50:52.682380+03:00 | postcode_area | 11 | espoo | 02710 | |||||
5596 | 49-02720 | ocd-division/country:fi/kunta:espoo/postinumero:02720 | 2020-10-02T09:50:52.689020+03:00 | postcode_area | 11 | espoo | 02720 | |||||
5597 | 49-02730 | ocd-division/country:fi/kunta:espoo/postinumero:02730 | 2020-10-02T09:50:52.694894+03:00 | postcode_area | 11 | espoo | 02730 | |||||
5598 | 49-02740 | ocd-division/country:fi/kunta:espoo/postinumero:02740 | 2020-10-02T09:50:52.700810+03:00 | postcode_area | 11 | espoo | 02740 | |||||
5599 | 49-02750 | ocd-division/country:fi/kunta:espoo/postinumero:02750 | 2020-10-02T09:50:52.707855+03:00 | postcode_area | 11 | espoo | 02750 | |||||
5600 | 49-02760 | ocd-division/country:fi/kunta:espoo/postinumero:02760 | 2020-10-02T09:50:52.714690+03:00 | postcode_area | 11 | espoo | 02760 | |||||
5601 | 49-02770 | ocd-division/country:fi/kunta:espoo/postinumero:02770 | 2020-10-02T09:50:52.721605+03:00 | postcode_area | 11 | espoo | 02770 | |||||
5602 | 49-02780 | ocd-division/country:fi/kunta:espoo/postinumero:02780 | 2020-10-02T09:50:52.728825+03:00 | postcode_area | 11 | espoo | 02780 | |||||
5603 | 49-02810 | ocd-division/country:fi/kunta:espoo/postinumero:02810 | 2020-10-02T09:50:52.736667+03:00 | postcode_area | 11 | espoo | 02810 | |||||
5604 | 49-02820 | ocd-division/country:fi/kunta:espoo/postinumero:02820 | 2020-10-02T09:50:52.743566+03:00 | postcode_area | 11 | espoo | 02820 | |||||
5605 | 49-02860 | ocd-division/country:fi/kunta:espoo/postinumero:02860 | 2020-10-02T09:50:52.751588+03:00 | postcode_area | 11 | espoo | 02860 | |||||
5606 | 49-02920 | ocd-division/country:fi/kunta:espoo/postinumero:02920 | 2020-10-02T09:50:52.759990+03:00 | postcode_area | 11 | espoo | 02920 | |||||
5607 | 49-02940 | ocd-division/country:fi/kunta:espoo/postinumero:02940 | 2020-10-02T09:50:52.767218+03:00 | postcode_area | 11 | espoo | 02940 | |||||
5608 | 49-02970 | ocd-division/country:fi/kunta:espoo/postinumero:02970 | 2020-10-02T09:50:52.775276+03:00 | postcode_area | 11 | espoo | 02970 | |||||
5609 | 49-02980 | ocd-division/country:fi/kunta:espoo/postinumero:02980 | 2020-10-02T09:50:52.782548+03:00 | postcode_area | 11 | espoo | 02980 | |||||
5610 | 92-04260 | ocd-division/country:fi/kunta:vantaa/postinumero:04260 | 2020-10-02T09:50:52.789241+03:00 | postcode_area | 33 | vantaa | 04260 | |||||
5611 | 92-04320 | ocd-division/country:fi/kunta:vantaa/postinumero:04320 | 2020-10-02T09:50:52.795324+03:00 | postcode_area | 33 | vantaa | 04320 |
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 );