Name: A Year Of Pumpkin Prices
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

A Year Of Pumpkin Prices

Context:

Over 1.5 billions pounds of pumpkin are grown annually in the United States. Where are they sold, and for how much?

This dataset contains prices for which pumpkins were sold at selected U.S. cities’ terminal markets. Prices are differentiated by the commodities’ growing origin, variety, size, package and grade.

Content:

This dataset contains terminal market prices for different pumpkin crops in 13 cities in the United States from September 24, 2016 to September 30, 2017. In keeping with the structure of the original source data, information on each city has been uploaded as a separate file.

Atlanta, GA
Baltimore, MD
Boston, MA
Chicago, IL
Columbia, SC
Dallas, TX
Detroit, MI
Los Angeles, CA
Miami, FL
New York, NY
Philadelphia, PA
San Francisco, CA
Saint Louis, MO

Data for each city includes the following columns (although not all information is available for every city)

Commodity Name: Always pumpkin, since this is a pumpkin-only dataset
City Name: City where the pumpkin was sold
Type
Package
Variety
Sub Variety
Grade: In the US, usually only canned pumpkin is graded
Date: Date of sale (rounded up to the nearest Saturday)
Low Price
High Price
Mostly Low
Mostly High
Origin: Where the pumpkins were grown
Origin District
Item Size
Color
Environment
Unit of Sale
Quality
Condition
Appearance
Storage
Crop
Repack: Whether the pumpkin has been repackaged before sale
Trans Mode

Acknowledgements:

This dataset is based on Specialty Crops Terminal Markets Standard Reports distributed by the United States Department of Agriculture. Up-to-date reports can be generated here. This data is in the public domain.

Inspiration:

Which states produce the most pumpkin?
Where are pumpkin prices highest?
How does pumpkin size relate to price?
Which pumpkin variety is the most expensive? Least expensive?

Tables

Atlanta 9–24–2016–9–30–2017

@kaggle.usda_a_year_of_pumpkin_prices.atlanta_9_24_2016_9_30_2017

15.85 kB
57 rows
25 columns

CREATE TABLE atlanta_9_24_2016_9_30_2017 (
  "commodity_name" VARCHAR,
  "city_name" VARCHAR,
  "type" VARCHAR,
  "package" VARCHAR,
  "variety" VARCHAR,
  "sub_variety" VARCHAR,
  "grade" VARCHAR,
  "date" TIMESTAMP,
  "low_price" DOUBLE,
  "high_price" DOUBLE,
  "mostly_low" DOUBLE,
  "mostly_high" DOUBLE,
  "origin" VARCHAR,
  "origin_district" VARCHAR,
  "item_size" VARCHAR,
  "color" VARCHAR,
  "environment" VARCHAR,
  "unit_of_sale" VARCHAR,
  "quality" VARCHAR,
  "condition" VARCHAR,
  "appearance" VARCHAR,
  "storage" VARCHAR,
  "crop" VARCHAR,
  "repack" VARCHAR,
  "trans_mode" VARCHAR
);

Baltimore 9–24–2016–9–30–2017

@kaggle.usda_a_year_of_pumpkin_prices.baltimore_9_24_2016_9_30_2017

17.28 kB
153 rows
25 columns

CREATE TABLE baltimore_9_24_2016_9_30_2017 (
  "commodity_name" VARCHAR,
  "city_name" VARCHAR,
  "type" VARCHAR,
  "package" VARCHAR,
  "variety" VARCHAR,
  "sub_variety" VARCHAR,
  "grade" VARCHAR,
  "date" TIMESTAMP,
  "low_price" BIGINT,
  "high_price" DOUBLE,
  "mostly_low" BIGINT,
  "mostly_high" DOUBLE,
  "origin" VARCHAR,
  "origin_district" VARCHAR,
  "item_size" VARCHAR,
  "color" VARCHAR,
  "environment" VARCHAR,
  "unit_of_sale" VARCHAR,
  "quality" VARCHAR,
  "condition" VARCHAR,
  "appearance" VARCHAR,
  "storage" VARCHAR,
  "crop" VARCHAR,
  "repack" VARCHAR,
  "trans_mode" VARCHAR
);

Boston 9–24–2016–9–30–2017

@kaggle.usda_a_year_of_pumpkin_prices.boston_9_24_2016_9_30_2017

17.62 kB
352 rows
25 columns

CREATE TABLE boston_9_24_2016_9_30_2017 (
  "commodity_name" VARCHAR,
  "city_name" VARCHAR,
  "type" VARCHAR,
  "package" VARCHAR,
  "variety" VARCHAR,
  "sub_variety" VARCHAR,
  "grade" VARCHAR,
  "date" TIMESTAMP,
  "low_price" BIGINT,
  "high_price" BIGINT,
  "mostly_low" BIGINT,
  "mostly_high" BIGINT,
  "origin" VARCHAR,
  "origin_district" VARCHAR,
  "item_size" VARCHAR,
  "color" VARCHAR,
  "environment" VARCHAR,
  "unit_of_sale" VARCHAR,
  "quality" VARCHAR,
  "condition" VARCHAR,
  "appearance" VARCHAR,
  "storage" VARCHAR,
  "crop" VARCHAR,
  "repack" VARCHAR,
  "trans_mode" VARCHAR
);

Chicago 9–24–2016–9–30–2017

@kaggle.usda_a_year_of_pumpkin_prices.chicago_9_24_2016_9_30_2017

17.5 kB
248 rows
25 columns

CREATE TABLE chicago_9_24_2016_9_30_2017 (
  "commodity_name" VARCHAR,
  "city_name" VARCHAR,
  "type" VARCHAR,
  "package" VARCHAR,
  "variety" VARCHAR,
  "sub_variety" VARCHAR,
  "grade" VARCHAR,
  "date" TIMESTAMP,
  "low_price" DOUBLE,
  "high_price" DOUBLE,
  "mostly_low" DOUBLE,
  "mostly_high" DOUBLE,
  "origin" VARCHAR,
  "origin_district" VARCHAR,
  "item_size" VARCHAR,
  "color" VARCHAR,
  "environment" VARCHAR,
  "unit_of_sale" VARCHAR,
  "quality" VARCHAR,
  "condition" VARCHAR,
  "appearance" VARCHAR,
  "storage" VARCHAR,
  "crop" VARCHAR,
  "repack" VARCHAR,
  "trans_mode" VARCHAR
);

Columbia 9–24–2016–9–30–2017

@kaggle.usda_a_year_of_pumpkin_prices.columbia_9_24_2016_9_30_2017

17.34 kB
263 rows
25 columns

CREATE TABLE columbia_9_24_2016_9_30_2017 (
  "commodity_name" VARCHAR,
  "city_name" VARCHAR,
  "type" VARCHAR,
  "package" VARCHAR,
  "variety" VARCHAR,
  "sub_variety" VARCHAR,
  "grade" VARCHAR,
  "date" TIMESTAMP,
  "low_price" BIGINT,
  "high_price" BIGINT,
  "mostly_low" BIGINT,
  "mostly_high" BIGINT,
  "origin" VARCHAR,
  "origin_district" VARCHAR,
  "item_size" VARCHAR,
  "color" VARCHAR,
  "environment" VARCHAR,
  "unit_of_sale" VARCHAR,
  "quality" VARCHAR,
  "condition" VARCHAR,
  "appearance" VARCHAR,
  "storage" VARCHAR,
  "crop" VARCHAR,
  "repack" VARCHAR,
  "trans_mode" VARCHAR
);

Dallas 9–24–2016–9–30–2017

@kaggle.usda_a_year_of_pumpkin_prices.dallas_9_24_2016_9_30_2017

16.62 kB
137 rows
25 columns

CREATE TABLE dallas_9_24_2016_9_30_2017 (
  "commodity_name" VARCHAR,
  "city_name" VARCHAR,
  "type" VARCHAR,
  "package" VARCHAR,
  "variety" VARCHAR,
  "sub_variety" VARCHAR,
  "grade" VARCHAR,
  "date" TIMESTAMP,
  "low_price" BIGINT,
  "high_price" BIGINT,
  "mostly_low" BIGINT,
  "mostly_high" BIGINT,
  "origin" VARCHAR,
  "origin_district" VARCHAR,
  "item_size" VARCHAR,
  "color" VARCHAR,
  "environment" VARCHAR,
  "unit_of_sale" VARCHAR,
  "quality" VARCHAR,
  "condition" VARCHAR,
  "appearance" VARCHAR,
  "storage" VARCHAR,
  "crop" VARCHAR,
  "repack" VARCHAR,
  "trans_mode" VARCHAR
);

Detroit 9–24–2016–9–30–2017

@kaggle.usda_a_year_of_pumpkin_prices.detroit_9_24_2016_9_30_2017

15.82 kB
44 rows
25 columns

CREATE TABLE detroit_9_24_2016_9_30_2017 (
  "commodity_name" VARCHAR,
  "city_name" VARCHAR,
  "type" VARCHAR,
  "package" VARCHAR,
  "variety" VARCHAR,
  "sub_variety" VARCHAR,
  "grade" VARCHAR,
  "date" TIMESTAMP,
  "low_price" BIGINT,
  "high_price" BIGINT,
  "mostly_low" BIGINT,
  "mostly_high" BIGINT,
  "origin" VARCHAR,
  "origin_district" VARCHAR,
  "item_size" VARCHAR,
  "color" VARCHAR,
  "environment" VARCHAR,
  "unit_of_sale" VARCHAR,
  "quality" VARCHAR,
  "condition" VARCHAR,
  "appearance" VARCHAR,
  "storage" VARCHAR,
  "crop" VARCHAR,
  "repack" VARCHAR,
  "trans_mode" VARCHAR
);

Los Angeles 9–24–2016–9–30–2017

@kaggle.usda_a_year_of_pumpkin_prices.los_angeles_9_24_2016_9_30_2017

16.44 kB
62 rows
25 columns

CREATE TABLE los_angeles_9_24_2016_9_30_2017 (
  "commodity_name" VARCHAR,
  "city_name" VARCHAR,
  "type" VARCHAR,
  "package" VARCHAR,
  "variety" VARCHAR,
  "sub_variety" VARCHAR,
  "grade" VARCHAR,
  "date" TIMESTAMP,
  "low_price" DOUBLE,
  "high_price" DOUBLE,
  "mostly_low" DOUBLE,
  "mostly_high" DOUBLE,
  "origin" VARCHAR,
  "origin_district" VARCHAR,
  "item_size" VARCHAR,
  "color" VARCHAR,
  "environment" VARCHAR,
  "unit_of_sale" VARCHAR,
  "quality" VARCHAR,
  "condition" VARCHAR,
  "appearance" VARCHAR,
  "storage" VARCHAR,
  "crop" VARCHAR,
  "repack" VARCHAR,
  "trans_mode" VARCHAR
);

Miami 9–24–2016–9–30–2017

@kaggle.usda_a_year_of_pumpkin_prices.miami_9_24_2016_9_30_2017

15.33 kB
3 rows
25 columns

CREATE TABLE miami_9_24_2016_9_30_2017 (
  "commodity_name" VARCHAR,
  "city_name" VARCHAR,
  "type" VARCHAR,
  "package" VARCHAR,
  "variety" VARCHAR,
  "sub_variety" VARCHAR,
  "grade" VARCHAR,
  "date" TIMESTAMP,
  "low_price" BIGINT,
  "high_price" BIGINT,
  "mostly_low" BIGINT,
  "mostly_high" BIGINT,
  "origin" VARCHAR,
  "origin_district" VARCHAR,
  "item_size" VARCHAR,
  "color" VARCHAR,
  "environment" VARCHAR,
  "unit_of_sale" VARCHAR,
  "quality" VARCHAR,
  "condition" VARCHAR,
  "appearance" VARCHAR,
  "storage" VARCHAR,
  "crop" VARCHAR,
  "repack" VARCHAR,
  "trans_mode" VARCHAR
);

New York 9–24–2016–9–30–2017

@kaggle.usda_a_year_of_pumpkin_prices.new_york_9_24_2016_9_30_2017

16.96 kB
112 rows
25 columns

CREATE TABLE new_york_9_24_2016_9_30_2017 (
  "commodity_name" VARCHAR,
  "city_name" VARCHAR,
  "type" VARCHAR,
  "package" VARCHAR,
  "variety" VARCHAR,
  "sub_variety" VARCHAR,
  "grade" VARCHAR,
  "date" TIMESTAMP,
  "low_price" BIGINT,
  "high_price" BIGINT,
  "mostly_low" BIGINT,
  "mostly_high" BIGINT,
  "origin" VARCHAR,
  "origin_district" VARCHAR,
  "item_size" VARCHAR,
  "color" VARCHAR,
  "environment" VARCHAR,
  "unit_of_sale" VARCHAR,
  "quality" VARCHAR,
  "condition" VARCHAR,
  "appearance" VARCHAR,
  "storage" VARCHAR,
  "crop" VARCHAR,
  "repack" VARCHAR,
  "trans_mode" VARCHAR
);

Philadelphia 9–24–2016–9–30–2017

@kaggle.usda_a_year_of_pumpkin_prices.philadelphia_9_24_2016_9_30_2017

16.2 kB
57 rows
25 columns

CREATE TABLE philadelphia_9_24_2016_9_30_2017 (
  "commodity_name" VARCHAR,
  "city_name" VARCHAR,
  "type" VARCHAR,
  "package" VARCHAR,
  "variety" VARCHAR,
  "sub_variety" VARCHAR,
  "grade" VARCHAR,
  "date" TIMESTAMP,
  "low_price" BIGINT,
  "high_price" BIGINT,
  "mostly_low" BIGINT,
  "mostly_high" BIGINT,
  "origin" VARCHAR,
  "origin_district" VARCHAR,
  "item_size" VARCHAR,
  "color" VARCHAR,
  "environment" VARCHAR,
  "unit_of_sale" VARCHAR,
  "quality" VARCHAR,
  "condition" VARCHAR,
  "appearance" VARCHAR,
  "storage" VARCHAR,
  "crop" VARCHAR,
  "repack" VARCHAR,
  "trans_mode" VARCHAR
);

San Fransisco 9–24–2016–9–30–2017

@kaggle.usda_a_year_of_pumpkin_prices.san_fransisco_9_24_2016_9_30_2017

17.47 kB
166 rows
25 columns

CREATE TABLE san_fransisco_9_24_2016_9_30_2017 (
  "commodity_name" VARCHAR,
  "city_name" VARCHAR,
  "type" VARCHAR,
  "package" VARCHAR,
  "variety" VARCHAR,
  "sub_variety" VARCHAR,
  "grade" VARCHAR,
  "date" TIMESTAMP,
  "low_price" DOUBLE,
  "high_price" DOUBLE,
  "mostly_low" DOUBLE,
  "mostly_high" DOUBLE,
  "origin" VARCHAR,
  "origin_district" VARCHAR,
  "item_size" VARCHAR,
  "color" VARCHAR,
  "environment" VARCHAR,
  "unit_of_sale" VARCHAR,
  "quality" VARCHAR,
  "condition" VARCHAR,
  "appearance" VARCHAR,
  "storage" VARCHAR,
  "crop" VARCHAR,
  "repack" VARCHAR,
  "trans_mode" VARCHAR
);

St Louis 9–24–2016–9–30–2017

@kaggle.usda_a_year_of_pumpkin_prices.st_louis_9_24_2016_9_30_2017

18.31 kB
103 rows
29 columns

CREATE TABLE st_louis_9_24_2016_9_30_2017 (
  "commodity_name" VARCHAR,
  "city_name" VARCHAR,
  "type" VARCHAR,
  "package" VARCHAR,
  "variety" VARCHAR,
  "sub_variety" VARCHAR,
  "grade" VARCHAR,
  "date" TIMESTAMP,
  "low_price" DOUBLE,
  "high_price" DOUBLE,
  "mostly_low" VARCHAR,
  "mostly_high" VARCHAR,
  "origin" VARCHAR,
  "origin_district" VARCHAR,
  "item_size" VARCHAR,
  "color" VARCHAR,
  "environment" VARCHAR,
  "unit_of_sale" VARCHAR,
  "quality" VARCHAR,
  "condition" VARCHAR,
  "appearance" VARCHAR,
  "storage" VARCHAR,
  "crop" VARCHAR,
  "repack" VARCHAR,
  "trans_mode" VARCHAR,
  "offerings" VARCHAR,
  "market_tone" VARCHAR,
  "price_comment" VARCHAR,
  "comments" VARCHAR
);