I’m looking to find out the distribution of the number of single-family homes by municipality. Are there census figures available that would have this information?
This website seems to have lots of data by city…
Thanks, but that site seems to deal with a city’s population and no the number of single-family homes. Also, I’m looking for the aggregate data so I could create a bell curve that shows how many homes there are in the largest number of municipalities.
Here’s the data directly from the US census. Type in the municipality, and you’ll get a brief overview of the data. Scroll to the bottom (“Housing Characteristics”) and click on “show more”. You’ll get a breakdown of housing units, into “1-unit, detached,” “1-unit, attached,” “2 units,” “3 or 4 units,” “5 to 9 units,” “10 to 19 units,” “20 or more units,” “Mobile home,” and “Boat, RV, van, etc.”
Looks like you can adjust your search to smaller or larger sections, using state, county, zip code, census tract number, city, etc. The data are (mostly, I think) from 2000, so it’s a little out of date. Hopefully sufficient for what you need.
There’s always the Census Bureau’s website but I assume you already checked that out.
That’s the data I’m looking for, but is it compiled anywhere? I can’t possibly go through each and every municipality and collect the data one-by-one. Ideally, I’d be able to simply generate a chart that looks like this, BellCurve.gif, and see where the numbers fell at every point of the graph.
Not asking for much, are we?
As it happens, you can get that from census.gov.
- Go to Factfinder at census.gov.
- Click on “Download Center” from the list on the left.
- Choose the data set “Census 2000 Summary File 3 (SF 3) - Sample Data” (third one down)
- Select the Geographic Level you want (I think you want “All Places” under “National Level”–fourth one down–but here’s where you’ll have to experiment. “All Places” is approximately 25,000 basic geographic units.)
- Click “Go”
- You should see a pick list of tables in a scroll box. The one you want is about halfway down: “H30: Units in Structure”. Click on it and click “Add”
- You may also want one of the tables around H30: H31 or H32 or H33, which deal with vacant housing, tenure, and total population. If you do, add those, too. Heck, add whatever you want. The final download will be an aggregate file of all the data. (I downloaded H30 and H33; the file was 1.5meg)
- Click “Next.” You’ll be directed to a Download page. Click “Start Download” to get the data.
- The data are downloaded in a zip file containing three .txt files. You want the one that says “data1”.
- You can, if you wish, open the file with Excel. The data are pipe delimited, so indicate that in the appropriate box when opening.’
And voila! Sort and graph to your heart’s content.
Wow! Wow! Wow! Thank you so much.
What’s the difference between “Housing units: 1; detached units in structure” and “Housing units: 1; attached units in structure”
I assume the “attached units” are townhouses/brownstones, while the “detatched units” are homes with actual space in between them. I’m not positive about this, but look at the large number of “attached units” in Philadelphia and NYC, where brownstones are popular.
That makes sense. Thank you again. You were enormously helpful.