Crop Nutrient Database

USDA data about crop nutrients in the U.S.

@kaggle.crawford_crop_nutrient_database

Table List

1 table(186.68 KB)

Crops

@kaggle.crawford_crop_nutrient_database.crops

186.68 KB
737 rows
161 columns
Only the first 100 columns are shown

crop Crop	scientificname ScientificName	symbol Symbol	nucontavailable NuContAvailable	plantpartharvested PlantPartHarvested	cropcategory CropCategory	yieldunit YieldUnit	avyieldunitweight_lb AvYieldUnitWeight(lb)	avmoisture AvMoisture%	avn_dry AvN%(dry)	avp_dry AvP%(dry)	avk_dry AvK%(dry)	yieldunitweight_lb_set YieldUnitWeight(lb) Set	drymatter_m_ff DryMatter% M-FF	drymatter_nas DryMatter% NAS	drymatter_f_l DryMatter% F\u0026L	drymatter_f_n DryMatter% F\u0026N	drymatter_agh8_12 DryMatter% AgH8-12	avdrymatter AvDryMatter%	n_dry_nas N%(dry) NAS	n_dry_f_l N%(dry) F\u0026L	n_dry_f_n N%(dry) F\u0026N	n_dry_agh8_12 N%(dry) AgH8-12	n_dry_m_ff N%(dry) M-FF	p_dry_m_ff P%(dry) M-FF	p_dry_nas P%(dry) NAS	p_dry_f_l P%(dry) F\u0026L	p_dry_f_n P%(dry) F\u0026N	p_dry_agh8_12 P%(dry) AgH8-12
Acorn	Quercus sp.	QUERC	N,P,K	Fruit	Tree and fruit	lb of fruit	1	27.9	1.3647711512	0.10957004161	0.74757281553	1					72.1	72.1				1.3647711512						0.10957004161
Alfalfa + Orchardgrass, for hay	Medicago sativa, Dactylis glomerata	MESA, DAGL	N,P	Aboveground biomass	Forage	ton	2000	9.7	2.4797142857	0.26785714286	#DIV/0!	2000	89.6	91.2	91.4	89		90.3	2.592	2.544	2.64		2.1428571429	0.26785714286
Alfalfa + Orchardgrass, for hay (cut 1)	Medicago sativa, Dactylis glomerata	MESA, DAGL	N,P,K	Aboveground biomass	Forage	ton	2000	7.95	2.144	0.2	1.49	2000		92.9	91.2			92.05	1.696	2.592						0.2
Alfalfa + Smooth Brome, for green chop	Medicago sativa, Bromus inermis	MESA, BRIN2	N,P,K	Aboveground biomass	Forage	ton	2000	77.63	3.3220740741	0.31055555556	2.8	2000	22.5	21.6		23		22.37	3.136		3.408		3.4222222222	0.31111111111			0.31
Alfalfa + Smooth Brome, for hay	Medicago sativa, Bromus inermis	MESA, BRIN2	N,P,K	Aboveground biomass	Forage	ton	2000	11.58	2.4177085202	0.27105381166	1.8977466368	2000	89.2	82.5	91	91		88.42	2.592	2.48	2.48		2.1188340807	0.22421524664	0.3	0.28	0.28
Alfalfa + Smooth Brome, for hay (cut 1)	Medicago sativa, Bromus inermis	MESA, BRIN2	N,P,K	Aboveground biomass	Forage	ton	2000	10.1	2.192	0.295	1.4	2000		89.9	89.9			89.9	2.192	2.192					0.28	0.31
Alfalfa + Smooth Brome, for hay (cut 2)	Medicago sativa, Bromus inermis	MESA, BRIN2	N,P	Aboveground biomass	Forage	ton	2000	10.2	2.192	0.21	#DIV/0!	2000		89.8	89.8			89.8	2.192	2.192					0.21	0.21
Alfalfa + Timothy, for green chop (50% alfalfa)	Medicago sativa, Phleum pratense	MESA, PHPR3	N,P,K	Aboveground biomass	Forage	ton	2000	78.08	3.3647488584	0.36882420091	2.2393607306	2000	21.9	21.9	21.9	22		21.93	3.36	3.36	3.36		3.3789954338	0.36529680365	0.37	0.37	0.37
Alfalfa + Timothy, for hay	Medicago sativa, Phleum pratense	MESA, PHPR3	N,P,K	Aboveground biomass	Forage	ton	2000	10.37	2.1728869048	0.21107142857	2.16	2000	89.6	89	90.3			89.63	2.192	2.128			2.1986607143	0.22321428571	0.2	0.21
Alfalfa + Timothy, for hay (cut 1)	Medicago sativa, Phleum pratense	MESA, PHPR3	N,P	Aboveground biomass	Forage	ton	2000	9.8	1.792	0.14	#DIV/0!	2000		90.2	90.2			90.2	1.792	1.792					0.14	0.14


CREATE TABLE crops (
  "crop" VARCHAR,
  "scientificname" VARCHAR,
  "symbol" VARCHAR,
  "nucontavailable" VARCHAR,
  "plantpartharvested" VARCHAR,
  "cropcategory" VARCHAR,
  "yieldunit" VARCHAR,
  "avyieldunitweight_lb" DOUBLE,
  "avmoisture" DOUBLE,
  "avn_dry" VARCHAR,
  "avp_dry" VARCHAR,
  "avk_dry" VARCHAR,
  "yieldunitweight_lb_set" DOUBLE,
  "yieldunitweight_lb_bau" DOUBLE,
  "yieldunitweight_lb_joh" DOUBLE,
  "yieldunitweight_lb_roberts" DOUBLE,
  "yieldunitweight_lb_weep" DOUBLE,
  "yieldunitweight_lb_men" DOUBLE,
  "yieldunitweight_lb_guy" DOUBLE,
  "yieldunitweight_lb_mc" DOUBLE,
  "yieldunitweight_lb_mah" DOUBLE,
  "yieldunitweight_lb_sha" DOUBLE,
  "yieldunitweight_lb_sch" DOUBLE,
  "yieldunitweight_lb_atu" DOUBLE,
  "yieldunitweight_lb_zim" DOUBLE,
  "yieldunitweight_lb_scu" DOUBLE,
  "yieldunitweight_lb_john" DOUBLE,
  "yieldunitweight_lb_arc" DOUBLE,
  "drymatter_m_ff" DOUBLE,
  "drymatter_nas" DOUBLE,
  "drymatter_f_l" DOUBLE,
  "drymatter_f_n" DOUBLE,
  "drymatter_alb" DOUBLE,
  "drymatter_est1" DOUBLE,
  "drymatter_est2" DOUBLE,
  "drymatter_est3" DOUBLE,
  "drymatter_est4" DOUBLE,
  "drymatter_est5" DOUBLE,
  "drymatter_est6" DOUBLE,
  "drymatter_m_r" DOUBLE,
  "drymatter_m_l" DOUBLE,
  "drymatter_sun" DOUBLE,
  "drymatter_gro" DOUBLE,
  "drymatter_agh8_9" DOUBLE,
  "drymatter_agh8_12" DOUBLE,
  "drymatter_b788" DOUBLE,
  "avdrymatter" DOUBLE,
  "n_dry_nas" DOUBLE,
  "n_dry_f_l" DOUBLE,
  "n_dry_f_n" DOUBLE,
  "n_dry_swa" DOUBLE,
  "n_dry_chapko" DOUBLE,
  "n_dry_hill" DOUBLE,
  "n_dry_bru" DOUBLE,
  "n_dry_agh8_9" DOUBLE,
  "n_dry_agh8_12" DOUBLE,
  "n_dry_b788" DOUBLE,
  "n_dry_m_l" DOUBLE,
  "n_dry_m_ff" DOUBLE,
  "n_dry_m_r" DOUBLE,
  "n_dry_foster" DOUBLE,
  "n_dry_rob1" DOUBLE,
  "n_dry_rob2" DOUBLE,
  "n_dry_coa" DOUBLE,
  "n_dry_and" DOUBLE,
  "n_dry_gol1" DOUBLE,
  "n_dry_gol2" DOUBLE,
  "n_dry_wol" DOUBLE,
  "n_dry_pete" DOUBLE,
  "n_dry_col" DOUBLE,
  "n_dry_alb" DOUBLE,
  "n_dry_arc" DOUBLE,
  "n_dry_bis" DOUBLE,
  "n_dry_gar" DOUBLE,
  "n_dry_heg" DOUBLE,
  "n_dry_flo" DOUBLE,
  "n_dry_feil" DOUBLE,
  "n_dry_bre" DOUBLE,
  "n_dry_burns" DOUBLE,
  "n_dry_coc" DOUBLE,
  "p_dry_m_ff" DOUBLE,
  "p_dry_nas" DOUBLE,
  "p_dry_f_l" DOUBLE,
  "p_dry_f_n" DOUBLE,
  "p_dry_agh8_9" DOUBLE,
  "p_dry_agh8_12" DOUBLE,
  "p_dry_b788" DOUBLE,
  "p_dry_m_l" DOUBLE,
  "p_dry_l_v" DOUBLE,
  "p_dry_foster" DOUBLE,
  "p_dry_rob1" DOUBLE,
  "p_dry_rob2" DOUBLE,
  "p_dry_coa" DOUBLE,
  "p_dry_and" DOUBLE,
  "p_dry_gol1" DOUBLE,
  "p_dry_gol2" DOUBLE,
  "p_dry_sims" DOUBLE,
  "p_dry_wol" DOUBLE,
  "p_dry_pete" DOUBLE,
  "p_dry_col" DOUBLE
);