Dataset pack

Flights and airports

Flights with origin and destination airport codes, and the airport table.

Fictional data · UTF-8 CSV, every value quoted so padding and leading zeros survive; empty fields are missing values · free for personal and classroom practice · practise it in One lookup table, two roles.

flights 20 rows × 3 columns

Download flights.csv (Pro)

Data dictionary

id: Unique flight ID.
origin: Origin airport code.
dest: Destination airport code.

airports 5 rows × 2 columns

Download airports.csv (Pro)

Data dictionary

code: Airport code (unique).
city: City served.

Values are shown in quotes so leading and trailing spaces are visible. ∅ means the cell is missing. Exercises are also graded on hidden datasets that are never published.