Thursday, August 19, 2021

UPDATE2 : Census 2020 Housing Units, Occupied Units, and Vacant Unit Counts: FOR Oregon to the Block Group Level.

UPDATE 2: 

At the request of IPUMS NHGIS staff I have deleted the national Census 2020 housing data from my Excel workbook. Staff explained that users need to obtain their National data directly from from their website so they can track the usage of that data. IPUMS NHGIS put in the work and have the expertise to put together this data (long before Census bureau will make it available) so I’m happy to comply with their request and have apologized for my misstep. All of the extracted data for Oregon remains in the workbook. Here's a link to the terms and conditions for use of their data. 

Note: There are still 15 worksheets in the workbook and file size is substantially reduced to only 3 MB so the Oregon focused workbook is easier for users to open, navigate and add pivot table worksheets.  

---

UPDATE: I added worksheets with school district housing unit counts for unified districts and districts that break out data for secondary and elementary schools (some definitional information is here). This adds a total of six worksheets to the file, 3 for Oregon and 3 for the US. 

----

Thanks to NHGIS IPUMS (IPUMS NHGIS, University of Minnesota, www.nhgis.org) Census 2020 counts of housing units, occupied units, and vacant units are available down to the block group level. 

I created a 70 3 MB Excel workbook HERE that has that data for multiple OREGON geographies all the way to the block group level (240,000+ block groups nationally). 

I created separate worksheets for Oregon (tabs are green) and also included the source worksheets at the national level--22 28 ,15 worksheets in all. These geographic levels are included:

  • State
  • Congressional district
  • CBSA
  • CSA
  • County
  • State legislative districts, both upper and lower
  • Places
  • School districts (ADDED August 20)
  • Census tracts
  • Census block groups 

Each worksheet include about 100 fields of data with the housing counts at the end of the data fields. (I have listed a sample in the READ me worksheet). 

Note that these are total housing counts, with no breakouts yet for owners and renters. Housing tenure data is not anticipated to arrive until 2022. 

Originally created and posted on the Oregon Housing Blog.

No comments:

Post a Comment