Tag Archives: pandemic

coronavirus trackers and simulations revisited

Update: December 13, 2020 (and from time to time since then, I update links if I notice they are broken)

This post is getting a surprising amount of attention. I don’t normally update posts, but I am updating this one since it is getting attention and the commentary in the original post is significantly outdated. Rest assured, if you are a historian in the far future studying what I was thinking back in June 2020, I have kept the original post at the bottom. I am keeping all the links, just grouping them somewhat and removing (from this section) the outdated commentary. (Thank you, Word Press, for making a simple copy-and-paste operation like this beyond excruciating.)

Data Trackers

  • Johns Hopkins – map, stats, access to data sets
  • New York Times – a national (U.S.) map by county and plots by state (now, with a paywall! as of 7/30/21. Which I will never pay because WEAPONS OF MASS DESTRUCTION!)
  • Financial Times – similar to others, but they look at excess deaths a little differently and have some interesting graphics
  • BBC – similar to NYT, but international
  • CDC – changed this link to their “COVID-19 by County” page on 2/26/22; the updated recommendation is to mask indoors if new cases in your county are 200,000 per 100,000 population per week, AND if the number of people entering the hospital and/or in the hospital is above certain thresholds. It’s a little hard to find the data and figure out yourself, so if you trust the CDC (and who wouldn’t?) you can just type in your county and they will tell you if it is high/medium/low.
  • https://coronavirus.thebaselab.com/ – a variety of maps and plots
  • City Observatory – intermittent data-based articles and maps
  • Our World in Data – excellent interactive country-level data, maps, and plots. A tip – you can also type in “world” or the name of a continent in the country box.
  • https://aatishb.com/covidtrends/ – a very clever animated time series of growth in cases over time, by country
  • Reuters – just more numbers and maps, similar to NYT
  • Covid Act Now – state-level data and communication in a simple, easy to understand index format
  • Harvard Global Health Institute COVID Risk Levels Dashboard – similar to Covid Act Now, but less simple and less easy to understand. Seems to have more ability to drill down into county-level data, although when you do that much of it is blank.
  • Wastewater surveillance from “Biobot Analytics” – added 4/30/22.

Simulations

  • University of Washington IHME – the best place I have found for understandable future projections. At the state level.
  • FiveThirtyEight – compares different models (no longer updating as of 7/30/21)
  • https://covid19risk.biosci.gatech.edu/ – This site calculates the probability that someone in a group of a given size is infected, based on the estimated rate of active cases in a U.S. state.
  • MicroCOVID – a risk calculator based on local data and allowing you to adjust your risk tolerance and try out various scenarios (added 8/8/21), such as “one night stand with a random person” (on the latter, please remember there are other diseases besides just Covid-19, for example antibiotic-resistant syphilis…)
  • Covid-19 Forecast hub – another visualization of various models and ensembles of models

Vaccine Trackers

Local Pennsylvania/Philadelphia Interest

  • The state of Pennsylvania has a useful dashboard which they have now made public (or it was public before and I didn’t notice.) It compares cases, positive tests, and hospital data for the current and last 7-day period, at the county level.
  • Speaking of Philadelphia, a shout out to the Philadelphia Health Department which provides some open downloadable data.

Miscellaneous Stuff

Original Post (June 27, 2020)

I decided to list out and summarize the variety of trackers and simulations I’ve mentioned in previous posts. Like many people (in the U.S. Northeast at least), I was glued to coronavirus info on various screens from roughly mid-March to mid-May, then my attention started to gradually drift to other things as the situation got better. Now, it seems that it has either stabilized at a not-quite-out-of-the-woods level, or is slowly reversing itself as we see other parts of the country start to be affected more seriously (sorry if you are reading this and are being affected, we in the Northeast take no pleasure in your suffering, I promise, although we suggest you turn out any bigoted anti-science politicians in your area who are letting this happen.) Anyway, I find that I am interested in starting to look at trackers and simulations again on a daily basis. These are in the order I discovered them.

  • Johns Hopkins – a neat map early on, although now the entire world has become a blob. Still a good place to stare at data.
  • New York Times – a national (U.S.) map by county and plots by state. seems to load even though I have used all my free articles for the month.
  • BBC – they update continuously but I’m not sure if this link will be to the latest
  • CDC – this is what I would have predicted would be the go-to source of information and expertise if you asked me before all this started…but it’s mediocre at best. Yes, that just about sums it up.
  • https://coronavirus.thebaselab.com/ – a variety of maps and plots to stare at, not my first stop but a little different if I am tired of others
  • University of Washington IHME – still the most informative state-level simulations I have found, accounting for hospital capacity among other things
  • City Observatory – they did an awesome analysis by U.S. metro area, which I have not seen anyone else do (human beings interact with each other socially and economically in cities and their suburbs, which often cut across states, and states often contain metro areas that are not connected much socially or economically. Economists, social scientists and urban planners know this of course, but nobody else studying the epidemic seems to have figured this out. Seriously, other data visualization and simulation sites, you can do this, it’s just a matter of grouping data by counties.) Unfortunately, they quit updating it and have not automated it. I still check every now and then to see if they have picked it up.
  • Our World in Data – pretty much every conceivable way of looking at data by country. I like to look at confirmed deaths per million across countries. By this measure, the starkest contrast is east vs. west. The eastern countries were hit first, hard, and without warning, and their death rates are very, very low. They have a variety of government types, responses, ethnicities and cultures. I just don’t think anybody has come close to explaining it. The U.S. is in the middle of the pack of western countries, which somewhat contradicts conventional wisdom and suggests news organizations are making the obvious error of not normalizing by population.
  • https://aatishb.com/covidtrends/ – an animated time series of new confirmed cases in the past week vs. total confirmed cases, both on a log scale, by country. As I write this, shows the beginning of a concerning uptick for the United States, and Brazil out of control.
  • Reuters – I actually never wrote about this one, but it has a map and some numbers.
  • FiveThirtyEight – they have an aggregation of various simulation models out there. New York and New Jersey look like a stream sprayed horizontally out of a garden hose, while Texas and Florida (today) look more like a fire hose.
  • https://covid19risk.biosci.gatech.edu/ – This site calculates the probability that someone in a group of a given size is infected, based on the estimated rate of active cases in a U.S. state. I assume it’s estimated active cases, anyway, or it wouldn’t make sense. It would be better by metro area (seriously guys, someone just get this done), but still a nice idea. I’m in Philadelphia, but I figure the New Jersey numbers are probably the most applicable.
  • Covid Act Now – provides a composite risk index at the state level, and county when county level data is available in the right format (which is not that often)
  • Harvard Global Health Institute COVID Risk Levels Dashboard – keeps it simple with just data on new cases, but gives you a variety of nice mapping, charting, and tabular formats to slice and dice the data at country, (U.S.) state or county level.
  • The state of Pennsylvania has a useful dashboard which they have now made public (or it was public before and I didn’t notice.) It compares cases, positive tests, and hospital data for the current and last 7-day period, at the county level.
  • Speaking of Philadelphia, a shout out to the Philadelphia Health Department which provides some open downloadable data.
  • I look at the FAO food price index on occasion. It’s falling lately. Sometimes I look at oil and gold prices, and how many Special Drawing Rights can be bought with one U.S. dollar. Oh and, the Rapture Index is at an all time high!

bodies stacked like cordwood

Here goes…I generally support police-court-prison reform and policies to reduce violence in all its forms. I support policies to help right past and present injustices, both race and class based.

I’m very concerned about thousands of people out on the streets just when we thought we were getting Covid-19 under control. This is a disease that has killed black people and poor people disproportionately. About 100,000 people dead in the last couple months vs. about 1,000 per year killed by police (which is certainly too much). Now is just not the time, in my view. If we wanted to devise an experiment to find out whether people gathering in the streets by the thousands, packed in like sardines but largely wearing masks, would reverse our progress on Covid-19 or not, this would be the experiment. It would not be an ethical experiment!

A history lesson: In 1918, Philadelphians took to the streets by the thousands in the midst of the flu epidemic that year, with devastating consequences. From Smithsonian:

When the Fourth Liberty Loan Drive parade stepped off on September 28, some 200,000 people jammed Broad Street, cheering wildly as the line of marchers stretched for two miles. Floats showcased the latest addition to America’s arsenal – floating biplanes built in Philadelphia’s Navy Yard. Brassy tunes filled the air along a route where spectators were crushed together like sardines in a can. Each time the music stopped, bond salesmen singled out war widows in the crowd, a move designed to evoke sympathy and ensure that Philadelphia met its Liberty Loan quota…

Within 72 hours of the parade, every bed in Philadelphia’s 31 hospitals was filled. In the week ending October 5, some 2,600 people in Philadelphia had died from the flu or its complications. A week later, that number rose to more than 4,500. With many of the city’s health professionals pressed into military service, Philadelphia was unprepared for this deluge of death.

Attempting to slow the carnage, city leaders essentially closed down Philadelphia. On October 3, officials shuttered most public spaces – including schools, churches, theaters and pool halls. But the calamity was relentless. Understaffed hospitals were crippled. Morgues and undertakers could not keep pace with demand. Grieving families had to bury their own dead. Casket prices skyrocketed. The phrase “bodies stacked like cordwood” became a common refrain.

Smithsonian

Let’s hope this is a history lesson and not history repeating itself!

In another case of “let’s hope this is a history lesson”, Trump is calling for a military crack down almost exactly 50 years (May 1970) after the Ohio National Guard mowed down protestors with machine guns at Kent State.

how are people really getting coronavirus?

This blog post from a professor of epidemiology has some interesting logic. I don’t know this person, but they are a professor at a reputable university and I give their opinion some weight based on that. You can review their credentials and decide for yourself.

I took microbiology as a graduate student in environmental engineering, and I’ve done just a bit of microbial risk assessment since then. Which in no way qualifies me as an expert on covid-19. But this post did help me to think about some things harkening back to my classes, which are almost entirely absent from other media sources I am reading. In my classes and my professional work, there is a logic of dose response – you have to ingest a certain amount of material, and it has to contain a certain amount of a pathogen, for you to get sick. This usually has to do with small amounts of fecal matter present in the environment or water in my case, and the consequence typically is a bout of gastrointestinal distress curable with rest and fluids, although pretty much any disease is more dangerous to the very old, the very young, and the very sick.

That was a long preamble. You should read the blog post. But here is the brief summary:

  • If someone coughs or sneezes directly in your face, you are likely to get infected.
  • If you spend significant time indoors in a place where an infected person has recently coughed or sneezed, you are likely to get infected.
  • Other than that, you are not likely to get infected from someone breathing or even talking to you as you briefly pass on the street. You would need to talk to that person for at least 5-10 minutes to be likely to take in enough virus to get infected. That is just not very likely if you pass someone while walking, jogging, or biking. The advice of my local and state health departments is consistent with these facts. The behavior of people I observe in my neighborhood is not consistent with these facts. My behavior is consistent with these facts, even if other people in my neighborhood choose to have opinions that are not consistent with the known facts, and to try to impose those opinions on me.
  • Now, if you are indoors for awhile in a place where a lot of people are talking and breathing, and someone is infected, your odds of getting infected are high. This is why offices and schools are closed.
  • The bigger the crowd in the indoor space you are in, the more likely someone is infected. This is why conferences, religious services, sporting events, and Disney World are shut down.
  • So, people are getting infected when they have to be indoors around a lot of other people for a period of time, like in warehouses and meatpacking plants and unfortunately nursing homes. They are getting infected when they choose to attend large group events they don’t need to attend, like parades or worship services. And finally, they are getting infected when a family member goes out, gets infected, and brings it home.

plague lit

Wired has an article on science fiction novels involving plagues, and over at the New Yorker is a long article from the more literary genre (Steven King appears to have breached this category!).

Wired mentions:

  • three Neal Stephenson novels: Seveneaves, Anathem, and The Fall, or, Dodge in Hell
  • The Expanse (which I have heard great things about but probably won’t read because the show has spoiled it for me)
  • Mars Trilogy by Kim Stanley Robinson (who I recently learned is a dude. I read the first book, and liked it, but didn’t love it enough to read the other two. It is one of those books I find myself thinking about though.)
  • Ender’s Game (big fan)
  • The Moon is a Harsh Mistress (I’ve been burned out just a bit on Heinlein, but maybe I’ll give this one a chance at some point.)
  • William Gibson. No specific books, just William Gibson. (I like that I have read William Gibson, but I don’t )

The New Yorker mentions:

  • A Journal of the Plague Year by Daniel Defoe, 1722. (Yes, it’s about that plague. Also know as the plague.)
  • The Last Man by Mary Shelley, 1826.
  • Oedipus Rex (mentions the plague apparently)
  • Angels in America (yes, AIDS counts as a plague, complete with a long incubation time, asymptomatic transmission, initial government denial and botched response, and eventual development of more effective treatments, although there is still no vaccine or absolute cure.)
  • The Masque of the Red Death by Edgar Allen Poe, 1842.
  • The Scarlet Plague by Jack London, 1912. (sort of a sequel to the Poe story, apparently)
  • The Plague by Albert Camus, 1947. (I didn’t realize Camus was that recent, but that is just me being ignorant.)
  • Blindness by Jose Saramago, 1995. (“brilliant” according to the New Yorker, but just sounds too depressing for right now.)
  • And of course, The Stand.

The science fiction book I keep thinking about though, which is not on either list, is Robots of Dawn by Isaac Asimov. In Robots of Dawn, life on Earth is nasty, brutish and short. But there is a race (of humans) who have moved to space, and they live hundreds of years in part by avoiding virtually all physical contact with each other. They can do this because the human population is very low on a large planet, robots do all the work, and they have excellent video conferencing facilities. Humans basically never come into close physical proximity, with the one exception that husbands and wives get together only for the purpose of making babies, which is surprising because you would think a futuristic civilization where robots do all the work would have discovered in vitro fertilization. At the very least, you could send a robot over to your wife’s place with a turkey baster full of…well, you get the idea.

I’m thinking about a 2020 summer reading theme. I don’t think I want a plague theme! I could do worse than dig into some Neal Stephenson novels I’ve missed. I could always go back and read some Edgar Allen Poe. I’ve never read The Stand, so maybe.

ferrets and coronavirus

Ferrets are highly susceptible to coronavirus. Apparently, ferrets are susceptible to similar respiratory diseases as humans in general and are used in research for that reason. Cats are also susceptible, but dogs and farm animals generally aren’t.

If this were a movie, humans would eradicate the virus but it would persist in a small community of feral cats somewhere, mutate into something even more horrible, and jump back to humans.

more from Bill Gates on coronavirus

You can still decide for yourself if Bill Gates is someone we should listen to on coronavirus. But he sounds cautiously optimistic, at least when it comes to developed Asia and the U.S.

[Someone asking Bill a question on Reddit: ]I read the Imperial College COVID-19 Response Team report as well as this explanation in a historical context. Essentially, it says that by doing nothing, 4 million Americans die. Through the mitigation strategy—i.e. social distancing and “flattening the curve”— it says that 1.1-2 million Americans will die. However, it also says that the suppression strategy, or shutting everything down for 18 months”—will lead to only a few thousand people dying...

[Bill’s answer: ]Fortunately it appears the parameters used in that model were too negative. The experience in China is the most critical data we have. They did their “shut down” and were able to reduce the number of cases. They are testing widely so they see rebounds immediately and so far there have not been a lot. They avoided widespread infection. The Imperial model does not match this experience…

China is seeing very few cases now because their testing and “shut down” was very effective. If a country does a good job with testing and “shut down” then within 6-10 weeks they should see very few cases and be able to open back up…

Gates Notes

more coronavirus tracking

This massive data analysis entry from Our World in Data is a pretty good example of how to take a data set and beat the crap out of it from every angle.

I like what they did. Since it’s by country, it allows interesting comparisons across countries but is not meant to provide local or regional-specific information. Countries are pretty big. My favorite trackers that are most relevant to my situation are still the City Observatory analyses of U.S. metro areas and the University of Washington simulations of available hospital capacity. The latter are by state.

an immunity test for Covid?

This article raises the possibility that maybe an immunity test for Covid-2 could be rolled out faster than a vaccine. The concept is that people who have had the disease and recovered, thereby developing some immunity (which is still being studied and not 100% confirmed that it is long-lasting), could be identified and allowed to resume their normal routines before people who have not been exposed and/or are at high risk.

March 2020 in Review

To state the obvious, March 2020 was all about the coronavirus. At the beginning of the month, we here in the U.S. watched with horror as it spread through Europe. We were hearing about a few cases in Seattle and California, and stories about people flying back from Italy and entering the greater New York area and other U.S. cities without medical screening. It was horrible, but still something happening mostly to other people far away on TV. In the middle of the month, schools and offices started to close. By the end of the month, it was a full blown crisis overwhelming hospitals in New York and New Jersey and starting to ramp up in other U.S. cities. It’s a little hard to follow my usual format this month but I’ll try. Most frightening and/or depressing story:
  • Hmm…could it be…THE CORONAVIRUS??? The way the CDC dropped the ball on testing and tracking, after preparing for this for years, might be the single most maddening thing of all. There are big mistakes, there are enormously unfathomable mistakes, and then there are mistakes that kill hundreds of thousands of people (at least) and cost tens of trillions of dollars. I got over-excited about Coronavirus dashboards and simulations towards the beginning of month, and kind of tired of looking at them by the end of the month.
Most hopeful story:
  • Some diabetics are hacking their own insulin pumps. Okay, I don’t know if this is a good thing. But if medical device companies are not meeting their patient/customers’ needs, and some of those customers are savvy enough to write software that meets their needs, maybe the medical device companies could learn something.
Most interesting story, that was not particularly frightening or hopeful, or perhaps was a mixture of both:
  • I studied up a little on the emergency powers available to local, state, and the U.S. federal government in a health crisis. Local jurisdictions are generally subordinate to the state, and that is more or less the way it has played out in Pennsylvania. For the most part, the state governor made the policy decisions and Philadelphia added a few details and implemented them. The article I read said that states could choose to put their personnel under CDC direction, but that hasn’t happened. In fact, the CDC seems somewhat absent in all this other than as a provider of public service announcements. The federal government officials we see on TV are from the “Institute of Allergies and Infectious Diseases”, which most people never heard of, and to a certain extent the surgeon general. I suppose my expectations on this were created mostly by Hollywood, and if this were a movie the CDC would be swooping in with white suits and saving us, or possibly incinerating the few to save the many. If this were a movie, the coronavirus would also be mutating into a fog that would seep into my living room and turn me inside out, so at least there’s that.
https://www.youtube.com/watch?v=4chSOb3bY6Y