administrative_division
171 rows where type = "postcode_area" sorted by ocd_id
This data as json, CSV (advanced)
Suggested facets: parent, municipality, modified_at (date)
id | origin_id | ocd_id ▼ | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
5441 | 91-00100 | ocd-division/country:fi/kunta:helsinki/postinumero:00100 | 2020-10-02T09:50:51.665339+03:00 | postcode_area | 32 | helsinki | 00100 | |||||
5442 | 91-00120 | ocd-division/country:fi/kunta:helsinki/postinumero:00120 | 2020-10-02T09:50:51.671884+03:00 | postcode_area | 32 | helsinki | 00120 | |||||
5443 | 91-00130 | ocd-division/country:fi/kunta:helsinki/postinumero:00130 | 2020-10-02T09:50:51.678262+03:00 | postcode_area | 32 | helsinki | 00130 | |||||
5444 | 91-00140 | ocd-division/country:fi/kunta:helsinki/postinumero:00140 | 2020-10-02T09:50:51.684209+03:00 | postcode_area | 32 | helsinki | 00140 | |||||
5445 | 91-00150 | ocd-division/country:fi/kunta:helsinki/postinumero:00150 | 2020-10-02T09:50:51.689901+03:00 | postcode_area | 32 | helsinki | 00150 | |||||
5446 | 91-00160 | ocd-division/country:fi/kunta:helsinki/postinumero:00160 | 2020-10-02T09:50:51.696165+03:00 | postcode_area | 32 | helsinki | 00160 | |||||
5447 | 91-00170 | ocd-division/country:fi/kunta:helsinki/postinumero:00170 | 2020-10-02T09:50:51.704632+03:00 | postcode_area | 32 | helsinki | 00170 | |||||
5448 | 91-00180 | ocd-division/country:fi/kunta:helsinki/postinumero:00180 | 2020-10-02T09:50:51.712031+03:00 | postcode_area | 32 | helsinki | 00180 | |||||
5449 | 91-00190 | ocd-division/country:fi/kunta:helsinki/postinumero:00190 | 2020-10-02T09:50:51.718158+03:00 | postcode_area | 32 | helsinki | 00190 | |||||
5450 | 91-00200 | ocd-division/country:fi/kunta:helsinki/postinumero:00200 | 2020-10-02T09:50:51.724118+03:00 | postcode_area | 32 | helsinki | 00200 | |||||
5451 | 91-00210 | ocd-division/country:fi/kunta:helsinki/postinumero:00210 | 2020-10-02T09:50:51.729821+03:00 | postcode_area | 32 | helsinki | 00210 | |||||
5452 | 91-00220 | ocd-division/country:fi/kunta:helsinki/postinumero:00220 | 2020-10-02T09:50:51.735497+03:00 | postcode_area | 32 | helsinki | 00220 | |||||
5453 | 91-00230 | ocd-division/country:fi/kunta:helsinki/postinumero:00230 | 2020-10-02T09:50:51.741625+03:00 | postcode_area | 32 | helsinki | 00230 | |||||
5454 | 91-00240 | ocd-division/country:fi/kunta:helsinki/postinumero:00240 | 2020-10-02T09:50:51.747562+03:00 | postcode_area | 32 | helsinki | 00240 | |||||
5455 | 91-00250 | ocd-division/country:fi/kunta:helsinki/postinumero:00250 | 2020-10-02T09:50:51.755273+03:00 | postcode_area | 32 | helsinki | 00250 | |||||
5456 | 91-00260 | ocd-division/country:fi/kunta:helsinki/postinumero:00260 | 2020-10-02T09:50:51.763366+03:00 | postcode_area | 32 | helsinki | 00260 | |||||
5457 | 91-00270 | ocd-division/country:fi/kunta:helsinki/postinumero:00270 | 2020-10-02T09:50:51.769685+03:00 | postcode_area | 32 | helsinki | 00270 | |||||
5458 | 91-00280 | ocd-division/country:fi/kunta:helsinki/postinumero:00280 | 2020-10-02T09:50:51.776460+03:00 | postcode_area | 32 | helsinki | 00280 | |||||
5459 | 91-00290 | ocd-division/country:fi/kunta:helsinki/postinumero:00290 | 2020-10-02T09:50:51.781724+03:00 | postcode_area | 32 | helsinki | 00290 | |||||
5460 | 91-00300 | ocd-division/country:fi/kunta:helsinki/postinumero:00300 | 2020-10-02T09:50:51.789196+03:00 | postcode_area | 32 | helsinki | 00300 | |||||
5461 | 91-00310 | ocd-division/country:fi/kunta:helsinki/postinumero:00310 | 2020-10-02T09:50:51.796073+03:00 | postcode_area | 32 | helsinki | 00310 | |||||
5462 | 91-00320 | ocd-division/country:fi/kunta:helsinki/postinumero:00320 | 2020-10-02T09:50:51.803974+03:00 | postcode_area | 32 | helsinki | 00320 | |||||
5463 | 91-00330 | ocd-division/country:fi/kunta:helsinki/postinumero:00330 | 2020-10-02T09:50:51.810867+03:00 | postcode_area | 32 | helsinki | 00330 | |||||
5464 | 91-00340 | ocd-division/country:fi/kunta:helsinki/postinumero:00340 | 2020-10-02T09:50:51.817652+03:00 | postcode_area | 32 | helsinki | 00340 | |||||
5465 | 91-00350 | ocd-division/country:fi/kunta:helsinki/postinumero:00350 | 2020-10-02T09:50:51.824016+03:00 | postcode_area | 32 | helsinki | 00350 | |||||
5466 | 91-00360 | ocd-division/country:fi/kunta:helsinki/postinumero:00360 | 2020-10-02T09:50:51.830529+03:00 | postcode_area | 32 | helsinki | 00360 | |||||
5467 | 91-00370 | ocd-division/country:fi/kunta:helsinki/postinumero:00370 | 2020-10-02T09:50:51.836861+03:00 | postcode_area | 32 | helsinki | 00370 | |||||
5468 | 91-00380 | ocd-division/country:fi/kunta:helsinki/postinumero:00380 | 2020-10-02T09:50:51.844051+03:00 | postcode_area | 32 | helsinki | 00380 | |||||
5469 | 91-00390 | ocd-division/country:fi/kunta:helsinki/postinumero:00390 | 2020-10-02T09:50:51.850668+03:00 | postcode_area | 32 | helsinki | 00390 | |||||
5470 | 91-00400 | ocd-division/country:fi/kunta:helsinki/postinumero:00400 | 2020-10-02T09:50:51.856375+03:00 | postcode_area | 32 | helsinki | 00400 | |||||
5471 | 91-00410 | ocd-division/country:fi/kunta:helsinki/postinumero:00410 | 2020-10-02T09:50:51.862029+03:00 | postcode_area | 32 | helsinki | 00410 | |||||
5472 | 91-00420 | ocd-division/country:fi/kunta:helsinki/postinumero:00420 | 2020-10-02T09:50:51.867723+03:00 | postcode_area | 32 | helsinki | 00420 | |||||
5473 | 91-00430 | ocd-division/country:fi/kunta:helsinki/postinumero:00430 | 2020-10-02T09:50:51.874041+03:00 | postcode_area | 32 | helsinki | 00430 | |||||
5474 | 91-00440 | ocd-division/country:fi/kunta:helsinki/postinumero:00440 | 2020-10-02T09:50:51.880855+03:00 | postcode_area | 32 | helsinki | 00440 | |||||
5475 | 91-00500 | ocd-division/country:fi/kunta:helsinki/postinumero:00500 | 2020-10-02T09:50:51.888736+03:00 | postcode_area | 32 | helsinki | 00500 | |||||
5476 | 91-00510 | ocd-division/country:fi/kunta:helsinki/postinumero:00510 | 2020-10-02T09:50:51.897868+03:00 | postcode_area | 32 | helsinki | 00510 | |||||
5477 | 91-00520 | ocd-division/country:fi/kunta:helsinki/postinumero:00520 | 2020-10-02T09:50:51.908139+03:00 | postcode_area | 32 | helsinki | 00520 | |||||
5478 | 91-00530 | ocd-division/country:fi/kunta:helsinki/postinumero:00530 | 2020-10-02T09:50:51.917040+03:00 | postcode_area | 32 | helsinki | 00530 | |||||
5479 | 91-00540 | ocd-division/country:fi/kunta:helsinki/postinumero:00540 | 2020-10-02T09:50:51.924087+03:00 | postcode_area | 32 | helsinki | 00540 | |||||
5480 | 91-00550 | ocd-division/country:fi/kunta:helsinki/postinumero:00550 | 2020-10-02T09:50:51.930060+03:00 | postcode_area | 32 | helsinki | 00550 | |||||
5481 | 91-00560 | ocd-division/country:fi/kunta:helsinki/postinumero:00560 | 2020-10-02T09:50:51.938085+03:00 | postcode_area | 32 | helsinki | 00560 | |||||
5482 | 91-00570 | ocd-division/country:fi/kunta:helsinki/postinumero:00570 | 2020-10-02T09:50:51.947500+03:00 | postcode_area | 32 | helsinki | 00570 | |||||
5483 | 91-00580 | ocd-division/country:fi/kunta:helsinki/postinumero:00580 | 2020-10-02T09:50:51.956031+03:00 | postcode_area | 32 | helsinki | 00580 | |||||
5484 | 91-00590 | ocd-division/country:fi/kunta:helsinki/postinumero:00590 | 2020-10-02T09:50:51.962584+03:00 | postcode_area | 32 | helsinki | 00590 | |||||
5485 | 91-00600 | ocd-division/country:fi/kunta:helsinki/postinumero:00600 | 2020-10-02T09:50:51.968444+03:00 | postcode_area | 32 | helsinki | 00600 | |||||
5486 | 91-00610 | ocd-division/country:fi/kunta:helsinki/postinumero:00610 | 2020-10-02T09:50:51.974317+03:00 | postcode_area | 32 | helsinki | 00610 | |||||
5487 | 91-00620 | ocd-division/country:fi/kunta:helsinki/postinumero:00620 | 2020-10-02T09:50:51.980107+03:00 | postcode_area | 32 | helsinki | 00620 | |||||
5488 | 91-00630 | ocd-division/country:fi/kunta:helsinki/postinumero:00630 | 2020-10-02T09:50:51.985328+03:00 | postcode_area | 32 | helsinki | 00630 | |||||
5489 | 91-00640 | ocd-division/country:fi/kunta:helsinki/postinumero:00640 | 2020-10-02T09:50:51.990842+03:00 | postcode_area | 32 | helsinki | 00640 | |||||
5490 | 91-00650 | ocd-division/country:fi/kunta:helsinki/postinumero:00650 | 2020-10-02T09:50:51.996996+03:00 | postcode_area | 32 | helsinki | 00650 | |||||
5491 | 91-00660 | ocd-division/country:fi/kunta:helsinki/postinumero:00660 | 2020-10-02T09:50:52.002440+03:00 | postcode_area | 32 | helsinki | 00660 | |||||
5492 | 91-00670 | ocd-division/country:fi/kunta:helsinki/postinumero:00670 | 2020-10-02T09:50:52.010071+03:00 | postcode_area | 32 | helsinki | 00670 |
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 );