Search This Blog

Saturday, March 21, 2020

Coronavirus the Numbers: Your State

How is your state handing the "coronavirus" crisis?  Do you wonder if your state's destruction of the economy, your job, your welfare, etc. is the "norm" across the country? (CSV at the end of the post. For those born recently I will be providing handy picture pages for you to grasp what's being presented. Click image to enlarge.)



The above is based on the following sources:

CDC Influenza Data

The above table is from the linked CDC site.  For calculating historical influenza numbers I simply averaged each column and, using the total populate of the US states created the ratio of that state's population to the total US population and multiplied it by the average.  Clearly these are simply "rough estimates" to get a feel for the magnitude of the issue.

(I apologize in advance for any transcription errors...)

Closure data from: https://www.aljazeera.com/news/2020/03/emergencies-closures-states-handling-coronavirus-200317213356419.html

Political data from: https://worldpopulationreview.com/states/blue-states/

Influenza data from: https://www.cdc.gov/flu/about/burden/index.html

Corona virus cases/deaths from: https://www.livescience.com/coronavirus-updates-united-states.html

Populations: Wikipedia

CSV Data:

State,Political as of 2020,Corona Cases (not deaths) as of 3/20/20,Population,Corona Deaths as of 3/20/20,Historic Average Annual Symptomatic Influenza Reports,HistoricalAverage Annual InfluenzaDeaths,Public School Closures,State Run Entities Closed (G=Gambling),Large Event Limits or Cancellations,"Closings Business (F=Forced, V=Voluntary, NE=Non-Essential Forced Closed)","Bars, Restaurants, etc.Forced Closed (T=Takeout Only, R=Restricted)","State of Emergency (L=Limited, D=Disaster)",Delay Elections
Alabama,Red,29,"4,903,185",0,"367,188",546,Y,N,N,V,N,N,N
Alaska,Red,9,"731,545",0,"54,784",81,Y,Y,N,V,N,N,N
Arizona,Red,44,"7,278,717",0,"545,086",810,N,N,Y,V,N,N,N
Arkansas,Red,64,"3,017,825",0,"225,998",336,N,N,N,V,N,N,N
California,Blue,982,"39,512,223",16,"2,958,978","4,397",Y,Y,F,F,F,Y,N
Colorado,Purple,363,"5,758,736",4,"431,258",641,N,N,N,N,T,N,N
Connecticut,Blue,97,"3,565,287",1,"266,996",397,Y,N,Y,N,F,N,N
Delaware,Blue,30,"973,764",0,"72,923",108,Y,N,N,N,T,N,N
Florida,Red,390,"21,477,737",8,"1,608,418","2,390",Y,N,N,N,R,N,N
Georgia,Red,287,"10,617,423",10,"795,114","1,181",Y,N,N,N,N,L,N
Hawaii,Blue,16,"1,415,872",0,"106,031",158,Y,Y,Y,N,T,N,N
Idaho,Red,11,"1,792,065",0,"134,204",199,N,N,N,N,N,L,N
Illinois,Blue,288,"12,671,821",1,"948,963","1,410",Y,N,Y,NE,F,N,N
Indiana,Red,79,"6,732,219",2,"504,160",749,N,N,N,N,T,N,N
Iowa,Red,39,"3,155,070",0,"236,276",351,N,N,Y,N,T,N,N
Kansas,Red,34,"2,913,314",1,"218,171",324,Y,N,N,N,N,N,N
Kentucky,Red,35,"4,467,673",1,"334,574",497,Y,N,Y,N,F,Y,N
Louisiana,Red,347,"4,648,794",8,"348,137",517,Y,N,Y,N,T,N,Y
Maine,Red,56,"1,344,212",0,"100,665",150,N,N,Y,N,T,N,N
Maryland,Blue,149,"6,045,680",1,"452,747",673,Y,G,Y,N,T,N,N
Massachusetts,Blue,413,"6,949,503",1,"520,432",773,Y,N,Y,N,F,Y,N
Michigan,Red,549,"9,986,857",3,"747,892","1,111",Y,N,Y,N,T,N,N
Minnesota,Blue,115,"5,639,632",0,"422,339",628,Y,N,N,N,T,N,N
Mississippi,Red,80,"2,976,149",1,"222,877",331,N,N,N,N,N,N,N
Missouri,Red,24,"6,137,428",1,"459,618",683,N,G,N,N,N,N,N
Montana,Red,11,"1,068,778",0,"80,038",119,Y,N,N,N,N,Y,N
Nebraska,Red,32,"1,934,408",0,"144,863",215,N,N,Y,N,T,N,N
Nevada,Red,84,"3,080,156",1,"230,666",343,Y,G,Y,NE,T,Y,N
New Hampshire,Red,44,"1,359,711",0,"101,826",151,Y,N,Y,N,N,Y,N
New Jersey,Blue,742,"8,882,190",9,"665,167",988,Y,N,Y,N,F,N,N
New Mexico,Blue,35,"2,096,829",0,"157,027",233,N,N,Y,N,R,N,N
New York,Blue,7102,"19,453,561",26,"1,456,832","2,165",Y,N,N,NE,F,Y,N
North Carolina,Red,137,"10,488,084",0,"785,428","1,167",Y,N,N,N,T,N,N
North Dakota,Red,20,"762,062",0,"57,069",85,Y,N,N,N,N,N,N
Ohio,Red,169,"11,689,100",1,"875,370","1,301",Y,Y,N,N,T,N,Y
Oklahoma,Red,49,"3,956,971",1,"296,328",440,N,N,N,N,N,N,N
Oregon,Blue,114,"4,217,737",2,"315,857",469,N,N,N,N,T,N,N
Pennsylvania,Red,268,"12,801,989",1,"958,711","1,425",N,N,Y,NE,T,N,N
Rhode Island,Blue,54,"1,059,361",0,"79,333",118,Y,N,N,N,T,Y,N
South Carolina,Red,125,"5,148,714",1,"385,575",573,Y,N,N,N,T,N,N
South Dakota,Red,11,"884,659",1,"66,250",98,Y,Y,N,N,N,N,N
Tennessee,Red,154,"6,833,174",0,"511,721",760,N,N,N,N,N,Y,N
Texas,Red,228,"28,995,881",4,"2,171,434","3,227",N,N,N,N,N,D,N
Utah,Red,112,"3,205,958",0,"240,087",357,N,N,N,N,N,N,N
Vermont,Blue,18,"623,989",9,"46,729",69,Y,N,Y,N,T,Y,N
Virginia,Red,94,"8,535,519",2,"639,205",950,Y,N,Y,N,N,N,N
Washington,Blue,1187,"7,614,893",68,"570,262",847,Y,N,Y,N,F,Y,N
West Virginia,Red,8,"1,787,145",0,"133,835",199,Y,N,N,N,N,N,N
Wisconsin,Red,206,"5,822,434",3,"436,029",648,Y,N,N,N,T,N,N
Wyoming,Red,20,"578,759",0,"43,342",64,N,N,N,N,N,N,N

No comments:

Post a Comment