California Wine Production 1980-2020
40 years of California wine production data
@kaggle.jarredpriester_california_wine_production_19802020
40 years of California wine production data
@kaggle.jarredpriester_california_wine_production_19802020
California is famous for their wine and they have produced a lot of wine through the years.
In this dataset you will find the acres harvested, yield, amount produced, total price, for each county in California from 1980 to 2020.
This data could be a great way to practice some data visualization techniques.
Combine with California rain data to create a machine learning model.
Or maybe try to forecast the next 10 years of productions.
CREATE TABLE californa_wine_production_1980_2020 (
"year" BIGINT,
"commoditycode" BIGINT,
"cropname" VARCHAR,
"countycode" BIGINT,
"county" VARCHAR,
"harvestedacres" DOUBLE,
"yield_unit_acre" DOUBLE -- Yield(Unit/Acre),
"production" DOUBLE,
"price_dollars_unit" DOUBLE -- Price(Dollars/Unit),
"unit" VARCHAR,
"value_dollars" BIGINT -- Value(Dollars)
);Anyone who has the link will be able to view this.