Logistics
23 columns
200 rows
8 formats

Parcel Sorting Facility Records

This dataset provides detailed, event-level records of parcels processed through sorting facilities, capturing parcel dimensions, weight, routing decisions, timestamps, facility metadata, and exception handling. It enables comprehensive analysis of logistics flows, bottleneck identification, and optimization of parcel routing and facility operations.

last updated 12 Jul 2025
by GoMask

The brief that made it

Logistics flow optimization and bottleneck analysis

Sample rows

preview · 8 of 200 rows · all 23 columns

record_idstring	routing_decisionstring	parcel_length_cmfloat	exception_flagboolean	facility_countrystring	parcel_idstring	facility_idstring	facility_namestring	facility_citystring	facility_statestring	arrival_datetimedatetime	departure_datetimedatetime	processing_duration_minutesinteger	parcel_width_cmfloat	parcel_height_cmfloat	parcel_weight_kgfloat	destination_citystring	destination_statestring	destination_countrystring	next_facility_idstring	operator_idstring	notesstring	exception_reasonstring
REC001	forwarded	36.5	false	USA	PKG2024001	FAC1001	Northeast Regional Hub	Newark	NJ	2024-06-01T07:20:00Z	2024-06-01T08:45:00Z	85	22.4	15.7	3.2	Boston	MA	USA	FAC1005	OP1234	Standard processing, no issues reported.	blank
REC002	out_for_delivery	42	false	USA	PKG2024002	FAC1002	Atlanta Metro Sort Center	Atlanta	GA	2024-06-01T10:30:00Z	2024-06-01T12:05:00Z	95	28	16	4.1	Charlotte	NC	USA	blank	OP1101	Express parcel, prioritized for early dispatch.	blank
REC003	forwarded	55.5	false	Germany	PKG2024INT1	FACDE01	Frankfurt International Hub	Frankfurt	HE	2024-06-01T04:00:00Z	2024-06-01T13:00:00Z	540	38.7	22.3	9.8	Tokyo	Tokyo	Japan	FACJP01	OP9001	International shipment, cleared for customs.	blank
REC004	forwarded	39.2	false	USA	PKG2024004	FAC1003	Southwest Regional Sort	Dallas	TX	2024-06-01T14:15:00Z	2024-06-01T16:05:00Z	110	30	18.5	4.7	Houston	TX	USA	FAC1007	OP1352	Standard processing, no delays observed.	blank
REC005	forwarded	22	false	USA	PKG2024005	FAC1004	Great Lakes Hub	Chicago	IL	2024-06-01T06:00:00Z	2024-06-01T06:45:00Z	45	12.5	8	1.1	Detroit	MI	USA	FAC1008	OP1198	Standard parcel, direct routing.	blank
REC006	held	32.2	true	USA	PKG2024RET1	FAC1010	Seattle Returns Center	Seattle	WA	2024-06-01T09:50:00Z	blank	blank	19	11.5	2.7	blank	blank	blank	blank	OP1222	Awaiting customer instruction before further processing.	Return shipment pending customer confirmation.
REC007	out_for_delivery	21.5	false	USA	PKG2024006	FAC1005	Boston Metro Sort	Boston	MA	2024-06-01T12:10:00Z	2024-06-01T13:30:00Z	80	10	7	0.9	Providence	RI	USA	blank	OP1234	Final delivery stage.	blank
REC008	held	162.5	true	USA	PKG2024007	FAC1006	Denver Central Hub	Denver	CO	2024-06-01T21:00:00Z	blank	blank	80	60	120	Salt Lake City	UT	USA	blank	OP1407	Requires special handling due to size.	Oversized parcel, pending manual inspection.
REC009	forwarded	37	false	USA	PKG2024008	FAC1007	Houston Metro Sort	Houston	TX	2024-06-02T03:30:00Z	2024-06-02T04:30:00Z	60	25	13.5	2.9	Austin	TX	USA	FAC1012	OP1492	Standard routing, on schedule.	blank
REC010	forwarded	48.2	false	Canada	PKG2024INT2	FACCA01	Toronto Intl Gateway	Toronto	ON	2024-06-01T16:55:00Z	2024-06-01T19:10:00Z	135	32	20	6.4	Montreal	QC	Canada	FACCA03	OP2015	International routing, customs cleared.	blank
REC011	forwarded	29	false	USA	PKG2024009	FAC1008	Detroit Gateway Facility	Detroit	MI	2024-06-02T07:40:00Z	2024-06-02T09:00:00Z	80	16	9	1.8	Cleveland	OH	USA	FAC1013	OP1199	No exceptions, processed in standard window.	blank
REC012	out_for_delivery	26.4	false	USA	PKG2024010	FAC1011	San Diego Distribution Center	San Diego	CA	2024-06-01T18:00:00Z	2024-06-01T19:42:00Z	102	14.9	7.8	1.2	San Diego	CA	USA	blank	OP1253	Last mile delivery.	blank
REC013	forwarded	113	false	USA	PKG2024011	FAC1009	St. Louis Metro Sort	St. Louis	MO	2024-06-02T05:30:00Z	2024-06-02T09:30:00Z	240	61	40	68	Kansas City	MO	USA	FAC1014	OP1337	Heavy parcel, processed with forklift.	blank
REC014	other	0	true	USA	PKG2024012	FAC1012	Austin Distribution	Austin	TX	2024-06-02T05:00:00Z	blank	blank	0	0	0	blank	blank	blank	blank	blank	Boundary test case for zero values.	Empty parcel record generated for system test.
REC015	forwarded	35.5	false	USA	PKG2024013	FAC1013	Cleveland Crossdock	Cleveland	OH	2024-06-02T10:00:00Z	2024-06-02T11:50:00Z	110	24	13	2.6	Pittsburgh	PA	USA	FAC1015	OP1432	Onward routing to final hub.	blank
REC016	forwarded	37	false	USA	PKG2024014	FAC1014	Kansas City Hub	Kansas City	MO	2024-06-02T13:30:00Z	2024-06-02T15:00:00Z	90	21.5	11	3	Omaha	NE	USA	FAC1016	OP1366	Processed without delay.	blank
REC017	held	34	true	USA	PKG2024015	FAC1015	Pittsburgh Distribution Ctr	Pittsburgh	PA	2024-06-02T12:00:00Z	blank	blank	19.5	10	2.4	Buffalo	NY	USA	blank	OP1408	Customer notified for further action.	Parcel damaged during sortation.
REC018	out_for_delivery	28	false	USA	PKG2024016	FAC1016	Omaha Midwestern Hub	Omaha	NE	2024-06-02T16:15:00Z	2024-06-02T18:10:00Z	115	14	8.5	1.5	Des Moines	IA	USA	blank	OP1238	Ready for final delivery.	blank
REC019	forwarded	22.5	false	USA	PKG2024017	FAC1017	Salt Lake City Hub	Salt Lake City	UT	2024-06-02T19:45:00Z	2024-06-02T20:30:00Z	45	12	7.2	1	Ogden	UT	USA	FAC1018	OP1450	Express routing to branch facility.	blank
REC020	out_for_delivery	23	false	USA	PKG2024018	FAC1018	Ogden Distribution	Ogden	UT	2024-06-02T21:00:00Z	2024-06-02T21:45:00Z	45	13	7.5	1.2	Ogden	UT	USA	blank	OP1451	Final delivery, no issues.	blank

What the 200 rows show

from the 200-row sample

Held (routing decision) stands out: 28 of its 28 rows have exception_flag = true, against 10 of 172 for the rest.

19%exception_flag = true
32.2median parcel_length_cm
7destination countries
45destination states
46facility states
87median processing_duration_minutes

Exception flag rate by routing_decisionexception_flag = true

parcel_length_cm200 rows, in bands of 50

Median 32.2, from 0.0 to 350.0.

facility_country199 rows with a value · 1 left blank

USA176
UK5
Germany4
Canada4
France4
NowhereLand3
Japan3

23 columns by typefrom the column list below

string 15
integer 1
float 4
datetime 2
boolean 1

Columns

23 columns in four groups

blueprint · 23 columns
column	type	description	example
Text 15 columns
`record_id`	string	Unique identifier for each parcel sorting recordunique	REC001
`parcel_id`	string	Unique identifier for the parcel being sorted	PKG2024001
`facility_id`	string	Identifier for the sorting facility processing the parcel	FAC1001
`facility_name`	string	Name of the sorting facilityoptional	Northeast Regional Hub
`facility_city`	string	City where the sorting facility is locatedoptional	Newark
`facility_state`	string	State or region of the sorting facilityoptional	NJ
`facility_country`	string	Country of the sorting facility7 countries · optional	USA
`destination_city`	string	Destination city for the parceloptional	Boston
`destination_state`	string	Destination state or region for the parceloptional	MA
`destination_country`	string	Destination country for the parcel7 countries · optional	USA
`routing_decision`	string	Routing decision taken for the parcel at this facility (e.g., next facility, direct delivery, hold)forwarded · held · returned · out_for_delivery · other	forwarded
`next_facility_id`	string	Identifier for the next facility in the routing path, if applicableoptional	FAC1005
`operator_id`	string	Identifier for the operator or system that processed the parceloptional	OP1234
`exception_reason`	string	Description of the exception, if anyoptional	Return shipment pending c…
`notes`	string	Additional notes or comments regarding the parcel or sorting processoptional	Final delivery stage.
Numbers 5 columns
`processing_duration_minutes`	integer	Total time in minutes the parcel spent at the facility0 or more · optional	85
`parcel_length_cm`	float	Length of the parcel in centimeters0 or more	36.5
`parcel_width_cm`	float	Width of the parcel in centimeters0 or more	22.4
`parcel_height_cm`	float	Height of the parcel in centimeters0 or more	15.7
`parcel_weight_kg`	float	Weight of the parcel in kilograms0 or more	3.2
Dates and times 2 columns
`arrival_datetime`	datetime	Date and time when the parcel arrived at the facility	2024-06-01T07:20:00Z
`departure_datetime`	datetime	Date and time when the parcel left the facilityoptional	2024-06-01T08:45:00Z
True or false 1 column
`exception_flag`	boolean	Indicates if an exception occurred during sorting (e.g., damage, address issue)	false

Use it for

A logistics dashboard
The exception_flag rate, parcel_length_cm by routing_decision and a breakdown of facility_country. Excel, Power BI or Tableau.
Why do 38 of 200 rows have exception_flag = true?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Records200
REC00136.5forwarded
REC00632.2held
REC008162.5held
A software demo
Believable records with parcel_id, facility_id and facility_name to fill a screen in front of a buyer.

This dataset200 rows23 columns

Yours1,000 rows23 columnsfacility_city: UK only

blueprint · parcel-sorting-facility-records

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 23 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.

Rules it was built with

Each parcel has facility and timestamp
Include measured weight, dimensions, and routing outcome
Flag handling exceptions
No sender/recipient info

Rows1,000 rows10,000 rows100,000 rows1,000,000 rows

Open the blueprint in Data Factory

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: parcel-sorting-facility-records

What should your data show?

No signup. No card.

Sample rows

What the 200 rows show

Columns

Use it for

A logistics dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Logistics

What should your data show?