The Database provides a snapshot of all data found in the live d-portal database. This is updated nightly.

The following are tables with figures representing the number of distinct (unique) values in the column; ie. repeated values are not counted.

Certain parts of IATI data have been indexed into tables specifically to be displayed in d-portal.

The Act table (created in 2014) forms the base of the website but has been used as a stable API for external tools like the Humanitarian Data Exchange for many years, despite being an internal tool.

We create a lot of indexes because, as a public facing site, we need the database queries to run as fast as possible.

The Xson table (created in 2020) accommodates more complex data needs and searches as it includes all activity and organisation elements according to the IATI Standard, as well as non-standard attributes and extensions that can be found in published data.

As such, for uses beyond the d-portal user interface, you can now explore dQuery by using SQL in the browser.