Zip Code Tabulation Areas (ZCTA) by Place

Get the list of all Zip Code Tabulation Areas (ZCTA) in the United States with corresponding list of Places associated with each ZCTA, and details including: the County where the Place is located, the Classification of the Place (borough, CDP, city, municipality, town, urban county, village, comunidad, zona urbana, consolidated government, unified government, metropolitan government, metro government, metro township), the global location or coordinates (Latitude and Longitude) of the Place, the Elevation of the Place, the Land Area and Water Area of both ZCTA and Place, and how much Land Area and Water Area of that Place is assigned to that ZCTA.

ZCTA Codes are ZIP Codes that are used by the Census Bureau to represent population blocks or tabulation areas. For tabulation blocks that contain housing units, the ZCTA Code is the ZIP Code associated with the most addresses in that block. Only populated areas are included in the Census data, and thus ZIP Codes that only serve PO Boxes have no corresponding ZCTA.

The list is sorted by State Name, then Place name, and then ZCTA Code.

Row #ZCTA CodeState Abbr.Place NamePlace ClassCounty NameLatitude
(DMS)		Longitude
(DMS)		Latitude
(dec)		Longitude
(dec)		Elevation
(meters)		Elevation
(feet)		ZCTA
Land Area
(sq meters)		ZCTA
Water Area
(sq meters)		Place
Land Area
(sq meters)		Place
Water Area
(sq meters)		Land Area
Part
(sq meters)		Water Area
Part
(sq meters)
3163613495NYNew York MillsvillageOneida430603N0751735W43.1007043-75.29311331524992242191030567610435320
3163714513NYNewarkvillageWayne430230N0770535W43.0417867-77.092965314447211716473419598414035204119701403520411970
3163813811NYNewark ValleyvillageTioga421322N0761112W42.2229058-76.18677592889451611466823886962558385025583850
3163912550NYNewburghcityOrange413013N0740114W41.5036973-74.020472266217898164241652550985774725337399614254112185
3164012553NYNewburghcityOrange413013N0740114W41.5036973-74.020472266217625890852665349985774725337392434930
3164114028NYNewfaneCDPNiagara431708N0784138W43.2856857-78.693946410534435918090132526313735039018818870
3164214108NYNewfaneCDPNiagara431708N0784138W43.2856857-78.6939464105344642961470137350390118531520
3164314867NYNewfieldCDPTompkins422130N0763532W42.3582519-76.592256434911451753774433691253256315254932563152549
3164413416NYNewportvillageHerkimer431109N0750054W43.1859195-75.015095520165913025384869018813620061661271362006166127
3164514301NYNiagara FallscityNiagara430532N0790053W43.0920924-79.014731717457153553032195913648261571008595355303219591
Download sample Excel file »  
Download sample Excel file »
"id","ZCTA_CODE","STATE_ABBR","PLACE_NAME","PLACE_CLASS","COUNTY_NAME","LAT_DMS","LONG_DMS","LAT_DEC","LONG_DEC","ELEV_IN_M","ELEV_IN_FT","ZCTA_ALAND_SQM","ZCTA_AWATER_SQM","PLACE_ALAND_SQM","PLACE_AWATER_SQM","AREALAND_PART","AREAWATER_PART"
31636,"13495","NY","New York Mills","village","Oneida","430603N","0751735W",43.1007043,-75.2931133,152,499,2242191,0,3056761,0,43532,0
31637,"14513","NY","Newark","village","Wayne","430230N","0770535W",43.0417867,-77.0929653,144,472,117164734,195984,14035204,11970,14035204,11970
31638,"13811","NY","Newark Valley","village","Tioga","421322N","0761112W",42.2229058,-76.1867759,288,945,161146682,388696,2558385,0,2558385,0
31639,"12550","NY","Newburgh","city","Orange","413013N","0740114W",41.5036973,-74.0204722,66,217,89816424,1652550,9857747,2533739,9614254,112185
31640,"12553","NY","Newburgh","city","Orange","413013N","0740114W",41.5036973,-74.0204722,66,217,62589085,2665349,9857747,2533739,243493,0
31641,"14028","NY","Newfane","CDP","Niagara","431708N","0784138W",43.2856857,-78.6939464,105,344,35918090,1325263,13735039,0,1881887,0
31642,"14108","NY","Newfane","CDP","Niagara","431708N","0784138W",43.2856857,-78.6939464,105,344,64296147,0,13735039,0,11853152,0
31643,"14867","NY","Newfield","CDP","Tompkins","422130N","0763532W",42.3582519,-76.5922564,349,1145,175377443,369125,3256315,2549,3256315,2549
31644,"13416","NY","Newport","village","Herkimer","431109N","0750054W",43.1859195,-75.0150955,201,659,130253848,690188,1362006,166127,1362006,166127
31645,"14301","NY","Niagara Falls","city","Niagara","430532N","0790053W",43.0920924,-79.0147317,174,571,5355303,219591,36482615,7100859,5355303,219591
Download sample CSV file »  
Download sample CSV file »
ColumnsTypeMax LengthExample
Row # NUMBER
(unique to each row)		 5 6569
ZCTA Code TEXT 5 93454
State Abbr. TEXT 2 CA
Place Name TEXT 50 Santa Maria
Place Class TEXT 25 city
County Name TEXT 30 Santa Barbara
Latitude (DMS) TEXT 7 345600N
Longitude (DMS) TEXT 8 1202636W
Latitude (dec) DECIMAL 9,7 34.9334293
Longitude (dec) DECIMAL 10,7 -120.4433280
Elevation (meters) NUMBER 6 65
Elevation (feet) NUMBER 7 213
ZCTA Land Area (sq meters) NUMBER 11 1083353419
ZCTA Water Area (sq meters) NUMBER 10 9729254
Place Land Area (sq meters) NUMBER 10 59078451
Place Water Area (sq meters) NUMBER 10 1575636
Land Area Part (sq meters) NUMBER 11 17035167
Water Area Part (sq meters) NUMBER 10 1342232

About the website

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.