{"id":"f9c96d91-c544-489e-9cb1-829304066ac1","type":"DATASET","name":"Table publisher","slug":"table-publisher","description":"The WISE Statistics - pesticides tables are aggregated products used for the calculation of the annual Freshwater indicator „Pesticides in rivers, lakes and groundwater in Europe“, which is published on the EEA website. The data tables include pesticide concentration data aggregated by monitoring site and year (annual average). They were reported annually either in disaggregated or aggregated form via WISE-SoE reporting as part of the WISE-6 data flow. Moreover, the tables include data on effect thresholds for pesticides (e.g. Environmental Quality Standards, EQS) used for the calculation of the indicator. In addition, tables are provided with the underlying spatial data and with summary statistics (mean, SD, minimum, maximum and percentiles) of the reported pesticide concentrations per water body category (i.e. surface water, groundwater).","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":null,"docs_url":null,"repo_url":"https://discomap.eea.europa.eu/App/DiscodataViewer?fqn=%5BWISE_Indicators%5D.%5Bv6r1%5D.%5BSpatialData_Country%5D","status":"ACTIVE","verification_state":"VERIFIED","tags":["water","environment"],"logo_url":"https://discomap.eea.europa.eu/App/DiscodataViewer/favicon-32x32.png","primary_source_url":"https://discomap.eea.europa.eu/App/DiscodataViewer?fqn=%5BWISE_Indicators%5D.%5Bv6r1%5D.%5BSpatialData_Country%5D","extraction_confidence":"0.30","created_at":"2026-06-16T02:10:38.630Z","updated_at":"2026-08-16T08:59:40.966Z","last_verified_at":"2026-08-16T08:59:40.966Z","deprecated_at":null,"ranking_score":56,"last_ranked_at":"2026-08-09T03:31:57.522Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-08-02T09:44:05.526Z","search_vector":"'-6':70B,175B,301B,406B 'addit':96B 'addition':327B 'agenc':140B 'agency':371B 'aggreg':9B,42B,58B,131B,156B,182B 'aggregated':240B,273B,289B,362B,387B,413B 'along':202B,433B 'also':186B,417B 'and':255B,277B,336B,344B,380B,391B,438B,447B 'annual':17B,48B,53B,137B,248B,279B,368B 'annually':284B 'are':239B,329B 'as':296B,401B,422B 'averag':49B 'average':280B 'bodi':122B,225B 'body':353B,458B 'broken':221B,454B 'by':274B,388B,456B 'calcul':14B,91B,135B,201B 'calculate':366B 'calculation':245B,322B,432B 'categori':123B,226B 'category':354B,459B 'concentr':40B,119B,154B,220B 'concentration':271B,385B 'concentrations':350B,453B 'contain':187B,418B 'data':36B,41B,71B,77B,104B,155B,176B,206B,267B,272B,302B,308B,335B,386B,407B,437B 'dataset':129B,360B 'deviat':212B 'deviation':444B 'disaggreg':56B,180B 'disaggregated':287B,411B 'down':455B 'e.g':83B,314B 'eea':33B,141B,264B,372B 'effect':79B,188B,310B,419B 'either':54B,178B,285B,409B 'environ':139B,231C 'environment':84B,192B,370B 'environmental':315B,423B 'eq':87B,195B 'eqs':318B,426B 'europ':27B 'europe':258B 'european':138B,369B 'flow':72B,177B,303B,408B 'for':243B,312B,320B 'form':59B,183B,290B,414B 'freshwat':18B,142B 'freshwater':249B,373B 'groundwat':25B,127B,150B,229B 'groundwater':256B,358B,381B,462B 'i.e':124B,355B 'in':252B,257B,286B,326B,377B,410B,428B 'includ':38B,76B,152B 'include':269B,307B 'includes':383B 'indic':19B,94B,143B,199B 'indicator':250B,325B,374B,430B 'is':260B 'it':382B 'lake':23B,148B 'lakes':254B,379B 'maximum':112B,214B,343B,446B 'mean':109B,210B,340B,442B 'minimum':111B,213B,342B,445B 'monitor':44B,158B 'monitoring':275B,389B 'moreov':73B 'moreover':304B 'of':246B,298B,323B,346B,403B,450B 'on':262B,309B,375B 'or':288B,412B 'part':66B,171B,297B,402B 'per':120B,351B 'percentil':114B,216B 'percentiles':345B,449B 'percentiles-of':448B 'pesticid':6B,20B,39B,82B,118B,145B,153B,219B 'pesticide':270B,349B,384B,452B 'pesticides':237B,251B,313B,376B 'process':169B,400B 'product':10B 'products':241B 'provid':99B,130B 'provided':330B 'provides':361B 'publish':2A,30B 'published':261B 'publisher':233A 'qualiti':85B,193B 'quality':316B,424B 'report':52B,64B,117B,162B,168B,218B 'reported':283B,348B,393B,451B 'reporting':295B,399B 'river':22B,147B 'rivers':253B,378B 's':431B 'sd':110B,341B 'site':45B,159B,276B,390B 'soe':63B,167B,294B,398B 'spatial':103B,205B,334B,436B 'standard':86B,194B,211B,443B 'standards':317B,425B 'statist':5B,108B,209B 'statistics':236B,339B,441B 'statistics-mean':440B 'such':421B 'summari':107B,208B 'summary':338B,439B 'surfac':125B,227B 'surface':356B,460B 'tabl':1A,7B,37B,75B,97B,132B,185B 'table':232A 'tables':238B,268B,306B,328B,363B,416B 'the':234B,244B,247B,263B,266B,299B,305B,321B,324B,332B,347B,367B,395B,404B,415B,429B 'they':281B 'this':359B 'threshold':80B,189B 'thresholds':311B,420B 'through':394B 'to':365B 'under':102B,204B 'underlying':333B,435B 'use':11B,88B,133B,196B 'used':242B,319B,364B,427B 'via':60B,291B 'water':121B,126B,224B,228B,230C,352B,357B,457B,461B 'websit':34B 'website':265B 'were':282B 'which':259B 'wise':4B,62B,69B,166B,174B,235B,293B,300B,397B,405B 'wise-so':61B,165B 'wise-soe':292B,396B 'with':331B,337B,434B 'year':47B,161B,278B,392B","popularity_score":"0.0000","maintenance_score":"0.7000","institution_id":"9389c883-d002-49ab-97fd-b0185412535b","institution_type":"INTERGOVERNMENTAL_ORG","country_code":"EU","official_confidence":null,"proof_summary":null,"source_seed_url":null,"is_public_sector":true,"published_at":"2026-06-16T02:10:38.630Z","geographic_scope":"EUROPEAN","name_en":null,"description_en":"This dataset provides aggregated tables used to calculate the annual European Environment Agency (EEA) Freshwater indicator on pesticides in rivers, lakes and groundwater. It includes pesticide concentration data aggregated by monitoring site and year, reported through the WISE-SoE reporting process as part of the WISE-6 data flow, either in disaggregated or aggregated form. The tables also contain effect thresholds such as Environmental Quality Standards (EQS) used in the indicator's calculation, along with underlying spatial data and summary statistics—mean, standard deviation, minimum, maximum, and percentiles—of reported pesticide concentrations, broken down by water body category (surface water, groundwater).","native_lang":"en","access_level":"direct","formats":[],"capability_tier":"download","trust_score":43.269230769230774,"access":{"level":"direct","primary":{"kind":"download","label":"Download data","method":"GET","url":"https://discomap.eea.europa.eu/App/DiscodataViewer/?fqn=[WISE_Indicators].[v6r1].[SpatialData_Country]","source":"distribution","runnable":true},"actions":[{"kind":"download","label":"Download data","method":"GET","url":"https://discomap.eea.europa.eu/App/DiscodataViewer/?fqn=[WISE_Indicators].[v6r1].[SpatialData_Country]","source":"distribution","runnable":true},{"kind":"landing","label":"Open source page","method":"GET","url":"https://discomap.eea.europa.eu/App/DiscodataViewer/?fqn=[WISE_Indicators].[v6r1].[SpatialData_MonitoringSite]","source":"landing_page","runnable":false},{"kind":"landing","label":"Open source record","method":"GET","url":"https://discomap.eea.europa.eu/App/DiscodataViewer?fqn=%5BWISE_Indicators%5D.%5Bv6r1%5D.%5BSpatialData_Country%5D","source":"primary_source","runnable":false}],"formats":[]},"maturity":{"entry_id":"f9c96d91-c544-489e-9cb1-829304066ac1","granularity":"entry","granularity_label":"One unit = one catalog entry. A PROXY for the SCOPE.md §4 ladder, which governs source families, not entries: a family with 400 entries moves this reading 400 times as much as a family with one. Never compare or combine with the source_family reading.","level":"verified","level_index":2,"level_label":"Verified","meaning":"Access tested successfully","counts_as_coverage":false,"blocked_by":null,"rungs":[{"level":"discovered","level_index":1,"label":"Discovered","meaning":"Source and metadata recorded","evidence":"membership of the named population the ladder is taken over","counts_as_coverage":false,"met":true,"reached":true,"criterion":"TRUE"},{"level":"verified","level_index":2,"label":"Verified","meaning":"Access tested successfully","evidence":"entries.verification_state = 'VERIFIED'","counts_as_coverage":false,"met":true,"reached":true,"criterion":"entries.verification_state = 'VERIFIED'"},{"level":"profiled","level_index":3,"label":"Profiled","meaning":"Schema, dimensions and licence understood","evidence":"a data profile with at least one field (entry_data_profiles.field_count > 0)","counts_as_coverage":false,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_data_profiles p WHERE p.entry_id = entries.id AND COALESCE(p.field_count, 0) > 0)"},{"level":"executable","level_index":4,"label":"Executable","meaning":"Queries run through Commodity","evidence":"entries.capability_tier = 'live' — today's proxy for \"queryable through us\"","counts_as_coverage":true,"met":false,"reached":false,"criterion":"entries.capability_tier = 'live'"},{"level":"joinable","level_index":5,"label":"Joinable","meaning":"Canonical identifiers and concepts mapped","evidence":"a field link to a canonical identifier whose sampled VALUES match its format","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_field_links efl WHERE efl.entry_id = entries.id AND efl.identifier_id IS NOT NULL AND efl.value_status = 'match')"},{"level":"reproducible","level_index":6,"label":"Reproducible","meaning":"Snapshots and transformation evidence retained","evidence":"at least one retained evidence manifest (migration 078)","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM evidence_manifests em WHERE em.entry_id = entries.id)"},{"level":"guaranteed","level_index":7,"label":"Guaranteed","meaning":"Monitored against an operational reliability target","evidence":"an active reliability target with a named monitor (migration 096)","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_reliability_targets rt WHERE rt.entry_id = entries.id AND rt.is_active = true)"}],"officialness":{"basis":"catalog_inherited","label":"Inherited from the upstream catalog: this item came from a trusted official government catalog, and that provenance — not per-item proof — is the warrant. Its own proof score is below 80 or it matched no registered institution (apps/worker/src/connectors/catalog/qualify-store.ts).","proof_confidence":null,"proven_threshold":80,"institution_id":"9389c883-d002-49ab-97fd-b0185412535b","definition":"CASE WHEN COALESCE(entries.is_public_sector, false) IS NOT TRUE THEN 'not_official' WHEN COALESCE(entries.official_confidence, 0) >= 80 AND entries.institution_id IS NOT NULL THEN 'per_item_proven' ELSE 'catalog_inherited' END"},"source_family":{"key":"discomap.eea.europa.eu","label":"One unit = one source family, approximated by the serving host of the entry's primary source URL (e.g. bdl.stat.gov.pl). A COMPUTED stand-in for the curated families of SCOPE.md §5, which no table holds yet. A family sits at the highest level any of its entries has reached, because a family is integrated to the depth of its deepest working integration. Never compare or combine with the entry reading."},"generated_at":"2026-08-16T13:48:43.626Z"},"api_details":null,"dataset_details":{"id":"f17bdc49-c296-4260-8a43-74a4fb1c72d4","entry_id":"f9c96d91-c544-489e-9cb1-829304066ac1","upstream_issued":"2026-02-02T00:00:00.000Z","upstream_modified":null,"themes":["ENVI"],"update_frequency":null,"temporal_start":null,"temporal_end":null,"spatial_coverage":null,"landing_page":"https://discomap.eea.europa.eu/App/DiscodataViewer/?fqn=[WISE_Indicators].[v6r1].[SpatialData_MonitoringSite]","license_id":null,"license_raw":null,"has_documentation":true,"has_data_dictionary":false,"has_versioning":false,"source_portal":null,"source_portal_url":null,"created_at":"2026-06-16T02:10:38.789Z","updated_at":"2026-06-16T02:10:38.789Z","publisher":null,"publisher_url":null,"distributions":[{"id":"042bc624-3d7a-45a3-a501-37075d7952bb","dataset_details_id":"f17bdc49-c296-4260-8a43-74a4fb1c72d4","title":"SpatialData_Country","description":null,"access_url":"https://discomap.eea.europa.eu/App/DiscodataViewer/?fqn=[WISE_Indicators].[v6r1].[SpatialData_Country]","download_url":null,"media_type":null,"format":null,"byte_size":null,"license_id":null,"license_raw":null,"last_checked_at":"2026-08-16T08:59:37.992Z","is_available":true,"last_http_status":200,"created_at":"2026-06-16T02:10:39.101Z","updated_at":"2026-08-16T08:59:37.992Z"}],"license":null},"license":null,"reuse":{"license_id":null,"license_name":null,"license_url":null,"commercial_use":{"status":"unknown","value":null},"redistribution":{"status":"unknown","value":null},"attribution_required":{"status":"unknown","value":null},"share_alike":{"status":"unknown","value":null},"personal_data_warning":{"status":"unknown","value":null},"cache_and_mirror":{"status":"unknown","value":null},"undetermined":["commercial_use","redistribution","attribution_required","share_alike","personal_data_warning","cache_and_mirror"],"basis":"unverified","confidence":0.1,"confidence_tier":"low","source_text":null,"source_url":null,"reviewed_at":null},"license_raw":null,"latest_check":{"id":"bdf80b61-d82f-4a46-9bfa-ebf7bb9b5b97","entry_id":"f9c96d91-c544-489e-9cb1-829304066ac1","status":"VERIFIED","last_checked_at":"2026-08-16T08:59:40.475Z","p50_latency_ms":1737,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-06-16T02:11:57.908Z","updated_at":"2026-08-16T08:59:40.475Z","consecutive_successes":149,"probe_url":"https://discomap.eea.europa.eu/App/DiscodataViewer/?fqn=[WISE_Indicators].[v6r1].[SpatialData_Country]","probe_method":"GET","probe_http_status":200,"probe_content_type":"text/html","probe_succeeded_at":"2026-08-16T08:59:40.475Z"},"data_profile":{"id":"4389a44c-5c8e-4783-afca-900bd51189d2","entry_id":"f9c96d91-c544-489e-9cb1-829304066ac1","profile_source":"none","profile_kind":"dataset","dataset_id":null,"fields":null,"field_count":null,"sample_records":null,"record_count":null,"data_size_bytes":null,"dataset_count":null,"query_examples":null,"status":"unsupported","error_message":"No introspectable source detected (primary URL sniffed: not machine-readable data)","profiled_at":"2026-07-20T14:11:57.947Z","run_id":"f7bee8d3-ef38-4629-8a8b-c3ccfc71d9da","created_at":"2026-07-20T14:11:57.947Z","updated_at":"2026-07-20T14:11:57.947Z","license_raw":null,"license_id":null,"consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":false},"datasets":[],"limits":[]}