Making a Datasette of Finnish coronavirus data

readme.md

Making a Datasette of Finnish coronavirus data

From here: https://github.com/HS-Datadesk/koronavirus-avoindata

Tools

You'll need jq, sqlite-utils and Datasette.

• jq installation instructions: https://stedolan.github.io/jq/download/
• pip install sqlite-utils datasette

Building the database

curl "https://w3qa5ydb4l.execute-api.eu-west-1.amazonaws.com/prod/finnishCoronaData" \
  | jq '.confirmed' | sqlite-utils insert finnishCoronaData.db confirmed -
curl "https://w3qa5ydb4l.execute-api.eu-west-1.amazonaws.com/prod/finnishCoronaData" \
  | jq '.deaths' | sqlite-utils insert finnishCoronaData.db deaths -
curl "https://w3qa5ydb4l.execute-api.eu-west-1.amazonaws.com/prod/finnishCoronaData" \
  | jq '.recovered' | sqlite-utils insert finnishCoronaData.db recovered -

This will create a database called finnishCoronaData.db

Now run it with:

datasette finnishCoronaData.db