What Is Malloy
Bar Charts
The examples below all use the following semantic model.
source: flights is duckdb.table('../data/flights.parquet') extend { join_one: carriers is duckdb.table('../data/carriers.parquet') on carrier = carriers.code measure: flight_count is count() aircraft_count is count(distinct tail_num) }
Line charts take two or three parameters.
First parameter - X-axis is time field or numeric expression
Second parameter - Y-axis is a numeric expression
Third (optional) Pivot is dimensional field (numeric or string)
Single line line_chart
# line_chart run: flights -> { group_by: departure_month is dep_time.month aggregate: flight_count }
[ { "departure_month": "2005-12-01T00:00:00.000Z", "flight_count": 5770 }, { "departure_month": "2005-11-01T00:00:00.000Z", "flight_count": 5533 }, { "departure_month": "2005-10-01T00:00:00.000Z", "flight_count": 6083 }, { "departure_month": "2005-09-01T00:00:00.000Z", "flight_count": 6100 }, { "departure_month": "2005-08-01T00:00:00.000Z", "flight_count": 6415 }, { "departure_month": "2005-07-01T00:00:00.000Z", "flight_count": 6227 }, { "departure_month": "2005-06-01T00:00:00.000Z", "flight_count": 6118 }, { "departure_month": "2005-05-01T00:00:00.000Z", "flight_count": 6064 }, { "departure_month": "2005-04-01T00:00:00.000Z", "flight_count": 6043 }, { "departure_month": "2005-03-01T00:00:00.000Z", "flight_count": 5732 }, { "departure_month": "2005-02-01T00:00:00.000Z", "flight_count": 5707 }, { "departure_month": "2005-01-01T00:00:00.000Z", "flight_count": 5997 }, { "departure_month": "2004-12-01T00:00:00.000Z", "flight_count": 6202 }, { "departure_month": "2004-11-01T00:00:00.000Z", "flight_count": 6084 }, { "departure_month": "2004-10-01T00:00:00.000Z", "flight_count": 6228 }, { "departure_month": "2004-09-01T00:00:00.000Z", "flight_count": 5689 }, { "departure_month": "2004-08-01T00:00:00.000Z", "flight_count": 5993 }, { "departure_month": "2004-07-01T00:00:00.000Z", "flight_count": 5775 }, { "departure_month": "2004-06-01T00:00:00.000Z", "flight_count": 5622 }, { "departure_month": "2004-05-01T00:00:00.000Z", "flight_count": 5609 }, { "departure_month": "2004-04-01T00:00:00.000Z", "flight_count": 5385 }, { "departure_month": "2004-03-01T00:00:00.000Z", "flight_count": 5463 }, { "departure_month": "2004-02-01T00:00:00.000Z", "flight_count": 5223 }, { "departure_month": "2004-01-01T00:00:00.000Z", "flight_count": 5124 }, { "departure_month": "2003-12-01T00:00:00.000Z", "flight_count": 5134 }, { "departure_month": "2003-11-01T00:00:00.000Z", "flight_count": 4729 }, { "departure_month": "2003-10-01T00:00:00.000Z", "flight_count": 4726 }, { "departure_month": "2003-09-01T00:00:00.000Z", "flight_count": 4431 }, { "departure_month": "2003-08-01T00:00:00.000Z", "flight_count": 4918 }, { "departure_month": "2003-07-01T00:00:00.000Z", "flight_count": 5117 }, { "departure_month": "2003-06-01T00:00:00.000Z", "flight_count": 5005 }, { "departure_month": "2003-05-01T00:00:00.000Z", "flight_count": 5114 }, { "departure_month": "2003-04-01T00:00:00.000Z", "flight_count": 4873 }, { "departure_month": "2003-03-01T00:00:00.000Z", "flight_count": 5017 }, { "departure_month": "2003-02-01T00:00:00.000Z", "flight_count": 4720 }, { "departure_month": "2003-01-01T00:00:00.000Z", "flight_count": 4892 }, { "departure_month": "2002-12-01T00:00:00.000Z", "flight_count": 3999 }, { "departure_month": "2002-11-01T00:00:00.000Z", "flight_count": 3914 }, { "departure_month": "2002-10-01T00:00:00.000Z", "flight_count": 4340 }, { "departure_month": "2002-09-01T00:00:00.000Z", "flight_count": 4261 }, { "departure_month": "2002-08-01T00:00:00.000Z", "flight_count": 4326 }, { "departure_month": "2002-07-01T00:00:00.000Z", "flight_count": 4346 }, { "departure_month": "2002-06-01T00:00:00.000Z", "flight_count": 4375 }, { "departure_month": "2002-05-01T00:00:00.000Z", "flight_count": 4348 }, { "departure_month": "2002-04-01T00:00:00.000Z", "flight_count": 4046 }, { "departure_month": "2002-03-01T00:00:00.000Z", "flight_count": 4102 }, { "departure_month": "2002-02-01T00:00:00.000Z", "flight_count": 3583 }, { "departure_month": "2002-01-01T00:00:00.000Z", "flight_count": 4008 }, { "departure_month": "2001-12-01T00:00:00.000Z", "flight_count": 4086 }, { "departure_month": "2001-11-01T00:00:00.000Z", "flight_count": 3819 }, { "departure_month": "2001-10-01T00:00:00.000Z", "flight_count": 3809 }, { "departure_month": "2001-09-01T00:00:00.000Z", "flight_count": 3616 }, { "departure_month": "2001-08-01T00:00:00.000Z", "flight_count": 4607 }, { "departure_month": "2001-07-01T00:00:00.000Z", "flight_count": 4440 }, { "departure_month": "2001-06-01T00:00:00.000Z", "flight_count": 4451 }, { "departure_month": "2001-05-01T00:00:00.000Z", "flight_count": 4407 }, { "departure_month": "2001-04-01T00:00:00.000Z", "flight_count": 4328 }, { "departure_month": "2001-03-01T00:00:00.000Z", "flight_count": 3869 }, { "departure_month": "2001-02-01T00:00:00.000Z", "flight_count": 3672 }, { "departure_month": "2001-01-01T00:00:00.000Z", "flight_count": 4071 }, { "departure_month": "2000-12-01T00:00:00.000Z", "flight_count": 3744 }, { "departure_month": "2000-11-01T00:00:00.000Z", "flight_count": 3718 }, { "departure_month": "2000-10-01T00:00:00.000Z", "flight_count": 3858 }, { "departure_month": "2000-09-01T00:00:00.000Z", "flight_count": 3850 }, { "departure_month": "2000-08-01T00:00:00.000Z", "flight_count": 4182 }, { "departure_month": "2000-07-01T00:00:00.000Z", "flight_count": 4043 }, { "departure_month": "2000-06-01T00:00:00.000Z", "flight_count": 3774 }, { "departure_month": "2000-05-01T00:00:00.000Z", "flight_count": 4047 }, { "departure_month": "2000-04-01T00:00:00.000Z", "flight_count": 3778 }, { "departure_month": "2000-03-01T00:00:00.000Z", "flight_count": 4252 }, { "departure_month": "2000-02-01T00:00:00.000Z", "flight_count": 3876 }, { "departure_month": "2000-01-01T00:00:00.000Z", "flight_count": 4020 } ]
SELECT DATE_TRUNC('month', flights."dep_time") as "departure_month", COUNT( 1) as "flight_count" FROM '../data/flights.parquet' as flights GROUP BY 1 ORDER BY 1 desc NULLS LAST
Multi line line_chart
The third parameter in a line chart adds a line for each dimension found.
# line_chart run: flights -> { group_by: departure_month is dep_time.month aggregate: flight_count group_by: carriers.nickname }
[ { "departure_month": "2005-12-01T00:00:00.000Z", "flight_count": 557, "nickname": "Continental Express" }, { "departure_month": "2005-12-01T00:00:00.000Z", "flight_count": 356, "nickname": "American Eagle" }, { "departure_month": "2005-12-01T00:00:00.000Z", "flight_count": 1606, "nickname": "Southwest" }, { "departure_month": "2005-12-01T00:00:00.000Z", "flight_count": 428, "nickname": "American" }, { "departure_month": "2005-12-01T00:00:00.000Z", "flight_count": 136, "nickname": "America West" }, { "departure_month": "2005-12-01T00:00:00.000Z", "flight_count": 647, "nickname": "United" }, { "departure_month": "2005-12-01T00:00:00.000Z", "flight_count": 572, "nickname": "Northwest" }, { "departure_month": "2005-12-01T00:00:00.000Z", "flight_count": 93, "nickname": "Continental" }, { "departure_month": "2005-12-01T00:00:00.000Z", "flight_count": 153, "nickname": "Comair" }, { "departure_month": "2005-12-01T00:00:00.000Z", "flight_count": 333, "nickname": "USAir" }, { "departure_month": "2005-12-01T00:00:00.000Z", "flight_count": 104, "nickname": "Alaska" }, { "departure_month": "2005-12-01T00:00:00.000Z", "flight_count": 139, "nickname": "Delta" }, { "departure_month": "2005-12-01T00:00:00.000Z", "flight_count": 246, "nickname": "Jetblue" }, { "departure_month": "2005-12-01T00:00:00.000Z", "flight_count": 400, "nickname": "Atlantic Southeast" }, { "departure_month": "2005-11-01T00:00:00.000Z", "flight_count": 522, "nickname": "Continental Express" }, { "departure_month": "2005-11-01T00:00:00.000Z", "flight_count": 357, "nickname": "American Eagle" }, { "departure_month": "2005-11-01T00:00:00.000Z", "flight_count": 1448, "nickname": "Southwest" }, { "departure_month": "2005-11-01T00:00:00.000Z", "flight_count": 401, "nickname": "American" }, { "departure_month": "2005-11-01T00:00:00.000Z", "flight_count": 132, "nickname": "America West" }, { "departure_month": "2005-11-01T00:00:00.000Z", "flight_count": 584, "nickname": "United" }, { "departure_month": "2005-11-01T00:00:00.000Z", "flight_count": 551, "nickname": "Northwest" }, { "departure_month": "2005-11-01T00:00:00.000Z", "flight_count": 195, "nickname": "Comair" }, { "departure_month": "2005-11-01T00:00:00.000Z", "flight_count": 290, "nickname": "Atlantic Southeast" }, { "departure_month": "2005-11-01T00:00:00.000Z", "flight_count": 470, "nickname": "USAir" }, { "departure_month": "2005-11-01T00:00:00.000Z", "flight_count": 94, "nickname": "Alaska" }, { "departure_month": "2005-11-01T00:00:00.000Z", "flight_count": 185, "nickname": "Delta" }, { "departure_month": "2005-11-01T00:00:00.000Z", "flight_count": 82, "nickname": "Continental" }, { "departure_month": "2005-11-01T00:00:00.000Z", "flight_count": 222, "nickname": "Jetblue" }, { "departure_month": "2005-10-01T00:00:00.000Z", "flight_count": 503, "nickname": "Continental Express" }, { "departure_month": "2005-10-01T00:00:00.000Z", "flight_count": 344, "nickname": "American Eagle" }, { "departure_month": "2005-10-01T00:00:00.000Z", "flight_count": 1543, "nickname": "Southwest" }, { "departure_month": "2005-10-01T00:00:00.000Z", "flight_count": 406, "nickname": "American" }, { "departure_month": "2005-10-01T00:00:00.000Z", "flight_count": 163, "nickname": "America West" }, { "departure_month": "2005-10-01T00:00:00.000Z", "flight_count": 102, "nickname": "Continental" }, { "departure_month": "2005-10-01T00:00:00.000Z", "flight_count": 651, "nickname": "USAir" }, { "departure_month": "2005-10-01T00:00:00.000Z", "flight_count": 597, "nickname": "United" }, { "departure_month": "2005-10-01T00:00:00.000Z", "flight_count": 97, "nickname": "Alaska" }, { "departure_month": "2005-10-01T00:00:00.000Z", "flight_count": 499, "nickname": "Northwest" }, { "departure_month": "2005-10-01T00:00:00.000Z", "flight_count": 178, "nickname": "Comair" }, { "departure_month": "2005-10-01T00:00:00.000Z", "flight_count": 393, "nickname": "Atlantic Southeast" }, { "departure_month": "2005-10-01T00:00:00.000Z", "flight_count": 352, "nickname": "Delta" }, { "departure_month": "2005-10-01T00:00:00.000Z", "flight_count": 255, "nickname": "Jetblue" }, { "departure_month": "2005-09-01T00:00:00.000Z", "flight_count": 504, "nickname": "Continental Express" }, { "departure_month": "2005-09-01T00:00:00.000Z", "flight_count": 652, "nickname": "USAir" }, { "departure_month": "2005-09-01T00:00:00.000Z", "flight_count": 415, "nickname": "American Eagle" }, { "departure_month": "2005-09-01T00:00:00.000Z", "flight_count": 1466, "nickname": "Southwest" }, { "departure_month": "2005-09-01T00:00:00.000Z", "flight_count": 492, "nickname": "American" }, { "departure_month": "2005-09-01T00:00:00.000Z", "flight_count": 98, "nickname": "Continental" }, { "departure_month": "2005-09-01T00:00:00.000Z", "flight_count": 456, "nickname": "Atlantic Southeast" }, { "departure_month": "2005-09-01T00:00:00.000Z", "flight_count": 537, "nickname": "United" }, { "departure_month": "2005-09-01T00:00:00.000Z", "flight_count": 113, "nickname": "Alaska" }, { "departure_month": "2005-09-01T00:00:00.000Z", "flight_count": 482, "nickname": "Northwest" }, { "departure_month": "2005-09-01T00:00:00.000Z", "flight_count": 167, "nickname": "Comair" }, { "departure_month": "2005-09-01T00:00:00.000Z", "flight_count": 91, "nickname": "ATA" }, { "departure_month": "2005-09-01T00:00:00.000Z", "flight_count": 167, "nickname": "Jetblue" }, { "departure_month": "2005-09-01T00:00:00.000Z", "flight_count": 147, "nickname": "America West" }, { "departure_month": "2005-09-01T00:00:00.000Z", "flight_count": 313, "nickname": "Delta" }, { "departure_month": "2005-08-01T00:00:00.000Z", "flight_count": 538, "nickname": "Continental Express" }, { "departure_month": "2005-08-01T00:00:00.000Z", "flight_count": 723, "nickname": "USAir" }, { "departure_month": "2005-08-01T00:00:00.000Z", "flight_count": 358, "nickname": "American Eagle" }, { "departure_month": "2005-08-01T00:00:00.000Z", "flight_count": 1582, "nickname": "Southwest" }, { "departure_month": "2005-08-01T00:00:00.000Z", "flight_count": 529, "nickname": "American" }, { "departure_month": "2005-08-01T00:00:00.000Z", "flight_count": 131, "nickname": "America West" }, { "departure_month": "2005-08-01T00:00:00.000Z", "flight_count": 578, "nickname": "United" }, { "departure_month": "2005-08-01T00:00:00.000Z", "flight_count": 465, "nickname": "Northwest" }, { "departure_month": "2005-08-01T00:00:00.000Z", "flight_count": 112, "nickname": "Continental" }, { "departure_month": "2005-08-01T00:00:00.000Z", "flight_count": 207, "nickname": "Comair" }, { "departure_month": "2005-08-01T00:00:00.000Z", "flight_count": 521, "nickname": "Atlantic Southeast" }, { "departure_month": "2005-08-01T00:00:00.000Z", "flight_count": 325, "nickname": "Delta" }, { "departure_month": "2005-08-01T00:00:00.000Z", "flight_count": 93, "nickname": "Alaska" }, { "departure_month": "2005-08-01T00:00:00.000Z", "flight_count": 118, "nickname": "Jetblue" }, { "departure_month": "2005-08-01T00:00:00.000Z", "flight_count": 135, "nickname": "ATA" }, { "departure_month": "2005-07-01T00:00:00.000Z", "flight_count": 580, "nickname": "Continental Express" }, { "departure_month": "2005-07-01T00:00:00.000Z", "flight_count": 686, "nickname": "USAir" }, { "departure_month": "2005-07-01T00:00:00.000Z", "flight_count": 332, "nickname": "American Eagle" }, { "departure_month": "2005-07-01T00:00:00.000Z", "flight_count": 1564, "nickname": "Southwest" }, { "departure_month": "2005-07-01T00:00:00.000Z", "flight_count": 493, "nickname": "American" }, { "departure_month": "2005-07-01T00:00:00.000Z", "flight_count": 584, "nickname": "United" }, { "departure_month": "2005-07-01T00:00:00.000Z", "flight_count": 108, "nickname": "Continental" }, { "departure_month": "2005-07-01T00:00:00.000Z", "flight_count": 484, "nickname": "Atlantic Southeast" }, { "departure_month": "2005-07-01T00:00:00.000Z", "flight_count": 457, "nickname": "Northwest" }, { "departure_month": "2005-07-01T00:00:00.000Z", "flight_count": 372, "nickname": "Delta" }, { "departure_month": "2005-07-01T00:00:00.000Z", "flight_count": 193, "nickname": "Comair" }, { "departure_month": "2005-07-01T00:00:00.000Z", "flight_count": 124, "nickname": "Jetblue" }, { "departure_month": "2005-07-01T00:00:00.000Z", "flight_count": 123, "nickname": "ATA" }, { "departure_month": "2005-07-01T00:00:00.000Z", "flight_count": 126, "nickname": "Alaska" }, { "departure_month": "2005-07-01T00:00:00.000Z", "flight_count": 1, "nickname": "America West" }, { "departure_month": "2005-06-01T00:00:00.000Z", "flight_count": 645, "nickname": "USAir" }, { "departure_month": "2005-06-01T00:00:00.000Z", "flight_count": 603, "nickname": "Continental Express" }, { "departure_month": "2005-06-01T00:00:00.000Z", "flight_count": 374, "nickname": "American Eagle" }, { "departure_month": "2005-06-01T00:00:00.000Z", "flight_count": 1383, "nickname": "Southwest" }, { "departure_month": "2005-06-01T00:00:00.000Z", "flight_count": 466, "nickname": "American" }, { "departure_month": "2005-06-01T00:00:00.000Z", "flight_count": 150, "nickname": "America West" }, { "departure_month": "2005-06-01T00:00:00.000Z", "flight_count": 98, "nickname": "Continental" }, { "departure_month": "2005-06-01T00:00:00.000Z", "flight_count": 201, "nickname": "Comair" }, { "departure_month": "2005-06-01T00:00:00.000Z", "flight_count": 442, "nickname": "Atlantic Southeast" }, { "departure_month": "2005-06-01T00:00:00.000Z", "flight_count": 398, "nickname": "Northwest" }, { "departure_month": "2005-06-01T00:00:00.000Z", "flight_count": 570, "nickname": "United" }, { "departure_month": "2005-06-01T00:00:00.000Z", "flight_count": 400, "nickname": "Delta" }, { "departure_month": "2005-06-01T00:00:00.000Z", "flight_count": 132, "nickname": "Alaska" }, { "departure_month": "2005-06-01T00:00:00.000Z", "flight_count": 123, "nickname": "Jetblue" }, { "departure_month": "2005-06-01T00:00:00.000Z", "flight_count": 133, "nickname": "ATA" }, { "departure_month": "2005-05-01T00:00:00.000Z", "flight_count": 663, "nickname": "USAir" }, { "departure_month": "2005-05-01T00:00:00.000Z", "flight_count": 535, "nickname": "Continental Express" }, { "departure_month": "2005-05-01T00:00:00.000Z", "flight_count": 330, "nickname": "American Eagle" }, { "departure_month": "2005-05-01T00:00:00.000Z", "flight_count": 1384, "nickname": "Southwest" }, { "departure_month": "2005-05-01T00:00:00.000Z", "flight_count": 507, "nickname": "American" }, { "departure_month": "2005-05-01T00:00:00.000Z", "flight_count": 129, "nickname": "America West" }, { "departure_month": "2005-05-01T00:00:00.000Z", "flight_count": 451, "nickname": "Northwest" }, { "departure_month": "2005-05-01T00:00:00.000Z", "flight_count": 396, "nickname": "Delta" }, { "departure_month": "2005-05-01T00:00:00.000Z", "flight_count": 106, "nickname": "Continental" }, { "departure_month": "2005-05-01T00:00:00.000Z", "flight_count": 17, "nickname": "Alaska" }, { "departure_month": "2005-05-01T00:00:00.000Z", "flight_count": 134, "nickname": "Jetblue" }, { "departure_month": "2005-05-01T00:00:00.000Z", "flight_count": 202, "nickname": "Comair" }, { "departure_month": "2005-05-01T00:00:00.000Z", "flight_count": 452, "nickname": "Atlantic Southeast" }, { "departure_month": "2005-05-01T00:00:00.000Z", "flight_count": 622, "nickname": "United" }, { "departure_month": "2005-05-01T00:00:00.000Z", "flight_count": 136, "nickname": "ATA" }, { "departure_month": "2005-04-01T00:00:00.000Z", "flight_count": 584, "nickname": "Continental Express" }, { "departure_month": "2005-04-01T00:00:00.000Z", "flight_count": 686, "nickname": "USAir" }, { "departure_month": "2005-04-01T00:00:00.000Z", "flight_count": 171, "nickname": "Comair" }, { "departure_month": "2005-04-01T00:00:00.000Z", "flight_count": 326, "nickname": "American Eagle" }, { "departure_month": "2005-04-01T00:00:00.000Z", "flight_count": 1432, "nickname": "Southwest" }, { "departure_month": "2005-04-01T00:00:00.000Z", "flight_count": 491, "nickname": "American" }, { "departure_month": "2005-04-01T00:00:00.000Z", "flight_count": 139, "nickname": "America West" }, { "departure_month": "2005-04-01T00:00:00.000Z", "flight_count": 522, "nickname": "Northwest" }, { "departure_month": "2005-04-01T00:00:00.000Z", "flight_count": 392, "nickname": "Delta" }, { "departure_month": "2005-04-01T00:00:00.000Z", "flight_count": 369, "nickname": "Atlantic Southeast" }, { "departure_month": "2005-04-01T00:00:00.000Z", "flight_count": 98, "nickname": "Alaska" }, { "departure_month": "2005-04-01T00:00:00.000Z", "flight_count": 491, "nickname": "United" }, { "departure_month": "2005-04-01T00:00:00.000Z", "flight_count": 103, "nickname": "Continental" }, { "departure_month": "2005-04-01T00:00:00.000Z", "flight_count": 104, "nickname": "ATA" }, { "departure_month": "2005-04-01T00:00:00.000Z", "flight_count": 135, "nickname": "Jetblue" }, { "departure_month": "2005-03-01T00:00:00.000Z", "flight_count": 530, "nickname": "Continental Express" }, { "departure_month": "2005-03-01T00:00:00.000Z", "flight_count": 156, "nickname": "Comair" }, { "departure_month": "2005-03-01T00:00:00.000Z", "flight_count": 347, "nickname": "American Eagle" }, { "departure_month": "2005-03-01T00:00:00.000Z", "flight_count": 1439, "nickname": "Southwest" }, { "departure_month": "2005-03-01T00:00:00.000Z", "flight_count": 464, "nickname": "American" }, { "departure_month": "2005-03-01T00:00:00.000Z", "flight_count": 137, "nickname": "America West" }, { "departure_month": "2005-03-01T00:00:00.000Z", "flight_count": 584, "nickname": "United" }, { "departure_month": "2005-03-01T00:00:00.000Z", "flight_count": 261, "nickname": "Atlantic Southeast" }, { "departure_month": "2005-03-01T00:00:00.000Z", "flight_count": 667, "nickname": "USAir" }, { "departure_month": "2005-03-01T00:00:00.000Z", "flight_count": 270, "nickname": "Delta" }, { "departure_month": "2005-03-01T00:00:00.000Z", "flight_count": 141, "nickname": "Alaska" }, { "departure_month": "2005-03-01T00:00:00.000Z", "flight_count": 450, "nickname": "Northwest" }, { "departure_month": "2005-03-01T00:00:00.000Z", "flight_count": 105, "nickname": "Continental" }, { "departure_month": "2005-03-01T00:00:00.000Z", "flight_count": 98, "nickname": "ATA" }, { "departure_month": "2005-03-01T00:00:00.000Z", "flight_count": 83, "nickname": "Jetblue" }, { "departure_month": "2005-02-01T00:00:00.000Z", "flight_count": 483, "nickname": "Continental Express" }, { "departure_month": "2005-02-01T00:00:00.000Z", "flight_count": 288, "nickname": "American Eagle" }, { "departure_month": "2005-02-01T00:00:00.000Z", "flight_count": 1281, "nickname": "Southwest" }, { "departure_month": "2005-02-01T00:00:00.000Z", "flight_count": 467, "nickname": "American" }, { "departure_month": "2005-02-01T00:00:00.000Z", "flight_count": 125, "nickname": "America West" }, { "departure_month": "2005-02-01T00:00:00.000Z", "flight_count": 473, "nickname": "Northwest" }, { "departure_month": "2005-02-01T00:00:00.000Z", "flight_count": 175, "nickname": "Comair" }, { "departure_month": "2005-02-01T00:00:00.000Z", "flight_count": 417, "nickname": "Atlantic Southeast" }, { "departure_month": "2005-02-01T00:00:00.000Z", "flight_count": 578, "nickname": "USAir" }, { "departure_month": "2005-02-01T00:00:00.000Z", "flight_count": 125, "nickname": "Alaska" }, { "departure_month": "2005-02-01T00:00:00.000Z", "flight_count": 543, "nickname": "United" }, { "departure_month": "2005-02-01T00:00:00.000Z", "flight_count": 420, "nickname": "Delta" }, { "departure_month": "2005-02-01T00:00:00.000Z", "flight_count": 83, "nickname": "Continental" }, { "departure_month": "2005-02-01T00:00:00.000Z", "flight_count": 144, "nickname": "ATA" }, { "departure_month": "2005-02-01T00:00:00.000Z", "flight_count": 105, "nickname": "Jetblue" }, { "departure_month": "2005-01-01T00:00:00.000Z", "flight_count": 692, "nickname": "USAir" }, { "departure_month": "2005-01-01T00:00:00.000Z", "flight_count": 520, "nickname": "Continental Express" }, { "departure_month": "2005-01-01T00:00:00.000Z", "flight_count": 349, "nickname": "American Eagle" }, { "departure_month": "2005-01-01T00:00:00.000Z", "flight_count": 1421, "nickname": "Southwest" }, { "departure_month": "2005-01-01T00:00:00.000Z", "flight_count": 399, "nickname": "American" }, { "departure_month": "2005-01-01T00:00:00.000Z", "flight_count": 143, "nickname": "America West" }, { "departure_month": "2005-01-01T00:00:00.000Z", "flight_count": 539, "nickname": "United" }, { "departure_month": "2005-01-01T00:00:00.000Z", "flight_count": 398, "nickname": "Atlantic Southeast" }, { "departure_month": "2005-01-01T00:00:00.000Z", "flight_count": 416, "nickname": "Delta" }, { "departure_month": "2005-01-01T00:00:00.000Z", "flight_count": 110, "nickname": "Alaska" }, { "departure_month": "2005-01-01T00:00:00.000Z", "flight_count": 131, "nickname": "Comair" }, { "departure_month": "2005-01-01T00:00:00.000Z", "flight_count": 111, "nickname": "ATA" }, { "departure_month": "2005-01-01T00:00:00.000Z", "flight_count": 549, "nickname": "Northwest" }, { "departure_month": "2005-01-01T00:00:00.000Z", "flight_count": 93, "nickname": "Continental" }, { "departure_month": "2005-01-01T00:00:00.000Z", "flight_count": 126, "nickname": "Jetblue" }, { "departure_month": "2004-12-01T00:00:00.000Z", "flight_count": 632, "nickname": "USAir" }, { "departure_month": "2004-12-01T00:00:00.000Z", "flight_count": 522, "nickname": "Continental Express" }, { "departure_month": "2004-12-01T00:00:00.000Z", "flight_count": 322, "nickname": "American Eagle" }, { "departure_month": "2004-12-01T00:00:00.000Z", "flight_count": 1408, "nickname": "Southwest" }, { "departure_month": "2004-12-01T00:00:00.000Z", "flight_count": 481, "nickname": "American" }, { "departure_month": "2004-12-01T00:00:00.000Z", "flight_count": 139, "nickname": "America West" }, { "departure_month": "2004-12-01T00:00:00.000Z", "flight_count": 106, "nickname": "Continental" }, { "departure_month": "2004-12-01T00:00:00.000Z", "flight_count": 524, "nickname": "Delta" }, { "departure_month": "2004-12-01T00:00:00.000Z", "flight_count": 394, "nickname": "Atlantic Southeast" }, { "departure_month": "2004-12-01T00:00:00.000Z", "flight_count": 184, "nickname": "Comair" }, { "departure_month": "2004-12-01T00:00:00.000Z", "flight_count": 557, "nickname": "United" }, { "departure_month": "2004-12-01T00:00:00.000Z", "flight_count": 527, "nickname": "Northwest" }, { "departure_month": "2004-12-01T00:00:00.000Z", "flight_count": 157, "nickname": "Alaska" }, { "departure_month": "2004-12-01T00:00:00.000Z", "flight_count": 121, "nickname": "Jetblue" }, { "departure_month": "2004-12-01T00:00:00.000Z", "flight_count": 128, "nickname": "ATA" }, { "departure_month": "2004-11-01T00:00:00.000Z", "flight_count": 641, "nickname": "USAir" }, { "departure_month": "2004-11-01T00:00:00.000Z", "flight_count": 519, "nickname": "Continental Express" }, { "departure_month": "2004-11-01T00:00:00.000Z", "flight_count": 209, "nickname": "Comair" }, { "departure_month": "2004-11-01T00:00:00.000Z", "flight_count": 266, "nickname": "American Eagle" }, { "departure_month": "2004-11-01T00:00:00.000Z", "flight_count": 1370, "nickname": "Southwest" }, { "departure_month": "2004-11-01T00:00:00.000Z", "flight_count": 499, "nickname": "American" }, { "departure_month": "2004-11-01T00:00:00.000Z", "flight_count": 145, "nickname": "America West" }, { "departure_month": "2004-11-01T00:00:00.000Z", "flight_count": 583, "nickname": "United" }, { "departure_month": "2004-11-01T00:00:00.000Z", "flight_count": 57, "nickname": "Continental" }, { "departure_month": "2004-11-01T00:00:00.000Z", "flight_count": 470, "nickname": "Delta" }, { "departure_month": "2004-11-01T00:00:00.000Z", "flight_count": 428, "nickname": "Atlantic Southeast" }, { "departure_month": "2004-11-01T00:00:00.000Z", "flight_count": 543, "nickname": "Northwest" }, { "departure_month": "2004-11-01T00:00:00.000Z", "flight_count": 119, "nickname": "ATA" }, { "departure_month": "2004-11-01T00:00:00.000Z", "flight_count": 124, "nickname": "Alaska" }, { "departure_month": "2004-11-01T00:00:00.000Z", "flight_count": 111, "nickname": "Jetblue" }, { "departure_month": "2004-10-01T00:00:00.000Z", "flight_count": 680, "nickname": "USAir" }, { "departure_month": "2004-10-01T00:00:00.000Z", "flight_count": 536, "nickname": "Continental Express" }, { "departure_month": "2004-10-01T00:00:00.000Z", "flight_count": 198, "nickname": "Comair" }, { "departure_month": "2004-10-01T00:00:00.000Z", "flight_count": 335, "nickname": "American Eagle" }, { "departure_month": "2004-10-01T00:00:00.000Z", "flight_count": 483, "nickname": "American" }, { "departure_month": "2004-10-01T00:00:00.000Z", "flight_count": 150, "nickname": "America West" }, { "departure_month": "2004-10-01T00:00:00.000Z", "flight_count": 614, "nickname": "United" }, { "departure_month": "2004-10-01T00:00:00.000Z", "flight_count": 66, "nickname": "Continental" }, { "departure_month": "2004-10-01T00:00:00.000Z", "flight_count": 405, "nickname": "Atlantic Southeast" }, { "departure_month": "2004-10-01T00:00:00.000Z", "flight_count": 130, "nickname": "Alaska" }, { "departure_month": "2004-10-01T00:00:00.000Z", "flight_count": 140, "nickname": "Jetblue" }, { "departure_month": "2004-10-01T00:00:00.000Z", "flight_count": 482, "nickname": "Delta" }, { "departure_month": "2004-10-01T00:00:00.000Z", "flight_count": 97, "nickname": "ATA" }, { "departure_month": "2004-10-01T00:00:00.000Z", "flight_count": 1421, "nickname": "Southwest" }, { "departure_month": "2004-10-01T00:00:00.000Z", "flight_count": 491, "nickname": "Northwest" }, { "departure_month": "2004-09-01T00:00:00.000Z", "flight_count": 557, "nickname": "USAir" }, { "departure_month": "2004-09-01T00:00:00.000Z", "flight_count": 447, "nickname": "Continental Express" }, { "departure_month": "2004-09-01T00:00:00.000Z", "flight_count": 231, "nickname": "American Eagle" }, { "departure_month": "2004-09-01T00:00:00.000Z", "flight_count": 1305, "nickname": "Southwest" }, { "departure_month": "2004-09-01T00:00:00.000Z", "flight_count": 386, "nickname": "American" }, { "departure_month": "2004-09-01T00:00:00.000Z", "flight_count": 150, "nickname": "America West" }, { "departure_month": "2004-09-01T00:00:00.000Z", "flight_count": 607, "nickname": "United" }, { "departure_month": "2004-09-01T00:00:00.000Z", "flight_count": 78, "nickname": "Continental" }, { "departure_month": "2004-09-01T00:00:00.000Z", "flight_count": 195, "nickname": "Comair" }, { "departure_month": "2004-09-01T00:00:00.000Z", "flight_count": 454, "nickname": "Delta" }, { "departure_month": "2004-09-01T00:00:00.000Z", "flight_count": 137, "nickname": "Alaska" }, { "departure_month": "2004-09-01T00:00:00.000Z", "flight_count": 491, "nickname": "Northwest" }, { "departure_month": "2004-09-01T00:00:00.000Z", "flight_count": 116, "nickname": "Jetblue" }, { "departure_month": "2004-09-01T00:00:00.000Z", "flight_count": 121, "nickname": "ATA" }, { "departure_month": "2004-09-01T00:00:00.000Z", "flight_count": 414, "nickname": "Atlantic Southeast" }, { "departure_month": "2004-08-01T00:00:00.000Z", "flight_count": 641, "nickname": "USAir" }, { "departure_month": "2004-08-01T00:00:00.000Z", "flight_count": 269, "nickname": "American Eagle" }, { "departure_month": "2004-08-01T00:00:00.000Z", "flight_count": 1154, "nickname": "Southwest" }, { "departure_month": "2004-08-01T00:00:00.000Z", "flight_count": 536, "nickname": "American" }, { "departure_month": "2004-08-01T00:00:00.000Z", "flight_count": 535, "nickname": "Continental Express" }, { "departure_month": "2004-08-01T00:00:00.000Z", "flight_count": 84, "nickname": "Continental" }, { "departure_month": "2004-08-01T00:00:00.000Z", "flight_count": 153, "nickname": "Comair" }, { "departure_month": "2004-08-01T00:00:00.000Z", "flight_count": 453, "nickname": "Atlantic Southeast" }, { "departure_month": "2004-08-01T00:00:00.000Z", "flight_count": 131, "nickname": "Alaska" }, { "departure_month": "2004-08-01T00:00:00.000Z", "flight_count": 600, "nickname": "United" }, { "departure_month": "2004-08-01T00:00:00.000Z", "flight_count": 127, "nickname": "ATA" }, { "departure_month": "2004-08-01T00:00:00.000Z", "flight_count": 130, "nickname": "Jetblue" }, { "departure_month": "2004-08-01T00:00:00.000Z", "flight_count": 145, "nickname": "America West" }, { "departure_month": "2004-08-01T00:00:00.000Z", "flight_count": 533, "nickname": "Northwest" }, { "departure_month": "2004-08-01T00:00:00.000Z", "flight_count": 502, "nickname": "Delta" }, { "departure_month": "2004-07-01T00:00:00.000Z", "flight_count": 505, "nickname": "USAir" }, { "departure_month": "2004-07-01T00:00:00.000Z", "flight_count": 563, "nickname": "Continental Express" }, { "departure_month": "2004-07-01T00:00:00.000Z", "flight_count": 200, "nickname": "Comair" }, { "departure_month": "2004-07-01T00:00:00.000Z", "flight_count": 990, "nickname": "Southwest" }, { "departure_month": "2004-07-01T00:00:00.000Z", "flight_count": 463, "nickname": "American" }, { "departure_month": "2004-07-01T00:00:00.000Z", "flight_count": 74, "nickname": "Continental" }, { "departure_month": "2004-07-01T00:00:00.000Z", "flight_count": 423, "nickname": "Atlantic Southeast" }, { "departure_month": "2004-07-01T00:00:00.000Z", "flight_count": 511, "nickname": "Delta" }, { "departure_month": "2004-07-01T00:00:00.000Z", "flight_count": 535, "nickname": "Northwest" }, { "departure_month": "2004-07-01T00:00:00.000Z", "flight_count": 144, "nickname": "Alaska" }, { "departure_month": "2004-07-01T00:00:00.000Z", "flight_count": 578, "nickname": "United" }, { "departure_month": "2004-07-01T00:00:00.000Z", "flight_count": 154, "nickname": "America West" }, { "departure_month": "2004-07-01T00:00:00.000Z", "flight_count": 114, "nickname": "Jetblue" }, { "departure_month": "2004-07-01T00:00:00.000Z", "flight_count": 126, "nickname": "ATA" }, { "departure_month": "2004-07-01T00:00:00.000Z", "flight_count": 395, "nickname": "American Eagle" }, { "departure_month": "2004-06-01T00:00:00.000Z", "flight_count": 469, "nickname": "Continental Express" }, { "departure_month": "2004-06-01T00:00:00.000Z", "flight_count": 371, "nickname": "USAir" }, { "departure_month": "2004-06-01T00:00:00.000Z", "flight_count": 1088, "nickname": "Southwest" }, { "departure_month": "2004-06-01T00:00:00.000Z", "flight_count": 486, "nickname": "American" }, { "departure_month": "2004-06-01T00:00:00.000Z", "flight_count": 155, "nickname": "America West" }, { "departure_month": "2004-06-01T00:00:00.000Z", "flight_count": 601, "nickname": "United" }, { "departure_month": "2004-06-01T00:00:00.000Z", "flight_count": 101, "nickname": "Continental" }, { "departure_month": "2004-06-01T00:00:00.000Z", "flight_count": 397, "nickname": "Atlantic Southeast" }, { "departure_month": "2004-06-01T00:00:00.000Z", "flight_count": 122, "nickname": "Alaska" }, { "departure_month": "2004-06-01T00:00:00.000Z", "flight_count": 184, "nickname": "Comair" }, { "departure_month": "2004-06-01T00:00:00.000Z", "flight_count": 130, "nickname": "Jetblue" }, { "departure_month": "2004-06-01T00:00:00.000Z", "flight_count": 92, "nickname": "ATA" }, { "departure_month": "2004-06-01T00:00:00.000Z", "flight_count": 366, "nickname": "American Eagle" }, { "departure_month": "2004-06-01T00:00:00.000Z", "flight_count": 510, "nickname": "Delta" }, { "departure_month": "2004-06-01T00:00:00.000Z", "flight_count": 550, "nickname": "Northwest" }, { "departure_month": "2004-05-01T00:00:00.000Z", "flight_count": 348, "nickname": "Continental Express" }, { "departure_month": "2004-05-01T00:00:00.000Z", "flight_count": 221, "nickname": "Comair" }, { "departure_month": "2004-05-01T00:00:00.000Z", "flight_count": 290, "nickname": "USAir" }, { "departure_month": "2004-05-01T00:00:00.000Z", "flight_count": 309, "nickname": "American Eagle" }, { "departure_month": "2004-05-01T00:00:00.000Z", "flight_count": 1225, "nickname": "Southwest" }, { "departure_month": "2004-05-01T00:00:00.000Z", "flight_count": 152, "nickname": "America West" }, { "departure_month": "2004-05-01T00:00:00.000Z", "flight_count": 104, "nickname": "Continental" }, { "departure_month": "2004-05-01T00:00:00.000Z", "flight_count": 504, "nickname": "Delta" }, { "departure_month": "2004-05-01T00:00:00.000Z", "flight_count": 558, "nickname": "Northwest" }, { "departure_month": "2004-05-01T00:00:00.000Z", "flight_count": 423, "nickname": "Atlantic Southeast" }, { "departure_month": "2004-05-01T00:00:00.000Z", "flight_count": 69, "nickname": "Alaska" }, { "departure_month": "2004-05-01T00:00:00.000Z", "flight_count": 123, "nickname": "Jetblue" }, { "departure_month": "2004-05-01T00:00:00.000Z", "flight_count": 532, "nickname": "American" }, { "departure_month": "2004-05-01T00:00:00.000Z", "flight_count": 623, "nickname": "United" }, { "departure_month": "2004-05-01T00:00:00.000Z", "flight_count": 128, "nickname": "ATA" }, { "departure_month": "2004-04-01T00:00:00.000Z", "flight_count": 439, "nickname": "Continental Express" }, { "departure_month": "2004-04-01T00:00:00.000Z", "flight_count": 185, "nickname": "Comair" }, { "departure_month": "2004-04-01T00:00:00.000Z", "flight_count": 385, "nickname": "American Eagle" }, { "departure_month": "2004-04-01T00:00:00.000Z", "flight_count": 512, "nickname": "American" }, { "departure_month": "2004-04-01T00:00:00.000Z", "flight_count": 108, "nickname": "Continental" }, { "departure_month": "2004-04-01T00:00:00.000Z", "flight_count": 458, "nickname": "Delta" }, { "departure_month": "2004-04-01T00:00:00.000Z", "flight_count": 444, "nickname": "Atlantic Southeast" }, { "departure_month": "2004-04-01T00:00:00.000Z", "flight_count": 229, "nickname": "USAir" }, { "departure_month": "2004-04-01T00:00:00.000Z", "flight_count": 493, "nickname": "Northwest" }, { "departure_month": "2004-04-01T00:00:00.000Z", "flight_count": 114, "nickname": "Alaska" }, { "departure_month": "2004-04-01T00:00:00.000Z", "flight_count": 538, "nickname": "United" }, { "departure_month": "2004-04-01T00:00:00.000Z", "flight_count": 132, "nickname": "Jetblue" }, { "departure_month": "2004-04-01T00:00:00.000Z", "flight_count": 107, "nickname": "ATA" }, { "departure_month": "2004-04-01T00:00:00.000Z", "flight_count": 28, "nickname": "America West" }, { "departure_month": "2004-04-01T00:00:00.000Z", "flight_count": 1213, "nickname": "Southwest" }, { "departure_month": "2004-03-01T00:00:00.000Z", "flight_count": 419, "nickname": "Continental Express" }, { "departure_month": "2004-03-01T00:00:00.000Z", "flight_count": 346, "nickname": "American Eagle" }, { "departure_month": "2004-03-01T00:00:00.000Z", "flight_count": 1197, "nickname": "Southwest" }, { "departure_month": "2004-03-01T00:00:00.000Z", "flight_count": 426, "nickname": "American" }, { "departure_month": "2004-03-01T00:00:00.000Z", "flight_count": 589, "nickname": "United" }, { "departure_month": "2004-03-01T00:00:00.000Z", "flight_count": 551, "nickname": "Northwest" }, { "departure_month": "2004-03-01T00:00:00.000Z", "flight_count": 90, "nickname": "Continental" }, { "departure_month": "2004-03-01T00:00:00.000Z", "flight_count": 383, "nickname": "Atlantic Southeast" }, { "departure_month": "2004-03-01T00:00:00.000Z", "flight_count": 282, "nickname": "USAir" }, { "departure_month": "2004-03-01T00:00:00.000Z", "flight_count": 109, "nickname": "Alaska" }, { "departure_month": "2004-03-01T00:00:00.000Z", "flight_count": 111, "nickname": "America West" }, { "departure_month": "2004-03-01T00:00:00.000Z", "flight_count": 134, "nickname": "Jetblue" }, { "departure_month": "2004-03-01T00:00:00.000Z", "flight_count": 117, "nickname": "ATA" }, { "departure_month": "2004-03-01T00:00:00.000Z", "flight_count": 174, "nickname": "Comair" }, { "departure_month": "2004-03-01T00:00:00.000Z", "flight_count": 535, "nickname": "Delta" }, { "departure_month": "2004-02-01T00:00:00.000Z", "flight_count": 408, "nickname": "Continental Express" }, { "departure_month": "2004-02-01T00:00:00.000Z", "flight_count": 198, "nickname": "Comair" }, { "departure_month": "2004-02-01T00:00:00.000Z", "flight_count": 1120, "nickname": "Southwest" }, { "departure_month": "2004-02-01T00:00:00.000Z", "flight_count": 469, "nickname": "American" }, { "departure_month": "2004-02-01T00:00:00.000Z", "flight_count": 158, "nickname": "America West" }, { "departure_month": "2004-02-01T00:00:00.000Z", "flight_count": 524, "nickname": "Northwest" }, { "departure_month": "2004-02-01T00:00:00.000Z", "flight_count": 401, "nickname": "Atlantic Southeast" }, { "departure_month": "2004-02-01T00:00:00.000Z", "flight_count": 265, "nickname": "USAir" }, { "departure_month": "2004-02-01T00:00:00.000Z", "flight_count": 491, "nickname": "United" }, { "departure_month": "2004-02-01T00:00:00.000Z", "flight_count": 476, "nickname": "Delta" }, { "departure_month": "2004-02-01T00:00:00.000Z", "flight_count": 81, "nickname": "Continental" }, { "departure_month": "2004-02-01T00:00:00.000Z", "flight_count": 95, "nickname": "Jetblue" }, { "departure_month": "2004-02-01T00:00:00.000Z", "flight_count": 100, "nickname": "ATA" }, { "departure_month": "2004-02-01T00:00:00.000Z", "flight_count": 334, "nickname": "American Eagle" }, { "departure_month": "2004-02-01T00:00:00.000Z", "flight_count": 103, "nickname": "Alaska" }, { "departure_month": "2004-01-01T00:00:00.000Z", "flight_count": 399, "nickname": "Continental Express" }, { "departure_month": "2004-01-01T00:00:00.000Z", "flight_count": 190, "nickname": "Comair" }, { "departure_month": "2004-01-01T00:00:00.000Z", "flight_count": 366, "nickname": "American Eagle" }, { "departure_month": "2004-01-01T00:00:00.000Z", "flight_count": 1149, "nickname": "Southwest" }, { "departure_month": "2004-01-01T00:00:00.000Z", "flight_count": 331, "nickname": "American" }, { "departure_month": "2004-01-01T00:00:00.000Z", "flight_count": 148, "nickname": "America West" }, { "departure_month": "2004-01-01T00:00:00.000Z", "flight_count": 510, "nickname": "Northwest" }, { "departure_month": "2004-01-01T00:00:00.000Z", "flight_count": 96, "nickname": "Continental" }, { "departure_month": "2004-01-01T00:00:00.000Z", "flight_count": 295, "nickname": "USAir" }, { "departure_month": "2004-01-01T00:00:00.000Z", "flight_count": 436, "nickname": "United" }, { "departure_month": "2004-01-01T00:00:00.000Z", "flight_count": 117, "nickname": "Alaska" }, { "departure_month": "2004-01-01T00:00:00.000Z", "flight_count": 503, "nickname": "Delta" }, { "departure_month": "2004-01-01T00:00:00.000Z", "flight_count": 124, "nickname": "ATA" }, { "departure_month": "2004-01-01T00:00:00.000Z", "flight_count": 332, "nickname": "Atlantic Southeast" }, { "departure_month": "2004-01-01T00:00:00.000Z", "flight_count": 128, "nickname": "Jetblue" }, { "departure_month": "2003-12-01T00:00:00.000Z", "flight_count": 347, "nickname": "Continental Express" }, { "departure_month": "2003-12-01T00:00:00.000Z", "flight_count": 329, "nickname": "American Eagle" }, { "departure_month": "2003-12-01T00:00:00.000Z", "flight_count": 1205, "nickname": "Southwest" }, { "departure_month": "2003-12-01T00:00:00.000Z", "flight_count": 434, "nickname": "American" }, { "departure_month": "2003-12-01T00:00:00.000Z", "flight_count": 115, "nickname": "America West" }, { "departure_month": "2003-12-01T00:00:00.000Z", "flight_count": 88, "nickname": "Continental" }, { "departure_month": "2003-12-01T00:00:00.000Z", "flight_count": 441, "nickname": "Atlantic Southeast" }, { "departure_month": "2003-12-01T00:00:00.000Z", "flight_count": 570, "nickname": "United" }, { "departure_month": "2003-12-01T00:00:00.000Z", "flight_count": 126, "nickname": "Alaska" }, { "departure_month": "2003-12-01T00:00:00.000Z", "flight_count": 489, "nickname": "Delta" }, { "departure_month": "2003-12-01T00:00:00.000Z", "flight_count": 118, "nickname": "Jetblue" }, { "departure_month": "2003-12-01T00:00:00.000Z", "flight_count": 53, "nickname": "ATA" }, { "departure_month": "2003-12-01T00:00:00.000Z", "flight_count": 525, "nickname": "Northwest" }, { "departure_month": "2003-12-01T00:00:00.000Z", "flight_count": 294, "nickname": "USAir" }, { "departure_month": "2003-11-01T00:00:00.000Z", "flight_count": 368, "nickname": "Continental Express" }, { "departure_month": "2003-11-01T00:00:00.000Z", "flight_count": 83, "nickname": "American Eagle" }, { "departure_month": "2003-11-01T00:00:00.000Z", "flight_count": 464, "nickname": "American" }, { "departure_month": "2003-11-01T00:00:00.000Z", "flight_count": 100, "nickname": "Continental" }, { "departure_month": "2003-11-01T00:00:00.000Z", "flight_count": 419, "nickname": "Atlantic Southeast" }, { "departure_month": "2003-11-01T00:00:00.000Z", "flight_count": 296, "nickname": "USAir" }, { "departure_month": "2003-11-01T00:00:00.000Z", "flight_count": 528, "nickname": "Northwest" }, { "departure_month": "2003-11-01T00:00:00.000Z", "flight_count": 123, "nickname": "Alaska" }, { "departure_month": "2003-11-01T00:00:00.000Z", "flight_count": 508, "nickname": "Delta" }, { "departure_month": "2003-11-01T00:00:00.000Z", "flight_count": 458, "nickname": "United" }, { "departure_month": "2003-11-01T00:00:00.000Z", "flight_count": 122, "nickname": "Jetblue" }, { "departure_month": "2003-11-01T00:00:00.000Z", "flight_count": 123, "nickname": "America West" }, { "departure_month": "2003-11-01T00:00:00.000Z", "flight_count": 1137, "nickname": "Southwest" }, { "departure_month": "2003-10-01T00:00:00.000Z", "flight_count": 406, "nickname": "Continental Express" }, { "departure_month": "2003-10-01T00:00:00.000Z", "flight_count": 1160, "nickname": "Southwest" }, { "departure_month": "2003-10-01T00:00:00.000Z", "flight_count": 138, "nickname": "America West" }, { "departure_month": "2003-10-01T00:00:00.000Z", "flight_count": 470, "nickname": "United" }, { "departure_month": "2003-10-01T00:00:00.000Z", "flight_count": 487, "nickname": "American" }, { "departure_month": "2003-10-01T00:00:00.000Z", "flight_count": 109, "nickname": "Continental" }, { "departure_month": "2003-10-01T00:00:00.000Z", "flight_count": 429, "nickname": "Delta" }, { "departure_month": "2003-10-01T00:00:00.000Z", "flight_count": 450, "nickname": "Atlantic Southeast" }, { "departure_month": "2003-10-01T00:00:00.000Z", "flight_count": 374, "nickname": "USAir" }, { "departure_month": "2003-10-01T00:00:00.000Z", "flight_count": 465, "nickname": "Northwest" }, { "departure_month": "2003-10-01T00:00:00.000Z", "flight_count": 113, "nickname": "Alaska" }, { "departure_month": "2003-10-01T00:00:00.000Z", "flight_count": 125, "nickname": "Jetblue" }, { "departure_month": "2003-09-01T00:00:00.000Z", "flight_count": 249, "nickname": "Continental Express" }, { "departure_month": "2003-09-01T00:00:00.000Z", "flight_count": 479, "nickname": "American" }, { "departure_month": "2003-09-01T00:00:00.000Z", "flight_count": 156, "nickname": "America West" }, { "departure_month": "2003-09-01T00:00:00.000Z", "flight_count": 108, "nickname": "Continental" }, { "departure_month": "2003-09-01T00:00:00.000Z", "flight_count": 278, "nickname": "Atlantic Southeast" }, { "departure_month": "2003-09-01T00:00:00.000Z", "flight_count": 354, "nickname": "USAir" }, { "departure_month": "2003-09-01T00:00:00.000Z", "flight_count": 468, "nickname": "United" }, { "departure_month": "2003-09-01T00:00:00.000Z", "flight_count": 139, "nickname": "Alaska" }, { "departure_month": "2003-09-01T00:00:00.000Z", "flight_count": 381, "nickname": "Northwest" }, { "departure_month": "2003-09-01T00:00:00.000Z", "flight_count": 499, "nickname": "Delta" }, { "departure_month": "2003-09-01T00:00:00.000Z", "flight_count": 1199, "nickname": "Southwest" }, { "departure_month": "2003-09-01T00:00:00.000Z", "flight_count": 121, "nickname": "Jetblue" }, { "departure_month": "2003-08-01T00:00:00.000Z", "flight_count": 415, "nickname": "Continental Express" }, { "departure_month": "2003-08-01T00:00:00.000Z", "flight_count": 28, "nickname": "American Eagle" }, { "departure_month": "2003-08-01T00:00:00.000Z", "flight_count": 1219, "nickname": "Southwest" }, { "departure_month": "2003-08-01T00:00:00.000Z", "flight_count": 456, "nickname": "American" }, { "departure_month": "2003-08-01T00:00:00.000Z", "flight_count": 142, "nickname": "America West" }, { "departure_month": "2003-08-01T00:00:00.000Z", "flight_count": 112, "nickname": "Continental" }, { "departure_month": "2003-08-01T00:00:00.000Z", "flight_count": 485, "nickname": "Delta" }, { "departure_month": "2003-08-01T00:00:00.000Z", "flight_count": 432, "nickname": "Atlantic Southeast" }, { "departure_month": "2003-08-01T00:00:00.000Z", "flight_count": 540, "nickname": "United" }, { "departure_month": "2003-08-01T00:00:00.000Z", "flight_count": 400, "nickname": "Northwest" }, { "departure_month": "2003-08-01T00:00:00.000Z", "flight_count": 131, "nickname": "Jetblue" }, { "departure_month": "2003-08-01T00:00:00.000Z", "flight_count": 419, "nickname": "USAir" }, { "departure_month": "2003-08-01T00:00:00.000Z", "flight_count": 139, "nickname": "Alaska" }, { "departure_month": "2003-07-01T00:00:00.000Z", "flight_count": 442, "nickname": "Continental Express" }, { "departure_month": "2003-07-01T00:00:00.000Z", "flight_count": 159, "nickname": "American Eagle" }, { "departure_month": "2003-07-01T00:00:00.000Z", "flight_count": 1252, "nickname": "Southwest" }, { "departure_month": "2003-07-01T00:00:00.000Z", "flight_count": 133, "nickname": "America West" }, { "departure_month": "2003-07-01T00:00:00.000Z", "flight_count": 399, "nickname": "Northwest" }, { "departure_month": "2003-07-01T00:00:00.000Z", "flight_count": 115, "nickname": "Continental" }, { "departure_month": "2003-07-01T00:00:00.000Z", "flight_count": 418, "nickname": "Atlantic Southeast" }, { "departure_month": "2003-07-01T00:00:00.000Z", "flight_count": 410, "nickname": "USAir" }, { "departure_month": "2003-07-01T00:00:00.000Z", "flight_count": 567, "nickname": "United" }, { "departure_month": "2003-07-01T00:00:00.000Z", "flight_count": 472, "nickname": "Delta" }, { "departure_month": "2003-07-01T00:00:00.000Z", "flight_count": 473, "nickname": "American" }, { "departure_month": "2003-07-01T00:00:00.000Z", "flight_count": 133, "nickname": "Alaska" }, { "departure_month": "2003-07-01T00:00:00.000Z", "flight_count": 144, "nickname": "Jetblue" }, { "departure_month": "2003-06-01T00:00:00.000Z", "flight_count": 425, "nickname": "Continental Express" }, { "departure_month": "2003-06-01T00:00:00.000Z", "flight_count": 150, "nickname": "American Eagle" }, { "departure_month": "2003-06-01T00:00:00.000Z", "flight_count": 1205, "nickname": "Southwest" }, { "departure_month": "2003-06-01T00:00:00.000Z", "flight_count": 426, "nickname": "American" }, { "departure_month": "2003-06-01T00:00:00.000Z", "flight_count": 139, "nickname": "America West" }, { "departure_month": "2003-06-01T00:00:00.000Z", "flight_count": 86, "nickname": "Continental" }, { "departure_month": "2003-06-01T00:00:00.000Z", "flight_count": 585, "nickname": "Atlantic Southeast" }, { "departure_month": "2003-06-01T00:00:00.000Z", "flight_count": 489, "nickname": "United" }, { "departure_month": "2003-06-01T00:00:00.000Z", "flight_count": 394, "nickname": "USAir" }, { "departure_month": "2003-06-01T00:00:00.000Z", "flight_count": 470, "nickname": "Delta" }, { "departure_month": "2003-06-01T00:00:00.000Z", "flight_count": 112, "nickname": "Jetblue" }, { "departure_month": "2003-06-01T00:00:00.000Z", "flight_count": 122, "nickname": "Alaska" }, { "departure_month": "2003-06-01T00:00:00.000Z", "flight_count": 402, "nickname": "Northwest" }, { "departure_month": "2003-05-01T00:00:00.000Z", "flight_count": 397, "nickname": "Continental Express" }, { "departure_month": "2003-05-01T00:00:00.000Z", "flight_count": 149, "nickname": "American Eagle" }, { "departure_month": "2003-05-01T00:00:00.000Z", "flight_count": 1232, "nickname": "Southwest" }, { "departure_month": "2003-05-01T00:00:00.000Z", "flight_count": 476, "nickname": "American" }, { "departure_month": "2003-05-01T00:00:00.000Z", "flight_count": 141, "nickname": "America West" }, { "departure_month": "2003-05-01T00:00:00.000Z", "flight_count": 62, "nickname": "Continental" }, { "departure_month": "2003-05-01T00:00:00.000Z", "flight_count": 641, "nickname": "Atlantic Southeast" }, { "departure_month": "2003-05-01T00:00:00.000Z", "flight_count": 381, "nickname": "USAir" }, { "departure_month": "2003-05-01T00:00:00.000Z", "flight_count": 524, "nickname": "United" }, { "departure_month": "2003-05-01T00:00:00.000Z", "flight_count": 432, "nickname": "Northwest" }, { "departure_month": "2003-05-01T00:00:00.000Z", "flight_count": 128, "nickname": "Alaska" }, { "departure_month": "2003-05-01T00:00:00.000Z", "flight_count": 426, "nickname": "Delta" }, { "departure_month": "2003-05-01T00:00:00.000Z", "flight_count": 125, "nickname": "Jetblue" }, { "departure_month": "2003-04-01T00:00:00.000Z", "flight_count": 221, "nickname": "Continental Express" }, { "departure_month": "2003-04-01T00:00:00.000Z", "flight_count": 117, "nickname": "American Eagle" }, { "departure_month": "2003-04-01T00:00:00.000Z", "flight_count": 1193, "nickname": "Southwest" }, { "departure_month": "2003-04-01T00:00:00.000Z", "flight_count": 457, "nickname": "American" }, { "departure_month": "2003-04-01T00:00:00.000Z", "flight_count": 137, "nickname": "America West" }, { "departure_month": "2003-04-01T00:00:00.000Z", "flight_count": 401, "nickname": "Northwest" }, { "departure_month": "2003-04-01T00:00:00.000Z", "flight_count": 107, "nickname": "Continental" }, { "departure_month": "2003-04-01T00:00:00.000Z", "flight_count": 626, "nickname": "Atlantic Southeast" }, { "departure_month": "2003-04-01T00:00:00.000Z", "flight_count": 349, "nickname": "USAir" }, { "departure_month": "2003-04-01T00:00:00.000Z", "flight_count": 468, "nickname": "United" }, { "departure_month": "2003-04-01T00:00:00.000Z", "flight_count": 406, "nickname": "Delta" }, { "departure_month": "2003-04-01T00:00:00.000Z", "flight_count": 139, "nickname": "Jetblue" }, { "departure_month": "2003-04-01T00:00:00.000Z", "flight_count": 119, "nickname": "Alaska" }, { "departure_month": "2003-04-01T00:00:00.000Z", "flight_count": 133, "nickname": "ATA" }, { "departure_month": "2003-03-01T00:00:00.000Z", "flight_count": 277, "nickname": "Continental Express" }, { "departure_month": "2003-03-01T00:00:00.000Z", "flight_count": 1191, "nickname": "Southwest" }, { "departure_month": "2003-03-01T00:00:00.000Z", "flight_count": 529, "nickname": "American" }, { "departure_month": "2003-03-01T00:00:00.000Z", "flight_count": 133, "nickname": "America West" }, { "departure_month": "2003-03-01T00:00:00.000Z", "flight_count": 483, "nickname": "United" }, { "departure_month": "2003-03-01T00:00:00.000Z", "flight_count": 448, "nickname": "Northwest" }, { "departure_month": "2003-03-01T00:00:00.000Z", "flight_count": 103, "nickname": "Continental" }, { "departure_month": "2003-03-01T00:00:00.000Z", "flight_count": 604, "nickname": "Atlantic Southeast" }, { "departure_month": "2003-03-01T00:00:00.000Z", "flight_count": 363, "nickname": "USAir" }, { "departure_month": "2003-03-01T00:00:00.000Z", "flight_count": 549, "nickname": "Delta" }, { "departure_month": "2003-03-01T00:00:00.000Z", "flight_count": 149, "nickname": "Jetblue" }, { "departure_month": "2003-03-01T00:00:00.000Z", "flight_count": 72, "nickname": "Alaska" }, { "departure_month": "2003-03-01T00:00:00.000Z", "flight_count": 116, "nickname": "ATA" }, { "departure_month": "2003-02-01T00:00:00.000Z", "flight_count": 205, "nickname": "Continental Express" }, { "departure_month": "2003-02-01T00:00:00.000Z", "flight_count": 156, "nickname": "American Eagle" }, { "departure_month": "2003-02-01T00:00:00.000Z", "flight_count": 1098, "nickname": "Southwest" }, { "departure_month": "2003-02-01T00:00:00.000Z", "flight_count": 463, "nickname": "American" }, { "departure_month": "2003-02-01T00:00:00.000Z", "flight_count": 110, "nickname": "America West" }, { "departure_month": "2003-02-01T00:00:00.000Z", "flight_count": 507, "nickname": "United" }, { "departure_month": "2003-02-01T00:00:00.000Z", "flight_count": 99, "nickname": "Continental" }, { "departure_month": "2003-02-01T00:00:00.000Z", "flight_count": 329, "nickname": "USAir" }, { "departure_month": "2003-02-01T00:00:00.000Z", "flight_count": 548, "nickname": "Atlantic Southeast" }, { "departure_month": "2003-02-01T00:00:00.000Z", "flight_count": 464, "nickname": "Delta" }, { "departure_month": "2003-02-01T00:00:00.000Z", "flight_count": 128, "nickname": "Alaska" }, { "departure_month": "2003-02-01T00:00:00.000Z", "flight_count": 387, "nickname": "Northwest" }, { "departure_month": "2003-02-01T00:00:00.000Z", "flight_count": 93, "nickname": "Jetblue" }, { "departure_month": "2003-02-01T00:00:00.000Z", "flight_count": 133, "nickname": "ATA" }, { "departure_month": "2003-01-01T00:00:00.000Z", "flight_count": 259, "nickname": "Continental Express" }, { "departure_month": "2003-01-01T00:00:00.000Z", "flight_count": 358, "nickname": "USAir" }, { "departure_month": "2003-01-01T00:00:00.000Z", "flight_count": 170, "nickname": "American Eagle" }, { "departure_month": "2003-01-01T00:00:00.000Z", "flight_count": 1209, "nickname": "Southwest" }, { "departure_month": "2003-01-01T00:00:00.000Z", "flight_count": 422, "nickname": "American" }, { "departure_month": "2003-01-01T00:00:00.000Z", "flight_count": 142, "nickname": "America West" }, { "departure_month": "2003-01-01T00:00:00.000Z", "flight_count": 547, "nickname": "Atlantic Southeast" }, { "departure_month": "2003-01-01T00:00:00.000Z", "flight_count": 339, "nickname": "Delta" }, { "departure_month": "2003-01-01T00:00:00.000Z", "flight_count": 524, "nickname": "United" }, { "departure_month": "2003-01-01T00:00:00.000Z", "flight_count": 137, "nickname": "ATA" }, { "departure_month": "2003-01-01T00:00:00.000Z", "flight_count": 151, "nickname": "Jetblue" }, { "departure_month": "2003-01-01T00:00:00.000Z", "flight_count": 73, "nickname": "Continental" }, { "departure_month": "2003-01-01T00:00:00.000Z", "flight_count": 419, "nickname": "Northwest" }, { "departure_month": "2003-01-01T00:00:00.000Z", "flight_count": 142, "nickname": "Alaska" }, { "departure_month": "2002-12-01T00:00:00.000Z", "flight_count": 262, "nickname": "American Eagle" }, { "departure_month": "2002-12-01T00:00:00.000Z", "flight_count": 1250, "nickname": "Southwest" }, { "departure_month": "2002-12-01T00:00:00.000Z", "flight_count": 460, "nickname": "American" }, { "departure_month": "2002-12-01T00:00:00.000Z", "flight_count": 101, "nickname": "America West" }, { "departure_month": "2002-12-01T00:00:00.000Z", "flight_count": 501, "nickname": "Northwest" }, { "departure_month": "2002-12-01T00:00:00.000Z", "flight_count": 112, "nickname": "Continental" }, { "departure_month": "2002-12-01T00:00:00.000Z", "flight_count": 405, "nickname": "USAir" }, { "departure_month": "2002-12-01T00:00:00.000Z", "flight_count": 291, "nickname": "Delta" }, { "departure_month": "2002-12-01T00:00:00.000Z", "flight_count": 500, "nickname": "United" }, { "departure_month": "2002-12-01T00:00:00.000Z", "flight_count": 117, "nickname": "Alaska" }, { "departure_month": "2002-11-01T00:00:00.000Z", "flight_count": 301, "nickname": "American Eagle" }, { "departure_month": "2002-11-01T00:00:00.000Z", "flight_count": 466, "nickname": "American" }, { "departure_month": "2002-11-01T00:00:00.000Z", "flight_count": 85, "nickname": "America West" }, { "departure_month": "2002-11-01T00:00:00.000Z", "flight_count": 414, "nickname": "Northwest" }, { "departure_month": "2002-11-01T00:00:00.000Z", "flight_count": 99, "nickname": "Continental" }, { "departure_month": "2002-11-01T00:00:00.000Z", "flight_count": 137, "nickname": "Alaska" }, { "departure_month": "2002-11-01T00:00:00.000Z", "flight_count": 518, "nickname": "United" }, { "departure_month": "2002-11-01T00:00:00.000Z", "flight_count": 1179, "nickname": "Southwest" }, { "departure_month": "2002-11-01T00:00:00.000Z", "flight_count": 300, "nickname": "Delta" }, { "departure_month": "2002-11-01T00:00:00.000Z", "flight_count": 415, "nickname": "USAir" }, { "departure_month": "2002-10-01T00:00:00.000Z", "flight_count": 337, "nickname": "American Eagle" }, { "departure_month": "2002-10-01T00:00:00.000Z", "flight_count": 1280, "nickname": "Southwest" }, { "departure_month": "2002-10-01T00:00:00.000Z", "flight_count": 178, "nickname": "America West" }, { "departure_month": "2002-10-01T00:00:00.000Z", "flight_count": 527, "nickname": "United" }, { "departure_month": "2002-10-01T00:00:00.000Z", "flight_count": 547, "nickname": "American" }, { "departure_month": "2002-10-01T00:00:00.000Z", "flight_count": 113, "nickname": "Continental" }, { "departure_month": "2002-10-01T00:00:00.000Z", "flight_count": 475, "nickname": "USAir" }, { "departure_month": "2002-10-01T00:00:00.000Z", "flight_count": 461, "nickname": "Northwest" }, { "departure_month": "2002-10-01T00:00:00.000Z", "flight_count": 132, "nickname": "Alaska" }, { "departure_month": "2002-10-01T00:00:00.000Z", "flight_count": 290, "nickname": "Delta" }, { "departure_month": "2002-09-01T00:00:00.000Z", "flight_count": 352, "nickname": "American Eagle" }, { "departure_month": "2002-09-01T00:00:00.000Z", "flight_count": 1214, "nickname": "Southwest" }, { "departure_month": "2002-09-01T00:00:00.000Z", "flight_count": 152, "nickname": "America West" }, { "departure_month": "2002-09-01T00:00:00.000Z", "flight_count": 512, "nickname": "United" }, { "departure_month": "2002-09-01T00:00:00.000Z", "flight_count": 517, "nickname": "American" }, { "departure_month": "2002-09-01T00:00:00.000Z", "flight_count": 399, "nickname": "Northwest" }, { "departure_month": "2002-09-01T00:00:00.000Z", "flight_count": 87, "nickname": "Continental" }, { "departure_month": "2002-09-01T00:00:00.000Z", "flight_count": 296, "nickname": "Delta" }, { "departure_month": "2002-09-01T00:00:00.000Z", "flight_count": 606, "nickname": "USAir" }, { "departure_month": "2002-09-01T00:00:00.000Z", "flight_count": 126, "nickname": "Alaska" }, { "departure_month": "2002-08-01T00:00:00.000Z", "flight_count": 280, "nickname": "American Eagle" }, { "departure_month": "2002-08-01T00:00:00.000Z", "flight_count": 1286, "nickname": "Southwest" }, { "departure_month": "2002-08-01T00:00:00.000Z", "flight_count": 526, "nickname": "American" }, { "departure_month": "2002-08-01T00:00:00.000Z", "flight_count": 150, "nickname": "America West" }, { "departure_month": "2002-08-01T00:00:00.000Z", "flight_count": 434, "nickname": "United" }, { "departure_month": "2002-08-01T00:00:00.000Z", "flight_count": 468, "nickname": "Northwest" }, { "departure_month": "2002-08-01T00:00:00.000Z", "flight_count": 90, "nickname": "Continental" }, { "departure_month": "2002-08-01T00:00:00.000Z", "flight_count": 648, "nickname": "USAir" }, { "departure_month": "2002-08-01T00:00:00.000Z", "flight_count": 127, "nickname": "Alaska" }, { "departure_month": "2002-08-01T00:00:00.000Z", "flight_count": 317, "nickname": "Delta" }, { "departure_month": "2002-07-01T00:00:00.000Z", "flight_count": 586, "nickname": "USAir" }, { "departure_month": "2002-07-01T00:00:00.000Z", "flight_count": 287, "nickname": "American Eagle" }, { "departure_month": "2002-07-01T00:00:00.000Z", "flight_count": 1235, "nickname": "Southwest" }, { "departure_month": "2002-07-01T00:00:00.000Z", "flight_count": 503, "nickname": "American" }, { "departure_month": "2002-07-01T00:00:00.000Z", "flight_count": 137, "nickname": "America West" }, { "departure_month": "2002-07-01T00:00:00.000Z", "flight_count": 445, "nickname": "United" }, { "departure_month": "2002-07-01T00:00:00.000Z", "flight_count": 103, "nickname": "Continental" }, { "departure_month": "2002-07-01T00:00:00.000Z", "flight_count": 455, "nickname": "Northwest" }, { "departure_month": "2002-07-01T00:00:00.000Z", "flight_count": 140, "nickname": "Alaska" }, { "departure_month": "2002-07-01T00:00:00.000Z", "flight_count": 455, "nickname": "Delta" }, { "departure_month": "2002-06-01T00:00:00.000Z", "flight_count": 1215, "nickname": "Southwest" }, { "departure_month": "2002-06-01T00:00:00.000Z", "flight_count": 133, "nickname": "America West" }, { "departure_month": "2002-06-01T00:00:00.000Z", "flight_count": 512, "nickname": "American" }, { "departure_month": "2002-06-01T00:00:00.000Z", "flight_count": 444, "nickname": "Northwest" }, { "departure_month": "2002-06-01T00:00:00.000Z", "flight_count": 111, "nickname": "Continental" }, { "departure_month": "2002-06-01T00:00:00.000Z", "flight_count": 630, "nickname": "USAir" }, { "departure_month": "2002-06-01T00:00:00.000Z", "flight_count": 109, "nickname": "Alaska" }, { "departure_month": "2002-06-01T00:00:00.000Z", "flight_count": 423, "nickname": "Delta" }, { "departure_month": "2002-06-01T00:00:00.000Z", "flight_count": 485, "nickname": "United" }, { "departure_month": "2002-06-01T00:00:00.000Z", "flight_count": 313, "nickname": "American Eagle" }, { "departure_month": "2002-05-01T00:00:00.000Z", "flight_count": 630, "nickname": "USAir" }, { "departure_month": "2002-05-01T00:00:00.000Z", "flight_count": 305, "nickname": "American Eagle" }, { "departure_month": "2002-05-01T00:00:00.000Z", "flight_count": 1291, "nickname": "Southwest" }, { "departure_month": "2002-05-01T00:00:00.000Z", "flight_count": 549, "nickname": "American" }, { "departure_month": "2002-05-01T00:00:00.000Z", "flight_count": 124, "nickname": "America West" }, { "departure_month": "2002-05-01T00:00:00.000Z", "flight_count": 20, "nickname": "Continental" }, { "departure_month": "2002-05-01T00:00:00.000Z", "flight_count": 136, "nickname": "Alaska" }, { "departure_month": "2002-05-01T00:00:00.000Z", "flight_count": 417, "nickname": "Delta" }, { "departure_month": "2002-05-01T00:00:00.000Z", "flight_count": 459, "nickname": "United" }, { "departure_month": "2002-05-01T00:00:00.000Z", "flight_count": 417, "nickname": "Northwest" }, { "departure_month": "2002-04-01T00:00:00.000Z", "flight_count": 268, "nickname": "American Eagle" }, { "departure_month": "2002-04-01T00:00:00.000Z", "flight_count": 534, "nickname": "American" }, { "departure_month": "2002-04-01T00:00:00.000Z", "flight_count": 1186, "nickname": "Southwest" }, { "departure_month": "2002-04-01T00:00:00.000Z", "flight_count": 137, "nickname": "America West" }, { "departure_month": "2002-04-01T00:00:00.000Z", "flight_count": 60, "nickname": "Continental" }, { "departure_month": "2002-04-01T00:00:00.000Z", "flight_count": 600, "nickname": "USAir" }, { "departure_month": "2002-04-01T00:00:00.000Z", "flight_count": 117, "nickname": "Alaska" }, { "departure_month": "2002-04-01T00:00:00.000Z", "flight_count": 285, "nickname": "Northwest" }, { "departure_month": "2002-04-01T00:00:00.000Z", "flight_count": 417, "nickname": "Delta" }, { "departure_month": "2002-04-01T00:00:00.000Z", "flight_count": 442, "nickname": "United" }, { "departure_month": "2002-03-01T00:00:00.000Z", "flight_count": 276, "nickname": "American Eagle" }, { "departure_month": "2002-03-01T00:00:00.000Z", "flight_count": 1240, "nickname": "Southwest" }, { "departure_month": "2002-03-01T00:00:00.000Z", "flight_count": 466, "nickname": "American" }, { "departure_month": "2002-03-01T00:00:00.000Z", "flight_count": 164, "nickname": "America West" }, { "departure_month": "2002-03-01T00:00:00.000Z", "flight_count": 442, "nickname": "Northwest" }, { "departure_month": "2002-03-01T00:00:00.000Z", "flight_count": 476, "nickname": "USAir" }, { "departure_month": "2002-03-01T00:00:00.000Z", "flight_count": 407, "nickname": "United" }, { "departure_month": "2002-03-01T00:00:00.000Z", "flight_count": 122, "nickname": "Alaska" }, { "departure_month": "2002-03-01T00:00:00.000Z", "flight_count": 424, "nickname": "Delta" }, { "departure_month": "2002-03-01T00:00:00.000Z", "flight_count": 85, "nickname": "Continental" }, { "departure_month": "2002-02-01T00:00:00.000Z", "flight_count": 266, "nickname": "American Eagle" }, { "departure_month": "2002-02-01T00:00:00.000Z", "flight_count": 102, "nickname": "America West" }, { "departure_month": "2002-02-01T00:00:00.000Z", "flight_count": 404, "nickname": "Northwest" }, { "departure_month": "2002-02-01T00:00:00.000Z", "flight_count": 95, "nickname": "Continental" }, { "departure_month": "2002-02-01T00:00:00.000Z", "flight_count": 402, "nickname": "United" }, { "departure_month": "2002-02-01T00:00:00.000Z", "flight_count": 343, "nickname": "Delta" }, { "departure_month": "2002-02-01T00:00:00.000Z", "flight_count": 422, "nickname": "American" }, { "departure_month": "2002-02-01T00:00:00.000Z", "flight_count": 457, "nickname": "USAir" }, { "departure_month": "2002-02-01T00:00:00.000Z", "flight_count": 1092, "nickname": "Southwest" }, { "departure_month": "2002-01-01T00:00:00.000Z", "flight_count": 573, "nickname": "USAir" }, { "departure_month": "2002-01-01T00:00:00.000Z", "flight_count": 222, "nickname": "American Eagle" }, { "departure_month": "2002-01-01T00:00:00.000Z", "flight_count": 1240, "nickname": "Southwest" }, { "departure_month": "2002-01-01T00:00:00.000Z", "flight_count": 461, "nickname": "American" }, { "departure_month": "2002-01-01T00:00:00.000Z", "flight_count": 123, "nickname": "America West" }, { "departure_month": "2002-01-01T00:00:00.000Z", "flight_count": 112, "nickname": "Continental" }, { "departure_month": "2002-01-01T00:00:00.000Z", "flight_count": 427, "nickname": "Delta" }, { "departure_month": "2002-01-01T00:00:00.000Z", "flight_count": 459, "nickname": "United" }, { "departure_month": "2002-01-01T00:00:00.000Z", "flight_count": 391, "nickname": "Northwest" }, { "departure_month": "2001-12-01T00:00:00.000Z", "flight_count": 247, "nickname": "American Eagle" }, { "departure_month": "2001-12-01T00:00:00.000Z", "flight_count": 1159, "nickname": "Southwest" }, { "departure_month": "2001-12-01T00:00:00.000Z", "flight_count": 486, "nickname": "American" }, { "departure_month": "2001-12-01T00:00:00.000Z", "flight_count": 115, "nickname": "America West" }, { "departure_month": "2001-12-01T00:00:00.000Z", "flight_count": 418, "nickname": "United" }, { "departure_month": "2001-12-01T00:00:00.000Z", "flight_count": 432, "nickname": "Northwest" }, { "departure_month": "2001-12-01T00:00:00.000Z", "flight_count": 108, "nickname": "Alaska" }, { "departure_month": "2001-12-01T00:00:00.000Z", "flight_count": 403, "nickname": "Delta" }, { "departure_month": "2001-12-01T00:00:00.000Z", "flight_count": 634, "nickname": "USAir" }, { "departure_month": "2001-12-01T00:00:00.000Z", "flight_count": 84, "nickname": "Continental" }, { "departure_month": "2001-11-01T00:00:00.000Z", "flight_count": 212, "nickname": "American Eagle" }, { "departure_month": "2001-11-01T00:00:00.000Z", "flight_count": 1224, "nickname": "Southwest" }, { "departure_month": "2001-11-01T00:00:00.000Z", "flight_count": 462, "nickname": "American" }, { "departure_month": "2001-11-01T00:00:00.000Z", "flight_count": 52, "nickname": "America West" }, { "departure_month": "2001-11-01T00:00:00.000Z", "flight_count": 399, "nickname": "United" }, { "departure_month": "2001-11-01T00:00:00.000Z", "flight_count": 101, "nickname": "Continental" }, { "departure_month": "2001-11-01T00:00:00.000Z", "flight_count": 499, "nickname": "USAir" }, { "departure_month": "2001-11-01T00:00:00.000Z", "flight_count": 440, "nickname": "Delta" }, { "departure_month": "2001-11-01T00:00:00.000Z", "flight_count": 317, "nickname": "Northwest" }, { "departure_month": "2001-11-01T00:00:00.000Z", "flight_count": 113, "nickname": "Alaska" }, { "departure_month": "2001-10-01T00:00:00.000Z", "flight_count": 346, "nickname": "Delta" }, { "departure_month": "2001-10-01T00:00:00.000Z", "flight_count": 456, "nickname": "USAir" }, { "departure_month": "2001-10-01T00:00:00.000Z", "flight_count": 290, "nickname": "American Eagle" }, { "departure_month": "2001-10-01T00:00:00.000Z", "flight_count": 1309, "nickname": "Southwest" }, { "departure_month": "2001-10-01T00:00:00.000Z", "flight_count": 455, "nickname": "American" }, { "departure_month": "2001-10-01T00:00:00.000Z", "flight_count": 94, "nickname": "America West" }, { "departure_month": "2001-10-01T00:00:00.000Z", "flight_count": 110, "nickname": "Continental" }, { "departure_month": "2001-10-01T00:00:00.000Z", "flight_count": 290, "nickname": "Northwest" }, { "departure_month": "2001-10-01T00:00:00.000Z", "flight_count": 361, "nickname": "United" }, { "departure_month": "2001-10-01T00:00:00.000Z", "flight_count": 98, "nickname": "Alaska" }, { "departure_month": "2001-09-01T00:00:00.000Z", "flight_count": 450, "nickname": "Delta" }, { "departure_month": "2001-09-01T00:00:00.000Z", "flight_count": 227, "nickname": "American Eagle" }, { "departure_month": "2001-09-01T00:00:00.000Z", "flight_count": 1150, "nickname": "Southwest" }, { "departure_month": "2001-09-01T00:00:00.000Z", "flight_count": 347, "nickname": "American" }, { "departure_month": "2001-09-01T00:00:00.000Z", "flight_count": 296, "nickname": "United" }, { "departure_month": "2001-09-01T00:00:00.000Z", "flight_count": 419, "nickname": "Northwest" }, { "departure_month": "2001-09-01T00:00:00.000Z", "flight_count": 76, "nickname": "Continental" }, { "departure_month": "2001-09-01T00:00:00.000Z", "flight_count": 449, "nickname": "USAir" }, { "departure_month": "2001-09-01T00:00:00.000Z", "flight_count": 67, "nickname": "Alaska" }, { "departure_month": "2001-09-01T00:00:00.000Z", "flight_count": 135, "nickname": "America West" }, { "departure_month": "2001-08-01T00:00:00.000Z", "flight_count": 554, "nickname": "Delta" }, { "departure_month": "2001-08-01T00:00:00.000Z", "flight_count": 554, "nickname": "USAir" }, { "departure_month": "2001-08-01T00:00:00.000Z", "flight_count": 343, "nickname": "American Eagle" }, { "departure_month": "2001-08-01T00:00:00.000Z", "flight_count": 1318, "nickname": "Southwest" }, { "departure_month": "2001-08-01T00:00:00.000Z", "flight_count": 557, "nickname": "American" }, { "departure_month": "2001-08-01T00:00:00.000Z", "flight_count": 153, "nickname": "America West" }, { "departure_month": "2001-08-01T00:00:00.000Z", "flight_count": 363, "nickname": "United" }, { "departure_month": "2001-08-01T00:00:00.000Z", "flight_count": 516, "nickname": "Northwest" }, { "departure_month": "2001-08-01T00:00:00.000Z", "flight_count": 133, "nickname": "Alaska" }, { "departure_month": "2001-08-01T00:00:00.000Z", "flight_count": 116, "nickname": "Continental" }, { "departure_month": "2001-07-01T00:00:00.000Z", "flight_count": 498, "nickname": "Delta" }, { "departure_month": "2001-07-01T00:00:00.000Z", "flight_count": 367, "nickname": "American Eagle" }, { "departure_month": "2001-07-01T00:00:00.000Z", "flight_count": 1299, "nickname": "Southwest" }, { "departure_month": "2001-07-01T00:00:00.000Z", "flight_count": 522, "nickname": "American" }, { "departure_month": "2001-07-01T00:00:00.000Z", "flight_count": 142, "nickname": "America West" }, { "departure_month": "2001-07-01T00:00:00.000Z", "flight_count": 272, "nickname": "United" }, { "departure_month": "2001-07-01T00:00:00.000Z", "flight_count": 123, "nickname": "Continental" }, { "departure_month": "2001-07-01T00:00:00.000Z", "flight_count": 583, "nickname": "USAir" }, { "departure_month": "2001-07-01T00:00:00.000Z", "flight_count": 143, "nickname": "Alaska" }, { "departure_month": "2001-07-01T00:00:00.000Z", "flight_count": 491, "nickname": "Northwest" }, { "departure_month": "2001-06-01T00:00:00.000Z", "flight_count": 485, "nickname": "Delta" }, { "departure_month": "2001-06-01T00:00:00.000Z", "flight_count": 309, "nickname": "American Eagle" }, { "departure_month": "2001-06-01T00:00:00.000Z", "flight_count": 1254, "nickname": "Southwest" }, { "departure_month": "2001-06-01T00:00:00.000Z", "flight_count": 543, "nickname": "American" }, { "departure_month": "2001-06-01T00:00:00.000Z", "flight_count": 160, "nickname": "America West" }, { "departure_month": "2001-06-01T00:00:00.000Z", "flight_count": 512, "nickname": "Northwest" }, { "departure_month": "2001-06-01T00:00:00.000Z", "flight_count": 110, "nickname": "Continental" }, { "departure_month": "2001-06-01T00:00:00.000Z", "flight_count": 607, "nickname": "USAir" }, { "departure_month": "2001-06-01T00:00:00.000Z", "flight_count": 133, "nickname": "Alaska" }, { "departure_month": "2001-06-01T00:00:00.000Z", "flight_count": 338, "nickname": "United" }, { "departure_month": "2001-05-01T00:00:00.000Z", "flight_count": 535, "nickname": "Delta" }, { "departure_month": "2001-05-01T00:00:00.000Z", "flight_count": 327, "nickname": "American Eagle" }, { "departure_month": "2001-05-01T00:00:00.000Z", "flight_count": 1216, "nickname": "Southwest" }, { "departure_month": "2001-05-01T00:00:00.000Z", "flight_count": 466, "nickname": "American" }, { "departure_month": "2001-05-01T00:00:00.000Z", "flight_count": 151, "nickname": "America West" }, { "departure_month": "2001-05-01T00:00:00.000Z", "flight_count": 124, "nickname": "Continental" }, { "departure_month": "2001-05-01T00:00:00.000Z", "flight_count": 646, "nickname": "USAir" }, { "departure_month": "2001-05-01T00:00:00.000Z", "flight_count": 139, "nickname": "Alaska" }, { "departure_month": "2001-05-01T00:00:00.000Z", "flight_count": 491, "nickname": "Northwest" }, { "departure_month": "2001-05-01T00:00:00.000Z", "flight_count": 312, "nickname": "United" }, { "departure_month": "2001-04-01T00:00:00.000Z", "flight_count": 553, "nickname": "Delta" }, { "departure_month": "2001-04-01T00:00:00.000Z", "flight_count": 641, "nickname": "USAir" }, { "departure_month": "2001-04-01T00:00:00.000Z", "flight_count": 305, "nickname": "American Eagle" }, { "departure_month": "2001-04-01T00:00:00.000Z", "flight_count": 1218, "nickname": "Southwest" }, { "departure_month": "2001-04-01T00:00:00.000Z", "flight_count": 523, "nickname": "American" }, { "departure_month": "2001-04-01T00:00:00.000Z", "flight_count": 112, "nickname": "Continental" }, { "departure_month": "2001-04-01T00:00:00.000Z", "flight_count": 478, "nickname": "Northwest" }, { "departure_month": "2001-04-01T00:00:00.000Z", "flight_count": 120, "nickname": "Alaska" }, { "departure_month": "2001-04-01T00:00:00.000Z", "flight_count": 277, "nickname": "United" }, { "departure_month": "2001-04-01T00:00:00.000Z", "flight_count": 101, "nickname": "America West" }, { "departure_month": "2001-03-01T00:00:00.000Z", "flight_count": 589, "nickname": "Delta" }, { "departure_month": "2001-03-01T00:00:00.000Z", "flight_count": 589, "nickname": "USAir" }, { "departure_month": "2001-03-01T00:00:00.000Z", "flight_count": 332, "nickname": "American Eagle" }, { "departure_month": "2001-03-01T00:00:00.000Z", "flight_count": 514, "nickname": "American" }, { "departure_month": "2001-03-01T00:00:00.000Z", "flight_count": 747, "nickname": "Southwest" }, { "departure_month": "2001-03-01T00:00:00.000Z", "flight_count": 150, "nickname": "America West" }, { "departure_month": "2001-03-01T00:00:00.000Z", "flight_count": 318, "nickname": "United" }, { "departure_month": "2001-03-01T00:00:00.000Z", "flight_count": 478, "nickname": "Northwest" }, { "departure_month": "2001-03-01T00:00:00.000Z", "flight_count": 127, "nickname": "Alaska" }, { "departure_month": "2001-03-01T00:00:00.000Z", "flight_count": 25, "nickname": "Continental" }, { "departure_month": "2001-02-01T00:00:00.000Z", "flight_count": 387, "nickname": "Delta" }, { "departure_month": "2001-02-01T00:00:00.000Z", "flight_count": 1212, "nickname": "Southwest" }, { "departure_month": "2001-02-01T00:00:00.000Z", "flight_count": 154, "nickname": "America West" }, { "departure_month": "2001-02-01T00:00:00.000Z", "flight_count": 464, "nickname": "Northwest" }, { "departure_month": "2001-02-01T00:00:00.000Z", "flight_count": 92, "nickname": "Continental" }, { "departure_month": "2001-02-01T00:00:00.000Z", "flight_count": 552, "nickname": "USAir" }, { "departure_month": "2001-02-01T00:00:00.000Z", "flight_count": 443, "nickname": "American" }, { "departure_month": "2001-02-01T00:00:00.000Z", "flight_count": 230, "nickname": "United" }, { "departure_month": "2001-02-01T00:00:00.000Z", "flight_count": 138, "nickname": "Alaska" }, { "departure_month": "2001-01-01T00:00:00.000Z", "flight_count": 437, "nickname": "Delta" }, { "departure_month": "2001-01-01T00:00:00.000Z", "flight_count": 1315, "nickname": "Southwest" }, { "departure_month": "2001-01-01T00:00:00.000Z", "flight_count": 533, "nickname": "American" }, { "departure_month": "2001-01-01T00:00:00.000Z", "flight_count": 184, "nickname": "America West" }, { "departure_month": "2001-01-01T00:00:00.000Z", "flight_count": 493, "nickname": "Northwest" }, { "departure_month": "2001-01-01T00:00:00.000Z", "flight_count": 134, "nickname": "Continental" }, { "departure_month": "2001-01-01T00:00:00.000Z", "flight_count": 656, "nickname": "USAir" }, { "departure_month": "2001-01-01T00:00:00.000Z", "flight_count": 118, "nickname": "Alaska" }, { "departure_month": "2001-01-01T00:00:00.000Z", "flight_count": 201, "nickname": "United" }, { "departure_month": "2000-12-01T00:00:00.000Z", "flight_count": 463, "nickname": "Delta" }, { "departure_month": "2000-12-01T00:00:00.000Z", "flight_count": 1116, "nickname": "Southwest" }, { "departure_month": "2000-12-01T00:00:00.000Z", "flight_count": 449, "nickname": "American" }, { "departure_month": "2000-12-01T00:00:00.000Z", "flight_count": 206, "nickname": "United" }, { "departure_month": "2000-12-01T00:00:00.000Z", "flight_count": 473, "nickname": "Northwest" }, { "departure_month": "2000-12-01T00:00:00.000Z", "flight_count": 114, "nickname": "Alaska" }, { "departure_month": "2000-12-01T00:00:00.000Z", "flight_count": 647, "nickname": "USAir" }, { "departure_month": "2000-12-01T00:00:00.000Z", "flight_count": 117, "nickname": "Continental" }, { "departure_month": "2000-12-01T00:00:00.000Z", "flight_count": 159, "nickname": "America West" }, { "departure_month": "2000-11-01T00:00:00.000Z", "flight_count": 511, "nickname": "Delta" }, { "departure_month": "2000-11-01T00:00:00.000Z", "flight_count": 552, "nickname": "USAir" }, { "departure_month": "2000-11-01T00:00:00.000Z", "flight_count": 501, "nickname": "American" }, { "departure_month": "2000-11-01T00:00:00.000Z", "flight_count": 1059, "nickname": "Southwest" }, { "departure_month": "2000-11-01T00:00:00.000Z", "flight_count": 133, "nickname": "Continental" }, { "departure_month": "2000-11-01T00:00:00.000Z", "flight_count": 145, "nickname": "Alaska" }, { "departure_month": "2000-11-01T00:00:00.000Z", "flight_count": 269, "nickname": "United" }, { "departure_month": "2000-11-01T00:00:00.000Z", "flight_count": 32, "nickname": "America West" }, { "departure_month": "2000-11-01T00:00:00.000Z", "flight_count": 516, "nickname": "Northwest" }, { "departure_month": "2000-10-01T00:00:00.000Z", "flight_count": 589, "nickname": "Delta" }, { "departure_month": "2000-10-01T00:00:00.000Z", "flight_count": 620, "nickname": "USAir" }, { "departure_month": "2000-10-01T00:00:00.000Z", "flight_count": 1108, "nickname": "Southwest" }, { "departure_month": "2000-10-01T00:00:00.000Z", "flight_count": 483, "nickname": "American" }, { "departure_month": "2000-10-01T00:00:00.000Z", "flight_count": 131, "nickname": "America West" }, { "departure_month": "2000-10-01T00:00:00.000Z", "flight_count": 433, "nickname": "Northwest" }, { "departure_month": "2000-10-01T00:00:00.000Z", "flight_count": 51, "nickname": "Alaska" }, { "departure_month": "2000-10-01T00:00:00.000Z", "flight_count": 121, "nickname": "Continental" }, { "departure_month": "2000-10-01T00:00:00.000Z", "flight_count": 322, "nickname": "United" }, { "departure_month": "2000-09-01T00:00:00.000Z", "flight_count": 496, "nickname": "Delta" }, { "departure_month": "2000-09-01T00:00:00.000Z", "flight_count": 603, "nickname": "USAir" }, { "departure_month": "2000-09-01T00:00:00.000Z", "flight_count": 1040, "nickname": "Southwest" }, { "departure_month": "2000-09-01T00:00:00.000Z", "flight_count": 540, "nickname": "American" }, { "departure_month": "2000-09-01T00:00:00.000Z", "flight_count": 477, "nickname": "Northwest" }, { "departure_month": "2000-09-01T00:00:00.000Z", "flight_count": 106, "nickname": "Continental" }, { "departure_month": "2000-09-01T00:00:00.000Z", "flight_count": 166, "nickname": "America West" }, { "departure_month": "2000-09-01T00:00:00.000Z", "flight_count": 310, "nickname": "United" }, { "departure_month": "2000-09-01T00:00:00.000Z", "flight_count": 112, "nickname": "Alaska" }, { "departure_month": "2000-08-01T00:00:00.000Z", "flight_count": 568, "nickname": "Delta" }, { "departure_month": "2000-08-01T00:00:00.000Z", "flight_count": 616, "nickname": "USAir" }, { "departure_month": "2000-08-01T00:00:00.000Z", "flight_count": 1143, "nickname": "Southwest" }, { "departure_month": "2000-08-01T00:00:00.000Z", "flight_count": 552, "nickname": "American" }, { "departure_month": "2000-08-01T00:00:00.000Z", "flight_count": 173, "nickname": "America West" }, { "departure_month": "2000-08-01T00:00:00.000Z", "flight_count": 509, "nickname": "Northwest" }, { "departure_month": "2000-08-01T00:00:00.000Z", "flight_count": 131, "nickname": "Continental" }, { "departure_month": "2000-08-01T00:00:00.000Z", "flight_count": 335, "nickname": "United" }, { "departure_month": "2000-08-01T00:00:00.000Z", "flight_count": 155, "nickname": "Alaska" }, { "departure_month": "2000-07-01T00:00:00.000Z", "flight_count": 514, "nickname": "Delta" }, { "departure_month": "2000-07-01T00:00:00.000Z", "flight_count": 623, "nickname": "USAir" }, { "departure_month": "2000-07-01T00:00:00.000Z", "flight_count": 1070, "nickname": "Southwest" }, { "departure_month": "2000-07-01T00:00:00.000Z", "flight_count": 571, "nickname": "American" }, { "departure_month": "2000-07-01T00:00:00.000Z", "flight_count": 165, "nickname": "America West" }, { "departure_month": "2000-07-01T00:00:00.000Z", "flight_count": 506, "nickname": "Northwest" }, { "departure_month": "2000-07-01T00:00:00.000Z", "flight_count": 129, "nickname": "Continental" }, { "departure_month": "2000-07-01T00:00:00.000Z", "flight_count": 158, "nickname": "Alaska" }, { "departure_month": "2000-07-01T00:00:00.000Z", "flight_count": 307, "nickname": "United" }, { "departure_month": "2000-06-01T00:00:00.000Z", "flight_count": 561, "nickname": "Delta" }, { "departure_month": "2000-06-01T00:00:00.000Z", "flight_count": 566, "nickname": "USAir" }, { "departure_month": "2000-06-01T00:00:00.000Z", "flight_count": 1030, "nickname": "Southwest" }, { "departure_month": "2000-06-01T00:00:00.000Z", "flight_count": 496, "nickname": "American" }, { "departure_month": "2000-06-01T00:00:00.000Z", "flight_count": 130, "nickname": "America West" }, { "departure_month": "2000-06-01T00:00:00.000Z", "flight_count": 134, "nickname": "Continental" }, { "departure_month": "2000-06-01T00:00:00.000Z", "flight_count": 135, "nickname": "Alaska" }, { "departure_month": "2000-06-01T00:00:00.000Z", "flight_count": 404, "nickname": "Northwest" }, { "departure_month": "2000-06-01T00:00:00.000Z", "flight_count": 318, "nickname": "United" }, { "departure_month": "2000-05-01T00:00:00.000Z", "flight_count": 546, "nickname": "Delta" }, { "departure_month": "2000-05-01T00:00:00.000Z", "flight_count": 611, "nickname": "USAir" }, { "departure_month": "2000-05-01T00:00:00.000Z", "flight_count": 1151, "nickname": "Southwest" }, { "departure_month": "2000-05-01T00:00:00.000Z", "flight_count": 467, "nickname": "American" }, { "departure_month": "2000-05-01T00:00:00.000Z", "flight_count": 181, "nickname": "America West" }, { "departure_month": "2000-05-01T00:00:00.000Z", "flight_count": 317, "nickname": "United" }, { "departure_month": "2000-05-01T00:00:00.000Z", "flight_count": 499, "nickname": "Northwest" }, { "departure_month": "2000-05-01T00:00:00.000Z", "flight_count": 147, "nickname": "Alaska" }, { "departure_month": "2000-05-01T00:00:00.000Z", "flight_count": 128, "nickname": "Continental" }, { "departure_month": "2000-04-01T00:00:00.000Z", "flight_count": 533, "nickname": "Delta" }, { "departure_month": "2000-04-01T00:00:00.000Z", "flight_count": 1097, "nickname": "Southwest" }, { "departure_month": "2000-04-01T00:00:00.000Z", "flight_count": 165, "nickname": "America West" }, { "departure_month": "2000-04-01T00:00:00.000Z", "flight_count": 455, "nickname": "Northwest" }, { "departure_month": "2000-04-01T00:00:00.000Z", "flight_count": 118, "nickname": "Alaska" }, { "departure_month": "2000-04-01T00:00:00.000Z", "flight_count": 279, "nickname": "United" }, { "departure_month": "2000-04-01T00:00:00.000Z", "flight_count": 118, "nickname": "Continental" }, { "departure_month": "2000-04-01T00:00:00.000Z", "flight_count": 568, "nickname": "USAir" }, { "departure_month": "2000-04-01T00:00:00.000Z", "flight_count": 445, "nickname": "American" }, { "departure_month": "2000-03-01T00:00:00.000Z", "flight_count": 670, "nickname": "Delta" }, { "departure_month": "2000-03-01T00:00:00.000Z", "flight_count": 636, "nickname": "USAir" }, { "departure_month": "2000-03-01T00:00:00.000Z", "flight_count": 1117, "nickname": "Southwest" }, { "departure_month": "2000-03-01T00:00:00.000Z", "flight_count": 517, "nickname": "American" }, { "departure_month": "2000-03-01T00:00:00.000Z", "flight_count": 177, "nickname": "America West" }, { "departure_month": "2000-03-01T00:00:00.000Z", "flight_count": 496, "nickname": "Northwest" }, { "departure_month": "2000-03-01T00:00:00.000Z", "flight_count": 151, "nickname": "Alaska" }, { "departure_month": "2000-03-01T00:00:00.000Z", "flight_count": 356, "nickname": "United" }, { "departure_month": "2000-03-01T00:00:00.000Z", "flight_count": 132, "nickname": "Continental" }, { "departure_month": "2000-02-01T00:00:00.000Z", "flight_count": 534, "nickname": "Delta" }, { "departure_month": "2000-02-01T00:00:00.000Z", "flight_count": 565, "nickname": "USAir" }, { "departure_month": "2000-02-01T00:00:00.000Z", "flight_count": 1088, "nickname": "Southwest" }, { "departure_month": "2000-02-01T00:00:00.000Z", "flight_count": 505, "nickname": "American" }, { "departure_month": "2000-02-01T00:00:00.000Z", "flight_count": 150, "nickname": "America West" }, { "departure_month": "2000-02-01T00:00:00.000Z", "flight_count": 465, "nickname": "Northwest" }, { "departure_month": "2000-02-01T00:00:00.000Z", "flight_count": 135, "nickname": "Alaska" }, { "departure_month": "2000-02-01T00:00:00.000Z", "flight_count": 326, "nickname": "United" }, { "departure_month": "2000-02-01T00:00:00.000Z", "flight_count": 108, "nickname": "Continental" }, { "departure_month": "2000-01-01T00:00:00.000Z", "flight_count": 623, "nickname": "Delta" }, { "departure_month": "2000-01-01T00:00:00.000Z", "flight_count": 1114, "nickname": "Southwest" }, { "departure_month": "2000-01-01T00:00:00.000Z", "flight_count": 167, "nickname": "America West" }, { "departure_month": "2000-01-01T00:00:00.000Z", "flight_count": 523, "nickname": "Northwest" }, { "departure_month": "2000-01-01T00:00:00.000Z", "flight_count": 98, "nickname": "Continental" }, { "departure_month": "2000-01-01T00:00:00.000Z", "flight_count": 141, "nickname": "Alaska" }, { "departure_month": "2000-01-01T00:00:00.000Z", "flight_count": 276, "nickname": "United" }, { "departure_month": "2000-01-01T00:00:00.000Z", "flight_count": 554, "nickname": "USAir" }, { "departure_month": "2000-01-01T00:00:00.000Z", "flight_count": 524, "nickname": "American" } ]
SELECT DATE_TRUNC('month', flights."dep_time") as "departure_month", COUNT( 1) as "flight_count", carriers_0."nickname" as "nickname" FROM '../data/flights.parquet' as flights LEFT JOIN '../data/carriers.parquet' AS carriers_0 ON flights."carrier"=carriers_0."code" GROUP BY 1,3 ORDER BY 1 desc NULLS LAST
Line Charts nested in tables
When line charts are nested in tables the size is reduced. Nested line charts increase the density of information provided by the result.
run: flights -> { group_by: destination aggregate: flight_count # line_chart nest: by_month is { group_by: departure_month is dep_time.month aggregate: flight_count group_by: carriers.nickname } limit: 5 }
| destination | flight_​count | by_​month |
|---|---|---|
| ATL | 17,832 | |
| DFW | 17,776 | |
| ORD | 14,213 | |
| PHX | 12,477 | |
| LAS | 11,092 |
[ { "destination": "ATL", "flight_count":