Honeybees And Neonic Pesticides

Are Neonic pesticides connected to decline of honeybee colonies?

@kaggle.kevinzmith_honey_with_neonic_pesticide

Table List

2 tables(114.38 KB)

Vhoneyneonic V02

@kaggle.kevinzmith_honey_with_neonic_pesticide.vhoneyneonic_v02

52.82 KB
825 rows
16 columns

state State	numcol Numcol	yieldpercol Yieldpercol	totalprod Totalprod	stocks Stocks	priceperlb Priceperlb	prodvalue Prodvalue	year Year	statename StateName	region Region	nclothianidin NCLOTHIANIDIN	nimidacloprid NIMIDACLOPRID	nthiamethoxam NTHIAMETHOXAM	nallneonic NAllNeonic
AL	11000	56	616000	209000	1.49	918000	2007	Alabama	South	7696.2	3258.1	4149.6	15103.9
AL	11000	72	792000	230000	1.21	958000	2006	Alabama	South	680	4230.2	5371.6	10281.8
AL	12000	86	1032000	103000	1.18	1218000	2002	Alabama	South		1178.8	840.4	2019.2
AL	12000	87	1044000	282000	1.41	1472000	2004	Alabama	South	2676.4	1323.9	3863.9	7864.2
AL	13000	66	858000	266000	1.02	875000	2005	Alabama	South	1503.6	994.5	5493.9	7992
AL	13000	82	1066000	43000	1.24	1322000	2003	Alabama	South		668.3	591.7	1260
AL	14000	73	1022000	235000	0.72	736000	2001	Alabama	South		1490.8		1490.8
AL	16000	71	1136000	159000	0.72	818000	1998	Alabama	South		1836.3		1836.3
AL	16000	78	1248000	187000	0.59	736000	2000	Alabama	South		1499.2		1499.2
AL	17000	68	1156000	185000	0.56	647000	1999	Alabama	South		1251.2		1251.2


CREATE TABLE vhoneyneonic_v02 (
  "state" VARCHAR,
  "numcol" DOUBLE,
  "yieldpercol" BIGINT,
  "totalprod" DOUBLE,
  "stocks" DOUBLE,
  "priceperlb" DOUBLE,
  "prodvalue" DOUBLE,
  "year" BIGINT,
  "statename" VARCHAR,
  "region" VARCHAR,
  "nclothianidin" DOUBLE,
  "nimidacloprid" DOUBLE,
  "nthiamethoxam" DOUBLE,
  "nacetamiprid" DOUBLE,
  "nthiacloprid" DOUBLE,
  "nallneonic" DOUBLE
);