🏦 EU FTS Beneficiary Records

One structured funding_record per record from the official public source, logged-out. Public, robots-honoured.

Difference: one funding_record per official EU Financial Transparency System beneficiary row (beneficiary, registration/VAT, contracted + committed + consumed amounts, programme, budget line, geography, references, project) from the Commission's annual FTS XLSX — the full 38-column schema carried verbatim, canaried on drift. Annual publication-timing drift handled loud.

Output is one eu_fts_beneficiary row per result; billing is pay-per-event, the value event being one funding record (a $0.02 start fee per run, then $0.05 per funding record). Source: ec.europa.eu.

No login, no API key and no CAPTCHA solving are involved: the source is read logged-out with an identified contact User-Agent.

📊 Sample Output

Real rows from run imAE80Lpo5U6QSimq on build 0.1.16 (2026-09-17), the same input as the Quick start below — every value is as the source published it (emails masked, long text shortened):

budget	reference_of_the_legal_commitment_lc	reference_budget	name_of_beneficiary	main_registration_number_of_beneficiary	vat_number_of_beneficiary
Other European Bodies	EAS.572166	EAS.75201.1	21 SOLUTIONS	895963264	BE0895963264
Other European Bodies	JIT.1956074	JIT.1956074.1	28DIGITAL	831431639	BE0831431639
Other European Bodies	JIT.1209441	JIT.1209441.5	28DIGITAL	831431639	BE0831431639
Other European Bodies	LIS.10089	LIS.8411.1	A&C PROPERTIES SA	473917155	BE0473917155
Other European Bodies	LIS.10089	LIS.8409.1	A&C PROPERTIES SA	473917155	BE0473917155
Other European Bodies	LIS.10089	LIS.8412.1	A&C PROPERTIES SA	473917155	BE0473917155
Other European Bodies	LIS.10089	LIS.8407.1	A&C PROPERTIES SA	473917155	BE0473917155
Other European Bodies	EAS.568649	EAS.74247.1	ABELAG AVIATION	427155930	BE0427155930

The run finished with the status message: CAPPED: delivered 10 of 81756 available source rows (maxRecords=10) — a buyer bound, not an outage. billable=10 [requested_cap=10, delivered=10]

✅ What you get

Each row is flat JSON with these fields (from the dataset schema and the sample run; a field the source does not publish for a given row is null):

• record_type (string) — e.g. eu_fts_beneficiary
• year (string/null) — e.g. 2025
• budget (string/null) — e.g. Other European Bodies
• reference_of_the_legal_commitment_lc (string/null) — e.g. EAS.572166
• reference_budget (string/null) — e.g. EAS.75201.1
• name_of_beneficiary (string/null) — e.g. 21 SOLUTIONS
• main_registration_number_of_beneficiary (string/null) — e.g. 895963264
• vat_number_of_beneficiary (string/null) — e.g. BE0895963264
• not_for_profit_organisation_nfpo (string/null) — e.g. No
• non_governmental_organisation_ngo (string/null) — e.g. No
• coordinator (string/null) — e.g. No
• address (string/null) — e.g. RUE DU MARCHE AUX HERBES 105 B.42
• city (string/null) — e.g. BRUXELLES
• postal_code (string/null) — e.g. 1000
• beneficiary_country (string/null) — e.g. Belgium
• nuts2 (string/null) — e.g. Région de Bruxelles-Capitale/Brussels Hoofdstedelijk Gewest
• beneficiary_s_contracted_amount_eur (string/null) — e.g. 6464.3235
• beneficiary_s_estimated_contracted_amoun (string/null) — e.g. 19393
• beneficiary_s_estimated_consumed_amount_ (string/null) — e.g. 6464.3235
• commitment_contracted_amount_eur_a (string/null) — e.g. 19392.99
• additional_reduced_amount_eur_b (string/null) — e.g. 0
• commitment_total_amount_eur_a_b (string/null) — e.g. 19393
• commitment_consumed_amount_eur (string/null) — e.g. 19393
• source_of_estimated_detailed_amount (string/null) — e.g. The repartition for each beneficiary was not available in our central accounting
• expense_type (string/null) — e.g. Operational
• call_id (string/null) — e.g. N/A - Not applicable
• project_id (string/null) — e.g. N/A - Not applicable
• project_acronym (string/null) — e.g. N/A - Not applicable
• subject_of_grant_or_contract (string/null) — e.g. SCS6-EEAS/2021/OP/0050-RM.SCS.6/2025/10-COMASE SYSTÈME DE MANAGEMENT ENVIRONNEME
• responsible_department (string/null) — e.g. EEAS - European External Action Service
• budget_line_number (string/null) — e.g. 2014
• budget_line_name (string/null) — e.g. Other expenditure relating to buildings
• programme_name (string/null) — e.g. DA/JU/EUI - Decentralised Agencies, Joint Undertakings, EU institutions
• beneficiary_group_code — null in every sample row
• beneficiary_type (string/null) — e.g. Private Companies
• project_start_date (string/null) — e.g. 2025-04-28 00:00:00
• project_end_date (string/null) — e.g. 2026-12-31 00:00:00
• type_of_contract (string/null) — e.g. Building: Maintenance
• management_type (string/null) — e.g. Direct management
• benefiting_country (string/null) — e.g. Belgium 100%
• count_commitment_position_key — e.g. 1
• source (string/null) — e.g. eu-fts-beneficiary-records
• release_date (string/null) — e.g. 2025-FTS
• source_url (string/null) — e.g. https://ec.europa.eu/budget/financial-transparency-system/download/2025_FTS_data
• observed_at (string/null) — e.g. 2026-09-17T18:28:37Z
• terminal (string/integer/null) — null in every sample row
• reported_total (string/integer/null) — null in every sample row
• raw_seen (string/integer/null) — null in every sample row
• duplicates (string/integer/null) — null in every sample row
• unique_found (string/integer/null) — null in every sample row
• delivered (string/integer/null) — null in every sample row
• scope (string/integer/null) — null in every sample row
• note (string/integer/null) — null in every sample row
• license (string/integer/null) — null in every sample row
• attribution (string/integer/null) — null in every sample row

What you get

One funding_record per record, deduplicated on the source-native id. Fields the source does not publish are honest null. A run_receipt row carries the source URL, scope, reconciliation counts, and delivered/duplicate totals.

Every run also writes a RUN_RECEIPT record to its key-value store with the source checks it made and the counts it charged — diagnostics never land in the paid dataset.

⚙️ Sample inputs

1. Quick start — the Store example (this is what the sample above came from)

{
  "maxRecords": 10
}

The sample run charged exactly: 1 × $0.02 apify-actor-start + 10 × $0.05 funding_record = $0.52 on the Free tier — every delivered row was billed.

2. A smaller, narrowed run

{
  "maxRecords": 5
}

Caps the run at 5 rows — about $0.27 on the Free tier ($0.02 start + 5 × $0.05).

3. A full-size run

{
  "maxRecords": 5000
}

Up to 5000 rows (the schema default for maxRecords) — about $250.02 on the Free tier ($0.02 start + 5000 × $0.05) if the source has that many.

🧾 JSON sample record

One real record from run imAE80Lpo5U6QSimq, exactly as it lands in the dataset (emails masked, long text shortened):

{
  "record_type": "eu_fts_beneficiary",
  "year": "2025",
  "budget": "Other European Bodies",
  "reference_of_the_legal_commitment_lc": "EAS.572166",
  "reference_budget": "EAS.75201.1",
  "name_of_beneficiary": "21 SOLUTIONS",
  "main_registration_number_of_beneficiary": "895963264",
  "vat_number_of_beneficiary": "BE0895963264",
  "not_for_profit_organisation_nfpo": "No",
  "non_governmental_organisation_ngo": "No",
  "coordinator": "No",
  "address": "RUE DU MARCHE AUX HERBES 105 B.42",
  "city": "BRUXELLES",
  "postal_code": "1000",
  "beneficiary_country": "Belgium",
  "nuts2": "Région de Bruxelles-Capitale/Brussels Hoofdstedelijk Gewest",
  "beneficiary_s_contracted_amount_eur": "6464.3235",
  "beneficiary_s_estimated_contracted_amoun": "19393",
  "beneficiary_s_estimated_consumed_amount_": "6464.3235",
  "commitment_contracted_amount_eur_a": "19392.99",
  "additional_reduced_amount_eur_b": "0",
  "commitment_total_amount_eur_a_b": "19393",
  "commitment_consumed_amount_eur": "19393",
  "source_of_estimated_detailed_amount": "The repartition for each beneficiary was not available in our central accounting system at the time of publication. The total amount was divided by the number of beneficiaries in order to display a proportional repartition.",
  "expense_type": "Operational",
  "call_id": "N/A - Not applicable",
  "project_id": "N/A - Not applicable",
  "project_acronym": "N/A - Not applicable",
  "subject_of_grant_or_contract": "SCS6-EEAS/2021/OP/0050-RM.SCS.6/2025/10-COMASE SYSTÈME DE MANAGEMENT ENVIRONNEMENTAL (SME) - BON DE COMMANDE N. 4",
  "responsible_department": "EEAS - European External Action Service",
  "budget_line_number": "2014",
  "budget_line_name": "Other expenditure relating to buildings",
  "programme_name": "DA/JU/EUI - Decentralised Agencies, Joint Undertakings, EU institutions",
  "beneficiary_group_code": null,
  "beneficiary_type": "Private Companies",
  "project_start_date": "2025-04-28 00:00:00",
  "project_end_date": "2026-12-31 00:00:00",
  "type_of_contract": "Building: Maintenance",
  "management_type": "Direct management",
  "benefiting_country": "Belgium 100%",
  "count_commitment_position_key": "1",
  "source": "eu-fts-beneficiary-records",
  "release_date": "2025-FTS",
  "source_url": "https://ec.europa.eu/budget/financial-transparency-system/download/2025_FTS_dataset_en.xlsx",
  "observed_at": "2026-09-17T18:28:37Z"
}

🔧 How it works

Transport. Plain HTTPS from the Apify platform, no proxy. robots.txt is read first and a disallowed path is never fetched. Every request carries an identified contact User-Agent. Pacing: CRAWL_DELAY=0.0.

Charging. Each funding record is charged at the moment it is pushed (funding_record); a row that fails to charge is not delivered, so the dataset count always equals the charged count.

How it behaves

The annual FTS XLSX is downloaded (year input; default latest, falling back to the prior year with a note), the 38-column header canaried, and rows streamed read-only into one record each, deduped on legal-commitment + beneficiary + amount + budget line. Bulk-proof: streamed, memory bounded, never a full-file self-charged pull.

Source

https://ec.europa.eu/budget/financial-transparency-system/download/{year}_FTS_dataset_en.xlsx

What is not done. No login, no cookie or CAPTCHA bypass, no private or personal-account data, no browser automation.

💰 Pricing example

Event	Free	Bronze	Silver	Gold
Actor Start (apify-actor-start)	$0.02	$0.02	$0.02	$0.02
Funding Record (funding_record)	$0.05	$0.04	$0.04	$0.03

Worked at the live Free-tier price:

• 8 funding records: $0.02 start + 8 × $0.05 = $0.42
• 25 funding records: $0.02 start + 25 × $0.05 = $1.27
• 5000 funding records: $0.02 start + 5000 × $0.05 = $250.02

A run that delivers zero rows charges the $0.02 start fee only. A BLOCKED run (source refused) fails loud and charges no value event. The start fee is charged once per GB of run memory; the default run memory is 1024 MB.

Yield on the sample run: CAPPED: delivered 10 of 81756 available source rows (maxRecords=10) — a buyer bound, not an outage. billable=10 [requested_cap=10, delivered=10]. maxRecords is a hard ceiling on what is delivered and billed, never a target.

⚖️ Legal & ToS

This actor reads public, logged-out pages and feeds published by ec.europa.eu. It collects only what the source publishes to any visitor, keeps to the source's robots rules (checked on every run), identifies itself with a contact User-Agent, and does not access accounts, private data or anything behind authentication. Use the output in line with the source's terms and your local law; the intended use is B2B research and monitoring.

❓ FAQ

Q: Do I need an API key or a login?
A: No. The source (ec.europa.eu) is read logged-out; the input schema has no key field and the actor carries no secrets.

Q: Why did my run return 0 rows?
A: Read the run's status message. GENUINE_EMPTY means the source was read and had nothing in scope for your input; BLOCKED means the source refused and the run failed without billing a value event — retry later or narrow the input. A zero-row run bills the start fee only.

Q: How many rows can one run return?
A: Up to maxRecords (default 5000). Raise the cap for a bigger run; you pay per delivered row.

Q: How fresh is the data?
A: Every run reads the source live at run time; nothing is cached between runs. Put it on a schedule for a continuous feed.

Q: What formats can I export?
A: The dataset downloads as JSON, CSV, Excel, XML or RSS from the run's Dataset tab or the Apify API, and any run can push to a webhook or integration.

Q: How is this different from the other public funding registries actors?
A: Same output shape and billing model; this one covers ec.europa.eu. The siblings under Related Actors cover the other sources or slices — run several on one schedule for a combined feed.

Q: Are there rate limits?
A: The actor paces itself against the source (CRAWL_DELAY=0.0) and honours its robots rules; there is no per-buyer limit beyond your Apify plan's concurrency.

🆘 Troubleshooting

• Run FAILED with BLOCKED → the source refused the request or changed its page shape → nothing was billed beyond the start fee; retry after a while, and if it persists open an Issue with the run id.
• Status says CAPPED → your cap (maxRecords) was reached → raise it for a bigger run.
• Input validation error on start → a field is outside the schema's allowed values → start from the Quick start block and change one field at a time.
• Run TIMED-OUT → a very wide request on a slow day → raise the run timeout in Run options or narrow the input; what was delivered before the timeout is still in the dataset.

🔗 Related Actors

• Brazil BNDES Financing Operations — One structured fundingrecord per record from the official public source, logged-out. Public, robots-honoured
• France ADEME Financial Aid Records — One structured fundingrecord per record from the official public source, logged-out. Public, robots-honoured
• Poland EU-Funded Projects — One funding record per EU-co-financed project in Poland (2021-2027) from the official national project list — beneficiary, programme, value, EU co-fi…
• USAspending Federal Award Watch (post-award) — POST-AWARD ONLY: awards that have already been made, as published by USAspending
• 🏢 About NexGenData — NexGen Watch is NexGenData's fleet of 256 public monitoring and lookup actors built on official sources, pay-per-result. Browse the catalog at apify.com/nexgenwatch.

⭐ Found this useful?

If this actor saved you a manual check, a quick review on the Apify Store helps other teams find it. Feature request or a source that changed? Open it from the Issues tab — every one is read.