- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Daily COVID Updated as of 11/2/20 8:00 PM
Posted on 5/27/20 at 10:57 am to the808bass
Posted on 5/27/20 at 10:57 am to the808bass
As expected, deaths are jumping today.
Posted on 5/27/20 at 11:03 am to Crimsonians
If we’re under 2000, it’s still a win. We’ll be under 1000 for the last 4 days (I think).
Posted on 5/27/20 at 11:24 am to Chromdome35
These are the tabs currently available on the tracker:
US Tab: This shows data for the US. You cannot change anything on this tab.
State Tab: This shows data for the selected state. You can change the State by clicking on cell B1 and selecting a different state via the dropdown. It will take about 30 seconds to update. you can also select the date which will change the starting point for the graphs. 3/15/20 is a good starting date as there isn't much data before that time.
By Capita Tab: This shows a comparison of states by capita for a given day. You can select the date in cell A2 and the data element you want to view in cell B2. After a few seconds, the chart will update.
Heat Map Tab: This allows you to pick a starting date and a data element to view. You can also select a state in cell B6 that you can use to compare to the cells below. The colors are based on the data range for each state. This means that for a given state, whichever days have the highest values will be the most red. The scale is state dependant which means that for Arkansas the highest day might be 100 cases and it will be red while for NY, red might be 2000 cases. It's all relative to each state.
Control Tab: This tab is used by the various formulas to populate the various dropdowns and as a reference for the sheets formulas to refer to.
COVIDData Tab: This tab contains 1 row for each state for each day. The data for the US is here as well with the US appearing as another state in the table. On the control tab, you'll see a data definition of the table on the COVIDData tab. If you want to do your own analysis, you can pull the data out of this tab for your own use.
WoMUSData Tab: This tab uses the google sheets importhtml function to screen scrape the WoM site for the number of new cases and deaths for the day. This data is then displayed on the top row of the tracker so the viewer will have an idea of how today is trending. You can compare these 2 numbers to the Previous day's columns in cells C8 and C11.
US Tab: This shows data for the US. You cannot change anything on this tab.
State Tab: This shows data for the selected state. You can change the State by clicking on cell B1 and selecting a different state via the dropdown. It will take about 30 seconds to update. you can also select the date which will change the starting point for the graphs. 3/15/20 is a good starting date as there isn't much data before that time.
By Capita Tab: This shows a comparison of states by capita for a given day. You can select the date in cell A2 and the data element you want to view in cell B2. After a few seconds, the chart will update.
Heat Map Tab: This allows you to pick a starting date and a data element to view. You can also select a state in cell B6 that you can use to compare to the cells below. The colors are based on the data range for each state. This means that for a given state, whichever days have the highest values will be the most red. The scale is state dependant which means that for Arkansas the highest day might be 100 cases and it will be red while for NY, red might be 2000 cases. It's all relative to each state.
Control Tab: This tab is used by the various formulas to populate the various dropdowns and as a reference for the sheets formulas to refer to.
COVIDData Tab: This tab contains 1 row for each state for each day. The data for the US is here as well with the US appearing as another state in the table. On the control tab, you'll see a data definition of the table on the COVIDData tab. If you want to do your own analysis, you can pull the data out of this tab for your own use.
WoMUSData Tab: This tab uses the google sheets importhtml function to screen scrape the WoM site for the number of new cases and deaths for the day. This data is then displayed on the top row of the tracker so the viewer will have an idea of how today is trending. You can compare these 2 numbers to the Previous day's columns in cells C8 and C11.
This post was edited on 5/27/20 at 4:20 pm
Posted on 5/27/20 at 12:09 pm to the808bass
quote:
If we’re under 2000, it’s still a win. We’ll be under 1000 for the last 4 days (I think).
Correct. For the three day weekend, we were at right around 1,900 deaths. It would take 2,100 to get to a 4 day average of 1,000.
Also of note, yesterday was the first non holiday weekday since March 30 that we were below 1000 deaths.
Posted on 5/27/20 at 1:10 pm to Volsfan82169
820 and counting. Doesn't look like we will get near 2000.
Posted on 5/27/20 at 2:12 pm to Crimsonians
We may not get to 20k cases.
Posted on 5/27/20 at 3:28 pm to Chromdome35
I finally got screen scraping to work so I could pull some numbers from the WoM site. I made the header of the tracker look like this
This shows you New Cases and Deaths for the day from WoM along with a comparison to the previous day which shows as Down or UP X from the previous day.
I also added a WoM States reporting so we could see how many states currently have reported numbers on the WoM site. Just because a state has updated, doesn't mean they won't update again during the day. Florida, Georgia and NY all seem to update more than once a day.
The screen scrape runs once an hour on the hour.
This shows you New Cases and Deaths for the day from WoM along with a comparison to the previous day which shows as Down or UP X from the previous day.
I also added a WoM States reporting so we could see how many states currently have reported numbers on the WoM site. Just because a state has updated, doesn't mean they won't update again during the day. Florida, Georgia and NY all seem to update more than once a day.
The screen scrape runs once an hour on the hour.
This post was edited on 5/27/20 at 3:29 pm
Posted on 5/27/20 at 6:15 pm to Chromdome35
This is the link to the New COVID-19 tracker that I have shared on Google Drive.
If you want to view the shared sheet, follow this link New COVID-19 Tracker
If you want to download a copy of this sheet and manipulate it follow this link Downloadable New COVID-19 Tracker
The source for the data is from https://covidtracking.com/data/
NOTE: Be sure to view the READ ME page on the new tracker
Links to the old Tracker
Chromdome's Old COVID Tracker
Old Tracker
New Tracker
If you want to view the shared sheet, follow this link New COVID-19 Tracker
If you want to download a copy of this sheet and manipulate it follow this link Downloadable New COVID-19 Tracker
The source for the data is from https://covidtracking.com/data/
NOTE: Be sure to view the READ ME page on the new tracker
Links to the old Tracker
Chromdome's Old COVID Tracker
Old Tracker
New Tracker
Posted on 5/27/20 at 8:25 pm to Chromdome35
New Cases up today by 2.3K over yesterday but down 2.7K from last Wednesday. Deaths came in at 1.2K which is a WIN by any standard. After three consecutive days of 602 average deaths, we expected to see a bump today. The fact that deaths are 143 down from last Wednesday which wasn't impacted by a three-day slump is a great sign.
Testing was down to 285K today, we are seeing a fairly rapid decline in the number of tests, I wonder if that is caused by a lack of people to test?
The % positive rate was up to 6.51% a 1.2% increase over yesterday and 1.3% above last Wednesday's 405K tests.
Mortality remains at 5.6% where its been since 5/7.
Testing was down to 285K today, we are seeing a fairly rapid decline in the number of tests, I wonder if that is caused by a lack of people to test?
The % positive rate was up to 6.51% a 1.2% increase over yesterday and 1.3% above last Wednesday's 405K tests.
Mortality remains at 5.6% where its been since 5/7.
This post was edited on 5/27/20 at 8:26 pm
Posted on 5/28/20 at 12:52 am to Chromdome35
Almost under 1% case growth baws
Posted on 5/28/20 at 4:23 am to Chromdome35
quote:
Testing was down to 285K today, we are seeing a fairly rapid decline in the number of tests, I wonder if that is caused by a lack of people to test?
The CDC has been trying to get states to break out infection and serologic tests, so it’s possible that some of the decrease is due to the removal of antibody tests.
Posted on 5/28/20 at 6:24 am to Chromdome35
Getting it down below 1000 deaths very soon, if not today on the 7 day roll is a big deal. Especially the way it is dropping, I think this is all gonna be over sooner than expected.
Posted on 5/28/20 at 7:07 am to jeffsdad
quote:
Testing was down to 285K today, we are seeing a fairly rapid decline in the number of tests, I wonder if that is caused by a lack of people to test?
It's warmer out now. fewer people will need testing as the summer progresses. Finding an asymptomatic positive is pretty pointless anyways.
Posted on 5/28/20 at 7:37 am to uppermidwestbama
I've come to the conclusion this is basically lung herpes with the exception it doesnt recur.
A lot of people get it and dont know they have it. They may never know they had it. Some people get it and have horrible debilitating outbreaks.
You don't routinely test for herpes for that reason. You dont want to know if you're positive "just to know" because of the stigma associated with it.
A lot of people get it and dont know they have it. They may never know they had it. Some people get it and have horrible debilitating outbreaks.
You don't routinely test for herpes for that reason. You dont want to know if you're positive "just to know" because of the stigma associated with it.
This post was edited on 5/28/20 at 8:24 am
Posted on 5/28/20 at 11:17 am to Chromdome35
is the old state tracker available, or it is data non grata?
Posted on 5/28/20 at 1:39 pm to Hooligan's Ghost
It is still live for the time being Chromdome's Old State Tracker
I don't know how much longer it will be up. Probably until I finish the new one.
I don't know how much longer it will be up. Probably until I finish the new one.
Posted on 5/28/20 at 1:53 pm to Hooligan's Ghost
I will update it in a few minutes
Posted on 5/28/20 at 6:09 pm to Chromdome35
This is the link to the New COVID-19 tracker that I have shared on Google Drive.
If you want to view the shared sheet, follow this link New COVID-19 Tracker
If you want to download a copy of this sheet and manipulate it follow this link Downloadable New COVID-19 Tracker
The source for the data is from https://covidtracking.com/data/
NOTE: Be sure to view the READ ME page on the new tracker
Links to the old Tracker
Chromdome's Old COVID Tracker
Old Tracker
New Tracker
If you want to view the shared sheet, follow this link New COVID-19 Tracker
If you want to download a copy of this sheet and manipulate it follow this link Downloadable New COVID-19 Tracker
The source for the data is from https://covidtracking.com/data/
NOTE: Be sure to view the READ ME page on the new tracker
Links to the old Tracker
Chromdome's Old COVID Tracker
Old Tracker
New Tracker
This post was edited on 5/28/20 at 7:48 pm
Popular
Back to top
Follow TigerDroppings for LSU Football News