Hubble by Deck
Search
⌃K

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,000 counties in the US including previous versions of the county.

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 name of a given county (proper case).
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, ...))"
}
]