School Supplies Procurement Delay Tracking
This dataset provides detailed records of school supply procurement orders, tracking delivery timelines, delays, vendor performance, and order statuses across multiple schools and vendors. It enables education administrators to identify supply chain bottlenecks, optimize vendor selection, and ensure timely classroom readiness by analyzing procurement delays and their causes.
Sample rows
preview · 8 of 85 rows · all 24 columns| order_idstring | order_statusstring | delay_daysinteger | delivery_address_statestring | school_idstring | school_namestring | school_districtstring | vendor_idstring | vendor_namestring | item_skustring | item_namestring | item_categorystring | quantity_orderedinteger | order_datedate | expected_delivery_datedate | actual_delivery_datedate | delay_reasonstring | order_total_amountfloat | contact_personstring | contact_emailstring | delivery_address_streetstring | delivery_address_citystring | delivery_address_postal_codestring | delivery_address_countrystring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ORD10001 | delivered | 0 | TX | SCH201 | Lincoln Middle School | Northside District | VEND101 | EduSupplies Inc. | STN-001 | No. 2 Pencils (Box of 12) | stationery | 15 | 2023-08-01 | 2023-08-10 | 2023-08-10 | blank | 45 | Sandra Owens | sandra.owens@ | 123 School Lane | Riverton | 75001 | USA |
| ORD10002 | delayed | 6 | IL | SCH202 | Maple Grove Elementary | Southview Schools | VEND102 | Classroom Essentials | FUR-004 | Adjustable Student Desk | furniture | 8 | 2023-09-03 | 2023-09-17 | 2023-09-23 | Supply chain disruption | 640 | Gregory Lee | glee@ | 418 Maple Ave | Springfield | 62704 | USA |
| ORD10003 | pending | blank | CA | SCH203 | Westfield High | blank | VEND103 | LearnIT Technologies | ELC-011 | Interactive Whiteboard | electronics | 2 | 2024-01-12 | 2024-01-27 | blank | blank | 2400 | Angela Martinez | amartinez@ | 325 Westfield Dr | Lakewood | 90712 | USA |
| ORD10004 | delayed | 3 | CO | SCH204 | Pine Hills Academy | Evergreen District | VEND101 | EduSupplies Inc. | CLN-002 | Disinfectant Wipes (Pack of 4) | cleaning | 12 | 2023-10-22 | 2023-10-30 | 2023-11-02 | Weather delay | 84 | Rachel Green | rachel.green@ | 98 Forest Rd | Boulder | 80304 | USA |
| ORD10005 | delivered | 0 | OH | SCH205 | Central City High | Central District | VEND104 | Furniture 4 Schools | FUR-007 | Teacher's Rolling Chair | furniture | 3 | 2023-08-15 | 2023-08-29 | 2023-08-29 | blank | 360 | Paul Nguyen | paul.nguyen@ | 200 Main St | Columbus | 43215 | USA |
| ORD10006 | shipped | blank | FL | SCH206 | Sunnybrook Elementary | River Valley District | VEND102 | Classroom Essentials | STN-019 | Colored Markers (Set of 10) | stationery | 20 | 2024-02-01 | 2024-02-09 | blank | blank | 100 | Denise Carter | denise.carter@ | 456 Oak St | Riverside | 32205 | USA |
| ORD10007 | delivered | 0 | AZ | SCH207 | Horizon Charter School | blank | VEND105 | TechEd Global | ELC-023 | Chromebook Laptop | electronics | 6 | 2023-12-11 | 2023-12-21 | 2023-12-20 | blank | 1800 | Megan Price | megan.price@ | 7901 Horizon Blvd | Phoenix | 85001 | USA |
| ORD10008 | delayed | 2 | MD | SCH208 | Eastside Middle School | East District | VEND106 | Clean & Green Supplies | CLN-005 | Hand Sanitizer (1L) | cleaning | 18 | 2023-11-05 | 2023-11-15 | 2023-11-17 | Vendor shortage | 135 | James O'Neil | joneil@ | 1700 East Ave | Baltimore | 21218 | USA |
| ORD10009 | pending | blank | GA | SCH209 | Brookwood School | Brook District | VEND101 | EduSupplies Inc. | STN-012 | Spiral Notebooks (Pack of 5) | stationery | 10 | 2024-01-15 | 2024-01-25 | blank | blank | 60 | Lisa Freeman | lisa.freeman@ | 12 Brookwood Rd | Duluth | 30096 | USA |
| ORD10010 | delivered | 0 | OH | SCH210 | Summit Learning Center | Summit County Schools | VEND107 | NextGen Classroom | ELC-030 | Document Camera | electronics | 4 | 2023-09-20 | 2023-09-27 | 2023-09-27 | blank | 480 | Brian Kelly | bkelly@ | 33 Summit Dr | Akron | 44308 | USA |
| ORD10011 | delayed | 2 | TX | SCH211 | Willow Lane Elementary | blank | VEND108 | GreenTree Distribution | CLN-009 | Paper Towels (Rolls of 6) | cleaning | 14 | 2023-08-27 | 2023-09-04 | 2023-09-06 | Logistics delay | 56 | Kayla Morgan | kayla.morgan@ | 102 Willow Ln | Plano | 75024 | USA |
| ORD10012 | shipped | blank | CA | SCH212 | Cedar Ridge High | West Valley | VEND104 | Furniture 4 Schools | FUR-012 | Filing Cabinet | furniture | 2 | 2024-02-12 | 2024-02-19 | blank | blank | 210 | Steven Barnes | sbarnes@ | 340 Cedar Blvd | Fresno | 93722 | USA |
| ORD10013 | delayed | 2 | WI | SCH213 | Silver Lake Elementary | Silver District | VEND102 | Classroom Essentials | STN-015 | Dry Erase Markers (Pack of 8) | stationery | 7 | 2023-09-10 | 2023-09-18 | 2023-09-20 | Backordered item | 49 | Emily James | emily.james@ | 10 Silver Lake Rd | Madison | 53703 | USA |
| ORD10014 | delivered | 0 | IA | SCH214 | Prairie View School | Prairie District | VEND109 | Office Depot Education | STN-022 | Glue Sticks (Set of 6) | stationery | 24 | 2023-08-11 | 2023-08-19 | 2023-08-19 | blank | 72 | Olivia Perez | operez@ | 9 Prairie View Dr | Des Moines | 50310 | USA |
| ORD10015 | delayed | 3 | CA | SCH215 | Harbor Charter | blank | VEND110 | EdTech Supplies | ELC-018 | Tablet Charging Cart | electronics | 1 | 2023-10-16 | 2023-10-26 | 2023-10-29 | Shipping carrier error | 799.99 | Victor Chen | victor.chen@ | 22 Harbor Blvd | Long Beach | 90803 | USA |
| ORD10016 | shipped | blank | CO | SCH216 | Mountain Ridge School | Mountain District | VEND107 | NextGen Classroom | FUR-010 | Stackable Student Chair | furniture | 30 | 2024-01-10 | 2024-01-19 | blank | blank | 900 | Teresa Wallace | twallace@ | 99 Ridge Rd | Boulder | 80305 | USA |
| ORD10017 | delayed | 2 | FL | SCH217 | Cypress Grove Middle | Cypress Unified | VEND102 | Classroom Essentials | STN-017 | Construction Paper (Pack of 50) | stationery | 18 | 2023-11-15 | 2023-11-27 | 2023-11-29 | Backlog in warehouse | 54 | Robert Kim | rkim@ | 700 Cypress Rd | Orlando | 32801 | USA |
| ORD10018 | delivered | 0 | NC | SCH218 | Liberty High School | Liberty District | VEND101 | EduSupplies Inc. | STN-009 | Binders (1 inch, Pack of 3) | stationery | 13 | 2023-09-28 | 2023-10-07 | 2023-10-07 | blank | 65 | Monica Davis | mdavis@ | 201 Liberty St | Greensboro | 27401 | USA |
| ORD10019 | pending | blank | IA | SCH219 | River Valley School | River Valley District | VEND104 | Furniture 4 Schools | FUR-021 | Bookcase (3-Shelf) | furniture | 5 | 2023-10-19 | 2023-10-29 | blank | blank | 250 | Samuel Lin | samuel.lin@ | 123 River Rd | Cedar Rapids | 52401 | USA |
| ORD10020 | delayed | 2 | AZ | SCH220 | Sunset Elementary | Sunset District | VEND109 | Office Depot Education | STN-028 | Index Cards (Pack of 100) | stationery | 16 | 2023-08-13 | 2023-08-20 | 2023-08-22 | Address confirmation required | 32 | Natalie Turner | nturner@ | 56 Sunset Blvd | Mesa | 85201 | USA |
What the 85 rows show
from the 85-row sampleDelivered (order status) stands out: mean delay_
- 2median delay_
days - 4item categories
- 12vendors
- 17vendor names
- 12median quantity_
ordered - 108.0median order_
total_ amount
Median 2, from 0 to 6.
- string 18
- integer 2
- float 1
- date 3
Columns
24 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 18 columns | |||
order_id | string | Unique identifier for each procurement order.unique | ORD10001 |
school_id | string | Unique identifier for the school placing the order. | SCH201 |
school_name | string | Name of the school placing the order. | Lincoln Middle School |
school_district | string | Name of the school district.optional | Northside District |
vendor_id | string | Unique identifier for the vendor supplying the order.12 vendors | VEND101 |
vendor_name | string | Name of the vendor supplying the school supplies. | EduSupplies Inc. |
item_sku | string | Stock keeping unit (SKU) for the ordered item. | STN-001 |
item_name | string | Name or description of the ordered school supply item. | Adjustable Student Desk |
item_category | string | Category of the school supply item (e.g., stationery, furniture, electronics).stationery · furniture · electronics · cleaning · other · optional | stationery |
order_status | string | Current status of the order (e.g., pending, shipped, delivered, delayed, cancelled).pending · shipped · delivered · delayed · cancelled | delivered |
delay_reason | string | Reason for delivery delay, if any.optional | Supply chain disruption |
contact_person | string | Name of the primary contact person for the order.optional | Sandra Owens |
contact_email | string | Email address of the contact person.optional | glee@ |
delivery_address_street | string | Street address for delivery. | 123 School Lane |
delivery_address_city | string | City for delivery. | Riverton |
delivery_address_state | string | State or province for delivery. | TX |
delivery_address_postal_code | string | Postal code for delivery address. | 75001 |
delivery_address_country | string | Country for delivery. | USA |
| Numbers 3 columns | |||
quantity_ordered | integer | Number of units ordered for the item.1 or more | 15 |
delay_days | integer | Number of days the delivery was delayed (actual_delivery_date - expected_delivery_date).0 or more · optional | 0 |
order_total_amount | float | Total monetary amount for the order.0 or more | 45 |
| Dates and times 3 columns | |||
order_date | date | Date when the procurement order was placed. | 2023-08-01 |
expected_delivery_date | date | Date when the supplies are expected to be delivered. | 2023-08-10 |
actual_delivery_date | date | Date when the supplies were actually delivered.optional | 2023-08-10 |
Use it for
An education dashboard
Delay_
days by order_ status and a breakdown of delivery_ address_ state. Excel, Power BI or Tableau. Why do the 35 delivered rows have a mean delay_
days of 0.83? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Orders85ORD100010deliveredORD100026delayedORD10003pending
A software demo
Believable orders with school_
id, school_ name and school_ district to fill a screen in front of a buyer.
blueprint · school-supplies-procurement-delay-tracking
Behind this dataset
Same schema. As many rows as you need.
These 85 rows came out of a blueprint — 24 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 represents a unique supply order.
- Order status must be updated as 'Ordered', 'Shipped', 'Delivered', or 'Delayed'.
- Delay reasons are required for any order marked 'Delayed'.
- Vendor ratings are recalculated quarterly based on delivery punctuality.
- Only K-12 school supply requests are included.
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- school-supplies-procurement-delay-tracking