California Avocado Production 1980-2020

40 years of California Avocado data

@kaggle.jarredpriester_california_avocado_production_19802020

Table List

1 table(21.37 KB)

Cali Avocados

@kaggle.jarredpriester_california_avocado_production_19802020.cali_avocados

21.37 KB
420 rows
11 columns

year Year	n__commodity_code Commodity Code	n__crop_name Crop Name	n__county_code County Code	n__county County	n__harvested_acres Harvested Acres	n__yield Yield	n__production Production	n__price_p_u Price P/U	n__unit Unit	n__value Value
2020	221999	AVOCADOS ALL	53	Monterey	223	5.56	1240	2379.84	Tons	2951000
2020	221999	AVOCADOS ALL	65	Riverside	3020				Tons	88697000
2020	221999	AVOCADOS ALL	71	San Bernardino	370	2.16	799	2617.02	Tons	2091000
2020	221999	AVOCADOS ALL	73	San Diego	14400	3.51	50500	3028.87	Tons	152958000
2020	221999	AVOCADOS ALL	79	San Luis Obispo	4240	5.9	25000	1886.76	Tons	47169000
2020	221999	AVOCADOS ALL	83	Santa Barbara	5770	4.89	28200	2842.59	Tons	80161000
2020	221999	AVOCADOS ALL	111	Ventura	16400	4.29	70300	2556.57	Tons	179727000
2019	221999	AVOCADOS ALL	53	Monterey	225	6.58	1480	2500	Tons	3700000
2019	221999	AVOCADOS ALL	65	Riverside	2940	5.48	16100	2505.53	Tons	40339000
2019	221999	AVOCADOS ALL	71	San Bernardino	397	3.53	1400	2604.29	Tons	3646000


CREATE TABLE cali_avocados (
  "year" BIGINT,
  "n__commodity_code" BIGINT,
  "n__crop_name" VARCHAR,
  "n__county_code" BIGINT,
  "n__county" VARCHAR,
  "n__harvested_acres" VARCHAR,
  "n__yield" VARCHAR,
  "n__production" VARCHAR,
  "n__price_p_u" VARCHAR,
  "n__unit" VARCHAR,
  "n__value" VARCHAR
);