This repository creates a wrapper for querying and cleaning data from Census APIs which are relevant to the supply chain. The available data sources are listed below. It is specifically created to migrate data into the Supply Chain Information Portal (SCIP) database.
Packages use are documented in sup_chain_env.yml. To create the conda environment, run conda env create -f sup_chain_env.yml.
Fill out api_endpoints.yml.
https://www.census.gov/data/developers/data-sets/Annual-Survey-of-Manufactures.html
https://www.census.gov/data/developers/data-sets/international-trade.html Requires a crosswalk which converts state abbreviations to their GEO_IDs in order to run the add_geo function. The path to the crosswalk should be saved in config.py in the variable STATE_GEOID_CROSSWALK. Current crosswalk was made manually by pulling GEOIDs and state names from econ census and then adding state abbreviations.
https://www.census.gov/data/developers/data-sets/economic-census.html
https://www.census.gov/data/developers/data-sets/cfs.html
https://www.census.gov/naics/?68967 Different survey years use different NAICS codes. We use these concordance files to harmonize all codes to 2022.