Pizza Sales Dataset
Dive into Comprehensive Order Details for Analysis and extract insights.
@kaggle.nextmillionaire_pizza_sales_dataset
Pizza Sales
@kaggle.nextmillionaire_pizza_sales_dataset.pizza_sales
- 815.07 KB
- 48620 rows
- 12 columns
pizza_idPizza Id | order_idOrder Id | pizza_name_idPizza Name Id | quantityQuantity | order_dateOrder Date | order_timeOrder Time | unit_priceUnit Price | total_priceTotal Price | pizza_sizePizza Size | pizza_categoryPizza Category | pizza_ingredientsPizza Ingredients | pizza_namePizza Name |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | hawaiian_m | 1 | 1/1/2015 | 11:38:36 | 13.25 | 13.25 | M | Classic | Sliced Ham, Pineapple, Mozzarella Cheese | The Hawaiian Pizza |
| 2 | 2 | classic_dlx_m | 1 | 1/1/2015 | 11:57:40 | 16 | 16 | M | Classic | Pepperoni, Mushrooms, Red Onions, Red Peppers, Bacon | The Classic Deluxe Pizza |
| 3 | 2 | five_cheese_l | 1 | 1/1/2015 | 11:57:40 | 18.5 | 18.5 | L | Veggie | Mozzarella Cheese, Provolone Cheese, Smoked Gouda Cheese, Romano Cheese, Blue Cheese, Garlic | The Five Cheese Pizza |
| 4 | 2 | ital_supr_l | 1 | 1/1/2015 | 11:57:40 | 20.75 | 20.75 | L | Supreme | Calabrese Salami, Capocollo, Tomatoes, Red Onions, Green Olives, Garlic | The Italian Supreme Pizza |
| 5 | 2 | mexicana_m | 1 | 1/1/2015 | 11:57:40 | 16 | 16 | M | Veggie | Tomatoes, Red Peppers, Jalapeno Peppers, Red Onions, Cilantro, Corn, Chipotle Sauce, Garlic | The Mexicana Pizza |
| 6 | 2 | thai_ckn_l | 1 | 1/1/2015 | 11:57:40 | 20.75 | 20.75 | L | Chicken | Chicken, Pineapple, Tomatoes, Red Peppers, Thai Sweet Chilli Sauce | The Thai Chicken Pizza |
| 7 | 3 | ital_supr_m | 1 | 1/1/2015 | 12:12:28 | 16.5 | 16.5 | M | Supreme | Calabrese Salami, Capocollo, Tomatoes, Red Onions, Green Olives, Garlic | The Italian Supreme Pizza |
| 8 | 3 | prsc_argla_l | 1 | 1/1/2015 | 12:12:28 | 20.75 | 20.75 | L | Supreme | Prosciutto di San Daniele, Arugula, Mozzarella Cheese | The Prosciutto and Arugula Pizza |
| 9 | 4 | ital_supr_m | 1 | 1/1/2015 | 12:16:31 | 16.5 | 16.5 | M | Supreme | Calabrese Salami, Capocollo, Tomatoes, Red Onions, Green Olives, Garlic | The Italian Supreme Pizza |
| 10 | 5 | ital_supr_m | 1 | 1/1/2015 | 12:21:30 | 16.5 | 16.5 | M | Supreme | Calabrese Salami, Capocollo, Tomatoes, Red Onions, Green Olives, Garlic | The Italian Supreme Pizza |
CREATE TABLE pizza_sales (
"pizza_id" DOUBLE,
"order_id" DOUBLE,
"pizza_name_id" VARCHAR,
"quantity" DOUBLE,
"order_date" VARCHAR,
"order_time" VARCHAR,
"unit_price" DOUBLE,
"total_price" DOUBLE,
"pizza_size" VARCHAR,
"pizza_category" VARCHAR,
"pizza_ingredients" VARCHAR,
"pizza_name" VARCHAR
);