API for the European Commission's Financial Transparency System

An API to access data used by the European Commission's Financial Transparency System (FTS).

Download the raw data by clicking on the "download" hyperlink in their website's help page.

POST /api/ec/fts

A query filter is sent as a POST request JSON message body.

Sample JSON query filter:

{
	"years": [2015, 2016],
	"territories": ["Albania", "Bosnia and Herzegovina", "Croatia", "Kosovo", "Macedonia", "Montenegro", "Serbia"],
	"beneficiaries": ["AB AMBER GRID", "LITGRID AB*"],
	"expenseTypes": ["Operational", "Administrative"],
	"responsibleDepartments": ["Innovation and Networks Executive Agency"],
	"budgetLines": ["Sustainable energy"],
	"actionTypes": ["Cohesion Fund (CF)", "Food and Feed"],
	"fundingTypes": ["Grants", "Provisional commitment followed by payment"],
	"amount": {
		"gte": 50000,
		"lte": 100000
	},
	"sortBy": ["year", "territory"],
	"order": "asc"
}

Sample Response JSON (not representative of actual data):

{
	"count": 2,
	"amount": {
		"total": 120000,
		"min": 40000,
		"max": 80000,
		"avg": 60000
	},
	"results": [{
			"years": 2015,
			"territory": "Croatia",
			"beneficiary": "AB AMBER GRID",
			"expenseType": "Operational",
			"responsibleDepartment": "Innovation and Networks Executive Agency",
			"budgetLine": "Sustainable energy",
			"actionTypes": "Cohesion Fund (CF)",
			"fundingTypes": "Grants",
			"amount": 40000
		},{
			"years": 2016,
			"territory": "Kosovo",
			"beneficiary": "LITGRID AB*",
			"expenseType": "Operational",
			"responsibleDepartment": "Innovation and Networks Executive Agency",
			"budgetLine": "Sustainable energy",
			"actionTypes": "Cohesion Fund (CF)",
			"fundingTypes": "Grants",
			"amount": 80000
		}
	]
}

TODO:

Allow for filter parameter that defines grouping of results, e.g. group by budget line.

GET /api/ec/fts/<year:int>/<territory-slug:string>/beneficiaries

Get list of beneficiaries and their total amount for a given year and territory.

Sample response (TODO):

{
	"count": 0,
	"results": []  
}

GET /api/ec/fts/<year:int>/expense-types

Get list of expense types and their total amount for a given year.

Sample response (TODO):

{
	"count": 0,
	"results": []  
}

GET /api/ec/fts/<year:int>/responsible-departments

Get list of responsible departments and their total amount for a given year.

Sample response (TODO):

{
	"count": 0,
	"results": []  
}

GET /api/ec/fts/<year:int>/budget-lines

Get list of budget lines and their total amount for a given year.

Sample response (TODO):

{
	"count": 0,
	"results": []  
}

GET /api/ec/fts/<year:int>/action-types

Get list of action types and their total amount for a given year.

Sample response (TODO):

{
	"count": 0,
	"results": []  
}