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.

Open the Data Generator

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.

Open the Data Generator

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

  1. Open the Data Generator and pick Flight bookings or Shipments.
  2. Choose the number of rows.
  3. Pick CSV, Excel, JSON or Parquet.
  4. 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.