Overview
This vignette demonstrates how to use the eufundr
package to download and analyze publicly available EU funding data from
multiple sources: Kohesio, FTS, Horizon Europe, and Horizon 2020.
Kohesio Data
fi_projects <- get_kohesio_projects("FI")## Warning: Expecting logical in AG1348 / R1348C33: got
## 'https://ec.europa.eu/regional_policy/rest/projects/upload/4144.jpg'## Warning: Expecting logical in AI1348 / R1348C35: got
## 'https://ec.europa.eu/regional_policy/projects/projects-database/open-innovation-platforms-for-finlands-media-industry_en'## Warning: Expecting logical in AG1494 / R1494C33: got
## 'https://ec.europa.eu/regional_policy/rest/projects/upload/4377.jpg'## Warning: Expecting logical in AI1494 / R1494C35: got
## 'https://ec.europa.eu/regional_policy/projects/projects-database/sustainability-competitiveness-and-business-growth-in-industry-and-mining-in-lapland_en'## Warning: Expecting logical in AG1958 / R1958C33: got
## 'https://ec.europa.eu/regional_policy/rest/projects/upload/5101.jpg'## Warning: Expecting logical in AI1958 / R1958C35: got
## 'https://ec.europa.eu/regional_policy/projects/projects-database/bringing-innovation-to-hospital-healthcare-in-southern-finland_en'## Warning: Expecting logical in AG2002 / R2002C33: got
## 'https://ec.europa.eu/regional_policy/rest/projects/upload/4458.png'## Warning: Expecting logical in AI2002 / R2002C35: got
## 'https://ec.europa.eu/regional_policy/projects/projects-database/helping-young-people-develop-professional-it-skills-in-central-ostrobothnia-finland_en'## Warning: Expecting logical in AG3185 / R3185C33: got
## 'https://ec.europa.eu/regional_policy/rest/projects/upload/4915.jpg'## Warning: Expecting logical in AI3185 / R3185C35: got
## 'https://ec.europa.eu/regional_policy/projects/projects-database/new-testing-platform-helps-modernise-healthcare-in-finland-and-beyond_en'## Warning: Expecting logical in AG4260 / R4260C33: got
## 'https://ec.europa.eu/regional_policy/rest/projects/upload/auto2020.png'## Warning: Expecting logical in AI4260 / R4260C35: got
## 'https://ec.europa.eu/regional_policy/projects/projects-database/auto2020-finland-trains-students-for-world-of-zero-emission-transport_en'## Warning: Expecting logical in AG5489 / R5489C33: got
## 'https://ec.europa.eu/regional_policy/rest/projects/upload/5125.jpg'## Warning: Expecting logical in AI5489 / R5489C35: got
## 'https://ec.europa.eu/regional_policy/projects/projects-database/lahti-fringe-festival-brings-artists-from-around-the-world-to-finland_en'## Warning: Expecting logical in AG5708 / R5708C33: got
## 'https://ec.europa.eu/regional_policy/rest/projects/upload/4252.jpg'## Warning: Expecting logical in AI5708 / R5708C35: got
## 'https://ec.europa.eu/regional_policy/projects/projects-database/n2-project-is-starting-up-in-south-west-finland_en'## Warning: Expecting logical in AG6082 / R6082C33: got
## 'https://ec.europa.eu/regional_policy/rest/projects/upload/5040.jpg'## Warning: Expecting logical in AI6082 / R6082C35: got
## 'https://ec.europa.eu/regional_policy/projects/projects-database/preventing-homelessness-in-finlands-cities_en'## Warning: Expecting logical in AG9318 / R9318C33: got
## 'https://ec.europa.eu/regional_policy/rest/projects/upload/4169.jpg'## Warning: Expecting logical in AI9318 / R9318C35: got
## 'https://ec.europa.eu/regional_policy/projects/projects-database/low-carbon-life-in-finland_en'## Warning: Expecting logical in AG9921 / R9921C33: got
## 'https://ec.europa.eu/regional_policy/rest/projects/upload/4697.jpg'## Warning: Expecting logical in AI9921 / R9921C35: got
## 'https://ec.europa.eu/regional_policy/projects/projects-database/suomessa-leikataan-paastoja-katu-kerrallaan_en'
head(fi_projects)## # A tibble: 6 × 35
## operation_unique_identifier operation_local_iden…¹ operation_name_english
## <chr> <chr> <chr>
## 1 https://linkedopendata.eu/entit… A73439 A new kind of direct …
## 2 https://linkedopendata.eu/entit… A77235 Cleanliness — Interac…
## 3 https://linkedopendata.eu/entit… A76229 Construction of produ…
## 4 https://linkedopendata.eu/entit… GENERATED-ID-2021FI16… Contribution to devel…
## 5 https://linkedopendata.eu/entit… A70994 Development and evalu…
## 6 https://linkedopendata.eu/entit… A77559 Renewable Energy Heat…
## # ℹ abbreviated name: ¹operation_local_identifier
## # ℹ 32 more variables: operation_name_programme_language <chr>, country <chr>,
## # postal_code <dbl>, operation_start_date <chr>, operation_end_date <chr>,
## # cofinancing_rate <dbl>, total_eligible_expenditure_amount <dbl>,
## # total_eligible_expenditure_currency <chr>, project_eu_budget <dbl>,
## # beneficiary_unique_identifier <chr>,
## # location_indicator_latitude_longitude <chr>, …
fi_beneficiaries <- get_kohesio_beneficiaries("FI")
head(fi_beneficiaries)## beneficiary beneficiary_label
## 1 https://linkedopendata.eu/entity/Q3765452 BELLANPUISTO OY
## 2 https://linkedopendata.eu/entity/Q3766059 PROCADME TEAM OY
## 3 https://linkedopendata.eu/entity/Q3765157 VILLA GOLF-RUKA OY
## 4 https://linkedopendata.eu/entity/Q3761198 ST HEIKKILÄ OY
## 5 https://linkedopendata.eu/entity/Q3760472 FICONIC SOLUTIONS OY
## 6 https://linkedopendata.eu/entity/Q3769716 Suomen Setlementtiliitto r.y.
## website wikidata_id country
## 1 FI
## 2 FI
## 3 FI
## 4 FI
## 5 FI
## 6 FIFinancial Transparency System (FTS)
fts_fi <- get_all_fts("Finland")## Warning in value[[3L]](cond): Skipping year 2007 due to read error: zip file
## 'C:\Users\03262799\AppData\Local\Temp\Rtmpc3xVZd\file5b883ef4408b.xlsx' cannot
## be opened## Warning in value[[3L]](cond): Skipping year 2008 due to read error: zip file
## 'C:\Users\03262799\AppData\Local\Temp\Rtmpc3xVZd\file5b882180664.xlsx' cannot
## be opened## Warning in value[[3L]](cond): Skipping year 2009 due to read error: zip file
## 'C:\Users\03262799\AppData\Local\Temp\Rtmpc3xVZd\file5b88559d6eb2.xlsx' cannot
## be opened## Warning in value[[3L]](cond): Skipping year 2010 due to read error: zip file
## 'C:\Users\03262799\AppData\Local\Temp\Rtmpc3xVZd\file5b884de334ef.xlsx' cannot
## be opened## Warning in value[[3L]](cond): Skipping year 2011 due to read error: zip file
## 'C:\Users\03262799\AppData\Local\Temp\Rtmpc3xVZd\file5b88261e30c.xlsx' cannot
## be opened## Warning in value[[3L]](cond): Skipping year 2012 due to read error: zip file
## 'C:\Users\03262799\AppData\Local\Temp\Rtmpc3xVZd\file5b8830851a40.xlsx' cannot
## be opened## Warning in value[[3L]](cond): Skipping year 2013 due to read error: zip file
## 'C:\Users\03262799\AppData\Local\Temp\Rtmpc3xVZd\file5b889ca6b6b.xlsx' cannot
## be opened## Warning in value[[3L]](cond): Skipping year 2014 due to read error: zip file
## 'C:\Users\03262799\AppData\Local\Temp\Rtmpc3xVZd\file5b88527b6365.xlsx' cannot
## be opened## Warning in value[[3L]](cond): Skipping year 2015 due to read error: zip file
## 'C:\Users\03262799\AppData\Local\Temp\Rtmpc3xVZd\file5b88608712f2.xlsx' cannot
## be opened## Warning in value[[3L]](cond): Skipping year 2016 due to read error: zip file
## 'C:\Users\03262799\AppData\Local\Temp\Rtmpc3xVZd\file5b8811ed5736.xlsx' cannot
## be opened## Warning in value[[3L]](cond): Skipping year 2017 due to read error: zip file
## 'C:\Users\03262799\AppData\Local\Temp\Rtmpc3xVZd\file5b8871dded7.xlsx' cannot
## be opened## Warning in value[[3L]](cond): Skipping year 2018 due to read error: zip file
## 'C:\Users\03262799\AppData\Local\Temp\Rtmpc3xVZd\file5b882bca938.xlsx' cannot
## be opened## Warning in value[[3L]](cond): Skipping year 2019 due to read error: zip file
## 'C:\Users\03262799\AppData\Local\Temp\Rtmpc3xVZd\file5b88644c868.xlsx' cannot
## be opened## Warning in value[[3L]](cond): Skipping year 2020 due to read error: zip file
## 'C:\Users\03262799\AppData\Local\Temp\Rtmpc3xVZd\file5b88dba33c1.xlsx' cannot
## be opened## Warning in value[[3L]](cond): Skipping year 2021 due to read error: zip file
## 'C:\Users\03262799\AppData\Local\Temp\Rtmpc3xVZd\file5b883ee384c.xlsx' cannot
## be opened## Warning in value[[3L]](cond): Skipping year 2022 due to read error: zip file
## 'C:\Users\03262799\AppData\Local\Temp\Rtmpc3xVZd\file5b884557d5d.xlsx' cannot
## be opened## Warning in value[[3L]](cond): Skipping year 2023 due to read error: zip file
## 'C:\Users\03262799\AppData\Local\Temp\Rtmpc3xVZd\file5b88290e70c.xlsx' cannot
## be opened
head(fts_fi)## # A tibble: 0 × 0Horizon Europe
horizon_fi <- get_horizon_europe("FI")## ℹ Using "','" as decimal and "'.'" as grouping mark. Use `read_delim()` for more control.## Warning: One or more parsing issues, call `problems()` on your data frame for details,
## e.g.:
## dat <- vroom(...)
## problems(dat)## Rows: 16916 Columns: 20## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ";"
## chr (13): acronym, status, title, legalBasis, topics, frameworkProgramme, m...
## dbl (3): id, totalCost, ecMaxContribution
## lgl (1): nature
## date (3): startDate, endDate, ecSignatureDate
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
## ℹ Using "','" as decimal and "'.'" as grouping mark. Use `read_delim()` for more control.
##
## Rows: 102954 Columns: 25
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ";"
## chr (14): projectAcronym, vatNumber, name, shortName, activityType, street,...
## dbl (5): projectID, organisationID, rcn, order, totalCost
## num (2): ecContribution, netEcContribution
## lgl (3): SME, endOfParticipation, active
## dttm (1): contentUpdateDate
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
head(horizon_fi)## # A tibble: 6 × 9
## hankenimi toteutuneet_maksut rahasto kuvaus aloitusp lopetusp ytunnus
## <chr> <dbl> <chr> <chr> <date> <date> <chr>
## 1 Quantum Contr… 2270150. HORIZON The m… 2022-10-01 2025-09-30 NL0019…
## 2 Quantum Contr… 2270150. HORIZON The m… 2022-10-01 2025-09-30 IT0021…
## 3 Quantum Contr… 2270150. HORIZON The m… 2022-10-01 2025-09-30 NL8520…
## 4 Quantum Contr… 2270150. HORIZON The m… 2022-10-01 2025-09-30 GB2547…
## 5 Quantum Contr… 2270150. HORIZON The m… 2022-10-01 2025-09-30 NL8208…
## 6 Quantum Contr… 2270150. HORIZON The m… 2022-10-01 2025-09-30 GB5686…
## # ℹ 2 more variables: hakijanimi <chr>, country <chr>Horizon 2020
h2020_fi <- get_horizon_2020("FI")## ℹ Using "','" as decimal and "'.'" as grouping mark. Use `read_delim()` for more control.## Warning: One or more parsing issues, call `problems()` on your data frame for details,
## e.g.:
## dat <- vroom(...)
## problems(dat)## Rows: 35389 Columns: 20## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ";"
## chr (14): acronym, status, title, legalBasis, topics, frameworkProgramme, m...
## dbl (3): id, totalCost, ecMaxContribution
## date (3): startDate, endDate, ecSignatureDate
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
## ℹ Using "','" as decimal and "'.'" as grouping mark. Use `read_delim()` for more control.
##
## Rows: 178015 Columns: 25
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ";"
## chr (16): projectAcronym, vatNumber, name, shortName, activityType, street,...
## dbl (5): projectID, organisationID, rcn, order, totalCost
## lgl (3): SME, endOfParticipation, active
## dttm (1): contentUpdateDate
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
head(h2020_fi)## # A tibble: 6 × 9
## hankenimi toteutuneet_maksut rahasto kuvaus aloitusp lopetusp ytunnus
## <chr> <dbl> <chr> <chr> <date> <date> <chr>
## 1 Development o… 71429 H2020 "The … 2015-05-01 2015-10-31 IT0194…
## 2 A MOBILE SUPE… 71429 H2020 "The … 2018-07-01 2018-12-31 NA
## 3 Glyco and Nan… 158122. H2020 "The … 2017-04-01 2019-03-31 ESQ151…
## 4 Developing a … 71429 H2020 "Nano… 2019-03-01 2019-06-30 NL8542…
## 5 Novel 1D phot… 1116000 H2020 "The … 2018-01-01 2023-12-31 NA
## 6 Novel 1D phot… 1116000 H2020 "The … 2018-01-01 2023-12-31 PL7770…
## # ℹ 2 more variables: hakijanimi <chr>, country <chr>