EU Surface Water Priority Substance Records — EEA WISE

Keyless. Pay per record. Every EU priority substance assessed against Europe's surface waters — status, monitoring, and failure, verbatim.

This actor turns the European Environment Agency (EEA) WISE Water Framework Directive (WFD) database into clean, per-record data — the priority-substance chemical assessments of Europe's surface water bodies. Each run reads the EEA's keyless DiscoData SQL service and delivers one row per priority-substance 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, surface water bodies are assessed against the EU list of priority substances for chemical status. This actor reads that priority-substance table and delivers one record per water body / substance / cycle: the country, river basin, and water body; the chemical status value, assessment year, confidence, and monitoring results; the priority substance; the uPBT flag; and whether the substance is causing failure or exceeds in a mixing zone — all carried as filed. It is the priority-substance assessment layer of Europe's surface-water chemical status.

Who buys this and for what job

• Water-quality analysts identifying which priority substances drive surface-water chemical failures
• Chemicals-policy and pollution researchers tracking priority-substance assessments across basins
• ESG and catchment products attributing chemical failures to specific substances
• Data engineers who want the WISE WFD surface-water priority-substance 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 priority-substance assessment for a surface water 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 priority substance, status, and 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.

A required partition — this is a large dataset

The table holds 872,547 rows, so this actor requires a partition: every run must set a countryCode. The country bounds the run; there is no unbounded all-Europe pull. An optional year (reporting cycle) filter narrows further, and maxRecords is the hard ceiling.

Pricing

Event	Free plan	Bronze	Silver	Gold / Platinum / Diamond
sw_priority_substance_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	—	REQUIRED 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 priority-substance assessment. Real example (values as reported):

{
  "record_id": "ATOK1000010000:Mercury and its compounds:2016",
  "reporting_year": 2016,
  "country_code": "AT",
  "country_name": "Austria",
  "eu_rbd_code": "AT1000",
  "rbd_name": "DANUBE",
  "eu_surface_water_body_code": "ATOK1000010000",
  "surface_water_body_name": "Example Reach",
  "chemical_status_value": "2",
  "priority_substance_code": "Mercury and its compounds",
  "priority_substance_causing_failure": "Yes",
  "upbt": "Yes",
  "source": "EEA WISE Water Framework Directive (WFD) \u2014 surface-water priority-substance 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 priority-substance assessment. Identity: record_id, country_code, country_name, eu_rbd_code, rbd_name, eu_sub_unit_code, sub_unit_name, eu_surface_water_body_code, surface_water_body_name, surface_water_body_category, and reporting_year. Status: ecological_status_or_potential_value, chemical_status_value, chemical_assessment_year, chemical_assessment_confidence, and chemical_monitoring_results. Substance: priority_substance_code, priority_substance_causing_failure, priority_substance_exceedance_in_mixing_zone, and upbt. 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 surface-water priority-substance assessment table (filtered to your required 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 872,547 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.

Working with the data

The assessments are a chemicals ledger, and the fields make them analysable. Because every record pairs a priority_substance_code with priority_substance_causing_failure and the body's chemical_status_value, an analyst can see which substances drive surface-water chemical failures, and the upbt flag isolates the ubiquitous persistent substances. The reporting_year tracks change between cycles.

Identifiers and joins

Every record carries the eu_surface_water_body_code, keying each assessment to the fleet's surface-water chemical-exemption and failing-pollutant cells for the same body, on a shared identifier.

Cost guidance

One sw_priority_substance_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

This is a net-new category for the NexGenData fleet. It is distinct from eu-surface-water-chemical-exemption-records (the EXEMPTIONS on priority substances) and from eu-surface-water-failing-pollutant-records (river-basin-specific pollutants) — this cell carries the priority-substance ASSESSMENT itself. Its specific job is the WFD surface-water priority-substance 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. Water-body / priority-substance / 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.