July Madness (imaginary sports imaginary update plus brief COVID-19 update CXIII)

The first casualty of COVID-19 in the American sports world was the cancellation of the 2020 NCAA men’s basketball tournament. “March Madness” is one of the joys of the American sports calendar, and this year, it was gone.

Five Duke basketball players take the court
Aw crap, not these guys again (the 2020 Duke men’s basketball team)

I decided to take up the challenge and simulated the entire 2020 tournament – from announcing the teams to playing the final. Sadly, Duke won. And then I had an even better idea.

The NCAA Cup is the college basketball tournament for everyone, designed after European soccer tournaments like England’s FA Cup. Every team qualifies. At the beginning of each round, all matchups for that round are selected randomly.

I simulate each game on the whatifsports.com college basketball simulator, and announce the results in real time on Twitter at @fixthemadness.

Winners advance to the next round, and the process repeats until one team wins it all. The NCAA Cup has been going on since early April. I’ve given an update once before, but now it’s time for a more thorough update.

Rounds 1 and 2 are in the books, and round 3 has just started. I won’t cover everything here, but you can see the full and complete results on my NCAA Cup page.

Round 1

A Naval Academy basketball player attempts a shot
This is probably what it looked like when Navy won the play-in game

Round 1 began with the play-in game on April 7th, the day after Duke won the imaginary 2020 NCAA tournament. Because there were an odd number of teams (351), two teams were randomly selected for a play-in game Navy upset Virginia Commonwealth to advance to the first round proper, along with every other team.

Each of the 350 remaining teams was randomly paired one against another, and the home team for each was selected randomly too. That made 175 games, which were played between April 9th and May 31st.

The games in round 1 proper went mostly as expected, with a few minor upsets. Nebraska beat Oklahoma in Norman, LSU won at highly-ranked Penn State, Missouri beat Texas in Austin. No great surprises – until there was.

On May 9th in Las Vegas, UNLV shocked overall number one seed Gonzaga 82-71, behind 27 points by sophomore guard Bryce Hamilton. The Runnin Rebels’ tight defense held Gonzaga’s star power forward Filip Petrusev to just 15 points. Gonzaga, which had come into the Cup as the favorite to win it all, was knocked out at the first stage. It was an upset on par with UMBC’s win over Virginia in 2018.

I wish I had video of the UNLV’s win over Gonzaga, but it was imaginary. It probably looked like this, though.

The last first round game was held on May 31st at 10 PM ET, when Lamar beat Washington State 90-81.

Some facts about the first round:

The 175 first round winners advanced to the second round.

Round 2

Once again there were an odd number of teams (175), so a play-in game was required. In the play-in game, Radford beat Toledo. Radford, along with the rest of the round 1 winners, advanced to the second round. Once again, all the matchups and home teams were chosen randomly.

A tall white guy in a number 55 Iowa Hawkeyes basketball uniform
This is probably what it Luka Garza looked like after his team lost to Central Arkansas

The second round proper began with another titanic upset. Iowa, ranked #34 in the NET rankings and led by All-American center Luka Garza, lost the first game to #315 Central Arkansas in overtime. Rylan Bergersen had 21 points for the Bears, and Hayden Koval had 16 points and 15 rebounds.

The next day, in a matchup of top 10 teams, Louisville beat Florida State 72-68. The rest of the second round went mostly as expected, until…

Remember UNLV? In the first round, they pulled off a stunning upset, knocking off top seed Gonzaga. In the second round, the same thing happened to them, as the Runnin’ Rebels lost on the road to the #302 team in the NET rankings, the Longwood Lancers. Jaylon Wilson scored 16 points for the Lancers, who won 65-55.

Some facts about the second round:

The 87 second round winners advanced to the third round.

Round 3

There were 87 winners of round 2 – one again an odd number, so once again a play-in game. East Tennessee state beat Oakland in the play-in game to advance to round 3 proper.

And that’s where we are now! One great game has been played already: #8 Louisville followed up its second round win over Florida State with a third round upset of #2 Kansas.

For the full list of round 3 matchups, see the NCAA Cup page. I won’t list them all here, but here are some of the most interesting games coming up:

Date and TimeMatchup
Saturday July 11th at 8 PM (#302) Longwood at (#44) Virginia
Friday July 17 at 8 PM(#22) Texas Tech at (#7) Michigan State
Saturday July 18th at 8 PM(#49) Saint Louis at (#36) East Tennessee State
Sunday July 19th at 8 PM(#16) Ohio State at (#4) San Diego State
Tuesday July 21st at 8 PM(#39) Illinois at (#52) Notre Dame
Thursday July 23rd at 8 PM(#295) McNeese State at (#6) Duke
Schedule of some of the most anticipated games of round 3

Who will win it all? The championship game is on Saturday, August 29th. Join us every step of the way at @fixthemadness!

Quick COVID-19 update

Lastly, a quick update on COVID-19 cases around the world and in New York State.

Graphs day 113, pandemic day 120, day 190 since the first cases were diagnosed.

Total cases of COVID-19 diagnosed worldwide: 11,829,602

Total deaths: 544,163

Here is the graph of countries where the epidemic is getting worse:

Countries where the COVID-19 epidemic is getting worse: number of cases reported per day vs. time. Labels show deaths per million people.

Things do seem to be getting better is Sweden. But they’ve fooled me before; let’s hope it’s for real this time? If the downward trend continues for another two days, I’ll move Sweden to the “headed in the right direction” category.

You know who’s not getting better? The United States and South Africa.

Lastly, I discovered I made a mistake in yesterday’s graph of cases in different parts of New York – my case fatality rates were wrong. The corrected graph, including data for today, is shown here. I’ll update yesterday’s post with the correct graph as well.

Cases per million people per day in three regions of New York state: New York City, Westchester County, and the rest of the state

NCAA Cup updates throughout the third round and beyond. COVID-19 updates until the end of the pandemic or until I lose my mind.

Counting the counties (COVID-19 daily data update CXII)

Graphs day 112, pandemic day 119, day 189 since the first cases were diagnosed.

Total cases of COVID-19 diagnosed worldwide: 11,620,096

Total deaths: 538,058

Today is independence day in the Solomon Islands, but there are NO CASES of COVID-19 in the Solomon Islands – one of the few places in the world to remain completely free of this new disease. Sounds like a good opportunity to take a closer look at cases in the United States.

Cases in the U.S. overall

Total cases of COVID-19 diagnosed in the United States: 2,936,077

Total deaths: 130,285

Here is how the number of cases reported per day has changed in the U.S. over the course of the epidemic:

Cases reported per day in the U.S. The light blue line shows actual cases; the brown line shows the overall trend (10-day moving average smoothing)

We had this pandemic under control. Cases were steadily decreasing from early April through mid-June. And now the U.S. COVID-19 epidemic is worse than it has ever been.

Cases by state

Here’s the map of the total number of cases reported from the beginning of the epidemic in the 50 U.S. states (excluding territories, which is why the total number looks a bit different).

Total cases by state (click for a larger version)

The total amounts shown on the map above show the total impact of the epidemic in the U.S. from the beginning. Another way to look at the cases reported yesterday, giving us an idea of the state of the epidemic right now. Notice which states are experiencing the most cases right now. How is this map different from the map of total cases above?

Cases reported yesterday (July 6, 2020) by state. Click for a larger version.

Yet another way to look at the progress of the epidemic is to look at how the rate of cases has changed since the pandemic reached the U.S. in early March. Plotting all fifty states on a single graph would look like a plate of spaghetti, so how can we create a clean graph that displays as much useful information as possible?

After doing a lot of data exploring, I found a few different patterns that states have followed over the course of the epidemic. I chose one representative from each pattern and displayed them on one graph. The result is a graph of cases in seven key states around the country: Arizona, California, Florida, Louisiana, Maryland, New York, and Ohio.

Here is the graph, with all our usual formatting and labeling (“dpm” means “deaths per million people”):

Cases in each state over time. Click for a larger version.

The pandemic seems to be well-controlled in New York and Maryland. Cases are increasing in Ohio and California, but they remain at a fairly low level for now. Meanwhile, cases in Arizona, Florida, and Louisiana continue to increase quickly.

Cases by county: one example

I’ll close today’s update with a first look at something a new dataset will bring us a lot of exciting insights as we go: cases by county. We can take a much closer look what’s going on from place to place.

As a teaser for what the new county data will allow us to do, consider a question: what does “cases in New York” mean? New York State is a big and diverse place, including everything from Manhattan to small north country towns like Watertown. Looking as “cases in New York,” like we did above, compresses all those diverse places into one graph.

But now:

Cases per million people per day in three regions of New York state: New York City, Westchester County, and the rest of the state

Using the county data, I divided cases in New York State into three regions. The graph is plotted on “Qatar scale” (zero to 700 cases per million people), BUT Westchester County goes off that scale. The inset map goes up to 1,000 cases per million people.

There are so many other exciting things we can do with the county-level data. What would you like to see?

Want to try out some of these graphs for yourself? You can get the data that I used to make the country graphs from Johns Hopkins University’s Center for Systems Science and Engineering (CSSE) COVID-19 data site. Click on csse_covid_19_data, then on csse_covid_19_time_series, then download all the CSV files. Or clone the whole repository in GitHub.

You are welcome and encouraged to use my Excel templates. They’re now at version 5.1, and I have two separate templates: a global data template and a U.S. state data template.

Update tomorrow, and every day after that until this pandemic comes to an end or I lose my mind.

Update from the tree lobster (Daily COVID-19 data update CXI)

Graphs day 111, pandemic day 118, day 188 since the first cases were diagnosed. If you haven’t seen my other post today, learn the fascinating and beautiful story of the tree lobster.

Very quick update today, just with total case numbers and one updated graph.

Total cases of COVID-19 diagnosed worldwide: 11,449,707

Total deaths: 534,267

Today is independence day in the southern African nations of Comoros and Malawi. Fortunately, there are not many cases of COVID-19 in either country.

Usual graph style: each country is color-coded and labeled, labels include total deaths per million people from the beginning, label sizes and line thicknesses represent the case fatality rate.

Countries where the epidemic is still getting worse (click for a larger version)

Tomorrow is independence day in the Solomon Islands, so I’ll definitely report on cases there, but I might do graphs of U.S. states instead. What’s your preference: states or countries?

And meanwhile, I’m starting to look at cases by U.S. county, which will let us ask questions like “how bad is the epidemic in Upstate New York compared to New York City?,” and “what is the correlation between medium-scale population density and number of cases?” That’s going to be fun, updates soon.

Want to try out some of these graphs for yourself? You can get the data that I used to make the country graphs from Johns Hopkins University’s Center for Systems Science and Engineering (CSSE) COVID-19 data site. Click on csse_covid_19_data, then on csse_covid_19_time_series, then download all the CSV files. Or clone the whole repository from GitHub.

You are welcome and encouraged to use my Excel templates. I’ve tinkered enough that I’m plus-plusing the version to 5.1. I have two separate templates: a global data template and a U.S. state data template.

Update tomorrow, and every day after that until this pandemic comes to an end or I lose my mind or scientists find me hiding under a tea tree bush on Ball’s Pyramid.

Jolly good news! (Daily COVID-19 data update CX)

Four Cape Verdean-American teenagers riding on the back of a truck waving American and Cape Verdean flags. Cape Verde's flag is blue with thin white-red-white stripes about 2/3 of the way down, and a circle of 10 yellow stars representing the 10 islands.
Viva Cabo Verde!
A street parade celebrating Cape Verdean independence, July 5, 2019 in New Bedford, Connecticut
(photo credit: South Coast Today)

Graphs day 110, pandemic day 117, day 187 since the first cases were diagnosed.

Yesterday was U.S. Independence Day, so I showed you an update of U.S. cases. Today is Independence Day in both Algeria and Cape Verde, so we’re back to the global data, and I’ll include those two countries, just for today. Never forget that other people love their countries just like you love yours.

And never forget that people are dying of COVID-19 all over the world.

Total cases of COVID-19 diagnosed worldwide: 11,267,309

Total deaths: 530,754

Worldwide cases and deaths

The number of daily cases (blue line below) continues to go up in a jagged curve. Smoothing the curve to remove the day-to-day variations (with a 10-day moving average smoothing) shows the general upward trend. Four months into the global pandemic, and things are still going to get worse before they get better.

Cases of COVID-19 reported each day worldwide. The blue line is the actual reported number of cases; the red line is the smoothed number of cases (10-day moving average smoothing), showing the overall trend. Click for a larger version.

We are still on pace to hit 600,000 deaths worldwide in about two weeks. The global case fatality rate is at about 4.7 percent.

Cases and deaths by country

Two countries have changed categories today – and both in the right direction! Another appears to be on track to changing in the wrong direction. Algeria and Cape Verde are temporary additions, and I’ve temporarily removed India.

India continues its mercifully slow upward trend. Considering India’s high population density, it could be so, so much worse. Whatever the Indian government and people are doing to slow the spread, it’s working. Be like India.

Countries where COVID-19 was quickly contained

Usual graph style for all today’s graphs: each country is color-coded and labeled, labels include total deaths per million people from the beginning, label sizes and line thicknesses represent the case fatality rate.

Countries that quickly contained their COVID-19 epidemics (click for a larger version)
Captain Picard does an unprecendented two-handed facepalm
Captain Picard hears about the cause of the new outbreak in Australia

Sadly, look at Australia. A new outbreak has begun in the most Australian manner possible: travelers to Australia were being held in quarantine at a Melbourne hotel, and the security guards enforcing the quarantine were having sex with the quarantined guests.

That might be funny, but only if no one dies in this new outbreak. I’m going to say that if Australia reaches 6.8 cases per million people (half their peak rate from late March), I’ll move them to the “getting worse” category, but sadly it’s likely a matter of when, not if.

Countries where COVID-19 is now under control

Now that the case rate in the United Kingdom has fallen to 5.5 cases per million, the UK gets to move into the under control category.

Countries where COVID-19 is currently under control (click for a larger version)

As they say there: jolly good news!

Countries that are headed in the right direction(-ish)

More good news here: not only has Chile moved into the “moving in the right direction” category, they have also un-Qatared themselves back on to the main graph, with fewer than 200 new cases per million Chileans.

Countries where newly-reported cases per million people are steady or decreasing (click for a larger version)

As they say there, so fast that I would find even other Spanish speakers would find it incomprehensible: ¡Gracias a Diós, que siga!

Countries where the epidemic is getting worse

The usual countries are still here, and today also birthday countries Algeria and Cape Verde. Tomorrow is Independence Day in Comoros and Malawi.

Countries where the epidemic is still getting worse (click for a larger version)

Cases are increasing quickly in the USA, South Africa, and Serbia. And Brazil is about to go off the chart. As they say there, f*da-se Bolsonaro!

Lastly, as I say here on this blog:

Want to try out some of these graphs for yourself? You can get the data that I used to make the country graphs from Johns Hopkins University’s Center for Systems Science and Engineering (CSSE) COVID-19 data site. Click on csse_covid_19_data, then on csse_covid_19_time_series, then download all the CSV files. Or clone the whole repository from GitHub.

You are welcome and encouraged to use my Excel templates. I’ve tinkered enough that I’m plus-plusing the version to 5.1. I have two separate templates: a global data template and a U.S. state data template.

Update tomorrow, and every day after that until this pandemic comes to an end or I lose my mind or ABIN finds this blog.

Data Fireworks (COVID-19 data update CIX)

Graphs day 109, pandemic day 116, day 186 since the first cases were diagnosed. Today, Earth has passed 11 million total cases of COVID-19.

Total cases of COVID-19 diagnosed worldwide: 11,074,878

Total deaths: 525,121

Happy Fourth of July! In honor of U.S. Independence Day, we’ll take a closer look at the pattern of cases and deaths in the United States.

Total cases of COVID-19 diagnosed in the United States: 2,794,153

Total deaths: 129,434

Here’s the map of the total number of cases reported from the beginning of the epidemic in the U.S. This is total numbers rather than per capita, so naturally the larger states show more cases. The slight difference in the total is due to the fact that the number above includes the U.S. territories of Puerto Rico, Guam, the Virgin Islands, and the Northern Mariana Islands (American Samoa has had no cases).

Total cases by state (click for a larger version)

The total amounts shown on the map above show the total impact of the epidemic in the U.S. from the beginning. Another way to look at the cases reported yesterday, giving us an idea of the state of the epidemic right now. Notice which states are experiencing the most cases right now. How is this map different from the map of total cases above?

Cases reported yesterday (July 3, 2020) by state. Click for a larger version.

Three days ago, I showed, for the first time, graphs of cases over time in the U.S., in the style of the global graphs I’ve been making all along. I described several categories of states and showed two graphs: states where cases peaked early in the epidemic, and states where cases were low at the beginning, but where the epidemic has been getting worse quickly recently. I had shown several states in each category, which resulted in very complicated graphs.

I realized it would be clearer to show just one or two states in each category. And so – note that these numbers *are* per million people:

Cases in each state over time. Click for a larger version.

I showed a state that peaked in early April (New York), a state that peaked in May (Maryland), two states that have gotten much worse (Florida and Arizona), a state that started bad and is getting worse (Louisiana), and a state that has stayed fairly low throughout (Ohio).

One state I haven’t shown on this graph is the Granddaddy of Them All, California. The curve for California follows that of Ohio, but at a slightly higher level. I’ll keep an eye on California as we go, and show them on future graphs.

Want to try out some of these graphs for yourself? You can get the data that I used to make the country graphs from Johns Hopkins University’s Center for Systems Science and Engineering (CSSE) COVID-19 data site. Click on csse_covid_19_data, then on csse_covid_19_time_series, then download all the CSV files. Or clone the whole repository in GitHub.

You are welcome and encouraged to use my Excel templates. They’re now at version 5, and I have two separate templates: a global data template and a U.S. state data template.

Update tomorrow, and every day after that until this pandemic comes to an end or I lose my mind.