Malloy Documentation
search

A semantic data model contains prebuilt calculations and relationships for a set of data. This article will show you the basics of querying a semantic data model in Malloy.

Let’s start simply, we'll define: dimension, measure, aggregating query, and lookup query.

Data for Kindergarteners

Given that we learn about data in Kindergarten, it is really surprising how hard it is to query data in the "big" world. In kindergarten data, we notice attributes about things, make piles of things, and count things in the piles. We do this even before we learn any "real" math. Strangely, noticing attributes about things and counting things is almost all there is to working with data.

Two types of queries, "Where's Waldo" and "Making Piles"

There are really two types of queries in the world, lookup and aggregating.

Lookup queries are pretty easy. Google search is a lookup query. To search, type in some terms then see a list of results. Searching in SQL this often looks like SELECT * FROM <something> WHERE <FILTER>.

The interesting queries, the kindergarten queries, are aggregating. Aggregating queries tell you something about a set of data. An aggregating query has two main parts, the dimensions and measures.

Dimensions are the attributes you use to decide which pile the thing goes in.

A measure is something you can say about the pile. "How many objects?", "How much does this pile weigh?", "What is the average size of an object in this pile?"

"OK class, let's take this pile of coins and separate them. How many coins are pennies? How many coins are nickels? Dimes? Quarters?"

Aggregating queries tell us things about datasets. Lookup queries find things.

SQL World

In the SQL world, the interface to your data is just that, data. The data sits in tables. Everytime, you ask a question (run a query), you need to restate all the things about the data: the calculations, the relationships between tables. The unit of reusability is a table. You can run a query that makes a new table. You can turn a query into a SQL View, which is basically a table based on a calculation.

The Semantic Data Model is the interface to your data

In a Semantic Data Model, the calculations (dimensions and measures) are reusable. The join relationships are built into the semantic data model. The calculations (common ways of looking at data) are coded into the semantic data model. The act of querying becomes simply picking dimensions and measures, filtering the data, and sorting the results. This simplification is powerful in that the calculations are always vetted, so it becomes much harder to get incorrect results.

A Simple Example

Below is a semantic data model for some flight data. For now, let's not concern ourselves with how this model is built but instead focus on how we can ask questions of the model. In the semantic model, dimensions, measures, and joined relationships are all exposed as a list of variables.

Each flight has an origin, destination and carrier. Flights can be delayed. Each flight has an aircraft that made the flight, and more. The semantic data model provides us with the dimensions (in blue), the measures (in orange), and the graph of related objects. This model is encoded in a file called ‘flights.malloy’.

document
import {flights} from 'flights.malloy' 

Step 10: We'll jump to the end with a complex example

A semantic data model lets you do complicated things simply. Shamelessly, to ensure you read the full article, I'll start with a seemingly complex example and then explain how we got here. It's actually quite simple.

The dashboard below shows flights from airports in California, where you can go, and which carriers will take you there. It shows how this has changed over time.

document
# dashboard
run: flights -> origin_name + metrics + {
  where: origin.state = 'CA'
  nest: destination_name + metrics + carrier_list + {limit: 6} 
  # bar_chart
  nest: carrier_name + flight_count
  # line_chart
  nest: dep_month + flight_count 
}
QUERY RESULTS
origin_name
LAX - LOS ANGELES
flight_count
11,077
total_distance
12,861,847
percent_of_flights
27.24%
destination_name
destination_​nameflight_​counttotal_​distancepercent_​of_​flightscl
LAS - LAS VEGAS1,073253,2289.69%Southwest, United, America West, American, Northwest, Delta
OAK - OAKLAND868292,5167.84%Southwest, United, American
PHX - PHOENIX737272,6906.65%Southwest, America West, United, American
IAD - WASHINGTON6151,407,1205.55%United, American
SEA - SEATTLE528503,7124.77%Alaska, United
ORD - CHICAGO523912,6354.72%United, American
carrier_name
SouthwestUnitedAmericanNorthwestAlaskaDeltaAmerica WestUSAirATAAmerican EagleContinentalContinental Expr…carrier_name01,0002,0003,0004,000flight_count
dep_month
200020012002200320042005dep_month100120140160180200220flight_count
origin_name
OAK - OAKLAND
flight_count
5,076
total_distance
3,472,237
percent_of_flights
12.48%
destination_name
destination_​nameflight_​counttotal_​distancepercent_​of_​flightscl
LAX - LOS ANGELES792266,90415.6%Southwest, United, American
SAN - SAN DIEGO479213,6349.44%Southwest
SEA - SEATTLE472316,7129.3%Southwest, Alaska
ONT - ONTARIO433156,3138.53%Southwest
LAS - LAS VEGAS422171,7548.31%Southwest, America West
BUR - BURBANK405131,6257.98%Southwest
carrier_name
SouthwestJetblueUnitedAlaskaAmerica WestAmericanDeltaContinentalcarrier_name01,0002,0003,0004,000flight_count
dep_month
200020012002200320042005dep_month406080100flight_count
origin_name
SAN - SAN DIEGO
flight_count
5,075
total_distance
4,691,341
percent_of_flights
12.48%
destination_name
destination_​nameflight_​counttotal_​distancepercent_​of_​flightscl
LAS - LAS VEGAS508131,06410.01%Southwest, America West
OAK - OAKLAND482214,9729.5%Southwest
PHX - PHOENIX476144,7049.38%Southwest, America West
ORD - CHICAGO468806,3649.22%United, American
SMF - SACRAMENTO428205,4408.43%Southwest
SJC - SAN JOSE423176,3918.33%Southwest, American
carrier_name
SouthwestUnitedAmericanAlaskaUSAirNorthwestDeltaAmerica WestJetblueContinentalcarrier_name05001,0001,5002,0002,5003,000flight_count
dep_month
200020012002200320042005dep_month405060708090100flight_count
origin_name
SFO - SAN FRANCISCO
flight_count
4,540
total_distance
6,391,762
percent_of_flights
11.16%
destination_name
destination_​nameflight_​counttotal_​distancepercent_​of_​flightscl
LAS - LAS VEGAS431178,4349.49%United, America West
ORD - CHICAGO362668,2527.97%United, American
LAX - LOS ANGELES318107,1667%United, American, Alaska, Delta
DFW - DALLAS-FORT WORTH304445,0566.7%American, United, Delta
MSP - MINNEAPOLIS281446,5096.19%Northwest
PHX - PHOENIX259168,6095.7%United, America West, Southwest
carrier_name
UnitedAmericanNorthwestAlaskaAmerica WestUSAirDeltaSouthwestATAContinentalcarrier_name05001,0001,5002,0002,500flight_count
dep_month
200020012002200320042005dep_month405060708090flight_count
origin_name
SJC - SAN JOSE
flight_count
3,825
total_distance
2,826,646
percent_of_flights
9.4%
destination_name
destination_​nameflight_​counttotal_​distancepercent_​of_​flightscl
LAX - LOS ANGELES475146,30012.42%Southwest, American
SEA - SEATTLE368256,4969.62%Alaska, Southwest, American
SAN - SAN DIEGO363151,3719.49%Southwest, American
PHX - PHOENIX314194,9948.21%Southwest, America West, American
LAS - LAS VEGAS303116,9587.92%Southwest, American, America West
BUR - BURBANK24071,0406.27%Southwest
carrier_name
SouthwestAmericanAlaskaUnitedAmerica WestNorthwestContinentalJetblueDeltaATAcarrier_name05001,0001,5002,000flight_count
dep_month
200020012002200320042005dep_month304050607080flight_count
origin_name
SMF - SACRAMENTO
flight_count
3,576
total_distance
2,367,376
percent_of_flights
8.79%
destination_name
destination_​nameflight_​counttotal_​distancepercent_​of_​flightscl
PHX - PHOENIX479309,91313.39%America West, Southwest
SAN - SAN DIEGO396190,08011.07%Southwest
LAX - LOS ANGELES382142,48610.68%Southwest, United
ONT - ONTARIO380147,82010.63%Southwest
LAS - LAS VEGAS327129,8199.14%Southwest, America West
BUR - BURBANK27999,8827.8%Southwest
carrier_name
SouthwestAmerica WestUnitedAmericanAlaskaNorthwestDeltaContinentalJetbluecarrier_name05001,0001,5002,0002,500flight_count
dep_month
200020012002200320042005dep_month3040506070flight_count
origin_name
ONT - ONTARIO
flight_count
2,642
total_distance
1,492,508
percent_of_flights
6.5%
destination_name
destination_​nameflight_​counttotal_​distancepercent_​of_​flightscl
PHX - PHOENIX491159,57518.58%Southwest, America West
SMF - SACRAMENTO412160,26815.59%Southwest
OAK - OAKLAND411148,37115.56%Southwest
LAS - LAS VEGAS34467,76813.02%Southwest, America West
SJC - SAN JOSE23678,5888.93%Southwest
SEA - SEATTLE145138,6205.49%Alaska
carrier_name
SouthwestAlaskaUnitedAmericanAmerica WestNorthwestJetblueDeltaContinentalContinental Expr…carrier_name05001,0001,5002,000flight_count
dep_month
200020012002200320042005dep_month2030405060flight_count
origin_name
BUR - BURBANK
flight_count
1,952
total_distance
876,479
percent_of_flights
4.8%
destination_name
destination_​nameflight_​counttotal_​distancepercent_​of_​flightscl
LAS - LAS VEGAS38886,52419.88%Southwest, America West
OAK - OAKLAND367119,27518.8%Southwest
PHX - PHOENIX357131,73318.29%Southwest, America West
SMF - SACRAMENTO26093,08013.32%Southwest
SJC - SAN JOSE20660,97610.55%Southwest
SEA - SEATTLE154144,2987.89%Alaska
carrier_name
SouthwestAlaskaAmerica WestAmericanJetblueUnitedDeltacarrier_name05001,0001,500flight_count
dep_month
200020012002200320042005dep_month1520253035404550flight_count
origin_name
SNA - SANTA ANA
flight_count
1,919
total_distance
1,377,110
percent_of_flights
4.72%
destination_name
destination_​nameflight_​counttotal_​distancepercent_​of_​flightscl
PHX - PHOENIX297100,38615.48%America West, Southwest
LAS - LAS VEGAS26058,76013.55%America West, Southwest, American, Delta
SMF - SACRAMENTO252101,80813.13%Southwest, America West
SFO - SAN FRANCISCO17765,8449.22%United, American
DEN - DENVER173146,3589.02%United
OAK - OAKLAND16059,3608.34%Southwest
carrier_name
SouthwestUnitedAmerica WestNorthwestUSAirAmericanDeltacarrier_name0100200300400500600700flight_count
dep_month
200020012002200320042005dep_month1020304050flight_count
origin_name
LGB - LONG BEACH
flight_count
661
total_distance
931,914
percent_of_flights
1.63%
destination_name
destination_​nameflight_​counttotal_​distancepercent_​of_​flightscl
JFK - NEW YORK149367,28522.54%Jetblue
OAK - OAKLAND11741,30117.7%Jetblue
DFW - DALLAS-FORT WORTH97118,34014.67%American
IAD - WASHINGTON77175,32911.65%Jetblue
LAS - LAS VEGAS5612,9368.47%Jetblue
PHX - PHOENIX5419,1708.17%America West
carrier_name
JetblueAmericanAmerica WestAlaskacarrier_name0100200300400500flight_count
dep_month
200020012002200320042005dep_month05101520253035flight_count
[
  {
    "origin_name": "LAX - LOS ANGELES",
    "flight_count": 11077,
    "total_distance": 12861847,
    "percent_of_flights": 0.2723629210720433,
    "destination_name": [
      {
        "destination_name": "LAS - LAS VEGAS",
        "flight_count": 1073,
        "total_distance": 253228,
        "percent_of_flights": 0.09686738286539677,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 556
          },
          {
            "nickname": "United",
            "flight_count": 255
          },
          {
            "nickname": "America West",
            "flight_count": 136
          },
          {
            "nickname": "American",
            "flight_count": 82
          },
          {
            "nickname": "Northwest",
            "flight_count": 35
          },
          {
            "nickname": "Delta",
            "flight_count": 9
          }
        ]
      },
      {
        "destination_name": "OAK - OAKLAND",
        "flight_count": 868,
        "total_distance": 292516,
        "percent_of_flights": 0.07836056694050736,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 821
          },
          {
            "nickname": "United",
            "flight_count": 32
          },
          {
            "nickname": "American",
            "flight_count": 15
          }
        ]
      },
      {
        "destination_name": "PHX - PHOENIX",
        "flight_count": 737,
        "total_distance": 272690,
        "percent_of_flights": 0.06653426017874876,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 552
          },
          {
            "nickname": "America West",
            "flight_count": 159
          },
          {
            "nickname": "United",
            "flight_count": 15
          },
          {
            "nickname": "American",
            "flight_count": 11
          }
        ]
      },
      {
        "destination_name": "IAD - WASHINGTON",
        "flight_count": 615,
        "total_distance": 1407120,
        "percent_of_flights": 0.05552044777466823,
        "cl": [
          {
            "nickname": "United",
            "flight_count": 330
          },
          {
            "nickname": "American",
            "flight_count": 285
          }
        ]
      },
      {
        "destination_name": "SEA - SEATTLE",
        "flight_count": 528,
        "total_distance": 503712,
        "percent_of_flights": 0.047666335650446874,
        "cl": [
          {
            "nickname": "Alaska",
            "flight_count": 418
          },
          {
            "nickname": "United",
            "flight_count": 110
          }
        ]
      },
      {
        "destination_name": "ORD - CHICAGO",
        "flight_count": 523,
        "total_distance": 912635,
        "percent_of_flights": 0.047214949896181274,
        "cl": [
          {
            "nickname": "United",
            "flight_count": 382
          },
          {
            "nickname": "American",
            "flight_count": 141
          }
        ]
      }
    ],
    "carrier_name": [
      {
        "carrier_name": "Southwest",
        "flight_count": 4282
      },
      {
        "carrier_name": "United",
        "flight_count": 2319
      },
      {
        "carrier_name": "American",
        "flight_count": 1951
      },
      {
        "carrier_name": "Northwest",
        "flight_count": 993
      },
      {
        "carrier_name": "Alaska",
        "flight_count": 695
      },
      {
        "carrier_name": "Delta",
        "flight_count": 343
      },
      {
        "carrier_name": "America West",
        "flight_count": 295
      },
      {
        "carrier_name": "USAir",
        "flight_count": 135
      },
      {
        "carrier_name": "ATA",
        "flight_count": 32
      },
      {
        "carrier_name": "American Eagle",
        "flight_count": 25
      },
      {
        "carrier_name": "Continental",
        "flight_count": 6
      },
      {
        "carrier_name": "Continental Express",
        "flight_count": 1
      }
    ],
    "dep_month": [
      {
        "dep_month": "2005-12-01T00:00:00.000Z",
        "flight_count": 165
      },
      {
        "dep_month": "2005-11-01T00:00:00.000Z",
        "flight_count": 182
      },
      {
        "dep_month": "2005-10-01T00:00:00.000Z",
        "flight_count": 163
      },
      {
        "dep_month": "2005-09-01T00:00:00.000Z",
        "flight_count": 154
      },
      {
        "dep_month": "2005-08-01T00:00:00.000Z",
        "flight_count": 171
      },
      {
        "dep_month": "2005-07-01T00:00:00.000Z",
        "flight_count": 175
      },
      {
        "dep_month": "2005-06-01T00:00:00.000Z",
        "flight_count": 148
      },
      {
        "dep_month": "2005-05-01T00:00:00.000Z",
        "flight_count": 138
      },
      {
        "dep_month": "2005-04-01T00:00:00.000Z",
        "flight_count": 146
      },
      {
        "dep_month": "2005-03-01T00:00:00.000Z",
        "flight_count": 139
      },
      {
        "dep_month": "2005-02-01T00:00:00.000Z",
        "flight_count": 124
      },
      {
        "dep_month": "2005-01-01T00:00:00.000Z",
        "flight_count": 146
      },
      {
        "dep_month": "2004-12-01T00:00:00.000Z",
        "flight_count": 127
      },
      {
        "dep_month": "2004-11-01T00:00:00.000Z",
        "flight_count": 169
      },
      {
        "dep_month": "2004-10-01T00:00:00.000Z",
        "flight_count": 152
      },
      {
        "dep_month": "2004-09-01T00:00:00.000Z",
        "flight_count": 157
      },
      {
        "dep_month": "2004-08-01T00:00:00.000Z",
        "flight_count": 136
      },
      {
        "dep_month": "2004-07-01T00:00:00.000Z",
        "flight_count": 153
      },
      {
        "dep_month": "2004-06-01T00:00:00.000Z",
        "flight_count": 163
      },
      {
        "dep_month": "2004-05-01T00:00:00.000Z",
        "flight_count": 133
      },
      {
        "dep_month": "2004-04-01T00:00:00.000Z",
        "flight_count": 140
      },
      {
        "dep_month": "2004-03-01T00:00:00.000Z",
        "flight_count": 144
      },
      {
        "dep_month": "2004-02-01T00:00:00.000Z",
        "flight_count": 139
      },
      {
        "dep_month": "2004-01-01T00:00:00.000Z",
        "flight_count": 126
      },
      {
        "dep_month": "2003-12-01T00:00:00.000Z",
        "flight_count": 142
      },
      {
        "dep_month": "2003-11-01T00:00:00.000Z",
        "flight_count": 135
      },
      {
        "dep_month": "2003-10-01T00:00:00.000Z",
        "flight_count": 131
      },
      {
        "dep_month": "2003-09-01T00:00:00.000Z",
        "flight_count": 141
      },
      {
        "dep_month": "2003-08-01T00:00:00.000Z",
        "flight_count": 151
      },
      {
        "dep_month": "2003-07-01T00:00:00.000Z",
        "flight_count": 137
      },
      {
        "dep_month": "2003-06-01T00:00:00.000Z",
        "flight_count": 135
      },
      {
        "dep_month": "2003-05-01T00:00:00.000Z",
        "flight_count": 157
      },
      {
        "dep_month": "2003-04-01T00:00:00.000Z",
        "flight_count": 162
      },
      {
        "dep_month": "2003-03-01T00:00:00.000Z",
        "flight_count": 152
      },
      {
        "dep_month": "2003-02-01T00:00:00.000Z",
        "flight_count": 173
      },
      {
        "dep_month": "2003-01-01T00:00:00.000Z",
        "flight_count": 180
      },
      {
        "dep_month": "2002-12-01T00:00:00.000Z",
        "flight_count": 164
      },
      {
        "dep_month": "2002-11-01T00:00:00.000Z",
        "flight_count": 154
      },
      {
        "dep_month": "2002-10-01T00:00:00.000Z",
        "flight_count": 160
      },
      {
        "dep_month": "2002-09-01T00:00:00.000Z",
        "flight_count": 164
      },
      {
        "dep_month": "2002-08-01T00:00:00.000Z",
        "flight_count": 172
      },
      {
        "dep_month": "2002-07-01T00:00:00.000Z",
        "flight_count": 132
      },
      {
        "dep_month": "2002-06-01T00:00:00.000Z",
        "flight_count": 166
      },
      {
        "dep_month": "2002-05-01T00:00:00.000Z",
        "flight_count": 140
      },
      {
        "dep_month": "2002-04-01T00:00:00.000Z",
        "flight_count": 105
      },
      {
        "dep_month": "2002-03-01T00:00:00.000Z",
        "flight_count": 130
      },
      {
        "dep_month": "2002-02-01T00:00:00.000Z",
        "flight_count": 129
      },
      {
        "dep_month": "2002-01-01T00:00:00.000Z",
        "flight_count": 125
      },
      {
        "dep_month": "2001-12-01T00:00:00.000Z",
        "flight_count": 141
      },
      {
        "dep_month": "2001-11-01T00:00:00.000Z",
        "flight_count": 124
      },
      {
        "dep_month": "2001-10-01T00:00:00.000Z",
        "flight_count": 142
      },
      {
        "dep_month": "2001-09-01T00:00:00.000Z",
        "flight_count": 135
      },
      {
        "dep_month": "2001-08-01T00:00:00.000Z",
        "flight_count": 169
      },
      {
        "dep_month": "2001-07-01T00:00:00.000Z",
        "flight_count": 136
      },
      {
        "dep_month": "2001-06-01T00:00:00.000Z",
        "flight_count": 160
      },
      {
        "dep_month": "2001-05-01T00:00:00.000Z",
        "flight_count": 159
      },
      {
        "dep_month": "2001-04-01T00:00:00.000Z",
        "flight_count": 174
      },
      {
        "dep_month": "2001-03-01T00:00:00.000Z",
        "flight_count": 152
      },
      {
        "dep_month": "2001-02-01T00:00:00.000Z",
        "flight_count": 161
      },
      {
        "dep_month": "2001-01-01T00:00:00.000Z",
        "flight_count": 168
      },
      {
        "dep_month": "2000-12-01T00:00:00.000Z",
        "flight_count": 156
      },
      {
        "dep_month": "2000-11-01T00:00:00.000Z",
        "flight_count": 160
      },
      {
        "dep_month": "2000-10-01T00:00:00.000Z",
        "flight_count": 172
      },
      {
        "dep_month": "2000-09-01T00:00:00.000Z",
        "flight_count": 156
      },
      {
        "dep_month": "2000-08-01T00:00:00.000Z",
        "flight_count": 221
      },
      {
        "dep_month": "2000-07-01T00:00:00.000Z",
        "flight_count": 180
      },
      {
        "dep_month": "2000-06-01T00:00:00.000Z",
        "flight_count": 155
      },
      {
        "dep_month": "2000-05-01T00:00:00.000Z",
        "flight_count": 183
      },
      {
        "dep_month": "2000-04-01T00:00:00.000Z",
        "flight_count": 172
      },
      {
        "dep_month": "2000-03-01T00:00:00.000Z",
        "flight_count": 196
      },
      {
        "dep_month": "2000-02-01T00:00:00.000Z",
        "flight_count": 189
      },
      {
        "dep_month": "2000-01-01T00:00:00.000Z",
        "flight_count": 189
      }
    ]
  },
  {
    "origin_name": "OAK - OAKLAND",
    "flight_count": 5076,
    "total_distance": 3472237,
    "percent_of_flights": 0.12480944184902877,
    "destination_name": [
      {
        "destination_name": "LAX - LOS ANGELES",
        "flight_count": 792,
        "total_distance": 266904,
        "percent_of_flights": 0.15602836879432624,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 745
          },
          {
            "nickname": "United",
            "flight_count": 36
          },
          {
            "nickname": "American",
            "flight_count": 11
          }
        ]
      },
      {
        "destination_name": "SAN - SAN DIEGO",
        "flight_count": 479,
        "total_distance": 213634,
        "percent_of_flights": 0.09436564223798266,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 479
          }
        ]
      },
      {
        "destination_name": "SEA - SEATTLE",
        "flight_count": 472,
        "total_distance": 316712,
        "percent_of_flights": 0.09298660362490149,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 271
          },
          {
            "nickname": "Alaska",
            "flight_count": 201
          }
        ]
      },
      {
        "destination_name": "ONT - ONTARIO",
        "flight_count": 433,
        "total_distance": 156313,
        "percent_of_flights": 0.08530338849487785,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 433
          }
        ]
      },
      {
        "destination_name": "LAS - LAS VEGAS",
        "flight_count": 422,
        "total_distance": 171754,
        "percent_of_flights": 0.08313632781717888,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 382
          },
          {
            "nickname": "America West",
            "flight_count": 40
          }
        ]
      },
      {
        "destination_name": "BUR - BURBANK",
        "flight_count": 405,
        "total_distance": 131625,
        "percent_of_flights": 0.0797872340425532,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 405
          }
        ]
      }
    ],
    "carrier_name": [
      {
        "carrier_name": "Southwest",
        "flight_count": 3964
      },
      {
        "carrier_name": "Jetblue",
        "flight_count": 297
      },
      {
        "carrier_name": "United",
        "flight_count": 249
      },
      {
        "carrier_name": "Alaska",
        "flight_count": 245
      },
      {
        "carrier_name": "America West",
        "flight_count": 164
      },
      {
        "carrier_name": "American",
        "flight_count": 139
      },
      {
        "carrier_name": "Delta",
        "flight_count": 10
      },
      {
        "carrier_name": "Continental",
        "flight_count": 8
      }
    ],
    "dep_month": [
      {
        "dep_month": "2005-12-01T00:00:00.000Z",
        "flight_count": 91
      },
      {
        "dep_month": "2005-11-01T00:00:00.000Z",
        "flight_count": 87
      },
      {
        "dep_month": "2005-10-01T00:00:00.000Z",
        "flight_count": 100
      },
      {
        "dep_month": "2005-09-01T00:00:00.000Z",
        "flight_count": 88
      },
      {
        "dep_month": "2005-08-01T00:00:00.000Z",
        "flight_count": 88
      },
      {
        "dep_month": "2005-07-01T00:00:00.000Z",
        "flight_count": 98
      },
      {
        "dep_month": "2005-06-01T00:00:00.000Z",
        "flight_count": 83
      },
      {
        "dep_month": "2005-05-01T00:00:00.000Z",
        "flight_count": 79
      },
      {
        "dep_month": "2005-04-01T00:00:00.000Z",
        "flight_count": 85
      },
      {
        "dep_month": "2005-03-01T00:00:00.000Z",
        "flight_count": 82
      },
      {
        "dep_month": "2005-02-01T00:00:00.000Z",
        "flight_count": 77
      },
      {
        "dep_month": "2005-01-01T00:00:00.000Z",
        "flight_count": 76
      },
      {
        "dep_month": "2004-12-01T00:00:00.000Z",
        "flight_count": 76
      },
      {
        "dep_month": "2004-11-01T00:00:00.000Z",
        "flight_count": 68
      },
      {
        "dep_month": "2004-10-01T00:00:00.000Z",
        "flight_count": 98
      },
      {
        "dep_month": "2004-09-01T00:00:00.000Z",
        "flight_count": 91
      },
      {
        "dep_month": "2004-08-01T00:00:00.000Z",
        "flight_count": 93
      },
      {
        "dep_month": "2004-07-01T00:00:00.000Z",
        "flight_count": 62
      },
      {
        "dep_month": "2004-06-01T00:00:00.000Z",
        "flight_count": 62
      },
      {
        "dep_month": "2004-05-01T00:00:00.000Z",
        "flight_count": 73
      },
      {
        "dep_month": "2004-04-01T00:00:00.000Z",
        "flight_count": 88
      },
      {
        "dep_month": "2004-03-01T00:00:00.000Z",
        "flight_count": 66
      },
      {
        "dep_month": "2004-02-01T00:00:00.000Z",
        "flight_count": 75
      },
      {
        "dep_month": "2004-01-01T00:00:00.000Z",
        "flight_count": 64
      },
      {
        "dep_month": "2003-12-01T00:00:00.000Z",
        "flight_count": 79
      },
      {
        "dep_month": "2003-11-01T00:00:00.000Z",
        "flight_count": 84
      },
      {
        "dep_month": "2003-10-01T00:00:00.000Z",
        "flight_count": 85
      },
      {
        "dep_month": "2003-09-01T00:00:00.000Z",
        "flight_count": 92
      },
      {
        "dep_month": "2003-08-01T00:00:00.000Z",
        "flight_count": 77
      },
      {
        "dep_month": "2003-07-01T00:00:00.000Z",
        "flight_count": 93
      },
      {
        "dep_month": "2003-06-01T00:00:00.000Z",
        "flight_count": 70
      },
      {
        "dep_month": "2003-05-01T00:00:00.000Z",
        "flight_count": 84
      },
      {
        "dep_month": "2003-04-01T00:00:00.000Z",
        "flight_count": 86
      },
      {
        "dep_month": "2003-03-01T00:00:00.000Z",
        "flight_count": 72
      },
      {
        "dep_month": "2003-02-01T00:00:00.000Z",
        "flight_count": 69
      },
      {
        "dep_month": "2003-01-01T00:00:00.000Z",
        "flight_count": 101
      },
      {
        "dep_month": "2002-12-01T00:00:00.000Z",
        "flight_count": 70
      },
      {
        "dep_month": "2002-11-01T00:00:00.000Z",
        "flight_count": 70
      },
      {
        "dep_month": "2002-10-01T00:00:00.000Z",
        "flight_count": 56
      },
      {
        "dep_month": "2002-09-01T00:00:00.000Z",
        "flight_count": 60
      },
      {
        "dep_month": "2002-08-01T00:00:00.000Z",
        "flight_count": 66
      },
      {
        "dep_month": "2002-07-01T00:00:00.000Z",
        "flight_count": 61
      },
      {
        "dep_month": "2002-06-01T00:00:00.000Z",
        "flight_count": 55
      },
      {
        "dep_month": "2002-05-01T00:00:00.000Z",
        "flight_count": 69
      },
      {
        "dep_month": "2002-04-01T00:00:00.000Z",
        "flight_count": 63
      },
      {
        "dep_month": "2002-03-01T00:00:00.000Z",
        "flight_count": 50
      },
      {
        "dep_month": "2002-02-01T00:00:00.000Z",
        "flight_count": 55
      },
      {
        "dep_month": "2002-01-01T00:00:00.000Z",
        "flight_count": 81
      },
      {
        "dep_month": "2001-12-01T00:00:00.000Z",
        "flight_count": 70
      },
      {
        "dep_month": "2001-11-01T00:00:00.000Z",
        "flight_count": 69
      },
      {
        "dep_month": "2001-10-01T00:00:00.000Z",
        "flight_count": 65
      },
      {
        "dep_month": "2001-09-01T00:00:00.000Z",
        "flight_count": 63
      },
      {
        "dep_month": "2001-08-01T00:00:00.000Z",
        "flight_count": 58
      },
      {
        "dep_month": "2001-07-01T00:00:00.000Z",
        "flight_count": 65
      },
      {
        "dep_month": "2001-06-01T00:00:00.000Z",
        "flight_count": 47
      },
      {
        "dep_month": "2001-05-01T00:00:00.000Z",
        "flight_count": 54
      },
      {
        "dep_month": "2001-04-01T00:00:00.000Z",
        "flight_count": 53
      },
      {
        "dep_month": "2001-03-01T00:00:00.000Z",
        "flight_count": 33
      },
      {
        "dep_month": "2001-02-01T00:00:00.000Z",
        "flight_count": 57
      },
      {
        "dep_month": "2001-01-01T00:00:00.000Z",
        "flight_count": 80
      },
      {
        "dep_month": "2000-12-01T00:00:00.000Z",
        "flight_count": 57
      },
      {
        "dep_month": "2000-11-01T00:00:00.000Z",
        "flight_count": 43
      },
      {
        "dep_month": "2000-10-01T00:00:00.000Z",
        "flight_count": 70
      },
      {
        "dep_month": "2000-09-01T00:00:00.000Z",
        "flight_count": 54
      },
      {
        "dep_month": "2000-08-01T00:00:00.000Z",
        "flight_count": 53
      },
      {
        "dep_month": "2000-07-01T00:00:00.000Z",
        "flight_count": 49
      },
      {
        "dep_month": "2000-06-01T00:00:00.000Z",
        "flight_count": 51
      },
      {
        "dep_month": "2000-05-01T00:00:00.000Z",
        "flight_count": 70
      },
      {
        "dep_month": "2000-04-01T00:00:00.000Z",
        "flight_count": 45
      },
      {
        "dep_month": "2000-03-01T00:00:00.000Z",
        "flight_count": 52
      },
      {
        "dep_month": "2000-02-01T00:00:00.000Z",
        "flight_count": 63
      },
      {
        "dep_month": "2000-01-01T00:00:00.000Z",
        "flight_count": 57
      }
    ]
  },
  {
    "origin_name": "SAN - SAN DIEGO",
    "flight_count": 5075,
    "total_distance": 4691341,
    "percent_of_flights": 0.12478485370051635,
    "destination_name": [
      {
        "destination_name": "LAS - LAS VEGAS",
        "flight_count": 508,
        "total_distance": 131064,
        "percent_of_flights": 0.10009852216748769,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 470
          },
          {
            "nickname": "America West",
            "flight_count": 38
          }
        ]
      },
      {
        "destination_name": "OAK - OAKLAND",
        "flight_count": 482,
        "total_distance": 214972,
        "percent_of_flights": 0.09497536945812808,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 482
          }
        ]
      },
      {
        "destination_name": "PHX - PHOENIX",
        "flight_count": 476,
        "total_distance": 144704,
        "percent_of_flights": 0.09379310344827586,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 400
          },
          {
            "nickname": "America West",
            "flight_count": 76
          }
        ]
      },
      {
        "destination_name": "ORD - CHICAGO",
        "flight_count": 468,
        "total_distance": 806364,
        "percent_of_flights": 0.09221674876847291,
        "cl": [
          {
            "nickname": "United",
            "flight_count": 251
          },
          {
            "nickname": "American",
            "flight_count": 217
          }
        ]
      },
      {
        "destination_name": "SMF - SACRAMENTO",
        "flight_count": 428,
        "total_distance": 205440,
        "percent_of_flights": 0.08433497536945812,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 428
          }
        ]
      },
      {
        "destination_name": "SJC - SAN JOSE",
        "flight_count": 423,
        "total_distance": 176391,
        "percent_of_flights": 0.08334975369458128,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 366
          },
          {
            "nickname": "American",
            "flight_count": 57
          }
        ]
      }
    ],
    "carrier_name": [
      {
        "carrier_name": "Southwest",
        "flight_count": 2865
      },
      {
        "carrier_name": "United",
        "flight_count": 641
      },
      {
        "carrier_name": "American",
        "flight_count": 589
      },
      {
        "carrier_name": "Alaska",
        "flight_count": 389
      },
      {
        "carrier_name": "USAir",
        "flight_count": 145
      },
      {
        "carrier_name": "Northwest",
        "flight_count": 138
      },
      {
        "carrier_name": "Delta",
        "flight_count": 135
      },
      {
        "carrier_name": "America West",
        "flight_count": 114
      },
      {
        "carrier_name": "Jetblue",
        "flight_count": 56
      },
      {
        "carrier_name": "Continental",
        "flight_count": 3
      }
    ],
    "dep_month": [
      {
        "dep_month": "2005-12-01T00:00:00.000Z",
        "flight_count": 89
      },
      {
        "dep_month": "2005-11-01T00:00:00.000Z",
        "flight_count": 63
      },
      {
        "dep_month": "2005-10-01T00:00:00.000Z",
        "flight_count": 76
      },
      {
        "dep_month": "2005-09-01T00:00:00.000Z",
        "flight_count": 62
      },
      {
        "dep_month": "2005-08-01T00:00:00.000Z",
        "flight_count": 69
      },
      {
        "dep_month": "2005-07-01T00:00:00.000Z",
        "flight_count": 98
      },
      {
        "dep_month": "2005-06-01T00:00:00.000Z",
        "flight_count": 75
      },
      {
        "dep_month": "2005-05-01T00:00:00.000Z",
        "flight_count": 65
      },
      {
        "dep_month": "2005-04-01T00:00:00.000Z",
        "flight_count": 75
      },
      {
        "dep_month": "2005-03-01T00:00:00.000Z",
        "flight_count": 88
      },
      {
        "dep_month": "2005-02-01T00:00:00.000Z",
        "flight_count": 69
      },
      {
        "dep_month": "2005-01-01T00:00:00.000Z",
        "flight_count": 76
      },
      {
        "dep_month": "2004-12-01T00:00:00.000Z",
        "flight_count": 90
      },
      {
        "dep_month": "2004-11-01T00:00:00.000Z",
        "flight_count": 57
      },
      {
        "dep_month": "2004-10-01T00:00:00.000Z",
        "flight_count": 72
      },
      {
        "dep_month": "2004-09-01T00:00:00.000Z",
        "flight_count": 72
      },
      {
        "dep_month": "2004-08-01T00:00:00.000Z",
        "flight_count": 73
      },
      {
        "dep_month": "2004-07-01T00:00:00.000Z",
        "flight_count": 53
      },
      {
        "dep_month": "2004-06-01T00:00:00.000Z",
        "flight_count": 65
      },
      {
        "dep_month": "2004-05-01T00:00:00.000Z",
        "flight_count": 83
      },
      {
        "dep_month": "2004-04-01T00:00:00.000Z",
        "flight_count": 76
      },
      {
        "dep_month": "2004-03-01T00:00:00.000Z",
        "flight_count": 67
      },
      {
        "dep_month": "2004-02-01T00:00:00.000Z",
        "flight_count": 72
      },
      {
        "dep_month": "2004-01-01T00:00:00.000Z",
        "flight_count": 71
      },
      {
        "dep_month": "2003-12-01T00:00:00.000Z",
        "flight_count": 80
      },
      {
        "dep_month": "2003-11-01T00:00:00.000Z",
        "flight_count": 82
      },
      {
        "dep_month": "2003-10-01T00:00:00.000Z",
        "flight_count": 70
      },
      {
        "dep_month": "2003-09-01T00:00:00.000Z",
        "flight_count": 85
      },
      {
        "dep_month": "2003-08-01T00:00:00.000Z",
        "flight_count": 75
      },
      {
        "dep_month": "2003-07-01T00:00:00.000Z",
        "flight_count": 80
      },
      {
        "dep_month": "2003-06-01T00:00:00.000Z",
        "flight_count": 75
      },
      {
        "dep_month": "2003-05-01T00:00:00.000Z",
        "flight_count": 65
      },
      {
        "dep_month": "2003-04-01T00:00:00.000Z",
        "flight_count": 57
      },
      {
        "dep_month": "2003-03-01T00:00:00.000Z",
        "flight_count": 59
      },
      {
        "dep_month": "2003-02-01T00:00:00.000Z",
        "flight_count": 46
      },
      {
        "dep_month": "2003-01-01T00:00:00.000Z",
        "flight_count": 81
      },
      {
        "dep_month": "2002-12-01T00:00:00.000Z",
        "flight_count": 93
      },
      {
        "dep_month": "2002-11-01T00:00:00.000Z",
        "flight_count": 63
      },
      {
        "dep_month": "2002-10-01T00:00:00.000Z",
        "flight_count": 86
      },
      {
        "dep_month": "2002-09-01T00:00:00.000Z",
        "flight_count": 58
      },
      {
        "dep_month": "2002-08-01T00:00:00.000Z",
        "flight_count": 93
      },
      {
        "dep_month": "2002-07-01T00:00:00.000Z",
        "flight_count": 66
      },
      {
        "dep_month": "2002-06-01T00:00:00.000Z",
        "flight_count": 73
      },
      {
        "dep_month": "2002-05-01T00:00:00.000Z",
        "flight_count": 82
      },
      {
        "dep_month": "2002-04-01T00:00:00.000Z",
        "flight_count": 67
      },
      {
        "dep_month": "2002-03-01T00:00:00.000Z",
        "flight_count": 60
      },
      {
        "dep_month": "2002-02-01T00:00:00.000Z",
        "flight_count": 54
      },
      {
        "dep_month": "2002-01-01T00:00:00.000Z",
        "flight_count": 77
      },
      {
        "dep_month": "2001-12-01T00:00:00.000Z",
        "flight_count": 79
      },
      {
        "dep_month": "2001-11-01T00:00:00.000Z",
        "flight_count": 72
      },
      {
        "dep_month": "2001-10-01T00:00:00.000Z",
        "flight_count": 64
      },
      {
        "dep_month": "2001-09-01T00:00:00.000Z",
        "flight_count": 61
      },
      {
        "dep_month": "2001-08-01T00:00:00.000Z",
        "flight_count": 87
      },
      {
        "dep_month": "2001-07-01T00:00:00.000Z",
        "flight_count": 67
      },
      {
        "dep_month": "2001-06-01T00:00:00.000Z",
        "flight_count": 73
      },
      {
        "dep_month": "2001-05-01T00:00:00.000Z",
        "flight_count": 68
      },
      {
        "dep_month": "2001-04-01T00:00:00.000Z",
        "flight_count": 67
      },
      {
        "dep_month": "2001-03-01T00:00:00.000Z",
        "flight_count": 44
      },
      {
        "dep_month": "2001-02-01T00:00:00.000Z",
        "flight_count": 63
      },
      {
        "dep_month": "2001-01-01T00:00:00.000Z",
        "flight_count": 71
      },
      {
        "dep_month": "2000-12-01T00:00:00.000Z",
        "flight_count": 70
      },
      {
        "dep_month": "2000-11-01T00:00:00.000Z",
        "flight_count": 69
      },
      {
        "dep_month": "2000-10-01T00:00:00.000Z",
        "flight_count": 58
      },
      {
        "dep_month": "2000-09-01T00:00:00.000Z",
        "flight_count": 68
      },
      {
        "dep_month": "2000-08-01T00:00:00.000Z",
        "flight_count": 76
      },
      {
        "dep_month": "2000-07-01T00:00:00.000Z",
        "flight_count": 70
      },
      {
        "dep_month": "2000-06-01T00:00:00.000Z",
        "flight_count": 71
      },
      {
        "dep_month": "2000-05-01T00:00:00.000Z",
        "flight_count": 61
      },
      {
        "dep_month": "2000-04-01T00:00:00.000Z",
        "flight_count": 71
      },
      {
        "dep_month": "2000-03-01T00:00:00.000Z",
        "flight_count": 53
      },
      {
        "dep_month": "2000-02-01T00:00:00.000Z",
        "flight_count": 51
      },
      {
        "dep_month": "2000-01-01T00:00:00.000Z",
        "flight_count": 58
      }
    ]
  },
  {
    "origin_name": "SFO - SAN FRANCISCO",
    "flight_count": 4540,
    "total_distance": 6391762,
    "percent_of_flights": 0.11163019424637324,
    "destination_name": [
      {
        "destination_name": "LAS - LAS VEGAS",
        "flight_count": 431,
        "total_distance": 178434,
        "percent_of_flights": 0.09493392070484581,
        "cl": [
          {
            "nickname": "United",
            "flight_count": 299
          },
          {
            "nickname": "America West",
            "flight_count": 132
          }
        ]
      },
      {
        "destination_name": "ORD - CHICAGO",
        "flight_count": 362,
        "total_distance": 668252,
        "percent_of_flights": 0.07973568281938326,
        "cl": [
          {
            "nickname": "United",
            "flight_count": 282
          },
          {
            "nickname": "American",
            "flight_count": 80
          }
        ]
      },
      {
        "destination_name": "LAX - LOS ANGELES",
        "flight_count": 318,
        "total_distance": 107166,
        "percent_of_flights": 0.07004405286343612,
        "cl": [
          {
            "nickname": "United",
            "flight_count": 182
          },
          {
            "nickname": "American",
            "flight_count": 93
          },
          {
            "nickname": "Alaska",
            "flight_count": 40
          },
          {
            "nickname": "Delta",
            "flight_count": 3
          }
        ]
      },
      {
        "destination_name": "DFW - DALLAS-FORT WORTH",
        "flight_count": 304,
        "total_distance": 445056,
        "percent_of_flights": 0.06696035242290749,
        "cl": [
          {
            "nickname": "American",
            "flight_count": 252
          },
          {
            "nickname": "United",
            "flight_count": 50
          },
          {
            "nickname": "Delta",
            "flight_count": 2
          }
        ]
      },
      {
        "destination_name": "MSP - MINNEAPOLIS",
        "flight_count": 281,
        "total_distance": 446509,
        "percent_of_flights": 0.0618942731277533,
        "cl": [
          {
            "nickname": "Northwest",
            "flight_count": 281
          }
        ]
      },
      {
        "destination_name": "PHX - PHOENIX",
        "flight_count": 259,
        "total_distance": 168609,
        "percent_of_flights": 0.057048458149779734,
        "cl": [
          {
            "nickname": "United",
            "flight_count": 140
          },
          {
            "nickname": "America West",
            "flight_count": 78
          },
          {
            "nickname": "Southwest",
            "flight_count": 41
          }
        ]
      }
    ],
    "carrier_name": [
      {
        "carrier_name": "United",
        "flight_count": 2464
      },
      {
        "carrier_name": "American",
        "flight_count": 688
      },
      {
        "carrier_name": "Northwest",
        "flight_count": 522
      },
      {
        "carrier_name": "Alaska",
        "flight_count": 221
      },
      {
        "carrier_name": "America West",
        "flight_count": 210
      },
      {
        "carrier_name": "USAir",
        "flight_count": 157
      },
      {
        "carrier_name": "Delta",
        "flight_count": 134
      },
      {
        "carrier_name": "Southwest",
        "flight_count": 86
      },
      {
        "carrier_name": "ATA",
        "flight_count": 37
      },
      {
        "carrier_name": "Continental",
        "flight_count": 21
      }
    ],
    "dep_month": [
      {
        "dep_month": "2005-12-01T00:00:00.000Z",
        "flight_count": 84
      },
      {
        "dep_month": "2005-11-01T00:00:00.000Z",
        "flight_count": 92
      },
      {
        "dep_month": "2005-10-01T00:00:00.000Z",
        "flight_count": 95
      },
      {
        "dep_month": "2005-09-01T00:00:00.000Z",
        "flight_count": 79
      },
      {
        "dep_month": "2005-08-01T00:00:00.000Z",
        "flight_count": 74
      },
      {
        "dep_month": "2005-07-01T00:00:00.000Z",
        "flight_count": 92
      },
      {
        "dep_month": "2005-06-01T00:00:00.000Z",
        "flight_count": 86
      },
      {
        "dep_month": "2005-05-01T00:00:00.000Z",
        "flight_count": 70
      },
      {
        "dep_month": "2005-04-01T00:00:00.000Z",
        "flight_count": 81
      },
      {
        "dep_month": "2005-03-01T00:00:00.000Z",
        "flight_count": 74
      },
      {
        "dep_month": "2005-02-01T00:00:00.000Z",
        "flight_count": 70
      },
      {
        "dep_month": "2005-01-01T00:00:00.000Z",
        "flight_count": 75
      },
      {
        "dep_month": "2004-12-01T00:00:00.000Z",
        "flight_count": 86
      },
      {
        "dep_month": "2004-11-01T00:00:00.000Z",
        "flight_count": 75
      },
      {
        "dep_month": "2004-10-01T00:00:00.000Z",
        "flight_count": 77
      },
      {
        "dep_month": "2004-09-01T00:00:00.000Z",
        "flight_count": 63
      },
      {
        "dep_month": "2004-08-01T00:00:00.000Z",
        "flight_count": 71
      },
      {
        "dep_month": "2004-07-01T00:00:00.000Z",
        "flight_count": 62
      },
      {
        "dep_month": "2004-06-01T00:00:00.000Z",
        "flight_count": 74
      },
      {
        "dep_month": "2004-05-01T00:00:00.000Z",
        "flight_count": 78
      },
      {
        "dep_month": "2004-04-01T00:00:00.000Z",
        "flight_count": 68
      },
      {
        "dep_month": "2004-03-01T00:00:00.000Z",
        "flight_count": 68
      },
      {
        "dep_month": "2004-02-01T00:00:00.000Z",
        "flight_count": 62
      },
      {
        "dep_month": "2004-01-01T00:00:00.000Z",
        "flight_count": 59
      },
      {
        "dep_month": "2003-12-01T00:00:00.000Z",
        "flight_count": 62
      },
      {
        "dep_month": "2003-11-01T00:00:00.000Z",
        "flight_count": 54
      },
      {
        "dep_month": "2003-10-01T00:00:00.000Z",
        "flight_count": 45
      },
      {
        "dep_month": "2003-09-01T00:00:00.000Z",
        "flight_count": 64
      },
      {
        "dep_month": "2003-08-01T00:00:00.000Z",
        "flight_count": 69
      },
      {
        "dep_month": "2003-07-01T00:00:00.000Z",
        "flight_count": 59
      },
      {
        "dep_month": "2003-06-01T00:00:00.000Z",
        "flight_count": 40
      },
      {
        "dep_month": "2003-05-01T00:00:00.000Z",
        "flight_count": 49
      },
      {
        "dep_month": "2003-04-01T00:00:00.000Z",
        "flight_count": 46
      },
      {
        "dep_month": "2003-03-01T00:00:00.000Z",
        "flight_count": 47
      },
      {
        "dep_month": "2003-02-01T00:00:00.000Z",
        "flight_count": 50
      },
      {
        "dep_month": "2003-01-01T00:00:00.000Z",
        "flight_count": 58
      },
      {
        "dep_month": "2002-12-01T00:00:00.000Z",
        "flight_count": 49
      },
      {
        "dep_month": "2002-11-01T00:00:00.000Z",
        "flight_count": 48
      },
      {
        "dep_month": "2002-10-01T00:00:00.000Z",
        "flight_count": 59
      },
      {
        "dep_month": "2002-09-01T00:00:00.000Z",
        "flight_count": 56
      },
      {
        "dep_month": "2002-08-01T00:00:00.000Z",
        "flight_count": 55
      },
      {
        "dep_month": "2002-07-01T00:00:00.000Z",
        "flight_count": 63
      },
      {
        "dep_month": "2002-06-01T00:00:00.000Z",
        "flight_count": 65
      },
      {
        "dep_month": "2002-05-01T00:00:00.000Z",
        "flight_count": 59
      },
      {
        "dep_month": "2002-04-01T00:00:00.000Z",
        "flight_count": 58
      },
      {
        "dep_month": "2002-03-01T00:00:00.000Z",
        "flight_count": 45
      },
      {
        "dep_month": "2002-02-01T00:00:00.000Z",
        "flight_count": 58
      },
      {
        "dep_month": "2002-01-01T00:00:00.000Z",
        "flight_count": 43
      },
      {
        "dep_month": "2001-12-01T00:00:00.000Z",
        "flight_count": 51
      },
      {
        "dep_month": "2001-11-01T00:00:00.000Z",
        "flight_count": 70
      },
      {
        "dep_month": "2001-10-01T00:00:00.000Z",
        "flight_count": 66
      },
      {
        "dep_month": "2001-09-01T00:00:00.000Z",
        "flight_count": 55
      },
      {
        "dep_month": "2001-08-01T00:00:00.000Z",
        "flight_count": 55
      },
      {
        "dep_month": "2001-07-01T00:00:00.000Z",
        "flight_count": 78
      },
      {
        "dep_month": "2001-06-01T00:00:00.000Z",
        "flight_count": 69
      },
      {
        "dep_month": "2001-05-01T00:00:00.000Z",
        "flight_count": 65
      },
      {
        "dep_month": "2001-04-01T00:00:00.000Z",
        "flight_count": 58
      },
      {
        "dep_month": "2001-03-01T00:00:00.000Z",
        "flight_count": 69
      },
      {
        "dep_month": "2001-02-01T00:00:00.000Z",
        "flight_count": 51
      },
      {
        "dep_month": "2001-01-01T00:00:00.000Z",
        "flight_count": 51
      },
      {
        "dep_month": "2000-12-01T00:00:00.000Z",
        "flight_count": 40
      },
      {
        "dep_month": "2000-11-01T00:00:00.000Z",
        "flight_count": 58
      },
      {
        "dep_month": "2000-10-01T00:00:00.000Z",
        "flight_count": 54
      },
      {
        "dep_month": "2000-09-01T00:00:00.000Z",
        "flight_count": 46
      },
      {
        "dep_month": "2000-08-01T00:00:00.000Z",
        "flight_count": 61
      },
      {
        "dep_month": "2000-07-01T00:00:00.000Z",
        "flight_count": 62
      },
      {
        "dep_month": "2000-06-01T00:00:00.000Z",
        "flight_count": 55
      },
      {
        "dep_month": "2000-05-01T00:00:00.000Z",
        "flight_count": 73
      },
      {
        "dep_month": "2000-04-01T00:00:00.000Z",
        "flight_count": 50
      },
      {
        "dep_month": "2000-03-01T00:00:00.000Z",
        "flight_count": 67
      },
      {
        "dep_month": "2000-02-01T00:00:00.000Z",
        "flight_count": 56
      },
      {
        "dep_month": "2000-01-01T00:00:00.000Z",
        "flight_count": 64
      }
    ]
  },
  {
    "origin_name": "SJC - SAN JOSE",
    "flight_count": 3825,
    "total_distance": 2826646,
    "percent_of_flights": 0.09404966805999508,
    "destination_name": [
      {
        "destination_name": "LAX - LOS ANGELES",
        "flight_count": 475,
        "total_distance": 146300,
        "percent_of_flights": 0.12418300653594772,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 419
          },
          {
            "nickname": "American",
            "flight_count": 56
          }
        ]
      },
      {
        "destination_name": "SEA - SEATTLE",
        "flight_count": 368,
        "total_distance": 256496,
        "percent_of_flights": 0.09620915032679739,
        "cl": [
          {
            "nickname": "Alaska",
            "flight_count": 240
          },
          {
            "nickname": "Southwest",
            "flight_count": 106
          },
          {
            "nickname": "American",
            "flight_count": 22
          }
        ]
      },
      {
        "destination_name": "SAN - SAN DIEGO",
        "flight_count": 363,
        "total_distance": 151371,
        "percent_of_flights": 0.09490196078431372,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 315
          },
          {
            "nickname": "American",
            "flight_count": 48
          }
        ]
      },
      {
        "destination_name": "PHX - PHOENIX",
        "flight_count": 314,
        "total_distance": 194994,
        "percent_of_flights": 0.08209150326797386,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 178
          },
          {
            "nickname": "America West",
            "flight_count": 123
          },
          {
            "nickname": "American",
            "flight_count": 13
          }
        ]
      },
      {
        "destination_name": "LAS - LAS VEGAS",
        "flight_count": 303,
        "total_distance": 116958,
        "percent_of_flights": 0.0792156862745098,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 181
          },
          {
            "nickname": "American",
            "flight_count": 65
          },
          {
            "nickname": "America West",
            "flight_count": 57
          }
        ]
      },
      {
        "destination_name": "BUR - BURBANK",
        "flight_count": 240,
        "total_distance": 71040,
        "percent_of_flights": 0.06274509803921569,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 240
          }
        ]
      }
    ],
    "carrier_name": [
      {
        "carrier_name": "Southwest",
        "flight_count": 2148
      },
      {
        "carrier_name": "American",
        "flight_count": 562
      },
      {
        "carrier_name": "Alaska",
        "flight_count": 366
      },
      {
        "carrier_name": "United",
        "flight_count": 317
      },
      {
        "carrier_name": "America West",
        "flight_count": 180
      },
      {
        "carrier_name": "Northwest",
        "flight_count": 168
      },
      {
        "carrier_name": "Continental",
        "flight_count": 35
      },
      {
        "carrier_name": "Jetblue",
        "flight_count": 21
      },
      {
        "carrier_name": "Delta",
        "flight_count": 19
      },
      {
        "carrier_name": "ATA",
        "flight_count": 9
      }
    ],
    "dep_month": [
      {
        "dep_month": "2005-12-01T00:00:00.000Z",
        "flight_count": 77
      },
      {
        "dep_month": "2005-11-01T00:00:00.000Z",
        "flight_count": 51
      },
      {
        "dep_month": "2005-10-01T00:00:00.000Z",
        "flight_count": 62
      },
      {
        "dep_month": "2005-09-01T00:00:00.000Z",
        "flight_count": 54
      },
      {
        "dep_month": "2005-08-01T00:00:00.000Z",
        "flight_count": 59
      },
      {
        "dep_month": "2005-07-01T00:00:00.000Z",
        "flight_count": 65
      },
      {
        "dep_month": "2005-06-01T00:00:00.000Z",
        "flight_count": 64
      },
      {
        "dep_month": "2005-05-01T00:00:00.000Z",
        "flight_count": 57
      },
      {
        "dep_month": "2005-04-01T00:00:00.000Z",
        "flight_count": 56
      },
      {
        "dep_month": "2005-03-01T00:00:00.000Z",
        "flight_count": 49
      },
      {
        "dep_month": "2005-02-01T00:00:00.000Z",
        "flight_count": 60
      },
      {
        "dep_month": "2005-01-01T00:00:00.000Z",
        "flight_count": 55
      },
      {
        "dep_month": "2004-12-01T00:00:00.000Z",
        "flight_count": 59
      },
      {
        "dep_month": "2004-11-01T00:00:00.000Z",
        "flight_count": 78
      },
      {
        "dep_month": "2004-10-01T00:00:00.000Z",
        "flight_count": 51
      },
      {
        "dep_month": "2004-09-01T00:00:00.000Z",
        "flight_count": 49
      },
      {
        "dep_month": "2004-08-01T00:00:00.000Z",
        "flight_count": 60
      },
      {
        "dep_month": "2004-07-01T00:00:00.000Z",
        "flight_count": 44
      },
      {
        "dep_month": "2004-06-01T00:00:00.000Z",
        "flight_count": 49
      },
      {
        "dep_month": "2004-05-01T00:00:00.000Z",
        "flight_count": 48
      },
      {
        "dep_month": "2004-04-01T00:00:00.000Z",
        "flight_count": 39
      },
      {
        "dep_month": "2004-03-01T00:00:00.000Z",
        "flight_count": 42
      },
      {
        "dep_month": "2004-02-01T00:00:00.000Z",
        "flight_count": 50
      },
      {
        "dep_month": "2004-01-01T00:00:00.000Z",
        "flight_count": 34
      },
      {
        "dep_month": "2003-12-01T00:00:00.000Z",
        "flight_count": 46
      },
      {
        "dep_month": "2003-11-01T00:00:00.000Z",
        "flight_count": 46
      },
      {
        "dep_month": "2003-10-01T00:00:00.000Z",
        "flight_count": 46
      },
      {
        "dep_month": "2003-09-01T00:00:00.000Z",
        "flight_count": 56
      },
      {
        "dep_month": "2003-08-01T00:00:00.000Z",
        "flight_count": 56
      },
      {
        "dep_month": "2003-07-01T00:00:00.000Z",
        "flight_count": 43
      },
      {
        "dep_month": "2003-06-01T00:00:00.000Z",
        "flight_count": 48
      },
      {
        "dep_month": "2003-05-01T00:00:00.000Z",
        "flight_count": 51
      },
      {
        "dep_month": "2003-04-01T00:00:00.000Z",
        "flight_count": 44
      },
      {
        "dep_month": "2003-03-01T00:00:00.000Z",
        "flight_count": 45
      },
      {
        "dep_month": "2003-02-01T00:00:00.000Z",
        "flight_count": 43
      },
      {
        "dep_month": "2003-01-01T00:00:00.000Z",
        "flight_count": 54
      },
      {
        "dep_month": "2002-12-01T00:00:00.000Z",
        "flight_count": 47
      },
      {
        "dep_month": "2002-11-01T00:00:00.000Z",
        "flight_count": 49
      },
      {
        "dep_month": "2002-10-01T00:00:00.000Z",
        "flight_count": 62
      },
      {
        "dep_month": "2002-09-01T00:00:00.000Z",
        "flight_count": 60
      },
      {
        "dep_month": "2002-08-01T00:00:00.000Z",
        "flight_count": 64
      },
      {
        "dep_month": "2002-07-01T00:00:00.000Z",
        "flight_count": 45
      },
      {
        "dep_month": "2002-06-01T00:00:00.000Z",
        "flight_count": 64
      },
      {
        "dep_month": "2002-05-01T00:00:00.000Z",
        "flight_count": 73
      },
      {
        "dep_month": "2002-04-01T00:00:00.000Z",
        "flight_count": 49
      },
      {
        "dep_month": "2002-03-01T00:00:00.000Z",
        "flight_count": 60
      },
      {
        "dep_month": "2002-02-01T00:00:00.000Z",
        "flight_count": 71
      },
      {
        "dep_month": "2002-01-01T00:00:00.000Z",
        "flight_count": 54
      },
      {
        "dep_month": "2001-12-01T00:00:00.000Z",
        "flight_count": 58
      },
      {
        "dep_month": "2001-11-01T00:00:00.000Z",
        "flight_count": 59
      },
      {
        "dep_month": "2001-10-01T00:00:00.000Z",
        "flight_count": 57
      },
      {
        "dep_month": "2001-09-01T00:00:00.000Z",
        "flight_count": 47
      },
      {
        "dep_month": "2001-08-01T00:00:00.000Z",
        "flight_count": 69
      },
      {
        "dep_month": "2001-07-01T00:00:00.000Z",
        "flight_count": 46
      },
      {
        "dep_month": "2001-06-01T00:00:00.000Z",
        "flight_count": 61
      },
      {
        "dep_month": "2001-05-01T00:00:00.000Z",
        "flight_count": 53
      },
      {
        "dep_month": "2001-04-01T00:00:00.000Z",
        "flight_count": 62
      },
      {
        "dep_month": "2001-03-01T00:00:00.000Z",
        "flight_count": 40
      },
      {
        "dep_month": "2001-02-01T00:00:00.000Z",
        "flight_count": 50
      },
      {
        "dep_month": "2001-01-01T00:00:00.000Z",
        "flight_count": 46
      },
      {
        "dep_month": "2000-12-01T00:00:00.000Z",
        "flight_count": 51
      },
      {
        "dep_month": "2000-11-01T00:00:00.000Z",
        "flight_count": 44
      },
      {
        "dep_month": "2000-10-01T00:00:00.000Z",
        "flight_count": 49
      },
      {
        "dep_month": "2000-09-01T00:00:00.000Z",
        "flight_count": 49
      },
      {
        "dep_month": "2000-08-01T00:00:00.000Z",
        "flight_count": 53
      },
      {
        "dep_month": "2000-07-01T00:00:00.000Z",
        "flight_count": 46
      },
      {
        "dep_month": "2000-06-01T00:00:00.000Z",
        "flight_count": 38
      },
      {
        "dep_month": "2000-05-01T00:00:00.000Z",
        "flight_count": 60
      },
      {
        "dep_month": "2000-04-01T00:00:00.000Z",
        "flight_count": 59
      },
      {
        "dep_month": "2000-03-01T00:00:00.000Z",
        "flight_count": 35
      },
      {
        "dep_month": "2000-02-01T00:00:00.000Z",
        "flight_count": 52
      },
      {
        "dep_month": "2000-01-01T00:00:00.000Z",
        "flight_count": 53
      }
    ]
  },
  {
    "origin_name": "SMF - SACRAMENTO",
    "flight_count": 3576,
    "total_distance": 2367376,
    "percent_of_flights": 0.08792721908040324,
    "destination_name": [
      {
        "destination_name": "PHX - PHOENIX",
        "flight_count": 479,
        "total_distance": 309913,
        "percent_of_flights": 0.13394854586129754,
        "cl": [
          {
            "nickname": "America West",
            "flight_count": 249
          },
          {
            "nickname": "Southwest",
            "flight_count": 230
          }
        ]
      },
      {
        "destination_name": "SAN - SAN DIEGO",
        "flight_count": 396,
        "total_distance": 190080,
        "percent_of_flights": 0.11073825503355705,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 396
          }
        ]
      },
      {
        "destination_name": "LAX - LOS ANGELES",
        "flight_count": 382,
        "total_distance": 142486,
        "percent_of_flights": 0.10682326621923938,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 345
          },
          {
            "nickname": "United",
            "flight_count": 37
          }
        ]
      },
      {
        "destination_name": "ONT - ONTARIO",
        "flight_count": 380,
        "total_distance": 147820,
        "percent_of_flights": 0.10626398210290827,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 380
          }
        ]
      },
      {
        "destination_name": "LAS - LAS VEGAS",
        "flight_count": 327,
        "total_distance": 129819,
        "percent_of_flights": 0.09144295302013423,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 269
          },
          {
            "nickname": "America West",
            "flight_count": 58
          }
        ]
      },
      {
        "destination_name": "BUR - BURBANK",
        "flight_count": 279,
        "total_distance": 99882,
        "percent_of_flights": 0.07802013422818792,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 279
          }
        ]
      }
    ],
    "carrier_name": [
      {
        "carrier_name": "Southwest",
        "flight_count": 2471
      },
      {
        "carrier_name": "America West",
        "flight_count": 376
      },
      {
        "carrier_name": "United",
        "flight_count": 281
      },
      {
        "carrier_name": "American",
        "flight_count": 138
      },
      {
        "carrier_name": "Alaska",
        "flight_count": 132
      },
      {
        "carrier_name": "Northwest",
        "flight_count": 110
      },
      {
        "carrier_name": "Delta",
        "flight_count": 29
      },
      {
        "carrier_name": "Continental",
        "flight_count": 21
      },
      {
        "carrier_name": "Jetblue",
        "flight_count": 18
      }
    ],
    "dep_month": [
      {
        "dep_month": "2005-12-01T00:00:00.000Z",
        "flight_count": 57
      },
      {
        "dep_month": "2005-11-01T00:00:00.000Z",
        "flight_count": 46
      },
      {
        "dep_month": "2005-10-01T00:00:00.000Z",
        "flight_count": 53
      },
      {
        "dep_month": "2005-09-01T00:00:00.000Z",
        "flight_count": 62
      },
      {
        "dep_month": "2005-08-01T00:00:00.000Z",
        "flight_count": 59
      },
      {
        "dep_month": "2005-07-01T00:00:00.000Z",
        "flight_count": 64
      },
      {
        "dep_month": "2005-06-01T00:00:00.000Z",
        "flight_count": 59
      },
      {
        "dep_month": "2005-05-01T00:00:00.000Z",
        "flight_count": 57
      },
      {
        "dep_month": "2005-04-01T00:00:00.000Z",
        "flight_count": 56
      },
      {
        "dep_month": "2005-03-01T00:00:00.000Z",
        "flight_count": 55
      },
      {
        "dep_month": "2005-02-01T00:00:00.000Z",
        "flight_count": 63
      },
      {
        "dep_month": "2005-01-01T00:00:00.000Z",
        "flight_count": 70
      },
      {
        "dep_month": "2004-12-01T00:00:00.000Z",
        "flight_count": 52
      },
      {
        "dep_month": "2004-11-01T00:00:00.000Z",
        "flight_count": 70
      },
      {
        "dep_month": "2004-10-01T00:00:00.000Z",
        "flight_count": 51
      },
      {
        "dep_month": "2004-09-01T00:00:00.000Z",
        "flight_count": 51
      },
      {
        "dep_month": "2004-08-01T00:00:00.000Z",
        "flight_count": 51
      },
      {
        "dep_month": "2004-07-01T00:00:00.000Z",
        "flight_count": 34
      },
      {
        "dep_month": "2004-06-01T00:00:00.000Z",
        "flight_count": 53
      },
      {
        "dep_month": "2004-05-01T00:00:00.000Z",
        "flight_count": 67
      },
      {
        "dep_month": "2004-04-01T00:00:00.000Z",
        "flight_count": 47
      },
      {
        "dep_month": "2004-03-01T00:00:00.000Z",
        "flight_count": 41
      },
      {
        "dep_month": "2004-02-01T00:00:00.000Z",
        "flight_count": 60
      },
      {
        "dep_month": "2004-01-01T00:00:00.000Z",
        "flight_count": 47
      },
      {
        "dep_month": "2003-12-01T00:00:00.000Z",
        "flight_count": 48
      },
      {
        "dep_month": "2003-11-01T00:00:00.000Z",
        "flight_count": 40
      },
      {
        "dep_month": "2003-10-01T00:00:00.000Z",
        "flight_count": 50
      },
      {
        "dep_month": "2003-09-01T00:00:00.000Z",
        "flight_count": 56
      },
      {
        "dep_month": "2003-08-01T00:00:00.000Z",
        "flight_count": 57
      },
      {
        "dep_month": "2003-07-01T00:00:00.000Z",
        "flight_count": 41
      },
      {
        "dep_month": "2003-06-01T00:00:00.000Z",
        "flight_count": 49
      },
      {
        "dep_month": "2003-05-01T00:00:00.000Z",
        "flight_count": 60
      },
      {
        "dep_month": "2003-04-01T00:00:00.000Z",
        "flight_count": 52
      },
      {
        "dep_month": "2003-03-01T00:00:00.000Z",
        "flight_count": 31
      },
      {
        "dep_month": "2003-02-01T00:00:00.000Z",
        "flight_count": 44
      },
      {
        "dep_month": "2003-01-01T00:00:00.000Z",
        "flight_count": 36
      },
      {
        "dep_month": "2002-12-01T00:00:00.000Z",
        "flight_count": 57
      },
      {
        "dep_month": "2002-11-01T00:00:00.000Z",
        "flight_count": 45
      },
      {
        "dep_month": "2002-10-01T00:00:00.000Z",
        "flight_count": 51
      },
      {
        "dep_month": "2002-09-01T00:00:00.000Z",
        "flight_count": 53
      },
      {
        "dep_month": "2002-08-01T00:00:00.000Z",
        "flight_count": 58
      },
      {
        "dep_month": "2002-07-01T00:00:00.000Z",
        "flight_count": 68
      },
      {
        "dep_month": "2002-06-01T00:00:00.000Z",
        "flight_count": 54
      },
      {
        "dep_month": "2002-05-01T00:00:00.000Z",
        "flight_count": 47
      },
      {
        "dep_month": "2002-04-01T00:00:00.000Z",
        "flight_count": 37
      },
      {
        "dep_month": "2002-03-01T00:00:00.000Z",
        "flight_count": 59
      },
      {
        "dep_month": "2002-02-01T00:00:00.000Z",
        "flight_count": 34
      },
      {
        "dep_month": "2002-01-01T00:00:00.000Z",
        "flight_count": 54
      },
      {
        "dep_month": "2001-12-01T00:00:00.000Z",
        "flight_count": 48
      },
      {
        "dep_month": "2001-11-01T00:00:00.000Z",
        "flight_count": 43
      },
      {
        "dep_month": "2001-10-01T00:00:00.000Z",
        "flight_count": 53
      },
      {
        "dep_month": "2001-09-01T00:00:00.000Z",
        "flight_count": 39
      },
      {
        "dep_month": "2001-08-01T00:00:00.000Z",
        "flight_count": 58
      },
      {
        "dep_month": "2001-07-01T00:00:00.000Z",
        "flight_count": 45
      },
      {
        "dep_month": "2001-06-01T00:00:00.000Z",
        "flight_count": 39
      },
      {
        "dep_month": "2001-05-01T00:00:00.000Z",
        "flight_count": 41
      },
      {
        "dep_month": "2001-04-01T00:00:00.000Z",
        "flight_count": 44
      },
      {
        "dep_month": "2001-03-01T00:00:00.000Z",
        "flight_count": 29
      },
      {
        "dep_month": "2001-02-01T00:00:00.000Z",
        "flight_count": 40
      },
      {
        "dep_month": "2001-01-01T00:00:00.000Z",
        "flight_count": 51
      },
      {
        "dep_month": "2000-12-01T00:00:00.000Z",
        "flight_count": 39
      },
      {
        "dep_month": "2000-11-01T00:00:00.000Z",
        "flight_count": 36
      },
      {
        "dep_month": "2000-10-01T00:00:00.000Z",
        "flight_count": 40
      },
      {
        "dep_month": "2000-09-01T00:00:00.000Z",
        "flight_count": 46
      },
      {
        "dep_month": "2000-08-01T00:00:00.000Z",
        "flight_count": 50
      },
      {
        "dep_month": "2000-07-01T00:00:00.000Z",
        "flight_count": 44
      },
      {
        "dep_month": "2000-06-01T00:00:00.000Z",
        "flight_count": 40
      },
      {
        "dep_month": "2000-05-01T00:00:00.000Z",
        "flight_count": 51
      },
      {
        "dep_month": "2000-04-01T00:00:00.000Z",
        "flight_count": 49
      },
      {
        "dep_month": "2000-03-01T00:00:00.000Z",
        "flight_count": 55
      },
      {
        "dep_month": "2000-02-01T00:00:00.000Z",
        "flight_count": 43
      },
      {
        "dep_month": "2000-01-01T00:00:00.000Z",
        "flight_count": 47
      }
    ]
  },
  {
    "origin_name": "ONT - ONTARIO",
    "flight_count": 2642,
    "total_distance": 1492508,
    "percent_of_flights": 0.06496188836980575,
    "destination_name": [
      {
        "destination_name": "PHX - PHOENIX",
        "flight_count": 491,
        "total_distance": 159575,
        "percent_of_flights": 0.1858440575321726,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 380
          },
          {
            "nickname": "America West",
            "flight_count": 111
          }
        ]
      },
      {
        "destination_name": "SMF - SACRAMENTO",
        "flight_count": 412,
        "total_distance": 160268,
        "percent_of_flights": 0.15594246782740348,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 412
          }
        ]
      },
      {
        "destination_name": "OAK - OAKLAND",
        "flight_count": 411,
        "total_distance": 148371,
        "percent_of_flights": 0.15556396669190006,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 411
          }
        ]
      },
      {
        "destination_name": "LAS - LAS VEGAS",
        "flight_count": 344,
        "total_distance": 67768,
        "percent_of_flights": 0.13020439061317185,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 323
          },
          {
            "nickname": "America West",
            "flight_count": 21
          }
        ]
      },
      {
        "destination_name": "SJC - SAN JOSE",
        "flight_count": 236,
        "total_distance": 78588,
        "percent_of_flights": 0.08932626797880394,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 236
          }
        ]
      },
      {
        "destination_name": "SEA - SEATTLE",
        "flight_count": 145,
        "total_distance": 138620,
        "percent_of_flights": 0.05488266464799394,
        "cl": [
          {
            "nickname": "Alaska",
            "flight_count": 145
          }
        ]
      }
    ],
    "carrier_name": [
      {
        "carrier_name": "Southwest",
        "flight_count": 1804
      },
      {
        "carrier_name": "Alaska",
        "flight_count": 236
      },
      {
        "carrier_name": "United",
        "flight_count": 153
      },
      {
        "carrier_name": "American",
        "flight_count": 142
      },
      {
        "carrier_name": "America West",
        "flight_count": 132
      },
      {
        "carrier_name": "Northwest",
        "flight_count": 105
      },
      {
        "carrier_name": "Jetblue",
        "flight_count": 31
      },
      {
        "carrier_name": "Delta",
        "flight_count": 27
      },
      {
        "carrier_name": "Continental",
        "flight_count": 11
      },
      {
        "carrier_name": "Continental Express",
        "flight_count": 1
      }
    ],
    "dep_month": [
      {
        "dep_month": "2005-12-01T00:00:00.000Z",
        "flight_count": 48
      },
      {
        "dep_month": "2005-11-01T00:00:00.000Z",
        "flight_count": 23
      },
      {
        "dep_month": "2005-10-01T00:00:00.000Z",
        "flight_count": 42
      },
      {
        "dep_month": "2005-09-01T00:00:00.000Z",
        "flight_count": 58
      },
      {
        "dep_month": "2005-08-01T00:00:00.000Z",
        "flight_count": 42
      },
      {
        "dep_month": "2005-07-01T00:00:00.000Z",
        "flight_count": 41
      },
      {
        "dep_month": "2005-06-01T00:00:00.000Z",
        "flight_count": 35
      },
      {
        "dep_month": "2005-05-01T00:00:00.000Z",
        "flight_count": 34
      },
      {
        "dep_month": "2005-04-01T00:00:00.000Z",
        "flight_count": 51
      },
      {
        "dep_month": "2005-03-01T00:00:00.000Z",
        "flight_count": 38
      },
      {
        "dep_month": "2005-02-01T00:00:00.000Z",
        "flight_count": 44
      },
      {
        "dep_month": "2005-01-01T00:00:00.000Z",
        "flight_count": 52
      },
      {
        "dep_month": "2004-12-01T00:00:00.000Z",
        "flight_count": 48
      },
      {
        "dep_month": "2004-11-01T00:00:00.000Z",
        "flight_count": 57
      },
      {
        "dep_month": "2004-10-01T00:00:00.000Z",
        "flight_count": 46
      },
      {
        "dep_month": "2004-09-01T00:00:00.000Z",
        "flight_count": 28
      },
      {
        "dep_month": "2004-08-01T00:00:00.000Z",
        "flight_count": 45
      },
      {
        "dep_month": "2004-07-01T00:00:00.000Z",
        "flight_count": 20
      },
      {
        "dep_month": "2004-06-01T00:00:00.000Z",
        "flight_count": 32
      },
      {
        "dep_month": "2004-05-01T00:00:00.000Z",
        "flight_count": 44
      },
      {
        "dep_month": "2004-04-01T00:00:00.000Z",
        "flight_count": 36
      },
      {
        "dep_month": "2004-03-01T00:00:00.000Z",
        "flight_count": 24
      },
      {
        "dep_month": "2004-02-01T00:00:00.000Z",
        "flight_count": 31
      },
      {
        "dep_month": "2004-01-01T00:00:00.000Z",
        "flight_count": 36
      },
      {
        "dep_month": "2003-12-01T00:00:00.000Z",
        "flight_count": 22
      },
      {
        "dep_month": "2003-11-01T00:00:00.000Z",
        "flight_count": 33
      },
      {
        "dep_month": "2003-10-01T00:00:00.000Z",
        "flight_count": 46
      },
      {
        "dep_month": "2003-09-01T00:00:00.000Z",
        "flight_count": 38
      },
      {
        "dep_month": "2003-08-01T00:00:00.000Z",
        "flight_count": 46
      },
      {
        "dep_month": "2003-07-01T00:00:00.000Z",
        "flight_count": 51
      },
      {
        "dep_month": "2003-06-01T00:00:00.000Z",
        "flight_count": 31
      },
      {
        "dep_month": "2003-05-01T00:00:00.000Z",
        "flight_count": 38
      },
      {
        "dep_month": "2003-04-01T00:00:00.000Z",
        "flight_count": 31
      },
      {
        "dep_month": "2003-03-01T00:00:00.000Z",
        "flight_count": 23
      },
      {
        "dep_month": "2003-02-01T00:00:00.000Z",
        "flight_count": 25
      },
      {
        "dep_month": "2003-01-01T00:00:00.000Z",
        "flight_count": 27
      },
      {
        "dep_month": "2002-12-01T00:00:00.000Z",
        "flight_count": 36
      },
      {
        "dep_month": "2002-11-01T00:00:00.000Z",
        "flight_count": 34
      },
      {
        "dep_month": "2002-10-01T00:00:00.000Z",
        "flight_count": 42
      },
      {
        "dep_month": "2002-09-01T00:00:00.000Z",
        "flight_count": 44
      },
      {
        "dep_month": "2002-08-01T00:00:00.000Z",
        "flight_count": 30
      },
      {
        "dep_month": "2002-07-01T00:00:00.000Z",
        "flight_count": 37
      },
      {
        "dep_month": "2002-06-01T00:00:00.000Z",
        "flight_count": 36
      },
      {
        "dep_month": "2002-05-01T00:00:00.000Z",
        "flight_count": 30
      },
      {
        "dep_month": "2002-04-01T00:00:00.000Z",
        "flight_count": 31
      },
      {
        "dep_month": "2002-03-01T00:00:00.000Z",
        "flight_count": 32
      },
      {
        "dep_month": "2002-02-01T00:00:00.000Z",
        "flight_count": 36
      },
      {
        "dep_month": "2002-01-01T00:00:00.000Z",
        "flight_count": 40
      },
      {
        "dep_month": "2001-12-01T00:00:00.000Z",
        "flight_count": 35
      },
      {
        "dep_month": "2001-11-01T00:00:00.000Z",
        "flight_count": 41
      },
      {
        "dep_month": "2001-10-01T00:00:00.000Z",
        "flight_count": 39
      },
      {
        "dep_month": "2001-09-01T00:00:00.000Z",
        "flight_count": 32
      },
      {
        "dep_month": "2001-08-01T00:00:00.000Z",
        "flight_count": 33
      },
      {
        "dep_month": "2001-07-01T00:00:00.000Z",
        "flight_count": 39
      },
      {
        "dep_month": "2001-06-01T00:00:00.000Z",
        "flight_count": 40
      },
      {
        "dep_month": "2001-05-01T00:00:00.000Z",
        "flight_count": 47
      },
      {
        "dep_month": "2001-04-01T00:00:00.000Z",
        "flight_count": 34
      },
      {
        "dep_month": "2001-03-01T00:00:00.000Z",
        "flight_count": 24
      },
      {
        "dep_month": "2001-02-01T00:00:00.000Z",
        "flight_count": 34
      },
      {
        "dep_month": "2001-01-01T00:00:00.000Z",
        "flight_count": 42
      },
      {
        "dep_month": "2000-12-01T00:00:00.000Z",
        "flight_count": 37
      },
      {
        "dep_month": "2000-11-01T00:00:00.000Z",
        "flight_count": 29
      },
      {
        "dep_month": "2000-10-01T00:00:00.000Z",
        "flight_count": 37
      },
      {
        "dep_month": "2000-09-01T00:00:00.000Z",
        "flight_count": 36
      },
      {
        "dep_month": "2000-08-01T00:00:00.000Z",
        "flight_count": 36
      },
      {
        "dep_month": "2000-07-01T00:00:00.000Z",
        "flight_count": 26
      },
      {
        "dep_month": "2000-06-01T00:00:00.000Z",
        "flight_count": 30
      },
      {
        "dep_month": "2000-05-01T00:00:00.000Z",
        "flight_count": 34
      },
      {
        "dep_month": "2000-04-01T00:00:00.000Z",
        "flight_count": 34
      },
      {
        "dep_month": "2000-03-01T00:00:00.000Z",
        "flight_count": 28
      },
      {
        "dep_month": "2000-02-01T00:00:00.000Z",
        "flight_count": 45
      },
      {
        "dep_month": "2000-01-01T00:00:00.000Z",
        "flight_count": 36
      }
    ]
  },
  {
    "origin_name": "BUR - BURBANK",
    "flight_count": 1952,
    "total_distance": 876479,
    "percent_of_flights": 0.04799606589623801,
    "destination_name": [
      {
        "destination_name": "LAS - LAS VEGAS",
        "flight_count": 388,
        "total_distance": 86524,
        "percent_of_flights": 0.1987704918032787,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 384
          },
          {
            "nickname": "America West",
            "flight_count": 4
          }
        ]
      },
      {
        "destination_name": "OAK - OAKLAND",
        "flight_count": 367,
        "total_distance": 119275,
        "percent_of_flights": 0.1880122950819672,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 367
          }
        ]
      },
      {
        "destination_name": "PHX - PHOENIX",
        "flight_count": 357,
        "total_distance": 131733,
        "percent_of_flights": 0.18288934426229508,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 260
          },
          {
            "nickname": "America West",
            "flight_count": 97
          }
        ]
      },
      {
        "destination_name": "SMF - SACRAMENTO",
        "flight_count": 260,
        "total_distance": 93080,
        "percent_of_flights": 0.13319672131147542,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 260
          }
        ]
      },
      {
        "destination_name": "SJC - SAN JOSE",
        "flight_count": 206,
        "total_distance": 60976,
        "percent_of_flights": 0.10553278688524591,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 206
          }
        ]
      },
      {
        "destination_name": "SEA - SEATTLE",
        "flight_count": 154,
        "total_distance": 144298,
        "percent_of_flights": 0.07889344262295082,
        "cl": [
          {
            "nickname": "Alaska",
            "flight_count": 154
          }
        ]
      }
    ],
    "carrier_name": [
      {
        "carrier_name": "Southwest",
        "flight_count": 1477
      },
      {
        "carrier_name": "Alaska",
        "flight_count": 248
      },
      {
        "carrier_name": "America West",
        "flight_count": 101
      },
      {
        "carrier_name": "American",
        "flight_count": 96
      },
      {
        "carrier_name": "Jetblue",
        "flight_count": 16
      },
      {
        "carrier_name": "United",
        "flight_count": 13
      },
      {
        "carrier_name": "Delta",
        "flight_count": 1
      }
    ],
    "dep_month": [
      {
        "dep_month": "2005-12-01T00:00:00.000Z",
        "flight_count": 33
      },
      {
        "dep_month": "2005-11-01T00:00:00.000Z",
        "flight_count": 30
      },
      {
        "dep_month": "2005-10-01T00:00:00.000Z",
        "flight_count": 37
      },
      {
        "dep_month": "2005-09-01T00:00:00.000Z",
        "flight_count": 30
      },
      {
        "dep_month": "2005-08-01T00:00:00.000Z",
        "flight_count": 30
      },
      {
        "dep_month": "2005-07-01T00:00:00.000Z",
        "flight_count": 33
      },
      {
        "dep_month": "2005-06-01T00:00:00.000Z",
        "flight_count": 19
      },
      {
        "dep_month": "2005-05-01T00:00:00.000Z",
        "flight_count": 27
      },
      {
        "dep_month": "2005-04-01T00:00:00.000Z",
        "flight_count": 35
      },
      {
        "dep_month": "2005-03-01T00:00:00.000Z",
        "flight_count": 42
      },
      {
        "dep_month": "2005-02-01T00:00:00.000Z",
        "flight_count": 49
      },
      {
        "dep_month": "2005-01-01T00:00:00.000Z",
        "flight_count": 28
      },
      {
        "dep_month": "2004-12-01T00:00:00.000Z",
        "flight_count": 31
      },
      {
        "dep_month": "2004-11-01T00:00:00.000Z",
        "flight_count": 27
      },
      {
        "dep_month": "2004-10-01T00:00:00.000Z",
        "flight_count": 28
      },
      {
        "dep_month": "2004-09-01T00:00:00.000Z",
        "flight_count": 39
      },
      {
        "dep_month": "2004-08-01T00:00:00.000Z",
        "flight_count": 25
      },
      {
        "dep_month": "2004-07-01T00:00:00.000Z",
        "flight_count": 19
      },
      {
        "dep_month": "2004-06-01T00:00:00.000Z",
        "flight_count": 24
      },
      {
        "dep_month": "2004-05-01T00:00:00.000Z",
        "flight_count": 30
      },
      {
        "dep_month": "2004-04-01T00:00:00.000Z",
        "flight_count": 21
      },
      {
        "dep_month": "2004-03-01T00:00:00.000Z",
        "flight_count": 22
      },
      {
        "dep_month": "2004-02-01T00:00:00.000Z",
        "flight_count": 29
      },
      {
        "dep_month": "2004-01-01T00:00:00.000Z",
        "flight_count": 23
      },
      {
        "dep_month": "2003-12-01T00:00:00.000Z",
        "flight_count": 23
      },
      {
        "dep_month": "2003-11-01T00:00:00.000Z",
        "flight_count": 24
      },
      {
        "dep_month": "2003-10-01T00:00:00.000Z",
        "flight_count": 30
      },
      {
        "dep_month": "2003-09-01T00:00:00.000Z",
        "flight_count": 28
      },
      {
        "dep_month": "2003-08-01T00:00:00.000Z",
        "flight_count": 23
      },
      {
        "dep_month": "2003-07-01T00:00:00.000Z",
        "flight_count": 36
      },
      {
        "dep_month": "2003-06-01T00:00:00.000Z",
        "flight_count": 27
      },
      {
        "dep_month": "2003-05-01T00:00:00.000Z",
        "flight_count": 33
      },
      {
        "dep_month": "2003-04-01T00:00:00.000Z",
        "flight_count": 37
      },
      {
        "dep_month": "2003-03-01T00:00:00.000Z",
        "flight_count": 19
      },
      {
        "dep_month": "2003-02-01T00:00:00.000Z",
        "flight_count": 23
      },
      {
        "dep_month": "2003-01-01T00:00:00.000Z",
        "flight_count": 25
      },
      {
        "dep_month": "2002-12-01T00:00:00.000Z",
        "flight_count": 31
      },
      {
        "dep_month": "2002-11-01T00:00:00.000Z",
        "flight_count": 26
      },
      {
        "dep_month": "2002-10-01T00:00:00.000Z",
        "flight_count": 22
      },
      {
        "dep_month": "2002-09-01T00:00:00.000Z",
        "flight_count": 26
      },
      {
        "dep_month": "2002-08-01T00:00:00.000Z",
        "flight_count": 27
      },
      {
        "dep_month": "2002-07-01T00:00:00.000Z",
        "flight_count": 27
      },
      {
        "dep_month": "2002-06-01T00:00:00.000Z",
        "flight_count": 22
      },
      {
        "dep_month": "2002-05-01T00:00:00.000Z",
        "flight_count": 22
      },
      {
        "dep_month": "2002-04-01T00:00:00.000Z",
        "flight_count": 22
      },
      {
        "dep_month": "2002-03-01T00:00:00.000Z",
        "flight_count": 29
      },
      {
        "dep_month": "2002-02-01T00:00:00.000Z",
        "flight_count": 19
      },
      {
        "dep_month": "2002-01-01T00:00:00.000Z",
        "flight_count": 33
      },
      {
        "dep_month": "2001-12-01T00:00:00.000Z",
        "flight_count": 21
      },
      {
        "dep_month": "2001-11-01T00:00:00.000Z",
        "flight_count": 32
      },
      {
        "dep_month": "2001-10-01T00:00:00.000Z",
        "flight_count": 26
      },
      {
        "dep_month": "2001-09-01T00:00:00.000Z",
        "flight_count": 16
      },
      {
        "dep_month": "2001-08-01T00:00:00.000Z",
        "flight_count": 25
      },
      {
        "dep_month": "2001-07-01T00:00:00.000Z",
        "flight_count": 33
      },
      {
        "dep_month": "2001-06-01T00:00:00.000Z",
        "flight_count": 22
      },
      {
        "dep_month": "2001-05-01T00:00:00.000Z",
        "flight_count": 25
      },
      {
        "dep_month": "2001-04-01T00:00:00.000Z",
        "flight_count": 22
      },
      {
        "dep_month": "2001-03-01T00:00:00.000Z",
        "flight_count": 18
      },
      {
        "dep_month": "2001-02-01T00:00:00.000Z",
        "flight_count": 41
      },
      {
        "dep_month": "2001-01-01T00:00:00.000Z",
        "flight_count": 30
      },
      {
        "dep_month": "2000-12-01T00:00:00.000Z",
        "flight_count": 24
      },
      {
        "dep_month": "2000-11-01T00:00:00.000Z",
        "flight_count": 25
      },
      {
        "dep_month": "2000-10-01T00:00:00.000Z",
        "flight_count": 23
      },
      {
        "dep_month": "2000-09-01T00:00:00.000Z",
        "flight_count": 17
      },
      {
        "dep_month": "2000-08-01T00:00:00.000Z",
        "flight_count": 33
      },
      {
        "dep_month": "2000-07-01T00:00:00.000Z",
        "flight_count": 30
      },
      {
        "dep_month": "2000-06-01T00:00:00.000Z",
        "flight_count": 22
      },
      {
        "dep_month": "2000-05-01T00:00:00.000Z",
        "flight_count": 24
      },
      {
        "dep_month": "2000-04-01T00:00:00.000Z",
        "flight_count": 27
      },
      {
        "dep_month": "2000-03-01T00:00:00.000Z",
        "flight_count": 24
      },
      {
        "dep_month": "2000-02-01T00:00:00.000Z",
        "flight_count": 23
      },
      {
        "dep_month": "2000-01-01T00:00:00.000Z",
        "flight_count": 24
      }
    ]
  },
  {
    "origin_name": "SNA - SANTA ANA",
    "flight_count": 1919,
    "total_distance": 1377110,
    "percent_of_flights": 0.04718465699532825,
    "destination_name": [
      {
        "destination_name": "PHX - PHOENIX",
        "flight_count": 297,
        "total_distance": 100386,
        "percent_of_flights": 0.15476810838978636,
        "cl": [
          {
            "nickname": "America West",
            "flight_count": 174
          },
          {
            "nickname": "Southwest",
            "flight_count": 123
          }
        ]
      },
      {
        "destination_name": "LAS - LAS VEGAS",
        "flight_count": 260,
        "total_distance": 58760,
        "percent_of_flights": 0.1354872329338197,
        "cl": [
          {
            "nickname": "America West",
            "flight_count": 157
          },
          {
            "nickname": "Southwest",
            "flight_count": 100
          },
          {
            "nickname": "American",
            "flight_count": 2
          },
          {
            "nickname": "Delta",
            "flight_count": 1
          }
        ]
      },
      {
        "destination_name": "SMF - SACRAMENTO",
        "flight_count": 252,
        "total_distance": 101808,
        "percent_of_flights": 0.13131839499739448,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 163
          },
          {
            "nickname": "America West",
            "flight_count": 89
          }
        ]
      },
      {
        "destination_name": "SFO - SAN FRANCISCO",
        "flight_count": 177,
        "total_distance": 65844,
        "percent_of_flights": 0.09223553934340803,
        "cl": [
          {
            "nickname": "United",
            "flight_count": 171
          },
          {
            "nickname": "American",
            "flight_count": 6
          }
        ]
      },
      {
        "destination_name": "DEN - DENVER",
        "flight_count": 173,
        "total_distance": 146358,
        "percent_of_flights": 0.09015112037519542,
        "cl": [
          {
            "nickname": "United",
            "flight_count": 173
          }
        ]
      },
      {
        "destination_name": "OAK - OAKLAND",
        "flight_count": 160,
        "total_distance": 59360,
        "percent_of_flights": 0.08337675872850443,
        "cl": [
          {
            "nickname": "Southwest",
            "flight_count": 160
          }
        ]
      }
    ],
    "carrier_name": [
      {
        "carrier_name": "Southwest",
        "flight_count": 658
      },
      {
        "carrier_name": "United",
        "flight_count": 460
      },
      {
        "carrier_name": "America West",
        "flight_count": 420
      },
      {
        "carrier_name": "Northwest",
        "flight_count": 133
      },
      {
        "carrier_name": "USAir",
        "flight_count": 105
      },
      {
        "carrier_name": "American",
        "flight_count": 92
      },
      {
        "carrier_name": "Delta",
        "flight_count": 51
      }
    ],
    "dep_month": [
      {
        "dep_month": "2005-12-01T00:00:00.000Z",
        "flight_count": 40
      },
      {
        "dep_month": "2005-11-01T00:00:00.000Z",
        "flight_count": 37
      },
      {
        "dep_month": "2005-10-01T00:00:00.000Z",
        "flight_count": 34
      },
      {
        "dep_month": "2005-09-01T00:00:00.000Z",
        "flight_count": 30
      },
      {
        "dep_month": "2005-08-01T00:00:00.000Z",
        "flight_count": 37
      },
      {
        "dep_month": "2005-07-01T00:00:00.000Z",
        "flight_count": 39
      },
      {
        "dep_month": "2005-06-01T00:00:00.000Z",
        "flight_count": 32
      },
      {
        "dep_month": "2005-05-01T00:00:00.000Z",
        "flight_count": 30
      },
      {
        "dep_month": "2005-04-01T00:00:00.000Z",
        "flight_count": 24
      },
      {
        "dep_month": "2005-03-01T00:00:00.000Z",
        "flight_count": 35
      },
      {
        "dep_month": "2005-02-01T00:00:00.000Z",
        "flight_count": 33
      },
      {
        "dep_month": "2005-01-01T00:00:00.000Z",
        "flight_count": 26
      },
      {
        "dep_month": "2004-12-01T00:00:00.000Z",
        "flight_count": 33
      },
      {
        "dep_month": "2004-11-01T00:00:00.000Z",
        "flight_count": 43
      },
      {
        "dep_month": "2004-10-01T00:00:00.000Z",
        "flight_count": 34
      },
      {
        "dep_month": "2004-09-01T00:00:00.000Z",
        "flight_count": 29
      },
      {
        "dep_month": "2004-08-01T00:00:00.000Z",
        "flight_count": 30
      },
      {
        "dep_month": "2004-07-01T00:00:00.000Z",
        "flight_count": 22
      },
      {
        "dep_month": "2004-06-01T00:00:00.000Z",
        "flight_count": 19
      },
      {
        "dep_month": "2004-05-01T00:00:00.000Z",
        "flight_count": 18
      },
      {
        "dep_month": "2004-04-01T00:00:00.000Z",
        "flight_count": 33
      },
      {
        "dep_month": "2004-03-01T00:00:00.000Z",
        "flight_count": 27
      },
      {
        "dep_month": "2004-02-01T00:00:00.000Z",
        "flight_count": 46
      },
      {
        "dep_month": "2004-01-01T00:00:00.000Z",
        "flight_count": 25
      },
      {
        "dep_month": "2003-12-01T00:00:00.000Z",
        "flight_count": 27
      },
      {
        "dep_month": "2003-11-01T00:00:00.000Z",
        "flight_count": 32
      },
      {
        "dep_month": "2003-10-01T00:00:00.000Z",
        "flight_count": 29
      },
      {
        "dep_month": "2003-09-01T00:00:00.000Z",
        "flight_count": 29
      },
      {
        "dep_month": "2003-08-01T00:00:00.000Z",
        "flight_count": 30
      },
      {
        "dep_month": "2003-07-01T00:00:00.000Z",
        "flight_count": 24
      },
      {
        "dep_month": "2003-06-01T00:00:00.000Z",
        "flight_count": 21
      },
      {
        "dep_month": "2003-05-01T00:00:00.000Z",
        "flight_count": 21
      },
      {
        "dep_month": "2003-04-01T00:00:00.000Z",
        "flight_count": 28
      },
      {
        "dep_month": "2003-03-01T00:00:00.000Z",
        "flight_count": 30
      },
      {
        "dep_month": "2003-02-01T00:00:00.000Z",
        "flight_count": 26
      },
      {
        "dep_month": "2003-01-01T00:00:00.000Z",
        "flight_count": 36
      },
      {
        "dep_month": "2002-12-01T00:00:00.000Z",
        "flight_count": 20
      },
      {
        "dep_month": "2002-11-01T00:00:00.000Z",
        "flight_count": 23
      },
      {
        "dep_month": "2002-10-01T00:00:00.000Z",
        "flight_count": 34
      },
      {
        "dep_month": "2002-09-01T00:00:00.000Z",
        "flight_count": 19
      },
      {
        "dep_month": "2002-08-01T00:00:00.000Z",
        "flight_count": 34
      },
      {
        "dep_month": "2002-07-01T00:00:00.000Z",
        "flight_count": 27
      },
      {
        "dep_month": "2002-06-01T00:00:00.000Z",
        "flight_count": 21
      },
      {
        "dep_month": "2002-05-01T00:00:00.000Z",
        "flight_count": 29
      },
      {
        "dep_month": "2002-04-01T00:00:00.000Z",
        "flight_count": 34
      },
      {
        "dep_month": "2002-03-01T00:00:00.000Z",
        "flight_count": 38
      },
      {
        "dep_month": "2002-02-01T00:00:00.000Z",
        "flight_count": 28
      },
      {
        "dep_month": "2002-01-01T00:00:00.000Z",
        "flight_count": 23
      },
      {
        "dep_month": "2001-12-01T00:00:00.000Z",
        "flight_count": 19
      },
      {
        "dep_month": "2001-11-01T00:00:00.000Z",
        "flight_count": 21
      },
      {
        "dep_month": "2001-10-01T00:00:00.000Z",
        "flight_count": 20
      },
      {
        "dep_month": "2001-09-01T00:00:00.000Z",
        "flight_count": 20
      },
      {
        "dep_month": "2001-08-01T00:00:00.000Z",
        "flight_count": 18
      },
      {
        "dep_month": "2001-07-01T00:00:00.000Z",
        "flight_count": 28
      },
      {
        "dep_month": "2001-06-01T00:00:00.000Z",
        "flight_count": 19
      },
      {
        "dep_month": "2001-05-01T00:00:00.000Z",
        "flight_count": 23
      },
      {
        "dep_month": "2001-04-01T00:00:00.000Z",
        "flight_count": 24
      },
      {
        "dep_month": "2001-03-01T00:00:00.000Z",
        "flight_count": 21
      },
      {
        "dep_month": "2001-02-01T00:00:00.000Z",
        "flight_count": 17
      },
      {
        "dep_month": "2001-01-01T00:00:00.000Z",
        "flight_count": 16
      },
      {
        "dep_month": "2000-12-01T00:00:00.000Z",
        "flight_count": 17
      },
      {
        "dep_month": "2000-11-01T00:00:00.000Z",
        "flight_count": 15
      },
      {
        "dep_month": "2000-10-01T00:00:00.000Z",
        "flight_count": 23
      },
      {
        "dep_month": "2000-09-01T00:00:00.000Z",
        "flight_count": 22
      },
      {
        "dep_month": "2000-08-01T00:00:00.000Z",
        "flight_count": 18
      },
      {
        "dep_month": "2000-07-01T00:00:00.000Z",
        "flight_count": 14
      },
      {
        "dep_month": "2000-06-01T00:00:00.000Z",
        "flight_count": 20
      },
      {
        "dep_month": "2000-05-01T00:00:00.000Z",
        "flight_count": 29
      },
      {
        "dep_month": "2000-04-01T00:00:00.000Z",
        "flight_count": 27
      },
      {
        "dep_month": "2000-03-01T00:00:00.000Z",
        "flight_count": 23
      },
      {
        "dep_month": "2000-02-01T00:00:00.000Z",
        "flight_count": 18
      },
      {
        "dep_month": "2000-01-01T00:00:00.000Z",
        "flight_count": 28
      }
    ]
  },
  {
    "origin_name": "LGB - LONG BEACH",
    "flight_count": 661,
    "total_distance": 931914,
    "percent_of_flights": 0.016252766166707646,
    "destination_name": [
      {
        "destination_name": "JFK - NEW YORK",
        "flight_count": 149,
        "total_distance": 367285,
        "percent_of_flights": 0.2254160363086233,
        "cl": [
          {
            "nickname": "Jetblue",
            "flight_count": 149
          }
        ]
      },
      {
        "destination_name": "OAK - OAKLAND",
        "flight_count": 117,
        "total_distance": 41301,
        "percent_of_flights": 0.17700453857791226,
        "cl": [
          {
            "nickname": "Jetblue",
            "flight_count": 117
          }
        ]
      },
      {
        "destination_name": "DFW - DALLAS-FORT WORTH",
        "flight_count": 97,
        "total_distance": 118340,
        "percent_of_flights": 0.14674735249621784,
        "cl": [
          {
            "nickname": "American",
            "flight_count": 97
          }
        ]
      },
      {
        "destination_name": "IAD - WASHINGTON",
        "flight_count": 77,
        "total_distance": 175329,
        "percent_of_flights": 0.11649016641452345,
        "cl": [
          {
            "nickname": "Jetblue",
            "flight_count": 77
          }
        ]
      },
      {
        "destination_name": "LAS - LAS VEGAS",
        "flight_count": 56,
        "total_distance": 12936,
        "percent_of_flights": 0.08472012102874432,
        "cl": [
          {
            "nickname": "Jetblue",
            "flight_count": 56
          }
        ]
      },
      {
        "destination_name": "PHX - PHOENIX",
        "flight_count": 54,
        "total_distance": 19170,
        "percent_of_flights": 0.08169440242057488,
        "cl": [
          {
            "nickname": "America West",
            "flight_count": 54
          }
        ]
      }
    ],
    "carrier_name": [
      {
        "carrier_name": "Jetblue",
        "flight_count": 471
      },
      {
        "carrier_name": "American",
        "flight_count": 126
      },
      {
        "carrier_name": "America West",
        "flight_count": 54
      },
      {
        "carrier_name": "Alaska",
        "flight_count": 10
      }
    ],
    "dep_month": [
      {
        "dep_month": "2005-12-01T00:00:00.000Z",
        "flight_count": 19
      },
      {
        "dep_month": "2005-11-01T00:00:00.000Z",
        "flight_count": 22
      },
      {
        "dep_month": "2005-10-01T00:00:00.000Z",
        "flight_count": 23
      },
      {
        "dep_month": "2005-09-01T00:00:00.000Z",
        "flight_count": 14
      },
      {
        "dep_month": "2005-08-01T00:00:00.000Z",
        "flight_count": 13
      },
      {
        "dep_month": "2005-07-01T00:00:00.000Z",
        "flight_count": 24
      },
      {
        "dep_month": "2005-06-01T00:00:00.000Z",
        "flight_count": 23
      },
      {
        "dep_month": "2005-05-01T00:00:00.000Z",
        "flight_count": 12
      },
      {
        "dep_month": "2005-04-01T00:00:00.000Z",
        "flight_count": 3
      },
      {
        "dep_month": "2005-03-01T00:00:00.000Z",
        "flight_count": 5
      },
      {
        "dep_month": "2005-02-01T00:00:00.000Z",
        "flight_count": 8
      },
      {
        "dep_month": "2005-01-01T00:00:00.000Z",
        "flight_count": 17
      },
      {
        "dep_month": "2004-12-01T00:00:00.000Z",
        "flight_count": 13
      },
      {
        "dep_month": "2004-11-01T00:00:00.000Z",
        "flight_count": 10
      },
      {
        "dep_month": "2004-10-01T00:00:00.000Z",
        "flight_count": 9
      },
      {
        "dep_month": "2004-09-01T00:00:00.000Z",
        "flight_count": 18
      },
      {
        "dep_month": "2004-08-01T00:00:00.000Z",
        "flight_count": 17
      },
      {
        "dep_month": "2004-07-01T00:00:00.000Z",
        "flight_count": 15
      },
      {
        "dep_month": "2004-06-01T00:00:00.000Z",
        "flight_count": 15
      },
      {
        "dep_month": "2004-05-01T00:00:00.000Z",
        "flight_count": 6
      },
      {
        "dep_month": "2004-04-01T00:00:00.000Z",
        "flight_count": 11
      },
      {
        "dep_month": "2004-03-01T00:00:00.000Z",
        "flight_count": 10
      },
      {
        "dep_month": "2004-02-01T00:00:00.000Z",
        "flight_count": 12
      },
      {
        "dep_month": "2004-01-01T00:00:00.000Z",
        "flight_count": 10
      },
      {
        "dep_month": "2003-12-01T00:00:00.000Z",
        "flight_count": 15
      },
      {
        "dep_month": "2003-11-01T00:00:00.000Z",
        "flight_count": 17
      },
      {
        "dep_month": "2003-10-01T00:00:00.000Z",
        "flight_count": 19
      },
      {
        "dep_month": "2003-09-01T00:00:00.000Z",
        "flight_count": 21
      },
      {
        "dep_month": "2003-08-01T00:00:00.000Z",
        "flight_count": 11
      },
      {
        "dep_month": "2003-07-01T00:00:00.000Z",
        "flight_count": 15
      },
      {
        "dep_month": "2003-06-01T00:00:00.000Z",
        "flight_count": 25
      },
      {
        "dep_month": "2003-05-01T00:00:00.000Z",
        "flight_count": 17
      },
      {
        "dep_month": "2003-04-01T00:00:00.000Z",
        "flight_count": 17
      },
      {
        "dep_month": "2003-03-01T00:00:00.000Z",
        "flight_count": 12
      },
      {
        "dep_month": "2003-02-01T00:00:00.000Z",
        "flight_count": 3
      },
      {
        "dep_month": "2003-01-01T00:00:00.000Z",
        "flight_count": 33
      },
      {
        "dep_month": "2002-12-01T00:00:00.000Z",
        "flight_count": 5
      },
      {
        "dep_month": "2002-11-01T00:00:00.000Z",
        "flight_count": 3
      },
      {
        "dep_month": "2002-10-01T00:00:00.000Z",
        "flight_count": 7
      },
      {
        "dep_month": "2002-09-01T00:00:00.000Z",
        "flight_count": 5
      },
      {
        "dep_month": "2002-08-01T00:00:00.000Z",
        "flight_count": 2
      },
      {
        "dep_month": "2002-07-01T00:00:00.000Z",
        "flight_count": 4
      },
      {
        "dep_month": "2002-06-01T00:00:00.000Z",
        "flight_count": 1
      },
      {
        "dep_month": "2002-05-01T00:00:00.000Z",
        "flight_count": 2
      },
      {
        "dep_month": "2002-03-01T00:00:00.000Z",
        "flight_count": 3
      },
      {
        "dep_month": "2002-02-01T00:00:00.000Z",
        "flight_count": 3
      },
      {
        "dep_month": "2002-01-01T00:00:00.000Z",
        "flight_count": 1
      },
      {
        "dep_month": "2001-12-01T00:00:00.000Z",
        "flight_count": 3
      },
      {
        "dep_month": "2001-11-01T00:00:00.000Z",
        "flight_count": 2
      },
      {
        "dep_month": "2001-10-01T00:00:00.000Z",
        "flight_count": 2
      },
      {
        "dep_month": "2001-09-01T00:00:00.000Z",
        "flight_count": 4
      },
      {
        "dep_month": "2001-08-01T00:00:00.000Z",
        "flight_count": 4
      },
      {
        "dep_month": "2001-07-01T00:00:00.000Z",
        "flight_count": 2
      },
      {
        "dep_month": "2001-06-01T00:00:00.000Z",
        "flight_count": 3
      },
      {
        "dep_month": "2001-05-01T00:00:00.000Z",
        "flight_count": 5
      },
      {
        "dep_month": "2001-04-01T00:00:00.000Z",
        "flight_count": 2
      },
      {
        "dep_month": "2001-03-01T00:00:00.000Z",
        "flight_count": 3
      },
      {
        "dep_month": "2001-02-01T00:00:00.000Z",
        "flight_count": 4
      },
      {
        "dep_month": "2001-01-01T00:00:00.000Z",
        "flight_count": 9
      },
      {
        "dep_month": "2000-12-01T00:00:00.000Z",
        "flight_count": 4
      },
      {
        "dep_month": "2000-11-01T00:00:00.000Z",
        "flight_count": 1
      },
      {
        "dep_month": "2000-10-01T00:00:00.000Z",
        "flight_count": 1
      },
      {
        "dep_month": "2000-08-01T00:00:00.000Z",
        "flight_count": 5
      },
      {
        "dep_month": "2000-07-01T00:00:00.000Z",
        "flight_count": 7
      },
      {
        "dep_month": "2000-06-01T00:00:00.000Z",
        "flight_count": 4
      },
      {
        "dep_month": "2000-05-01T00:00:00.000Z",
        "flight_count": 7
      },
      {
        "dep_month": "2000-04-01T00:00:00.000Z",
        "flight_count": 4
      },
      {
        "dep_month": "2000-03-01T00:00:00.000Z",
        "flight_count": 7
      },
      {
        "dep_month": "2000-02-01T00:00:00.000Z",
        "flight_count": 6
      },
      {
        "dep_month": "2000-01-01T00:00:00.000Z",
        "flight_count": 2
      }
    ]
  }
]
WITH __stage0 AS (
  SELECT
    group_set,
    CASE WHEN group_set IN (1,2,3,4,5) THEN
      CONCAT(origin_0."code",' - ',origin_0."city")
      END as "origin_name__1",
    CASE WHEN group_set=1 THEN
      COUNT( 1)
      END as "flight_count__1",
    CASE WHEN group_set=1 THEN
      COALESCE(SUM(flights."distance"),0)
      END as "total_distance__1",
    (CASE WHEN group_set=1 THEN
      COUNT( 1)
      END)*1.0/MAX((CASE WHEN group_set=0 THEN
      COUNT( 1)
      END)) OVER () as "percent_of_flights__1",
    CASE WHEN group_set IN (2,3) THEN
      CONCAT(destination_0."code",' - ',destination_0."city")
      END as "destination_name__2",
    CASE WHEN group_set=2 THEN
      COUNT( 1)
      END as "flight_count__2",
    CASE WHEN group_set=2 THEN
      COALESCE(SUM(flights."distance"),0)
      END as "total_distance__2",
    (CASE WHEN group_set=2 THEN
      COUNT( 1)
      END)*1.0/MAX((CASE WHEN group_set=1 THEN
      COUNT( 1)
      END)) OVER (PARTITION BY CASE WHEN group_set IN (1,2,3,4,5) THEN
      CONCAT(origin_0."code",' - ',origin_0."city")
      END) as "percent_of_flights__2",
    CASE WHEN group_set=3 THEN
      carriers_0."nickname"
      END as "nickname__3",
    CASE WHEN group_set=3 THEN
      COUNT( 1)
      END as "flight_count__3",
    CASE WHEN group_set=4 THEN
      carriers_0."nickname"
      END as "carrier_name__4",
    CASE WHEN group_set=4 THEN
      COUNT( 1)
      END as "flight_count__4",
    CASE WHEN group_set=5 THEN
      DATE_TRUNC('month', flights."dep_time")
      END as "dep_month__5",
    CASE WHEN group_set=5 THEN
      COUNT( 1)
      END as "flight_count__5"
  FROM '../../documentation/data/flights.parquet' as flights
   LEFT JOIN '../../documentation/data/airports.parquet' AS origin_0
    ON origin_0."code"=flights."origin"
   LEFT JOIN '../../documentation/data/airports.parquet' AS destination_0
    ON destination_0."code"=flights."destination"
   LEFT JOIN '../../documentation/data/carriers.parquet' AS carriers_0
    ON carriers_0."code"=flights."carrier"
  CROSS JOIN (SELECT UNNEST(GENERATE_SERIES(0,5,1)) as group_set  ) as group_set
  WHERE origin_0."state"='CA'
  GROUP BY 1,2,6,10,12,14
)
, __stage1 AS (
  SELECT 
    CASE WHEN group_set=3 THEN 2  ELSE group_set END as group_set,
    CASE WHEN group_set IN (1,2,3,4,5) THEN
      "origin_name__1"
      END as "origin_name__1",
    FIRST("flight_count__1") FILTER (WHERE "flight_count__1" IS NOT NULL) as "flight_count__1",
    FIRST("total_distance__1") FILTER (WHERE "total_distance__1" IS NOT NULL) as "total_distance__1",
    FIRST("percent_of_flights__1") FILTER (WHERE "percent_of_flights__1" IS NOT NULL) as "percent_of_flights__1",
    CASE WHEN group_set IN (2,3) THEN
      "destination_name__2"
      END as "destination_name__2",
    FIRST("flight_count__2") FILTER (WHERE "flight_count__2" IS NOT NULL) as "flight_count__2",
    FIRST("total_distance__2") FILTER (WHERE "total_distance__2" IS NOT NULL) as "total_distance__2",
    FIRST("percent_of_flights__2") FILTER (WHERE "percent_of_flights__2" IS NOT NULL) as "percent_of_flights__2",
    COALESCE(LIST({
      "nickname": "nickname__3", 
      "flight_count": "flight_count__3"}  ORDER BY  "flight_count__3" desc NULLS LAST) FILTER (WHERE group_set=3),[]) as "cl__2",
    CASE WHEN group_set=4 THEN
      "carrier_name__4"
      END as "carrier_name__4",
    FIRST("flight_count__4") FILTER (WHERE "flight_count__4" IS NOT NULL) as "flight_count__4",
    CASE WHEN group_set=5 THEN
      "dep_month__5"
      END as "dep_month__5",
    FIRST("flight_count__5") FILTER (WHERE "flight_count__5" IS NOT NULL) as "flight_count__5"
  FROM __stage0
  WHERE group_set NOT IN (0)
  GROUP BY 1,2,6,11,13
)
SELECT
  "origin_name__1" as "origin_name",
  MAX(CASE WHEN group_set=1 THEN "flight_count__1" END) as "flight_count",
  MAX(CASE WHEN group_set=1 THEN "total_distance__1" END) as "total_distance",
  MAX(CASE WHEN group_set=1 THEN "percent_of_flights__1" END) as "percent_of_flights",
  COALESCE(LIST({
    "destination_name": "destination_name__2", 
    "flight_count": "flight_count__2", 
    "total_distance": "total_distance__2", 
    "percent_of_flights": "percent_of_flights__2", 
    "cl": "cl__2"}  ORDER BY  "flight_count__2" desc NULLS LAST) FILTER (WHERE group_set=2)[1:6],[]) as "destination_name",
  COALESCE(LIST({
    "carrier_name": "carrier_name__4", 
    "flight_count": "flight_count__4"}  ORDER BY  "flight_count__4" desc NULLS LAST) FILTER (WHERE group_set=4),[]) as "carrier_name",
  COALESCE(LIST({
    "dep_month": "dep_month__5", 
    "flight_count": "flight_count__5"}  ORDER BY  "dep_month__5" desc NULLS LAST) FILTER (WHERE group_set=5),[]) as "dep_month"
FROM __stage1
GROUP BY 1
ORDER BY 2 desc NULLS LAST

Wait, that looks really complex? What do those things mean?

If you press the control key and hover over any of the terms, the Malloy VSCode extension will show you the semantic definition for the term.

Back to Step 1: How big is the pile?

Ok, let's slow down and go step by step.

Often, the first thing you want to know is, how big is the dataset?

document
run: flights-> flight_count
QUERY RESULTS
flight_​count
344,827
[
  {
    "flight_count": 344827
  }
]
SELECT 
   COUNT( 1) as "flight_count"
FROM '../../documentation/data/flights.parquet' as flights

In Malloy, queries start with run: <source>. In this case, flights. The -> is the query transform operator. The right hand side of the -> is the query transformation. In this case we want a simple measure, flight_count.

Dimensions and Measures

As we talked about earlier. Aggregating queries have two parts: what you want to group by, and what you want to measure about things in that group. Let's group the flights by the origin, and count how many flights. When building a query, we use the + operator to combine the parts.

document
run: flights -> origin_name + flight_count 
QUERY RESULTS
origin_​nameflight_​count
ATL - ATLANTA17,875
DFW - DALLAS-FORT WORTH17,782
ORD - CHICAGO14,214
PHX - PHOENIX12,476
LAS - LAS VEGAS11,096
LAX - LOS ANGELES11,077
MSP - MINNEAPOLIS9,762
DTW - DETROIT8,161
PHL - PHILADELPHIA7,708
LGA - NEW YORK7,623
DEN - DENVER7,190
BWI - BALTIMORE7,177
CLT - CHARLOTTE7,099
SEA - SEATTLE7,010
MCO - ORLANDO6,790
DCA - WASHINGTON6,678
IAH - HOUSTON6,623
MDW - CHICAGO6,611
BOS - BOSTON5,797
EWR - NEWARK5,174
CLE - CLEVELAND5,127
OAK - OAKLAND5,076
SAN - SAN DIEGO5,075
TPA - TAMPA4,868
PIT - PITTSBURGH4,541
SFO - SAN FRANCISCO4,540
BNA - NASHVILLE4,287
STL - ST LOUIS4,089
MCI - KANSAS CITY4,078
IAD - WASHINGTON3,885
SJC - SAN JOSE3,825
JFK - NEW YORK3,689
FLL - FORT LAUDERDALE3,619
PDX - PORTLAND3,596
SMF - SACRAMENTO3,576
HOU - HOUSTON3,430
CVG - COVINGTON/CINCINNATI, OH3,300
MSY - NEW ORLEANS3,254
ABQ - ALBUQUERQUE2,762
SLC - SALT LAKE CITY2,741
ONT - ONTARIO2,642
RDU - RALEIGH/DURHAM2,444
MIA - MIAMI2,387
PVD - PROVIDENCE2,361
MEM - MEMPHIS2,242
IND - INDIANAPOLIS2,226
BDL - WINDSOR LOCKS2,168
AUS - AUSTIN2,091
RNO - RENO1,992
BUR - BURBANK1,952
SNA - SANTA ANA1,919
SAT - SAN ANTONIO1,865
CMH - COLUMBUS1,712
DAL - DALLAS1,662
MHT - MANCHESTER1,626
JAX - JACKSONVILLE1,599
ELP - EL PASO1,438
PBI - WEST PALM BEACH1,379
ISP - ISLIP1,302
BUF - BUFFALO1,246
BHM - BIRMINGHAM1,200
RSW - FORT MYERS1,169
MKE - MILWAUKEE1,132
ALB - ALBANY1,108
TUS - TUCSON1,062
SDF - LOUISVILLE1,003
TUL - TULSA984
OMA - OMAHA946
RIC - RICHMOND946
GEG - SPOKANE922
OKC - OKLAHOMA CITY905
ORF - NORFOLK888
LIT - LITTLE ROCK853
BOI - BOISE795
PFN - PANAMA CITY778
AGS - AUGUSTA756
ANC - ANCHORAGE748
ROC - ROCHESTER733
AVL - ASHEVILLE727
CHA - CHATTANOOGA697
LGB - LONG BEACH661
CSG - COLUMBUS654
SJU - SAN JUAN645
MYR - MYRTLE BEACH628
HSV - HUNTSVILLE607
SYR - SYRACUSE597
MDT - HARRISBURG584
TRI - BRISTOL/JOHNSON/KINGSPORT566
GRR - GRAND RAPIDS513
ABE - ALLENTOWN510
MGM - MONTGOMERY500
ACT - WACO494
TYR - TYLER480
GSO - GREENSBORO470
GNV - GAINESVILLE470
CHS - CHARLESTON466
TYS - KNOXVILLE464
SPS - WICHITA FALLS457
CLL - COLLEGE STATION454
COS - COLORADO SPRINGS426
LBB - LUBBOCK425
LAW - LAWTON423
SAV - SAVANNAH419
ILE - KILLEEN416
DAY - DAYTON416
MAF - MIDLAND409
SHV - SHREVEPORT406
VPS - VALPARAISO403
CAE - COLUMBIA376
JAN - JACKSON356
PWM - PORTLAND326
DHN - DOTHAN324
XNA - FAYETTEVILLE/SPRINGDALE/319
HPN - WHITE PLAINS315
BTV - BURLINGTON307
LEX - LEXINGTON305
AMA - AMARILLO298
ABI - ABILENE297
TLH - TALLAHASSEE285
GPT - GULFPORT278
BTR - BATON ROUGE274
MSN - MADISON271
HNL - HONOLULU267
GGG - LONGVIEW258
DSM - DES MOINES254
GSP - GREER241
PSP - PALM SPRINGS240
SJT - SAN ANGELO223
TXK - TEXARKANA207
FSM - FORT SMITH