Tables API¶

The Tables API makes it possible to access dataframes our data scientists use to prepare the data for our public charts.

When using this API, you have access to the public catalog of data processed by our data team. The catalog indexes tables of data, rather than datasets or individual indicators. To learn more, read about our data model.

PythonSQL

Install our Python client:

pip install owid-catalog

And query our data!

from owid.catalog import fetch
tb = fetch("grapher/biodiversity/2025-04-07/cherry_blossom/cherry_blossom")

Read library documentation »

The ETL catalog is stored in two efficient formats—Feather and Parquet—making it easy to query data with tools like DuckDB. To access a table, use the URL pattern:

https://catalog.ourworldindata.org/[channel]/[dataset]/[version]/[dataset]/[table].parquet

For example, to fetch the first 100 rows of the Cherry Blossom dataset:

SELECT
  *
FROM
  'https://catalog.ourworldindata.org/garden/biodiversity/2025-04-07/cherry_blossom/cherry_blossom.parquet'
LIMIT
  100;