Dataset: Crop Nutrient Database

About this Dataset

Crop Nutrient Database

Context

The PLANTS Database provides standardized information about the vascular plants, mosses, liverworts, hornworts, and lichens of the U.S. and its territories. It includes names, plant symbols, checklists, distributional data, species abstracts, characteristics, images, plant links, references, and crop information, and automated tools.

This particular dataset is the Crop Nutrient Database.

Content

These are the fields included in the dataset. I'll be honest, I have no idea what some of them mean:

Crop
ScientificName
Symbol
NuContAvailable
PlantPartHarvested
CropCategory
YieldUnit
AvYieldUnitWeight(lb)
AvMoisture%
AvN%(dry)
AvP%(dry)
AvK%(dry)
YieldUnitWeight(lb)_set
YieldUnitWeight(lb)_Bau
YieldUnitWeight(lb)_Joh
YieldUnitWeight(lb)_Roberts
YieldUnitWeight(lb)_WEEP
YieldUnitWeight(lb)_Men
YieldUnitWeight(lb)_Guy
YieldUnitWeight(lb)_Mc
YieldUnitWeight(lb)_Mah
YieldUnitWeight(lb)_Sha
YieldUnitWeight(lb)_Sch
YieldUnitWeight(lb)_Atu
YieldUnitWeight(lb)_Zim
YieldUnitWeight(lb)_Scu
YieldUnitWeight(lb)_John
YieldUnitWeight(lb)_Arc
DryMatter%_M-FF
DryMatter%_NAS
DryMatter%_F&L
DryMatter%_F&N
DryMatter%_Alb
DryMatter%_Est1
DryMatter%_Est2
DryMatter%_Est3
DryMatter%_Est4
DryMatter%_Est5
DryMatter%_Est6
DryMatter%_M&R
DryMatter%_M&L
DryMatter%_Sun
DryMatter%_Gro
DryMatter%_AgH8-9
DryMatter%_AgH8-12
DryMatter%_B788
AvDryMatter%
N%(dry)_NAS
N%(dry)_F&L
N%(dry)_F&N
N%(dry)_Swa
N%(dry)_Chapko
N%(dry)_Hill
N%(dry)_Bru
N%(dry)_AgH8-9
N%(dry)_AgH8-12
N%(dry)_B788
N%(dry)_M&L
N%(dry)_M-FF
N%(dry)_M&R
N%(dry)_Foster
N%(dry)_Rob1
N%(dry)_Rob2
N%(dry)_Coa
N%(dry)_And
N%(dry)_Gol1
N%(dry)_Gol2
N%(dry)_Wol
N%(dry)_Pete
N%(dry)_Col
N%(dry)_Alb
N%(dry)_Arc
N%(dry)_Bis
N%(dry)_Gar
N%(dry)_Heg
N%(dry)_Flo
N%(dry)_Feil
N%(dry)_Bre
N%(dry)_Burns
N%(dry)_Coc
P%(dry)_M-FF
P%(dry)_NAS
P%(dry)_F&L
P%(dry)_F&N
P%(dry)_AgH8-9
P%(dry)_AgH8-12
P%(dry)_B788
P%(dry)_M&L
P%(dry)_L&V
P%(dry)_Foster
P%(dry)_Rob1
P%(dry)_Rob2
P%(dry)_Coa
P%(dry)_And
P%(dry)_Gol1
P%(dry)_Gol2
P%(dry)_Sims
P%(dry)_Wol
P%(dry)_Pete
P%(dry)_Col
P%(dry)_Alb
P%(dry)_Arc
P%(dry)_Swa
P%(dry)_Rei
K%(dry)_M-FF
K%(dry)_NAS
K%(dry)_F&L
K%(dry)_F&N
K%(dry)_AgH8-9
K%(dry)_AgH8-12
K%(dry)_B788
K%(dry)_Foster
K%(dry)_Rob1
K%(dry)_Rob2
K%(dry)_Coa
K%(dry)_And
K%(dry)_Gol1
K%(dry)_Gol2
K%(dry)_Sims
K%(dry)_Wol
K%(dry)_Pete
K%(dry)_Col
K%(dry)_Alb
K%(dry)_Arc
K%(dry)_Swa
K%(dry)_Rei
Moisture%_M&R
Moisture%_M&L
Moisture%_Sun
Moisture%_Gro
gWater/100g_AgH8-9
gWater/100g_AgH8-12
gWater/100g_B788
Protein%(dry)_NAS
Protein%(dry)_F&L
Protein%(dry)_F&N
Protein%(dry)_Swa
Protein%(dry)_Chapko
Protein%(dry)_Hill
Protein%(dry)_Bru
Protein%(dry)_Bis
Protein%(dry)_Gar
Protein%(dry)_Heg
Protein%(dry)_Flo
Protein%(dry)_Feil
Protein%(dry)_Bre
Protein%(dry)_Burns
gProtein/100g(wet)_AgH8-9
gProtein/100g(wet)_AgH8-12
gProtein/100g(wet)_B788
Protein%(wet)_M&L
N%(wet)_M-FF
P%(wet)_M-FF
gP/100g(wet)_AgH8-9
gP/100g(wet)_AgH8-12
gP/100g(wet)_B788
P%(wet)_M&L
K%(wet)_M-FF
gK/100g(wet)_AgH8-9
gK/100g(wet)_AgH8-12
gK/100g(wet)_B788

Tables

Crops

@kaggle.crawford_crop_nutrient_database.crops

186.68 KB
737 rows
161 columns


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
);