Hubble by Deck
Search
⌃K

place

A place is either:
  • An incorporated place: a region defined by the US Census to follow the boundaries of incorporated jurisdictions within a state, such as cities, towns, and villages.
  • A census-designated place: a region defined by the US Census to follow the boundaries of communities that are not incorporated, but otherwise resemble incorporated places.
This table includes records for each place in the US. As of 2021, there were 31,617 places in the US — including 19,518 incorporated places and and 12,099 census-designated places.

Schema

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

Example entry

[
{
"year": "2010",
"is_latest_version": false,
"place_fips": "0649180",
"place_name": "Morada CDP",
"state_fips": "06",
"state_abbreviation": "CA",
"state_name": "California",
"shape": "POLYGON((-112.016347 33.370803, -112.016591 33.370742, ...))"
}
]