COVID-19 TSU v1.0.0-beta.2

• fine-tuned scripts
  • Use drop_chunks instead of truncate table for hypertables #20
  • Refresh materialized views at the end of scripts #19
• added postgis
• added and expanded daily_change continuous aggregate mentioned in Timescale blogpost #21
• documentation updated to reflect changes

COVID-19 TSU v1.0.0-beta.1

• OpenRefine automation using openrefine-batch
• Geocoding to get additional geographic metadata (continent, us_locality, us_county, us_state) using Geocode.earth
• Fully normalized, non-sparse, time-series data with the addition of daily incident counts - number of confirmed, deaths, and recovered for a given date/location. This will allow extended analysis, and arbitrary aggregations across date ranges and locations.

COVID-19 TSU v1.0.0-alpha.1

Initial alpha quality build:

• pumps JHU COVID19 data to a Timescale database
• OpenRefine projects/recipes to “unpivot”/normalize data