Get the list of all ZIP Codes in the United States with Full Delivery Address and other location details such as County, Locale Name, District, Area (Atlantic, Central, Southern, West Pacific, Headquarters, Overseas), the Type of Zip Code (Standard, PO Box, Unique, Military) and the list of Cities associated with each Zip Code.
The list is sorted by Zip Code.
Row # | Zip Code | State Id | Default State | Default City | Default Type | Physical Delivery Address | Physical City | Physical State | Physical County | Physical Zip | Physical Zip4 | Locale Name | District Name | Area Name |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4612 | 12401 | 37 | NY | KINGSTON | STANDARD | 90 CORNELL ST | KINGSTON | NY | ULSTER | 12401 | 9998 | KINGSTON | NEW YORK 3 | ATLANTIC |
4613 | 12402 | 37 | NY | KINGSTON | PO BOX | 1300 ULSTER AVE STE 101 | KINGSTON | NY | ULSTER | 12401 | 1518 | HUDSON VALLEY MALL | NEW YORK 3 | ATLANTIC |
4614 | 12402 | 37 | NY | KINGSTON | PO BOX | 90 CORNELL ST | KINGSTON | NY | ULSTER | 12401 | 9998 | KINGSTON | NEW YORK 3 | ATLANTIC |
4615 | 12402 | 37 | NY | KINGSTON | PO BOX | 50 MAIN ST | KINGSTON | NY | ULSTER | 12401 | 3851 | UPTOWN | NEW YORK 3 | ATLANTIC |
4616 | 12404 | 37 | NY | ACCORD | STANDARD | 30 MAIN ST | ACCORD | NY | ULSTER | 12404 | 9998 | ACCORD | NEW YORK 3 | ATLANTIC |
4617 | 12405 | 37 | NY | ACRA | STANDARD | 522 OLD ROUTE 23 | ACRA | NY | GREENE | 12405 | 9998 | ACRA | NEW YORK 3 | ATLANTIC |
4618 | 12405 | 37 | NY | ACRA | STANDARD | 540 MAIN ST | CAIRO | NY | GREENE | 12413 | 9998 | CAIRO | NEW YORK 3 | ATLANTIC |
4619 | 12406 | 37 | NY | ARKVILLE | STANDARD | 43400 STATE ROUTE 28 | ARKVILLE | NY | DELAWARE | 12406 | 9998 | ARKVILLE | NEW YORK 3 | ATLANTIC |
4620 | 12406 | 37 | NY | ARKVILLE | STANDARD | 315 MAIN ST | MARGARETVILLE | NY | DELAWARE | 12455 | 9998 | MARGARETVILLE | NEW YORK 3 | ATLANTIC |
4621 | 12407 | 37 | NY | ASHLAND | STANDARD | 12101 STATE HIGHWAY 23 | ASHLAND | NY | GREENE | 12407 | 9998 | ASHLAND | NEW YORK 3 | ATLANTIC |
"id","ZIP_CODE","sid","default_state","default_city","default_type","PHYSICAL_DELV_ADDR","PHYSICAL_CITY","PHYSICAL_STATE","PHYSICAL_COUNTY","PHYSICAL_ZIP","PHYSICAL_ZIP_4","LOCALE_NAME","DISTRICT_NAME","AREA_NAME" 4612,"12401",37,"NY","KINGSTON","STANDARD","90 CORNELL ST","KINGSTON","NY","ULSTER","12401","9998","KINGSTON","NEW YORK 3","ATLANTIC" 4613,"12402",37,"NY","KINGSTON","PO BOX","1300 ULSTER AVE STE 101","KINGSTON","NY","ULSTER","12401","1518","HUDSON VALLEY MALL","NEW YORK 3","ATLANTIC" 4614,"12402",37,"NY","KINGSTON","PO BOX","90 CORNELL ST","KINGSTON","NY","ULSTER","12401","9998","KINGSTON","NEW YORK 3","ATLANTIC" 4615,"12402",37,"NY","KINGSTON","PO BOX","50 MAIN ST","KINGSTON","NY","ULSTER","12401","3851","UPTOWN","NEW YORK 3","ATLANTIC" 4616,"12404",37,"NY","ACCORD","STANDARD","30 MAIN ST","ACCORD","NY","ULSTER","12404","9998","ACCORD","NEW YORK 3","ATLANTIC" 4617,"12405",37,"NY","ACRA","STANDARD","522 OLD ROUTE 23","ACRA","NY","GREENE","12405","9998","ACRA","NEW YORK 3","ATLANTIC" 4618,"12405",37,"NY","ACRA","STANDARD","540 MAIN ST","CAIRO","NY","GREENE","12413","9998","CAIRO","NEW YORK 3","ATLANTIC" 4619,"12406",37,"NY","ARKVILLE","STANDARD","43400 STATE ROUTE 28","ARKVILLE","NY","DELAWARE","12406","9998","ARKVILLE","NEW YORK 3","ATLANTIC" 4620,"12406",37,"NY","ARKVILLE","STANDARD","315 MAIN ST","MARGARETVILLE","NY","DELAWARE","12455","9998","MARGARETVILLE","NEW YORK 3","ATLANTIC" 4621,"12407",37,"NY","ASHLAND","STANDARD","12101 STATE HIGHWAY 23","ASHLAND","NY","GREENE","12407","9998","ASHLAND","NEW YORK 3","ATLANTIC"
Columns | Type | Max Length | Example |
---|---|---|---|
Row # | NUMBER (unique to each row) |
5 | 4620 |
Zip Code | TEXT | 5 | 12406 |
State Id | NUMBER (unique to each state) |
2 | 37 |
Default State | TEXT | 2 | NY |
Default City | TEXT | 30 | ARKVILLE |
Default Type | TEXT | 10 | STANDARD |
Physical Delivery Address | TEXT | 40 | 315 MAIN ST |
Physical City | TEXT | 30 | MARGARETVILLE |
Physical State | TEXT | 2 | NY |
Physical County | TEXT | 30 | DELAWARE |
Physical Zip | TEXT | 5 | 12455 |
Physical Zip4 | TEXT | 4 | 9998 |
Locale Name | TEXT | 30 | MARGARETVILLE |
District Name | TEXT | 25 | NEW YORK 3 |
Area Name | TEXT | 12 | ATLANTIC |
This website is not affiliated with any organization. All the lists available on this website were obtained by processing publicly available records from various authorized government agencies such as the USPS, USGS, and the US Census Bureau. The raw data had been carefully collected, cleaned up, fixed, matched, consolidated and deduplicated (rid of any duplicates) in order to produce the most accurate and complete list as of December 2022.
The lists are well-formatted and can be directly imported as tables to any SQL/Database server without the need to edit file or fix any data.
To contact us, please leave a message.