defensivos_tecnicos v1.1¶
Current technical pesticide registrations from Agrofit/MAPA.
Source: MAPA. Contract registry key: agrofit_tecnicos.
Schema¶
| Column | Type | Nullable | Unit |
|---|---|---|---|
nr_registro |
str | No | — |
marca_comercial |
str | Yes | — |
ingrediente_ativo |
str | Yes | — |
titular |
str | Yes | — |
classe |
str | Yes | — |
grupo_quimico |
str | Yes | — |
nome_cientifico |
str | Yes | — |
classe_toxicologica |
str | Yes | — |
classe_ambiental |
str | Yes | — |
composicao_texto |
str | Yes | — |
Primary key: nr_registro
All stable columns must exist, including nullable columns and empty results. Breaking schema changes require a major contract version.
Semantics and provenance¶
One row per textual registration. Compound ingredient and chemical-group labels are not split at arbitrary parentheses. composicao_texto retains the published cell; detailed composition is available through composicao_defensivos(tipo="tecnicos").
return_meta=True returns data and MetaInfo, including attempted/selected sources, acquisition time, contract version and source diagnostics. These current publications do not support selecting a historical revision through deterministic.
Parameters¶
| Parameter | Type | Default |
|---|---|---|
ingrediente_ativo |
str \| None |
None |
titular |
str \| None |
None |
classe |
str \| None |
None |
marca |
str \| None |
None |
nr_registro |
str \| None |
None |
use_cache |
bool |
True |
as_polars |
bool |
False |
return_meta |
bool |
False |
Example¶
from agrobr import contracts, datasets
df, meta = await datasets.defensivos_tecnicos(nr_registro="00301", return_meta=True)
contracts.validate_dataset(df, "agrofit_tecnicos")
Use from agrobr.sync import datasets for synchronous calls, without await. as_polars=True requires pip install agrobr[polars].
JSON schema and licence¶
agrobr/schemas/agrofit_tecnicos.json · get_contract("agrofit_tecnicos").
livre — see data licences and the API/source details.
Export of 2026-09-18¶
The two CSVs of the 2026-09-18 export contain 4,403 formulated products, 279,707 authorization occurrences and 2,992 technical products. Two ambiguous expressions in that export, 1.9 10*10 UFC/g and 200 1x10E10 UFC/g, retain their text and come out with null value and unit and a diagnostic. Numeric interpretation is not guaranteed for the whole component population.
The cache retains non-null values, dtypes, component position and UTC provenance; None and pd.NA are equivalent only in nullable fields. Composition and situation text retain the literal; other fields retain the documented cleanup. Authorizations are not deduplicated.
A suffix published in the concentration fields can include an ambiguous expression and does not by itself certify a measurement unit or numeric interpretation. Catalogue, CSV and cache share an origin: none of them confirms the historical population.