Data specifications and definitions

Number of records:45,619
Last updated:
Update frequency:Quarterly (January, April, July and October)
Geographic coverage:All 50 U.S. states plus Washington, D.C.
Data formats:CSV, SQL, XLS
Language and Encoding:en-US, UTF-8
Supply:Direct online download (8.0MB zipped file)

Field formats

FieldExampleTypeDescription
ID3119INTEGERThis field contains a unique integer identifier for the record.
NameSan ClementeTEXT(35)The official name of the city. Please see the naming conventions for more information.
CountyOrange CountyTEXT(33)The name of the county or local government area for the city. If a city spans multiple counties, the county names are separated with a forward slash character and listed in order of total area covered (with the largest first).
State codeCATEXT(2)The 2 character abbreviation for the state as defined in ISO 3166-2.
StateCaliforniaTEXT(20)The full-length name of the state that the city falls in.
ZIP codes92624 / 92672 / 92673 / 92674TEXT(1685)All ZIP codes in active use within the city limits. If a city spans multiple ZIP codes they are separated with a forward slash character.
TypeCityTEXT(23)Indicates the type of record: Borough, CDP (Census Designated Place), Charter Township, City, City and Borough, Consolidated Government, Corporation, Metro Government, Metropolitan Government, Municipality, Other, Town, Township, Unified Government, Urban County or Village.
Latitude33.42697NUMERIC(8,5)The WGS83 latitude coordinate for the center point of the city.
Longitude-117.61199NUMERIC(8,5)The WGS83 longitude coordinate for the center point of the city.
Area code949TEXT(3)The telephone area code for the city. If a city spans multiple area codes, the codes are separated with a forward slash character.
Population65,326INTEGERThe total population living within the city limits, using the latest US census 2014 population estimates. If not available this field is set to 0.
Households24,184INTEGERThe total number of households within the city limits using the latest 5 year estimates from the American Community Survey. If not available this field is set to 0.
Median income ($)90071INTEGERThe average (median) household income for the record using the latest 5 year estimates from the American Community Survey. If not available this field is set to 0.
Land area (m2)47,542,284INTEGERThe area of land covered by the city in sq. meters.
Water area (m2)1,965,336INTEGERThe area of water covered by the city in sq. meters.
Time zoneAmerica/Los AngelesTEXT(30)The IANA time zone for the city.

Naming conventions

All city names in the data follow a consistent naming convention. Specifically: