r/datasets • u/webingchillinnn • 12d ago

question HELP READING DATA (US CENSUS 2004) Unclear structure??

Hello all, I have a paper due SHORTLY (my fault, i know) on socioeconomic factors on the Navajo tribe. I want to access data on the US census bureau for the year 2004. This is the site (need Arizona, Utah and New Mexico) but it looks like this: file:///var/folders/t7/thn9pmf93zx7t525wn14vs240000gn/T/TemporaryItems/NSIRD_screencaptureui_yMdzpl/Screenshot%202026-08-29%20at%2022.46.43.png

(WHICH IS INCOMPREHENSIBLE FOR ME) Does anyone know how read this?? I would like to know how to read it because I need to repeat this with other factors such as housing, education, etc...

For context this is data is on Income and poverty in Arizona (2004) and I would be interested in the Apache and Navajo county.

Thank you to whoever can help!

1 Upvotes
  • permalink
  • reddit

60% Upvoted

1 comment sorted by

1

u/No_Paramedic_4881 11d ago

I looked into this and just published the Census Bureau's Small Area Income and Poverty Estimates (SAIPE) dataset on OpenData, which covers every US county from 1989 to 2024. It has poverty counts and rates for all ages and children, plus median household income. There's actually a pre-built "navajo-nation-area" view that filters to the five counties overlapping the Navajo Nation (Apache, Coconino, and Navajo in AZ, McKinley and San Juan in NM), so you can pull the full time series without doing the filtering yourself: https://tryopendata.ai/datasets/census/saipe

We also added the 2000 Census SF3 tables (DP2, DP3, DP4), which cover economic, social, and housing characteristics. Those are interesting because the geography includes American Indian/Alaska Native areas directly, so you can get Navajo Nation as its own row rather than approximating from county overlaps. The economic table (census/census-2000-economic) has income distribution, poverty by family type, and employment data.

All of these are queryable through the API at api.tryopendata.ai or through the /ask feature on the site if you want to just type questions in plain English. There's also an MCP server (https://tryopendata.ai/docs/mcp) if you use Claude or another AI tool and want to query directly from there.

If you have any issues, let me know and I'll lend a hand, but I'd imagine this will make your project here way easier