maptimeLA / food_bank_data_bank

🍱 Food Bank Data Bank
http://jrhutson.github.io/Food-Resource-Map/
10 stars 8 forks source link

Census Bureau SIPP Data. #15

Open JRHutson opened 8 years ago

JRHutson commented 8 years ago

Census Survey of Income and Program Participation. http://thedataweb.rm.census.gov/ftp/sipp_ftp.html

Lots of datasets here and not a lot of info on what each of them contains. See if Andy or someone else at the Food Bank can give us guidance on what is relevant.

lafoodbank commented 8 years ago

I cannot for the life of me figure out how to open a *.DAT file extension. With any native program it just appears as random digits. I might recommend looking at http://healthpolicy.ucla.edu/chis/data/Pages/public-use-data.aspx for program participation data from the AskCHIS NE portal, but of course the website is on 404 this evening. I'll try again tomorrow

JRHutson commented 8 years ago

@lafoodbank I was able to find income information along with some data on households receiving SNAP Benefits through the American Community Survey dataset. The data is in a format that only excel will open currently. Going to convert to CSV and upload. I'll share the excel only files with you through dropbox. Take a look before you spend more time searching.

johnhickok commented 8 years ago

Dat files tend to be generic. Tried Notepad++? On Aug 31, 2015 10:51 PM, "lafoodbank" notifications@github.com wrote:

I cannot for the life of me figure out how to open a *.DAT file extension. With any native program it just appears as random digits. I might recommend looking at http://healthpolicy.ucla.edu/chis/data/Pages/public-use-data.aspx for program participation data from the AskCHIS NE portal, but of course the website is on 404 this evening. I'll try again tomorrow

— Reply to this email directly or view it on GitHub https://github.com/maptimeLA/food_bank_data_bank/issues/15#issuecomment-136593201 .

JRHutson commented 8 years ago

Looking back at the available datasets, the most recent is from 2008. I think the American Community Survey is going to be a better source for data on program participation. I've been able to find data on SNAP and other benefits received.