BWI Passenger Data - January 2010 To July 2013
State of Maryland
@usgov.state_of_maryland_bwi_passenger_data_january_2010_to_july_2013
State of Maryland
@usgov.state_of_maryland_bwi_passenger_data_january_2010_to_july_2013
The total number of passengers per month by airline flying into and out of Baltimore/Washington International Thurgood Marshall Airport. Passenger totals include both local and connecting passengers.
Organization: State of Maryland
Last updated: 2020-11-10T17:24:03.411318
Tags: airlines, airport, passenger
CREATE TABLE table_1 (
"year" BIGINT,
"month" VARCHAR,
"southwest_airtran" BIGINT -- Southwest - Airtran,
"n__american" BIGINT -- American,
"american_eagle" BIGINT -- American - Eagle,
"cape_air" BIGINT,
"delta" BIGINT,
"delta_asa" BIGINT -- Delta - ASA,
"delta_chautaqua" BIGINT -- Delta - Chautaqua,
"delta_comair" BIGINT -- Delta - Comair,
"delta_compass" BIGINT -- Delta - Compass,
"delta_freedom" BIGINT -- Delta - Freedom,
"delta_gojet" BIGINT -- Delta - Gojet,
"delta_mesaba" BIGINT -- Delta - Mesaba,
"delta_northwest" BIGINT -- Delta - Northwest,
"northwest_pinnacle" BIGINT -- Northwest - Pinnacle,
"delta_skywest" DOUBLE -- Delta - Skywest,
"delta_pinnacle" BIGINT -- Delta - Pinnacle,
"jetblue" BIGINT,
"spirit" BIGINT,
"midwest_connect_skyway" BIGINT -- Midwest Connect - Skyway,
"southwest" BIGINT,
"continental_chautaqua" BIGINT -- Continental - Chautaqua,
"continental_expressjet" BIGINT -- Continental - Expressjet,
"united" BIGINT,
"united_chautauqua" BIGINT -- United - Chautauqua,
"united_colgan" BIGINT -- United - Colgan,
"united_commutair" BIGINT -- United - Commutair,
"united_continental" BIGINT -- United - Continental,
"united_expressjet" BIGINT -- United - Expressjet,
"united_gojet" BIGINT -- United - Gojet,
"n__united_shuttle_america" BIGINT -- United - Shuttle America,
"united_republic" DOUBLE -- United - Republic,
"us_airways" BIGINT,
"us_airways_air_wisconsin" BIGINT -- US Airways - Air Wisconsin,
"us_airways_chautaqua" BIGINT -- US Airways - Chautaqua,
"us_airways_mesa" BIGINT -- US Airways - Mesa,
"us_airways_piedmont" BIGINT -- US Airways - Piedmont,
"us_airways_psa" BIGINT -- US Airways - PSA,
"us_airways_republic" BIGINT -- US Airways - Republic,
"air_canada" BIGINT,
"air_jamaica" BIGINT,
"bahamasair" BIGINT,
"british_airways" BIGINT,
"condor" BIGINT,
"frontier" BIGINT,
"usa_3000" BIGINT,
"vision_airlines" BIGINT,
"air_canada_jetz" BIGINT,
"aero_mexico" BIGINT,
"allegiant_air" BIGINT,
"ameristar" BIGINT,
"ati" BIGINT,
"atlas_air" BIGINT,
"capital_airlines" BIGINT,
"falcon_air_express" BIGINT,
"hawaiian" BIGINT,
"lan_airlines" BIGINT,
"miami_air" BIGINT,
"midwest_airlines" BIGINT,
"north_american" BIGINT,
"northrop_grumman" BIGINT,
"omni" BIGINT,
"other" BIGINT,
"republic" BIGINT,
"ryan" BIGINT,
"sas" BIGINT,
"saudi_arabian" BIGINT,
"sierra_pacific" BIGINT,
"sky_king" BIGINT,
"sun_county" BIGINT,
"swift_air" BIGINT,
"team_jet" BIGINT,
"titan_airways" BIGINT,
"usa_jet" BIGINT,
"world" BIGINT,
"world_atlantic" BIGINT
);Anyone who has the link will be able to view this.