Get ACS rents data - Githubissues

santiagohermo commented 3 weeks ago

It exists @diegogentilepassaro @gabrieleborg ! Very exciting.

I asked for Census help and I got this response

Hi Santiago, Thank you for reaching out to the U.S. Census Bureau, and I apologize for the delayed response. The best we can offer are the tables below. Lower is the 25th percentile and upper is the 75th percentile. I've also filtered to all ZCTAs in the U.S., hence why it says it's too big to display, but they can download. There will be ZCTAs without estimates, as I'm sure many hit the various filtering rules for display.

B25057: Lower Contract Rent ... - Census Bureau Tables B25058: Median Contract ... - Census Bureau Tables B25059: Upper Contract Rent ... - Census Bureau Tables

If you want to go the extra mile to get a mean, you would have to use table B25060 and B25056. You would divide the aggregate amount found in B25060 by the "Wish cash rent" estimate total.

I hope this helps. Let me know if there is anything else I can do to help. Thanks, Ryan

I'll add the data to our repository in this issue. We need to discuss how to clean it up and add it to the pipeline.

santiagohermo commented 3 weeks ago

The data seems to be at the ZCTA level @diegogentilepassaro. We will need to construct our MW measures at this level as well.

santiagohermo commented 3 weeks ago

Data are available in GDrive/raw_data/acs_rents/

gabrieleborg commented 3 weeks ago

Hey guys! this is great! @santiagohermo let us know if you want to meet sometime to discuss what we need to do :)

santiagohermo commented 2 weeks ago

Thanks @gabrieleborg! I agree, time to discuss. I'll be in touch :)

santiagohermo commented 2 weeks ago

We already got the following data at the ZCTA level:

Number of households renting per year and total rents (can compute average)
p25, median, p75 of rents distribution
rent expenses as percentage of household income

Check if we can find other variables in ACS:

Population in each year
Number of housing units
Number of sampled households or something like that
Income (median household income exists. Mean and total income?)
Binned income, number of low-income workers, poverty

santiagohermo commented 2 weeks ago

Can you help me explore these data @gabrieleborg? We need to go to the census website linked in the opening comment and explore whether we can find the variables I mention in https://github.com/diegogentilepassaro/min_wage_rent/issues/275#issuecomment-2191782612

gabrieleborg commented 1 week ago

hey @santiagohermo , sounds good - will work on it next week.

diegogentilepassaro / min_wage_rent

Get ACS rents data #275