OVERVIEW

Statistics & graphs of the D-Portal database. Figures in the corresponding tables are daily logs of nightly imports. The graphs show these figures over time; hover over the points for more information.

LEGEND

Any linked definitions below are to the IATI Registry.

DATABASE

These are tables found in the database. Numbers are total entries found in these tables.
ActActivities table
BudgetBudgets table
CountryCountries table
ElementXML elements
LocationLocations table
RelatedRelated activities table
SectorSectors table
SlugIATI Registry slug (metadata)
TransTransactions table

TABLES

Number of distinct (unique) values in the column; ie. repeated values are not counted.
Aidiati-identifier
FlagsInternal flags
Spend_*USD currency is the default
Day_length( Day_end - Day_start ) ≯ than a year
Status_codeactivity-status
Countryrecipient-country
*_percentPercentage of activities should always add up to 100% even when reported otherwise
Element_*IATI element hierarchies
Element_volumeTotal number of elements
Locationlocation
Related_aidrelated-activity
Sector_codeDAC 5 Digit Sector
Sector_groupDAC 3 Digit Sector
BACK TOP