For which budget lines have more than 100.000.000 been earmarked since 2017?
As explained before, budget lines in the EU budget are described by their “Nomenclature”, being titles, chapters, articles, items and sub-items. This query is consisted of several steps:
- It adds up all the amounts at the level of the Article. This could also be at the level of Title or Chapter. It makes little sense to do it on a level below Article, i.e. Item or SubItem, as then expense items that are defined at article level are then not taken into account. Expense items cannot be defined at the level of Title or Chapter.
- In order to perform calculations on the numbers, the values should be transformed from strings (“132 493”) to numbers (132493). The query therefore removes spaces from the numbers, otherwise they cannot be added up.
- Once added up, the query filters out those Articles for which the total amount is above 100.000.000 and displays them:
|
ArAlias |
Article_Heading |
Amount |
Year |
A_Type |
|
01 03 06 |
Provisioning of the Guarantee Fund for external actions |
137800722 |
2018 |
NonDifferenciated |
|
01 03 06 |
Provisioning of the Guarantee Fund for external actions |
240540250 |
2017 |
NonDifferenciated |
|
01 03 08 |
Provisioning of the EFSD Guarantee Fund |
275000000 |
2017 |
NonDifferenciated |
|
01 04 05 |
Provisioning of the EFSI guarantee fund |
2641000000 |
2017 |
Commitment |
|
01 04 05 |
Provisioning of the EFSI guarantee fund |
1905092000 |
2018 |
Commitment |
|
02 02 01 |
Promoting entrepreneurship and improving the competitiveness and access to markets of Union enterprises |
119820000 |
2017 |
Commitment |
|
02 02 01 |
Promoting entrepreneurship and improving the competitiveness and access to markets of Union enterprises |
126566000 |
2018 |
Commitment |
Multilingualism is key in an EU-context. Therefore, query 4b shows how to change the language of the result in Dutch (or any other language) using the 2-letter ISO code of the language:
|
ArAlias |
Article_Heading |
Amount |
Year |
A_Type |
|
01 03 06 |
Voorziening van het Garantiefonds voor extern optreden |
137800722 |
2018 |
NonDifferenciated |
|
01 03 06 |
Voorziening van het Garantiefonds voor extern optreden |
240540250 |
2017 |
NonDifferenciated |
|
01 03 08 |
Voorziening van het EFDO-garantiefonds |
275000000 |
2017 |
NonDifferenciated |
|
01 04 05 |
Voorziening van het EFSI-garantiefonds |
2641000000 |
2017 |
Commitment |
|
01 04 05 |
Voorziening van het EFSI-garantiefonds |
1905092000 |
2018 |
Commitment |
|
02 02 01 |
Ondernemerschap bevorderen en het concurrentievermogen en de toegang tot markten van ondernemingen in de Unie verbeteren |
126566000 |
2018 |
Commitment |