tbl	Year	quarter	mkt_fare	citymarketid_1	citymarketid_2	city1	city2	carairlineid	car	carpax	carpaxshare	caravgfare	fareinc_min	fareinc_minpaxsh	fareinc_max	fare_inc_maxpaxsh	fare_inc_x3paxsh
Table 5	2014	3	261.1756757	30194	33044	"Dallas/Fort Worth, TX"	"Louisville, KY"	19805	AA	8740	35.79%	267.783524	175	11.21%	400	8.12%	0.012585812
Table 5	2014	3	329.0747331	30194	33244	"Dallas/Fort Worth, TX"	"Memphis, TN"	19805	AA	6970	31.01%	367.2624103	100	5.31%	500	14.35%	0.595408895
Table 5	2014	3	318.1609837	30255	30852	"Huntsville, AL"	"Washington, DC (Metropolitan Area)"	19790	DL	4980	16.55%	288.7218876	150	5.22%	375	5.82%	0.080321285
Table 5	2014	3	318.1609837	30255	30852	"Huntsville, AL"	"Washington, DC (Metropolitan Area)"	20355	US	8380	27.85%	316.3119332	125	17.90%	400	29.47%	0.430787589
Table 5	2014	3	274.9665139	30257	30977	"Albany, NY"	"Chicago, IL"	19977	UA	9650	29.48%	286.053057	200	16.58%	375	7.88%	0.01865285
Table 5	2014	3	274.9665139	30257	30977	"Albany, NY"	"Chicago, IL"	19393	WN	4760	14.54%	254.5071429	175	12.39%	375	15.34%	0.00210084
Table 5	2014	3	116.4540692	30325	30466	"Denver, CO"	"Phoenix, AZ"	20436	F9	31800	13.21%	87.93833333	75	46.16%	150	5.31%	0.012578616
Table 5	2014	3	116.4540692	30325	30466	"Denver, CO"	"Phoenix, AZ"	19393	WN	61110	25.39%	122.0718868	75	8.30%	150	12.49%	0.078546883
Table 5	2014	3	85.2341555	30397	30158	"Atlanta, GA (Metropolitan Area)"	"Atlantic City, NJ"	20416	NK	9160	49.12%	84.3018559	75	41.59%	150	8.73%	0.001091703
Table 5	2014	3	274.6097655	30397	31057	"Atlanta, GA (Metropolitan Area)"	"Charlotte, NC"	19790	DL	6670	25.64%	317.6883058	100	7.20%	500	12.59%	0.587706147
Table 5	2014	3	274.6097655	30397	31057	"Atlanta, GA (Metropolitan Area)"	"Charlotte, NC"	20355	US	5620	21.61%	239.3701068	75	19.40%	500	8.01%	0.460854093
Table 5	2014	3	283.571547	30397	31986	"Atlanta, GA (Metropolitan Area)"	"Grand Rapids, MI"	19790	DL	8410	38.72%	293.4894174	175	9.04%	600	6.78%	0.126040428
Table 5	2014	3	284.7097625	30397	33105	"Atlanta, GA (Metropolitan Area)"	"Cincinnati, OH"	19790	DL	13930	45.94%	292.0312994	150	7.82%	500	5.60%	0.114142139
Table 5	2014	3	317.74375	30397	33244	"Atlanta, GA (Metropolitan Area)"	"Memphis, TN"	19790	DL	12300	44.44%	332.0939024	125	6.50%	525	10.08%	0.363414634
Table 5	2014	3	106.8026217	30397	35356	"Atlanta, GA (Metropolitan Area)"	"Trenton, NJ"	20436	F9	12120	50.44%	106.2983498	75	30.45%	175	7.43%	0.02970297
Table 5	2014	3	263.139468	30423	31123	"Austin, TX"	"St. Louis, MO"	19805	AA	2390	12.98%	239.8334728	175	15.90%	275	9.62%	0.025104603
Table 5	2014	3	263.139468	30423	31123	"Austin, TX"	"St. Louis, MO"	19393	WN	5740	31.16%	268.7487805	175	8.36%	425	7.32%	0.006968641
Table 5	2014	3	315.605572	30647	31650	"Cleveland, OH (Metropolitan Area)"	"Minneapolis/St. Paul, MN"	19790	DL	9110	30.04%	331.619978	250	14.16%	550	7.24%	0.007683864
Table 5	2014	3	359.0436142	30647	34100	"Cleveland, OH (Metropolitan Area)"	"Philadelphia, PA"	20355	US	9980	43.35%	365.5132265	175	5.31%	675	5.11%	0.246492986
Table 5	2014	3	384.892	30977	31834	"Chicago, IL"	"Fayetteville, AR"	19805	AA	5450	34.06%	375.5924771	250	9.72%	600	16.15%	0.016513761
Table 5	2014	3	384.892	30977	31834	"Chicago, IL"	"Fayetteville, AR"	19977	UA	1900	11.88%	414.3152632	250	8.95%	600	16.84%	0.031578947
Table 5	2014	3	340.2683217	30977	33105	"Chicago, IL"	"Cincinnati, OH"	19805	AA	5230	18.29%	335.0015296	200	5.35%	500	8.99%	0.013384321
Table 5	2014	3	340.2683217	30977	33105	"Chicago, IL"	"Cincinnati, OH"	19790	DL	4230	14.79%	361.5827423	200	5.67%	525	6.86%	0.014184397
Table 5	2014	3	340.2683217	30977	33105	"Chicago, IL"	"Cincinnati, OH"	19977	UA	4390	15.35%	335.1940774	175	5.24%	500	12.98%	0.041002278
Table 5	2014	3	344.5480506	30977	34524	"Chicago, IL"	"Richmond, VA"	19805	AA	4080	13.60%	342.1767157	175	7.60%	525	8.33%	0.174019608
Table 5	2014	3	344.5480506	30977	34524	"Chicago, IL"	"Richmond, VA"	19977	UA	6060	20.19%	376.1452145	175	5.94%	525	8.91%	0.191419142
Table 5	2014	3	116.6569536	30977	35356	"Chicago, IL"	"Trenton, NJ"	20436	F9	10430	49.34%	118.5016299	75	25.79%	200	7.00%	0.057526366
Table 5	2014	3	260.8366829	31057	30693	"Charlotte, NC"	"Nashville, TN"	20355	US	12200	42.42%	273.6029508	150	8.20%	350	23.44%	0.050819672
Table 5	2014	3	304.5548353	31057	31295	"Charlotte, NC"	"Detroit, MI"	19790	DL	7200	19.13%	328.6565278	100	6.53%	625	6.25%	0.494444444
Table 5	2014	3	304.5548353	31057	31295	"Charlotte, NC"	"Detroit, MI"	20355	US	8940	23.75%	296.7614094	100	6.94%	325	5.48%	0.395973154
Table 5	2014	3	294.9359152	31057	34100	"Charlotte, NC"	"Philadelphia, PA"	20355	US	23630	45.53%	303.5433771	175	9.35%	375	5.71%	0.038933559
Table 5	2014	3	304.2254302	31066	31650	"Columbus, OH"	"Minneapolis/St. Paul, MN"	19790	DL	7200	27.53%	337.7886111	200	7.08%	625	8.06%	0.136111111
Table 5	2014	3	304.2254302	31066	31650	"Columbus, OH"	"Minneapolis/St. Paul, MN"	19393	WN	3420	13.08%	247.0383041	175	6.14%	400	5.85%	0
Table 5	2014	3	349.4313537	31066	31703	"Columbus, OH"	"New York City, NY (Metropolitan Area)"	19805	AA	8990	10.81%	343.2844271	200	22.47%	500	5.90%	0.123470523
Table 5	2014	3	349.4313537	31066	31703	"Columbus, OH"	"New York City, NY (Metropolitan Area)"	19790	DL	12610	15.16%	388.2605075	200	11.66%	400	6.03%	0.164155432
Table 5	2014	3	349.4313537	31066	31703	"Columbus, OH"	"New York City, NY (Metropolitan Area)"	19977	UA	11730	14.10%	364.997272	100	8.95%	250	5.63%	0.516624041
Table 5	2014	3	270.7811008	31066	34100	"Columbus, OH"	"Philadelphia, PA"	20355	US	14680	42.75%	282.0925749	125	9.13%	350	22.34%	0.141689373
Table 5	2014	3	109.4397919	31135	34100	"Myrtle Beach, SC"	"Philadelphia, PA"	20416	NK	6420	23.04%	75.48115265	75	59.66%	125	18.85%	0
Table 5	2014	3	109.4397919	31135	34100	"Myrtle Beach, SC"	"Philadelphia, PA"	20355	US	7120	25.55%	138.1120787	75	12.92%	225	5.20%	0.074438202
Table 5	2014	3	283.526122	31267	31703	"Dayton, OH"	"New York City, NY (Metropolitan Area)"	19977	UA	4910	18.83%	296.0718941	175	10.39%	375	10.39%	0.030549898
Table 5	2014	3	283.526122	31267	31703	"Dayton, OH"	"New York City, NY (Metropolitan Area)"	20355	US	3380	12.97%	258.7754438	175	14.20%	325	5.33%	0.044378698
Table 5	2014	3	287.2438331	31295	30529	"Detroit, MI"	"Hartford, CT"	19790	DL	7310	33.52%	321.002052	150	6.98%	500	5.06%	0.279069767
Table 5	2014	3	113.2907173	31295	31135	"Detroit, MI"	"Myrtle Beach, SC"	19790	DL	3720	13.08%	170.2860215	125	19.09%	250	5.11%	0.008064516
Table 5	2014	3	113.2907173	31295	31135	"Detroit, MI"	"Myrtle Beach, SC"	20416	NK	9720	34.18%	84.44897119	75	44.75%	150	8.54%	0.004115226
Table 5	2014	3	279.7705953	31295	31650	"Detroit, MI"	"Minneapolis/St. Paul, MN"	19790	DL	16450	28.22%	381.4262614	200	9.73%	625	7.29%	0.110030395
Table 5	2014	3	279.7705953	31295	31650	"Detroit, MI"	"Minneapolis/St. Paul, MN"	20416	NK	9240	15.85%	95.42132035	75	35.71%	175	12.66%	0.001082251
Table 5	2014	3	263.9078739	31295	31703	"Detroit, MI"	"New York City, NY (Metropolitan Area)"	19790	DL	60840	25.51%	323.4073143	150	17.39%	225	5.64%	0.277942143
Table 5	2014	3	263.9078739	31295	31703	"Detroit, MI"	"New York City, NY (Metropolitan Area)"	20416	NK	24210	10.15%	128.6180917	100	24.20%	200	16.81%	0.000826105
Table 5	2014	3	291.2865918	31295	33198	"Detroit, MI"	"Kansas City, MO"	19790	DL	7970	23.54%	386.0007528	175	5.14%	625	7.28%	0.210790464
Table 5	2014	3	291.2865918	31295	33198	"Detroit, MI"	"Kansas City, MO"	19393	WN	5840	17.25%	243.7597603	150	5.48%	350	11.64%	0.001712329
Table 5	2014	3	359.0496748	31295	34100	"Detroit, MI"	"Philadelphia, PA"	19790	DL	9360	23.41%	361.6443376	100	5.13%	500	33.23%	0.533119658
Table 5	2014	3	359.0496748	31295	34100	"Detroit, MI"	"Philadelphia, PA"	20355	US	8670	21.69%	363.7101499	75	6.00%	525	9.11%	0.689734717
Table 5	2014	3	269.5622804	31295	34492	"Detroit, MI"	"Raleigh/Durham, NC"	19790	DL	7330	26.28%	316.6942701	175	6.41%	650	6.00%	0.154160982
Table 5	2014	3	269.5622804	31295	34492	"Detroit, MI"	"Raleigh/Durham, NC"	20355	US	3810	13.66%	214.6496063	175	22.31%	300	5.77%	0.002624672
Table 5	2014	3	119.5372865	31638	32211	"Fresno, CA"	"Las Vegas, NV"	20368	G4	4730	23.08%	80.95243129	75	62.79%	150	5.29%	0
Table 5	2014	3	119.5372865	31638	32211	"Fresno, CA"	"Las Vegas, NV"	19977	UA	4580	22.35%	151.2155022	100	15.50%	250	5.46%	0.015283843
Table 5	2014	3	286.8645863	31650	30198	"Minneapolis/St. Paul, MN"	"Pittsburgh, PA"	19790	DL	8370	29.35%	329.4322581	125	7.53%	625	6.33%	0.310633214
Table 5	2014	3	285.3360219	31650	30693	"Minneapolis/St. Paul, MN"	"Nashville, TN"	19790	DL	9030	29.02%	326.7135105	200	6.31%	450	8.19%	0.023255814
Table 5	2014	3	285.3360219	31650	30693	"Minneapolis/St. Paul, MN"	"Nashville, TN"	19393	WN	4610	14.81%	232.5386117	150	6.72%	425	5.42%	0.002169197
Table 5	2014	3	295.1788815	31703	30198	"New York City, NY (Metropolitan Area)"	"Pittsburgh, PA"	19790	DL	16480	17.04%	297.7419296	125	7.40%	525	8.13%	0.349514563
Table 5	2014	3	295.1788815	31703	30198	"New York City, NY (Metropolitan Area)"	"Pittsburgh, PA"	19977	UA	11050	11.42%	323.2312217	100	5.97%	625	6.43%	0.464253394
Table 5	2014	3	295.1788815	31703	30198	"New York City, NY (Metropolitan Area)"	"Pittsburgh, PA"	20355	US	17290	17.87%	295.2314633	125	7.35%	525	8.10%	0.265471371
Table 5	2014	3	284.9992193	31703	33667	"New York City, NY (Metropolitan Area)"	"Norfolk, VA (Metropolitan Area)"	19805	AA	3400	11.06%	257.6232353	125	5.59%	525	7.06%	0.258823529
Table 5	2014	3	284.9992193	31703	33667	"New York City, NY (Metropolitan Area)"	"Norfolk, VA (Metropolitan Area)"	19790	DL	4040	13.14%	315.5	200	20.54%	525	7.67%	0.024752475
Table 5	2014	3	284.9992193	31703	33667	"New York City, NY (Metropolitan Area)"	"Norfolk, VA (Metropolitan Area)"	19977	UA	3890	12.65%	299.6658098	150	6.94%	525	6.94%	0.213367609
Table 5	2014	3	360.2735566	31703	34524	"New York City, NY (Metropolitan Area)"	"Richmond, VA"	19790	DL	7900	22.81%	361.3478481	200	15.57%	550	6.58%	0.036708861
Table 5	2014	3	360.2735566	31703	34524	"New York City, NY (Metropolitan Area)"	"Richmond, VA"	19977	UA	4170	12.04%	384.0311751	200	10.55%	525	18.71%	0.038369305
Table 5	2014	3	283.7214667	31986	31703	"Grand Rapids, MI"	"New York City, NY (Metropolitan Area)"	19790	DL	7030	23.43%	266.6455192	150	15.79%	250	5.41%	0.150782361
Table 5	2014	3	283.7214667	31986	31703	"Grand Rapids, MI"	"New York City, NY (Metropolitan Area)"	19977	UA	4970	16.57%	311.1955734	150	8.05%	550	6.84%	0.215291751
Table 5	2014	3	117.3131992	32211	34252	"Las Vegas, NV"	"Pasco/Kennewick/Richland, WA"	20368	G4	5300	33.31%	100.2292453	75	27.74%	150	7.74%	0.00754717
Table 5	2014	3	95.66409465	32211	34716	"Las Vegas, NV"	"Stockton, CA"	20368	G4	10320	53.09%	98.70397287	75	25.39%	200	5.72%	0
Table 5	2014	3	331.7942308	32337	31650	"Indianapolis, IN"	"Minneapolis/St. Paul, MN"	19790	DL	10880	34.87%	364.1660846	200	6.89%	600	5.97%	0.025735294
Table 5	2014	3	310.4382059	32337	31703	"Indianapolis, IN"	"New York City, NY (Metropolitan Area)"	19790	DL	16030	18.82%	337.1870867	200	25.89%	250	5.68%	0.144104803
Table 5	2014	3	310.4382059	32337	31703	"Indianapolis, IN"	"New York City, NY (Metropolitan Area)"	19977	UA	16800	19.73%	314.9595238	175	7.56%	575	7.98%	0.164285714
Table 5	2014	3	105.0218571	32898	31135	"Latrobe, PA"	"Myrtle Beach, SC"	20416	NK	9560	49.87%	104.9605649	75	23.54%	175	9.94%	0
Table 5	2014	3	90.86069712	32945	34761	"Lexington, KY"	"Sanford, FL"	20368	G4	7410	44.53%	84.82186235	75	59.92%	150	7.29%	0.008097166
Table 5	2014	3	301.2811374	33044	31703	"Louisville, KY"	"New York City, NY (Metropolitan Area)"	19790	DL	5790	13.72%	324.2552677	200	24.53%	325	5.35%	0.093264249
Table 5	2014	3	301.2811374	33044	31703	"Louisville, KY"	"New York City, NY (Metropolitan Area)"	19977	UA	5320	12.61%	324.2334586	125	5.08%	600	7.14%	0.296992481
Table 5	2014	3	390.0870748	33105	31650	"Cincinnati, OH"	"Minneapolis/St. Paul, MN"	19790	DL	7260	37.99%	423.0615702	225	10.33%	650	6.89%	0.024793388
Table 5	2014	3	380.8907656	33105	31703	"Cincinnati, OH"	"New York City, NY (Metropolitan Area)"	19790	DL	18100	28.57%	405.6760773	200	5.30%	675	6.08%	0.236464088
Table 5	2014	3	380.8907656	33105	31703	"Cincinnati, OH"	"New York City, NY (Metropolitan Area)"	19977	UA	6880	10.86%	404.2540698	200	5.67%	675	7.56%	0.225290698
Table 5	2014	3	313.9680702	33105	34100	"Cincinnati, OH"	"Philadelphia, PA"	19790	DL	3470	15.22%	289.4835735	175	10.66%	400	12.10%	0.011527378
Table 5	2014	3	313.9680702	33105	34100	"Cincinnati, OH"	"Philadelphia, PA"	20355	US	7450	32.68%	330.9718121	200	8.19%	475	5.37%	0.036241611
Table 5	2014	3	274.0738102	34100	30198	"Philadelphia, PA"	"Pittsburgh, PA"	20355	US	17400	47.87%	276.6451149	150	6.49%	400	6.72%	0.027586207
Table 5	2014	3	268.6222949	34100	34321	"Philadelphia, PA"	"Portland, ME"	20355	US	8440	50.18%	271.2342417	150	8.06%	325	7.46%	0.048578199
Table 5	2014	3	317.6894709	35412	30852	"Knoxville, TN"	"Washington, DC (Metropolitan Area)"	19790	DL	2410	12.75%	283.8244813	200	11.62%	375	8.30%	0.020746888
Table 5	2014	3	317.6894709	35412	30852	"Knoxville, TN"	"Washington, DC (Metropolitan Area)"	19977	UA	2180	11.53%	292.3894495	125	26.61%	675	5.96%	0.28440367
Table 5	2014	3	317.6894709	35412	30852	"Knoxville, TN"	"Washington, DC (Metropolitan Area)"	20355	US	4690	24.81%	336.9535181	125	16.42%	700	7.46%	0.317697228
Table 5	2014	3	260.8090307	35412	31703	"Knoxville, TN"	"New York City, NY (Metropolitan Area)"	19790	DL	3130	14.80%	288.4134185	175	14.06%	375	9.27%	0.095846645
Table 5	2014	3	260.8090307	35412	31703	"Knoxville, TN"	"New York City, NY (Metropolitan Area)"	19977	UA	2390	11.30%	248.7543933	175	15.48%	275	7.11%	0.050209205
Table 5	2014	3	260.8090307	35412	31703	"Knoxville, TN"	"New York City, NY (Metropolitan Area)"	20355	US	3360	15.89%	249.4235119	175	14.29%	275	16.37%	0.020833333