| Quick facts | |
|---|---|
| Vertical | Freight brokerage |
| Fields | 15 |
| Rows | 100, synthetic |
| License | CC BY 4.0 |
Dataset
Field dictionary and sample
| Field | Type | Meaning | What it replaces in real data |
|---|---|---|---|
load_id | string | Load identifier | Internal ID |
shipper_token | string | Pseudonym for the shipper | Replaces customer name |
carrier_token | string | Pseudonym for the carrier | Replaces carrier name, MC/DOT number |
origin_zip3 | string | Origin three-digit ZIP | Generalised |
dest_zip3 | string | Destination three-digit ZIP | Generalised |
miles | integer | Loaded miles | — |
equipment | enum | Trailer type | — |
weight_lbs | integer | Shipment weight | — |
shipper_rate | number | Rate quoted to shipper (USD) | Commercially confidential |
carrier_rate | number | Rate paid to carrier (USD) | Commercially confidential |
pickup_delay_min | integer | Minutes late to pickup appointment | — |
detention_hours | number | Billable detention | — |
accessorials | enum | Accessorial charges applied | — |
pod_received | boolean | Proof of delivery received | Replaces POD image (signatures) |
days_to_pay_carrier | integer | Carrier invoice to payment | — |
| load_id | shipper_token | carrier_token | origin_zip3 | dest_zip3 | miles | equipment | weight_lbs | shipper_rate | carrier_rate | pickup_delay_min | detention_hours | accessorials | pod_received | days_to_pay_carrier |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| L-500000 | shp_9698b5 | car_2d31b8 | 191 | 481 | 1175 | flatbed | 25867 | 2932.24 | 2605.96 | 0 | 0 | TONU | true | 34 |
| L-500001 | shp_c06018 | car_1bdf51 | 752 | 336 | 2044 | flatbed | 31752 | 7317.93 | 6053.8 | 0 | 0 | TONU | true | 31 |
| L-500002 | shp_861c9b | car_211ec8 | 191 | 191 | 1085 | reefer | 12611 | 3627.48 | 3058.33 | 0 | 0 | lumper | true | 15 |
| L-500003 | shp_fda070 | car_e771c1 | 339 | 327 | 1893 | dry van | 19105 | 4080.87 | 3592.31 | 127 | 3.5 | detention | true | 36 |
| L-500004 | shp_9e1fb8 | car_41738f | 336 | 339 | 1658 | dry van | 34459 | 3714.05 | 3175.57 | 0 | 0 | none | true | 37 |
| L-500005 | shp_53b9b4 | car_d9d361 | 301 | 327 | 2007 | dry van | 21828 | 4831.43 | 3932.03 | 0 | 0 | layover | true | 2 |
| L-500006 | shp_204b29 | car_73b7a6 | 191 | 972 | 163 | dry van | 22784 | 450 | 371.05 | 69 | 0 | none | true | 14 |
| L-500007 | shp_ac0380 | car_8a610c | 752 | 301 | 1207 | flatbed | 34617 | 3093.59 | 2587.3 | 0 | 0 | lumper | true | 11 |
Section 2
How to use this schema
- Map each field to the column in your own export that feeds it.
- Apply the “what it replaces” column: tokens for people, three-digit ZIPs for addresses, coded values for free-text notes.
- Keep the identifiers that link records across systems — that chain is what buyers price.
- Run a sample of your mapped output through the PII scanner before anyone else sees it.