sources
Data license: CC-BY
1 row where datasetId = 5053 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
---|---|---|---|---|---|---|---|---|
17784 | Inputs: Pesticides Use | { "link": "http://www.fao.org/faostat/en/?#data/", "retrievedDate": "13-Feb-2020", "additionalInfo": "The Pesticides Use database includes data on insecticides, fungicides, herbicides, disinfectants and any substance or mixture of substances intended for preventing, destroying or controlling any pest, including vectors of human or animal disease, unwanted species of plants or animals causing harm during or otherwise interfering with the production, processing, storage, transport or marketing of food, agricultural commodities, wood and wood products or animal feedstuffs, or substances which may be administered to animals for the control of insects, arachnids or other pests in or on their bodies. The term also includes substances intended for use as a plant growth regulator, defoliant, desiccant or agent for thinning fruit or preventing the premature fall of fruit, and substances applied to crops either before or after harvest to protect the commodity from deterioration during storage and transport. The pesticides are classified according to: (a) the type of activity/target organism (e.g. fungicides, insecticides, herbicides, plant growth regulators, rodenticides and etc.) and (b) the chemical nature (e.g. organophosphates, pyrethroids). The classification adopted in the Pesticide (use) database is organized as follows: 1. INSECTICIDES (Chlorinated hydrocarbons, Organo\u2013phosphates, Carbamates\u2013insecticides, Pyrethroids, Botanical and biological products and Others not elsewhere classified ); 2. MINERAL OILS; 3. HERBICIDES (Phenoxy hormone products, Triazines, Amides, Carbamates\u2013herbicides, Dinitroanilines, Urea derivatives, Sulfonyl urea, Bipiridils, Uracil, Others not elsewhere classified); 4. FUNGICIDES AND BACTERICIDES (Inorganic, Dithiocarbamates, Benzimidazoles, Triazoles Diazoles, Diazines Morpholines, Others not elsewhere classified); 5. SEED TREATMENT \u2013 FUNGICIDES (Dithiocarbamates, Benzimidazoles, Triazoles Diazoles, Diazines Morpholines, Botanical products and biological, Others not elsewhere classified); 6. SEED TREATMENT \u2013 INSECTICIDES (Organo-phosphates, Carbamates\u2013insecticides, Pyrethroids, Others not elsewhere classified); 7. PLANT GROWTH REGULATORS; 8. RODENTICIDES (Anti\u2013coagulants, Cyanide Generators, Hypercalcaemics, Narcotics, Others not elsewhere classified); 9. OTHER PESTICIDES NES (not elsewhere specified); 10. DISINFECTANTS.", "dataPublishedBy": "Food and Agriculture Organization of the United Nations (FAO) (2020)", "dataPublisherSource": "Primary data source: FAO Questionnaire on Pesticides Use. These official statistics may be complemented with government data sources such as yearbooks and ministerial data portals. Data gaps may be filled with secondary sources such as country studies from other International organizations. Data are flagged according to the type of data and the source." } |
2020-02-14 03:21:37 | 2020-02-14 03:21:37 | Inputs: Pesticides Use 5053 | The Pesticides Use database includes data on insecticides, fungicides, herbicides, disinfectants and any substance or mixture of substances intended for preventing, destroying or controlling any pest, including vectors of human or animal disease, unwanted species of plants or animals causing harm during or otherwise interfering with the production, processing, storage, transport or marketing of food, agricultural commodities, wood and wood products or animal feedstuffs, or substances which may be administered to animals for the control of insects, arachnids or other pests in or on their bodies. The term also includes substances intended for use as a plant growth regulator, defoliant, desiccant or agent for thinning fruit or preventing the premature fall of fruit, and substances applied to crops either before or after harvest to protect the commodity from deterioration during storage and transport. The pesticides are classified according to: (a) the type of activity/target organism (e.g. fungicides, insecticides, herbicides, plant growth regulators, rodenticides and etc.) and (b) the chemical nature (e.g. organophosphates, pyrethroids). The classification adopted in the Pesticide (use) database is organized as follows: 1. INSECTICIDES (Chlorinated hydrocarbons, Organo–phosphates, Carbamates–insecticides, Pyrethroids, Botanical and biological products and Others not elsewhere classified ); 2. MINERAL OILS; 3. HERBICIDES (Phenoxy hormone products, Triazines, Amides, Carbamates–herbicides, Dinitroanilines, Urea derivatives, Sulfonyl urea, Bipiridils, Uracil, Others not elsewhere classified); 4. FUNGICIDES AND BACTERICIDES (Inorganic, Dithiocarbamates, Benzimidazoles, Triazoles Diazoles, Diazines Morpholines, Others not elsewhere classified); 5. SEED TREATMENT – FUNGICIDES (Dithiocarbamates, Benzimidazoles, Triazoles Diazoles, Diazines Morpholines, Botanical products and biological, Others not elsewhere classified); 6. SEED TREATMENT – INSECTICIDES (Organo-phosphates, Carbamates–insecticides, Pyrethroids, Others … | http://www.fao.org/faostat/en/?#data/ | Food and Agriculture Organization of the United Nations (FAO) (2020) |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "sources" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(512) NULL , "description" TEXT NOT NULL , "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , "updatedAt" DATETIME NULL , "datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL, FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT ); CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");