Housing Data Tracking

	B	E	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AJ
1
2	Want to say thanks? Help support my coffee addiction:	https://www.buymeacoffee.com/sbarker77	Jump To:					STATE	DATE	TOTAL SFH LISTINGS	ACTIVE	PENDING	A/P RATIO	CHANGE IN ACTIVE LISTINGS	% CHANGE IN ACTIVE LISTINGS	TOTAL NEW CONST.	ACTIVE NEW CONST.	TOTAL FORECL.	ACTIVE FORECL.	TOTAL RP	ACTIVE RP	% OF ACTIVE RP	% CHANGE IN ACTIVE RP	POP	ACTIVE LISTING PER CAPITA	LISTING PER CAPITA
3	Welcome, all!		States					AL	#REF!															5,024,279	0	0	0.00%
4	I started this spreadsheet because I was bothered by how delayed public-facing housing information was. Browsing really made it apparent how many of us were curious, so I took it upon myself to make something. It started out small - rapidly evolved - and is now fully automated. This pulls daily data (from www.realtor.com) on a few trackable stats.		Alabama	Hawaii	Massachusetts	New Mexico	South Dakota	AK	#REF!															733391	0.0000	0.0000
5			Alaska	Idaho	Michigan	New York	Tennessee	AZ	#REF!															7151502	0.0000	0.0000
6			Arizona	Illinois	Minnesota	North Carolina	Texas	AR	#REF!															3011524	0.0000	0.0000
7	See the 'Requests' and 'Issues' tabs to make suggestions or point out errors.		Arkansas	Indiana	Mississippi	North Dakota	Utah	CA	#REF!															39538223	0.0000	0.0000
8			California	Iowa	Missouri	Ohio	Vermont	CO	#REF!															5773714	0.0000	0.0000
9			Colorado	Kansas	Montana	Oklahoma	Virginia	CT	#REF!															3605944	0.0000	0.0000
10			Connecticut	Kentucky	Nebraska	Oregon	Washington	DE	#REF!															989948	0.0000	0.0000
11			Delaware	Louisiana	Nevada	Pennsylvania	West Virginia	FL	#REF!															21538187	0.0000	0.0000
12			Florida	Maine	New Hampshire	Rhode Island	Wisconsin	GA	#REF!															10711908	0.0000	0.0000
13			Georgia	Maryland	New Jersey	South Carolina	Wyoming	HI	#REF!															1455271	0.0000	0.0000
14								ID	#REF!															1839106	0.0000	0.0000
15								IL	#REF!															12812508	0.0000	0.0000
16			Cities			Counties		IN	#REF!															6785528	0.0000	0.0000
17						Maricopa County, AZ	Gallatin County, MT	IA	#REF!															3190369	0.0000	0.0000
18						Alameda County, CA	Cumberland County, NC	KS	#REF!															2937880	0.0000	0.0000
19	This chart displays the percentage change of active listings for single-family-homes in a specified state.					El Dorado County, CA	Wake County, NC	KY	#REF!															4505836	0.0000	0.0000
20						Kern County, CA	Bergen County, NJ	LA	#REF!															4657757	0.0000	0.0000
21						Los Angeles County, CA	Passaic County, NJ	ME	#REF!															1362359	0.0000	0.0000
22						Orange County, CA	Bernalillo County, NM	MD	#REF!															6177224	0.0000	0.0000
23						Riverside County, CA	Clark County, NV	MA	#REF!															7029917	0.0000	0.0000
24						San Bernardino County, CA	Kings County, NY	MI	#REF!															10077331	0.0000	0.0000
25						San Diego County, CA	Monroe County, NY	MN	#REF!															5706494	0.0000	0.0000
26						Santa Clara County, CA	Nassau County, NY	MS	#REF!															2961279	0.0000	0.0000
27						El Paso County, CO	Queens County, NY	MO	#REF!															6154913	0.0000	0.0000
28						Jefferson County, CO	Rockland County, NY	MT	#REF!															1084225	0.0000	0.0000
29						Fairfield County, CT	Suffolk County, NY	NE	#REF!															1961504	0.0000	0.0000
30						Kent County, DE	Westchester County, NY	NV	#REF!															3104614	0.0000	0.0000
31						Sussex County, DE	Montgomery County, PA	NH	#REF!															1377529	0.0000	0.0000
32	This chart displays the percentage change of active listings for single-family-homes in a specified state that are currently "price reduced" from an initial listing price.					Broward County, FL	Philadelphia County, PA	NJ	#REF!															9288994	0.0000	0.0000
33						Citrus County, FL	Bexar County, TX	NM	#REF!															2117522	0.0000	0.0000
34						Lee County, FL	Dallas County, TX	NY	#REF!															20201249	0.0000	0.0000
35						Marion County, FL	Harris County, TX	NC	#REF!															10439388	0.0000	0.0000
36						Miami-Dade County, FL	Tarrant County, TX	ND	#REF!															779094	0.0000	0.0000
37						Orange County, FL	Webb County, TX	OH	#REF!															11799448	0.0000	0.0000
38						Cook County, IL	Salt Lake County, UT	OK	#REF!															3959353	0.0000	0.0000
39						Saint Clair County, IL	Utah County, UT	OR	#REF!															4237256	0.0000	0.0000
40						Johnson County, KS	Fairfax County, VA	PA	#REF!															13002700	0.0000	0.0000
41						Plymouth County, MA	Loudoun County, VA	RI	#REF!															1097379	0.0000	0.0000
42						Frederick County, MD	Roanoke County, VA	SC	#REF!															5118425	0.0000	0.0000
43						Howard County, MD	King County, WA	SD	#REF!															886667	0.0000	0.0000
44						Kennebec County, ME	Dane County, WI	TN	#REF!															6910840	0.0000	0.0000
45						Wayne County, MI		TX	#REF!															29145505	0.0000	0.0000
46	This chart displays the percentage of active listings for single-family-homes in a specified state that are currently "price reduced" from an initial listing price.							UT	#REF!															3271616	0.0000	0.0000
47								VT	#REF!															643077	0.0000	0.0000
48								VA	#REF!															8631393	0.0000	0.0000
49								WA	#REF!															7705281	0.0000	0.0000
50								WV	#REF!															1793716	0.0000	0.0000
51								WI	#REF!															5893718	0.0000	0.0000
52								WY	#REF!															576851	0.0000	0.0000
53
54
55
56
57
58
59
60	This chart displays the number of listings for single-family-homes per capita in a specified state. Census population data (2020) from: https://data.ers.usda.gov/reports.aspx?ID=17827
61
62
63
64
65
66
67
68
69
70
71
72
73	This chart displays the number of active listings for single-family-homes per capita in a specified state. Census population data (2020) from: https://data.ers.usda.gov/reports.aspx?ID=17827
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100