I’ve been playing with COVID-19 data recently. I live in the Czech Republic, so I‘m naturally interested in seeing how COVID spreads here. These data might also be interesting for you as the Czech Republic trends are pretty unique.
This article shows how to create a new SQLite, Postgres, or MySQL database with fresh COVID data in a few minutes. I’m using dbd as a database prototyping tool.
If you run the commands below, you’ll create this analytical model in your database:
Then you can use your favorite BI or data science tool to create nice data visualizations, dashboards, or machine learning models. I always recommend GoodData.CN for data analytics.
The steps are pretty simple. Just execute the following commands (make sure that you have Python 3.8 or higher installed on your machine):
pip3 install dbd
git clone https://github.com/zsvoboda/dbd.git
cd dbd/examples/sqlite/covid_cz
dbd --profile=../dbd.profile run .and you can start using the covid_cz.db database that appears on your disk.
NOTE: These commands download more than 1GB of data to your computer. It takes dbd some time to download, insert, and transform the data (~10 minutes on my machine and Internet connection).
Postgres, MySQL, BigQuery, Snowflake, and Redshift versions of these commands are also available. Redshift is a work in progress (more performance tuning) at the time of writing this article.
