NorCal Coffee Subscriptions

Affordable NorCal Coffee Subs

@kaggle.caseydyer8_norcal_coffee_subscriptions

Table List

1 table(12.06 KB)

Coffee Subscription Data

@kaggle.caseydyer8_norcal_coffee_subscriptions.coffee_subscription_data

12.06 KB
27 rows
17 columns

coffee_company Coffee Company	subscription_model Subscription Model	bag_size Bag Size	price_bag Price/Bag	frequency Frequency	duration Duration	amount_of_coffee_month Amount Of Coffee/month	price_per_oz Price Per Oz	price_per_lb Price Per Lb	cost_for_3_months Cost For 3 Months	coffee_beans_per_pot Coffee Beans Per Pot	cups_per_pot Cups Per Pot	cost_per_cup Cost Per Cup
Ritual	The Coffee Club	12 oz	$24.00	weekly	3 Months	3 lbs	$2	$32	$288	1.8 oz	3	$1.20
Ritual	The Coffee Club	5 lbs	$120.00	monthly	3 Months	5 lbs	$1.50	$24	$360	1.8 oz	3	$0.90
Remedy	Roaster's Pick	12 oz	$23.00	weekly	3 Months	3 lbs	$1.92	$30.67	$276	1.8 oz	3	$1.15
Remedy	Roaster's Pick	36 oz	$72.00	Biweekly	3 Months	4.5 lbs	$2	$32	$432	1.8 oz	3	$1.20
Remedy	Roaster's Pick	5 lbs	$121.00	monthly	3 Months	5 lbs	$1.51	$24.20	$363	1.8 oz	3	$0.91
Temple	Roaster's Choice	12 oz	$23.00	weekly	3 Months	3 lbs	$1.92	$30.67	$276	1.8 oz	3	$1.15
Temple	Roaster's Choice	5 lbs	$115.00	monthly	3 Months	5 lbs	$1.44	$23.00	$345	1.8 oz	3	$0.86
Blue Bottle	Single Origin Assortment	12 oz	$25.00	weekly	3 Months	3 lbs	$2.08	$33.33	$300	1.8 oz	3	$1.25
Blue Bottle	Single Origin Assortment	24 oz	$45.25	Biweekly	3 Months	3 lbs	$1.89	$30.17	$272	1.8 oz	3	$1.13
Blue Bottle	Single Origin Assortment	36 oz	$61.87	Biweekly	3 Months	4.5 lbs	$1.72	$27.50	$371	1.8 oz	3	$1.03


CREATE TABLE coffee_subscription_data (
  "coffee_company" VARCHAR,
  "subscription_model" VARCHAR,
  "bag_size" VARCHAR,
  "price_bag" VARCHAR,
  "frequency" VARCHAR,
  "duration" VARCHAR,
  "amount_of_coffee_month" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "price_per_oz" VARCHAR,
  "price_per_lb" VARCHAR,
  "unnamed_11" VARCHAR,
  "cost_for_3_months" VARCHAR,
  "unnamed_13" VARCHAR,
  "coffee_beans_per_pot" VARCHAR,
  "cups_per_pot" DOUBLE,
  "cost_per_cup" VARCHAR
);