My LibraryCart 2

Pesticides

EU Pesticide Active Substance Relationships Dataset

EU Pesticide Active Substance Relationships Dataset

19,00 €

Work with EU active-substance, group-member and pesticide-residue relationships in a documented export designed for structured analysis.

Purchase terms

Your purchase includes the edition described on this page. Later releases are separate unless this offer explicitly includes an update entitlement.

Source checks and new-release publication do not change the historical coverage or automatically add future editions to an earlier purchase.

Edition details

Edition
zf-016-2026-09-05-455141dbe3cf
Files
data/full.jsonl, data/full.csv, data/sample.json, schema.json, provenance.json, manifest.json, quality-report.json, LICENSE.md, README.md, CHANGELOG.md, sources/active-substances.ndjson, checksums.json
Formats
CSV, JSON, JSONL, MD, NDJSON
Coverage
Complete DG SANTE active-substance API export retrieved 2026-09-05. Rows preserve source relationships between substances, group members and pesticide residues.
Geographic scope
Complete DG SANTE active-substance API export retrieved 2026-09-05. Rows preserve source relationships between substances, group members and pesticide residues.
Publisher
European Commission DG SANTE
Source updated
Explicitly unknown; see immutable provenance for the recorded source retrieval.
Source checked
2026-09-05T11:48:49.388930+00:00
Released
2026-09-05T11:48:49.388930+00:00
Licence and attribution
Source records remain subject to the original publisher terms linked in provenance.json. Retain attribution and source notices. Zentra grants use of the normalization, schema and packaging for internal and commercial analysis; this does not grant exclusive rights over public source facts or third-party material. No endorsement by source publishers.

View the publisher source

Schema

FieldTypeDescription
ac_typenull|integer
active_substance_part_of_groupstring|null
active_substance_part_of_group_idinteger|null
approval_datenull|string
as_cas_numberstring|null
as_is_groupstring
as_member_idinteger|null
as_member_namestring|null
as_micro_orgstring
authorisations_at_nat_levelnull|string
basic_substancestring
candidate_for_substitutionstring
candidate_for_substitution_typenull|string
classification_reg_1272null|string
cormsstring|null
expiry_datenull|string
legislations_activesstring|null
legislations_oldstring|null
low_risk_active_substancestring
pest_res_linked_annexstring|null
pest_res_linked_legislationstring|null
pest_res_linked_legislation_urlstring|null
pest_res_mrl_webpagestring|null
pesticide_residue_linkedstring
remarkstring|null
risk_assessmentnull|string
rmsstring|null
substance_categorynull|string
substance_idinteger
substance_namestring
substance_statusstring
tox_remark_aaoelnull|string
tox_remark_adinull|string
tox_remark_aoelnull|string
tox_remark_arfdnull|string
tox_remark_othernull|string
tox_sourc_earfdstring|null
tox_source_aaoelnull|string
tox_source_adistring|null
tox_source_aoelstring|null
tox_source_earfdstring|null
tox_source_othernull|string
tox_value_aaoelnull|string
tox_value_adistring|null
tox_value_aoelstring|null
tox_value_arfdstring|null
tox_value_othernull|string

Sample preview

Open the public sample

ac_typeactive_substance_part_of_groupactive_substance_part_of_group_idapproval_dateas_cas_numberas_is_groupas_member_idas_member_nameas_micro_orgauthorisations_at_nat_levelbasic_substancecandidate_for_substitutioncandidate_for_substitution_typeclassification_reg_1272cormsexpiry_date
Fatty acids C7 to C20 (Pelargonic acid (CAS 112-05-0))113143-07-7No221Methyl decanoate (CAS 110-42-9)NoNoNoAT
2312-35-8NoNoNoNoAcute Tox. 3 - H331; Aquatic Acute 1 - H400; Aquatic Chronic 1 - H410; Carc. 2 - H351; Eye Dam. 1 - H318; Skin Irrit. 2 - H315
116-06-3NoNoNoNoAcute Tox. 2 - H300; Acute Tox. 2 - H330; Acute Tox. 3 - H311; Aquatic Acute 1 - H400; Aquatic Chronic 1 - H410
2302-17-2NoNoNoNoAquatic Acute 1 - H400; Aquatic Chronic 1 - H410; Skin Sens. 1 - H317
No CAS allocatedNoNoNoNo
01/08/2013374726-62-2NoNoAT, BE, BG, CY, CZ, DE, DK, EE, EL, ES, FI, FR, HR, HU, IE, IT, LT, LU, LV, MT, NL, NO, PL, PT, RO, SE, SI, SKNoNoAquatic Acute 1 - H400; Aquatic Chronic 1 - H410PT30/06/2029
01/05/2014422556-08-9NoNoAT, BE, BG, CY, CZ, DE, DK, EE, EL, ES, FI, FR, HR, HU, IE, IT, LT, LU, LV, NL, NO, PL, PT, RO, SE, SI, SKNoNoAquatic Acute 1 - H400; Aquatic Chronic 1 - H410; Skin Sens. 1 - H317FI30/09/2027
01/07/20068018-01-7NoNoNoNoAcute Tox. 4 - H332; Aquatic Acute 1 - H400; Aquatic Chronic 1 - H410; Eye Irrit. 2 - H319; Repr. 2 - H361d; Skin Sens. 1 - H317UK31/01/2017
Category:

Explore how active substances connect to group members and pesticide residues in the DG SANTE export. The download preserves relationship records so the source model can be analysed without flattening every repeated identifier into a supposed duplicate.

What this download contains

This is not a one-row-per-substance directory. Repeated identifiers can carry legitimate relationships, and removing them without understanding the schema can discard meaning. Status and legislation context must accompany the identifiers wherever the data is used.

Working with this edition

Load the relationship table with its field definitions, inspect the sample and choose join keys deliberately. Use source legislation for authoritative interpretation and avoid treating a reference relationship as a recommendation to use a substance.

Product questions

Is the row count the number of unique active substances?

No. The row count describes source relationships. Unique substances must be counted using the documented identifiers.

Does the dataset establish whether a substance may be used?

It is a reference export. Applicable conditions and authoritative requirements must be checked in the cited legislation.

Reviews

There are no reviews yet.

Be the first to review “EU Pesticide Active Substance Relationships Dataset”

Your email address will not be published. Required fields are marked *

Related products