customers 99,441 rows
One row per order's customer. customer_unique_id identifies the person.
customer_id TEXT customer_unique_id TEXT customer_zip_code_prefix TEXT customer_city TEXT customer_state TEXT order_items 112,650 rows
One row per item within an order. price and freight_value are per item.
order_id TEXT order_item_id INTEGER product_id TEXT seller_id TEXT shipping_limit_date TEXT price REAL freight_value REAL order_payments 103,886 rows
Payment installments per order. One order can have several payment rows.
order_id TEXT payment_sequential INTEGER payment_type TEXT payment_installments INTEGER payment_value REAL order_reviews 99,224 rows
Customer reviews. review_id is NOT unique (some rows repeat).
review_id TEXT order_id TEXT review_score INTEGER review_creation_date TEXT review_answer_timestamp TEXT orders 99,441 rows
One row per order, with status and the purchase/delivery timestamps.
order_id TEXT customer_id TEXT order_status TEXT order_purchase_timestamp TEXT order_approved_at TEXT order_delivered_carrier_date TEXT order_delivered_customer_date TEXT order_estimated_delivery_date TEXT product_category_name_translation 73 rows
Portuguese to English product category names.
product_category_name TEXT product_category_name_english TEXT products 32,951 rows
Product catalog. Category names are Portuguese; join the translation table.
product_id TEXT product_category_name TEXT product_name_lenght INTEGER product_description_lenght INTEGER product_photos_qty INTEGER product_weight_g INTEGER product_length_cm INTEGER product_height_cm INTEGER product_width_cm INTEGER sellers 3,095 rows
Marketplace sellers.
seller_id TEXT seller_zip_code_prefix TEXT seller_city TEXT seller_state TEXT