File Structure:
Field name | Field type | Description | STANDARD | STREET+ |
---|---|---|---|---|
ISO | Char(2) | ISO 3166-1 Country code | ![]() | ![]() |
Level | Smallint | Administrative level | ![]() | ![]() |
Type | Char(50) | Type of administrative unit | ![]() | ![]() |
Name | Char(80) | Administrative division name | ![]() | ![]() |
Country | Char(50) | Country name | ![]() | ![]() |
Region1 | Char(80) | Administrative division level 1 | ![]() | ![]() |
Region2 | Char(80) | Administrative division level 2 | ![]() | ![]() |
Region3 | Char(80) | Administrative division level 3 | ![]() | ![]() |
Region4 | Char(80) | Administrative division level 4 | ![]() | ![]() |
ISO2 | Char(10) | ISO 3166-2 Region code | ![]() | ![]() |
FIPS | Char(10) | NGA Geopolitical code (formerly FIPS PUB 10-4) | ![]() | ![]() |
NUTS | Char(10) | European division code | ![]() | ![]() |
HASC | Char(10) | Hierarchical administrative subdivision code | ![]() | ![]() |
STAT | Char(20) | National statistics/census code | ![]() | ![]() |
PADD Database Content (252 Countries and Territories)
Countries | Admin 1 | Admin 2 | Admin 3 | Admin 4 | Total |
---|---|---|---|---|---|
Afghanistan | 34 | 400 | 434 | ||
Åland (FI) | 3 | 16 | 19 | ||
Albania | 12 | 36 | 374 | 422 | |
Algeria | 48 | 48 | |||
American Samoa (US) | 5 | 16 | 21 | ||
Andorra | 7 | 7 | |||
Angola | 18 | 164 | 527 | 709 | |
Anguilla (GB) | 14 | 14 | |||
Antigua & Barbuda | 8 | 8 | |||
Argentina | 24 | 528 | 48 | 600 | |
Armenia | 11 | 41 | 915 | 967 | |
Aruba (NL) | 8 | 8 | |||
Australia | 16 | 58 | 563 | 637 | |
Austria | 9 | 95 | 2 357 | 2 461 | |
Azerbaijan | 10 | 77 | 87 | ||
Bahamas | 32 | 32 | |||
Bahrain | 5 | 5 | |||
Bangladesh | 7 | 64 | 525 | 596 | |
Barbados | 11 | 11 | |||
Belarus | 7 | 238 | 1 547 | 1 792 | |
Belgium | 3 | 10 | 43 | 589 | 645 |
Belize | 6 | 6 | |||
Benin | 12 | 77 | 89 | ||
Bermuda (GB) | 11 | 11 | |||
Bhutan | 20 | 20 | |||
Bolivia | 9 | 112 | 327 | 448 | |
Bosnia-Herzegovina | 3 | 10 | 141 | 154 | |
Botswana | 9 | 28 | 37 | ||
Brazil | 27 | 557 | 5 570 | 6 154 | |
British Virgin Islands (GB) | 5 | 5 | |||
Brunei | 4 | 39 | 43 | ||
Bulgaria | 6 | 28 | 264 | 298 | |
Burkina Faso | 13 | 45 | 351 | 409 | |
Burundi | 18 | 129 | 2 619 | 2 766 | |
Cambodia | 25 | 193 | 1 622 | 1 840 | |
Cameroon | 10 | 58 | 360 | 428 | |
Canada | 13 | 310 | 103 | 426 | |
Cape Verde | 22 | 32 | 54 | ||
Caribbean Netherlands (NL) | 3 | 3 | |||
Cayman Islands (GB) | 6 | 6 | |||
Central African Rep. | 17 | 79 | 170 | 266 | |
Chad | 23 | 67 | 362 | 452 | |
Chile | 15 | 54 | 346 | 415 | |
China | 34 | 338 | 2 866 | 33 476 | 36 714 |
Colombia | 33 | 92 | 1 123 | 20 | 1 268 |
Comoros | 3 | 3 | |||
Congo-Brazzaville | 12 | 46 | 58 | ||
Congo D.R. | 11 | 48 | 188 | 737 | 984 |
Cook Islands (NZ) | 3 | 3 | |||
Costa Rica | 7 | 81 | 473 | 561 | |
Côte d'Ivoire | 14 | 33 | 95 | 498 | 640 |
Croatia | 21 | 556 | 577 | ||
Cuba | 16 | 168 | 184 | ||
Cyprus | 6 | 6 | |||
Czech Republic | 14 | 77 | 6 248 | 6 339 | |
Denmark | 8 | 98 | 106 | ||
Djibouti | 6 | 11 | 17 | ||
Dominica | 10 | 10 | |||
Dominican Republic | 32 | 155 | 386 | 573 | |
Ecuador | 25 | 224 | 249 | ||
Egypt | 27 | 351 | 378 | ||
El Salvador | 14 | 262 | 276 | ||
Equatorial Guinea | 2 | 7 | 9 | ||
Eritrea | 6 | 58 | 64 | ||
Estonia | 15 | 226 | 241 | ||
Ethiopia | 11 | 74 | 683 | 768 | |
Falkland Islands (GB) | 2 | 776 | 778 | ||
Faroe Islands (DK) | 6 | 30 | 36 | ||
Fiji | 5 | 15 | 86 | 106 | |
Finland | 7 | 19 | 70 | 317 | 413 |
France | 36 | 101 | 341 | 3 779 | 4 257 |
French Guiana (FR) | 1 | 1 | 2 | 22 | 26 |
French Polynesia (FR) | 5 | 5 | |||
French Southern Territories (FR) | 3 | 3 | |||
Gabon | 9 | 48 | 57 | ||
Gambia | 8 | 43 | 51 | ||
Georgia | 12 | 72 | 84 | ||
Germany | 16 | 19 | 402 | 4 388 | 4 825 |
Ghana | 10 | 170 | 180 | ||
Greece | 14 | 325 | 339 | ||
Greenland (DK) | 4 | 4 | |||
Grenada | 7 | 7 | |||
Guadeloupe (FR) | 1 | 1 | 2 | 32 | 36 |
Guam (US) | 19 | 19 | |||
Guatemala | 22 | 334 | 356 | ||
Guernsey (GB) | 16 | 16 | |||
Guinea | 8 | 38 | 336 | 2 991 | 3 373 |
Guinea-Bissau | 9 | 39 | 48 | ||
Guyana | 10 | 118 | 128 | ||
Haiti | 10 | 42 | 140 | 570 | 762 |
Honduras | 18 | 298 | 316 | ||
Hong Kong (CN) | 3 | 18 | 21 | ||
Hungary | 7 | 20 | 175 | 202 | |
Iceland | 8 | 74 | 82 | ||
India | 36 | 59 | 643 | 6 071 | 6 809 |
Indonesia | 34 | 501 | 6 994 | 7 529 | |
Iran | 31 | 31 | |||
Iraq | 19 | 103 | 122 | ||
Ireland | 4 | 34 | 38 | ||
Isle of Man (GB) | 6 | 24 | 30 | ||
Israel | 7 | 27 | 34 | ||
Italy | 20 | 110 | 8 047 | 8 177 | |
Jamaica | 14 | 14 | |||
Japan | 8 | 47 | 1 179 | 1 095 | 2 329 |
Jersey (GB) | 12 | 12 | |||
Jordan | 12 | 51 | 63 | ||
Kazakhstan | 16 | 192 | 208 | ||
Kenya | 47 | 290 | 1 438 | 1 775 | |
Kiribati | 3 | 23 | 26 | ||
Kuwait | 6 | 75 | 81 | ||
Kyrgyzstan | 9 | 53 | 62 | ||
Laos | 18 | 142 | 160 | ||
Latvia | 119 | 564 | 683 | ||
Lebanon | 6 | 26 | 1 517 | 1 549 | |
Lesotho | 10 | 129 | 139 | ||
Liberia | 15 | 137 | 570 | 722 | |
Libya | 22 | 22 | |||
Liechtenstein | 11 | 11 | |||
Lithuania | 10 | 60 | 550 | 620 | |
Luxembourg | 3 | 12 | 105 | 120 | |
Macau (CN) | 2 | 2 | |||
Macedonia | 8 | 84 | 92 | ||
Madagascar | 6 | 22 | 114 | 1 578 | 1 720 |
Malawi | 3 | 28 | 31 | ||
Malaysia | 16 | 239 | 1 004 | 99 | 1 358 |
Maldives | 8 | 20 | 287 | 315 | |
Mali | 9 | 49 | 701 | 759 | |
Malta | 6 | 68 | 74 | ||
Martinique (FR) | 1 | 1 | 4 | 34 | 40 |
Mauritania | 13 | 55 | 218 | 286 | |
Mauritius | 12 | 12 | |||
Mayotte (FR) | 1 | 1 | 17 | 19 | |
Mexico | 32 | 2 457 | 2 489 | ||
Micronesia (US) | 4 | 4 | |||
Minor Outlying Islands (US) | 11 | 11 | |||
Moldova | 37 | 10 | 47 | ||
Mongolia | 22 | 339 | 361 | ||
Montenegro | 23 | 23 | |||
Montserrat (GB) | 3 | 3 | |||
Morocco | 12 | 75 | 87 | ||
Mozambique | 11 | 128 | 408 | 547 | |
Myanmar (Burma) | 14 | 67 | 325 | 406 | |
Namibia | 14 | 107 | 121 | ||
Nauru | 14 | 14 | |||
Nepal | 5 | 14 | 75 | 94 | |
Netherlands | 15 | 396 | 411 | ||
New Caledonia (FR) | 3 | 33 | 36 | ||
New Zealand | 20 | 66 | 86 | ||
Nicaragua | 17 | 153 | 170 | ||
Niger | 8 | 36 | 264 | 308 | |
Nigeria | 37 | 774 | 2 744 | 3 555 | |
Northern Mariana Islands (US) | 4 | 4 | |||
North Korea | 11 | 180 | 191 | ||
Norway | 24 | 428 | 452 | ||
Oman | 11 | 61 | 72 | ||
Pakistan | 8 | 144 | 470 | 622 | |
Palau (US) | 16 | 16 | |||
Palestine | 2 | 16 | 18 | ||
Panama | 15 | 76 | 622 | 713 | |
Papua New Guinea | 22 | 87 | 109 | ||
Paraguay | 18 | 18 | |||
Peru | 25 | 196 | 1 834 | 2 055 | |
Philippines | 18 | 80 | 1 634 | 1 732 | |
Pitcairn Islands (GB) | 4 | 4 | |||
Poland | 16 | 380 | 2 479 | 2 875 | |
Portugal | 20 | 308 | 3 092 | 3 420 | |
Puerto Rico (US) | 78 | 78 | |||
Qatar | 7 | 7 | |||
Réunion (FR) | 1 | 1 | 4 | 24 | 30 |
Romania | 8 | 42 | 3 185 | 3 235 | |
Russia | 83 | 2 481 | 125 | 2 689 | |
Rwanda | 5 | 30 | 416 | 451 | |
Saint Helena (GB) | 8 | 8 | |||
Saint Kitts and Nevis | 14 | 14 | |||
Saint Lucia | 10 | 10 | |||
Samoa | 11 | 43 | 54 | ||
San Marino | 9 | 9 | |||
São Tomé & Príncipe | 2 | 7 | 9 | ||
Saudi Arabia | 13 | 118 | 1 260 | 1 391 | |
Senegal | 14 | 45 | 237 | 374 | 670 |
Serbia | 3 | 30 | 194 | 227 | |
Seychelles | 26 | 26 | |||
Sierra Leone | 4 | 14 | 166 | 184 | |
Singapore | 5 | 28 | 33 | ||
Slovakia | 8 | 79 | 2 929 | 3 016 | |
Slovenia | 12 | 212 | 224 | ||
Solomon Islands | 10 | 10 | |||
Somalia | 18 | 90 | 108 | ||
South Africa | 9 | 52 | 226 | 287 | |
South Korea | 17 | 251 | 268 | ||
South Sudan | 10 | 78 | 88 | ||
Spain | 19 | 50 | 477 | 8 119 | 8 665 |
Sri Lanka | 9 | 25 | 328 | 362 | |
St Vinc. & Grenadines | 6 | 6 | |||
Sudan | 17 | 133 | 150 | ||
Suriname | 10 | 62 | 72 | ||
Svalbard and Jan Mayen (NO) | 2 | 2 | |||
Swaziland | 4 | 55 | 59 | ||
Sweden | 21 | 290 | 311 | ||
Switzerland | 26 | 147 | 2 330 | 2 503 | |
Syria | 14 | 60 | 269 | 343 | |
Taiwan (CN) | 22 | 369 | 391 | ||
Tajikistan | 5 | 73 | 78 | ||
Tanzania | 30 | 169 | 3 643 | 3 842 | |
Thailand | 6 | 78 | 929 | 1 013 | |
Timor-Leste | 13 | 65 | 442 | 520 | |
Togo | 5 | 31 | 36 | ||
Tonga | 5 | 24 | 29 | ||
Trinidad & Tobago | 2 | 14 | 16 | ||
Tunisia | 24 | 265 | 289 | ||
Turkey | 7 | 81 | 970 | 2 437 | 3 495 |
Turkmenistan | 6 | 13 | 19 | ||
Turks and Caicos Islands (GB) | 2 | 6 | 8 | ||
Tuvalu | 9 | 9 | |||
Uganda | 4 | 112 | 164 | 947 | 1 227 |
Ukraine | 27 | 682 | 709 | ||
United Arab Emirates | 7 | 7 | |||
United Kingdom | 20 | 89 | 89 | 270 | 468 |
United States | 61 | 3 142 | 3 203 | ||
Uruguay | 19 | 19 | |||
U.S. Virgin Islands (US) | 3 | 3 | |||
Uzbekistan | 14 | 184 | 198 | ||
Vanuatu | 6 | 6 | |||
Venezuela | 25 | 335 | 1 089 | 1 449 | |
Vietnam | 8 | 63 | 700 | 11 185 | 11 956 |
Wallis and Futuna (FR) | 3 | 3 | 6 | ||
Western Sahara | 4 | 4 | |||
Yemen | 22 | 333 | 355 | ||
Zambia | 10 | 74 | 84 | ||
Zimbabwe | 10 | 62 | 72 |