In this exercise you will learn how to use a programming language to interact with a database. You will download live data from Our World in Data and insert the data into an SQLite database for further processing. Then you query that data using any compatible database tool. Finally, you'll query and aggregate the data using a programming language.
In order to solve this exercise, consult the official DB-API 2.0 interface for SQLite databases tutorial .
In order to understand the input data, download and open the CSV file with your favorite spreadsheet program or an editor that properly supports CSV.Countries
table. It is your duty to
extend the exisiting code to fill the Mortality
table.stdout
.Country Date Cumulative Excess Cumulative Excess per Million Austria 2022-12-11 21776.797 2435.9878 Sweden 2022-12-11 13488.696 1278.6283