European Structural and Investment Funds per capita

So you want to know how much European funding goes to which country and on what it is spent? This is the right place to find out.

Data Sources

• European population (Eurostat)
• European Structural and Investment Funds (ESIF)

How to do it yourself

Make sure you have Node.js installed. Then convert the datasources into one json file:

node convert.js

Generate a csv with the amount invested per capita for every country.

node countries.csv.js

Sample:

COUNTRY, VALUE
Austria,574.01
Belgium,240.73
...

Generate a csv with the amount invested per category, per capita for every country.

node categories.csv.js

Sample:

COUNTRY, CATEGORY, VALUE
Austria, Research & Innovation, 30.04
Austria, Information & Communication Technologies , 3.11
Belgium, Research & Innovation, 24.68
Belgium, Competitiveness of SMEs, 43.91
...

Generate a csv for every country with the amount invested per category, per capita.

node categories.separate.csv.js

Sample:

CATEGORY, VALUE
Research & Innovation, 24.68
Competitiveness of SMEs, 43.91
...