Hubble by Deck
Searchโ€ฆ
county
A county is an administrative region defined by a state. (In Alaska, the term "borough" is used. In Louisiana, the term "parish" is used.) Counties typically have independent governments with delegated jurisdiction over functions like tax collection, policing, and election administration.
This table includes records for each of the 3,143 counties in the US.

Schema

Field
Description
year
The year associated with a given county definition record.
is latest version
A boolean indicating whether a record is the latest available for a given county.
county fips
A unique 5-digit code, maintained by the U.S. Census, assigned to each county. (The first two digits repeat state_fips.)
county name
The county's name, according to the U.S. Census.
state fips
A unique 2-digit code, maintained by the U.S. Census, for the state this county sits within.
state abbreviation
The two-letter abbreviation for the state this county sits within.
state name
The name of the state this county sits within.
shape
A polygon of the county's shape, represented in BigQuery's GEOGRAPHY data type.

Example entry

[
{
"year": "2010",
"is_latest_version": false,
"county_fips": "04013",
"county_name": "Maricopa County",
"state_fips": "04",
"state_abbreviation": "AZ",
"state_name": "Arizona",
"shape": "POLYGON((-112.016347 33.370803, -112.016591 33.370742, ...))"
}
]
Export as PDF
Copy link
On this page
Schema
Example entry