Global Air Transport Data
Data on carrier departures, freight weights, passengers carried, and more
@kaggle.tjkyner_global_air_transport_data
Data on carrier departures, freight weights, passengers carried, and more
@kaggle.tjkyner_global_air_transport_data
This dataset contains information on global air transport data for most countries around the world between 2005 and 2019. The available series include:
Data source: The World Bank
Image source: John McArthur on Unsplash
Some questions to get started:
CREATE TABLE data (
"series_name" VARCHAR,
"series_code" VARCHAR,
"country_name" VARCHAR,
"country_code" VARCHAR,
"n_2005_yr2005" VARCHAR -- 2005 [YR2005],
"n_2006_yr2006" VARCHAR -- 2006 [YR2006],
"n_2007_yr2007" VARCHAR -- 2007 [YR2007],
"n_2008_yr2008" VARCHAR -- 2008 [YR2008],
"n_2009_yr2009" VARCHAR -- 2009 [YR2009],
"n_2010_yr2010" VARCHAR -- 2010 [YR2010],
"n_2011_yr2011" VARCHAR -- 2011 [YR2011],
"n_2012_yr2012" VARCHAR -- 2012 [YR2012],
"n_2013_yr2013" VARCHAR -- 2013 [YR2013],
"n_2014_yr2014" VARCHAR -- 2014 [YR2014],
"n_2015_yr2015" VARCHAR -- 2015 [YR2015],
"n_2016_yr2016" VARCHAR -- 2016 [YR2016],
"n_2017_yr2017" VARCHAR -- 2017 [YR2017],
"n_2018_yr2018" VARCHAR -- 2018 [YR2018],
"n_2019_yr2019" VARCHAR -- 2019 [YR2019],
"n_2020_yr2020" VARCHAR -- 2020 [YR2020]
);
Anyone who has the link will be able to view this.