Brazilian E-Commerce Public Dataset
Tables (9)
Untitled (olist_customers_dataset)
- Key (customer_id) — STR — Primary key — NOT NULL
- Key (customer_unique_id) — STR — Primary key — NOT NULL
- Field (customer_zip_code_prefix) — INT — NOT NULL
- Field2 (customer_city) — STR — NOT NULL
- Field (customer_state) — STR — NOT NULL
Untitled (olist_geolocation_dataset)
- Field (geolocation_zip_code_prefix) — INT — NOT NULL
- Field (geolocation_lat) — INT — NOT NULL
- Field (geolocation_lng) — INT — NOT NULL
- Field2 (geolocation_city) — STR — NOT NULL
- Field3 (geolocation_state) — STR — NOT NULL
Untitled (olist_order_items_dataset)
- Key (order_item_id) — STR — Primary key — NOT NULL
- Key (order_id) — STR — Foreign key → Untitled.Key — NOT NULL
- Key (seller_id) — STR — Foreign key → Untitled.Key — NOT NULL
- Key (product_id) — STR — Foreign key → Untitled.Key — NOT NULL
- Field (shipping_limit_date) — DATE — NOT NULL
- Field2 (price) — INT — NOT NULL
- Field3 (freight_value) — INT — NOT NULL
Untitled (olist_order_payments_dataset)
- Key (order_id) — STR — Foreign key → Untitled.Key — NOT NULL
- Field (payment_sequential) — INT — NOT NULL
- Field (payment_type) — STR — NOT NULL
- Field (payment_installments) — INT — NOT NULL
- Field (payment_value) — INT — NOT NULL
Untitled (olist_order_reviews_dataset)
- Key2 (review_id) — STR — Primary key — NOT NULL
- Key (order_id) — STR — Foreign key → Untitled.Key — NOT NULL
- Field5 (review_score) — INT — NOT NULL
- Field (review_comment_title) — STR
- Field2 (review_comment_message) — STR
- Field3 (review_creation_date) — DATE — NOT NULL
- Field4 (review_answer_timestamp) — DATE — NOT NULL
Untitled (olist_orders_dataset)
- Key (order_id) — STR — Primary key — NOT NULL
- Key (customer_id) — STR — Foreign key → Untitled.Key — NOT NULL
- Field (order_status) — STR — NOT NULL
- Field2 (order_purchase_timestamp) — DATE — NOT NULL
- Field3 (order_approved_at) — DATE — NOT NULL
- Field4 (order_delivered_carrier_date) — DATE
- Field5 (order_delivered_customer_date) — DATE
- Field6 (order_estimated_delivery_date) — DATE — NOT NULL
Untitled (olist_products_dataset)
- Key (product_id) — STR — Primary key — NOT NULL
- Field (product_category_name) — STR
- Field2 (product_name_lenght) — INT
- Field3 (product_description_lenght) — INT
- Field4 (product_photos_qty) — INT
- Field5 (product_weight_g) — INT — NOT NULL
- Field (product_length_cm) — INT — NOT NULL
- Field6 (product_height_cm) — INT — NOT NULL
- Field7 (product_width_cm) — INT — NOT NULL
Untitled (olist_sellers_dataset)
- Key (seller_id) — STR — Primary key — NOT NULL
- Field (seller_zip_code_prefix) — INT — NOT NULL
- Field2 (seller_city) — STR — NOT NULL
- Field3 (seller_state) — STR — NOT NULL
Untitled (product_category_name_translation)
- Field (product_category_name) — NOT NULL
- Field2 (product_category_name_english) — NOT NULL