3 ms·

This PDF is what the map is based on and has some additional data: http://nlihc.org/sites/default/files/oor/2014OOR.pdf http://nlihc.org/sites/default/files/oor

by dm2 13y ago

This PDF is what the map is based on and has some additional data: http://nlihc.org/sites/default/files/oor/2014OOR.pdf http://nlihc.org/sites/default/files/oor/2014OOR.pdf Also: http://nlihc.org/oor/2014 http://nlihc.org/oor/2014

saraid216 13y ago
While that is good to have, a glance through the PDF actually says this data is different. Namely, the PDF indicates 2-bedroom whereas the WaPo article indicates 1-bedroom. I should probably do a number-comparison on a per-county basis to see if the WaPo writers simply made a mistake, but I'm feeling pretty lazy.
- dm2 13y ago
  They probably just downloaded the states individually (http://nlihc.org/oor/2014/NY http://nlihc.org/oor/2014/NY) to get the 1 bedroom numbers.
  - saraid216 13y ago
    And to clarify, you have to pull the XLS in order to get the 1BDR numbers. The PDF is still just 2BDR. But yes. dm2 is correct. This is probably the link that should have been shared to start: http://nlihc.org/oor/2014 http://nlihc.org/oor/2014
- wdmeldon 13y ago
  I avergaged the 1-bedroom numbers for all of the counties in Rhode Island (guess why I picked Rhode Island) and got ~$15.00, which is ~$3.00 less than the 2-bedroom on the PDF. So they probably calculated it correctly. Two bedrooms are always surprisingly close in price to one bedrooms.
adolph 13y ago
Here is the Washington Post's datasource: http://www.washingtonpost.com/wp-srv/special/national/county-rental-wages/data/rentals.csv http://www.washingtonpost.com/wp-srv/special/national/county...
- dm2 13y ago
  That's the data used to generate the map, I was linking to where they got those numbers from.
plorg 13y ago
County-level data is available on a per-state basis from the NLIHC website. I went and downloaded all of the state data spreadsheets and merged them into one big spreadsheet. It took maybe 20 lines of python. Here it is, for anyone interested: https://www.dropbox.com/s/40bg2um044vy82f/2014-OOR-ALL.xls https://www.dropbox.com/s/40bg2um044vy82f/2014-OOR-ALL.xls

by dm2 13y ago

saraid216 13y ago

While that is good to have, a glance through the PDF actually says this data is different. Namely, the PDF indicates 2-bedroom whereas the WaPo article indicates 1-bedroom. I should probably do a number-comparison on a per-county basis to see if the WaPo writers simply made a mistake, but I'm feeling pretty lazy.

dm2 13y ago
They probably just downloaded the states individually (http://nlihc.org/oor/2014/NY http://nlihc.org/oor/2014/NY) to get the 1 bedroom numbers.
- saraid216 13y ago
  And to clarify, you have to pull the XLS in order to get the 1BDR numbers. The PDF is still just 2BDR. But yes. dm2 is correct. This is probably the link that should have been shared to start: http://nlihc.org/oor/2014 http://nlihc.org/oor/2014
wdmeldon 13y ago
I avergaged the 1-bedroom numbers for all of the counties in Rhode Island (guess why I picked Rhode Island) and got ~$15.00, which is ~$3.00 less than the 2-bedroom on the PDF. So they probably calculated it correctly. Two bedrooms are always surprisingly close in price to one bedrooms.

adolph 13y ago

Here is the Washington Post's datasource: http://www.washingtonpost.com/wp-srv/special/national/county-rental-wages/data/rentals.csv http://www.washingtonpost.com/wp-srv/special/national/county...

dm2 13y ago
That's the data used to generate the map, I was linking to where they got those numbers from.

plorg 13y ago

County-level data is available on a per-state basis from the NLIHC website. I went and downloaded all of the state data spreadsheets and merged them into one big spreadsheet. It took maybe 20 lines of python. Here it is, for anyone interested: https://www.dropbox.com/s/40bg2um044vy82f/2014-OOR-ALL.xls https://www.dropbox.com/s/40bg2um044vy82f/2014-OOR-ALL.xls