EU Groundwater Pollutant Failure Records — EEA WISE

Keyless. Pay per record. Every pollutant assessed against Europe's groundwater bodies — status, risk, and failure flags, verbatim.

This actor turns the European Environment Agency (EEA) WISE Water Framework Directive (WFD) database into clean, per-record data — the pollutant-level chemical assessments of Europe's groundwater bodies. Each run reads the EEA's keyless DiscoData SQL service and delivers one row per pollutant assessment, structured for water-status and catchment analysis, reusable with acknowledgement of the EEA, with no personal data of any kind.

What this is, in one paragraph

Under the Water Framework Directive, each groundwater body is assessed pollutant by pollutant for chemical status. This actor reads that pollutant-assessment table and delivers one record per groundwater body / pollutant / cycle: the country and river basin, the groundwater body, the chemical status value, assessment year and confidence, the pollutant, and the flags for whether it is causing risk or FAILURE, its upward trend and trend reversal, and its background level — all carried as filed. It is the pollutant-failure layer beneath Europe's groundwater chemical status.

Who buys this and for what job

• Groundwater analysts identifying which pollutants drive chemical-status failures by body
• Regulatory and catchment teams tracking the substances behind groundwater failures
• Researchers analysing groundwater pollutant risk and trends across basins
• Data engineers who want the WISE WFD groundwater pollutant assessment table as clean rows from a keyless source.

EEA licence — reuse with acknowledgement

One licence rider travels on every record. EEA data may be reused, including commercially, provided the source is acknowledged: "Source: European Environment Agency (EEA)." Where third-party content is marked, it keeps its own terms. These are reported values and status labels as filed — not a compliance verdict.

Water-body grain — no person data

The unit of every record is a pollutant assessment for a groundwater body — a water body and its reported attributes, never a person. WISE reporting is at water-body / river-basin level: there is no contact, operator, or responsible-person field in the source table, and none is selected or emitted — the query reads only the water-body identity, the status/flags, and the pollutant, status, and risk/failure flags; the free-text 'other' pressure and impact narrative fields are excluded at field selection. A person-key guard runs on every record as a backstop. The file_url points to the official Eionet/CDR reporting file, never a person.

Sample output

Real rows from a live run of this actor (first 5 rows, selected columns).

One full record from the same run, exactly as delivered:

{
  "record_id": ":None:2010",
  "reporting_year": 2010,
  "country_code": "BE",
  "country_name": "Belgium",
  "eu_rbd_code": "BENOORDZEE_FED",
  "rbd_name": "BELGIAN COAST",
  "eu_groundwater_body_code": null,
  "groundwater_body_name": null,
  "chemical_status_value": null,
  "chemical_assessment_year": null,
  "chemical_assessment_confidence": null,
  "at_risk_chemical": null,
  "expected_to_be_at_risk_chemical": null,
  "quantitative_status_value": null,
  "pollutant_code": "None",
  "pollutant_other": null,
  "pollutant_causing_risk": "Unpopulated",
  "pollutant_causing_failure": "Unpopulated",
  "pollutant_upward_trend": "Unpopulated",
  "pollutant_trend_reversal": "Unpopulated",
  "pollutant_background_level_value": "unpopulated",
  "pollutant_background_level_unit": "unpopulated",
  "file_url": null,
  "source": "EEA WISE Water Framework Directive (WFD) — groundwater pollutant assessments",
  "source_url": "https://discodata.eea.europa.eu/",
  "licence": "European Environment Agency (EEA) WISE Water Framework Directive (WFD) database — groundwater pollutant assessments. Reuse is permitted, including for commercial purposes, provided the source is acknowledged: 'Source: European Environment Agency (EEA)'. Third-party content, where marked, keeps its own terms.",
  "attribution": "Source: European Environment Agency (EEA), WISE Water Framework Directive (WFD) database.",
  "disclaimer": "Groundwater pollutant assessments at groundwater-body / pollutant / reporting-cycle grain from the EEA WISE Water Framework Directive database. Each record names a groundwater body, the pollutant, the chemical STATUS LABEL carried VERBATIM (never a compliance verdict), the assessment year and confidence, and flags for whether the pollutant is causing risk or FAILURE and its trend. Water-body grain — there is no contact, operator, or responsible-person field in the source, and none is selected or emitted (free-text 'other' pressure/impact fields excluded at field selection); a person-key guard runs on every record as a backstop.",
  "observed_at": "2026-09-25T17:32:13Z"
}

Pricing

Event	Free plan	Bronze	Silver	Gold / Platinum / Diamond
gw_pollutant_failure_record	$0.05	$0.045	$0.04	$0.0335

Delivered before charged. Blocked runs and empty results cost nothing.

Input

Field	Type	Default	Description
countryCode	string	—	Optional 2-letter country code (e.g. DE, FR).
year	integer	—	Optional reporting cycle year to filter (e.g. 2016, 2022).
maxRecords	integer	500	Ceiling on records delivered and billed.

Output

One JSON object per pollutant assessment. Real example (values as reported):

{
  "record_id": "ATGK100001:Nitrate:2016",
  "reporting_year": 2016,
  "country_code": "AT",
  "country_name": "Austria",
  "eu_rbd_code": "AT1000",
  "rbd_name": "DANUBE",
  "eu_groundwater_body_code": "ATGK100001",
  "groundwater_body_name": "Example GW Body",
  "chemical_status_value": "2",
  "pollutant_code": "Nitrate",
  "pollutant_causing_failure": "Yes",
  "source": "EEA WISE Water Framework Directive (WFD) \u2014 groundwater pollutant assessments",
  "observed_at": "2026-08-22T00:00:00Z"
}

An unbilled RUN_RECEIPT records the robots check, the filters, rows seen and delivered, and whether charged equals delivered.

Field reference

Each record is one pollutant assessment. Identity: record_id, country_code, country_name, eu_rbd_code, rbd_name, eu_groundwater_body_code, groundwater_body_name, and reporting_year. Status: chemical_status_value, chemical_assessment_year, chemical_assessment_confidence, at_risk_chemical, expected_to_be_at_risk_chemical, and quantitative_status_value. Pollutant: pollutant_code, pollutant_other, pollutant_causing_risk, pollutant_causing_failure, pollutant_upward_trend, pollutant_trend_reversal, pollutant_background_level_value, and pollutant_background_level_unit. Plus file_url. Provenance travels on every record: source, source_url, licence, attribution, disclaimer, and observed_at.

How a run works

A run first re-reads the source host's robots posture from your runtime — the EEA DiscoData host — and stops at the door if that ever changes. It pages the WISE WFD groundwater pollutant assessment table (filtered to your optional countryCode and optional year), and flattens each row to one record — carrying every status label and value verbatim, never anything person-shaped — delivered before it is charged, so a blocked or empty run costs you nothing. The actor stops at your maxRecords ceiling and records charge_equals_delivered in the receipt.

Coverage and scope

The table holds on the order of 439,344 rows across reporting countries, river basin districts, and the 2016 and 2022 WFD reporting cycles. Because each record carries the country_code, the water-body identity, and the reporting_year, segmenting by country, basin, or cycle is straightforward. Pull one country, or the whole table to seed a water-status warehouse.

Risk versus failure

The directive distinguishes a pollutant that puts a body at risk of failing from one actually causing failure, and both are reported. Carrying pollutant_causing_risk and pollutant_causing_failure as separate flags lets an analyst separate the current failures from the emerging risks — the pollutants a basin should watch before they tip a body over — and the at_risk_chemical and expected_to_be_at_risk_chemical body-level flags frame each pollutant against the body's overall trajectory. The background-level value and unit add the reference against which an exceedance was judged.

Working with the data

The assessments are a diagnostic layer, and the fields make them queryable. Because every record pairs a pollutant_code with pollutant_causing_failure and the body's chemical_status_value, an analyst can rank which pollutants drive the most groundwater failures in a basin, and the trend flags surface where a pollutant is rising or reversing. The reporting_year lets the 2016 and 2022 cycles be compared.

Identifiers and joins

Every record carries the eu_groundwater_body_code, keying each pollutant assessment to the fleet's groundwater exemption, threshold-value, and surface-water-linkage cells for the same body, on a shared identifier rather than a fuzzy name match.

Cost guidance

One gw_pollutant_failure_record per delivered row: cost = rows delivered × your plan's per-record price. Scope with countryCode and year to keep runs bounded. 1,000 rows is $50 (Free) / $33.50 (Gold).

Honest limitations

• As reported. Status labels, reasons, and values are as filed by member states for the WFD reporting cycle; this actor reformats, it does not audit or recompute.
• A label, not a verdict. These are reported classifications, assessments, and reasons, not an independent compliance assessment.
• Two cycles merged. The table carries both the 2016 and 2022 reporting cycles; the reporting_year field distinguishes them.
• Acknowledge the EEA. The acknowledgement travels on every record.
• No person data of any kind.

Differentiation

It is distinct from eu-groundwater-chemical-exemption-records — that cell records the EXEMPTIONS claimed for a pollutant, while this cell records the failure ASSESSMENT (which pollutant is causing risk or failure and its status). Its specific job is the WFD groundwater pollutant assessments.

The NexGen Signal family

Part of the NexGen Signal family of pay-per-record data products:

• EU Groundwater Chemical Exemption Records — EEA WISE
• EU Surface Water Chemical Exemption Records — EEA WISE
• EU Pressure Substance Failure Records — EEA WISE
• EU Surface Water Failing Pollutant Records — EEA WISE
• EU Waterbody Quality Records — EEA

Source: European Environment Agency (EEA), WISE Water Framework Directive (WFD) database (discodata.eea.europa.eu). EEA data may be reused, including commercially, provided the source is acknowledged: "Source: European Environment Agency (EEA)"; marked third-party content keeps its own terms. Groundwater-body / pollutant / cycle grain; no contact/operator/responsible-person field selected or emitted, free-text 'other' narrative excluded. No natural-person data of any kind. Values and status labels as filed, not a compliance verdict.