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 V03

@kaggle.kevinzmith_honey_with_neonic_pesticide.vhoneyneonic_v03

61.56 KB
1132 rows
17 columns

state State	numcol Numcol	yieldpercol Yieldpercol	totalprod Totalprod	stocks Stocks	priceperlb Priceperlb	prodvalue Prodvalue	year Year	statename StateName	region Region	fips FIPS	nclothianidin NCLOTHIANIDIN	nimidacloprid NIMIDACLOPRID	nthiamethoxam NTHIAMETHOXAM	nallneonic NAllNeonic
AL	14000	66	924000	92000	0.81	748000	1997	Alabama	South	1		6704.8		6704.8
AL	15000	64	960000	96000	0.87	835000	1996	Alabama	South	1		371.6		371.6
AL	16000	58	928000	28000	0.69	640000	1995	Alabama	South	1		716.5		716.5
AL	18000	50	900000	99000	0.52	468000	1994	Alabama	South	1
AL	19000	45	855000	103000	0.59	504000	1993	Alabama	South	1
AL	23000	24	552000	66000	0.63	348000	1991	Alabama	South	1
AL	25000	41	1025000	113000	0.59	605000	1992	Alabama	South	1
AL	11000	56	616000	209000	1.49	918000	2007	Alabama	South	1	7696.2	3258.1	4149.6	15103.9
AL	11000	72	792000	230000	1.21	958000	2006	Alabama	South	1	680	4230.2	5371.6	10281.8
AL	12000	86	1032000	103000	1.18	1218000	2002	Alabama	South	1		1178.8	840.4	2019.2


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