Table 7 Domestic Airline Fares Third Quarter 2010

Document Sample
Table 7 Domestic Airline Fares Third Quarter 2010 Powered By Docstoc
					Year          Quarter       cityname origin                TOT_FaredPax
                                                  TOT_CountofMkts             TOT_AvgHubFare
                                                                     TOT_PctLFMkts      TOT_PctPremium
       2010             3                ABE
                            Allentown/Bethlehem/Easto 26      156450 0.58939 162.2675 -17.0423
       2010             3                ABQ
                            Albuquerque, NM             82 1041780 0.873303 190.109 0.039744
       2010             3                ACY
                            Atlantic City, NJ            9    296090         1 80.47053    -52.568
       2010             3   Albany, NY ALB              70    525540 0.779294 222.3719 11.52088
       2010             3   Amarillo, TX AMA            24    135480 0.789046 158.1526 -3.91958
       2010             3   Atlanta, GAATL             164 5913510 0.787926 175.9458 4.533041
       2010             3   Austin, TX AUS             103 1643070 0.834243 195.3952 3.565208
       2010             3   Hartford, CT BDL            88 1134450 0.685918 213.3843 11.91173
       2010             3                BHM
                            Birmingham, AL              66    534760 0.826782 195.3238 0.709308
       2010             3   Bellingham,BLIWA            12    152260 0.914423 104.6745 -38.7597
       2010             3                B
                            Nashville, TNNA             93 1551940 0.82527 190.2613 2.45112
       2010             3   Boise, ID BOI               59    536840 0.880728 172.7059 -4.78756
       2010             3   Boston, MABOS              148 5032260 0.770161 193.1057 -1.43514
       2010             3                BTR
                            Baton Rouge, LA             30    100480         0 212.9813 5.491281
       2010             3                VT
                            Burlington, BTV             43    232080 0.684548 215.725 8.215957
       2010             3   Buffalo, NY BUF             76 1173580 0.843913 163.0188 -10.0846
       2010             3   Burbank, CA  BUR            55 1034450 0.929421 156.5789 -0.10365
       2010             3   Baltimore, MDBWI           118 3890910 0.938588 161.8022 -9.41341
       2010             3   Columbia, SC CAE            36    131180         0 255.9167 24.24772
       2010             3   Akron, OH CAK               39    320750 0.911426 152.8733 -15.9341
       2010             3                SC
                            Charleston, CHS             58    384790         0 232.9654 18.41011
       2010             3                CID
                            Cedar Rapids/Iowa City, I   34    128950 0.311206     214.39 5.469219
       2010             3   Cleveland, OHCLE            84 1193960 0.556342 216.9921 21.82765
       2010             3   Charlotte, NCCLT           113 2131910 0.211613 198.6667 10.61226
       2010             3   Columbus, OH CMH            84 1276580 0.727146 177.3919 -2.67866
       2010             3                COS
                            Colorado Springs, CO        57    307870 0.376523 206.3636 -0.03513
       2010             3                CRP
                            Corpus Christi, TX          24     91280 0.625548 192.7727 10.03494
       2010             3   Covington, KYCVG            80    818990         0 231.726 32.75084
       2010             3                DAB
                            Daytona Beach, FL           19     48430         0 165.9427 -18.9816
       2010             3   Dallas, TX DAL             146 1302560 0.97878 155.8071 -0.29885
       2010             3   Dayton, OHDAY               62    484490 0.622386 178.3826 -11.5269
       2010             3                DCA
                            Washington, DC             165 3110600 0.271957 215.252 19.37875
       2010             3   Denver, CODEN              169 5779520 0.879981 170.6928 -5.89147
       2010             3                DFW
                            Dallas/Ft.Worth, TX        184 4500170 0.174809 223.4919 22.62719
       2010             3                DSM
                            Des Moines, IA              48    295660 0.315362 213.8554 6.54294
       2010             3   Detroit, MI DTW            129 2990140 0.64197 194.6381 4.734919
       2010             3   Eagle, CO EGE                6     14840         0 258.8066 18.61263
       2010             3   El Paso, TX ELP             66    578620 0.758754 198.3873 2.96126
       2010             3   Newark, NJEWR              182 3199790 0.211117 253.1988 27.99278
       2010             3   Fargo, ND FAR               26     95720 0.368784 210.1012 2.636712
       2010             3   Fresno, CA FAT              37    179910 0.119615 217.8711 -1.49313
       2010             3                FLL
                            Fort Lauderdale, FL        113 3380010 0.943266 147.4788 -23.6962
       2010             3   Flint, MI FNT               34    169050 0.872109 151.9562 -23.2527
       2010             3                FSD
                            Sioux Falls, SD             22     88110 0.44365 201.9843 -3.25297
       2010             3   Spokane, WA  GEG            62    633910 0.880866 172.4341 -10.0374
       2010             3                GPT
                            Gulfport/Biloxi, MS         33    105820 0.194481 194.9819 -9.26752
2010   3                GRR
           Grand Rapids, MI             57    389810   0.396629   191.2567     -3.2291
2010   3                GSO
           Greensboro/High Point, NC    59    321720   0.040004   195.6395   -2.73585
2010   3                GSP
           Greenville/Spartanburg, S    42    210450   0.263673   203.4558   7.938382
2010   3   Houston, TX  HOU            141   1566360   0.979379   176.5387   2.360981
2010   3                HPN
           White Plains, NY             33    422050   0.791755   166.3196   -8.34923
2010   3                HRL
           Harlingen/San Benito, TX     20    127490   0.935289   149.2739   -3.58966
2010   3                HSV
           Huntsville, AL               46    208000   0.225192   233.9212   21.33506
2010   3                IAD
           Washington, DC              165   2014930   0.735946   236.6532   14.98082
2010   3   Houston, TX  IAH            148   2492840   0.062603   240.8319   30.06275
2010   3   Wichita, KS ICT              43    244700    0.58586   183.7734   -6.28505
2010   3                IND
           Indianapolis, IN            100   1508680    0.74023   178.8365   -6.79479
2010   3   Islip, NY ISP                37    408520   0.985117   155.7938   -12.5777
2010   3                JAN
           Jackson/Vicksburg, MS        44    219240   0.697318   205.2355    2.57671
2010   3                JAX
           Jacksonville, FL             87   1139550   0.686596   172.1071   -5.62202
2010   3   New York, NY JFK            181   3612460   0.891229   225.0306   4.442239
2010   3   Las Vegas, NVLAS            170   6421690   0.877816   169.5039     -14.079
2010   3                LAX
           Los Angeles, CA             169   6673220    0.79347   217.6375   1.478117
2010   3   Lubbock, TX  LBB             29    164560   0.785124   164.6006   -0.86395
2010   3   New York, NY LGA            182   4964280   0.455007    185.161    6.59177
2010   3                LGB
           Long Beach, CA               28    633590   0.972253   134.1607   -21.6751
2010   3                AR
           Little Rock, LIT             61    415650   0.732251   205.2796   6.175348
2010   3                MAF
           Midland/Odessa, TX           25    152230    0.80155   161.8036   -1.68738
2010   3                 MO
           Kansas City,MCI             116   2027530    0.77298   176.5199   -5.96489
2010   3   Orlando, FLMCO              149   5716970   0.908208   146.5382     -20.363
2010   3   Chicago, IL MDW             161   2770920   0.992898   161.1056   -3.89023
2010   3   Memphis, TN  MEM             80    675340   0.272885   231.6218   22.42935
2010   3                MFE
           Mission/Mcallen/Edinburg,    22    101110   0.341213   200.1636   0.941152
2010   3                MHT
           Manchester, NH               68    668710   0.851804   181.1612   -1.99722
2010   3   Miami, FL MIA                88   1641520   0.114625   188.2091   -3.65556
2010   3   Milwaukee,MKE WI             87   1522030   0.871744   149.2875     -22.116
2010   3   Moline, IL MLI               35    147650   0.613546   179.6016   -12.8416
2010   3                MSP
           Minneapolis, MN             155   3298720   0.608591   212.8994   17.76061
2010   3                MSY
           New Orleans, LA              97   1562200   0.724062   179.2038   -2.78971
2010   3                MYR
           Myrtle Beach, SC             43    402850   0.743602     118.93   -33.1284
2010   3   Oakland, CA  OAK             69   1991390   0.976745    154.358   -7.59278
2010   3                OKC
           Oklahoma City, OK            73    627360   0.800115   212.5855   8.604114
2010   3   Omaha, NE OMA                71    782780   0.787258   183.5872   -2.05509
2010   3                ONT
           Ontario/San Bernardino, C    70   1030760   0.859191   178.7795   -1.22009
2010   3   Chicago, IL ORD             167   5863540   0.087474   201.3684   15.65128
2010   3   Norfolk, VAORF               81    731790   0.704478   200.8981     -0.1918
2010   3                PBI
           West Palm Beach/Palm Beac    68    933600   0.786836   162.0152     -11.778
2010   3                P
           Portland, ORDX              114   2338700   0.736828   206.7086   3.193726
2010   3                PHF
           Newport News/Williamsburg    33    223430    0.94477   145.2369   -22.5455
2010   3                PHL
           Philadelphia, PA            124   3700010    0.64286   196.0087   4.687844
2010   3   Phoenix, AZPHX              149   3930050   0.843717   180.6638   -2.80935
2010   3   Peoria, IL PIA               18     69400   0.591499   167.9369   -16.6051
2010   3                PIE
           St. Petersburg, FL           20    153450          1   77.04215   -58.5634
2010   3                PIT
           Pittsburgh, PA           104   1670270   0.732492   175.2693   -3.18318
2010   3   Pensacola, FLPNS          49    244080   0.558833   191.3355     -4.0547
2010   3                Springs, CA
           Indio/Palm PSP            26    105110    0.04148   196.1416   -8.49576
2010   3   Providence,PVDRI          74    918540   0.815403   184.8029   0.393447
2010   3   Portland, ME PWM          57    412480   0.601581   201.4033   8.361728
2010   3                RDU
           Raleigh/Durham, NC       101   1801970   0.724052   170.9205   -5.90961
2010   3   Richmond, VA RIC          71    674660   0.485993   182.8883   -5.97081
2010   3   Reno, NV RNO              65    756980   0.889522   180.1171   -4.60281
2010   3   Rochester, NYROC          55    496240   0.674996   172.7733   -3.24099
2010   3                R
           Ft. Myers, FL SW          73   1038850   0.870424   143.5333   -25.8341
2010   3   San Diego, CASAN         134   3497470   0.828725   190.3382   -4.66624
2010   3                SAT
           San Antonio, TX          109   1532560   0.816705   187.3084      -3.771
2010   3   Savannah, GA SAV          55    261960          0   214.9865   6.936721
2010   3                S
           Louisville, KYDF          75    626300   0.787753   199.6412   -0.14089
2010   3   Seattle, WASEA           170   4887860   0.705845   205.7128   -4.17731
2010   3   Orlando, FLSFB            19    129770          1   83.03257   -57.1047
2010   3                SFO
           San Francisco, CA        143   5063730   0.730708   225.0688    5.95935
2010   3   San Jose, CA SJC          76   1729460   0.890486   174.0165   -1.12029
2010   3                SLC
           Salt Lake City, UT       111   1943890    0.75511   200.3057   5.880724
2010   3                SMF
           Sacramento, CA            94   1849500   0.896853   178.7751   -4.53709
2010   3   Santa Ana, CASNA          90   1863060   0.644542    189.325   2.792705
2010   3                SRQ
           Sarasota/Bradenton, FL    38    179430   0.826506   155.7025   -19.0168
2010   3   St. Louis, MOSTL         112   2181730   0.781825   181.8017   3.100508
2010   3                SWF
           Newburgh/Poughkeepsie, NY 4      52160   0.866373   151.3309   -18.9115
2010   3                S
           Syracuse, NYYR            56    393330   0.437419   208.3358   8.408901
2010   3   Tampa, FL TPA            124   2829600   0.846685   161.4886   -11.8058
2010   3   Tulsa, OK TUL             67    520390   0.769231   201.7105   4.408081
2010   3   Tucson, AZ TUS            71    639840   0.774631   187.9439   -4.66839
         SH_FaredPax
SH_CountofMkts      SH_PctLFMkts
                             SH_AvgHubFare
                                       SH_PctPremium
                                                 LH_CountofMkts      LH_PctLFMkts
                                                           LH_FaredPax        LH_AvgHubFare
       9     47440 0.46016 183.6782 -0.91302           17    109010 0.645629 152.9498
      22   453640 0.950159 155.091 -4.68483            60    588140 0.814024 217.1189
       4     96700          1 74.13535 -55.7126         5    199390          1 83.54297
      27   195760 0.630415 192.4554 15.29538           43    329780 0.867669 240.1305
      10   103410 0.813074 137.932 -4.82976            14      32070 0.711568 223.3543
      97 3619050 0.831837 150.9051 -2.06444            67 2294460 0.718666 215.4426
      23   344690 0.857669 158.0799 4.361824           80 1298380 0.828024 205.3016
      27   303090 0.500115 198.9672 31.87061           61    831360 0.753657 218.6404
      37   350870 0.756548 177.0297 -3.15181           29    183890 0.960792 230.2298
       2       5250         0 120.221 -21.1064         10    147010 0.947078 104.1193
      48   883460 0.745829 174.0388 0.29078            45    668480 0.93026 211.7009
      20   369540 0.957515 136.5689 -14.5634           39    167300 0.711118 252.527
      38 1801830 0.702186 145.4828 4.327922           110 3230430 0.808075 219.6682
       9     40680          0 208.4523 29.88096        21      59800         0 216.0622
      15     89870 0.529098 185.391 23.35345           28    142210 0.782786 234.8946
      32   613370 0.75346 144.1752 -3.04603            44    560210 0.94295 183.6505
      13   686330 0.971355 124.4337 -0.22596           42    348120 0.846748 219.9541
      53 1942620 0.918908 129.7453 -8.20178            65 1948290 0.95821 193.7659
      20     74540          0 252.2752 30.5733         16      56640         0 260.7089
      17   158700 0.84184 138.9951 -12.7604            22    162050 0.979574 166.4647
      33   219880           0 227.1995 19.84556        25    164910          0 240.6531
       7     27780          0 262.6561 25.51105        27    101170 0.396659 201.1368
      42   597210 0.483381 197.7982 33.07846           42    596750 0.629359 236.2008
      71 1476310 0.285272 178.2792 11.38471            42    655600 0.045744 244.5763
      45   627680 0.571167 168.8569 6.789367           39    648900 0.878024 185.6477
      12     85690 0.547322 167.6226 -8.17386          45    222180 0.310649 221.3052
       7     56660 0.616484 150.351 7.08842            17      34620 0.640381 262.2012
      45   395180           0 235.4763 55.58564        35    423810          0 228.2292
       6     17370          0 163.4067 -15.9774        13      31060         0 167.361
      51   994380 0.978308       139.95 -3.35474       95    308180 0.980304 206.972
      32   228030 0.511819 175.4505 -6.43894           30    256460 0.720697 180.9897
      71 1474820 0.165986 205.3203 36.48428            94 1635780 0.367501 224.2064
      39 1446170 0.937801 131.7689 -16.5865           130 4333350 0.860685 183.6829
      66 1114090 0.320423 180.2688 11.56285           118 3386080 0.126899 237.7132
      15     73980 0.274939 246.2545 46.47299          33    221680 0.328852 203.043
      72 1386760 0.532796 197.3778 28.01566            57 1603380 0.736394 192.2685
       1       7410         0 232.317 19.14108          5       7430         0 285.2248
      20   321830 0.901035 173.3575 4.300009           46    256790 0.580435 229.7567
      62   752390           0 244.7023 63.02291       120 2447400 0.276019 255.8109
       5     19050          0 260.4326 60.85467        21      76670 0.460415 197.5955
       8     75420 0.285335 155.4248 -10.8001          29    104490          0 262.9444
      23   521000 0.868964 120.6143 -24.7033           90 2859010 0.956807 152.3743
      13     65570 0.784353 139.092 -23.0644           21    103480 0.927716 160.1076
       5     21380          0 248.4501 10.9481         17      66730 0.585793 187.0969
      10   265270 0.963019 117.6059      -23.286       52    368640 0.82175 211.888
      12     43190 0.476499 164.3842 -19.0874          21      62630         0 216.0822
24    149660   0.337432   203.0641   14.90438     33    240150   0.433521   183.8985
39    222900   0.057739   175.7585   -4.74231     20     98820          0   240.4835
23    145290   0.381926   174.1411   -0.95978     19     65160          0     268.82
35    773130   0.975127   149.7233   1.114313    106    793230   0.983523   202.6747
10     60500   0.006777    244.856    27.2944     23    361550   0.923109   153.1777
 8    101100   0.954006   128.9676   -7.56376     12     26390   0.863585   227.0672
22    123020   0.322956   205.4298   20.36209     24     84980   0.083667   275.1663
71    652250   0.575194   179.4276   20.93736     94   1362680   0.812891   264.0443
37    506910          0   193.3415   31.11182    111   1985930   0.078583   252.9539
11     55270   0.044328   241.7322   50.52801     32    189430   0.743863   166.8627
57    660600   0.536179   172.2587     -2.4117    43    848080   0.899172   183.9601
10     65880   0.969642   136.3526   -17.8116     27    342640   0.988092   159.5317
20    120440   0.640153   175.1035   -5.17375     24     98800   0.767004   241.9673
28    485300   0.782835   151.0959   -7.89855     59    654250   0.615208   187.6925
62    753650   0.882226   125.7735   -2.02133    119   2858810   0.893603   251.1972
35   2257180   0.996274   117.5078   -17.1309    135   4164510   0.813611   197.6859
29   1731880   0.954125   122.5176   -9.38725    140   4941340   0.737162   250.9758
12    122140   0.831914   141.5114   -3.26145     17     42420   0.650401   231.0814
62   2200010   0.269726   166.4099   10.69781    120   2764270   0.602466   200.0844
 8    313250   0.955754   92.17276   -33.0238     20    320340   0.988387   175.2194
26    212260   0.652973    179.792   5.112763     35    203390   0.814986   231.8788
12    120310   0.794946   143.1547   -7.24271     13     31920   0.826441   232.0935
43    869770   0.788082     155.32   -8.21197     73   1157760   0.761635   192.4464
38    800120   0.932973   127.9249   -23.1887    111   4916850   0.904178   149.5671
75   1263010   0.992352   137.6154   -2.66998     86   1507910   0.993355   180.7808
41    344200   0.393056   220.6143   23.97947     39    331140   0.147974   243.0634
 5     27790          0   182.8001   7.531141     17     73320    0.47054   206.7447
19    269360   0.805539   146.2458   -0.39093     49    399350    0.88301   204.7115
17    293380   0.423751   147.0847   -11.8422     71   1348140   0.047354   197.1586
42    600590   0.761451   139.5191   -19.4992     45    921440   0.943632   155.6545
12     57630   0.599861    164.647      -16.92    23     90020   0.622306   189.1754
49    999120   0.587697   184.5589   21.86355    106   2299600   0.617668   225.2126
36    669490   0.753305   156.5294   -5.05097     61    892710   0.702132   196.2085
31    338980   0.785592   107.2743   -38.8315     12     63870   0.520745   180.7906
16   1418250          1    125.824      -9.409    53    573140   0.919199   224.9663
25    243980   0.792729   180.2478    1.34181     48    383380   0.804815   233.1649
21    274830   0.702834   155.3001   -3.28998     50    507950   0.832936   198.8921
11    433190          1   126.5228   -4.07165     59    597570   0.757116   216.6614
77   2835410   0.024406   182.0214   16.79679     90   3028130   0.146529   219.4841
40    398730   0.670353   168.1651   -7.53916     41    333060   0.745331   240.0851
 9    102880   0.838258   139.4291   -13.7818     59    830720   0.780468   164.8124
18    603720   0.760286   144.9051   3.558525     96   1734980   0.728665   228.2144
14    139620   0.960392   115.3692   -30.8338     19     83810   0.918745   194.9939
52   1571530   0.575687   170.0305   15.84991     72   2128480   0.692457   215.1894
30   1600890   0.962365   132.7901    0.55275    119   2329160   0.762167   213.5686
 5     11590          0   219.4442   30.42098     13     57810   0.710085   157.6105
 8     67630          1   60.90884   -66.3895     12     85820          1   89.75592
50    832950   0.648874    151.339   -1.63892     54    837320   0.815674   199.0747
19     90070   0.621406   175.1377   -10.6563     30    154010   0.522239   200.8086
 4     28030          0   139.5869   -13.9204     22     77080   0.056565   216.7076
21    328460   0.733149   158.1069   6.476264     53    590080   0.861188   199.6628
17    178910   0.517411   172.7026   20.61387     40    233570   0.666053   223.3874
58   1232780   0.725555   146.7147     -8.3425    43    569190   0.720796   223.3467
39    407140   0.572113   160.4287   -7.01084     32    267520   0.354927   217.0695
16    452220   0.985361   133.0981   -13.8735     49    304760   0.747309   249.8864
26    238840   0.626403   161.3921   18.41491     29    257400   0.720085   183.3338
 8     69400   0.828098   146.8343   -13.4639     65    969450   0.873454    143.297
18   1291300   0.984899   121.2625   -15.7509    116   2206170   0.737314    230.769
25    358510   0.776241   156.5347   -12.2857     84   1174050   0.829062   196.7055
26    128250          0    206.116   7.988896     29    133710          0   223.4949
43    390070   0.703669   185.7081    0.65803     32    236230   0.926597   222.6479
31   1124000   0.836068   138.7264   -13.7739    139   3763860   0.666956   225.7169
 5     38340          1   56.73417   -69.6338     14     91430          1   94.06046
19   1813510   0.913091   124.5004     -12.436   124   3250220   0.628945   281.1824
14   1069090          1    131.097   -2.88049     62    660370   0.713191   243.5002
33   1032880   0.970742   151.3637   0.025694     78    911010   0.510631   255.7949
18   1051030   0.986623   133.0028   -10.0436     76    798470   0.778689   239.0253
12    750910          1   130.8148   -1.70129     78   1112150   0.404541   228.8303
 3     26300   0.840684    137.468   -19.7352     35    153130   0.824071   158.8343
56   1041270    0.71359   160.9984   -0.54598     56   1140460   0.844124   200.7956
                                                   4     52160   0.866373   151.3309
24    157310 0.384782 192.0263 23.02561           32    236020   0.472502   219.2062
35    523060 0.835277 151.4047 -11.7804           89   2306540   0.849272   163.7754
24    258280 0.715464 173.1401 0.292731           43    262110   0.822212   229.8634
13    255810        1 132.1222 -16.5831           58    384030   0.624509   225.1278
LH_PctPremium
 -23.5463
 2.848527
 -51.0729
 9.810565
   -2.0543
 12.93861
 3.403863
 6.560913
 6.965932
 -39.3196
 4.906306
 10.28708
 -3.40621
 -6.08344
 1.974383
 -15.3658
 0.033127
 -10.2047
    17.028
 -18.3627
 16.65133
 -0.24263
 13.76705
 9.367313
 -9.72086
 2.621903
 12.95156
  16.3259
   -20.533
 7.088869
 -15.4883
 8.183988
 -2.91122
 25.73866
 -4.04462
 -9.82546
 18.18681
 1.726531
 20.38558
 -8.23926
 3.096248
 -23.5487
   -23.356
 -8.24951
 -3.37237
 -3.09779
-12.7088
0.763016
24.03469
3.277811
-14.7354
6.360111
22.40444
13.16785
29.86003
-19.1786
-9.75132
-11.6531
10.54747
-4.20815
5.359671
-13.0474
3.603658
 3.66619
4.037401
-14.1964
 7.05103
14.21516
-4.54806
-19.9532
-4.65241
21.00203
-1.09026
-2.75287
-2.18082
-23.5675
-10.3905
16.36568
-1.38458
-5.33258
-4.95554
12.57284
-1.52386
0.038785
14.77713
6.933682
-11.5627
3.113472
  -12.172
-0.88343
-4.17856
-24.2312
-52.6699
-4.31919
-0.29697
-7.12479
-2.07249
2.213091
-2.21695
-4.77284
4.267651
-15.8167
-26.6037
-0.64575
-1.44624
6.022932
-1.22069
-2.17912
-52.1066
11.75976
0.466792
10.20875
-0.05605
4.639196
-18.9089
5.944182
-18.9115
1.376452
-11.8112
7.687816
0.969498

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:148
posted:3/23/2013
language:English
pages:9