Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: Carrier
| CARRIER_ID   | CARRIER_NAME                            |
|:-------------|:----------------------------------------|
| WG           | Sunwing Airlines Inc.                   |
| W8           | Cargojet Airways Ltd.                   |
| G7           | GoJet Airlines LLC d/b/a United Express |
| 8E           | Bering Air Inc.                         |
| LA           | Lan-Chile Airlines                      |
| G3           | VRG Linhas Aereas S A                   |
| 4W           | Warbelow                                |
| D7           | Air Asia X Berhad dba Airasia X         |
| GEQ          | Gestair, S.A.                           |
| 2OQ          | Talofa Airways Limited                  |


Table: CarrierDomSalesData
| DATEKEY                 |   YEAR |   QUARTER | ORIGIN   |   ONLINE | REPORTING_CARRIER   |   FLIGHTS |   PASSENGERS |   TOTAL_SALES |   MILES_FLOWN |         km_flown |
|:------------------------|-------:|----------:|:---------|---------:|:--------------------|----------:|-------------:|--------------:|--------------:|-----------------:|
| 2019-06-30 00:00:00.000 |   2019 |         2 | MSY      |        0 | OO                  |        30 |           33 |         16185 |         87887 | 141410           |
| 2019-06-30 00:00:00.000 |   2019 |         2 | SBA      |        0 | OO                  |      1503 |         1647 |        813619 |       4613509 |      7.42314e+06 |
| 2019-06-30 00:00:00.000 |   2019 |         2 | PAH      |        0 | OO                  |       241 |          245 |        120899 |        556642 | 895637           |
| 2019-06-30 00:00:00.000 |   2019 |         2 | MOB      |        0 | OO                  |       605 |          614 |        321203 |       1068098 |      1.71857e+06 |
| 2019-06-30 00:00:00.000 |   2019 |         2 | BOS      |        0 | OO                  |       523 |          604 |        219092 |        872890 |      1.40448e+06 |
| 2019-06-30 00:00:00.000 |   2019 |         2 | RDM      |        0 | OO                  |      1590 |         1654 |        706815 |       4851738 |      7.80645e+06 |
| 2019-06-30 00:00:00.000 |   2019 |         2 | HIB      |        0 | OO                  |       275 |          285 |        137855 |        682863 |      1.09873e+06 |
| 2019-06-30 00:00:00.000 |   2019 |         2 | EWN      |        0 | OO                  |         1 |            1 |           351 |          1161 |   1868.05        |
| 2019-06-30 00:00:00.000 |   2019 |         2 | LBF      |        0 | OO                  |       209 |          221 |        103510 |        469717 | 755775           |
| 2019-06-30 00:00:00.000 |   2019 |         2 | GRK      |        0 | OO                  |       158 |          163 |         68536 |        277376 | 446298           |


Table: CarrierEmployeeByCategory
| DATEKEY                 |   YEAR | UNIQUE_CARRIER   |   GENERAL_MANAGE |   PILOTS_COPILOTS |   OTHER_FLT_PERS |   PASS_GEN_SVC_ADMIN |   MAINTENANCE |   ARCFT_TRAF_HANDLING_GRP1 |   GEN_ARCFT_TRAF_HANDLING |   AIRCRAFT_CONTROL |   PASSENGER_HANDLING |   CARGO_HANDLING |   TRAINEES_INTRUCTOR |   STATISTICAL |   TRAFFIC_SOLICITERS |   OTHER |   TRANSPORT_RELATED |   TOTAL |
|:------------------------|-------:|:-----------------|-----------------:|------------------:|-----------------:|---------------------:|--------------:|---------------------------:|--------------------------:|-------------------:|---------------------:|-----------------:|---------------------:|--------------:|---------------------:|--------:|--------------------:|--------:|
| 2019-12-31 00:00:00.000 |   2019 | 0WQ              |                4 |                51 |                5 |                   18 |            28 |                         20 |                         0 |                  0 |                    0 |                3 |                    1 |            17 |                    0 |       7 |                   0 |     154 |
| 2019-12-31 00:00:00.000 |   2019 | 1BQ              |                2 |                35 |                0 |                   35 |            15 |                         17 |                         0 |                  0 |                    0 |                0 |                    0 |            26 |                    0 |       0 |                   0 |     130 |
| 2019-12-31 00:00:00.000 |   2019 | 2HQ              |               11 |                47 |                0 |                   32 |            31 |                         37 |                         0 |                  0 |                    0 |                0 |                    4 |            11 |                    0 |       0 |                   0 |     173 |
| 2019-12-31 00:00:00.000 |   2019 | 5V               |               12 |                50 |               14 |                    0 |           114 |                         88 |                         0 |                  0 |                    0 |                0 |                    5 |            43 |                    6 |      22 |                   0 |     354 |
| 2019-12-31 00:00:00.000 |   2019 | 5X               |                0 |               358 |                0 |                    0 |           258 |                          0 |                        15 |                 17 |                    0 |                0 |                   22 |            81 |                    2 |      14 |                   0 |     767 |
| 2019-12-31 00:00:00.000 |   2019 | 5X               |                0 |              1748 |                0 |                    0 |          1257 |                          0 |                        75 |                 81 |                    0 |                0 |                  109 |           397 |                   10 |      69 |                   0 |    3746 |
| 2019-12-31 00:00:00.000 |   2019 | 5X               |                0 |               146 |                0 |                    0 |           105 |                          0 |                         6 |                  7 |                    0 |                0 |                    9 |            33 |                    1 |       6 |                   0 |     313 |
| 2019-12-31 00:00:00.000 |   2019 | 5X               |                0 |               473 |                0 |                    0 |           340 |                          0 |                        20 |                 22 |                    0 |                0 |                   29 |           108 |                    3 |      19 |                   0 |    1014 |
| 2019-12-31 00:00:00.000 |   2019 | 5Y               |              304 |              1543 |              118 |                  222 |           194 |                          0 |                         0 |                 34 |                    0 |              250 |                   30 |            49 |                   38 |      16 |                   0 |    2798 |
| 2019-12-31 00:00:00.000 |   2019 | 5Y               |               21 |               108 |                8 |                   16 |            14 |                          0 |                         0 |                  2 |                    0 |               17 |                    2 |             3 |                    2 |       1 |                   0 |     194 |


Table: CarrierEmployeeSummary
| DATEKEY                 |   YEAR |   MONTH | UNIQUE_CARRIER   |   EMPFULL |   EMPPART |   EMPTOTAL |   EMPFTE |
|:------------------------|-------:|--------:|:-----------------|----------:|----------:|-----------:|---------:|
| 2019-03-31 00:00:00.000 |   2019 |       3 | 0WQ              |       154 |         0 |        154 |      154 |
| 2019-03-31 00:00:00.000 |   2019 |       3 | 2PQ              |        69 |         0 |         69 |       69 |
| 2019-03-31 00:00:00.000 |   2019 |       3 | 8C               |       607 |         0 |        607 |      607 |
| 2019-03-31 00:00:00.000 |   2019 |       3 | 9S               |       329 |         0 |        329 |      329 |
| 2019-03-31 00:00:00.000 |   2019 |       3 | AMQ              |        52 |         0 |         52 |       52 |
| 2019-03-31 00:00:00.000 |   2019 |       3 | CP               |      1704 |         0 |       1704 |     1704 |
| 2019-03-31 00:00:00.000 |   2019 |       3 | G7               |      1258 |         0 |       1258 |     1258 |
| 2019-03-31 00:00:00.000 |   2019 |       3 | GFQ              |       112 |         0 |        112 |      112 |
| 2019-03-31 00:00:00.000 |   2019 |       3 | KLQ              |       148 |         0 |        148 |      148 |
| 2019-03-31 00:00:00.000 |   2019 |       3 | M6               |       685 |         0 |        685 |      685 |


Table: CarrierIntlFlightData
| DATEKEY                 |   YEAR |   QUARTER |   MONTH | UNIQUE_CARRIER   | ORIGIN   | DEST   |   PASSENGERS |   FREIGHT_KG |   MAIL_COUNT |   DISTANCE_KM |   FLIGHTCOUNT |
|:------------------------|-------:|----------:|--------:|:-----------------|:---------|:-------|-------------:|-------------:|-------------:|--------------:|--------------:|
| 2019-03-31 00:00:00.000 |   2019 |         1 |       3 | UA               | ABQ      | GUA    |            0 |            0 |            0 |          1727 |             1 |
| 2019-02-28 00:00:00.000 |   2019 |         1 |       2 | UA               | ANU      | RSW    |            0 |            0 |            0 |          1433 |             1 |
| 2019-02-28 00:00:00.000 |   2019 |         1 |       2 | UA               | AUA      | CLT    |            0 |            0 |            0 |          1706 |             1 |
| 2019-08-31 00:00:00.000 |   2019 |         3 |       8 | UA               | AUA      | RDU    |            0 |            0 |            0 |          1700 |             1 |
| 2019-05-31 00:00:00.000 |   2019 |         2 |       5 | UA               | BDA      | BOS    |            0 |            0 |            0 |           772 |             1 |
| 2019-08-31 00:00:00.000 |   2019 |         3 |       8 | UA               | BDA      | IAH    |            0 |            0 |            0 |          1818 |             1 |
| 2019-06-30 00:00:00.000 |   2019 |         2 |       6 | UA               | BDA      | OMA    |            0 |            0 |            0 |          1825 |             1 |
| 2019-06-30 00:00:00.000 |   2019 |         2 |       6 | UA               | BOG      | MCO    |            0 |            0 |            0 |          1698 |             1 |
| 2019-09-30 00:00:00.000 |   2019 |         3 |       9 | UA               | BOS      | DUB    |            0 |            0 |            0 |          2993 |             1 |
| 2019-10-31 00:00:00.000 |   2019 |         4 |      10 | UA               | BOS      | YYZ    |            0 |            0 |            0 |           446 |             1 |


Table: Dates
| datekey                 |   year |   quarter |   month | month_name   | date_desc               |
|:------------------------|-------:|----------:|--------:|:-------------|:------------------------|
| 2018-01-31 00:00:00.000 |   2018 |         1 |       1 | January      | 2018-01-01 00:00:00.000 |
| 2018-02-28 00:00:00.000 |   2018 |         1 |       2 | February     | 2018-02-01 00:00:00.000 |
| 2018-03-31 00:00:00.000 |   2018 |         1 |       3 | March        | 2018-03-01 00:00:00.000 |
| 2018-04-30 00:00:00.000 |   2018 |         2 |       4 | April        | 2018-04-01 00:00:00.000 |
| 2018-05-31 00:00:00.000 |   2018 |         2 |       5 | May          | 2018-05-01 00:00:00.000 |
| 2018-06-30 00:00:00.000 |   2018 |         2 |       6 | June         | 2018-06-01 00:00:00.000 |
| 2018-07-31 00:00:00.000 |   2018 |         3 |       7 | July         | 2018-07-01 00:00:00.000 |
| 2018-08-31 00:00:00.000 |   2018 |         3 |       8 | August       | 2018-08-01 00:00:00.000 |
| 2018-09-30 00:00:00.000 |   2018 |         3 |       9 | September    | 2018-09-01 00:00:00.000 |
| 2018-10-31 00:00:00.000 |   2018 |         4 |      10 | October      | 2018-10-01 00:00:00.000 |


Table: DestinationAirport
| airport_id   | type          | name                          |   latitude_deg |   longitude_deg |   elevation_ft | continent   | iso_country   | iso_region   | municipality    | URL                                |
|:-------------|:--------------|:------------------------------|---------------:|----------------:|---------------:|:------------|:--------------|:-------------|:----------------|:-----------------------------------|
| LVD          | small_airport | Lime Village Airport          |        61.3591 |        -155.44  |            552 | NA          | US            | US-AK        | Lime Village    | https://airportcod.es/=airport/LVD |
| HGZ          | small_airport | Hog River Airport             |        66.2161 |        -155.669 |            534 | NA          | US            | US-AK        | Hogatza         | https://airportcod.es/=airport/HGZ |
| TLF          | small_airport | Telida Airport                |        63.3939 |        -153.269 |            650 | NA          | US            | US-AK        | Telida          | https://airportcod.es/=airport/TLF |
| KKK          | small_airport | Kalakaket Creek AS Airport    |        64.4166 |        -156.82  |           1598 | NA          | US            | US-AK        | Kalakaket Creek | https://airportcod.es/=airport/KKK |
| ELW          | seaplane_base | Ellamar Seaplane Base         |        60.8938 |        -146.704 |              0 | NA          | US            | US-AK        | Ellamar         | https://airportcod.es/=airport/ELW |
| HBH          | seaplane_base | Entrance Island Seaplane Base |        57.4122 |        -133.439 |              0 | NA          | US            | US-AK        | Entrance Island | https://airportcod.es/=airport/HBH |
| FAK          | seaplane_base | False Island Seaplane Base    |        57.5322 |        -135.213 |              0 | NA          | US            | US-AK        | False Island    | https://airportcod.es/=airport/FAK |
| WLR          | seaplane_base | Loring Seaplane Base          |        55.6013 |        -131.637 |              0 | NA          | US            | US-AK        | Loring          | https://airportcod.es/=airport/WLR |
| NUP          | small_airport | Nunapitchuk Airport           |        60.9056 |        -162.44  |             12 | NA          | US            | US-AK        | Nunapitchuk     | https://airportcod.es/=airport/NUP |
| PTC          | seaplane_base | Port Alice Seaplane Base      |        55.803  |        -133.597 |              0 | NA          | US            | US-AK        | Port Alice      | https://airportcod.es/=airport/PTC |


Table: FinancialsQrtlyBalanceSheet
| DATEKEY                 |   YEAR |   QUARTER | UNIQUE_CARRIER   |     CASH |   SHORT_TERM_INV |   NOTES_RECEIVABLE |   ACCTS_RECEIVABLE |   ACCTS_NOT_COLLECT |   NOTES_ACC_REC_NET |   PARTS_SUPPLIES_NET |   PREPAID_ITEMS |   CURR_ASSETS_OTH |   CURR_ASSETS |   INVEST_ASSOC_COMP |   INVEST_REC_OTH |   SPECIAL_FUNDS |   INVEST_SPEC_FUNDS |   FLIGHT_EQUIP |   PROP_EQUIP_GROUND |   DEPR_PR_EQ_GROUND |   PROP_EQUIP_NET |   LAND |   EQUIP_DEP_ADV_PAY |   CONSTRUCTION |   LEASED_PROP_CAP |   LEASED_PROP_ACC |   PROP_EQUIP |   PROP_EQUIP_NON_OP |   DEPR_PR_EQ_NON_OP |   PROP_EQUIP_NO_TOT |   PRE_PAY_LONG_TERM |   NON_AMORT_DEV |   ASSETS_OTH_DEF |   ASSETS_OTHER |   ASSETS |   LONG_DEBT_CUR_MAT |   NOTES_PAY_BANKS |   NOTES_PAY_OTHER |   ACCTS_PAY_TRADE |   ACCTS_PAY_OTHER |   CURR_OB_CAP_LEASE |   ACCR_SALARIES |   ACCR_VACATION |   ACCR_INTEREST |   ACCR_TAXES |   DIVIDENDS |   LIAB_AIR_TRAFFIC |   CURR_LIAB_OTH |   CURR_LIABILITIES |   LONG_TERM_DEBT |   ADV_ASSOC_COMP |   PENSION_LIAB |   NON_REC_OB_CAP_LS |   NON_REC_LIAB_OTH |   NON_REC_LIAB |   DEF_TAXES |   DEF_TAX_CREDITS |   DEF_CREDITS_OTH |   DEF_CREDITS |   PF_SHARES |   PF_SHARES_NUM |   COM_SHARES |   UNISSUED_STOCK |   CAPITAL_STOCK |   ADD_CAPITAL_INV |   PAID_IN_CAPITAL |   RET_EARNINGS |   SH_HLD_EQUITY |   TREAS_STOCK_NUM |   SH_HLD_EQUIT_NET |   LIAB_SH_HLD_EQUITY |
|:------------------------|-------:|----------:|:-----------------|---------:|-----------------:|-------------------:|-------------------:|--------------------:|--------------------:|---------------------:|----------------:|------------------:|--------------:|--------------------:|-----------------:|----------------:|--------------------:|---------------:|--------------------:|--------------------:|-----------------:|-------:|--------------------:|---------------:|------------------:|------------------:|-------------:|--------------------:|--------------------:|--------------------:|--------------------:|----------------:|-----------------:|---------------:|---------:|--------------------:|------------------:|------------------:|------------------:|------------------:|--------------------:|----------------:|----------------:|----------------:|-------------:|------------:|-------------------:|----------------:|-------------------:|-----------------:|-----------------:|---------------:|--------------------:|-------------------:|---------------:|------------:|------------------:|------------------:|--------------:|------------:|----------------:|-------------:|-----------------:|----------------:|------------------:|------------------:|---------------:|----------------:|------------------:|-------------------:|---------------------:|
| 2019-03-31 00:00:00.000 |   2019 |         1 | U7               | -4075    |             0    |                  0 |           84655.9  |                0    |            84655.9  |                 0    |         2696.6  |          12992.9  |       96270.4 |                 0   |                0 |               0 |                 0   |       19874.7  |             5100.78 |            19967.2  |          5008.19 |      0 |                   0 |       10895.6  |               0   |              0    |     15903.8  |             2255.3  |             1196.38 |             1058.92 |                0    |               0 |         51837.9  |       51837.9  | 165071   |                   0 |                 0 |                 0 |          54654.1  |              0    |                 0   |         1178.55 |            0    |            0    |      2654.76 |           0 |                  0 |         4892.16 |            63379.6 |                0 |              0   |              0 |                 0   |             776.98 |         776.98 |        0    |                 0 |                 0 |          0    |           0 |               0 |         0    |                0 |            0    |           69141.7 |          69141.7  |        31772.8 |       100914    |                 0 |          100914    |             165071   |
| 2019-09-30 00:00:00.000 |   2019 |         3 | U7               | -2846.75 |             0    |                  0 |           51794.8  |                0    |            51794.8  |                 0    |         1898.07 |          13738.5  |       64584.7 |                 0   |                0 |               0 |                 0   |       20826.2  |             5186.66 |            22755    |          3257.8  |      0 |                   0 |        4322.77 |               0   |              0    |      7579.57 |             2344.91 |             1380.28 |              964.63 |                0    |               0 |         20639    |       20639    |  93767.9 |                   0 |                 0 |                 0 |          37311    |              0    |                 0   |         1101.78 |            0    |            0    |       946.72 |           0 |                  0 |         1873.14 |            41232.6 |                0 |              0   |              0 |                 0   |            1057.49 |        1057.49 |        0    |                 0 |                 0 |          0    |           0 |               0 |         0    |                0 |            0    |           22115.3 |          22115.3  |        29362.5 |        51477.8  |                 0 |           51477.8  |              93767.9 |
| 2019-12-31 00:00:00.000 |   2019 |         4 | U7               | -2638.52 |             0    |                  0 |           69475.8  |                0    |            69475.8  |                 0    |         2026.67 |          13345.5  |       82209.4 |                 0   |                0 |               0 |                 0   |       21611.5  |             5195.38 |            24247    |          2559.82 |      0 |                   0 |        3956.49 |               0   |              0    |      6516.31 |             2926.93 |             1457.99 |             1468.93 |                0    |               0 |         22386.4  |       22386.4  | 112581   |                   0 |                 0 |                 0 |          50826.3  |              0    |                 0   |         1898.51 |            0    |            0    |      1552.47 |           0 |                  0 |         1898.88 |            56176.2 |                0 |              0   |              0 |                 0   |            2269.39 |        2269.39 |        0    |                 0 |                 0 |          0    |           0 |               0 |         0    |                0 |            0    |           21818.5 |          21818.5  |        32317   |        54135.4  |                 0 |           54135.4  |             112581   |
| 2019-12-31 00:00:00.000 |   2019 |         4 | 9E               |  -463.38 |             0    |                  0 |           69573    |                0    |            69573    |             38909.2  |         1129    |              0    |      109148   |                 0   |                0 |               0 |                 0   |       68574.9  |            28522.2  |            30294.1  |         66803    |      0 |                   0 |           0    |           17849.9 |           1558.85 |     83094.1  |                0    |                0    |                0    |                0    |               0 |         33026.3  |       33026.3  | 225268   |                5625 |                 0 |                 0 |          17899.2  |          31573.4  |              2625.9 |        22373.4  |        15362.1  |           50.25 |      7428.74 |           0 |                  0 |        37098.7  |           140037   |                0 |          12656.2 |              0 |             13962.2 |           27435.9  |       54054.4  |        0    |                 0 |                 0 |          0    |           0 |               0 |         0    |                0 |            0    |          307232   |         307232    |      -276054   |        31177.1  |                 0 |           31177.1  |             225268   |
| 2019-06-30 00:00:00.000 |   2019 |         2 | U7               |  -457.64 |             0    |                  0 |           52327.3  |                0    |            52327.3  |                 0    |         2594.69 |          13294.2  |       67758.6 |                 0   |                0 |               0 |                 0   |       20570    |             5123.48 |            21352.6  |          4340.84 |      0 |                   0 |        3630.69 |               0   |              0    |      7971.54 |             2255.3  |             1288.41 |              966.9  |                0    |               0 |         21400.4  |       21400.4  |  98097.4 |                   0 |                 0 |                 0 |          38049.2  |              0    |                 0   |         1689.08 |            0    |            0    |      1264.66 |           0 |                  0 |         1893.47 |            42896.4 |                0 |              0   |              0 |                 0   |            1073.36 |        1073.36 |        0    |                 0 |                 0 |          0    |           0 |               0 |         0    |                0 |            0    |           24967.7 |          24967.7  |        29160   |        54127.6  |                 0 |           54127.6  |              98097.4 |
| 2019-06-30 00:00:00.000 |   2019 |         2 | GL               |  -351.59 |             0    |                  0 |           -2594.38 |                0    |            -2594.38 |              1301.56 |         1383.1  |           7875.22 |        7613.9 |                 0   |                0 |               0 |                 0   |       12174.8  |             6491.65 |            12524.9  |          6141.5  |      0 |                   0 |           0    |               0   |              0    |      6141.5  |                0    |                0    |                0    |             2666.67 |               0 |             0    |        2666.67 |  16422.1 |                   0 |                 0 |                 0 |           -997.07 |          10270.1  |                 0   |            0    |            0    |            0    |         0    |           0 |                  0 |         7875.22 |            17148.2 |                0 |              0   |              0 |                 0   |            1679.88 |        1679.88 |        0    |                 0 |                 0 |          0    |           1 |               0 |      1003.75 |                0 |         1004.75 |               0   |           1004.75 |        -3410.8 |        -2406.06 |                 0 |           -2406.06 |              16422.1 |
| 2019-09-30 00:00:00.000 |   2019 |         3 | 8C               |  -272.39 |             0    |                  0 |           39248.4  |              189.04 |            39059.3  |                 0    |         1261.19 |            294.82 |       40343   |                 0   |                0 |               0 |                 0   |       76051    |             6825.78 |            45895.1  |         36981.8  |      0 |                   0 |           0    |               0   |              0    |     36981.8  |                0    |                0    |                0    |                0    |               0 |         35096.1  |       35096.1  | 112421   |                   0 |                 0 |                 0 |          20065.7  |              0    |                 0   |         2962.63 |         3290.21 |            0    |       867.56 |           0 |                  0 |         9868.65 |            37054.8 |                0 |          89230   |              0 |                 0   |             565.9  |       89795.9  |     7033.06 |                 0 |                 0 |       7033.06 |           0 |               0 |         0    |                0 |            0    |           39449.5 |          39449.5  |       -60912.5 |       -21463    |                 0 |          -21463    |             112421   |
| 2019-12-31 00:00:00.000 |   2019 |         4 | 8C               |    -7.22 |             0    |                  0 |           50652    |              239.31 |            50412.7  |               360.38 |         2689.27 |            297.82 |       53752.9 |                 0   |                0 |               0 |                 0   |       80407.1  |             6911.5  |            48497.8  |         38820.8  |      0 |                   0 |           0    |               0   |              0    |     38820.8  |                0    |                0    |                0    |                0    |               0 |         31226.3  |       31226.3  | 123800   |                   0 |                 0 |                 0 |          23322.4  |              0    |                 0   |         6908.28 |         3576.63 |            0    |      1133.18 |           0 |                  0 |        11990.6  |            46931.1 |                0 |          85359.6 |              0 |                 0   |             537.19 |       85896.8  |     6720.92 |                 0 |                 0 |       6720.92 |           0 |               0 |         0    |                0 |            0    |           39449.5 |          39449.5  |       -55198.3 |       -15748.8  |                 0 |          -15748.8  |             123800   |
| 2019-03-31 00:00:00.000 |   2019 |         1 | 27Q              |     0    |           -22.75 |                  0 |           66516.9  |             2062.67 |            64454.3  |                 0    |          -17.97 |            353.92 |       64767.5 |             39599.5 |                0 |               0 |             39599.5 |           0    |             2293.95 |             1547.52 |           746.43 |      0 |                   0 |           0    |               0   |              0    |       746.43 |                0    |                0    |                0    |                0    |               0 |           846.97 |         846.97 | 105960   |                   0 |                 0 |                 0 |           9030.08 |              0    |                 0   |         6017.14 |            0    |            0    |       915.81 |           0 |                  0 |        33212.7  |            49175.7 |                0 |              0   |              0 |                 0   |               0    |           0    |        0    |                 0 |                 0 |          0    |           0 |               0 |         0    |                0 |            0    |               0   |              0    |        56784.7 |        56784.7  |                 0 |           56784.7  |             105960   |
| 2019-03-31 00:00:00.000 |   2019 |         1 | CP               |     0    |         16130.6  |                  0 |           15253.4  |               26.75 |            15226.6  |             12331.2  |          834.43 |           1390.27 |       45913.2 |                 0   |                0 |               0 |                 0   |        3991.72 |            13182.4  |            11267.4  |          5906.79 |      0 |                   0 |           0    |               0   |              0    |      5906.79 |                0    |                0    |                0    |                0    |               0 |          3022.78 |        3022.78 |  54842.8 |                   0 |                 0 |                 0 |          16136.6  |            354.05 |                 0   |         4239.95 |         2927.29 |            0    |         0    |           0 |                  0 |         6817.84 |            30475.8 |                0 |              0   |              0 |                 0   |               0    |           0    |        0    |                 0 |                 0 |          0    |           0 |               0 |         0.01 |                0 |            0.01 |           14093.5 |          14093.5  |        10273.5 |        24367    |                 0 |           24367    |              54842.8 |


Table: FinancialsQrtlyProfitAndLoss
| DATEKEY                 |   YEAR |   QUARTER | UNIQUE_CARRIER   |   NET_INCOME |   OP_PROFIT_LOSS |   TRANS_REV_PAX |   MAIL |   TOTAL_PROPERTY |   PROP_FREIGHT |   PROP_BAG |   TOTAL_CHARTER |   CHARTER_PAX |   CHARTER_PROP |   TOTAL_MISC_REV |   RES_CANCEL_FEES |   MISC_OP_REV |   PUB_SVC_REVENUE |   TRANS_REVENUE |   OP_REVENUES |   FLYING_OPS |   MAINTENANCE |   PAX_SERVICE |   AIRCFT_SERVICES |   PROMOTION_SALES |   GENERAL_ADMIN |   GENERAL_SERVICES |   DEPREC_AMORT |   TRANS_EXPENSES |   OP_EXPENSES |   INTEREST_LONG_DEBT |   INTEREST_EXP_OTH |   FOREIGN_EX_GAINS |   CAP_GAINS_PROP |   CAP_GAINS_OTHER |   OTHER_INCOME_NET |   NON_OP_INCOME |   INCOME_PRE_TAX |   INCOME_TAX |   INCOME_BEFORE_OTH |   DISCONT_OPS |   EXTRA_ITEMS |   INCOME_TAX_EXTRA |   INCOME_TAX_CREDITS |
|:------------------------|-------:|----------:|:-----------------|-------------:|-----------------:|----------------:|-------:|-----------------:|---------------:|-----------:|----------------:|--------------:|---------------:|-----------------:|------------------:|--------------:|------------------:|----------------:|--------------:|-------------:|--------------:|--------------:|------------------:|------------------:|----------------:|-------------------:|---------------:|-----------------:|--------------:|---------------------:|-------------------:|-------------------:|-----------------:|------------------:|-------------------:|----------------:|-----------------:|-------------:|--------------------:|--------------:|--------------:|-------------------:|---------------------:|
| 2019-06-30 00:00:00.000 |   2019 |         2 | EV               |    -35746.5  |        -35746.6  |         81588.6 |      0 |                0 |              0 |          0 |               0 |          0    |            0   |                0 |                 0 |          0    |                 0 |            0    |       81588.6 |      46847.1 |       39614.1 |       6381.6  |           4218.41 |             64.12 |        19809.4  |                  0 |         400.49 |                0 |      117335   |                 0    |               0.1  |                  0 |                0 |                 0 |               0    |            0.1  |        -35746.5  |         0    |           -35746.5  |             0 |             0 |                  0 |                    0 |
| 2019-12-31 00:00:00.000 |   2019 |         4 | 9E               |    -22249.5  |        -21522    |        165806   |      0 |                0 |              0 |          0 |               0 |          0    |            0   |                0 |                 0 |          0    |                 0 |            0    |      165806   |      81088.7 |       69004.2 |      18790.3  |           1003.15 |              0    |        14722.1  |                  0 |        2719.43 |                0 |      187328   |              -759.42 |               0    |                  0 |                0 |                 0 |              31.96 |         -727.46 |        -22249.5  |         0    |           -22249.5  |             0 |             0 |                  0 |                    0 |
| 2019-03-31 00:00:00.000 |   2019 |         1 | 9E               |    -17935.9  |        -17374.1  |        154469   |      0 |                0 |              0 |          0 |               0 |          0    |            0   |                0 |                 0 |          0    |                 0 |            0    |      154469   |      79698.5 |       57096.9 |      18408.6  |            761.04 |              0    |        14168.9  |                  0 |        1709.43 |                0 |      171843   |              -727.32 |               0    |                  0 |                0 |                 0 |             165.56 |         -561.76 |        -17935.9  |         0    |           -17935.9  |             0 |             0 |                  0 |                    0 |
| 2019-09-30 00:00:00.000 |   2019 |         3 | 9E               |    -16631.7  |        -16036.4  |        161108   |      0 |                0 |              0 |          0 |               0 |          0    |            0   |                0 |                 0 |          0    |                 0 |            0    |      161108   |      78910.4 |       60468.4 |      19227.8  |           1170.55 |              0    |        14818.9  |                  0 |        2548.74 |                0 |      177145   |              -810.81 |               0    |                  0 |                0 |                 0 |             190.74 |         -620.07 |        -16656.5  |       -24.85 |           -16631.7  |             0 |             0 |                  0 |                    0 |
| 2019-09-30 00:00:00.000 |   2019 |         3 | EV               |    -14201.2  |        -14213.4  |         93914.7 |      0 |                0 |              0 |          0 |               0 |          0    |            0   |                0 |                 0 |          0    |                 0 |            0    |       93914.7 |      42704.7 |       34907.6 |       6508.09 |           4339.7  |             65.5  |        18955.3  |                  0 |         647.17 |                0 |      108128   |                12.17 |             -12.17 |                  0 |                0 |                 0 |              12.17 |           12.17 |        -14201.2  |         0    |           -14201.2  |             0 |             0 |                  0 |                    0 |
| 2019-03-31 00:00:00.000 |   2019 |         1 | EV               |    -14148    |        -16890.9  |         77829.8 |      0 |                0 |              0 |          0 |               0 |          0    |            0   |                0 |                 0 |          0    |                 0 |            0    |       77829.8 |      23577.4 |       37941.2 |       4500.68 |           2486.17 |             41.1  |        26087.5  |                  0 |          86.57 |                0 |       94720.6 |                -0.09 |               0.09 |                  0 |                0 |                 0 |              16    |           16    |        -16874.9  |     -2726.87 |           -14148    |             0 |             0 |                  0 |                    0 |
| 2019-12-31 00:00:00.000 |   2019 |         4 | EV               |    -10163.1  |        -10175.2  |         98210.2 |      0 |                0 |              0 |          0 |               0 |          0    |            0   |                0 |                 0 |          0    |                 0 |            0    |       98210.2 |      43552.5 |       33994.6 |       6945.94 |           4105.13 |             42.6  |        18791.9  |                  0 |         952.79 |                0 |      108386   |                12.15 |             -12.15 |                  0 |                0 |                 0 |              12.15 |           12.15 |        -10163.1  |         0    |           -10163.1  |             0 |             0 |                  0 |                    0 |
| 2019-06-30 00:00:00.000 |   2019 |         2 | 9E               |     -8411.95 |         -8082.28 |        164854   |      0 |                0 |              0 |          0 |               0 |          0    |            0   |                0 |                 0 |          0    |                 0 |            0    |      164854   |      75450   |       64076.9 |      17298.4  |            912.25 |              0    |        13437.1  |                  0 |        1761.34 |                0 |      172936   |              -691.47 |               0    |                  0 |                0 |                 0 |             361.8  |         -329.67 |         -8411.95 |         0    |            -8411.95 |             0 |             0 |                  0 |                    0 |
| 2019-06-30 00:00:00.000 |   2019 |         2 | 8C               |     -5183.76 |         -4525.08 |             0   |      0 |                0 |              0 |          0 |               0 |       2458.02 |        46321.7 |                0 |                 0 |          5.28 |                 0 |            0    |       48785   |      24200.9 |       22851.8 |        191.53 |           1519.89 |              0    |         2581.23 |                  0 |        1964.7  |                0 |       53310.1 |                 0    |            -658.68 |                  0 |                0 |                 0 |               0    |         -658.68 |         -5183.76 |         0    |            -5183.76 |             0 |             0 |                  0 |                    0 |
| 2019-12-31 00:00:00.000 |   2019 |         4 | CP               |     -5076.31 |         -5083.02 |         51547.4 |      0 |                0 |              0 |          0 |               0 |          0    |            0   |                0 |                 0 |          0    |                 0 |            7.86 |       51555.3 |      15403.4 |       26149   |       6456.64 |           4144.64 |             24.73 |         3980.76 |                  0 |         479.06 |                0 |       56638.3 |                 0    |               0    |                  0 |                0 |                 0 |               6.71 |            6.71 |         -5076.31 |         0    |            -5076.31 |             0 |             0 |                  0 |                    0 |


Table: OperatingPerformance
| DATEKEY                 |   YEAR |   QUARTER |   MONTH | UNIQUE_CARRIER   | ORIGIN   | DEST   |   FLIGHTS |   DEP_DELAY_NEW |   NUM_DELAYED_DEP_FLIGHTS |   ARR_DELAY_NEW |   NUM_DELAYED_ARR_FLIGHTS |   CANCELLED |   DIVERTED |
|:------------------------|-------:|----------:|--------:|:-----------------|:---------|:-------|----------:|----------------:|--------------------------:|----------------:|--------------------------:|------------:|-----------:|
| 2019-01-31 00:00:00.000 |   2019 |         1 |       1 | WN               | CHS      | BWI    |         1 |               0 |                         0 |               0 |                         0 |           0 |          0 |
| 2019-01-31 00:00:00.000 |   2019 |         1 |       1 | WN               | CVG      | BWI    |         1 |               0 |                         0 |               0 |                         0 |           0 |          0 |
| 2019-01-31 00:00:00.000 |   2019 |         1 |       1 | WN               | CLE      | BWI    |         1 |               0 |                         0 |               0 |                         0 |           0 |          0 |
| 2019-01-31 00:00:00.000 |   2019 |         1 |       1 | WN               | ATL      | BWI    |         1 |               0 |                         0 |               0 |                         0 |           0 |          0 |
| 2019-01-31 00:00:00.000 |   2019 |         1 |       1 | WN               | OAK      | BWI    |         1 |               0 |                         0 |               0 |                         0 |           0 |          0 |
| 2019-01-31 00:00:00.000 |   2019 |         1 |       1 | WN               | DEN      | BWI    |         1 |               0 |                         0 |               0 |                         0 |           0 |          0 |
| 2019-01-31 00:00:00.000 |   2019 |         1 |       1 | WN               | PWM      | BWI    |         1 |               0 |                         0 |               0 |                         0 |           0 |          0 |
| 2019-01-31 00:00:00.000 |   2019 |         1 |       1 | WN               | BOS      | BWI    |         1 |               0 |                         0 |               0 |                         0 |           0 |          0 |
| 2019-01-31 00:00:00.000 |   2019 |         1 |       1 | WN               | LAS      | BWI    |         1 |               0 |                         0 |               0 |                         0 |           0 |          0 |
| 2019-01-31 00:00:00.000 |   2019 |         1 |       1 | WN               | FLL      | BWI    |         1 |               0 |                         0 |               0 |                         0 |           0 |          0 |


Table: OriginationAirports
| airport_id   | type          | name                          |   latitude_deg |   longitude_deg |   elevation_ft | continent   | iso_country   | iso_region   | URL                                |
|:-------------|:--------------|:------------------------------|---------------:|----------------:|---------------:|:------------|:--------------|:-------------|:-----------------------------------|
| LVD          | small_airport | Lime Village Airport          |        61.3591 |        -155.44  |            552 | NA          | US            | US-AK        | https://airportcod.es/=airport/LVD |
| HGZ          | small_airport | Hog River Airport             |        66.2161 |        -155.669 |            534 | NA          | US            | US-AK        | https://airportcod.es/=airport/HGZ |
| TLF          | small_airport | Telida Airport                |        63.3939 |        -153.269 |            650 | NA          | US            | US-AK        | https://airportcod.es/=airport/TLF |
| KKK          | small_airport | Kalakaket Creek AS Airport    |        64.4166 |        -156.82  |           1598 | NA          | US            | US-AK        | https://airportcod.es/=airport/KKK |
| ELW          | seaplane_base | Ellamar Seaplane Base         |        60.8938 |        -146.704 |              0 | NA          | US            | US-AK        | https://airportcod.es/=airport/ELW |
| HBH          | seaplane_base | Entrance Island Seaplane Base |        57.4122 |        -133.439 |              0 | NA          | US            | US-AK        | https://airportcod.es/=airport/HBH |
| FAK          | seaplane_base | False Island Seaplane Base    |        57.5322 |        -135.213 |              0 | NA          | US            | US-AK        | https://airportcod.es/=airport/FAK |
| WLR          | seaplane_base | Loring Seaplane Base          |        55.6013 |        -131.637 |              0 | NA          | US            | US-AK        | https://airportcod.es/=airport/WLR |
| NUP          | small_airport | Nunapitchuk Airport           |        60.9056 |        -162.44  |             12 | NA          | US            | US-AK        | https://airportcod.es/=airport/NUP |
| PTC          | seaplane_base | Port Alice Seaplane Base      |        55.803  |        -133.597 |              0 | NA          | US            | US-AK        | https://airportcod.es/=airport/PTC |

 


tables: name: Carrier
data: Carrier.csv
name: CarrierDomSalesData
data: CarrierDomSalesData.csv
name: CarrierEmployeeByCategory
data: CarrierEmployeeByCategory.csv
name: CarrierEmployeeSummary
data: CarrierEmployeeSummary.csv
name: CarrierIntlFlightData
data: CarrierIntlFlightData.csv
name: Dates
data: Dates.csv
name: DestinationAirport
data: DestinationAirport.csv
name: FinancialsQrtlyBalanceSheet
data: FinancialsQrtlyBalanceSheet.csv
name: FinancialsQrtlyProfitAndLoss
data: FinancialsQrtlyProfitAndLoss.csv
name: OperatingPerformance
data: OperatingPerformance.csv
name: OriginationAirports
data: OriginationAirports.csv
label: CarrierDomSalesData
DATEKEY
Dates
datekey
CarrierEmployeeSummary
DATEKEY
Dates
datekey
CarrierIntlFlightData
DATEKEY
Dates
datekey
FinancialsQrtlyBalanceSheet
DATEKEY
Dates
datekey
FinancialsQrtlyProfitAndLoss
DATEKEY
Dates
datekey
CarrierEmployeeByCategory
DATEKEY
Dates
datekey
OperatingPerformance
DATEKEY
Dates
datekey
CarrierDomSalesData
ORIGIN
OriginationAirports
airport_id
CarrierIntlFlightData
DEST
DestinationAirport
airport_id
CarrierIntlFlightData
ORIGIN
OriginationAirports
airport_id
CarrierIntlFlightData
UNIQUE_CARRIER
Carrier
CARRIER_ID
FinancialsQrtlyBalanceSheet
UNIQUE_CARRIER
Carrier
CARRIER_ID
CarrierDomSalesData
REPORTING_CARRIER
Carrier
CARRIER_ID
CarrierEmployeeByCategory
UNIQUE_CARRIER
Carrier
CARRIER_ID
CarrierEmployeeSummary
UNIQUE_CARRIER
Carrier
CARRIER_ID
FinancialsQrtlyProfitAndLoss
UNIQUE_CARRIER
Carrier
CARRIER_ID
OperatingPerformance
DEST
DestinationAirport
airport_id
OperatingPerformance
ORIGIN
OriginationAirports
airport_id
OperatingPerformance
UNIQUE_CARRIER
Carrier
CARRIER_ID
output: {
    "joins": [
        {
            "from_table": "CarrierDomSalesData",
            "from_column": "DATEKEY",
            "to_table": "Dates",
            "to_column": "datekey"
        },
        {
            "from_table": "CarrierEmployeeSummary",
            "from_column": "DATEKEY",
            "to_table": "Dates",
            "to_column": "datekey"
        },
        {
            "from_table": "CarrierIntlFlightData",
            "from_column": "DATEKEY",
            "to_table": "Dates",
            "to_column": "datekey"
        },
        {
            "from_table": "FinancialsQrtlyBalanceSheet",
            "from_column": "DATEKEY",
            "to_table": "Dates",
            "to_column": "datekey"
        },
        {
            "from_table": "FinancialsQrtlyProfitAndLoss",
            "from_column": "DATEKEY",
            "to_table": "Dates",
            "to_column": "datekey"
        },
        {
            "from_table": "CarrierEmployeeByCategory",
            "from_column": "DATEKEY",
            "to_table": "Dates",
            "to_column": "datekey"
        },
        {
            "from_table": "OperatingPerformance",
            "from_column": "DATEKEY",
            "to_table": "Dates",
            "to_column": "datekey"
        },
        {
            "from_table": "CarrierDomSalesData",
            "from_column": "ORIGIN",
            "to_table": "OriginationAirports",
            "to_column": "airport_id"
        },
        {
            "from_table": "CarrierIntlFlightData",
            "from_column": "DEST",
            "to_table": "DestinationAirport",
            "to_column": "airport_id"
        },
        {
            "from_table": "CarrierIntlFlightData",
            "from_column": "ORIGIN",
            "to_table": "OriginationAirports",
            "to_column": "airport_id"
        },
        {
            "from_table": "CarrierIntlFlightData",
            "from_column": "UNIQUE_CARRIER",
            "to_table": "Carrier",
            "to_column": "CARRIER_ID"
        },
        {
            "from_table": "FinancialsQrtlyBalanceSheet",
            "from_column": "UNIQUE_CARRIER",
            "to_table": "Carrier",
            "to_column": "CARRIER_ID"
        },
        {
            "from_table": "CarrierDomSalesData",
            "from_column": "REPORTING_CARRIER",
            "to_table": "Carrier",
            "to_column": "CARRIER_ID"
        },
        {
            "from_table": "CarrierEmployeeByCategory",
            "from_column": "UNIQUE_CARRIER",
            "to_table": "Carrier",
            "to_column": "CARRIER_ID"
        },
        {
            "from_table": "CarrierEmployeeSummary",
            "from_column": "UNIQUE_CARRIER",
            "to_table": "Carrier",
            "to_column": "CARRIER_ID"
        },
        {
            "from_table": "FinancialsQrtlyProfitAndLoss",
            "from_column": "UNIQUE_CARRIER",
            "to_table": "Carrier",
            "to_column": "CARRIER_ID"
        },
        {
            "from_table": "OperatingPerformance",
            "from_column": "DEST",
            "to_table": "DestinationAirport",
            "to_column": "airport_id"
        },
        {
            "from_table": "OperatingPerformance",
            "from_column": "ORIGIN",
            "to_table": "OriginationAirports",
            "to_column": "airport_id"
        },
        {
            "from_table": "OperatingPerformance",
            "from_column": "UNIQUE_CARRIER",
            "to_table": "Carrier",
            "to_column": "CARRIER_ID"
        }
    ]
}