Mexico Toy Sales

Sales & inventory data for a fictitious chain of toy stores in Mexico.

@kaggle.mysarahmadbhat_toy_sales

Table List

4 tables(4.89 MB)

Inventory

Products

Sales

Stores

Stores

@kaggle.mysarahmadbhat_toy_sales.stores

5.85 KB
50 rows
5 columns

store_id Store ID	store_name Store Name	store_city Store City	store_location Store Location	store_open_date Store Open Date
1	Maven Toys Guadalajara 1	Guadalajara	Residential	Fri Sep 18 1992 00:00:00 GMT+0000 (Coordinated Universal Time)
2	Maven Toys Monterrey 1	Monterrey	Residential	Thu Apr 27 1995 00:00:00 GMT+0000 (Coordinated Universal Time)
3	Maven Toys Guadalajara 2	Guadalajara	Commercial	Mon Dec 27 1999 00:00:00 GMT+0000 (Coordinated Universal Time)
4	Maven Toys Saltillo 1	Saltillo	Downtown	Sat Jan 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)
5	Maven Toys La Paz 1	La Paz	Downtown	Thu May 31 2001 00:00:00 GMT+0000 (Coordinated Universal Time)
6	Maven Toys Mexicali 1	Mexicali	Commercial	Sat Dec 13 2003 00:00:00 GMT+0000 (Coordinated Universal Time)
7	Maven Toys Monterrey 2	Monterrey	Downtown	Thu Dec 25 2003 00:00:00 GMT+0000 (Coordinated Universal Time)
8	Maven Toys Pachuca 1	Pachuca	Downtown	Thu Oct 14 2004 00:00:00 GMT+0000 (Coordinated Universal Time)
9	Maven Toys Ciudad de Mexico 1	Cuidad de Mexico	Downtown	Fri Oct 15 2004 00:00:00 GMT+0000 (Coordinated Universal Time)
10	Maven Toys Campeche 1	Campeche	Downtown	Fri Jan 14 2005 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE stores (
  "store_id" BIGINT,
  "store_name" VARCHAR,
  "store_city" VARCHAR,
  "store_location" VARCHAR,
  "store_open_date" TIMESTAMP
);