Baselight

Emissions Of Pesticide Active Substances In The European Union

Joint Research Centre

@ecjrc.bf95e015_e041_4882_81fa_f2b283786d5c

Table 1
@ecjrc.bf95e015_e041_4882_81fa_f2b283786d5c.table_1

The dataset include the prediction of active ingredient use (kilograms) per region, the common name, the CAS (Chemical Abstracts Service Council number identifier), the CIPAC (Collaborative International Pesticides Analytical Council number identifier), the ID_EUPDB (identifier in the European Union Database of pesticides) and the Chemical Class for each active substance

  • 3.22 MB
  • 205289 rows
  • 15 columns
country

COUNTRY

nuts3

NUTS3

categories_of_products

Categories Of Products

chemical_class_substance

Chemical Class Substance

id_eupdb

ID EUPDB

cas

CAS

cipac

CIPAC

substances_common_names

Substances Common Names

arab_kg

Arab KG

fruit_kg

Fruit KG

oliv_kg

Oliv KG

vines_kg

Vines KG

grass_kg

Grass KG

rice_kg

Rice KG

kg_tot

KG TOT

ATAT111Other fungicides and bactericidesANILIDE FUNGICIDES1040188425-85-6673BOSCALID760.385094494266223.225550778779983.610645273045
ATAT112Other fungicides and bactericidesANILIDE FUNGICIDES1040188425-85-6673BOSCALID2702.23472646143409.2020762848953111.43680274633
ATAT113Other fungicides and bactericidesANILIDE FUNGICIDES1040188425-85-6673BOSCALID1521.0927302409261.5204913050311782.61322154593
ATAT121Other fungicides and bactericidesANILIDE FUNGICIDES1040188425-85-6673BOSCALID2262.038900314432262.03890031443
ATAT122Other fungicides and bactericidesANILIDE FUNGICIDES1040188425-85-6673BOSCALID702.78878937603151.433720247066854.222509623096
ATAT123Other fungicides and bactericidesANILIDE FUNGICIDES1040188425-85-6673BOSCALID1122.9370723445377.67193385259941200.60900619713
ATAT124Other fungicides and bactericidesANILIDE FUNGICIDES1040188425-85-6673BOSCALID5804.23945596324261.6678773268866065.90733329013
ATAT125Other fungicides and bactericidesANILIDE FUNGICIDES1040188425-85-6673BOSCALID5290.71170343398.02812805947252314.9640868130455613.70391830642
ATAT126Other fungicides and bactericidesANILIDE FUNGICIDES1040188425-85-6673BOSCALID5174.67193299745143.1174433321645317.78937632961
ATAT127Other fungicides and bactericidesANILIDE FUNGICIDES1040188425-85-6673BOSCALID2222.54761324968149.4639802183082372.01159346799

CREATE TABLE table_1 (
  "country" VARCHAR,
  "nuts3" VARCHAR,
  "categories_of_products" VARCHAR,
  "chemical_class_substance" VARCHAR,
  "id_eupdb" BIGINT,
  "cas" VARCHAR,
  "cipac" DOUBLE,
  "substances_common_names" VARCHAR,
  "arab_kg" DOUBLE,
  "fruit_kg" DOUBLE,
  "oliv_kg" DOUBLE,
  "vines_kg" DOUBLE,
  "grass_kg" DOUBLE,
  "rice_kg" DOUBLE,
  "kg_tot" DOUBLE
);

Share link

Anyone who has the link will be able to view this.