Forum Index > Full Moon Saloon > To your/our health (Covid-19 thread)
 This topic is locked: you cannot edit posts or make replies.
Previous :: Next Topic
Author Message
Joey
verrry senior member



Joined: 05 Jun 2005
Posts: 2797 | TRs | Pics
Location: Redmond
Joey
verrry senior member
PostFri Jun 12, 2020 1:13 pm 
Below are links to data files I produced that show the number of new COVID19 cases *per day* for each county in the USA. These are csv files and also include coordinates for each county centroid. This means the files are easy to import into spreadsheet or GIS software. The only limitation is that your use must be non-commercial. This data will be updated each night as the pandemic continues. The source of the data is a Johns Hopkins University GitHub page at: https://github.com/CSSEGISandData/COVID-19 A team at Hopkins collects information from a variety of sources and publishes a daily *cumulative* count of COVID cases for each county. This data is widely regarded as authoritative. If you are curious, here are some links where you can learn more about this work. https://www.esri.com/about/newsroom/podcast/the-science-and-scientist-behind-the-johns-hopkins-coronavirus-dashboard/ https://www.esri.com/arcgis-blog/products/product/public-safety/coronavirus-covid-19-data-available-by-county-from-johns-hopkins-university/ A few weeks ago I decided it would be useful if the Hopkins cumulative count data was converted to show the number of new COVID19 cases per day for each county. After searching online and failing to find the Hopkins data converted to daily counts, I decided to take on the task of writing code to do that conversion. That code now runs automatically each night (12:10a.m. pacific time), reads the prior two days worth of data from the Hopkins GitHib site, computes the new cases for yesterday and adds a new column to the csv file for the current month. Each month a new csv file will start. The daily count data starts on March 24. (Prior to March 23 there was a period of time when Hopkins was only reporting state totals.) Here is a link to the March csv file. The same naming convention will be followed as new months and years come along. In addition to this March file, you can also presently download a csv file for April, May and June by changing the month number in the following link. March csv file: https://mappingsupport.com/p2/disaster/coronavirus/daily_covid_cases/2020_03.csv Yes, the number of new COVID19 cases in these csv files might be different than the case numbers reported by county health departments. There are various reasons for any differences. For example, Hopkins counts both confirmed and probable cases. Also Hopkins ‘scrapes’ data from state health department websites and that data might lag a day or two behind data on county websites. You also will sometimes see negative numbers in these csv files. That might indicate a person who was counted as probable but then removed from the count when a negative test result was returned in a few days. I hope this data resource will be useful.

Back to top This topic is locked: you cannot edit posts or make replies. Reply with quote Send private message
jinx'sboy
Member
Member


Joined: 30 Jul 2008
Posts: 930 | TRs | Pics
Location: on a great circle route
jinx'sboy
Member
PostFri Jun 12, 2020 1:44 pm 
Now it looks like bald men might be at higher risk of more severe Covid-19 infection, due to androgen levels. https://nypost.com/2020/06/11/bald-men-may-be-hit-harder-by-coronavirus-scientists-fear/

Back to top This topic is locked: you cannot edit posts or make replies. Reply with quote Send private message
Cyclopath
Faster than light



Joined: 20 Mar 2012
Posts: 7731 | TRs | Pics
Location: Seattle
Cyclopath
Faster than light
PostSun Jun 14, 2020 8:52 pm 
DOH: New report shows increasing COVID-19 activity, some Eastern Washington counties now comparable to King County at March peak On Saturday, June 13th the Washington State Department of Health (DOH) released the latest COVID-19 statewide situation report, which shows virus transmission continued to increase in eastern Washington as of the end of May, with a possible uptick in western Washington as well. DOH said there are still significant differences in transmission from county to county. According to DOH, the situation in eastern Washington is of greatest concern – particularly in Benton, Franklin, Spokane and Yakima counties. The report estimates cases and deaths in these counties will soon increase substantially if COVID-19 continues to spread at current levels. In fact, by population, these counties are in a comparable position to King County at its March peak. DOH said these counties may require similar efforts to expand hospital capacity and testing, protect the people at highest risk and increase physical distancing. “The trends we’re seeing point to the critical importance of actions we can all take, like staying six feet apart and wearing cloth face coverings whenever we’re in public, as well as a need for increased response in these harder-hit areas,” said Dr. Kathy Lofy, state health officer at DOH. “We’re working closely with the Governor’s Office, local officials and partners to identify additional ways to reduce the spread of COVID-19 in these regions. Every single person in our state can and must do their part to help by following public health recommendations.” Meanwhile in Western Washington, DOH said case counts had been trending flat, but small increases are now being observed. State and local officials will continue to monitor the region carefully to determine whether the slight increase in COVID-19 transmission shown in the report continues to grow. The situation report findings include possible transmission increases over Memorial Day weekend, but DOH said this does not include increases that may have occurred following recent protests. The report also includes a new measure called Progress to Zero for each county, which shows how far cases have declined from the peak level of activity. This measure varies considerably across the state, with some counties showing large decreases (like King County) and other counties that have not yet reached a peak number of cases including Yakima, Klickitat, Benton, Franklin, Spokane and Stevens counties. The most recent estimates of transmission in eastern and western Washington are also available in the state’s risk assessment dashboard. The dashboard measures the same key metrics the Seattle-King County DOH does, but for each Washington State county. According to the assessment dashboard, King County – currently in modified phase 1.5 – is meeting as many key metric goals as neighboring, populous Pierce and Snohomish counties, which are currently in phase 2. King County is also meeting more key metrics than populous Spokane county, which is in phase 2. According to the Seattle Times, King County could apply this week to move to phase 2, which would expand some business capacity and relax restrictions on social gatherings. As of June 12th, King County had reported 8,700 COVID-19 cases – up 56 from the previous day – and 574 deaths – up 3 from the previous day. The positive COVID-19 test rate for King County is still on the decline, now at 6.4%. At its late March peak, that positive test rate was approximately 14%. Locally, Snoqualmie has reported on 27 total cases since the outbreak began – with four cases in May and none in June. Snoqualmie’s positive test rate is 5.3%. The City of North Bend (not including unincorporated area) has reported 18 cases – two in May and none in June – and has a 4.4% positive test rate. https://livingsnoqualmie.com/doh-new-report-shows-increasing-covid-19-activity-some-eastern-washington-counties-now-comparable-to-king-county-at-its-march-peak/

Back to top This topic is locked: you cannot edit posts or make replies. Reply with quote Send private message
zephyr
aka friendly hiker



Joined: 21 Jun 2009
Posts: 3370 | TRs | Pics
Location: West Seattle
zephyr
aka friendly hiker
PostMon Jun 15, 2020 10:15 am 
Here's an interesting graphic on Twitter showing all the states and their current increase or decrease in infection cases. Very good for a quick look at our state and our neighbors. Quote: How is your State doing, #COVID19 -wise? Here's a quick view. Red = ^ing #coronavirus incidence vs blue, declining viral spread. (Red/Blue are not GOP/Dem in this case) ~z Note: As of this morning, that link doesn't seem to work directly. It DOES work if you right click on it and open in another tab.

Back to top This topic is locked: you cannot edit posts or make replies. Reply with quote Send private message
Cyclopath
Faster than light



Joined: 20 Mar 2012
Posts: 7731 | TRs | Pics
Location: Seattle
Cyclopath
Faster than light
PostTue Jun 16, 2020 9:38 am 
UK experts say the low-dose steroid treatment [Dexamethasone] is a major breakthrough in the fight against the deadly virus. It cut the risk of death by a third for patients on ventilators. For those on oxygen, it cut deaths by a fifth. BBC

Back to top This topic is locked: you cannot edit posts or make replies. Reply with quote Send private message
treeswarper
Alleged Sockpuppet!



Joined: 25 Dec 2006
Posts: 11276 | TRs | Pics
Location: Don't move here
treeswarper
Alleged Sockpuppet!
PostTue Jun 16, 2020 6:04 pm 
Cyclopath wrote:
UK experts say the low-dose steroid treatment [Dexamethasone] is a major breakthrough in the fight against the deadly virus. It cut the risk of death by a third for patients on ventilators. For those on oxygen, it cut deaths by a fifth. BBC
After reading about the hospital bills that survivors are receiving, I wonder how much this drug costs here in the land of you get what you can pay for.

What's especially fun about sock puppets is that you can make each one unique and individual, so that they each have special characters. And they don't have to be human––animals and aliens are great possibilities
Back to top This topic is locked: you cannot edit posts or make replies. Reply with quote Send private message
zephyr
aka friendly hiker



Joined: 21 Jun 2009
Posts: 3370 | TRs | Pics
Location: West Seattle
zephyr
aka friendly hiker
PostTue Jun 16, 2020 8:37 pm 
treeswarper wrote:
After reading about the hospital bills that survivors are receiving, I wonder how much this drug costs here in the land of you get what you can pay for.
From what I've seen the last couple of days, that medication is relatively inexpensive. Here's an article in the BBC online about that. Note: I had read about this earlier in a different source and didn't see Cyclopath's complete quote. And you t.w., quoted it as well. haha Read that article and see about the costs. wink.gif ~z

Back to top This topic is locked: you cannot edit posts or make replies. Reply with quote Send private message
RayD
the griz ate my pass



Joined: 20 Aug 2005
Posts: 1763 | TRs | Pics
Location: Vacaville
RayD
the griz ate my pass
PostSat Jun 20, 2020 11:48 am 
An overview of vaccine development.

don't believe everything you think
Back to top This topic is locked: you cannot edit posts or make replies. Reply with quote Send private message
graywolf
Member
Member


Joined: 03 Feb 2005
Posts: 808 | TRs | Pics
Location: Sequim
graywolf
Member
PostSat Jun 20, 2020 12:42 pm 
Injectable dexamethasone is very inexpensive. At least it was. If the usual price gouging occurs, the price will increase dramatically due to "shortages, demand, etc.", whatever the drug companies can come up with to justify their exorbitant profits.

The only easy day was yesterday...
Back to top This topic is locked: you cannot edit posts or make replies. Reply with quote Send private message
altasnob
Member
Member


Joined: 29 Aug 2007
Posts: 1406 | TRs | Pics
Location: Tacoma
altasnob
Member
PostSat Jun 20, 2020 8:29 pm 
Iceland has no active corona virus cases. Bars and restaurants are fully open. And they will start allowing international tourists starting July 1. Upon entry you are tested. If negative, proceed on trip. If positive, 14 day quarantine. https://www.cnn.com/travel/article/iceland-reopens-coronavirus/index.html

Back to top This topic is locked: you cannot edit posts or make replies. Reply with quote Send private message
graywolf
Member
Member


Joined: 03 Feb 2005
Posts: 808 | TRs | Pics
Location: Sequim
graywolf
Member
PostSat Jun 20, 2020 8:55 pm 
Cyclopath wrote:
UK experts say the low-dose steroid treatment [Dexamethasone] is a major breakthrough in the fight against the deadly virus. It cut the risk of death by a third for patients on ventilators. For those on oxygen, it cut deaths by a fifth. BBC
Waiting for the peer review to see if this stands up to scrutiny.

The only easy day was yesterday...
Back to top This topic is locked: you cannot edit posts or make replies. Reply with quote Send private message
cdestroyer
Member
Member


Joined: 14 Sep 2015
Posts: 1250 | TRs | Pics
Location: montana
cdestroyer
Member
PostSun Jun 21, 2020 7:01 am 
big uptick in infections here since the reopening began: The state of Montana listed 32 new cases of COVID-19 on Saturday, the most in one day since late March and bringing the state’s total to 698 and capping a week in which an uptick of incidents have been reported. Seven new cases were reported in Gallatin County, five in Yellowstone County, four in Rosebud, three in Carbon, two in Big Horn, Missoula and Toole counties, and one each in Cascade, Custer, Dawson, Glacier, Park, Ravalli and Richland counties. People between 20-29 years of age account for 18% of all reported COVID-19 cases in Montana. The next most common age group is 50-59 years (17%) and 30-39 years (17%), followed by 60-69 years (15%). The median age for all cases is 44. Fifty percent of cases are between 28-60 years of age, the report stated. The report noted five counties have reported widespread community acquired transmission. Officials said 22% of all cases with known transmission information likely acquired the virus in the community; "most of those are in Gallatin and Yellowstone counties. Twenty-one percent of reported cases likely acquired the virus through travel-related exposures. About 29% of cases were contacts to a known case, either within the household or otherwise. Clusters identified 27% of new case reports." as reported in the great falls tribune

Back to top This topic is locked: you cannot edit posts or make replies. Reply with quote Send private message
zephyr
aka friendly hiker



Joined: 21 Jun 2009
Posts: 3370 | TRs | Pics
Location: West Seattle
zephyr
aka friendly hiker
PostSat Jun 27, 2020 9:20 pm 
Here's an interesting video clip of workers in Bangladesh making PPE. https://twitter.com/i/status/1276988927220449280 ~z

Back to top This topic is locked: you cannot edit posts or make replies. Reply with quote Send private message
zephyr
aka friendly hiker



Joined: 21 Jun 2009
Posts: 3370 | TRs | Pics
Location: West Seattle
zephyr
aka friendly hiker
PostWed Jul 01, 2020 10:10 am 
This video has been out since April, but it's the first time I have seen it. It's a little slow in the beginning. (Plus the sneezing scene is a little gross.) The best parts are toward the end when it demonstrates ventilation and dispersal of the micro droplets. This really makes me want to avoid being in closed spaces with poor ventilation and to avoid close contact conversations without masking. ~z
.

Back to top This topic is locked: you cannot edit posts or make replies. Reply with quote Send private message
Anne Elk
BrontosaurusTheorist



Joined: 07 Sep 2018
Posts: 2419 | TRs | Pics
Location: Seattle
Anne Elk
BrontosaurusTheorist
PostWed Jul 01, 2020 11:43 am 
Here's another cool metrics map: Pandemics Explained from Harvard Global Health Institute. Be patient if it takes some time drilling into the county data - it was mentioned on NPR this morning, and the site got a little overwhelmed.

"There are yahoos out there. It’s why we can’t have nice things." - Tom Mahood
Back to top This topic is locked: you cannot edit posts or make replies. Reply with quote Send private message
   All times are GMT - 8 Hours
 This topic is locked: you cannot edit posts or make replies.
Forum Index > Full Moon Saloon > To your/our health (Covid-19 thread)
  Happy Birthday Traildad!
Jump to:   
Search this topic:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum