Synthetic dataset

Freight Brokerage Load-to-Carrier-Invoice (Synthetic): Field Dictionary and 100-Row Sample

Sukhrobjon (Rob) Ismoilov
Sukhrobjon (Rob) Ismoilov
Founder & Principal, Main Street Wealth

One row per brokered load: lane, equipment, quoted shipper rate, carrier rate and margin, appointment performance, detention and accessorials, proof of delivery and the carrier’s invoice and payment. Every value is synthetic.

Last Updated November 16, 2026
3 min read
Share:
Quick facts
VerticalFreight brokerage
Fields15
Rows100, synthetic
LicenseCC BY 4.0

Dataset

Field dictionary and sample

100-row synthetic sample:CSVJSONCC BY 4.0 — cite “Main Street Wealth” with a link to this page.
FieldTypeMeaningWhat it replaces in real data
load_idstringLoad identifierInternal ID
shipper_tokenstringPseudonym for the shipperReplaces customer name
carrier_tokenstringPseudonym for the carrierReplaces carrier name, MC/DOT number
origin_zip3stringOrigin three-digit ZIPGeneralised
dest_zip3stringDestination three-digit ZIPGeneralised
milesintegerLoaded miles—
equipmentenumTrailer type—
weight_lbsintegerShipment weight—
shipper_ratenumberRate quoted to shipper (USD)Commercially confidential
carrier_ratenumberRate paid to carrier (USD)Commercially confidential
pickup_delay_minintegerMinutes late to pickup appointment—
detention_hoursnumberBillable detention—
accessorialsenumAccessorial charges applied—
pod_receivedbooleanProof of delivery receivedReplaces POD image (signatures)
days_to_pay_carrierintegerCarrier invoice to payment—
Field dictionary.
load_idshipper_tokencarrier_tokenorigin_zip3dest_zip3milesequipmentweight_lbsshipper_ratecarrier_ratepickup_delay_mindetention_hoursaccessorialspod_receiveddays_to_pay_carrier
L-500000shp_9698b5car_2d31b81914811175flatbed258672932.242605.9600TONUtrue34
L-500001shp_c06018car_1bdf517523362044flatbed317527317.936053.800TONUtrue31
L-500002shp_861c9bcar_211ec81911911085reefer126113627.483058.3300lumpertrue15
L-500003shp_fda070car_e771c13393271893dry van191054080.873592.311273.5detentiontrue36
L-500004shp_9e1fb8car_41738f3363391658dry van344593714.053175.5700nonetrue37
L-500005shp_53b9b4car_d9d3613013272007dry van218284831.433932.0300layovertrue2
L-500006shp_204b29car_73b7a6191972163dry van22784450371.05690nonetrue14
L-500007shp_ac0380car_8a610c7523011207flatbed346173093.592587.300lumpertrue11
First 8 of 100 synthetic rows. Every row is generated from a seeded random-number generator. No row is derived from any real company’s records, and the value distributions are invented for illustration — they are not market statistics.

Section 2

How to use this schema

  1. Map each field to the column in your own export that feeds it.
  2. Apply the “what it replaces” column: tokens for people, three-digit ZIPs for addresses, coded values for free-text notes.
  3. Keep the identifiers that link records across systems — that chain is what buyers price.
  4. Run a sample of your mapped output through the PII scanner before anyone else sees it.

Frequently asked questions

Is this real data?
Every row is generated from a seeded random-number generator. No row is derived from any real company’s records, and the value distributions are invented for illustration — they are not market statistics.

Want a straight read on what your records are worth?

Send us the systems, years and rough record counts. We tell you what is licensable, get competing written quotes, and you pay nothing if buyers pass.

Request the evaluation form
Calendar

This article is provided for general educational purposes and is not legal, tax, investment, or accounting advice. Multiples, fee ranges, and timelines are illustrative ranges compiled from third-party sources current as of November 16, 2026 and will vary by transaction and market conditions. Consult qualified counsel before acting on any information contained here.