Government Procurement Logistics Tracker
This dataset provides a comprehensive view of government procurement logistics, tracking digital shipments, delivery timelines, and supplier performance across agencies. It enables operational teams to monitor compliance, identify delays and bottlenecks, and optimize supply chain resilience for public sector logistics management.
Sample rows
preview · 8 of 85 rows · all 31 columns| shipment_idstring | carrier_namestring | supplier_performance_scorefloat | is_hazardousboolean | supplier_idstring | agency_idstring | agency_namestring | supplier_namestring | shipment_statusstring | expected_delivery_datedate | actual_delivery_datedate | shipment_created_datedate | origin_street_addressstring | origin_citystring | origin_statestring | origin_postal_codestring | origin_countrystring | destination_street_addressstring | destination_citystring | destination_statestring | destination_postal_codestring | destination_countrystring | shipment_weight_kgfloat | shipment_volume_m3float | item_countinteger | shipment_value_usdfloat | delivery_delay_daysinteger | delay_reasonstring | tracking_numberstring | compliance_flagboolean | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SHIP-10001 | FedEx | 92.5 | false | SUP-3001 | AGY-2001 | Department of Public Health | Northstar Logistics | delivered | 2024-05-14 | 2024-05-15 | 2024-05-08 | 1200 Market St | St. Louis | MO | 63103 | USA | 500 State Ave | Kansas City | KS | 66101 | USA | 1450.2 | 5.7 | 44 | 32400.25 | 1 | Carrier scheduling issue | FX123456789US | true | Delivered 1 day late, no damage. |
| SHIP-10002 | UPS | 87 | false | SUP-3002 | AGY-2002 | General Services Agency | Blue Ridge Supply | in_transit | 2024-06-11 | blank | 2024-06-02 | 344 Pine St | Charlotte | NC | 28202 | USA | 1800 Capitol Ave | Sacramento | CA | 95814 | USA | 740.5 | 3.1 | 19 | 11000 | blank | blank | 1Z999AA10123456784 | true | On track for on-time delivery. |
| SHIP-10003 | blank | 79.3 | false | SUP-3003 | AGY-2003 | Department of Transportation | Atlas Industrial | pending | 2024-07-02 | blank | 2024-06-27 | 77 Industrial Way | Toledo | OH | 43604 | USA | 400 Main St | Cleveland | OH | 44114 | USA | 2100 | 10.2 | 60 | 48300 | blank | blank | blank | blank | Order created, pickup scheduled. |
| SHIP-10004 | DHL | 95.2 | true | SUP-3004 | AGY-2004 | Emergency Management Agency | Horizon Freight | delivered | 2024-05-20 | 2024-05-20 | 2024-05-14 | 909 Elm Ave | Memphis | TN | 38103 | USA | 333 River Rd | Little Rock | AR | 72201 | USA | 256.8 | 1.2 | 9 | 5400 | 0 | blank | DHL0001223344 | true | Hazardous material, all compliance checks passed. |
| SHIP-10005 | FedEx | 68.5 | false | SUP-3002 | AGY-2003 | Department of Transportation | Blue Ridge Supply | delayed | 2024-04-25 | blank | 2024-04-17 | 233 Commerce Blvd | Nashville | TN | 37219 | USA | 1000 5th Ave | Charlotte | NC | 28202 | USA | 980 | 4.4 | 27 | 17200 | 3 | Flooded roadways | FX2233445566 | false | Delivery delayed due to severe weather. |
| SHIP-10006 | blank | 0 | false | SUP-3005 | AGY-2005 | Infrastructure and Roads Admin | Western Equipment | cancelled | 2024-06-01 | blank | 2024-05-25 | 1674 Granite St | Denver | CO | 80202 | USA | 89 Capitol Blvd | Boise | ID | 83702 | USA | 0 | 0 | 1 | 0 | blank | blank | blank | blank | Shipment cancelled by agency. |
| SHIP-10007 | blank | 81.9 | false | SUP-3006 | AGY-2006 | State IT Services | United Tech Vendors | pending | 2024-07-14 | blank | 2024-07-02 | 701 Innovation Dr | San Jose | CA | 95134 | USA | 650 State St | Salem | OR | 97301 | USA | 340.4 | 1.4 | 16 | 13350.7 | blank | blank | blank | blank | Awaiting pickup confirmation. |
| SHIP-10008 | UPS | 90.3 | false | SUP-3001 | AGY-2004 | Emergency Management Agency | Northstar Logistics | delivered | 2024-06-10 | 2024-06-09 | 2024-06-03 | 456 River Rd | Cincinnati | OH | 45202 | USA | 320 Liberty St | Columbus | OH | 43215 | USA | 899.9 | 2.9 | 23 | 18900 | 0 | blank | 1Z999AA10123456785 | true | Delivered ahead of schedule. |
| SHIP-10009 | FedEx | 73.1 | false | SUP-3007 | AGY-2007 | State Procurement Office | Prime Materials | delayed | 2024-05-18 | blank | 2024-05-09 | 800 Commerce Ct | Austin | TX | 78701 | USA | 1010 Grand Blvd | Houston | TX | 77002 | USA | 600 | 2.5 | 15 | 11800 | 2 | Mechanical issue | FX9988776655 | false | Carrier truck breakdown. |
| SHIP-10010 | DHL | 98 | false | SUP-3008 | AGY-2002 | General Services Agency | Central Office Supply | delivered | 2024-06-06 | 2024-06-06 | 2024-05-31 | 99 Oak Ave | Madison | WI | 53703 | USA | 244 Broad St | Springfield | IL | 62701 | USA | 123.7 | 0.7 | 12 | 3200 | 0 | blank | DHL99887766 | true | Quick delivery, all items accounted for. |
| SHIP-10011 | UPS | 84.8 | true | SUP-3009 | AGY-2008 | Dept. of Environmental Quality | EcoChem Services | in_transit | 2024-06-13 | blank | 2024-06-06 | 232 Green Blvd | Seattle | WA | 98101 | USA | 312 Pine St | Portland | OR | 97204 | USA | 88.1 | 1.1 | 7 | 4300 | blank | blank | 1Z999AA10123456786 | true | Hazardous shipment, expedited. |
| SHIP-10012 | blank | 85 | false | SUP-3010 | AGY-2001 | Department of Public Health | MedSupply Partners | pending | 2024-07-12 | blank | 2024-07-01 | 222 Health Dr | Phoenix | AZ | 85004 | USA | 800 City Hall | Las Vegas | NV | 89101 | USA | 210 | 1.9 | 13 | 9900 | blank | blank | blank | blank | Medical supplies, urgent. |
| SHIP-10013 | FedEx | 78.7 | false | SUP-3011 | AGY-2009 | Dept. of Corrections | GuardSafe Logistics | delivered | 2024-05-24 | 2024-05-25 | 2024-05-16 | 533 Security Ln | Omaha | NE | 68102 | USA | 500 Justice Rd | Lincoln | NE | 68508 | USA | 175.6 | 0.9 | 10 | 5900 | 1 | Traffic accident | FX4455667788 | true | Minor delay, no damage. |
| SHIP-10014 | UPS | 88.4 | false | SUP-3001 | AGY-2005 | Infrastructure and Roads Admin | Northstar Logistics | in_transit | 2024-06-14 | blank | 2024-06-07 | 101 Main St | Salt Lake City | UT | 84101 | USA | 100 Mountain Ave | Cheyenne | WY | 82001 | USA | 1560 | 6 | 34 | 40500 | blank | blank | 1Z999AA10123456787 | true | Heavy equipment, on schedule. |
| SHIP-10015 | DHL | 96.4 | false | SUP-3012 | AGY-2010 | Dept. of Education | Academic Supply Co. | delivered | 2024-05-29 | 2024-05-29 | 2024-05-22 | 10 Library Cir | Boston | MA | 02108 | USA | 1200 School St | Providence | RI | 02903 | USA | 83.3 | 0.6 | 8 | 2800 | 0 | blank | DHL22334455 | true | Delivered as scheduled. |
| SHIP-10016 | blank | 77.2 | true | SUP-3009 | AGY-2008 | Dept. of Environmental Quality | EcoChem Services | pending | 2024-07-03 | blank | 2024-06-25 | 14 Lake View Dr | Burlington | VT | 05401 | USA | 30 River St | Montpelier | VT | 05602 | USA | 60 | 0.3 | 4 | 1700 | blank | blank | blank | blank | Hazardous, awaiting clearance. |
| SHIP-10017 | FedEx | 84 | false | SUP-3013 | AGY-2009 | Dept. of Corrections | Steelgate Distribution | delivered | 2024-06-01 | 2024-06-02 | 2024-05-24 | 7000 Iron Dr | Pittsburgh | PA | 15222 | USA | 1818 Justice Ave | Harrisburg | PA | 17101 | USA | 980.2 | 4.5 | 22 | 11800 | 1 | Accident on highway | FX5556667778 | true | Slight delay, all items accounted for. |
| SHIP-10018 | UPS | 69 | false | SUP-3010 | AGY-2001 | Department of Public Health | MedSupply Partners | delayed | 2024-05-19 | blank | 2024-05-12 | 301 Wellness Ave | Denver | CO | 80203 | USA | 4800 Main St | Salt Lake City | UT | 84111 | USA | 430 | 2.1 | 17 | 6200 | 4 | Supplier staffing shortage | 1Z999AA10123456788 | false | Major delay, agency notified. |
| SHIP-10019 | blank | 93.8 | false | SUP-3012 | AGY-2010 | Dept. of Education | Academic Supply Co. | pending | 2024-07-11 | blank | 2024-07-01 | 700 Book Rd | Hartford | CT | 06103 | USA | 80 Campus Ave | New Haven | CT | 06510 | USA | 96 | 0.8 | 11 | 3200 | blank | blank | blank | blank | Textbooks and learning materials. |
| SHIP-10020 | DHL | 82.7 | false | SUP-3014 | AGY-2007 | State Procurement Office | Westfield Transport | delivered | 2024-05-26 | 2024-05-26 | 2024-05-18 | 4300 Airport Rd | Des Moines | IA | 50321 | USA | 220 Capitol St | Bismarck | ND | 58501 | USA | 1200 | 5 | 20 | 20700 | 0 | blank | DHL33445566 | true | Large shipment, delivered on time. |
What the 85 rows show
from the 85-row sampleUPS (carrier name) stands out: mean supplier_
- 20%is_
hazardous = true - 87.6median supplier_
performance_ score - 5shipment statuses
- 190.0median shipment_
weight_ kg - 1.1median shipment_
volume_ m3 - 14median item_
count
Median 87.6, from 0.0 to 99.2.
- string 20
- integer 2
- float 4
- date 3
- boolean 2
Columns
31 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 20 columns | |||
shipment_id | string | Unique identifier for each procurement shipmentunique | SHIP-10001 |
agency_id | string | Unique identifier for the government agency receiving the shipment | AGY-2001 |
agency_name | string | Full name of the government agency | General Services Agency |
supplier_id | string | Unique identifier for the supplier or vendor | SUP-3001 |
supplier_name | string | Name of the supplier or vendor | Northstar Logistics |
shipment_status | string | Current status of the shipmentpending · in_transit · delivered · delayed · cancelled | delivered |
origin_street_address | string | Street address of the shipment's origin | 1200 Market St |
origin_city | string | City of the shipment's origin | St. Louis |
origin_state | string | State or province of the shipment's origin | MO |
origin_postal_code | string | Postal code of the shipment's origin | 63103 |
origin_country | string | Country of the shipment's origin | USA |
destination_street_address | string | Street address of the shipment's destination | 500 State Ave |
destination_city | string | City of the shipment's destination | Kansas City |
destination_state | string | State or province of the shipment's destination | KS |
destination_postal_code | string | Postal code of the shipment's destination | 66101 |
destination_country | string | Country of the shipment's destination | USA |
delay_reason | string | Reason for delivery delay, if applicableoptional | Carrier scheduling issue |
carrier_name | string | Name of the logistics carrier or shipping company5 names · optional | FedEx |
tracking_number | string | Carrier-provided tracking number for the shipmentoptional | FX123456789US |
notes | string | Additional notes or comments about the shipmentoptional | Carrier truck breakdown. |
| Numbers 6 columns | |||
shipment_weight_kg | float | Total weight of the shipment in kilograms0 or more · optional | 1450.2 |
shipment_volume_m3 | float | Total volume of the shipment in cubic meters0 or more · optional | 5.7 |
item_count | integer | Number of items in the shipment1 or more · optional | 44 |
shipment_value_usd | float | Total monetary value of the shipment in USD0 or more · optional | 32400.25 |
delivery_delay_days | integer | Number of days the delivery was delayed (0 if on time, null if not delivered)0 or more · optional | 1 |
supplier_performance_score | float | Performance score for the supplier (0-100 scale)0 to 100 · optional | 92.5 |
| Dates and times 3 columns | |||
expected_delivery_date | date | Date the shipment is expected to be delivered | 2024-05-14 |
actual_delivery_date | date | Date the shipment was actually delivered (null if not yet delivered)optional | 2024-05-15 |
shipment_created_date | date | Date when the shipment was created or ordered | 2024-05-08 |
| True or false 2 columns | |||
is_hazardous | boolean | Indicates if the shipment contains hazardous materialsoptional | false |
compliance_flag | boolean | Indicates if the shipment met all compliance requirementsoptional | true |
Use it for
A logistics dashboard
The is_
hazardous rate, supplier_ performance_ score by carrier_ name and a breakdown of supplier_ id. Excel, Power BI or Tableau. Why do the 17 UPS rows have a mean supplier_
performance_ score of 81.7? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Shipments85SHIP-1000192.5FedExSHIP-1000495.2DHLSHIP-1001184.8UPS
A software demo
Believable shipments with agency_
id, agency_ name and supplier_ id to fill a screen in front of a buyer.
blueprint · government-procurement-logistics-tracker
Behind this dataset
Same schema. As many rows as you need.
These 85 rows came out of a blueprint — 31 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Each row tracks a single procurement shipment for a specific agency.
- Shipment status must be one of: In Transit, Delivered, Delayed, Cancelled.
- Include supplier compliance score (0-100) based on delivery performance.
- Flag shipments delayed beyond contractual SLA.
- Capture critical items category (e.g., medical, IT, infrastructure) for each shipment.
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- government-procurement-logistics-tracker