Replies

I've expanded my prior tracking of COVID-19 deaths by country to now cover all of the US at the state level. For those of you new to this analysis, I standardize each municipality's cumulative COVID-19 fatality count from GitHub by its population, then multiply the resulting quotient by the US' population of 329MM to put everyone on a common/US scale. I then index each municipality's time-series to Day 1, where their size-adjusted fatality count is right before it breaches 1,000 people. This corrects for what I call the "Golf Problem" where broadcasts of the Masters etc have to show not only each golfer's score, but which hole they're at. I also list the Day 1 date and the population for reference.

Below are the data. Note for the US as nation, that Day 1 is March 25, which means Day 20 is April 13 for that row of data. You can do the math for the other municipalities to find out what Day XX means for them in calendar times; as a general rule, the last actual data point is the freshest date (i.e., Day 22 for Georgia is that state's COVID-19 cumulative population-adjusted fatality count for April 13), but on a Golf timeline it gives each municipality's score as of the "20th hole." The order is alphabetical.

If we pick Day 20 as a reference point, the states with the four highest adjusted fatalities are NY, NJ, MI, LA and CT, respectively. Going a step further with regard to this article, here are the states SmokingJoe listed, the freshest adjusted fatality total, and their 'hole' as of April 13:

Arkansas – 3,209, Day 14
Iowa – 4,325 , Day 13
Nebraska – 2,955, Day 13
North Dakota – 3,483, Day 16
Oklahoma – 8,341, Day 18
South Carolina – 5,519, Day 18
South Dakota – 2,303, Day 9
Utah – 1,430, Day 9
Wyoming – hasn't started golfing

Henceforth, I'll just post updates vs the entire grid of data. Pray hard for those impacted and let me know if you have questions/corrections.

Municipality	Date of Day 1 = day prior to breaching size-adj 1,000 COVID19 fatalities	Population	Day 1	Day 2	Day 3	Day 4	Day 5	Day 6	Day 7	Day 8	Day 9	Day 10	Day 11	Day 12	Day 13	Day 14	Day 15	Day 16	Day 17	Day 18	Day 19	Day 20	Day 21	Day 22	Day 23	Day 24	Day 25	Day 26	Day 27	Day 28
Alabama	3/31/20	4,858,979	882	1,899	2,170	2,577	2,984	3,052	3,595	4,341	4,544	5,290	5,426	6,308	6,308	6,715	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Alaska	4/3/20	738,432	893	1,339	1,785	1,785	1,785	2,231	2,231	2,231	2,678	2,678	3,570	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Arizona	3/30/20	6,828,065	965	1,158	1,400	1,689	1,979	2,558	3,089	3,234	3,716	3,861	4,296	4,682	5,406	5,647	5,888	-	-	-	-	-	-	-	-	-	-	-	-	-
Arkansas	3/31/20	2,978,204	885	1,107	1,328	1,328	1,549	1,770	1,770	1,992	1,992	2,324	2,656	2,766	2,988	3,209	-	-	-	-	-	-	-	-	-	-	-	-	-	-
California	3/27/20	39,144,818	859	1,019	1,094	1,229	1,541	1,785	2,079	2,374	2,719	2,938	3,250	3,763	4,260	4,614	5,001	5,321	5,691	6,020	-	-	-	-	-	-	-	-	-	-
Colorado	3/24/20	5,456,574	664	1,148	1,450	1,872	2,657	2,839	3,080	4,167	4,832	5,798	6,644	7,610	8,455	9,059	10,811	11,596	13,710	15,280	16,549	17,515	18,481	-	-	-	-	-	-	-
Connecticut	3/23/20	3,590,886	918	1,101	1,744	1,927	2,478	3,029	3,120	3,304	6,333	7,801	10,279	12,114	15,143	17,346	18,906	25,422	30,745	34,875	41,116	45,337	50,844	55,249	-	-	-	-	-	-
Delaware	3/27/20	945,934	697	1,742	2,090	2,439	3,484	3,832	4,181	4,877	4,877	4,877	5,226	5,574	6,619	8,013	11,149	11,497	12,194	14,284	-	-	-	-	-	-	-	-	-	-
District of Columbia	3/24/20	672,228	980	1,471	1,471	1,961	1,961	1,961	4,412	4,412	5,393	5,883	7,354	10,295	10,785	11,766	10,785	13,237	15,688	18,629	23,042	24,512	25,493	-	-	-	-	-	-	-
Florida	3/29/20	20,271,272	959	1,154	1,382	1,626	2,341	2,747	3,154	3,577	4,113	4,796	5,235	6,015	6,796	7,235	7,478	8,112	-	-	-	-	-	-	-	-	-	-	-	-
Georgia	3/23/20	10,214,860	807	1,226	1,516	1,807	2,065	2,549	2,678	3,291	4,033	4,968	5,678	6,388	6,711	7,065	9,485	11,227	11,937	13,292	13,712	13,937	14,131	15,002	-	-	-	-	-	-
Hawaii	4/5/20	1,431,603	921	1,151	1,151	1,151	1,381	1,842	1,842	2,072	2,072	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Idaho	3/28/20	1,654,930	996	1,195	1,394	1,792	1,792	1,792	1,991	1,991	1,991	2,589	2,987	3,784	4,779	4,978	5,377	5,377	5,377	-	-	-	-	-	-	-	-	-	-	-
Illinois	3/27/20	12,859,995	948	1,281	1,794	2,153	2,742	3,741	4,228	5,407	6,355	7,227	7,919	9,841	11,891	13,685	15,555	17,477	18,630	20,450	-	-	-	-	-	-	-	-	-	-
Indiana	3/26/20	6,619,680	896	1,294	1,543	1,593	1,742	2,489	3,236	3,883	5,078	5,775	6,323	7,020	8,613	10,106	12,247	14,935	16,429	17,076	17,425	-	-	-	-	-	-	-	-	-
Iowa	4/1/20	3,123,899	949	1,160	1,160	1,160	2,321	2,637	2,743	2,848	2,848	3,270	3,587	4,325	4,325	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Kansas	3/29/20	2,911,641	792	1,019	1,132	1,245	1,585	2,151	2,377	2,603	2,830	3,396	4,301	4,754	5,659	6,225	6,338	7,018	-	-	-	-	-	-	-	-	-	-	-	-
Kentucky	3/30/20	4,425,092	819	1,341	1,489	2,532	2,532	2,979	3,277	3,873	4,915	5,437	6,256	6,703	7,001	7,298	8,416	-	-	-	-	-	-	-	-	-	-	-	-	-
Louisiana	3/20/20	4,670,724	706	1,129	1,411	2,399	3,246	4,586	5,856	8,396	9,666	10,725	13,124	16,934	19,262	21,873	26,106	29,070	33,656	36,126	41,065	46,004	49,532	53,271	56,870	59,269	62,373	-	-	-
Maine	3/30/20	1,329,328	744	1,240	1,735	1,735	2,231	2,479	2,479	2,479	2,975	3,471	3,967	4,215	4,710	4,710	4,710	-	-	-	-	-	-	-	-	-	-	-	-	-
Maryland	3/31/20	6,006,401	988	1,811	1,975	2,304	2,963	3,731	5,048	5,706	6,804	7,627	9,437	11,358	12,949	14,375	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Massachusetts	3/25/20	6,794,422	728	1,213	1,698	2,134	2,328	2,959	4,317	5,917	7,470	9,313	10,477	11,204	12,611	17,267	21,002	24,397	29,054	33,274	36,669	40,937	-	-	-	-	-	-	-	-
Michigan	3/24/20	9,922,576	797	1,428	2,092	3,089	3,687	4,384	6,543	8,768	11,159	13,850	15,876	17,935	20,459	24,146	28,065	31,851	35,737	42,512	46,199	49,354	53,207	-	-	-	-	-	-	-
Minnesota	3/31/20	5,489,594	720	1,021	1,081	1,321	1,441	1,741	1,801	2,041	2,341	3,002	3,422	3,842	4,202	4,202	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Mississippi	3/27/20	2,992,333	881	1,432	1,542	1,762	2,203	2,423	2,863	3,194	3,855	4,736	5,617	6,498	7,379	8,370	9,031	10,242	10,573	10,793	-	-	-	-	-	-	-	-	-	-
Missouri	4/1/20	6,083,672	975	1,300	1,679	2,384	2,817	3,034	4,279	4,659	5,092	5,688	6,284	6,284	6,663	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Montana	3/29/20	1,032,949	319	1,276	1,595	1,595	1,595	1,595	1,914	1,914	1,914	1,914	1,914	1,914	1,914	1,914	1,914	2,233	-	-	-	-	-	-	-	-	-	-	-	-
Nebraska	4/1/20	1,896,190	869	1,043	1,043	1,390	1,390	1,738	2,086	2,433	2,607	3,128	3,128	3,128	2,955	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Nevada	3/24/20	2,890,845	684	1,140	1,140	1,140	1,596	1,710	2,052	2,964	3,648	4,332	4,902	5,244	5,244	6,612	6,840	9,120	9,348	9,804	12,654	12,882	12,996	-	-	-	-	-	-	-
New Hampshire	4/1/20	1,330,608	991	1,238	1,734	2,229	2,229	2,229	3,220	4,458	5,201	5,449	5,696	5,696	5,696	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
New Jersey	3/23/20	8,958,013	993	1,619	2,281	2,980	3,973	5,150	5,923	7,321	9,823	13,060	19,829	23,802	31,160	33,736	36,973	45,324	55,331	62,541	71,076	80,310	86,454	89,876	-	-	-	-	-	-
New Mexico	4/1/20	2,085,109	948	1,106	1,581	1,739	1,897	1,897	2,055	2,529	2,687	3,003	3,161	4,109	4,109	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
New York	3/20/20	19,795,791	949	1,332	2,031	2,647	3,629	5,411	7,192	8,907	13,019	16,065	20,377	25,804	32,313	44,167	48,861	59,399	69,271	79,210	92,612	104,348	117,650	130,585	143,621	156,240	167,444	-	-	-
North Carolina	4/4/20	10,042,802	984	1,214	1,313	1,641	2,002	2,428	2,560	2,822	2,822	3,085	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
North Dakota	3/29/20	756,927	435	1,306	1,306	1,306	1,306	1,306	1,306	1,306	1,306	1,742	1,742	2,177	3,048	3,048	3,483	3,483	-	-	-	-	-	-	-	-	-	-	-	-
Ohio	3/29/20	11,614,373	851	1,135	1,561	1,844	2,298	2,582	2,894	3,377	4,029	4,739	5,476	6,044	6,555	7,009	7,179	7,775	-	-	-	-	-	-	-	-	-	-	-	-
Oklahoma	3/27/20	3,911,338	674	1,264	1,348	1,432	1,938	2,528	2,865	3,202	3,539	3,876	4,297	5,645	6,656	6,741	7,415	7,836	8,089	8,341	-	-	-	-	-	-	-	-	-	-
Oregon	3/27/20	4,028,977	982	1,063	1,063	1,309	1,472	1,554	1,718	1,800	2,127	2,209	2,372	2,699	3,108	3,599	3,926	4,172	4,253	4,335	-	-	-	-	-	-	-	-	-	-
Pennsylvania	3/28/20	12,802,503	901	1,030	1,236	1,853	1,905	2,317	2,626	3,578	4,093	4,350	6,178	8,057	8,855	11,198	13,257	13,514	15,162	-	-	-	-	-	-	-	-	-	-	-
Puerto Rico	4/1/20	3,680,058	985	1,075	1,343	1,612	1,791	1,881	2,060	2,149	2,955	3,493	3,761	3,940	4,030	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Rhode Island	3/29/20	1,056,298	936	1,248	2,496	3,120	3,744	4,368	5,304	7,800	8,424	9,360	10,920	13,416	15,288	17,472	19,655	19,655	-	-	-	-	-	-	-	-	-	-	-	-
South Carolina	3/27/20	4,896,146	875	1,010	1,077	1,212	1,481	1,750	2,087	2,289	2,692	2,962	3,231	3,433	4,240	4,510	4,846	5,385	5,519	5,519	-	-	-	-	-	-	-	-	-	-
South Dakota	4/5/20	858,469	768	1,536	2,303	2,303	2,687	2,687	2,303	2,303	2,303	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Tennessee	3/31/20	6,600,299	649	1,148	1,598	1,797	2,347	2,497	3,245	3,595	4,144	4,743	5,193	5,343	5,343	5,442	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Texas	4/2/20	27,469,114	948	1,164	1,488	1,644	1,920	2,136	2,339	2,735	2,963	3,191	3,467	3,659	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Utah	4/5/20	2,995,919	880	1,430	1,430	1,430	1,430	1,870	1,980	1,980	1,430	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Vermont	3/18/20	626,042	-	1,053	1,053	1,053	1,053	1,053	3,685	4,211	4,738	5,264	6,317	6,317	6,317	6,843	8,423	8,949	8,949	10,528	11,581	12,107	12,107	12,107	12,107	12,634	13,160	14,213	14,740	-
Virginia	3/29/20	8,382,993	865	1,022	1,061	1,337	1,612	1,808	2,044	2,044	2,123	2,713	2,948	4,285	4,757	5,111	5,543	5,858	-	-	-	-	-	-	-	-	-	-	-	-
Washington	3/8/20	7,170,351	873	1,011	1,103	1,333	1,471	1,701	1,838	1,930	2,206	2,482	3,125	3,447	3,815	4,366	4,458	5,056	5,653	5,975	6,940	8,135	8,779	9,514	10,157	10,387	11,444	12,501	13,467	14,616
West Virginia	4/10/20	1,844,128	894	1,072	1,430	1,430	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Wisconsin	3/29/20	5,771,337	971	1,142	1,428	1,884	2,113	2,798	3,426	4,168	4,739	5,368	6,110	6,624	7,480	8,051	8,280	8,794	-	-	-	-	-	-	-	-	-	-	-	-
Wyoming	3/29/20	586,107	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	562	-	-	-	-	-	-	-	-	-	-	-	-
United States	3/25/20	329,556,365	942	1,209	1,581	2,026	2,467	2,978	3,873	4,757	5,926	7,087	8,407	9,619	10,783	12,722	14,695	16,478	18,586	20,463	22,020	23,529	-	-	-	-	-	-	-	-