Resale ticket fields in every export
The event record covers event identifier, name, performer or team, venue, city and country, event date and local start time, on sale status and the event URL.
Listing observations are the core and they are timestamped rows rather than a current state. Each carries the seating section and row where published, the quantity available, the price per ticket as displayed, the fee component where it is shown separately, the total at checkout where reachable, the currency, and the seller type where the marketplace distinguishes brokers from individuals.
Derived measures per observation are computed from stored rows rather than supplied unexplained: the lowest available price in each seating category, the median, the count of distinct listings and the total quantity on offer. Those four together describe an inventory far better than a single get in price does.
Fee treatment is explicit. Which price the observation captured, whether fees were included, and the total where it was obtainable, all as separate fields, because the gap between headline and checkout is frequently the entire subject of the analysis.
Every row carries the observation timestamp to the minute and the market it was collected for, since prices and availability differ by country.