🗺️ geo

U.S. government geographic data including Census TIGER boundaries, HUD USPS ZIP code crosswalks, and demographic statistics. Enables spatial analysis, geographic aggregation, and crosswalk between ZIP codes, counties, census tracts, congressional districts, and metropolitan areas.

36 datasets · 216 columns

states · table

U.S. state boundaries and attributes from TIGER/Line shapefiles. Includes state FIPS codes, names, areas, and geographic boundaries. Updated annually with official Census Bureau boundaries.

Column	Type	Null	Description
state_fips	string	no	2-digit FIPS code identifying the state (e.g., '06' for California)
state_code	string	no	Geographic identifier (GEOID) for the state, matches state_fips
state_name	string	no	Full state name (e.g., 'California')
state_abbr	string	no	2-letter postal abbreviation (e.g., 'CA')
land_area	double	yes	Land area in square meters
water_area	double	yes	Water area in square meters
geometry	string	yes	WKT representation of boundary polygon

state_ref · table

Conformed US state-identity reference dimension: 50 states + DC with FIPS code, 2-letter postal abbreviation, and full name. Static and non-vintaged — this is the canonical foreign-key target for state_abbr and state_fips across all govdata schemas (geo.states is a year-partitioned boundary snapshot and cannot be an FK target). Join here to attach state names/codes to any table carrying a state abbreviation or FIPS code.

Column	Type	Null	Description
state_fips	string	no	2-digit state FIPS code, zero-padded (e.g., '06' for California)
state_abbr	string	no	2-letter USPS state abbreviation (e.g., 'CA')
state_name	string	no	Full state name (e.g., 'California')

census_regions · table

US Census Bureau statistical regions: 4 rows (Northeast, Midwest, South, West). Canonical FK target for a Census region_code (integer 1-4). Static and non-vintaged.

Column	Type	Null	Description
region_code	integer	no	Census region code (1=Northeast, 2=Midwest, 3=South, 4=West)
region_name	string	no	Census region name

census_divisions · table

US Census Bureau statistical divisions: 9 rows (New England, Middle Atlantic, East/West North Central, South Atlantic, East/West South Central, Mountain, Pacific), each carrying its parent region. Canonical FK target for a Census division_code (integer 1-9). Static and non-vintaged.

Column	Type	Null	Description
division_code	integer	no	Census division code (1-9)
division_name	string	no	Census division name
region_code	integer	no	Parent Census region code (FK to census_regions)
region_name	string	no	Parent Census region name (denormalized for convenience)

zcta_ref · table

Conformed ZIP Code Tabulation Area reference dimension: one row per 5-digit ZCTA (2020 census vintage) with land/water area and internal-point centroid. Static and non-vintaged — the canonical foreign-key target for zip_code / ZCTA across all govdata schemas (geo.zctas is a year-partitioned boundary snapshot and cannot be an FK target).

Column	Type	Null	Description
zcta	string	no	5-digit ZIP Code Tabulation Area code
land_area_sqmi	double	yes	Land area (square miles)
water_area_sqmi	double	yes	Water area (square miles)
latitude	double	yes	Internal-point latitude (centroid)
longitude	double	yes	Internal-point longitude (centroid)

counties · table

U.S. county boundaries and attributes including FIPS codes, names, metropolitan statistical areas, and geographic boundaries. Contains all 3,000+ counties and county equivalents.

Column	Type	Null	Description
county_fips	string	no	5-digit FIPS code for county (state + county, e.g., '06037' for Los Angeles County)
state_fips	string	no	2-digit FIPS code identifying the state (e.g., '06' for California)
county_name	string	no	Full county name (e.g., 'Los Angeles County')
county_code	string	no	Geographic identifier (GEOID) for the county
land_area	double	yes	Land area in square meters
water_area	double	yes	Water area in square meters
geometry	string	yes	WKT representation of boundary polygon

places · table

Census designated places including cities, towns, and villages. Contains place boundaries, population classifications, and geographic identifiers for incorporated and census-designated places.

Column	Type	Null	Description
place_fips	string	no	7-digit FIPS code for place (state + place code)
state_fips	string	no	2-digit FIPS code identifying the state (e.g., '06' for California)
place_name	string	no	Name of incorporated place or census-designated place
place_type	string	yes	Classification of place (e.g., 'city', 'town', 'CDP')
geometry	string	yes	WKT representation of boundary polygon

zctas · table

ZIP Code Tabulation Areas (ZCTAs) approximating USPS ZIP Code delivery areas. Includes ZCTA boundaries and relationships to other geographic entities.

Column	Type	Null	Description
zcta	string	no	5-digit ZIP Code Tabulation Area code
land_area	double	yes	Land area in square meters
water_area	double	yes	Water area in square meters
geometry	string	yes	WKT representation of boundary polygon

census_tracts · table

Census tract boundaries - small statistical subdivisions of counties averaging 4,000 inhabitants. Key geography for demographic analysis and census data reporting.

Column	Type	Null	Description
tract_fips	string	no	11-digit FIPS code for census tract (state + county + tract)
state_fips	string	no	2-digit FIPS code identifying the state (e.g., '06' for California)
county_fips	string	no	5-digit FIPS code for county (state + county, e.g., '06037' for Los Angeles County)
tract_name	string	yes	Census tract number (e.g., '4201.02')
land_area	double	yes	Land area in square meters
water_area	double	yes	Water area in square meters
geometry	string	yes	WKT representation of boundary polygon

block_groups · table

Census block groups - statistical divisions of census tracts, generally containing 600-3,000 people. Smallest geography for which census sample data is published.

Column	Type	Null	Description
block_group_fips	string	no	12-digit FIPS code for block group (state + county + tract + block group)
state_fips	string	no	2-digit FIPS code identifying the state (e.g., '06' for California)
county_fips	string	no	5-digit FIPS code for county (state + county, e.g., '06037' for Los Angeles County)
tract_fips	string	no	11-digit FIPS code of the parent census tract
land_area	double	yes	Land area in square meters
water_area	double	yes	Water area in square meters
geometry	string	yes	WKT representation of boundary polygon

cbsa · table

Core Based Statistical Areas including Metropolitan and Micropolitan Statistical Areas. Defines urban cores and surrounding counties with social and economic ties.

Column	Type	Null	Description
cbsa_fips	string	no	5-digit CBSA code for Core Based Statistical Area
cbsa_name	string	no	Name of metropolitan or micropolitan statistical area
metro_micro	string	yes	LSAD code indicating Metropolitan or Micropolitan designation
land_area	double	yes	Land area in square meters
water_area	double	yes	Water area in square meters
geometry	string	yes	WKT representation of boundary polygon

congressional_districts · table

U.S. Congressional district boundaries for the House of Representatives. Updated after each decennial census reapportionment and subsequent redistricting.

Column	Type	Null	Description
cd_fips	string	no	4-digit congressional district code (state + district number)
state_fips	string	no	2-digit FIPS code identifying the state (e.g., '06' for California)
cd_name	string	yes	Congressional district name or number
land_area	double	yes	Land area in square meters
water_area	double	yes	Water area in square meters
geometry	string	yes	WKT representation of boundary polygon

school_districts · table

Elementary, secondary, and unified school district boundaries. Includes district codes, names, and relationships to other geographic entities.

Column	Type	Null	Description
sd_lea	string	no	Local Education Agency (LEA) code identifying the school district
state_fips	string	no	2-digit FIPS code identifying the state (e.g., '06' for California)
sd_name	string	yes	School district name
sd_type	string	yes	School district type (elementary, secondary, or unified)
land_area	double	yes	Land area in square meters
water_area	double	yes	Water area in square meters
geometry	string	yes	WKT representation of boundary polygon

state_legislative_lower · table

State legislative district boundaries for lower chambers (State House/Assembly). Used for political analysis and representation mapping.

Column	Type	Null	Description
sldl_fips	string	no	State legislative district lower chamber code (state + district)
state_fips	string	no	2-digit FIPS code identifying the state (e.g., '06' for California)
district_name	string	yes	District name or number
land_area	double	yes	Land area in square meters
water_area	double	yes	Water area in square meters
geometry	string	yes	WKT representation of boundary polygon

state_legislative_upper · table

State legislative district boundaries for upper chambers (State Senate). Used for political analysis and representation mapping.

Column	Type	Null	Description
sldu_fips	string	no	State legislative district upper chamber code (state + district)
state_fips	string	no	2-digit FIPS code identifying the state (e.g., '06' for California)
district_name	string	yes	District name or number
land_area	double	yes	Land area in square meters
water_area	double	yes	Water area in square meters
geometry	string	yes	WKT representation of boundary polygon

county_subdivisions · table

County subdivisions including Minor Civil Divisions (MCDs), census county divisions, and unorganized territories. Represents administrative or statistical subdivisions of counties.

Column	Type	Null	Description
cousub_fips	string	no	County subdivision FIPS code (state + county + subdivision)
state_fips	string	no	2-digit FIPS code identifying the state (e.g., '06' for California)
county_fips	string	no	5-digit FIPS code for county (state + county, e.g., '06037' for Los Angeles County)
cousub_name	string	yes	County subdivision name
cousub_type	string	yes	Legal/statistical area description code
land_area	double	yes	Land area in square meters
water_area	double	yes	Water area in square meters
geometry	string	yes	WKT representation of boundary polygon

tribal_areas · table

American Indian reservations, Alaska Native villages, and Native Hawaiian home lands. Includes federal and state recognized tribal boundaries and trust lands.

Column	Type	Null	Description
aiannhce	string	no	American Indian/Alaska Native/Native Hawaiian area code
name	string	yes	Area name
namelsad	string	yes	Name and legal/statistical area description
area_type	string	yes	Area type (federal reservation, state reservation, TDSA, etc.)
land_area	double	yes	Land area in square meters
water_area	double	yes	Water area in square meters
geometry	string	yes	WKT representation of boundary polygon

urban_areas · table

Census Bureau urban area boundaries. For 2020 Census, minimum threshold is 5,000 people or 2,000 housing units. The distinction between Urbanized Areas and Urban Clusters was eliminated - all qualifying areas are now simply 'urban areas'.

Column	Type	Null	Description
uace	string	no	Urban area code
name	string	yes	Urban area name
urban_type	string	yes	Urban type code (legacy field from pre-2020 Census, may be blank for 2020+ data)
land_area	double	yes	Land area in square meters
water_area	double	yes	Water area in square meters
geometry	string	yes	WKT representation of boundary polygon

pumas · table

Public Use Microdata Areas for Census microdata products. Each PUMA contains at least 100,000 people and is built from census tracts and counties.

Column	Type	Null	Description
puma_code	string	no	5-digit PUMA code (unique within state)
state_fips	string	no	2-digit FIPS code identifying the state (e.g., '06' for California)
puma_name	string	yes	PUMA name
land_area	double	yes	Land area in square meters
water_area	double	yes	Water area in square meters
geometry	string	yes	WKT representation of boundary polygon

voting_districts · table

Voting district boundaries (precincts, wards, election districts) as reported by states for redistricting. Available for 2012 (2010 census vintage) and 2020 (2020 census vintage). Attributes are normalized to canonical form.

Column	Type	Null	Description
vtd_code	string	no	Voting district code (state + county + VTD)
state_fips	string	no	2-digit FIPS code identifying the state (e.g., '06' for California)
county_fips	string	no	5-digit FIPS code for county (state + county, e.g., '06037' for Los Angeles County)
vtd_name	string	yes	Voting district name
land_area	double	yes	Land area in square meters
water_area	double	yes	Water area in square meters
geometry	string	yes	WKT representation of boundary polygon

zip_county_crosswalk · table

ZIP Code to County crosswalk file mapping ZIP codes to counties with residential and business address ratios. Source: HUD USPS ZIP Code Crosswalk.

Column	Type	Null	Description
zip	string	no	5-digit ZIP Code
county_fips	string	no	5-digit FIPS code for county (state + county, e.g., '06037' for Los Angeles County)
res_ratio	double	yes	Ratio of residential addresses in this ZIP that are in this county
bus_ratio	double	yes	Ratio of business addresses in this ZIP that are in this county
oth_ratio	double	yes	Ratio of other addresses in this ZIP that are in this county
tot_ratio	double	yes	Ratio of total addresses in this ZIP that are in this county

zip_cbsa_crosswalk · table

ZIP Code to Core Based Statistical Area crosswalk mapping ZIP codes to metropolitan and micropolitan areas.

Column	Type	Null	Description
zip	string	no	5-digit ZIP Code
cbsa_code	string	no	5-digit CBSA code for Core Based Statistical Area
res_ratio	double	yes	Ratio of residential addresses in this ZIP that are in this CBSA
bus_ratio	double	yes	Ratio of business addresses in this ZIP that are in this CBSA
oth_ratio	double	yes	Ratio of other addresses in this ZIP that are in this CBSA
tot_ratio	double	yes	Ratio of total addresses in this ZIP that are in this CBSA

tract_zip_crosswalk · table

Census tract to ZIP Code crosswalk for relating census geography to postal geography. Includes residential and business address ratios.

Column	Type	Null	Description
tract_fips	string	no	11-digit census tract FIPS code
zip	string	no	5-digit ZIP Code
res_ratio	double	yes	Ratio of residential addresses in this tract that are in this ZIP
bus_ratio	double	yes	Ratio of business addresses in this tract that are in this ZIP
oth_ratio	double	yes	Ratio of other addresses in this tract that are in this ZIP
tot_ratio	double	yes	Ratio of total addresses in this tract that are in this ZIP

zip_tract_crosswalk · table

ZIP Code to Census Tract crosswalk mapping ZIP codes to census tracts with residential and business address ratios. Source: HUD USPS ZIP Code Crosswalk.

Column	Type	Null	Description
zip	string	no	5-digit ZIP Code
tract_fips	string	no	11-digit census tract FIPS code
state_fips	string	no	2-digit FIPS code identifying the state (e.g., '06' for California)
res_ratio	double	yes	Ratio of residential addresses in this ZIP that are in this tract
bus_ratio	double	yes	Ratio of business addresses in this ZIP that are in this tract
oth_ratio	double	yes	Ratio of other addresses in this ZIP that are in this tract
tot_ratio	double	yes	Ratio of total addresses in this ZIP that are in this tract

zip_cd_crosswalk · table

ZIP Code to Congressional District crosswalk mapping ZIP codes to congressional districts with address ratios. Source: HUD USPS ZIP Code Crosswalk.

Column	Type	Null	Description
zip	string	no	5-digit ZIP Code
cd_fips	string	no	Congressional district code (state + district number)
res_ratio	double	yes	Ratio of residential addresses in this ZIP that are in this CD
bus_ratio	double	yes	Ratio of business addresses in this ZIP that are in this CD
oth_ratio	double	yes	Ratio of other addresses in this ZIP that are in this CD
tot_ratio	double	yes	Ratio of total addresses in this ZIP that are in this CD

county_zip_crosswalk · table

County to ZIP Code crosswalk for allocating county-level data to ZIP codes. Reverse mapping of zip_county_crosswalk. Source: HUD USPS ZIP Code Crosswalk.

Column	Type	Null	Description
county_fips	string	no	5-digit FIPS code for county (state + county, e.g., '06037' for Los Angeles County)
zip	string	no	5-digit ZIP Code
res_ratio	double	yes	Ratio of residential addresses in this county that are in this ZIP
bus_ratio	double	yes	Ratio of business addresses in this county that are in this ZIP
oth_ratio	double	yes	Ratio of other addresses in this county that are in this ZIP
tot_ratio	double	yes	Ratio of total addresses in this county that are in this ZIP

cd_zip_crosswalk · table

Congressional District to ZIP Code crosswalk for allocating district-level data to ZIP codes. Reverse mapping of zip_cd_crosswalk. Source: HUD USPS Crosswalk.

Column	Type	Null	Description
cd_fips	string	no	Congressional district code (state + district number)
zip	string	no	5-digit ZIP Code
res_ratio	double	yes	Ratio of residential addresses in this CD that are in this ZIP
bus_ratio	double	yes	Ratio of business addresses in this CD that are in this ZIP
oth_ratio	double	yes	Ratio of other addresses in this CD that are in this ZIP
tot_ratio	double	yes	Ratio of total addresses in this CD that are in this ZIP

rural_urban_continuum · table

USDA Economic Research Service Rural-Urban Continuum Codes classifying counties by degree of urbanization and adjacency to metro areas. 9-category classification updated decennially.

Column	Type	Null	Description
county_fips	string	no	5-digit FIPS code for county (state + county, e.g., '06037' for Los Angeles County)
state_fips	string	no	2-digit FIPS code identifying the state (e.g., '06' for California)
county_name	string	yes	County name
rucc_code	int	no	Rural-Urban Continuum Code (1-9)
rucc_description	string	yes	Description of the RUCC category
population	int	yes	County population from Census
metro_nonmetro	string	yes	Metro (1-3) or Nonmetro (4-9) designation

ruca_codes · table

USDA Rural-Urban Commuting Area codes at census tract level. More granular than county-level RUCC, based on population density and commuting patterns. Primary codes (1-10) with secondary subdivision codes.

Column	Type	Null	Description
tract_fips_20	string	yes	11-digit census tract FIPS code (2020)
state_fips_20	string	yes	2-digit state FIPS code
county_fips_20	string	yes	5-digit county FIPS code (state + county)
primary_ruca	int	yes	Primary RUCA code (1-10)
secondary_ruca	double	yes	Secondary RUCA code for subdivision
primary_ruca_description	string	yes	Description of the primary RUCA category
population	int	yes	Tract population from Census

gazetteer_counties · table

Census Bureau Gazetteer file for counties with authoritative names, codes, area measurements, and representative coordinates. Official reference for county identifiers and centroids.

Column	Type	Null	Description
county_fips	string	no	5-digit FIPS code for county (state + county, e.g., '06037' for Los Angeles County)
state_fips	string	no	2-digit FIPS code identifying the state (e.g., '06' for California)
county_name	string	no	Official county name
land_area_sqmi	double	yes	Land area in square miles
water_area_sqmi	double	yes	Water area in square miles
latitude	double	yes	Internal point latitude (centroid)
longitude	double	yes	Internal point longitude (centroid)

gazetteer_places · table

Census Bureau Gazetteer file for incorporated places and CDPs with authoritative names, codes, area measurements, and representative coordinates.

Column	Type	Null	Description
place_fips	string	no	Place FIPS code (state + place)
state_fips	string	no	2-digit FIPS code identifying the state (e.g., '06' for California)
place_name	string	no	Official place name
place_type	string	yes	Place type (city, town, CDP, etc.)
land_area_sqmi	double	yes	Land area in square miles
water_area_sqmi	double	yes	Water area in square miles
latitude	double	yes	Internal point latitude (centroid)
longitude	double	yes	Internal point longitude (centroid)
population	int	yes	Population estimate
housing_units	int	yes	Housing unit count

gazetteer_zctas · table

Census Bureau Gazetteer file for ZIP Code Tabulation Areas with area measurements and representative coordinates.

Column	Type	Null	Description
zcta	string	no	5-digit ZCTA code
land_area_sqmi	double	yes	Land area in square miles
water_area_sqmi	double	yes	Water area in square miles
latitude	double	yes	Internal point latitude (centroid)
longitude	double	yes	Internal point longitude (centroid)
population	int	yes	Population estimate
housing_units	int	yes	Housing unit count

watersheds_huc2 · table

USGS Watershed Boundary Dataset HUC2 regions - the largest hydrologic units dividing the country into 22 major drainage basins.

Column	Type	Null	Description
huc2	string	no	2-digit Hydrologic Unit Code
name	string	yes	Watershed region name
area_sq_km	double	yes	Total area in square kilometers
geometry	string	yes	WKT representation of boundary polygon

watersheds_huc4 · table

USGS Watershed Boundary Dataset HUC4 subregions - subdivisions of HUC2 regions into approximately 223 subregions.

Column	Type	Null	Description
huc4	string	no	4-digit Hydrologic Unit Code
huc2	string	no	Parent HUC2 region code
name	string	yes	Watershed subregion name
area_sq_km	double	yes	Total area in square kilometers
geometry	string	yes	WKT representation of boundary polygon

watersheds_huc8 · table

USGS Watershed Boundary Dataset HUC8 subbasins - commonly used watershed level for water quality and resource management with ~2,300 units.

Column	Type	Null	Description
huc8	string	no	8-digit Hydrologic Unit Code
huc4	string	no	Parent HUC4 subregion code
name	string	yes	Watershed subbasin name
area_sq_km	double	yes	Total area in square kilometers
geometry	string	yes	WKT representation of boundary polygon

watersheds_huc12 · table

USGS Watershed Boundary Dataset HUC12 subwatersheds - the smallest standard hydrologic units with approximately 100,000 units nationally.

Column	Type	Null	Description
huc12	string	no	12-digit Hydrologic Unit Code
huc8	string	no	Parent HUC8 subbasin code
name	string	yes	Subwatershed name
area_sq_km	double	yes	Total area in square kilometers
geometry	string	yes	WKT representation of boundary polygon