Skip to content

purchase_orders

Orders placed with suppliers, one per delivery. One row is one order.

One row is
one order
Columns
6
Rows in Sample
9,689
Rows in Standard
9,689
Rows in Full
9,689

This table describes the company, not individual guests, so it is identical in all three sizes.

Columns

ColumnTypeWhat it holdsValues or range
purchase_order_idkeyintegerUnique id for the row.
supplier_idintegerLinks to suppliers.
ordered_datedateDay the order was placed.2017-12-05 to 2025-12-30
expected_atdate and timeWhen the delivery was due.2018-01-01 07:00 to 2025-12-31 07:00
received_atdate and timeWhen it arrived. More than an hour after expected_at counts as late.2018-01-01 06:50 to 2025-12-31 07:02
order_totaldecimalValue of the order in dollars.0 to 376,708.67

How it connects

First five rows

Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.

purchase_order_idsupplier_idordered_dateexpected_atreceived_atorder_total
60000122017-12-312018-01-01 07:00:002018-01-01 06:58:119061.99
60000232017-12-292018-01-01 07:00:002018-01-02 06:42:1625983.62
60000342017-12-302018-01-01 07:00:002018-01-01 06:59:1823435.94
60000462017-12-312018-01-01 07:00:002018-01-01 06:50:0520360.78
60000512017-12-302018-01-02 07:00:002018-01-02 06:46:45105584.69

Download from Kaggle