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	2	272.1987709	30194	31423	"Dallas/Fort Worth, TX"	"Des Moines, IA"	19805	AA	6860	38.32%	292.1446064	175	14.58%	375	5.10%	0.080174927
Table 5	2015	2	279.6787265	30194	33044	"Dallas/Fort Worth, TX"	"Louisville, KY"	19805	AA	9280	33.57%	306.6393319	175	8.41%	375	5.93%	0.068965517
Table 5	2015	2	295.2544118	30255	30852	"Huntsville, AL"	"Washington, DC (Metropolitan Area)"	19790	DL	4430	14.16%	283.7433409	175	9.26%	375	8.13%	0.042889391
Table 5	2015	2	295.2544118	30255	30852	"Huntsville, AL"	"Washington, DC (Metropolitan Area)"	20355	US	8700	27.81%	291.522069	125	17.47%	525	5.98%	0.217241379
Table 5	2015	2	262.9616151	30257	30977	"Albany, NY"	"Chicago, IL"	19977	UA	7120	25.33%	277.5620787	175	8.43%	375	7.72%	0.018258427
Table 5	2015	2	262.9616151	30257	30977	"Albany, NY"	"Chicago, IL"	19393	WN	4910	17.47%	242.1812627	150	7.54%	400	6.52%	0
Table 5	2015	2	303.2070601	30397	31057	"Atlanta, GA (Metropolitan Area)"	"Charlotte, NC"	19790	DL	7530	27.26%	338.9900398	200	8.63%	500	12.75%	0.013280212
Table 5	2015	2	303.2070601	30397	31057	"Atlanta, GA (Metropolitan Area)"	"Charlotte, NC"	20355	US	5000	18.10%	266.6954	75	13.60%	500	10.40%	0.52
Table 5	2015	2	281.8083981	30397	31986	"Atlanta, GA (Metropolitan Area)"	"Grand Rapids, MI"	19790	DL	8290	40.24%	295.4588661	175	9.77%	450	6.27%	0.125452352
Table 5	2015	2	262.3474792	30397	31995	"Atlanta, GA (Metropolitan Area)"	"Greensboro/High Point, NC"	19790	DL	6910	38.28%	293.5298119	125	8.97%	500	7.38%	0.322720695
Table 5	2015	2	272.9112485	30397	32070	"Atlanta, GA (Metropolitan Area)"	"Harrisburg, PA"	19790	DL	5970	36.90%	283.0144054	150	11.06%	275	5.86%	0.180904523
Table 5	2015	2	285.0645777	30397	32600	"Atlanta, GA (Metropolitan Area)"	"Little Rock, AR"	19790	DL	7410	40.38%	291.1013495	100	9.45%	425	7.69%	0.407557355
Table 5	2015	2	260.8311949	30397	33044	"Atlanta, GA (Metropolitan Area)"	"Louisville, KY"	19790	DL	10620	42.58%	275.4348399	100	5.27%	375	6.59%	0.354990584
Table 5	2015	2	267.9671012	30397	33105	"Atlanta, GA (Metropolitan Area)"	"Cincinnati, OH"	19790	DL	13850	38.42%	321.0940072	175	7.36%	525	5.34%	0.075090253
Table 5	2015	2	331.6987722	30397	33244	"Atlanta, GA (Metropolitan Area)"	"Memphis, TN"	19790	DL	12120	41.34%	361.689934	225	7.76%	575	5.28%	0.008250825
Table 5	2015	2	82.79715142	30397	35356	"Atlanta, GA (Metropolitan Area)"	"Trenton, NJ"	20436	F9	9830	49.13%	82.41027467	75	48.32%	125	8.44%	0
Table 5	2015	2	310.0801877	30647	31650	"Cleveland, OH (Metropolitan Area)"	"Minneapolis/St. Paul, MN"	19790	DL	8400	29.20%	344.6788095	250	11.55%	600	5.36%	0.016666667
Table 5	2015	2	266.2605433	30721	31066	"Boston, MA (Metropolitan Area)"	"Columbus, OH"	19790	DL	6670	14.85%	362.3463268	175	7.80%	525	5.85%	0.218890555
Table 5	2015	2	266.2605433	30721	31066	"Boston, MA (Metropolitan Area)"	"Columbus, OH"	20355	US	6410	14.27%	224.900624	125	7.33%	275	6.86%	0.087363495
Table 5	2015	2	266.2605433	30721	31066	"Boston, MA (Metropolitan Area)"	"Columbus, OH"	19393	WN	5300	11.80%	226.2254717	150	10.19%	375	6.04%	0.005660377
Table 5	2015	2	260.0176399	30721	31267	"Boston, MA (Metropolitan Area)"	"Dayton, OH"	20355	US	2990	18.19%	267.3434783	175	19.06%	375	9.03%	0.030100334
Table 5	2015	2	382.5423371	30977	31834	"Chicago, IL"	"Fayetteville, AR"	19805	AA	6490	38.11%	384.3343606	175	10.48%	600	9.24%	0.269645609
Table 5	2015	2	281.5058161	30977	32070	"Chicago, IL"	"Harrisburg, PA"	19805	AA	3250	15.24%	317.2738462	175	6.15%	425	7.69%	0.070769231
Table 5	2015	2	281.5058161	30977	32070	"Chicago, IL"	"Harrisburg, PA"	19977	UA	6010	28.19%	260.5184692	175	7.99%	425	5.16%	0.023294509
Table 5	2015	2	262.4376109	30977	32337	"Chicago, IL"	"Indianapolis, IN"	19805	AA	4600	27.20%	292.1013043	150	5.43%	325	23.04%	0.104347826
Table 5	2015	2	262.4376109	30977	32337	"Chicago, IL"	"Indianapolis, IN"	19977	UA	3600	21.29%	254.2663889	150	8.33%	325	18.89%	0.019444444
Table 5	2015	2	311.1931129	30977	33105	"Chicago, IL"	"Cincinnati, OH"	19805	AA	4160	11.37%	353.2336538	200	6.01%	400	5.77%	0.038461538
Table 5	2015	2	311.1931129	30977	33105	"Chicago, IL"	"Cincinnati, OH"	19790	DL	6060	16.56%	312.4584158	200	11.06%	375	25.41%	0.011551155
Table 5	2015	2	311.1931129	30977	33105	"Chicago, IL"	"Cincinnati, OH"	19977	UA	6990	19.10%	303.6230329	200	7.73%	375	23.75%	0.015736767
Table 5	2015	2	334.6391149	30977	34524	"Chicago, IL"	"Richmond, VA"	19805	AA	5120	16.66%	334.9294922	175	24.61%	525	8.79%	0.115234375
Table 5	2015	2	334.6391149	30977	34524	"Chicago, IL"	"Richmond, VA"	19977	UA	5850	19.04%	374.6177778	250	14.02%	550	6.67%	0.020512821
Table 5	2015	2	81.82221553	30977	35356	"Chicago, IL"	"Trenton, NJ"	20436	F9	7810	47.02%	81.93354673	75	50.32%	150	5.76%	0.005121639
Table 5	2015	2	272.8193617	30977	35412	"Chicago, IL"	"Knoxville, TN"	19805	AA	2740	14.57%	282.9186131	150	14.23%	350	20.44%	0.076642336
Table 5	2015	2	272.8193617	30977	35412	"Chicago, IL"	"Knoxville, TN"	19977	UA	4770	25.37%	269.3867925	200	18.24%	350	21.59%	0.012578616
Table 5	2015	2	272.6773035	31057	30693	"Charlotte, NC"	"Nashville, TN"	20355	US	10190	36.25%	298.4569185	175	5.69%	450	6.77%	0.02747792
Table 5	2015	2	304.7555767	31057	31295	"Charlotte, NC"	"Detroit, MI"	19790	DL	8810	20.95%	322.3169126	100	6.58%	650	5.11%	0.48354143
Table 5	2015	2	304.7555767	31057	31295	"Charlotte, NC"	"Detroit, MI"	20355	US	9550	22.71%	302.0681675	100	5.13%	425	5.55%	0.393717277
Table 5	2015	2	260.8834917	31057	32467	"Charlotte, NC"	"Miami, FL (Metropolitan Area)"	19790	DL	7240	10.75%	184.3194751	150	43.65%	275	8.29%	0.005524862
Table 5	2015	2	260.8834917	31057	32467	"Charlotte, NC"	"Miami, FL (Metropolitan Area)"	20355	US	21350	31.70%	278.3137705	175	12.22%	475	6.04%	0.037470726
Table 5	2015	2	262.4943094	31057	33105	"Charlotte, NC"	"Cincinnati, OH"	19790	DL	2130	12.63%	227.8943662	125	9.86%	300	12.68%	0.051643192
Table 5	2015	2	262.4943094	31057	33105	"Charlotte, NC"	"Cincinnati, OH"	20355	US	5740	34.02%	274.8783972	175	11.15%	350	18.12%	0.043554007
Table 5	2015	2	263.0662306	31057	33195	"Charlotte, NC"	"Tampa, FL (Metropolitan Area)"	19790	DL	4140	11.28%	187.67343	125	26.33%	300	5.56%	0.031400966
Table 5	2015	2	263.0662306	31057	33195	"Charlotte, NC"	"Tampa, FL (Metropolitan Area)"	20355	US	12660	34.51%	290.3526856	75	5.21%	475	5.77%	0.70221169
Table 5	2015	2	260.1549199	31057	34027	"Charlotte, NC"	"West Palm Beach/Palm Beach, FL"	19790	DL	1930	11.04%	181.4378238	150	45.60%	300	8.81%	0.005181347
Table 5	2015	2	260.1549199	31057	34027	"Charlotte, NC"	"West Palm Beach/Palm Beach, FL"	20355	US	6300	36.04%	285.425873	175	15.24%	475	5.24%	0.03968254
Table 5	2015	2	74.91305511	31057	35356	"Charlotte, NC"	"Trenton, NJ"	20436	F9	9430	50.45%	74.92820785	75	60.87%	125	8.38%	0
Table 5	2015	2	314.8844307	31066	31650	"Columbus, OH"	"Minneapolis/St. Paul, MN"	19790	DL	7140	27.65%	366.4417367	200	8.40%	650	7.28%	0.196078431
Table 5	2015	2	314.8844307	31066	31650	"Columbus, OH"	"Minneapolis/St. Paul, MN"	19393	WN	3150	12.20%	240.6790476	175	11.11%	325	7.30%	0.003174603
Table 5	2015	2	341.01763	31066	31703	"Columbus, OH"	"New York City, NY (Metropolitan Area)"	19790	DL	12680	14.18%	371.0978707	200	10.88%	625	6.07%	0.164826498
Table 5	2015	2	341.01763	31066	31703	"Columbus, OH"	"New York City, NY (Metropolitan Area)"	19977	UA	12390	13.85%	374.9231638	100	6.62%	625	5.73%	0.521388216
Table 5	2015	2	299.7041353	31066	34100	"Columbus, OH"	"Philadelphia, PA"	20355	US	12300	38.53%	306.4260976	175	7.48%	450	6.99%	0.03495935
Table 5	2015	2	281.83177	31267	31703	"Dayton, OH"	"New York City, NY (Metropolitan Area)"	19805	AA	2790	10.55%	266.7516129	175	41.94%	375	7.89%	0.050179211
Table 5	2015	2	281.83177	31267	31703	"Dayton, OH"	"New York City, NY (Metropolitan Area)"	19977	UA	3060	11.57%	330.6611111	225	13.40%	425	8.82%	0.026143791
Table 5	2015	2	281.83177	31267	31703	"Dayton, OH"	"New York City, NY (Metropolitan Area)"	20355	US	4500	17.02%	249.9268889	175	27.78%	375	6.67%	0.024444444
Table 5	2015	2	299.1864878	31295	30529	"Detroit, MI"	"Hartford, CT"	19790	DL	7840	38.95%	306.2653061	175	11.86%	375	5.87%	0.132653061
Table 5	2015	2	119.3768807	31295	31135	"Detroit, MI"	"Myrtle Beach, SC"	19790	DL	3250	11.93%	188.3538462	125	14.77%	250	10.77%	0.030769231
Table 5	2015	2	119.3768807	31295	31135	"Detroit, MI"	"Myrtle Beach, SC"	20416	NK	9500	34.86%	88.42536842	75	40.32%	150	9.68%	0.001052632
Table 5	2015	2	279.7706013	31295	31650	"Detroit, MI"	"Minneapolis/St. Paul, MN"	19790	DL	18320	31.20%	356.4788755	175	8.73%	600	7.21%	0.212336245
Table 5	2015	2	279.7706013	31295	31650	"Detroit, MI"	"Minneapolis/St. Paul, MN"	20416	NK	7130	12.14%	86.12847125	75	53.16%	175	9.26%	0
Table 5	2015	2	262.299159	31295	33198	"Detroit, MI"	"Kansas City, MO"	19790	DL	8820	23.93%	364.1867347	150	5.67%	625	9.18%	0.30952381
Table 5	2015	2	262.299159	31295	33198	"Detroit, MI"	"Kansas City, MO"	20416	NK	4170	11.31%	86.55755396	75	56.12%	175	8.87%	0.002398082
Table 5	2015	2	262.299159	31295	33198	"Detroit, MI"	"Kansas City, MO"	19393	WN	4370	11.86%	215.9894737	125	5.03%	350	8.47%	0.004576659
Table 5	2015	2	385.6193086	31295	34100	"Detroit, MI"	"Philadelphia, PA"	19790	DL	11220	27.70%	369.5231729	100	5.53%	700	6.42%	0.51426025
Table 5	2015	2	385.6193086	31295	34100	"Detroit, MI"	"Philadelphia, PA"	20355	US	6800	16.79%	454.4448529	200	6.47%	700	9.12%	0.251470588
Table 5	2015	2	276.9028792	31295	34492	"Detroit, MI"	"Raleigh/Durham, NC"	19790	DL	8320	29.21%	308.1277644	175	6.37%	450	7.09%	0.126201923
Table 5	2015	2	281.900072	31650	30198	"Minneapolis/St. Paul, MN"	"Pittsburgh, PA"	19790	DL	8240	29.67%	321.1177184	125	10.07%	525	5.10%	0.333737864
Table 5	2015	2	291.5754537	31650	30693	"Minneapolis/St. Paul, MN"	"Nashville, TN"	19790	DL	9710	28.89%	335.7881565	200	10.50%	475	5.56%	0.044284243
Table 5	2015	2	291.5754537	31650	30693	"Minneapolis/St. Paul, MN"	"Nashville, TN"	19393	WN	4720	14.04%	220.9279661	175	25.42%	300	5.93%	0
Table 5	2015	2	288.1980691	31703	30198	"New York City, NY (Metropolitan Area)"	"Pittsburgh, PA"	19790	DL	19700	18.56%	286.8698477	125	8.07%	525	5.69%	0.301522843
Table 5	2015	2	288.1980691	31703	30198	"New York City, NY (Metropolitan Area)"	"Pittsburgh, PA"	19977	UA	13150	12.39%	303.138403	150	12.62%	525	10.65%	0.245627376
Table 5	2015	2	288.1980691	31703	30198	"New York City, NY (Metropolitan Area)"	"Pittsburgh, PA"	20355	US	15050	14.18%	295.7760133	125	5.58%	350	9.44%	0.257807309
Table 5	2015	2	304.5289209	31703	33667	"New York City, NY (Metropolitan Area)"	"Norfolk, VA (Metropolitan Area)"	19790	DL	4220	14.14%	346.5888626	175	6.64%	550	7.58%	0.146919431
Table 5	2015	2	304.5289209	31703	33667	"New York City, NY (Metropolitan Area)"	"Norfolk, VA (Metropolitan Area)"	19977	UA	3860	12.94%	305.5626943	175	8.29%	500	5.18%	0.056994819
Table 5	2015	2	304.5289209	31703	33667	"New York City, NY (Metropolitan Area)"	"Norfolk, VA (Metropolitan Area)"	20355	US	3270	10.96%	301.8672783	175	8.87%	550	6.42%	0.119266055
Table 5	2015	2	381.2877335	31703	34524	"New York City, NY (Metropolitan Area)"	"Richmond, VA"	19790	DL	9520	24.03%	392.1894958	175	5.04%	550	7.98%	0.226890756
Table 5	2015	2	381.2877335	31703	34524	"New York City, NY (Metropolitan Area)"	"Richmond, VA"	19977	UA	4130	10.42%	370.3380145	200	10.41%	550	6.05%	0.04842615
Table 5	2015	2	381.2877335	31703	34524	"New York City, NY (Metropolitan Area)"	"Richmond, VA"	20355	US	5130	12.95%	385.8046784	200	10.33%	600	5.46%	0.052631579
Table 5	2015	2	272.1420997	31986	31703	"Grand Rapids, MI"	"New York City, NY (Metropolitan Area)"	19790	DL	6060	21.42%	261.3605611	125	5.61%	275	5.78%	0.188118812
Table 5	2015	2	272.1420997	31986	31703	"Grand Rapids, MI"	"New York City, NY (Metropolitan Area)"	19977	UA	5420	19.16%	285.2062731	150	22.14%	275	6.27%	0.175276753
Table 5	2015	2	264.8027131	31995	31703	"Greensboro/High Point, NC"	"New York City, NY (Metropolitan Area)"	19790	DL	8000	18.09%	265.501	150	9.13%	375	8.25%	0.07875
Table 5	2015	2	264.8027131	31995	31703	"Greensboro/High Point, NC"	"New York City, NY (Metropolitan Area)"	19977	UA	5870	13.27%	258.8487223	100	6.98%	375	6.30%	0.316865417
Table 5	2015	2	93.29327902	32211	34716	"Las Vegas, NV"	"Stockton, CA"	20368	G4	10110	51.48%	95.34668645	75	35.61%	200	5.93%	0
Table 5	2015	2	333.7098901	32337	31650	"Indianapolis, IN"	"Minneapolis/St. Paul, MN"	19790	DL	9960	34.20%	371.1126506	175	5.22%	625	8.03%	0.346385542
Table 5	2015	2	327.5307743	32337	31703	"Indianapolis, IN"	"New York City, NY (Metropolitan Area)"	19790	DL	15230	16.63%	370.6683519	175	6.30%	325	5.45%	0.267235719
Table 5	2015	2	327.5307743	32337	31703	"Indianapolis, IN"	"New York City, NY (Metropolitan Area)"	19977	UA	16010	17.48%	352.1276702	200	13.49%	325	6.00%	0.121798876
Table 5	2015	2	289.2576348	32337	34100	"Indianapolis, IN"	"Philadelphia, PA"	20355	US	13870	35.12%	302.2679885	175	10.67%	450	6.92%	0.042537851
Table 5	2015	2	94.35399876	32945	34761	"Lexington, KY"	"Sanford, FL"	20368	G4	7880	48.85%	88.22335025	75	46.32%	150	5.84%	0.002538071
Table 5	2015	2	306.861527	33044	31703	"Louisville, KY"	"New York City, NY (Metropolitan Area)"	19790	DL	8300	17.65%	325.7385542	175	12.41%	600	5.42%	0.178313253
Table 5	2015	2	306.861527	33044	31703	"Louisville, KY"	"New York City, NY (Metropolitan Area)"	19977	UA	6540	13.91%	330.4689602	175	10.70%	600	5.35%	0.185015291
Table 5	2015	2	271.5964118	33044	34100	"Louisville, KY"	"Philadelphia, PA"	20355	US	5680	33.41%	284.7633803	150	11.27%	375	7.04%	0.107394366
Table 5	2015	2	374.2213302	33105	31650	"Cincinnati, OH"	"Minneapolis/St. Paul, MN"	19790	DL	8030	38.15%	401.1363636	200	5.48%	675	7.47%	0.240348692
Table 5	2015	2	381.8760761	33105	31703	"Cincinnati, OH"	"New York City, NY (Metropolitan Area)"	19790	DL	18270	26.75%	403.355884	200	6.62%	650	5.75%	0.191570881
Table 5	2015	2	381.8760761	33105	31703	"Cincinnati, OH"	"New York City, NY (Metropolitan Area)"	19977	UA	8080	11.83%	399.2638614	200	6.93%	650	5.07%	0.20049505
Table 5	2015	2	311.0463913	33105	34100	"Cincinnati, OH"	"Philadelphia, PA"	19790	DL	3570	14.31%	308.7330532	175	5.60%	425	8.96%	0.025210084
Table 5	2015	2	311.0463913	33105	34100	"Cincinnati, OH"	"Philadelphia, PA"	20355	US	7600	30.47%	314.6455263	175	7.11%	425	13.16%	0.040789474
Table 5	2015	2	84.29694836	33105	34761	"Cincinnati, OH"	"Sanford, FL"	20368	G4	8670	50.88%	79.04786621	75	56.40%	125	10.27%	0
Table 5	2015	2	264.4294534	33342	34100	"Milwaukee, WI"	"Philadelphia, PA"	20355	US	7860	30.91%	287.9290076	175	6.49%	375	11.70%	0.030534351
Table 5	2015	2	287.0607192	34100	30198	"Philadelphia, PA"	"Pittsburgh, PA"	20355	US	16480	45.59%	291.4442961	150	5.70%	425	6.98%	0.037621359
Table 5	2015	2	270.3679394	34100	34492	"Philadelphia, PA"	"Raleigh/Durham, NC"	20355	US	18310	36.99%	277.0744402	150	8.19%	350	5.95%	0.034953577
Table 5	2015	2	286.7446861	35412	30852	"Knoxville, TN"	"Washington, DC (Metropolitan Area)"	19790	DL	1920	11.93%	286.7848958	125	6.25%	325	8.85%	0.208333333
Table 5	2015	2	286.7446861	35412	30852	"Knoxville, TN"	"Washington, DC (Metropolitan Area)"	20355	US	5210	32.38%	278.3071017	125	12.09%	300	8.25%	0.199616123
Table 5	2015	2	284.0509288	35412	31703	"Knoxville, TN"	"New York City, NY (Metropolitan Area)"	19790	DL	3940	20.33%	311.6652284	200	11.42%	400	5.33%	0.058375635
Table 5	2015	2	284.0509288	35412	31703	"Knoxville, TN"	"New York City, NY (Metropolitan Area)"	20355	US	2870	14.81%	248.3407666	175	21.60%	300	9.41%	0.017421603