COVID19 cases per hospital bed

May 1st graph updates wrt. the coronavirus pandemonium. Here I’m plotting bubble sizes proportional to the number of SARS-CoV-2 cases per total hospital beds in a county, and coloring by log cases per county.

COVID19 cases per hospital bed

Here is basically the same graph, after switching the color and size axes: bubble sizes are now proportional to the sqrt(cases) in a county, and color represents the number of cases per bed.

Let’s check in with NYC and see how it’s fairing compared to the rest of the US…

Lastly I’ve generated a log-log plot of cumulative vs. daily cases and deaths. Ultimately we want the daily cases and deaths to drop significantly, so when things start going very well, there should be a dramatic drop along the y-dim (particularly for the deaths graph, since daily cases might indicate a ramping-up of testing, which I’d consider a good thing). As of May 1st, things look promising, but this battle is certainly not over. At least, however, it looks like the physical distancing tourniquet has greatly attenuated the exponential growth.

2019-nCOV Data Visualizations

FeaturedEuropean Coronavirus

Here I will be adding data visualizations (both found and original) depicting facets of the 2019/2020 coronavirus pandemic.

Let’s start with one found on https://coronavirus.1point3acres.com showing how the cumulative number of confirmed COVID19 cases in each state has evolved over time.

This shows pretty clearly the situation in New York is dire, but I wouldn’t be surprised if California starts to close the gap.

Here is a similar graph, for each country

Here is a data viz I made using ERIS ArcGIS…

The best covid19 dashboard I’ve found belongs to the group at Johns Hopkins University…

One way we might be able to predict which U.S. counties will be disproportionately affected by the coronavirus pandemic is whether there are enough hospitals (specifically hospital beds) in those regions to accomodate the number of people expected to become infected with COVID-19.

Using data compiled from the CDC, Johns Hopkins University, and the NYT databases…

… I’ve generated a map of the location of U.S. hospitals. Each dot is a hospital. The size of the dot is proportional to the number of beds each hospital contains. Each dot is colored according to how many beds there are per 1000 people in the county. Such a map might help reveal areas with a low number of hospital beds per service population.

(full MATLAB code tutorial here)

Here is another plot similar to the one above. In this one…

  • Dot size == total number of hospital beds in a given county
  • Dot color == log(Cases) in that county

This next graph shows U.S. COVID-19 related hospitalizations over time, broken down by age group. The y-axis represents the number of infections per 100,000 people.

Plotting the location of every U.S. hospital using MATLAB Mapping Toolbox

FeaturedU.S. Hospital Locations

Given the current COVID-19 pandemic, one major question is will we have enough medical resources to handle those who need treatment. In order to make predictions about the nCOV sequelae, one key piece of information is the number of U.S. hospitals, and where they are located.

I’ve put a copy of this dataset here: https://bit.ly/UShospitals

After importing the data the MATLAB, we simply need to pass the latitude and longitude data into the mapping toolbox. We will use a method that draw circles of a given size, centered at each lat/lon provided.

Hospitals in the U.S.

This looks pretty good from this level of zoom, but you will find out upon zooming in that map overlays that draw polygons that (for good reason) don’t resize when you zoom in and out…

You can however plot locations using pins, which will resize based on the current zoom level. Here is an example of that code:

Pins indicate the location of U.S. hospitals

Proposition 22 – and how AB2257 didn’t fix the issues with AB5 that needed to be fixed

A comment found on HN:

It was not a law that put us in this position, it was the Supreme Court of California. In any case, AB2257 fixes the issues with AB5 that needed to be fixed.

hacker guy

How did AB2257 fix the issues with AB5 that needed to be fixed? I’m genuinely curious. From what I’ve read it still boils down to the interpretation of the “ABC Test“.

For those unfamiliar with the ABCs…

The provisions of AB 2257 sets forth the ABC Test in statute. The statutory ABC Test codified the language used by the state Supreme Court in its Dynamex decision. “A person providing labor or services for remuneration shall be considered an employee rather than an independent contractor unless the hiring entity demonstrates that all of the following conditions are satisfied:

  • A. The person is free from the control and direction of a hiring entity in connection with the performance of the work, under the contract for the performance and in fact.

  • B. The person performs work outside a hiring entity’s usual course of business.

  • C. The person is customarily engaged in an independently established trade, business, or occupation of the same nature as the performed work.

Let’s apply the ABC test to an Uber Driver (Umar); and for comparison a violinist (Viola, ironically) who is often hired by Joel Nelson Bay Area wedding Productions (JNP) [joelnelson.com/weddings].

The person is free from control and direction of the hiring entity for the performance of the work


Umar is given the location of the pickup, and the dropoff destination. The Uber app suggests pickup and dropoff routes, however Umar has some flexibility on which routes he takes, how fast or careful he drives, how chatty he is, the cleanliness of his vehicle, and any ‘extras’ (e.g. phone charger) he provides.

Viola is given the location of the venue and a list of songs to play. She has some flexibility in the specific musical arrangements of those songs, and her performance. Ultimately she is trusted to show up on time and play, to her ability, the requested songs.

The person performs work outside a hiring entity’s usual course of business.


Umar provides transportation/taxi services. Uber will claim they are not a ‘transportation’ company, but a software company that caters to the vehicle-for-hire, food delivery, courier/freight & package delivery industries. They will claim programmers and IT specialists fall within their ‘usual course of business’, not vehicle drivers. Nevertheless, to the customer, it seems like Uber provides transportation services.

Viola provides musical performance services. JNP will claim they are not a musical performance company, but a wedding & event planning agency. Nevertheless, JNP offers wedding music and entertainment right on their website (“String quartets, variety bands, experienced and diverse Disc Jockeys and MC’s, specialty lighting and photography packages, and more… Joel Nelson Productions has the right plan at the right price to make your wedding dreams a reality.“)

The person is customarily engaged in an independently established trade of the same nature


Umar mostly drives for Lyft. He only gives Uber rides on weekends.

Viola has a full-time job as an accountant. She only does violin gigs on some weekends. She only gigs through JNP.

Who is an employee and who is a contractor? Seems like Viola would be classified as an employee, because doesn’t fulfill requirement ‘C’. All three of these stipulations are not very concrete, open to many interpretations and arguments, and thus not a very good law.

In my humble opinion, good laws are clear, concise, and concrete (the 3 Cs). So, instead of the ABCs, here’s my attempt to draft a C3 law with similar intent: Someone shall be classified as an employee (not an independent contractor) if they…

C1: have performed services for company C over W weeks

C2: work for company C more than H hours per week

C3: perform this work as their primary source of income