Flight Booking and Shipment Sample Data: Free Travel and Logistics Datasets
Travel and logistics reports need rows for routes, fares, parcels and delays. Generate flight bookings and shipments in your browser and download them free, with no real passengers or customers.
Two datasets
Flight bookings has a booking reference, passenger, flight number, origin and destination airport (IATA codes such as LHR, DEL or JFK), departure time, travel class and fare. Shipments has a tracking number, carrier, origin and destination city, weight, status and shipped date.
Weighted, not uniform
Travel class is weighted, so most seats are Economy and few are First. Shipment status is weighted too: most shipments are Delivered, some are In transit, and a few are Delayed or Returned. That gives charts and percentage calculations a realistic shape instead of equal bars.
The routes are random pairs from about 28 major airports. Origin and destination can occasionally be the same airport. If that matters for your test, filter those rows out with a simple condition, such as WHERE origin <> destination.
Reports to build
For flights, build revenue by travel class and the busiest routes: SELECT origin, destination, COUNT(*) AS bookings, ROUND(SUM(fare), 2) AS revenue FROM flights GROUP BY origin, destination ORDER BY revenue DESC; For shipments, calculate the share of each status and the average weight by carrier. Both run in SQL on Your Files without installing anything.
What to use it for
Use it to build a dashboard, test a booking or tracking screen, practise group by and date functions, or fill a demo database. Download Parquet when a file is large, and see CSV vs Parquet file size for what to expect.
What it is not
The data is random. Fares are not based on real prices, flight numbers do not correspond to real schedules, and the carriers are invented names.
Related tool pages
- Fake Data Generator: Generate realistic fake data online: names, emails, addresses, dates and more, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
- Test Data Generator: Generate test data for databases and apps: names, emails, addresses, dates and numbers, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
- Student Data Generator: Fake Student Records: Generate fake student data for class projects: IDs, names, courses, marks and attendance. Download CSV, Excel, JSON or Parquet. Free.
- Student Marks Dataset Generator: Create a student marks dataset by student, subject and exam for SQL, Excel pivot tables and charts. Free, in your browser.
- Sample Data for SQL Practice: Generate sample tables for SQL practice (students, orders, employees), download CSV and query it in your browser. Free.
- Dummy Data for Excel Practice: Generate dummy sales, student or employee data and download Excel to practise filters, pivot tables and VLOOKUP. Free.
Also try
How to use the Data Generator: step by step
- Open the Data Generator and pick Flight bookings or Shipments.
- Choose the number of rows.
- Pick CSV, Excel, JSON or Parquet.
- Download the file and open it in your tool.
When to use the Data Generator
- Build a travel revenue dashboard
- Test a booking or parcel tracking screen
- Practise SQL group by on routes and statuses
- Fill a demo database for a logistics app
Example
Input: Dataset: Customers, 3 rows
Output: id,name,email 1,Maya Patel,maya.patel@example.com 2,Leo Fischer,leo.fischer@example.com
Frequently asked questions
Are these real flights?
No. Airport codes are real, but routes, flight numbers, passengers and fares are random and do not match real schedules or prices.
Can origin and destination be the same?
Occasionally, because the two columns are independent. Filter those rows with WHERE origin <> destination if your test needs different airports.
How many rows can I generate?
Up to 500,000 rows in the Data Generator. Choose the row count before you download.
Tip: Set the departure date range in the generator to the period your report covers, so date filters return rows.