Open dfsnow opened 1 month ago
Added details: Single- and Multi-Unit Characteristics: the num_apartments column is useful. If it's "None" or NULL, let's assume that this property has 1 living unit (because it's probably a condo or single-family home, without any apartments). For other properties with multiple apartments, let's multiply appropriately. Do filter tax year = 2023
Condos: each row is one living unit, unless it's parking or nonlivable space. Do filter tax year = 2023
For commercial data: @wrridgeway might have a helpful data dictionary, but for now, the sum of apt
(instead of tot_units). For this one, note that you do not want to filter tax year = 2023
For the exploratory data, feel free to use excel.
here is the result I got, in the sheet 'final_output', in 'output.xlsx'; and the plan and process of calculation is in this google doc. You could click the links and open them. If anything wrong, please tell me and I will revise them later. And Dan suggests to turn this into a short how-to document. Could you provide me some examples of them? Thanks! @ccao-jardine
Thanks -- this is a good start! Some overall feedback:
This is a good start -- let's make it a little more accessible to someone, as if this was a blog post how-to guide. I've attached an example how-to. HowTo_Sales.pdf
Great start! I just want some QC, I think; this is the first time we've tried to use the data this way.
general:
I'm curious to see whether these numbers match up to other sources of housing counts, like the US Census. Can you find a few external counts of housing counts, and a description of their methods, so we might compare our totals?
I've requested edit access so I can make more specific feedback.
Here is the formatted draft for instruction file. Please tell me if you have any suggestions. :) @ccao-jardine @dfsnow instruction_housing_unit0807.pdf
The updated (considering apt, sum of unit columns and tot_units) instructions. The recommendation. The updated output table. Please tell me if you have any suggestion:) @dfsnow @ccao-jardine
Thanks, the instructions are looking very clear -- nice work! I've requested edit access to the google doc to make small wording revisions.
One thing we should dig into are the instructions for section 3. Large multi-unit properties. All steps say we should first filter the modelgroup
to "Multifamily." But one hypothesis is that there might be other kinds of housing units with different modelgroup
names. If so, this filter might be excluding some housing units in different model groups.
To test this hypothesis, I looked at sum(apt)
, sum(tot_units)
, and sum(2brunits)
grouped by modelgroup
, without filtering modelgroup
. (I chose 2brunits
at random from the studiounits, 1brunits, etc.) By doing this, I found a couple of types of multi-family housing with tot_units
> 0 that don't have modelgroup
= "Multifamily." Specifically:
modelgroup
names to consider! modelgroup names like "NursingHomes" and "T28-SpecialNursing" have tot_units
> 0. Nursing homes and skilled nursing facilities provide specialized housing to the aging population. But I'm actually not sure whether these are typically counted as "housing units" by others, such as the US census.modelgroup
"Affordable Housing" looks to generally not have apt or tot_unit, but can have studiounits
, 1brunits
, 2brunits
, etc. Affordable housing properties provide housing at a reduced cost...but again, I'm actually not sure whether these are typically counted as "housing units" by the US census! For completeness, I think we should show how to count these, but let users make a decision whether to include nursing homes and affordable housing. Let's do the following steps:
modelgroup
filter and then sum things appropriately. Please also add these as two more tabs to the google sheet. Data source | Nursing Homes counted as housing units? | Affordable Housing counted as housing units? | Sources |
---|---|---|---|
Census Bureau | no, doesn't count | not sure | http://... |
FRED | no, doesn't count | yes, this counts | http:// |
Thoughts?
I found housing units count data from Census Bureau, and the count in 2023 is 2,280,981, calculated by survey and sampling, which is higher than what we got.
I completed the tasks above, and the links are the same ones as the links in previous comment.
After reading through Census Bureau's AHS's survey instruction, I found they considered the nursing home and no sign of excluding the affordable houses. FRED used the data from Census Bureau. American Community Survey has no sign of excluding the two categories. For Statista, I need to pay to see the data source.
Please tell me if you have any suggestion! Thanks.
Great, thanks! I made some minor suggested text modifications in the google doc, such as some minor word/organization fixes, and adding links to the google sheet. When you have time, for each suggestion, please accept the suggestions, or revise them if I've introduced any errors. And definitely be sure to add authorship information to the top of the document too so that you receive appropriate credit.
Then that's a wrap on this issue!
Great, thanks! I made some minor suggested text modifications in the google doc, such as some minor word/organization fixes, and adding links to the google sheet. When you have time, for each suggestion, please accept the suggestions, or revise them if I've introduced any errors. And definitely be sure to add authorship information to the top of the document too so that you receive appropriate credit.
Then that's a wrap on this issue!
Thank you! I updated the files with your suggestions. Do I need to open the google sheet accessibility? I notice that you added the link in the instruction document.
Do I need to open the google sheet accessibility?
Oh, good catch 😅 Yes please!
Researchers often want to know the total number of housing units in Cook County in a specific tax year, according to the Assessor's Office.
Right now, that is technically at least partially answerable but the data are in multiple data sources. We need to think about number of cards on a res PIN, livable condo spaces, and large multi-unit properties.
The goal of this project is to get a count of the number of housing units in Cook County in tax year 2023 using open data, provide advice on making this data more accessible to the public, and perhaps creating a contribution to our reporting database that institutionalizes these housing counts.
Data sources that are publicly available (happy to discuss more)
is_parking_space
oris_common_area
is true, then that PIN isn't a housing unit.modelgroup
or theproperty_type/use
indicates some kind of multifamily property. Then, for those properties, we can count thetot_units
.Note that these are on Open Data. The portal allows you to filter and count.
Other things to look at
Suggested outputs