Dataset: Most Crowded Airports

About this Dataset

Most Crowded Airports

Context

Airports are the gate of a new country or city and exploring different airports would be entertaining, in this dataset you would take an overview of the most crowded airports between 2016-2020

Content

The dataset contains 250 different airports and each airport has the following attributes:

Rank: Airport ranking for that year

Airport: Airport name

Location: Airport location

Country: Airport country

Code: Code of the airport (IATA/ICAO)

Passengers: Total number of passengers

Year: Year of ranking

Questions to be answered

Which country has the most crowded airports ?
Which year had the most passengers ?
Which year had the least passengers ?
What is the total of passengers in the U.S in 2020 ?

Tables

Airports

@kaggle.khaiid_most_crowded_airports.airports

12.26 KB
250 rows
7 columns


CREATE TABLE airports (
  "rank" BIGINT,
  "airport" VARCHAR,
  "location" VARCHAR,
  "country" VARCHAR,
  "code" VARCHAR,
  "passengers" BIGINT,
  "year" BIGINT
);