TrackingMore fields in every export
Carrier records carry the carrier name, its identifier on the platform, country or countries of operation, carrier type such as postal, express or last mile, website, and the tracking number formats it uses where documented.
Status vocabulary is collected per carrier as its own rows: the raw status text the carrier emits, and the normalised lifecycle stage we map it to. Both are kept, because the normalisation is an interpretation and a user who disagrees with a mapping needs the original to work from.
The normalised lifecycle is a small deliberate set - information received, in transit, out for delivery, delivered, exception, returned - chosen because a finer scheme cannot be populated consistently across a thousand carriers and a coarser one loses the distinctions people act on.
Coverage fields record which countries and lanes a carrier serves, which is the question most e-commerce operators bring to this data.
Every row carries the collection timestamp, since carrier coverage and naming change more often than people expect.