Covid19

 

Release Notes

1.3.12 (July 5th, 2020)

  • New data for 6/27 through 7/4, loaded from JHU CSSE and covidtracking.com (US testing data)

1.3.11 (June 27th, 2020)

  • New data for 6/25 through 6/26, loaded from JHU CSSE and covidtracking.com (US testing data)

1.3.10 (June 24th, 2020)

  • New data for 6/21 through 6/23, loaded from JHU CSSE and covidtracking.com (US testing data)

1.3.9 (June 21st, 2020)

  • New data for 6/16 through 6/20, loaded from JHU CSSE and covidtracking.com (US testing data)

1.3.8 (June 16th, 2020)

  • New data for 6/15, loaded from JHU CSSE and covidtracking.com (US testing data)

1.3.7 (June 15th, 2020)

  • New data for 6/12, 6/13 and 6/14, loaded from JHU CSSE and covidtracking.com (US testing data) and Aura Vision (lockdown dates)

1.3.6 (June 12th, 2020)

  • New data for 6/9, 6/10 and 6/11, loaded from JHU CSSE and covidtracking.com (US testing data)

1.3.5 (June 9th, 2020)

  • New data for 6/6, 6/7 and 6/8, loaded from JHU CSSE and covidtracking.com (US testing data)

1.3.4 (June 6th, 2020)

  • New data for 6/04 and 6/05, loaded from JHU CSSE and covidtracking.com (US testing data)
  • the us_counties view created in 1.3 was accidentally never committed, so that is now actually shipping. 🙁

1.3.3 (June 3rd, 2020)

  • New data for 6/02 and 6/03, loaded from JHU CSSE and covidtracking.com (US testing data)

1.3.2 (June 1st, 2020)

  • New data for 5/29 through 6/01, loaded from JHU CSSE and covidtracking.com (US testing data)

1.3.1 (May 28th, 2020)

  • Added new Y-axis options – new tests administered, and new positive tests
  • resolved some recently created CSS layout problems with the header on the main page
  • New data for 5/28 loaded from JHU CSSE and covidtracking.com (US testing data)

1.3 (May 27th, 2020)

  • Moved “US Counties” out to its own page and reworekd it to leverage postprocess better. Bottom line – you can now change the selected counties and even change the y-axis option without re-dispatching the entire search
  • Added new data for the populations of all US counties. This allowed a new y-axis options in the “US Counties” page, for Total Confirmed Cases by % of population
  • New data for 5/25 and 5/27 and loaded from JHU CSSE, covidtracking.com (US testing data) and Aura Vision (lockdown dates)

1.2.2 (May 25th, 2020)

  • New data for 5/24 loaded from JHU CSSE and covidtracking.com (US testing data)

1.2.1 (May 23rd, 2020)

  • New data for 5/22 and 5/23 loaded from JHU CSSE and covidtracking.com (US testing data)

1.2 (May 21st, 2020)

  • Added buttons to the main tab with which the user can launch the Job Inspector, export results as csv, or print the page.
  • New data for 5/21 loaded from JHU CSSE and covidtracking.com (US testing data)

1.1.14 (May 20th, 2020)

  • New data for 5/20 loaded from JHU CSSE and covidtracking.com (US testing data)

1.1.13 (May 19th, 2020)

  • New data for 5/19 loaded from JHU CSSE, covidtracking.com (US testing data) and Aura Vision (lockdown dates)

1.1.12 (May 18th, 2020)

  • New data for 5/18 loaded from JHU CSSE and covidtracking.com (US testing data)

1.1.11 (May 17th, 2020)

  • Fixed a bug where if you didn’t normalize the _time axis it would give you one bucket per month instead of one per day
  • New data for 5/16 and 5/17 loaded from JHU CSSE and covidtracking.com (US testing data)

1.1.10 (May 16th, 2020)

  • New data for 5/15 loaded from JHU CSSE and covidtracking.com (US testing data)

1.1.9 (May 14th, 2020)

  • New data for 5/14 loaded from JHU CSSE and covidtracking.com (US testing data)

1.1.8 (May 13th, 2020)

  • reordered the y-axis options, partly to improve organization but also to make the “remaining patients sick” option not
    be the default any longer.
  • Moving the logarithmic axis primer into the notes section since log axes are no longer the default and since they’re only enabled for a couple of the y-axis options.
  • New data for 5/13 loaded from JHU CSSE and covidtracking.com (US testing data)

1.1.7 (May 12th, 2020)

  • Modified the Logarithmic axis option within the US Counties tab to disable and hide itself if statistics are selected for which it makes no sense. This matches the same fairly longstanding behavior in the main tab.
  • New data for 5/12 loaded from JHU CSSE and covidtracking.com (US testing data)

1.1.6 (May 11th, 2020)

  • New data for 5/10 and 5/11 loaded from JHU CSSE and covidtracking.com (US testing data)

1.1.5 (May 9th, 2020)

  • “US Counties” tab – Performance improvements.
  • “US Counties” tab – Added new y-axis options of “deaths – per day” and “cases – per day”
  • “US Counties” tab – removed the “remaining patients sick” and “patients who have recovered”. Since the recovered stats are generally not very well reported at the county level, these were misleading.
  • Added new y-axis options to the main tab – “tests – total tests administered” and “tests – percent testing positive”
  • New data for 5/9 loaded from JHU CSSE and covidtracking.com (US testing data)

1.1.4 (May 8th, 2020)

  • A little cleanup in the search that feeds the CheckboxPulldown for countries/provinces/states, roughly halving the render time for those options
  • New data for 5/8 loaded from JHU CSSE and covidtracking.com (US testing data)

1.1.3 (May 7th, 2020)

  • New data for 5/6 loaded from JHU CSSE and covidtracking.com (US testing data)

1.1.2 (May 6th, 2020)

  • Some more cleanup and layout improvement within “Recovery by country”.
  • pulling in a couple fixes that just went up on covidtracking.com (US testing data)

1.1.1 (May 6th, 2020)

  • Some cleanup of the “Recovery by country” tab, as well as introducing a second chart for each selected country/province/state, that shows the actual Deaths per day over time, for reference.
  • New data for 5/6 loaded from JHU CSSE and covidtracking.com (US testing data)

1.1 (May 5th, 2020)

  • A bit of cleanup in the analysis view just makes the entire first tab actually run as a datacube+postprocess pattern. this vastly improves the speed at which the charts render there.
  • Fixed a bug where the granularity of the timecharts in the ‘recovery by country’ tab was snapping to weeks instead of days for some countries/provinces/states with longer histories.
  • New data for 5/5 loaded from JHU CSSE and covidtracking.com (US testing data)

1.0.7 (May 4th, 2020)

  • New data for 5/4 loaded from JHU CSSE and covidtracking.com (US testing data)

1.0.6 (May 4th, 2020)

  • New data for 5/3 loaded from JHU CSSE, covidtracking.com (US testing data) and Aura Vision (lockdown dates)

1.0.5 (May 2nd, 2020)

  • Fixed a CSS bug where the text color and the background color of the navigation menus was the same and you had to mouseover them to read them at all
  • Commenting out the exponential-forecast section. There are so few tracks that are still following exponential curves that even with its heavy qualifiers, it’s probably misleading more folks than it’s helping.
  • Changing Deaths and Confirmed y-axis options to default to linear scale instead of logarithmic scale
  • New data for 5/2 loaded from JHU CSSE and covidtracking.com (US testing data)

1.0.4 (May 1st, 2020)

  • Fixed a CSS bug where the bottom paginator of the ‘recovery by country’ tab was partly hidden behind the last chart.
  • New data for 5/1 loaded from JHU CSSE and covidtracking.com (US testing data)

1.0.3 (April 30th, 2020)

  • Finished the work to get population in there by country and also for US states. And added a y-axis option to display the total number of confirmed cases as a percent of the population instead of as a raw count.
  • New data for 4/30 loaded from JHU CSSE and covidtracking.com (US testing data)

1.0.2 (April 29th, 2020)

  • Fixed a cosmetic bug introduced yesterday where the NavBar’s links in this app became a dark blue color that was quite hard to see against the grey background
  • New data for 4/29 loaded from JHU CSSE and covidtracking.com (US testing data) and Aura Vision (lockdown dates)

1.0.1 (April 28th, 2020)

  • New data for 4/28 loaded from JHU CSSE and covidtracking.com (US testing data)

1.0 (April 27th, 2020)

  • The app now checks to see whether the data it has is more than a day old. If it is, it gives the user a warning and tells them about the three ways they can update the app to get newer data
  • New data for 4/27 loaded from JHU CSSE and covidtracking.com (US testing data) and Aura Vision (lockdown dates)

0.9.17 (April 26th, 2020)

  • New data for 4/26 loaded from JHU CSSE and covidtracking.com (US testing data) (no new lockdown data from Aura Vision today

0.9.16 (April 25th, 2020)

  • New data for 4/25 loaded from JHU CSSE and covidtracking.com (US testing data)

0.9.15 (April 25th, 2020)

  • New data for 4/24 loaded from JHU CSSE (JHU didn’t post 4/24 numbers last night so it slipped until today) and covidtracking.com (US testing data) (no new lockdown data from Aura Vision today)

0.9.14 (April 23rd, 2020)

  • New data for 4/23 loaded from JHU CSSE and covidtracking.com (US testing data) and Aura Vision (lockdown dates)

0.9.13 (April 22nd, 2020)

  • New data for 4/22 loaded from JHU CSSE and covidtracking.com (US testing data) (no new lockdown data from Aura Vision today)

0.9.12 (April 21st, 2020)

  • New data for 4/21 loaded from JHU CSSE and covidtracking.com (US testing data) (no new lockdown data from Aura Vision today)

0.9.11 (April 20th, 2020)

  • A new landing page exists.
  • New data for 4/20 loaded from JHU CSSE, covidtracking.com (US testing data) and Aura Vision (lockdown dates)

0.9.10 (April 19th, 2020)

  • Rewrote python scripts to use requests (formerly it was just a quick wget inside popen).
  • New data for 4/19 loaded from JHU CSSE and covidtracking.com (US testing data) (no new lockdown data from Aura Vision today)

0.9.9 (April 18th, 2020)

  • Added a new “Deaths per day, 3 day moving average” option for the y-axis
  • Added some plain english statistics to the “recovery by country” tab.
  • New data for 4/18 loaded from JHU CSSE and covidtracking.com (US testing data) (no new lockdown data from Aura Vision today)

0.9.8 (April 17th, 2020)

  • New data for 4/17 loaded from JHU CSSE, covidtracking.com (US testing data) and Aura Vision (lockdown dates)

0.9.7 (April 16th, 2020)

  • Fixed a bug where the header for the main chart would get misaligned if certain combinations of options were selected
  • New data for 4/15 loaded from JHU CSSE and covidtracking.com (US testing data) (no new lockdown data from Aura Vision today)

0.9.6 (April 15th, 2020)

  • New data for 4/15 loaded from JHU CSSE and covidtracking.com (US testing data) (no new lockdown data from Aura Vision today)

0.9.5 (April 14th, 2020)

  • Fixed a bug in how the default selected countries were being set, that regressed with the fixes last night for France/UK
  • New data for 4/14 loaded from JHU CSSE, covidtracking.com (US testing data) and Aura Vision (lockdown dates)

0.9.4 (April 13th, 2020)

  • The main tab now has an option where you can choose to not normalize the y-axis at all. If you pick this it does give you some options for where you want the time axis to start.
  • There is also a new option to normalize the time axis to “days since local state/country locked down”, using the lockdown data that the app has been pulling in from Aura Vision
  • there is a new statistic that you can pick for the Y-axis, “cases – percent growth by day”
  • Fixed bugs when you would try to select all provinces for France or UK, and get just the actual provinces, and not the “main country” Province.
  • Fixed a minor bug where the US would appear in a slightly wrong place in the sort order.
  • The Chart is now vertically resizable
  • New data for 4/13 loaded from JHU CSSE — it seems they corrected a typo for the case count in Okaloosa County Florida today (4/13). Cases were earlier today listed as 102103 instead of 103.

0.9.3 (April 13th, 2020)

  • New data for 4/13 loaded from JHU CSSE, covidtracking.com (US testing data) (no new lockdown data from Aura Vision today)

0.9.2 (April 12th, 2020)

  • New data for 4/12 loaded from JHU CSSE, covidtracking.com (US testing data) and Aura Vision (lockdown data).

0.9.1 (April 11th, 2020)

  • New data for 4/11 loaded from JHU CSSE, covidtracking.com (US testing data) and Aura Vision (lockdown data).

0.9 (April 10th, 2020)

  • Reimplemented the basic way the app gets and uses the JHU CSSE data. Instead of the old way where the app shipped a strange lookup holding a freeze dried version of rows that one might get back from a splunk search, the app now ships a single lookup that is a merged file containing data from all of the daily report files. The app also ships a script that can be used to refresh the master.zip from github and then rebuild this lookup from that zip’s daily report files. NOTE – this script is not enabled yet. That will likely happen in a day or two though.
  • Completely rebuilt the “recovery by country” tab to instead display a chart of the “Expected Rise In Deaths” statistic for every selected country, so you can page through one chart for every country you’ve selected.
  • Add a small normalization to fix a single data point that listed HK alongside the Chinese Provinces, so that HK only appears consistently as Hong Kong/Hong Kong.
  • Fixed a bug where the “reset selection to…” control only appeared if you were in the first tab.
  • Minimum required version of Canary is now 1.2.6 (This was to pull in new Chart module functionality that is required in the new ‘recovery by country’ tab).
  • New data for 4/10 loaded from JHU CSSE (Note the mechanism for this is completely different in this release. See above)

0.8.3 (April 9th, 2020)

  • Fixed appinspect failures that were just silly packaging mistakes.
  • New data for 4/9 loaded from JHU CSSE

0.8.2 (April 8th, 2020)

  • Removed the temporary fix that was in place for the covidtracking.com testing data, and instead now there’s simpler code that just makes the file a local lookup directly.
  • Adding a new lookup that has lockdown dates by country and state. Although this is not used in the UI, this *is* used in the underlying SPL now. To make a long story short there is a field now in the main base search called “days_since_lockdown_started” for the given Country or State. As such, an intrepid if not necessarily fearless user of this app could click ‘see search syntax’ and then make the modifications to change the final chart command to use this as the x-axis.
  • Updated the search feeding the “Current numbers” tab, to actually display all the things that have been added in the past couple weeks. This means the number of columns is about 3x what it was and it’s a big horizontal scroll now to see it all. These are the breaks.
  • New data for 4/8 loaded from JHU CSSE

0.8.1 (April 7th, 2020)

  • New data for 4/7 loaded from JHU CSSE

0.8 (April 6th, 2020)

  • Replaced the newly added NetInflux statistic with a similar but more useful one, that is also explained inline if you select it.
  • Fixed a bug where if you picked one of the test counts as your y-axis, the logarithmic y-axis option wasn’t getting disabled

0.7.15 (April 6th, 2020)

  • Added a new statistic, for the moment called NetInflux. If you select it in the UI, the app itself gives some explanatory text about what it is trying to do, and how it is calculated.
  • New data for 4/6 loaded from JHU CSSE

0.7.14 (April 5th, 2020)

  • New data for 4/5 loaded from JHU CSSE

0.7.13 (April 4th, 2020)

  • New data for 4/4 loaded from JHU CSSE

0.7.12 (April 3rd, 2020)

  • Fixed a bug where if you had ‘treat provinces/states as countries’ set to “no”, that the reset links to show all states/provinces within US/Australia/Canada/etc did not work properly
  • Bumping up the required version of the Canary app, so as to pull in some important additions from that side.
  • Some wording improvements to the form element options
  • New data for 4/3 loaded from JHU CSSE

0.7.11 (April 2nd, 2020)

  • New data for 4/2 loaded from JHU CSSE
  • The experimental “forecast” panel now only appears if one of the statistics that actually does have an ‘exponential’ phase, is selected — ie total deaths, total cases, and total ‘sick’. Conversely if something like Case Fatality Rate is selected, it hides itself.

0.7.10 (April 1st, 2020)

  • New data for 4/1 loaded from JHU CSSE – includes the US data that was missing at 4:50pm pacific

0.7.9 (April 1st, 2020)

  • Added a median_age field to the us_states.csv
  • Added a new y-axis option of ‘case fatality rate (then-current)’. This option switches you to a linear y-axis and disables th e logarithmic y-axis. (h/t to Ari for the conversation that indicated this was a bit of a hot button statistic.)
  • Added new y-axis options to allow charting of new deaths per day, as opposed to cumulative deaths. likewise new confirmed cases per day as opposed to cumulative cases per day.
  • Fixed a bug – the shortcut links to reset selected countries/and states now preserve your x-axis normalization options
  • in the underlying SPL there are new fields in the underlying datacube, of median_age by country (or for US States, for that state), also Population and “Urban_Percentage”
  • minor improvements to organize the todos and notes and link to them from the nav
  • New data for 4/1 loaded from JHU CSSE, but this is a very thin daily report and for instance it includes no new points for any US states

0.7.8 (March 31st, 2020)

  • A small change to condense the form elements slightly to help users with smaller monitors.
  • Manually preventing France and the United Kingdom from being split apart into province/state values because they only have a couple small province/state values being broken out and since they are far smaller in population than the respective “most of the country” value, the net effect on the UI is a little confusing. and I’m going to revisit this later to find a better solution.
  • added a new static lookup for countries, that has population, land area, median age, and ‘urban percentage’. This isn’t wired up as anything in the UI yet at all, but it will be soon.
  • (New data for 3/31 loaded from JHU CSSE)

0.7.7 (March 30th, 2020)

  • Edited the ‘default’ reset link to add Belgium and the Netherlands.
  • Fixed a bug in the new US-counties prototype, where the state pulldown was initially selected to “all”
  • Fixed a bug where extracting the county names from jan/feb rows, inadvertently trimmed off some city-level rows. Now the group that captures the county names is optional in the regex.
  • Added back the testing options to the y-axis pulldown (these pull from the covidtracking.com data, and while the machinery has been in the app for some time, I inadvertently removed the options from the y-axis several releases ago)
  • Added a contextual disclaimer about the “PendingTests” statistic, that these numbers are not widely reported so the chart can be misleading.
  • (New data for 3/30 loaded from JHU CSSE)

0.7.6 (March 29th, 2020)

  • Added some higher numbers to the “by number of days since the” selector. Unfortunately it is sometimes useful to normalize the x-axis to these much higher numbers now.
  • Moved the layer of reset links into its own Pattern file.
  • Added a new prototype that allows the same sort of interactivity but specifically for the counties within one particular US State. For all non-US users out there, unfortunately the JHU dataset recently started providing this County-level detail only for US States. For what it’s worth when similar granularity is available for other countries I will certainly try and expose that as additional functionality, as I’ve done here for the US.)
  • (New data for 3/29 loaded from JHU CSSE)

0.7.5 (March 28th, 2020)

  • Added a disclaimer to both “cases over time by country or state” and “recovery by country” to call out that the “Recovered” numbers in the dataset are not broken out by US State. Without this disclaimer it seemed potentially quite alarming. Hopefully the JHU CSSE folks are able to soon break this down by state and I can change this disclaimer or remove it later.
  • (New data for 3/28 loaded from JHU CSSE)

0.7.4 (March 27th, 2020)

  • (New data for 3/27 loaded from JHU CSSE)

0.7.3 (March 27th, 2020)

  • Fixed a misconfiguration of the main view, where the main Country/Province/State pulldown would reset to the default every time you reloaded the page (rather than using the selection preserved in the url)
  • minor fix so the chart doesn’t redispatch when you just change the y-axis type.
  • Expanded the ‘reset to default’ link to also allow you to reset to selecting all the provinces within the few countries that have that level of granularity. This is only a convenience but it saves a lot of time selecting/deselecting provinces and states.
  • Also I have added another static lookup to handle normalization of various Province_State names that have typos or inconsistencies.
  • (New data for 3/26 loaded from JHU CSSE)

0.7.2 (March 26th, 2020)

  • Fixed a minor bug where the explanatory note above the main chart always said the xaxis showed days since the Nth “confirmed case”, even when that option was set to ‘deaths’ instead.

0.7.1 (March 25th, 2020)

  • quick fix for the ‘recovery by country’ tab

0.7 (March 25th, 2020)

  • The app now ships a pair of lookups. These are a snapshot of
    index=covid19 sourcetype=”csse_covid_19_daily_report”
    and
    index=covid19 sourcetype=”states_daily_testing”
    respectively. All searches in the app draw from these static lookups and not from searching indexed data. The app does still ship a snapshot of the daily reports data in the “covid_data” subfolder. However it does not ship enabled data inputs to index those files.

    This is a new solution to the problem we’ve had, where when JHU fixes typos or cleans something up in an old daily report, that the monitor inputs would then reindex part of the data when the user updates to a new version. These nature of this data, and the nature of these updates are such that ‘simply deduping’ the events is not as easy as it normally is in Splunk.

  • I’ve put back the legacy SideviewUtils module into all views. I removed this by mistake thinking it was redundant now. However this is still a load-bearing piece of how we’re ensuring redirects away from legacy advanced-xml URLs to proper canary URLs.
  • (New data loaded from JHU CSSE dataset)

0.6 (March 24th, 2020)

  • Improved the `get_count_of_days_since_nth_case` further, so now it can take three optional args. See comments in macros.conf
  • Added the ability to explode out the countries/provinces and treat them as separate countries. This allows a much more flexible analysis – notably you can compare individual US states or Australian or Canadian provinces to entire countries. The previous tab doing per-state analysis has been deleted.
  • Added controls to allow the user to change from the x-axis being “days since the 100th confirmed case” from 100 to any N, and from “confirmed case” to “death”.
  • Fixed a bug where clicking ‘see raw search syntax’ on a tabular output would dump you out into a column chart
  • Pulled out the primer on logarithmic y-axes into its own page under ‘notes’
  • Upped the required version of Canary to 1.2.3, and added a little message that appears in the top of the analysis view, if the version is too low
  • Users that update to the latest Canary version will see different and better colors on the charts within the ‘current status by country’ tab.

0.5.2 (March 23rd, 2020)

  • Fixed a problem in the “COVID-19 dataset” tab where the covidtracking.com data rows were appearing there, but with most columns blank. As this was confusing and served no purpose I filtered them out
  • Fixed a regression in the “COVID-19 dataset” tab where the selection of the province/state element had no effect on the results.
  • Added some text underneath the main tab giving users a primer on exponential curves and how to interpret charts with logarithmic y-axes
  • Since the JHU CSSE data suddenly has a whole other field for US County, but the field name strangely is “Admin2”, I’ve renamed the field to “County” and made it visible in the “COVID-19 dataset” tab.
  • (New data loaded from JHU CSSE dataset)

0.5.1 (March 23rd, 2020)

  • Fixed an unfortunately bug that only happened on 7.3, but that prevented users from being redirected into the app correctly. Instead they were stranded on a page telling them that “TopNav” and “AppNav” modules didnt exist.

0.5 (March 22nd, 2020)

  • Reviewed and made improvements to how we handle days with missing data at the country and province level. Previously the SPL screened out the duplicate records where the “Last Update” referred to a day before the day-based filename the record was in. Now we let those records get indexed and returned at search time but at search time we override the _time value from the filename. Normally this is a bad practice in Splunk and it’s better to set it from the filename at index time with INGEST_EVAL. However here it’s quick, its effective and we pull the entire set off disk anyway with each search so there’s not much of a downside. Also INGEST_EVAL would force reindexing for all upgrades to this release.
  • (New data loaded from JHU CSSE dataset)

0.4.3 (March 21st, 2020)

  • Removing the warning message added in 0.4.2 and the app now simply dedups the data explicitly on search.
  • There is a new health checks page, whereby the app ships stanzas in checklist.conf that get run explicitly on this page. Note the checklist.conf stanzas will also run in the Splunk Monitoring Console if any splunk admins are looking there
  • (New data loaded from JHU CSSE dataset)

0.4.2 (March 21st, 2020)

  • JHU recently went back and changed something in the daily data from 2 days ago, which is great. However this comes before I had completed the health check to automatically detect this and bubble up a warning to the user.
    So this release just has a hardcoded warning at the top to always reindex the data after updating to a new version.

0.4.1 (March 20th, 2020)

  • Redoing the default country selection. The short version is “I added Switzerland”.
    The Long version – Previously it was the top 10 total confirmed cases, plus an extra 2 – Hong Kong and Singapore which are low but have extremely interesting curves. New it is the top 10, plus an extra 3 – Japan, Hong Kong and Singapore.

0.4 (March 20th, 2020)

  • the app now ships a snapshot of the per-day testing data for US States from https://covidtracking.com/api/
  • some key numbers from the us testing data can now be chosen as y-axis values on the per-province/state chart, although of course they only work for US states at the moment.
  • In the “by province/state” tab I have marked the “Recovered” yaxis option as “(doesn’t work with recent US data)”, The reason is that since the “Recovered” numbers in the US are no longer associated with individual states, this means we can’t really graph that number in the US split by state. While you might think we can create a fake state called ‘unknown’, we’d ahve to also determine “on what day the unknown state passed 30th confirmed cases” and that’s nonsensical.

0.3.4 (March 20th, 2020)

  • Altered the app so that even if the user fails to install the Sideview Utils app or the Canary app (or both) this app itself will explain that problem to them on the landing page and give them instructions for how to install the missing apps. (Before this version the app would just load a blank page and leave the user stranded.)
  • Tested on Splunk 7.3 and since everything seems fine, I am marking it compatible with 7.3 (prior to this it was marked in SB as Splunk 8.X only)
  • gave the navigation bar a link to the release notes file.

0.3.3 (March 19th, 2020)

  • (New data loaded from JHU CSSE dataset)

0.3.2 (March 19th, 2020)

  • Fixed the problem that was preventing other countries that had more than 1 Province/State past the 30-confirmed-cases mark, from appearing in the ‘cases over time by province/state’ graph. Short Version – you can now see Australia, Canada and Denmark in that visualization
  • Changing the “cases over time by province/state” tab’s y-axis to default to normal ie ‘linear’ because it’s actually more informative that way, at least at this stage.
  • Changing the ‘recovery over time by country’ page to use line charts instead of area charts. I think with area charts it’s slightly easier to misinterpret the numbers as “net-new cases for that day” when they are in fact cumulative numbers.
  • Adding a state/province CheckboxPulldown to the “COVID-19 dataset” tab. Also adding a second Pager control at the bottom of the table for convenience.
  • Fixing an issue that only just appeared in the 3/18/2020 data for the US. There’s a row with Province_State=”US” and Recovered=106 but confirmed is only listed as 1. I am interpreting this to mean the confirmed is reported at a more granular level already, but through some datasource they know there are 106 recovered cases across the country. The change specifically here to this app, is that the “Sick” number would for this one datapoint, go negative and thus throw off numbers for that day.
  • Patching a minor problem in the data where sometimes the United Kingdom’s “United Kingdom” Province is listed as “UK”.
  • moving the log/linear axis control in the province/state tab to be below the other controls whose changes redispatch the search.
  • (New data loaded from JHU CSSE dataset)

0.3.1 (March 18th, 2020)

  • small change to the “recovery by country” tab, to make their time axis all start on the same day. This resolves at least the constant need to refer to the x-axis as you look between charts.

0.3 (March 18th, 2020)

  • New tab added “cases over time by province/state”. This is much like the main visualization showing change over time since the day the country had its 100th total confirmed case, except that you pick an individual country and then it does that analysis for the country’s provinces or states.
  • SPL has been developed to make the US data from the early days more usable. The states are extracted from the county names and so ultimately that county-level data can get automatically counted when analysis is done split or grouped by state.
  • as a part of the previous item, added a small csv lookup that maps 2-letter abbreviations for US states to the full state name.
  • Data Onboarding Notes page has been updated. Also several macros have been renamed and several new macros have been created. Note that macros.conf also contains quite a lot of comments for anyone interested in dissecting how this all works.
  • release notes file created, and backfilled from checkin comments for prior 2 releases.
  • (New data loaded from JHU CSSE dataset)

0.2.4 (March 18th, 2020)

  • New (hidden) prototype of the visualization to split things by Province/State for particular countries.
  • parametrizing the “get_count_of_days*” macro and abandoning the old hardcoded one that did the 100 day threshold.
  • (New data loaded from JHU CSSE dataset)

0.2.3 (March 17th, 2020)

  • changing the main tab name from “confirmed cases over time” to “cases over time by country”. The old name I think made it easier to think the ‘sick cases’ number on the y-axis and the ‘time since the 100th confirmed case’ on the x-axis, were the same number. Might revisit this again but this seemed an easy improvement.
  • Fixed a typo that broke one of the links to the data_onboarding_notes page
  • added the working list of todo’s into the app at the bottom of the data_onboarding_notes page.
  • (New data loaded from JHU CSSE dataset)

0.2.2 (March 17th, 2020)

  • css tweaks.
  • making the “remaining sick patients” yaxis option to “remaining patients sick or testing positive”. In some informal user testing someone assumed incorrectly from the old label that the patients were visibly sick and showing symptoms, whereas the count also includes patients testing positive but asymptomatic.
  • adding the nullValueMode=connect to the “recovery by country” tab.
  • moving the Sick field to a calculated field.
  • manually filtering out the 3/1 data point where only ‘channel islands’ reported data in the UK. with the new nullValueMode=connect, it’s better to just yank the point, let the charting framework connect it, rather than what I was doing prior creating a fake data point (ick). Now the chart looks the same but if you look closely you’ll see there’s no little data point circle there and thats better.
  • commented the macros.
  • (New data loaded from JHU CSSE dataset)

0.2.1 (March 16th, 2020)

  • Fixing a bug – yaxis was always showing “confirmed cases”. Now it reflects the actual selected yaxis statistic.
  • Fixing the linux/windows problem with that filename extraction.
  • Adding a second data input with windows backslashes, so that the app’s data input can work out of the box on Windows as it does on *nix
  • (New data loaded from JHU CSSE dataset)