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	2015	3	78.69476108	30158	31135	"Atlantic City, NJ"	"Myrtle Beach, SC"	20416	NK	8410	48.42%	78.38751486	75	63.14%	150	5.71%	0
Table 5	2015	3	280.9428942	30255	30852	"Huntsville, AL"	"Washington, DC (Metropolitan Area)"	19805	AA	8260	30.65%	290.4472155	125	15.50%	350	23.85%	0.18401937
Table 5	2015	3	280.9428942	30255	30852	"Huntsville, AL"	"Washington, DC (Metropolitan Area)"	19790	DL	4710	17.48%	259.3779193	125	6.58%	325	5.31%	0.13163482
Table 5	2015	3	268.8187614	30257	30977	"Albany, NY"	"Chicago, IL"	19977	UA	9350	28.52%	282.3036364	175	9.09%	375	6.84%	0.021390374
Table 5	2015	3	268.8187614	30257	30977	"Albany, NY"	"Chicago, IL"	19393	WN	5200	15.86%	262.3315385	175	8.08%	400	14.23%	0
Table 5	2015	3	117.257383	30325	32211	"Denver, CO"	"Las Vegas, NV"	20436	F9	50400	19.57%	88.70228175	75	38.19%	150	8.00%	0.00218254
Table 5	2015	3	117.257383	30325	32211	"Denver, CO"	"Las Vegas, NV"	19393	WN	54200	21.04%	129.4308487	75	20.63%	175	8.23%	0.104612546
Table 5	2015	3	356.4868706	30397	30693	"Atlanta, GA (Metropolitan Area)"	"Nashville, TN"	19790	DL	7450	47.48%	367.7652349	225	5.50%	500	8.46%	0.013422819
Table 5	2015	3	263.7504717	30397	30792	"Atlanta, GA (Metropolitan Area)"	"Buffalo, NY"	19790	DL	9320	31.40%	285.1050429	200	12.77%	300	6.44%	0.034334764
Table 5	2015	3	295.005081	30397	31057	"Atlanta, GA (Metropolitan Area)"	"Charlotte, NC"	19805	AA	5130	18.89%	276.2937622	75	11.11%	500	7.02%	0.592592593
Table 5	2015	3	295.005081	30397	31057	"Atlanta, GA (Metropolitan Area)"	"Charlotte, NC"	19790	DL	7510	27.65%	327.6412783	150	5.19%	500	13.05%	0.271637816
Table 5	2015	3	281.4755496	30397	31986	"Atlanta, GA (Metropolitan Area)"	"Grand Rapids, MI"	19790	DL	9140	41.00%	288.0554705	100	5.14%	450	6.02%	0.366520788
Table 5	2015	3	290.900523	30397	32600	"Atlanta, GA (Metropolitan Area)"	"Little Rock, AR"	19790	DL	7160	41.60%	301.2965084	100	9.50%	425	6.98%	0.441340782
Table 5	2015	3	271.6844534	30397	33105	"Atlanta, GA (Metropolitan Area)"	"Cincinnati, OH"	19790	DL	12980	40.20%	308.6898305	150	5.32%	450	5.24%	0.1394453
Table 5	2015	3	310.16294	30397	33244	"Atlanta, GA (Metropolitan Area)"	"Memphis, TN"	19790	DL	12860	41.92%	332.3307932	225	6.84%	400	10.81%	0.003888025
Table 5	2015	3	94.42027972	30397	35356	"Atlanta, GA (Metropolitan Area)"	"Trenton, NJ"	20436	F9	8640	46.48%	93.35474537	75	26.74%	125	13.89%	0.002314815
Table 5	2015	3	304.4298943	30647	31650	"Cleveland, OH (Metropolitan Area)"	"Minneapolis/St. Paul, MN"	19790	DL	9830	30.55%	335.728179	225	5.90%	575	6.10%	0.018311292
Table 5	2015	3	118.1182479	30647	34492	"Cleveland, OH (Metropolitan Area)"	"Raleigh/Durham, NC"	20436	F9	8900	30.82%	78.09438202	75	51.46%	125	10.34%	0
Table 5	2015	3	269.9922931	30721	31986	"Boston, MA (Metropolitan Area)"	"Grand Rapids, MI"	19790	DL	3230	20.40%	305.1213622	150	7.12%	400	5.26%	0.148606811
Table 5	2015	3	269.9922931	30721	31986	"Boston, MA (Metropolitan Area)"	"Grand Rapids, MI"	19393	WN	1880	11.88%	206.3462766	150	13.30%	375	5.32%	0
Table 5	2015	3	380.1269733	30977	31834	"Chicago, IL"	"Fayetteville, AR"	19805	AA	5990	37.23%	381.4190317	175	8.85%	600	13.36%	0.273789649
Table 5	2015	3	380.1269733	30977	31834	"Chicago, IL"	"Fayetteville, AR"	19977	UA	1910	11.87%	394.3188482	175	10.99%	600	14.14%	0.340314136
Table 5	2015	3	279.1422949	30977	32070	"Chicago, IL"	"Harrisburg, PA"	19805	AA	4520	21.43%	315.2409292	175	5.97%	425	6.64%	0.095132743
Table 5	2015	3	279.1422949	30977	32070	"Chicago, IL"	"Harrisburg, PA"	19977	UA	5640	26.74%	262.187234	125	7.62%	350	6.03%	0.163120567
Table 5	2015	3	276.216144	30977	32337	"Chicago, IL"	"Indianapolis, IN"	19805	AA	4660	27.06%	293.1693133	150	6.22%	350	8.15%	0.070815451
Table 5	2015	3	276.216144	30977	32337	"Chicago, IL"	"Indianapolis, IN"	19977	UA	4060	23.58%	274.6408867	175	7.14%	350	6.16%	0.032019704
Table 5	2015	3	320.3656454	30977	33105	"Chicago, IL"	"Cincinnati, OH"	19805	AA	4760	14.16%	349.8523109	200	7.77%	400	8.82%	0.044117647
Table 5	2015	3	320.3656454	30977	33105	"Chicago, IL"	"Cincinnati, OH"	19790	DL	5770	17.16%	324.2403813	200	5.89%	400	8.67%	0.005199307
Table 5	2015	3	320.3656454	30977	33105	"Chicago, IL"	"Cincinnati, OH"	19977	UA	6270	18.65%	304.0068581	200	6.70%	400	6.22%	0.014354067
Table 5	2015	3	320.8752881	30977	34524	"Chicago, IL"	"Richmond, VA"	19805	AA	5420	17.35%	351.6953875	175	8.49%	550	11.07%	0.210332103
Table 5	2015	3	320.8752881	30977	34524	"Chicago, IL"	"Richmond, VA"	19977	UA	6600	21.13%	339.4440909	150	9.24%	550	10.61%	0.316666667
Table 5	2015	3	273.7512758	30977	35096	"Chicago, IL"	"Syracuse, NY"	19805	AA	4800	23.55%	315.5033333	150	8.13%	350	9.79%	0.1125
Table 5	2015	3	273.7512758	30977	35096	"Chicago, IL"	"Syracuse, NY"	19977	UA	4710	23.11%	256.3991507	150	11.25%	350	6.16%	0.042462845
Table 5	2015	3	91.64026091	30977	35356	"Chicago, IL"	"Trenton, NJ"	20436	F9	9950	44.76%	92.47356784	75	33.57%	150	14.97%	0.001005025
Table 5	2015	3	278.643214	31057	30693	"Charlotte, NC"	"Nashville, TN"	19805	AA	11350	42.32%	292.19163	175	6.17%	375	11.89%	0.01938326
Table 5	2015	3	304.9237592	31057	31295	"Charlotte, NC"	"Detroit, MI"	19805	AA	11280	27.71%	288.3371454	125	5.59%	425	5.23%	0.265070922
Table 5	2015	3	304.9237592	31057	31295	"Charlotte, NC"	"Detroit, MI"	19790	DL	7370	18.11%	335.3067843	100	6.11%	625	7.60%	0.521031208
Table 5	2015	3	279.3469987	31057	32467	"Charlotte, NC"	"Miami, FL (Metropolitan Area)"	19805	AA	21560	38.63%	304.3492115	200	20.73%	500	5.98%	0.048701299
Table 5	2015	3	279.3469987	31057	32467	"Charlotte, NC"	"Miami, FL (Metropolitan Area)"	19790	DL	6460	11.57%	196.2673375	150	21.67%	275	9.13%	0.010835913
Table 5	2015	3	271.6493999	31057	33195	"Charlotte, NC"	"Tampa, FL (Metropolitan Area)"	19805	AA	11910	38.63%	292.8420655	175	6.63%	375	8.98%	0.026868178
Table 5	2015	3	271.6493999	31057	33195	"Charlotte, NC"	"Tampa, FL (Metropolitan Area)"	19790	DL	3150	10.22%	209.5565079	125	8.57%	300	6.98%	0.031746032
Table 5	2015	3	87.07398292	31057	35356	"Charlotte, NC"	"Trenton, NJ"	20436	F9	9310	46.76%	87.15112782	75	31.15%	125	16.43%	0.006444683
Table 5	2015	3	302.558627	31066	31650	"Columbus, OH"	"Minneapolis/St. Paul, MN"	19790	DL	7820	28.41%	336.5528133	225	15.86%	625	6.91%	0.020460358
Table 5	2015	3	302.558627	31066	31650	"Columbus, OH"	"Minneapolis/St. Paul, MN"	19393	WN	3420	12.42%	248.7608187	175	9.65%	400	6.14%	0.005847953
Table 5	2015	3	292.948308	31066	31703	"Columbus, OH"	"New York City, NY (Metropolitan Area)"	19805	AA	12210	13.37%	295.9653563	175	10.40%	375	8.60%	0.067158067
Table 5	2015	3	292.948308	31066	31703	"Columbus, OH"	"New York City, NY (Metropolitan Area)"	19790	DL	16230	17.77%	291.1269254	175	23.48%	375	12.69%	0.057917437
Table 5	2015	3	292.948308	31066	31703	"Columbus, OH"	"New York City, NY (Metropolitan Area)"	19977	UA	12520	13.71%	316.660623	100	6.47%	400	6.55%	0.548722045
Table 5	2015	3	284.4727994	31066	34100	"Columbus, OH"	"Philadelphia, PA"	19805	AA	12760	44.05%	290.9894984	125	11.68%	375	11.44%	0.138714734
Table 5	2015	3	118.4437447	31135	34100	"Myrtle Beach, SC"	"Philadelphia, PA"	19805	AA	4290	18.13%	167.9312354	100	7.93%	200	8.39%	0.067599068
Table 5	2015	3	118.4437447	31135	34100	"Myrtle Beach, SC"	"Philadelphia, PA"	20416	NK	6790	28.70%	80.05581738	75	55.38%	150	6.77%	0
Table 5	2015	3	263.0665331	31267	31703	"Dayton, OH"	"New York City, NY (Metropolitan Area)"	19805	AA	5920	23.73%	253.5967905	175	21.28%	375	6.76%	0.02027027
Table 5	2015	3	263.0665331	31267	31703	"Dayton, OH"	"New York City, NY (Metropolitan Area)"	19977	UA	3380	13.55%	274.3843195	175	20.12%	375	9.17%	0.035502959
Table 5	2015	3	305.4891602	31295	30529	"Detroit, MI"	"Hartford, CT"	19790	DL	8130	39.70%	313.7430504	200	11.32%	375	7.87%	0.051660517
Table 5	2015	3	115.4005852	31295	31135	"Detroit, MI"	"Myrtle Beach, SC"	19790	DL	4070	13.23%	174.4911548	125	17.94%	250	6.88%	0.029484029
Table 5	2015	3	115.4005852	31295	31135	"Detroit, MI"	"Myrtle Beach, SC"	20416	NK	10190	33.13%	82.86977429	75	45.93%	125	13.44%	0.000981354
Table 5	2015	3	270.5813718	31295	31650	"Detroit, MI"	"Minneapolis/St. Paul, MN"	19790	DL	19850	31.96%	337.5504786	125	7.46%	600	5.69%	0.415617128
Table 5	2015	3	270.5813718	31295	31650	"Detroit, MI"	"Minneapolis/St. Paul, MN"	20416	NK	7580	12.20%	95.30382586	75	32.72%	175	5.94%	0
Table 5	2015	3	382.8736096	31295	34100	"Detroit, MI"	"Philadelphia, PA"	19805	AA	7440	20.28%	439.3030914	175	5.91%	700	8.74%	0.411290323
Table 5	2015	3	382.8736096	31295	34100	"Detroit, MI"	"Philadelphia, PA"	19790	DL	9630	26.25%	360.2304258	100	5.61%	700	7.37%	0.490134995
Table 5	2015	3	287.2515094	31295	34492	"Detroit, MI"	"Raleigh/Durham, NC"	19805	AA	3090	11.66%	250.831068	175	10.36%	325	11.97%	0.025889968
Table 5	2015	3	287.2515094	31295	34492	"Detroit, MI"	"Raleigh/Durham, NC"	19790	DL	7570	28.57%	315.8587847	225	14.40%	450	6.21%	0.021136063
Table 5	2015	3	79.18261249	31295	35356	"Detroit, MI"	"Trenton, NJ"	20436	F9	10110	44.17%	78.78635015	75	55.29%	125	11.08%	0
Table 5	2015	3	288.2937794	31650	30198	"Minneapolis/St. Paul, MN"	"Pittsburgh, PA"	19790	DL	8080	27.17%	346.6842822	125	5.82%	525	5.94%	0.382425743
Table 5	2015	3	288.2937794	31650	30198	"Minneapolis/St. Paul, MN"	"Pittsburgh, PA"	19393	WN	3310	11.13%	204.7063444	150	20.24%	275	11.48%	0
Table 5	2015	3	284.4537153	31650	30693	"Minneapolis/St. Paul, MN"	"Nashville, TN"	19790	DL	10320	29.27%	316.8070736	200	5.52%	400	9.98%	0.023255814
Table 5	2015	3	284.4537153	31650	30693	"Minneapolis/St. Paul, MN"	"Nashville, TN"	19393	WN	5270	14.95%	230.2935484	175	18.60%	275	13.66%	0.001897533
Table 5	2015	3	293.8686865	31703	30198	"New York City, NY (Metropolitan Area)"	"Pittsburgh, PA"	19805	AA	17000	17.46%	303.3350588	125	7.71%	525	5.35%	0.252941176
Table 5	2015	3	293.8686865	31703	30198	"New York City, NY (Metropolitan Area)"	"Pittsburgh, PA"	19790	DL	16600	17.05%	286.5559036	125	8.98%	525	6.27%	0.274698795
Table 5	2015	3	293.8686865	31703	30198	"New York City, NY (Metropolitan Area)"	"Pittsburgh, PA"	19977	UA	13330	13.69%	309.1744936	100	5.63%	550	6.38%	0.471117779
Table 5	2015	3	300.1419985	31703	33667	"New York City, NY (Metropolitan Area)"	"Norfolk, VA (Metropolitan Area)"	19805	AA	4160	15.34%	316.4879808	200	11.30%	275	7.69%	0.038461538
Table 5	2015	3	300.1419985	31703	33667	"New York City, NY (Metropolitan Area)"	"Norfolk, VA (Metropolitan Area)"	19790	DL	4030	14.86%	322.7890819	200	11.17%	550	9.93%	0.022332506
Table 5	2015	3	300.1419985	31703	33667	"New York City, NY (Metropolitan Area)"	"Norfolk, VA (Metropolitan Area)"	19977	UA	4460	16.45%	309.5304933	100	5.16%	550	6.95%	0.443946188
Table 5	2015	3	384.1649648	31703	34524	"New York City, NY (Metropolitan Area)"	"Richmond, VA"	19805	AA	5660	16.61%	375.3588339	200	9.89%	550	8.48%	0.060070671
Table 5	2015	3	384.1649648	31703	34524	"New York City, NY (Metropolitan Area)"	"Richmond, VA"	19790	DL	8030	23.56%	386.6631382	200	9.71%	550	11.21%	0.069738481
Table 5	2015	3	268.9416773	31986	31703	"Grand Rapids, MI"	"New York City, NY (Metropolitan Area)"	19790	DL	7490	23.98%	262.6526035	150	19.09%	275	5.21%	0.125500668
Table 5	2015	3	268.9416773	31986	31703	"Grand Rapids, MI"	"New York City, NY (Metropolitan Area)"	19977	UA	5290	16.93%	265.8232514	150	23.82%	225	8.51%	0.147448015
Table 5	2015	3	88.93991207	32211	34716	"Las Vegas, NV"	"Stockton, CA"	20368	G4	10020	48.95%	94.44111776	75	42.12%	200	7.19%	0
Table 5	2015	3	318.2612936	32337	31650	"Indianapolis, IN"	"Minneapolis/St. Paul, MN"	19790	DL	10620	35.96%	337.1170433	200	6.69%	550	7.34%	0.030131827
Table 5	2015	3	296.134004	32337	31703	"Indianapolis, IN"	"New York City, NY (Metropolitan Area)"	19805	AA	11650	13.02%	235.2208584	150	10.64%	300	6.09%	0.035193133
Table 5	2015	3	296.134004	32337	31703	"Indianapolis, IN"	"New York City, NY (Metropolitan Area)"	19790	DL	15550	17.38%	326.8554341	175	9.90%	275	6.30%	0.186495177
Table 5	2015	3	296.134004	32337	31703	"Indianapolis, IN"	"New York City, NY (Metropolitan Area)"	19977	UA	15120	16.90%	321.5806217	150	9.72%	275	5.89%	0.232804233
Table 5	2015	3	271.3921613	32337	34100	"Indianapolis, IN"	"Philadelphia, PA"	19805	AA	14480	41.12%	286.3825276	175	12.85%	375	17.13%	0.031077348
Table 5	2015	3	92.87762277	32898	31135	"Latrobe, PA"	"Myrtle Beach, SC"	20416	NK	8700	48.55%	92.45471264	75	34.02%	150	17.13%	0
Table 5	2015	3	272.6656588	33044	31703	"Louisville, KY"	"New York City, NY (Metropolitan Area)"	19805	AA	5700	14.01%	239.5398246	175	15.44%	275	5.61%	0.022807018
Table 5	2015	3	272.6656588	33044	31703	"Louisville, KY"	"New York City, NY (Metropolitan Area)"	19790	DL	6860	16.86%	300.6444606	175	9.33%	375	6.41%	0.103498542
Table 5	2015	3	272.6656588	33044	31703	"Louisville, KY"	"New York City, NY (Metropolitan Area)"	19977	UA	4900	12.05%	297.075102	175	13.06%	350	6.94%	0.095918367
Table 5	2015	3	378.5226021	33105	31650	"Cincinnati, OH"	"Minneapolis/St. Paul, MN"	19790	DL	8140	38.65%	403.1799754	225	8.11%	650	12.65%	0.038083538
Table 5	2015	3	337.5411933	33105	31703	"Cincinnati, OH"	"New York City, NY (Metropolitan Area)"	19790	DL	21570	29.32%	345.3658785	175	20.26%	500	5.42%	0.147890589
Table 5	2015	3	337.5411933	33105	31703	"Cincinnati, OH"	"New York City, NY (Metropolitan Area)"	19977	UA	8440	11.47%	356.7783175	175	12.32%	500	5.57%	0.16943128
Table 5	2015	3	320.7548658	33105	34100	"Cincinnati, OH"	"Philadelphia, PA"	19805	AA	8360	35.07%	327.6833732	175	5.74%	425	15.19%	0.053827751
Table 5	2015	3	320.7548658	33105	34100	"Cincinnati, OH"	"Philadelphia, PA"	19790	DL	3130	13.13%	312.6226837	175	5.11%	425	12.78%	0.028753994
Table 5	2015	3	283.9109634	34100	30198	"Philadelphia, PA"	"Pittsburgh, PA"	19805	AA	16370	48.37%	287.1058644	150	6.84%	425	5.62%	0.035430666
Table 5	2015	3	271.4730207	34100	34321	"Philadelphia, PA"	"Portland, ME"	19805	AA	8040	48.96%	271.3578358	150	6.34%	350	8.21%	0.042288557
Table 5	2015	3	273.1979323	34100	34492	"Philadelphia, PA"	"Raleigh/Durham, NC"	19805	AA	17360	39.45%	279.8710253	150	7.55%	350	10.89%	0.029953917
Table 5	2015	3	77.18687043	34492	35356	"Raleigh/Durham, NC"	"Trenton, NJ"	20436	F9	11770	50.67%	77.79864061	75	59.13%	125	13.76%	0
Table 5	2015	3	289.9451011	35412	31703	"Knoxville, TN"	"New York City, NY (Metropolitan Area)"	19805	AA	3790	19.65%	269.2604222	175	12.40%	325	6.07%	0.050131926
Table 5	2015	3	289.9451011	35412	31703	"Knoxville, TN"	"New York City, NY (Metropolitan Area)"	19790	DL	4050	21.00%	309.9923457	200	10.12%	400	6.91%	0.051851852