defensivos_formulados v1.1¶

Current formulated pesticide registrations from Agrofit/MAPA.

Source: MAPA. Contract registry key: agrofit_formulados.

Schema¶

Column	Type	Nullable	Unit
`nr_registro`	str	No	—
`marca_comercial`	str	Yes	—
`ingrediente_ativo`	str	Yes	—
`titular`	str	Yes	—
`classe`	str	Yes	—
`formulacao`	str	Yes	—
`classe_toxicologica`	str	Yes	—
`classe_ambiental`	str	Yes	—
`organicos`	str	Yes	—
`modo_de_acao`	str	Yes	—
`situacao`	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 published registration, retained as text. situacao and composicao_texto preserve the original content. Use composicao_defensivos for components and concentrations; this product table does not create one row per ingredient.

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`
`classe_toxicologica`	`str \\| None`	`None`
`classe_ambiental`	`str \\| None`	`None`
`titular`	`str \\| None`	`None`
`organicos`	`str \\| None`	`None`
`marca`	`str \\| None`	`None`
`formulacao`	`str \\| None`	`None`
`classe`	`str \\| None`	`None`
`nr_registro`	`str \\| None`	`None`
`situacao`	`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_formulados(nr_registro="08725", return_meta=True)
contracts.validate_dataset(df, "agrofit_formulados")

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_formulados.json · get_contract("agrofit_formulados").

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.