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
Boolean (true/false) 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 district's shape, represented in BigQuery's GEOGRAPHY data type.

Example entry

[
{
"year": "2021",
"is_latest_version": "true",
"place_fips": "1702531",
"place_name": "Ashley city",
"state_fips": "17",
"state_abbreviation": "IL",
"state_name": "Illinois",
"shape": "POLYGON((-89.200018 38.324692, -89.196929 38.324107, -89.196891 38.3241, -89.196781 38.32408, -89.196744 38.324074, -89.196626 38.324045, -89.196651 38.323502, -89.196176 38.323443, -89.194424 38.323225, -89.194384 38.323223, -89.194484 38.322657, -89.19451 38.322512, -89.194148 38.322444, -89.194223 38.322061, -89.19139 38.321702, -89.191292 38.321686, -89.191034 38.321654, -89.190964 38.321647, -89.190923 38.321847, -89.190884 38.322037, -89.190766 38.322608, -89.190761 38.322631, -89.190694 38.32262, -89.190613 38.322611, -89.18945 38.322472, -89.189241 38.322447, -89.188951 38.322412, -89.188558 38.322366, -89.188024 38.322302, -89.187307 38.322219, -89.187309 38.322066, -89.187312 38.321885, -89.187315 38.321736, -89.187316 38.321653, -89.187322 38.321329, -89.187335 38.3206, -89.187343 38.320255, -89.187345 38.320059, -89.187348 38.31988, -89.187351 38.31976, -89.18751 38.319763, -89.187765 38.319767, -89.1882 38.319775, -89.188487 38.319782, -89.18947 38.319797, -89.189473 38.319632, -89.189478 38.319324, -89.18949 38.318991, -89.189487 38.318781, -89.189511 38.316218, -89.189355 38.316217, -89.184649 38.316167, -89.182813 38.316144, -89.182805 38.316736, -89.182794 38.317685, -89.18278 38.318774, -89.182772 38.319454, -89.182771 38.319469, -89.182771 38.319515, -89.182771 38.319531, -89.182769 38.319714, -89.185054 38.319718, -89.185049 38.31989, -89.185037 38.320303, -89.185011 38.321224, -89.185005 38.321435, -89.18499 38.321957, -89.184326 38.321881, -89.183814 38.321821, -89.182744 38.321699, -89.182595 38.321681, -89.182337 38.321652, -89.182245 38.321641, -89.18204 38.321617, -89.181964 38.321943, -89.181915 38.32214, -89.18185 38.322427, -89.181699 38.32307, -89.181541 38.323539, -89.181502 38.323651, -89.181493 38.323707, -89.181436 38.32404, -89.181287 38.324909, -89.181048 38.326299, -89.180926 38.327013, -89.180762 38.327969, -89.180576 38.329049, -89.180542 38.329248, -89.180539 38.329266, -89.180536 38.329285, -89.180527 38.329335, -89.180109 38.32929, -89.178513 38.329114, -89.177876 38.329044, -89.177877 38.329081, -89.177877 38.329103, -89.177877 38.32917, -89.177878 38.329193, -89.177881 38.329482, -89.177891 38.33035, -89.177894 38.330595, -89.177893 38.33064, -89.177952 38.33064, -89.178772 38.330643, -89.180307 38.330649, -89.180294 38.330703, -89.18028 38.330803, -89.180198 38.331503, -89.179958 38.333557, -89.179902 38.334025, -89.179795 38.334937, -89.179741 38.335412, -89.179634 38.336312, -89.180872 38.336439, -89.186909 38.337059, -89.187949 38.337166, -89.18812 38.337183, -89.188226 38.337194, -89.190077 38.337384, -89.191684 38.337548, -89.191743 38.337554, -89.191755 38.337556, -89.191757 38.337667, -89.191757 38.3377, -89.191826 38.337708, -89.191942 38.337722, -89.192028 38.337732, -89.19209 38.337739, -89.192176 38.337751, -89.192397 38.337774, -89.192973 38.337841, -89.194131 38.33797, -89.198141 38.338438, -89.198458 38.335681, -89.198658 38.333963, -89.198735 38.333279, -89.198846 38.332319, -89.198849 38.332294, -89.198948 38.331429, -89.19915 38.329681, -89.199186 38.329456, -89.199346 38.328438, -89.199556 38.327106, -89.200018 38.324692))"
}
]