Test OWID Datasette from python

This notebook demonstrates how to use Python to interact with the Our World In Data Datasette instance that provides access to all our articles and charts in structured form

import requests

import pandas as pd

The URL is from a Datasette query that filters the datasets on those created after December 1st, 2021

url = "https://owid-datasette-y43qr.ondigitalocean.app/owid/datasets.json?_sort=id&createdAt__gte=2021-12-01&_labels=on"

data = requests.get(url).json()

dataset = pd.DataFrame(data["rows"])

dataset