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	1	285.4662666	30194	31423	"Dallas/Fort Worth, TX"	"Des Moines, IA"	19805	AA	6250	39.48%	308.00384	175	9.60%	350	5.76%	0.1136
Table 5	2015	1	299.5443377	30194	33244	"Dallas/Fort Worth, TX"	"Memphis, TN"	19805	AA	7670	32.05%	355.8872229	150	6.52%	500	11.99%	0.329856584
Table 5	2015	1	302.912968	30255	30852	"Huntsville, AL"	"Washington, DC (Metropolitan Area)"	19790	DL	4390	16.94%	261.4806378	175	13.67%	375	5.47%	0.022779043
Table 5	2015	1	302.912968	30255	30852	"Huntsville, AL"	"Washington, DC (Metropolitan Area)"	20355	US	6460	24.93%	305.9955108	125	16.72%	350	21.36%	0.221362229
Table 5	2015	1	366.8810429	30372	32575	"Aspen, CO"	"Los Angeles, CA (Metropolitan Area)"	19977	UA	9290	45.27%	385.8630786	250	7.75%	425	9.47%	0.05489774
Table 5	2015	1	361.0811881	30397	30693	"Atlanta, GA (Metropolitan Area)"	"Nashville, TN"	19790	DL	6680	47.24%	372.5258982	225	8.68%	500	6.74%	0.019461078
Table 5	2015	1	266.8269416	30397	30792	"Atlanta, GA (Metropolitan Area)"	"Buffalo, NY"	19790	DL	5680	30.42%	290.5200704	100	5.81%	550	5.99%	0.376760563
Table 5	2015	1	295.6692222	30397	31057	"Atlanta, GA (Metropolitan Area)"	"Charlotte, NC"	19790	DL	7230	26.78%	327.8502075	200	6.36%	500	13.55%	0.008298755
Table 5	2015	1	295.6692222	30397	31057	"Atlanta, GA (Metropolitan Area)"	"Charlotte, NC"	20355	US	5590	20.70%	258.8046512	75	15.56%	500	8.05%	0.529516995
Table 5	2015	1	344.6420757	30397	31834	"Atlanta, GA (Metropolitan Area)"	"Fayetteville, AR"	19790	DL	5740	40.25%	370.2557491	125	6.79%	425	6.27%	0.454703833
Table 5	2015	1	309.9857587	30397	31986	"Atlanta, GA (Metropolitan Area)"	"Grand Rapids, MI"	19790	DL	6440	40.05%	321.4091615	175	11.65%	450	10.09%	0.118012422
Table 5	2015	1	260.2417139	30397	31995	"Atlanta, GA (Metropolitan Area)"	"Greensboro/High Point, NC"	19790	DL	6460	40.71%	278.7921053	100	5.11%	500	7.74%	0.383900929
Table 5	2015	1	260.5701681	30397	32070	"Atlanta, GA (Metropolitan Area)"	"Harrisburg, PA"	19790	DL	5100	35.71%	279.7913725	125	6.08%	275	8.43%	0.229411765
Table 5	2015	1	260.5701681	30397	32070	"Atlanta, GA (Metropolitan Area)"	"Harrisburg, PA"	20355	US	1650	11.55%	198.0509091	125	11.52%	300	6.06%	0.036363636
Table 5	2015	1	278.9534722	30397	32600	"Atlanta, GA (Metropolitan Area)"	"Little Rock, AR"	19790	DL	6210	39.20%	296.062963	100	10.95%	425	6.12%	0.450885668
Table 5	2015	1	296.1124653	30397	33105	"Atlanta, GA (Metropolitan Area)"	"Cincinnati, OH"	19790	DL	12980	45.07%	304.4238059	175	5.32%	450	5.08%	0.039291217
Table 5	2015	1	308.4177693	30397	33244	"Atlanta, GA (Metropolitan Area)"	"Memphis, TN"	19790	DL	12570	40.17%	341.6633254	225	6.21%	550	7.56%	0.003977725
Table 5	2015	1	271.4870195	30397	34576	"Atlanta, GA (Metropolitan Area)"	"Rochester, NY"	19790	DL	5480	34.53%	286.4839416	175	8.94%	350	5.11%	0.082116788
Table 5	2015	1	89.6541769	30397	35356	"Atlanta, GA (Metropolitan Area)"	"Trenton, NJ"	20436	F9	8310	51.04%	90.35006017	75	50.42%	150	7.94%	0.010830325
Table 5	2015	1	306.3392283	30647	31650	"Cleveland, OH (Metropolitan Area)"	"Minneapolis/St. Paul, MN"	19790	DL	6520	29.95%	337.5723926	200	5.67%	575	6.44%	0.041411043
Table 5	2015	1	268.4884354	30647	34100	"Cleveland, OH (Metropolitan Area)"	"Philadelphia, PA"	20355	US	10430	41.74%	277.4436242	150	6.62%	400	5.75%	0.044103547
Table 5	2015	1	284.9751136	30721	31066	"Boston, MA (Metropolitan Area)"	"Columbus, OH"	19790	DL	3830	14.51%	361.8924282	175	6.79%	650	8.09%	0.227154047
Table 5	2015	1	284.9751136	30721	31066	"Boston, MA (Metropolitan Area)"	"Columbus, OH"	20355	US	3970	15.04%	253.5115869	175	10.33%	275	8.06%	0.0302267
Table 5	2015	1	284.9751136	30721	31066	"Boston, MA (Metropolitan Area)"	"Columbus, OH"	19393	WN	3140	11.89%	236.8764331	175	21.66%	375	5.10%	0.003184713
Table 5	2015	1	407.365728	30977	31834	"Chicago, IL"	"Fayetteville, AR"	19805	AA	5460	37.50%	404.0282051	175	5.13%	600	15.75%	0.313186813
Table 5	2015	1	407.365728	30977	31834	"Chicago, IL"	"Fayetteville, AR"	19977	UA	1660	11.40%	433.7710843	250	5.42%	600	10.24%	0.054216867
Table 5	2015	1	305.9847166	30977	33105	"Chicago, IL"	"Cincinnati, OH"	19805	AA	4360	14.71%	335.5919725	200	7.11%	375	19.50%	0.041284404
Table 5	2015	1	305.9847166	30977	33105	"Chicago, IL"	"Cincinnati, OH"	19790	DL	4440	14.98%	305.2792793	175	6.98%	375	13.06%	0.011261261
Table 5	2015	1	305.9847166	30977	33105	"Chicago, IL"	"Cincinnati, OH"	19977	UA	5540	18.69%	298.868231	200	7.22%	375	12.09%	0.012635379
Table 5	2015	1	341.9809889	30977	34524	"Chicago, IL"	"Richmond, VA"	19805	AA	2830	12.06%	368.8628975	175	12.72%	525	9.54%	0.127208481
Table 5	2015	1	341.9809889	30977	34524	"Chicago, IL"	"Richmond, VA"	19977	UA	5290	22.55%	387.437051	225	5.10%	525	14.18%	0.034026465
Table 5	2015	1	263.9332382	30977	35096	"Chicago, IL"	"Syracuse, NY"	19805	AA	3170	22.61%	275.0085174	150	15.14%	350	5.99%	0.09148265
Table 5	2015	1	263.9332382	30977	35096	"Chicago, IL"	"Syracuse, NY"	19977	UA	2700	19.26%	255.7362963	150	15.56%	350	5.93%	0.037037037
Table 5	2015	1	260.392277	30994	34100	"Charleston, SC"	"Philadelphia, PA"	20355	US	6160	41.01%	272.7228896	150	12.01%	350	8.77%	0.095779221
Table 5	2015	1	261.6724944	31057	30693	"Charlotte, NC"	"Nashville, TN"	20355	US	9910	36.79%	286.784561	150	10.60%	350	29.36%	0.062563068
Table 5	2015	1	265.3084314	31057	31066	"Charlotte, NC"	"Columbus, OH"	20355	US	5530	36.14%	305.8486438	175	8.50%	450	7.05%	0.072332731
Table 5	2015	1	276.8946229	31057	31136	"Charlotte, NC"	"Jacksonville, FL"	19790	DL	1770	12.36%	199.5706215	100	7.34%	275	6.21%	0.062146893
Table 5	2015	1	276.8946229	31057	31136	"Charlotte, NC"	"Jacksonville, FL"	20355	US	5180	36.17%	301.2816602	75	6.37%	500	6.37%	0.571428571
Table 5	2015	1	310.3893953	31057	31295	"Charlotte, NC"	"Detroit, MI"	19790	DL	6950	21.12%	340.6838849	100	5.32%	625	8.92%	0.538129496
Table 5	2015	1	310.3893953	31057	31295	"Charlotte, NC"	"Detroit, MI"	20355	US	7430	22.58%	300.4561238	75	6.33%	425	5.52%	0.530282638
Table 5	2015	1	270.9328814	31057	32467	"Charlotte, NC"	"Miami, FL (Metropolitan Area)"	20355	US	22980	33.87%	282.5563534	175	11.44%	475	5.61%	0.048302872
Table 5	2015	1	270.3740661	31057	33044	"Charlotte, NC"	"Louisville, KY"	20355	US	5020	36.06%	302.3743028	75	5.98%	350	20.12%	0.677290837
Table 5	2015	1	275.097947	31057	33105	"Charlotte, NC"	"Cincinnati, OH"	19790	DL	2020	13.38%	254.2227723	75	5.94%	350	19.80%	0.599009901
Table 5	2015	1	275.097947	31057	33105	"Charlotte, NC"	"Cincinnati, OH"	20355	US	5280	34.97%	278.5988636	150	5.30%	350	16.29%	0.056818182
Table 5	2015	1	268.1711479	31057	33195	"Charlotte, NC"	"Tampa, FL (Metropolitan Area)"	19790	DL	3820	10.72%	200.297644	125	9.95%	300	5.24%	0.02617801
Table 5	2015	1	268.1711479	31057	33195	"Charlotte, NC"	"Tampa, FL (Metropolitan Area)"	20355	US	13110	36.79%	288.2081617	75	5.80%	375	18.69%	0.701754386
Table 5	2015	1	275.1881425	31057	34027	"Charlotte, NC"	"West Palm Beach/Palm Beach, FL"	20355	US	6240	36.45%	295.2926282	175	13.30%	425	5.45%	0.057692308
Table 5	2015	1	293.4089037	31057	34100	"Charlotte, NC"	"Philadelphia, PA"	20355	US	21400	41.97%	316.9653271	175	5.28%	375	6.78%	0.057009346
Table 5	2015	1	310.2386673	31066	31650	"Columbus, OH"	"Minneapolis/St. Paul, MN"	19790	DL	5720	28.87%	350.7405594	200	14.69%	625	11.19%	0.171328671
Table 5	2015	1	347.4721995	31066	31703	"Columbus, OH"	"New York City, NY (Metropolitan Area)"	19805	AA	7680	10.85%	367.3553385	150	5.08%	475	6.25%	0.31640625
Table 5	2015	1	347.4721995	31066	31703	"Columbus, OH"	"New York City, NY (Metropolitan Area)"	19790	DL	10430	14.73%	369.795302	175	12.37%	475	6.04%	0.233940556
Table 5	2015	1	347.4721995	31066	31703	"Columbus, OH"	"New York City, NY (Metropolitan Area)"	19977	UA	9540	13.48%	365.4120545	100	6.18%	700	5.14%	0.525157233
Table 5	2015	1	301.1160229	31066	34100	"Columbus, OH"	"Philadelphia, PA"	20355	US	11340	43.37%	305.5727513	125	7.58%	450	5.64%	0.166666667
Table 5	2015	1	116.201027	31135	31703	"Myrtle Beach, SC"	"New York City, NY (Metropolitan Area)"	20416	NK	11210	38.38%	92.38349688	75	51.12%	200	8.56%	0.002676182
Table 5	2015	1	295.2009229	31267	31703	"Dayton, OH"	"New York City, NY (Metropolitan Area)"	19805	AA	2210	12.00%	294.7674208	175	23.53%	375	10.41%	0.067873303
Table 5	2015	1	295.2009229	31267	31703	"Dayton, OH"	"New York City, NY (Metropolitan Area)"	19977	UA	2110	11.45%	299.9170616	125	6.16%	450	5.69%	0.274881517
Table 5	2015	1	295.2009229	31267	31703	"Dayton, OH"	"New York City, NY (Metropolitan Area)"	20355	US	2770	15.04%	287.5700361	175	12.64%	375	6.86%	0.072202166
Table 5	2015	1	299.2221587	31295	30529	"Detroit, MI"	"Hartford, CT"	19790	DL	4950	35.38%	324.339798	150	5.66%	250	6.06%	0.274747475
Table 5	2015	1	350.4166093	31295	31650	"Detroit, MI"	"Minneapolis/St. Paul, MN"	19790	DL	13280	35.18%	398.2108434	200	7.08%	625	5.20%	0.097891566
Table 5	2015	1	265.9558484	31295	31703	"Detroit, MI"	"New York City, NY (Metropolitan Area)"	19790	DL	44570	25.48%	330.8294817	125	10.10%	200	6.82%	0.342158403
Table 5	2015	1	265.9558484	31295	31703	"Detroit, MI"	"New York City, NY (Metropolitan Area)"	20416	NK	18870	10.79%	107.3502915	75	26.34%	200	10.07%	0.001059883
Table 5	2015	1	284.6020429	31295	33198	"Detroit, MI"	"Kansas City, MO"	19790	DL	7250	24.28%	382.5143448	175	6.48%	625	9.38%	0.217931034
Table 5	2015	1	284.6020429	31295	33198	"Detroit, MI"	"Kansas City, MO"	19393	WN	4230	14.17%	227.0224586	150	12.29%	350	11.82%	0.002364066
Table 5	2015	1	377.4158509	31295	34100	"Detroit, MI"	"Philadelphia, PA"	19790	DL	8660	24.64%	360.5795612	100	6.35%	500	35.91%	0.553117783
Table 5	2015	1	377.4158509	31295	34100	"Detroit, MI"	"Philadelphia, PA"	20355	US	7190	20.46%	426.4445063	175	5.01%	525	14.60%	0.171070932
Table 5	2015	1	290.0095012	31295	34492	"Detroit, MI"	"Raleigh/Durham, NC"	19790	DL	6180	29.36%	324.5347896	175	13.75%	650	7.12%	0.182847896
Table 5	2015	1	290.0095012	31295	34492	"Detroit, MI"	"Raleigh/Durham, NC"	20355	US	2370	11.26%	255.9417722	175	5.06%	300	8.86%	0.037974684
Table 5	2015	1	293.6199137	31650	30198	"Minneapolis/St. Paul, MN"	"Pittsburgh, PA"	19790	DL	5850	31.57%	337.0147009	125	10.77%	625	6.67%	0.403418803
Table 5	2015	1	291.447511	31650	30693	"Minneapolis/St. Paul, MN"	"Nashville, TN"	19790	DL	8130	32.38%	319.0398524	175	5.04%	600	6.15%	0.141451415
Table 5	2015	1	291.447511	31650	30693	"Minneapolis/St. Paul, MN"	"Nashville, TN"	19393	WN	3060	12.19%	222.8509804	175	19.93%	300	6.21%	0
Table 5	2015	1	305.5458121	31703	30198	"New York City, NY (Metropolitan Area)"	"Pittsburgh, PA"	19790	DL	13270	16.47%	301.8565938	125	10.32%	525	9.65%	0.36322532
Table 5	2015	1	305.5458121	31703	30198	"New York City, NY (Metropolitan Area)"	"Pittsburgh, PA"	19977	UA	11150	13.84%	322.3409865	125	6.37%	525	12.20%	0.361434978
Table 5	2015	1	305.5458121	31703	30198	"New York City, NY (Metropolitan Area)"	"Pittsburgh, PA"	20355	US	12610	15.65%	318.8316416	150	11.90%	525	9.28%	0.241078509
Table 5	2015	1	309.3782097	31703	33667	"New York City, NY (Metropolitan Area)"	"Norfolk, VA (Metropolitan Area)"	19790	DL	2440	12.48%	337.7512295	150	7.38%	525	11.89%	0.286885246
Table 5	2015	1	309.3782097	31703	33667	"New York City, NY (Metropolitan Area)"	"Norfolk, VA (Metropolitan Area)"	19977	UA	2850	14.58%	325.9912281	175	8.07%	525	9.12%	0.080701754
Table 5	2015	1	309.3782097	31703	33667	"New York City, NY (Metropolitan Area)"	"Norfolk, VA (Metropolitan Area)"	20355	US	2320	11.87%	307.1181034	150	8.62%	250	8.62%	0.172413793
Table 5	2015	1	395.3073398	31703	34524	"New York City, NY (Metropolitan Area)"	"Richmond, VA"	19790	DL	6300	20.92%	395.0490476	175	7.94%	550	7.78%	0.165079365
Table 5	2015	1	395.3073398	31703	34524	"New York City, NY (Metropolitan Area)"	"Richmond, VA"	19977	UA	3490	11.59%	410.1103152	200	7.16%	550	6.30%	0.077363897
Table 5	2015	1	395.3073398	31703	34524	"New York City, NY (Metropolitan Area)"	"Richmond, VA"	20355	US	4540	15.08%	416.2806167	200	8.59%	550	5.73%	0.099118943
Table 5	2015	1	271.3149091	31986	31703	"Grand Rapids, MI"	"New York City, NY (Metropolitan Area)"	19790	DL	3950	20.52%	265.3526582	150	34.18%	275	5.32%	0.164556962
Table 5	2015	1	271.3149091	31986	31703	"Grand Rapids, MI"	"New York City, NY (Metropolitan Area)"	19977	UA	3410	17.71%	296.4231672	125	7.33%	275	5.57%	0.249266862
Table 5	2015	1	90.55088968	32211	34716	"Las Vegas, NV"	"Stockton, CA"	20368	G4	7640	54.38%	97.07591623	75	29.19%	200	5.24%	0
Table 5	2015	1	341.322083	32337	31650	"Indianapolis, IN"	"Minneapolis/St. Paul, MN"	19790	DL	7510	32.45%	385.7537949	175	6.79%	625	5.73%	0.332889481
Table 5	2015	1	320.8030483	32337	31703	"Indianapolis, IN"	"New York City, NY (Metropolitan Area)"	19790	DL	10320	16.13%	366.0508721	175	9.88%	275	5.14%	0.277131783
Table 5	2015	1	320.8030483	32337	31703	"Indianapolis, IN"	"New York City, NY (Metropolitan Area)"	19977	UA	10570	16.52%	348.5653737	125	5.11%	550	8.80%	0.407757805
Table 5	2015	1	267.2419303	32337	34100	"Indianapolis, IN"	"Philadelphia, PA"	20355	US	11750	37.93%	283.191234	125	9.28%	375	7.66%	0.122553191
Table 5	2015	1	100.1548502	32945	34761	"Lexington, KY"	"Sanford, FL"	20368	G4	6670	47.57%	100.6064468	75	45.58%	175	6.90%	0.03898051
Table 5	2015	1	295.3815709	33044	31703	"Louisville, KY"	"New York City, NY (Metropolitan Area)"	19790	DL	5440	16.63%	305.446875	175	25.92%	600	5.33%	0.158088235
Table 5	2015	1	295.3815709	33044	31703	"Louisville, KY"	"New York City, NY (Metropolitan Area)"	19977	UA	3560	10.88%	326.6747191	175	13.76%	600	6.46%	0.176966292
Table 5	2015	1	387.7838532	33105	31650	"Cincinnati, OH"	"Minneapolis/St. Paul, MN"	19790	DL	6260	38.29%	416.1166134	200	9.90%	625	12.30%	0.233226837
Table 5	2015	1	394.5946507	33105	31703	"Cincinnati, OH"	"New York City, NY (Metropolitan Area)"	19790	DL	13750	26.18%	423.98	200	8.29%	700	6.47%	0.241454545
Table 5	2015	1	394.5946507	33105	31703	"Cincinnati, OH"	"New York City, NY (Metropolitan Area)"	19977	UA	6120	11.65%	420.9423203	125	6.05%	700	7.68%	0.514705882
Table 5	2015	1	327.5632374	33105	34100	"Cincinnati, OH"	"Philadelphia, PA"	19790	DL	3130	15.26%	294.4303514	175	8.31%	400	9.90%	0.015974441
Table 5	2015	1	327.5632374	33105	34100	"Cincinnati, OH"	"Philadelphia, PA"	20355	US	6360	31.01%	347.5820755	225	5.97%	425	7.23%	0.04245283
Table 5	2015	1	118.8380625	33264	34057	"Medford, OR"	"Portland, OR"	19930	AS	8270	51.69%	117.8275695	75	24.06%	200	12.09%	0.024183797
Table 5	2015	1	269.228611	33342	34100	"Milwaukee, WI"	"Philadelphia, PA"	20355	US	6090	33.70%	296.627422	125	9.20%	375	8.37%	0.149425287
Table 5	2015	1	117.7216163	34057	31884	"Portland, OR"	"Spokane, WA"	19930	AS	19840	49.18%	117.5958165	75	19.81%	175	7.46%	0.035282258
Table 5	2015	1	279.3368095	34100	30198	"Philadelphia, PA"	"Pittsburgh, PA"	20355	US	16620	46.84%	283.0395307	200	6.56%	400	5.35%	0.012033694
Table 5	2015	1	273.6661033	34100	34492	"Philadelphia, PA"	"Raleigh/Durham, NC"	20355	US	16530	39.91%	285.2597701	150	8.65%	325	21.05%	0.066545675
Table 5	2015	1	278.9312543	35412	31703	"Knoxville, TN"	"New York City, NY (Metropolitan Area)"	19790	DL	2690	18.44%	301.5817844	175	13.38%	375	8.18%	0.148698885
Table 5	2015	1	278.9312543	35412	31703	"Knoxville, TN"	"New York City, NY (Metropolitan Area)"	20355	US	2060	14.12%	266.5014563	175	12.14%	275	7.28%	0.048543689