First Level goes to fips1a.php and uses statefips1.sqlite Statefips1.sqlite has 2 variables, FIPS and State. These variables were created using the website: https://transition.fcc.gov/oet/info/maps/census/fips/fips.txt Second Level goes to fips2a.php and uses fips2.sqlite and contains the variables: STATE, CFIPS, COUNTY, SFIPS, STATENAME These variables were created using the website: https://transition.fcc.gov/oet/info/maps/census/fips/fips.txt Use EXCEL to Add and Edit variables. These codes rarely change.

Goes to allzips1.php and uses three SQLite Databases; allzips2.sqlite which contains the variables ID (a sorting variable) STATE, STATENAME, MSANUMBER, COUNTYFIPS, COUNTY, STATEFIPS MSANAME, ZIPCODE and PLACE Data from: https://www.bls.gov/cew/classifications/areas/county-msa-csa-crosswalk.htm This data rarely changes. Use the CMSA from the Dexter file, slightly different. Merge with Dexter file (Missouri State Data Center). dexter1.sqlite which contains the variables STATE, ZIPCODE, COUNTY, POP2000, PORTION, RANK, FIPCO, STATE1 and COUNTYCODE Data from the Missouri State Data Center: https://mcdc.missouri.edu/cgi-bin/broker?_PROGRAM=utils.uex2dex.sas&path=/pub/data/corrlst&dset=us_stzcta5_county&view=0 This file changes frequently, sometimes every 3 months. zipcounty2.sqlite which contains the variables ZIP, COUNTY, STATE, RESPROP, STATEFIPS, COUNTYFIPS, COUNTYNAME, and STATENAME. The data is downloaded from: https://www.huduser.gov/apps/public/uspscrosswalk/login?previous=https://www.huduser.gov/apps/public/uspscrosswalk/home It's free to get an account. Remove the BUS_RATIO, OTH_RATIO, and TOT_RATIO variables. I use the RES_RATIO variable, but changed the name to RESPROP. I used fips2.sqlite data to make other variables. This file changes frequently, sometimes every 3 months.

Goes to fips2.php and uses fips2.sqlite. These variables were created using the website: https://transition.fcc.gov/oet/info/maps/census/fips/fips.txt These codes rarely change.

Goes to fips3.php and uses fips2.sqlite. These variables were created using the website: https://transition.fcc.gov/oet/info/maps/census/fips/fips.txt These codes rarely change.