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.
As such, for uses beyond the d-portal user interface, you can now explore dQuery by using SQL in the browser.
Statistics & graphs of the logs and IATI elements in the D-Portal database.
Please be aware that these pages take awhile to load.
Project page, issues and feedback on Github.