administrative_division
171 rows where type = "postcode_area" sorted by type
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
5493 | 91-00680 | ocd-division/country:fi/kunta:helsinki/postinumero:00680 | 2020-10-02T09:50:52.017332+03:00 | postcode_area | 32 | helsinki | 00680 | |||||
5494 | 91-00690 | ocd-division/country:fi/kunta:helsinki/postinumero:00690 | 2020-10-02T09:50:52.024096+03:00 | postcode_area | 32 | helsinki | 00690 | |||||
5495 | 91-00700 | ocd-division/country:fi/kunta:helsinki/postinumero:00700 | 2020-10-02T09:50:52.029796+03:00 | postcode_area | 32 | helsinki | 00700 | |||||
5496 | 91-00710 | ocd-division/country:fi/kunta:helsinki/postinumero:00710 | 2020-10-02T09:50:52.035448+03:00 | postcode_area | 32 | helsinki | 00710 | |||||
5497 | 91-00720 | ocd-division/country:fi/kunta:helsinki/postinumero:00720 | 2020-10-02T09:50:52.041135+03:00 | postcode_area | 32 | helsinki | 00720 | |||||
5498 | 91-00730 | ocd-division/country:fi/kunta:helsinki/postinumero:00730 | 2020-10-02T09:50:52.046761+03:00 | postcode_area | 32 | helsinki | 00730 | |||||
5499 | 91-00740 | ocd-division/country:fi/kunta:helsinki/postinumero:00740 | 2020-10-02T09:50:52.052890+03:00 | postcode_area | 32 | helsinki | 00740 | |||||
5500 | 91-00750 | ocd-division/country:fi/kunta:helsinki/postinumero:00750 | 2020-10-02T09:50:52.059635+03:00 | postcode_area | 32 | helsinki | 00750 | |||||
5501 | 91-00760 | ocd-division/country:fi/kunta:helsinki/postinumero:00760 | 2020-10-02T09:50:52.066484+03:00 | postcode_area | 32 | helsinki | 00760 | |||||
5502 | 91-00770 | ocd-division/country:fi/kunta:helsinki/postinumero:00770 | 2020-10-02T09:50:52.073491+03:00 | postcode_area | 32 | helsinki | 00770 | |||||
5503 | 91-00780 | ocd-division/country:fi/kunta:helsinki/postinumero:00780 | 2020-10-02T09:50:52.080272+03:00 | postcode_area | 32 | helsinki | 00780 | |||||
5504 | 91-00790 | ocd-division/country:fi/kunta:helsinki/postinumero:00790 | 2020-10-02T09:50:52.087295+03:00 | postcode_area | 32 | helsinki | 00790 | |||||
5505 | 91-00800 | ocd-division/country:fi/kunta:helsinki/postinumero:00800 | 2020-10-02T09:50:52.093618+03:00 | postcode_area | 32 | helsinki | 00800 | |||||
5506 | 91-00810 | ocd-division/country:fi/kunta:helsinki/postinumero:00810 | 2020-10-02T09:50:52.099505+03:00 | postcode_area | 32 | helsinki | 00810 | |||||
5507 | 91-00820 | ocd-division/country:fi/kunta:helsinki/postinumero:00820 | 2020-10-02T09:50:52.105707+03:00 | postcode_area | 32 | helsinki | 00820 | |||||
5508 | 91-00830 | ocd-division/country:fi/kunta:helsinki/postinumero:00830 | 2020-10-02T09:50:52.112202+03:00 | postcode_area | 32 | helsinki | 00830 | |||||
5509 | 91-00840 | ocd-division/country:fi/kunta:helsinki/postinumero:00840 | 2020-10-02T09:50:52.117808+03:00 | postcode_area | 32 | helsinki | 00840 | |||||
5510 | 91-00850 | ocd-division/country:fi/kunta:helsinki/postinumero:00850 | 2020-10-02T09:50:52.124212+03:00 | postcode_area | 32 | helsinki | 00850 | |||||
5511 | 91-00860 | ocd-division/country:fi/kunta:helsinki/postinumero:00860 | 2020-10-02T09:50:52.130133+03:00 | postcode_area | 32 | helsinki | 00860 | |||||
5512 | 91-00870 | ocd-division/country:fi/kunta:helsinki/postinumero:00870 | 2020-10-02T09:50:52.135892+03:00 | postcode_area | 32 | helsinki | 00870 | |||||
5513 | 91-00880 | ocd-division/country:fi/kunta:helsinki/postinumero:00880 | 2020-10-02T09:50:52.141527+03:00 | postcode_area | 32 | helsinki | 00880 | |||||
5514 | 91-00890 | ocd-division/country:fi/kunta:helsinki/postinumero:00890 | 2020-10-02T09:50:52.147201+03:00 | postcode_area | 32 | helsinki | 00890 | |||||
5515 | 91-00900 | ocd-division/country:fi/kunta:helsinki/postinumero:00900 | 2020-10-02T09:50:52.155073+03:00 | postcode_area | 32 | helsinki | 00900 | |||||
5516 | 91-00910 | ocd-division/country:fi/kunta:helsinki/postinumero:00910 | 2020-10-02T09:50:52.160897+03:00 | postcode_area | 32 | helsinki | 00910 | |||||
5517 | 91-00920 | ocd-division/country:fi/kunta:helsinki/postinumero:00920 | 2020-10-02T09:50:52.166023+03:00 | postcode_area | 32 | helsinki | 00920 | |||||
5518 | 91-00930 | ocd-division/country:fi/kunta:helsinki/postinumero:00930 | 2020-10-02T09:50:52.171229+03:00 | postcode_area | 32 | helsinki | 00930 | |||||
5519 | 91-00940 | ocd-division/country:fi/kunta:helsinki/postinumero:00940 | 2020-10-02T09:50:52.177051+03:00 | postcode_area | 32 | helsinki | 00940 | |||||
5520 | 91-00950 | ocd-division/country:fi/kunta:helsinki/postinumero:00950 | 2020-10-02T09:50:52.183131+03:00 | postcode_area | 32 | helsinki | 00950 | |||||
5521 | 91-00960 | ocd-division/country:fi/kunta:helsinki/postinumero:00960 | 2020-10-02T09:50:52.188904+03:00 | postcode_area | 32 | helsinki | 00960 | |||||
5522 | 91-00970 | ocd-division/country:fi/kunta:helsinki/postinumero:00970 | 2020-10-02T09:50:52.194468+03:00 | postcode_area | 32 | helsinki | 00970 | |||||
5523 | 91-00980 | ocd-division/country:fi/kunta:helsinki/postinumero:00980 | 2020-10-02T09:50:52.200091+03:00 | postcode_area | 32 | helsinki | 00980 | |||||
5524 | 91-00990 | ocd-division/country:fi/kunta:helsinki/postinumero:00990 | 2020-10-02T09:50:52.206029+03:00 | postcode_area | 32 | helsinki | 00990 | |||||
5525 | 92-01200 | ocd-division/country:fi/kunta:vantaa/postinumero:01200 | 2020-10-02T09:50:52.211852+03:00 | postcode_area | 33 | vantaa | 01200 | |||||
5526 | 92-01230 | ocd-division/country:fi/kunta:vantaa/postinumero:01230 | 2020-10-02T09:50:52.218327+03:00 | postcode_area | 33 | vantaa | 01230 | |||||
5527 | 92-01260 | ocd-division/country:fi/kunta:vantaa/postinumero:01260 | 2020-10-02T09:50:52.224612+03:00 | postcode_area | 33 | vantaa | 01260 | |||||
5528 | 92-01280 | ocd-division/country:fi/kunta:vantaa/postinumero:01280 | 2020-10-02T09:50:52.230616+03:00 | postcode_area | 33 | vantaa | 01280 | |||||
5529 | 92-01300 | ocd-division/country:fi/kunta:vantaa/postinumero:01300 | 2020-10-02T09:50:52.237720+03:00 | postcode_area | 33 | vantaa | 01300 | |||||
5530 | 92-01340 | ocd-division/country:fi/kunta:vantaa/postinumero:01340 | 2020-10-02T09:50:52.244738+03:00 | postcode_area | 33 | vantaa | 01340 | |||||
5531 | 92-01350 | ocd-division/country:fi/kunta:vantaa/postinumero:01350 | 2020-10-02T09:50:52.251008+03:00 | postcode_area | 33 | vantaa | 01350 | |||||
5532 | 92-01360 | ocd-division/country:fi/kunta:vantaa/postinumero:01360 | 2020-10-02T09:50:52.257054+03:00 | postcode_area | 33 | vantaa | 01360 | |||||
5533 | 92-01370 | ocd-division/country:fi/kunta:vantaa/postinumero:01370 | 2020-10-02T09:50:52.263146+03:00 | postcode_area | 33 | vantaa | 01370 | |||||
5534 | 92-01380 | ocd-division/country:fi/kunta:vantaa/postinumero:01380 | 2020-10-02T09:50:52.269148+03:00 | postcode_area | 33 | vantaa | 01380 | |||||
5535 | 92-01390 | ocd-division/country:fi/kunta:vantaa/postinumero:01390 | 2020-10-02T09:50:52.274926+03:00 | postcode_area | 33 | vantaa | 01390 | |||||
5536 | 92-01400 | ocd-division/country:fi/kunta:vantaa/postinumero:01400 | 2020-10-02T09:50:52.280427+03:00 | postcode_area | 33 | vantaa | 01400 | |||||
5537 | 92-01420 | ocd-division/country:fi/kunta:vantaa/postinumero:01420 | 2020-10-02T09:50:52.286594+03:00 | postcode_area | 33 | vantaa | 01420 | |||||
5538 | 92-01450 | ocd-division/country:fi/kunta:vantaa/postinumero:01450 | 2020-10-02T09:50:52.292396+03:00 | postcode_area | 33 | vantaa | 01450 | |||||
5539 | 92-01480 | ocd-division/country:fi/kunta:vantaa/postinumero:01480 | 2020-10-02T09:50:52.298186+03:00 | postcode_area | 33 | vantaa | 01480 | |||||
5540 | 92-01490 | ocd-division/country:fi/kunta:vantaa/postinumero:01490 | 2020-10-02T09:50:52.303832+03:00 | postcode_area | 33 | vantaa | 01490 |
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 );