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.

Act	Activities table
Budget	Budgets table
Country	Countries table
Element	XML elements
Location	Locations table
Related	Related activities table
Sector	Sectors table
Slug	IATI Registry slug (metadata)
Trans	Transactions table

TABLES

Number of distinct (unique) values in the column; ie. repeated values are not counted.

Aid	iati-identifier
Flags	Internal flags
Spend_*	USD currency is the default
Day_length	( Day_end - Day_start ) ≯ than a year
Status_code	activity-status
Country	recipient-country
*_percent	Percentage of activities should always add up to 100% even when reported otherwise
Element_*	IATI element hierarchies
Element_volume	Total number of elements
Location	location
Related_aid	related-activity
Sector_code	DAC 5 Digit Sector
Sector_group	DAC 3 Digit Sector