COVID-19 - Filters

The Filters tab of the COVID-19 data plotter provides a number of features to help users use the data to answer various questions.

This page provides a basic tutorial.

An Example | Selected Sites | Filters | Negative Daily Counts


An Example

How many counties have had fewer than n-cases or deaths?

To visualize this, press the Clear All button before pressing the Select button. Unselected markers are red - selected markers are green.

A similar procedure can be used to determine cases per day - 2999 counties have had fewer than 5 new cases in a single day, and only 8 have had more than 100.


Selected Sites

The map displays a marker for every site in the current dataset. Many features, such as Heatmap Animations and Aggregate Plots, operate on the selected sites.

When the application begins, all the sites are selected so that a lot of functions will work right away. However, the user has the ability to select, and deselect, sites using various tools.

The most obvious are the Select all and Clear All buttons. These are both below the map and duplicated on the Filters tab. When either Clear All button is pressed, the display mode (normally controlled via the Color Keys tab) is automatically changed to Selections .

There are 4 options below the map - Add, Remove, Single site, Region - that control how the mouse affects the selections. Holding the shift key while clicking reverses the Add/Remove action.

Selections and deselections can also be made using the Search by Name controls.

Search parameters in the url can control the selections when the application starts.


Filters

The filters (on the Filters tab - duh) provide another way to change the current selection. The example at the top of this page showed several examples. The next has another.

By using the Range, you can select a specific day, week, or month. These values are indices (because they are easier to implement using existing components) and are displayed as days (in another field) as the values change. The default minimum is 15 Feb 2020 (index 24) for no particular reason, the default maximum is in the far future so it won't need to be adjusted for each new dataset.

You can start with everything selected and remove sites meeting some criteria, or with nothing selected and add sites.

The provided data (from Johns Hopkins) is cumulative - the numbers just get bigger (except for when they don't - see the next section). However, the application can search (and display) both the cumulative and the daily values.

There are 181 global sites (26 US states, 2003 US counties) where the slope between April 4 and 22. (80 and 91) is less than or equal to zero. This is good - it shows that we are recovering.
To get this, use daily slope is <= 0 with a range of 80 to 91. If a range maximum of 200 is used (the default), the results will change everyday as new data becomes available.


Negative Daily Counts

When analyzing US States and Regions, as of 22 April 2020, 11 report at least one day with a negative count. The fact that there are negative results indicates a problem with the data. Using the provided filters, these anomalies are very easy to find.

Details

When doing statistical analysis, errors of this sort can cause significant problems.

The application computes these values by summing the values provided for individual counties. If for some reason a county reports a lower value than the day before, then these anomalous values will appear. Sometimes, missing data is reported as zero. Using the filter function on 04-23-20, there were 880 (out of 3104) counties that had at least one negative daily value. Obviously, the reporting criteria for a (supposedly) monotonically increasing quantity varies quite a lot. (As of 04-25-20, there were 990.)


Author: Robert Clemenzi
URL: http:// mc-computing.com / Science_Facts / COVID-19 / Filters.html