Getting Started

IATI tables transforms IATI data into relational tables, and provides multiple ways to access these data.

IATI Tables Datasette

Datasette is an open source tool for exploring data. For more information on the Datasette tool, see the Datasette documentation.

The IATI Tables Datasette instance allows you to explore IATI data your browser using SQL, and download the results of your query in multiple formats. You can also query IATI Tables Datasette from notebooks, such as Google Colab or Deepnote.

CSV Zip

The CSV Zip download is a compressed folder containing a CSV file for each table, which you can explore by importing into a spreadsheet viewer such as Excel or Google Sheets. For more information, see Spreadsheets.

SQLite Zip

The SQLite Zip download is a compressed SQLite database, which can be run and explored with sqlite3.

PG Dump

The PG Dump download can be loaded into a PostgreSQL database and are created by the pg_dump utility.

There are two options to choose from, gzip or custom:

Gzip

The ‘gzip’ format gives you a compressed plaintext script of SQL commands, which can be restored using psql.

Custom

The ‘custom’ format can be restored using the pg_restore utility. This option is more flexible if you want to perform any schema changes before restoring.