GitHub - arjenlentz/covtrack: Quick ETL trickery in PHP to load/update the Johns Hopskins Uni timeseries data tracking COVID-19, to MySQL/MariaDB

arjenlentz / covtrack Public

Notifications You must be signed in to change notification settings
Fork 0
Star 0

Quick ETL trickery in PHP to load/update the Johns Hopskins Uni timeseries data tracking COVID-19, to MySQL/MariaDB

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 7 Commits
README		README
cov_load_timeseries_csv.php		cov_load_timeseries_csv.php
getnewdata.sh		getnewdata.sh
seed.sql		seed.sql

Repository files navigation

Assorted notes...

This tool uses data from https://github.com/CSSEGISandData/COVID-19
Clone that repo, and pull once a day for updates, then run the script to update your database.

Data for previous days can (and frequently is) updated also, and the script processes this properly as well.
Keep that in mind when you calculate aggregates, you'll have to re-run those as well.

The PHP script is hardcoded to use the dbname covtrack, but it's an easy define near the top.

You don't have to use the seed file, the items and locations are created and dynamically updated by the script.
However, I also added a population table, and tied it back to the locations table - so to make that work for you, I've added the seed.sql file with both locations and population, so your IDs will match up.

PRs welcome!