UM Geospatial Digital Special Collections

Citation: United States Census Bureau (2022). 2020 Census County FIPS Codes [gis dataset]. U.S. Census Bureau. https://www.census.gov/library/reference/code-lists.html. last updated: 2024-05-01 (update frequency: Never). Abstract: FIPS codes are numbers which uniquely identify geographic areas. The number of digits in FIPS codes vary depending on the level of geography. State-level FIPS codes have two digits, county-level FIPS codes have five digits of which the first two are the FIPS code of the state to which the county belongs. When using the list below to look up county FIPS codes, it is advisable to first look up the FIPS code for the state to which the county belongs. This will help you identify the right section of the list while scrolling down, which can be important since there are over 3000 counties and county-equivalents (e.g. independent cities, parishes, boroughs) in the United States. Key words: Census, 2020, County, FIPS Open Geospatial Consortium Standards: vector tiles | WMS (coming soon) | WFS (coming soon) ETL documentation

ETL for us_2020_census_county_fips

######### # GDSC ETL is performed in two steps: shell script to ETL data into postgres # and then additional transformations with SQL in postGIS (if needed). #### ######### # Step 1 - bash script (pseudo code) #### # create directory structure and move into it mkdir -p /data/us_2020_census_county_fips/{download,etl} && cd /data/us_2020_census_county_fips # set update flag based on last update and update frequency do_update=0 if date() < last_update + update_frequency else do_update = 1 # Download and etl as needed if [[ $do_update = 1 ]]; then curl -o download/us_2020_census_county_fips.json "https://api.census.gov/data/2020/dec/dp?get=NAME&for=county:*"; fi awk '{gsub(/\[|\]|.$/,""); print;}' download/us_2020_census_county_fips.json | sed 's/, /\",\"/g' | sed 's/\"NAME\"/\"county_name\",\"state_name\"/g' | ogr2ogr -f PostgreSQL PG:"" csv:/vsistdin/ -nln us_2020_census_county_fips