Download Census Data

Downloading Census Data for PUMA (Names) The data can be found on the census site itself:

https://www.census.gov/programs-surveys/geography/guidance/geo-areas/pumas.html?utm_source=chatgpt.com

1. Scroll down until you see: 2020 PUMA Names File [<1.0 MB]
2. Download the file
3. Because the file is in acrobat, use Google Docs to open it.
4. Then copy and paste into a file using VI
5. Use the following commands to format the data for uploading.

NOTE: Use the Chrome browser

1. Go to: https://usa.ipums.org/usa/
2. Create an account if you don’t already have one.
3. After creating an account and signing in, click “Create Your Custom Data Set
4. CLick “Submit Sample Size”
5. Add Variables:
   1. Household → Geographic → PUMA & STATEFIP
   2. Person → Demographic → Age
   3. Person → Race, Ethnicity, Nativity → SPEAKENG & LANGUAGE
6. View Data Cart → Create Data Extract
   1. 
7. Change Data Format to “.csv”
8. Click Show and you should see the following:
9. Click “Submit Extract”

NOTE: When the job is finished, you will receive and email. You can then download the “.gz” file and load as required.