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	2	274.0379895	30194	33044	"Dallas/Fort Worth, TX"	"Louisville, KY"	19805	AA	18550	69.84%	281.4590836	200	16.12%	375	15.20%	0.015633423
Table 5	2014	2	274.0379895	30194	33044	"Dallas/Fort Worth, TX"	"Louisville, KY"	19790	DL	2800	10.54%	249.7625	175	13.21%	275	6.07%	0.042857143
Table 5	2014	2	329.1255814	30194	33244	"Dallas/Fort Worth, TX"	"Memphis, TN"	19805	AA	14740	67.21%	334.792673	75	5.63%	500	8.48%	0.695386703
Table 5	2014	2	329.1255814	30194	33244	"Dallas/Fort Worth, TX"	"Memphis, TN"	19790	DL	3490	15.91%	381.725788	200	5.16%	650	7.45%	0.108882521
Table 5	2014	2	323.1947064	30255	30852	"Huntsville, AL"	"Washington, DC (Metropolitan Area)"	19790	DL	9000	27.38%	311.4211111	200	11.78%	375	5.33%	0.042222222
Table 5	2014	2	323.1947064	30255	30852	"Huntsville, AL"	"Washington, DC (Metropolitan Area)"	20355	US	19810	60.27%	321.261787	125	31.10%	400	26.15%	0.426552246
Table 5	2014	2	294.7857509	30397	31057	"Atlanta, GA (Metropolitan Area)"	"Charlotte, NC"	19790	DL	15690	57.47%	313.5758445	75	6.18%	500	5.48%	0.684512428
Table 5	2014	2	294.7857509	30397	31057	"Atlanta, GA (Metropolitan Area)"	"Charlotte, NC"	20355	US	11040	40.44%	266.6346014	75	15.49%	475	13.32%	0.544384058
Table 5	2014	2	300.9571587	30397	31986	"Atlanta, GA (Metropolitan Area)"	"Grand Rapids, MI"	19790	DL	14820	82.24%	312.7761808	175	7.09%	425	6.14%	0.134952767
Table 5	2014	2	279.9245484	30397	33105	"Atlanta, GA (Metropolitan Area)"	"Cincinnati, OH"	19790	DL	27060	95.86%	281.3474132	150	8.46%	375	6.06%	0.111234294
Table 5	2014	2	322.4595467	30397	33244	"Atlanta, GA (Metropolitan Area)"	"Memphis, TN"	19790	DL	27450	94.27%	326.1044444	200	5.54%	500	9.00%	0.021493625
Table 5	2014	2	116.6952835	30397	35356	"Atlanta, GA (Metropolitan Area)"	"Trenton, NJ"	20436	F9	18800	99.63%	116.811383	75	21.38%	200	5.00%	0.050531915
Table 5	2014	2	260.5641051	30423	31123	"Austin, TX"	"St. Louis, MO"	19805	AA	5460	27.07%	236.9752747	175	18.86%	275	10.07%	0.02014652
Table 5	2014	2	260.5641051	30423	31123	"Austin, TX"	"St. Louis, MO"	19393	WN	13200	65.44%	268.2995455	175	12.58%	425	5.30%	0.003030303
Table 5	2014	2	315.5690256	30647	31650	"Cleveland, OH (Metropolitan Area)"	"Minneapolis/St. Paul, MN"	19790	DL	18350	62.74%	333.679564	225	8.23%	500	9.59%	0.022343324
Table 5	2014	2	315.5690256	30647	31650	"Cleveland, OH (Metropolitan Area)"	"Minneapolis/St. Paul, MN"	19977	UA	4510	15.42%	308.0399113	200	7.54%	500	5.10%	0.026607539
Table 5	2014	2	315.5690256	30647	31650	"Cleveland, OH (Metropolitan Area)"	"Minneapolis/St. Paul, MN"	19393	WN	3530	12.07%	264.8951841	200	16.71%	400	7.65%	0.002832861
Table 5	2014	2	271.7049261	30647	33198	"Cleveland, OH (Metropolitan Area)"	"Kansas City, MO"	19790	DL	3210	19.77%	241.1093458	150	5.92%	350	6.23%	0.043613707
Table 5	2014	2	271.7049261	30647	33198	"Cleveland, OH (Metropolitan Area)"	"Kansas City, MO"	19977	UA	4580	28.20%	317.5117904	175	8.73%	425	14.85%	0.043668122
Table 5	2014	2	271.7049261	30647	33198	"Cleveland, OH (Metropolitan Area)"	"Kansas City, MO"	19393	WN	6710	41.32%	252.0260805	175	16.54%	350	16.84%	0.001490313
Table 5	2014	2	358.5802321	30647	34100	"Cleveland, OH (Metropolitan Area)"	"Philadelphia, PA"	20355	US	20380	87.58%	368.9946026	150	5.00%	525	8.44%	0.347890088
Table 5	2014	2	274.0126557	30868	30852	"Columbia, SC"	"Washington, DC (Metropolitan Area)"	19790	DL	2970	14.80%	339.5154882	175	7.41%	350	10.77%	0.117845118
Table 5	2014	2	274.0126557	30868	30852	"Columbia, SC"	"Washington, DC (Metropolitan Area)"	19977	UA	6310	31.44%	227.6513471	100	30.59%	650	5.39%	0.255150555
Table 5	2014	2	274.0126557	30868	30852	"Columbia, SC"	"Washington, DC (Metropolitan Area)"	20355	US	10300	51.32%	281.4350485	100	9.32%	650	5.73%	0.321359223
Table 5	2014	2	329.2562316	30977	33105	"Chicago, IL"	"Cincinnati, OH"	19805	AA	9990	32.68%	319.8374374	200	8.21%	500	8.41%	0.019019019
Table 5	2014	2	329.2562316	30977	33105	"Chicago, IL"	"Cincinnati, OH"	19790	DL	9350	30.59%	356.2681283	175	5.67%	500	14.87%	0.03315508
Table 5	2014	2	329.2562316	30977	33105	"Chicago, IL"	"Cincinnati, OH"	19977	UA	10550	34.51%	312.3709953	150	6.07%	500	12.61%	0.233175355
Table 5	2014	2	323.7572002	30977	34524	"Chicago, IL"	"Richmond, VA"	19805	AA	7910	24.44%	329.9940582	175	5.69%	525	10.49%	0.12642225
Table 5	2014	2	323.7572002	30977	34524	"Chicago, IL"	"Richmond, VA"	19790	DL	3460	10.69%	284.6069364	175	5.20%	350	12.43%	0.040462428
Table 5	2014	2	323.7572002	30977	34524	"Chicago, IL"	"Richmond, VA"	19977	UA	14520	44.87%	341.3703168	200	11.71%	625	5.51%	0.090220386
Table 5	2014	2	323.7572002	30977	34524	"Chicago, IL"	"Richmond, VA"	20355	US	3460	10.69%	319.5011561	200	5.49%	250	18.21%	0.083815029
Table 5	2014	2	110.9336377	30977	35356	"Chicago, IL"	"Trenton, NJ"	20436	F9	20640	99.18%	111.0129845	75	26.31%	175	7.41%	0.031007752
Table 5	2014	2	312.3026371	31057	31295	"Charlotte, NC"	"Detroit, MI"	19790	DL	15710	41.43%	322.8580522	100	5.41%	625	7.64%	0.45385105
Table 5	2014	2	312.3026371	31057	31295	"Charlotte, NC"	"Detroit, MI"	20355	US	17340	45.73%	318.571857	175	6.86%	625	5.82%	0.173587082
Table 5	2014	2	279.2910946	31057	33105	"Charlotte, NC"	"Cincinnati, OH"	19790	DL	4800	29.68%	268.50625	150	6.25%	425	6.46%	0.03125
Table 5	2014	2	279.2910946	31057	33105	"Charlotte, NC"	"Cincinnati, OH"	20355	US	10960	67.78%	285.1336679	175	9.67%	425	7.03%	0.042883212
Table 5	2014	2	280.6479405	31057	33244	"Charlotte, NC"	"Memphis, TN"	19790	DL	3370	19.28%	241.6780415	150	10.98%	350	6.53%	0.038575668
Table 5	2014	2	280.6479405	31057	33244	"Charlotte, NC"	"Memphis, TN"	20355	US	12940	74.03%	288.9709428	150	6.65%	350	5.95%	0.128284389
Table 5	2014	2	292.5088849	31057	34100	"Charlotte, NC"	"Philadelphia, PA"	20355	US	48760	88.41%	302.6760049	175	11.73%	450	6.62%	0.044298605
Table 5	2014	2	305.5101038	31066	31650	"Columbus, OH"	"Minneapolis/St. Paul, MN"	19790	DL	14390	57.47%	338.8275886	200	15.36%	625	8.55%	0.123002085
Table 5	2014	2	305.5101038	31066	31650	"Columbus, OH"	"Minneapolis/St. Paul, MN"	19393	WN	6160	24.60%	246.8631494	175	17.37%	400	6.49%	0
Table 5	2014	2	338.3600111	31066	31703	"Columbus, OH"	"New York City, NY (Metropolitan Area)"	19805	AA	21930	24.45%	330.7470132	175	12.63%	650	5.79%	0.171454628
Table 5	2014	2	338.3600111	31066	31703	"Columbus, OH"	"New York City, NY (Metropolitan Area)"	19790	DL	27190	30.31%	364.7057374	175	7.91%	650	8.28%	0.220301581
Table 5	2014	2	338.3600111	31066	31703	"Columbus, OH"	"New York City, NY (Metropolitan Area)"	19977	UA	21580	24.06%	392.2037998	100	6.02%	275	8.62%	0.507414272
Table 5	2014	2	338.3600111	31066	31703	"Columbus, OH"	"New York City, NY (Metropolitan Area)"	20355	US	9470	10.56%	267.3085533	175	13.83%	275	8.03%	0.070749736
Table 5	2014	2	274.94805	31066	34100	"Columbus, OH"	"Philadelphia, PA"	20355	US	28470	84.76%	287.7280646	125	9.52%	450	6.08%	0.191078328
Table 5	2014	2	118.755614	31135	34100	"Myrtle Beach, SC"	"Philadelphia, PA"	20416	NK	10780	51.51%	78.77105751	75	52.13%	150	6.31%	0.000927644
Table 5	2014	2	118.755614	31135	34100	"Myrtle Beach, SC"	"Philadelphia, PA"	20355	US	9090	43.43%	161.8490649	100	11.88%	225	7.81%	0.062706271
Table 5	2014	2	273.2667345	31267	31703	"Dayton, OH"	"New York City, NY (Metropolitan Area)"	19805	AA	6280	21.30%	273.6896497	150	9.08%	650	5.10%	0.151273885
Table 5	2014	2	273.2667345	31267	31703	"Dayton, OH"	"New York City, NY (Metropolitan Area)"	19790	DL	3450	11.70%	282.2782609	100	7.54%	275	6.96%	0.333333333
Table 5	2014	2	273.2667345	31267	31703	"Dayton, OH"	"New York City, NY (Metropolitan Area)"	19977	UA	9890	33.54%	288.8547017	175	10.72%	350	14.26%	0.031344793
Table 5	2014	2	273.2667345	31267	31703	"Dayton, OH"	"New York City, NY (Metropolitan Area)"	20355	US	7320	24.82%	262.9224044	150	5.33%	325	6.42%	0.087431694
Table 5	2014	2	282.2129454	31295	30529	"Detroit, MI"	"Hartford, CT"	19790	DL	15290	68.97%	315.558208	175	10.86%	625	5.04%	0.159581426
Table 5	2014	2	282.2129454	31295	30529	"Detroit, MI"	"Hartford, CT"	20355	US	3880	17.50%	207.8523196	150	11.08%	300	5.15%	0.018041237
Table 5	2014	2	118.0064694	31295	31135	"Detroit, MI"	"Myrtle Beach, SC"	19790	DL	6960	22.63%	188.8731322	125	19.68%	300	6.18%	0.022988506
Table 5	2014	2	118.0064694	31295	31135	"Detroit, MI"	"Myrtle Beach, SC"	20416	NK	22260	72.37%	90.69964061	75	36.21%	150	12.53%	0.00359389
Table 5	2014	2	308.3509137	31295	31650	"Detroit, MI"	"Minneapolis/St. Paul, MN"	19790	DL	35420	69.60%	367.3555054	200	11.41%	575	9.88%	0.040372671
Table 5	2014	2	308.3509137	31295	31650	"Detroit, MI"	"Minneapolis/St. Paul, MN"	20416	NK	7770	15.27%	95.49330759	75	36.42%	175	5.15%	0.002574003
Table 5	2014	2	269.986926	31295	31703	"Detroit, MI"	"New York City, NY (Metropolitan Area)"	19790	DL	123770	53.67%	325.4168619	150	18.53%	200	6.75%	0.289326977
Table 5	2014	2	269.986926	31295	31703	"Detroit, MI"	"New York City, NY (Metropolitan Area)"	20416	NK	46240	20.05%	129.4036765	100	27.51%	200	20.26%	0.000216263
Table 5	2014	2	321.3168642	31295	33198	"Detroit, MI"	"Kansas City, MO"	19790	DL	18460	56.09%	375.6634886	200	8.61%	575	5.80%	0.070964247
Table 5	2014	2	321.3168642	31295	33198	"Detroit, MI"	"Kansas City, MO"	19393	WN	11710	35.58%	246.292912	200	21.61%	350	12.72%	0
Table 5	2014	2	347.748719	31295	34100	"Detroit, MI"	"Philadelphia, PA"	19790	DL	23090	48.89%	333.4843222	100	6.37%	500	20.92%	0.464270247
Table 5	2014	2	347.748719	31295	34100	"Detroit, MI"	"Philadelphia, PA"	20355	US	20000	42.35%	379.8379	225	6.30%	500	25.15%	0.044
Table 5	2014	2	269.6009063	31295	34492	"Detroit, MI"	"Raleigh/Durham, NC"	19790	DL	14200	53.63%	318.2759155	200	6.83%	625	5.07%	0.097887324
Table 5	2014	2	269.6009063	31295	34492	"Detroit, MI"	"Raleigh/Durham, NC"	20355	US	7540	28.47%	210.182626	175	21.62%	275	5.70%	0.00265252
Table 5	2014	2	269.6009063	31295	34492	"Detroit, MI"	"Raleigh/Durham, NC"	19393	WN	2710	10.23%	208.1712177	150	6.64%	325	6.27%	0.003690037
Table 5	2014	2	105.1529537	31638	32211	"Fresno, CA"	"Las Vegas, NV"	20368	G4	8770	23.34%	79.03078677	75	67.73%	150	5.25%	0
Table 5	2014	2	105.1529537	31638	32211	"Fresno, CA"	"Las Vegas, NV"	19977	UA	28610	76.13%	112.5689619	75	35.30%	175	7.79%	0.052778749
Table 5	2014	2	279.7315234	31650	30198	"Minneapolis/St. Paul, MN"	"Pittsburgh, PA"	19790	DL	15690	61.29%	319.0022945	125	10.71%	325	9.56%	0.326959847
Table 5	2014	2	279.7315234	31650	30198	"Minneapolis/St. Paul, MN"	"Pittsburgh, PA"	19393	WN	3830	14.96%	194.3464752	125	7.57%	300	5.48%	0.028720627
Table 5	2014	2	280.7696429	31650	30693	"Minneapolis/St. Paul, MN"	"Nashville, TN"	19790	DL	17810	58.90%	317.8792813	200	12.52%	450	5.50%	0.033688939
Table 5	2014	2	280.7696429	31650	30693	"Minneapolis/St. Paul, MN"	"Nashville, TN"	19393	WN	8070	26.69%	224.4262701	175	29.12%	250	6.07%	0
Table 5	2014	2	286.3989268	31703	30198	"New York City, NY (Metropolitan Area)"	"Pittsburgh, PA"	19790	DL	38840	36.89%	276.0595263	125	10.50%	475	7.83%	0.287332647
Table 5	2014	2	286.3989268	31703	30198	"New York City, NY (Metropolitan Area)"	"Pittsburgh, PA"	19977	UA	20650	19.61%	348.889201	100	5.81%	675	5.91%	0.527845036
Table 5	2014	2	286.3989268	31703	30198	"New York City, NY (Metropolitan Area)"	"Pittsburgh, PA"	20355	US	38430	36.50%	274.4342961	125	15.90%	475	10.17%	0.259432735
Table 5	2014	2	274.3859491	31703	33667	"New York City, NY (Metropolitan Area)"	"Norfolk, VA (Metropolitan Area)"	19805	AA	6350	20.46%	257.9070866	125	6.14%	525	7.40%	0.240944882
Table 5	2014	2	274.3859491	31703	33667	"New York City, NY (Metropolitan Area)"	"Norfolk, VA (Metropolitan Area)"	19790	DL	9330	30.07%	297.1962487	150	7.82%	525	9.11%	0.217577706
Table 5	2014	2	274.3859491	31703	33667	"New York City, NY (Metropolitan Area)"	"Norfolk, VA (Metropolitan Area)"	19977	UA	5520	17.79%	290.0983696	150	6.34%	500	9.06%	0.210144928
Table 5	2014	2	274.3859491	31703	33667	"New York City, NY (Metropolitan Area)"	"Norfolk, VA (Metropolitan Area)"	20355	US	6140	19.79%	272.9151466	150	8.47%	275	5.21%	0.146579805
Table 5	2014	2	344.2823785	31703	34524	"New York City, NY (Metropolitan Area)"	"Richmond, VA"	19805	AA	6860	16.58%	330.1266764	175	5.25%	525	16.03%	0.074344023
Table 5	2014	2	344.2823785	31703	34524	"New York City, NY (Metropolitan Area)"	"Richmond, VA"	19790	DL	19650	47.50%	342.4378117	200	20.56%	525	14.10%	0.02086514
Table 5	2014	2	344.2823785	31703	34524	"New York City, NY (Metropolitan Area)"	"Richmond, VA"	19977	UA	9970	24.10%	361.519659	200	12.14%	500	20.76%	0.028084253
Table 5	2014	2	115.7561045	31721	30852	"Flint, MI"	"Washington, DC (Metropolitan Area)"	19393	WN	16240	92.22%	108.2876847	75	14.04%	175	5.05%	0.052955665
Table 5	2014	2	293.150717	31986	31703	"Grand Rapids, MI"	"New York City, NY (Metropolitan Area)"	19805	AA	3200	12.08%	238.420625	150	20.00%	300	5.31%	0.040625
Table 5	2014	2	293.150717	31986	31703	"Grand Rapids, MI"	"New York City, NY (Metropolitan Area)"	19790	DL	13110	49.47%	288.7253242	150	5.80%	250	6.64%	0.186117468
Table 5	2014	2	293.150717	31986	31703	"Grand Rapids, MI"	"New York City, NY (Metropolitan Area)"	19977	UA	8780	33.13%	327.6137813	150	7.29%	550	10.14%	0.275626424
Table 5	2014	2	93.54164511	32211	34716	"Las Vegas, NV"	"Stockton, CA"	20368	G4	19330	100.00%	93.54164511	75	36.58%	175	8.12%	0
Table 5	2014	2	311.5675701	32337	31650	"Indianapolis, IN"	"Minneapolis/St. Paul, MN"	19790	DL	23540	73.33%	336.9982583	200	14.32%	575	7.43%	0.016992353
Table 5	2014	2	311.5675701	32337	31650	"Indianapolis, IN"	"Minneapolis/St. Paul, MN"	19977	UA	3790	11.81%	245.2693931	175	15.83%	350	5.28%	0.01055409
Table 5	2014	2	303.6730291	32337	31703	"Indianapolis, IN"	"New York City, NY (Metropolitan Area)"	19790	DL	37520	41.66%	322.9965618	200	26.52%	300	5.06%	0.117270789
Table 5	2014	2	303.6730291	32337	31703	"Indianapolis, IN"	"New York City, NY (Metropolitan Area)"	19977	UA	31570	35.05%	315.417675	175	9.66%	575	8.55%	0.180551156
Table 5	2014	2	303.6730291	32337	31703	"Indianapolis, IN"	"New York City, NY (Metropolitan Area)"	20355	US	9360	10.39%	260.432906	150	6.62%	300	8.01%	0.083333333
Table 5	2014	2	93.05579399	32945	34761	"Lexington, KY"	"Sanford, FL"	20368	G4	18640	100.00%	93.05579399	75	50.16%	150	10.19%	0.028433476
Table 5	2014	2	302.7549712	33044	31703	"Louisville, KY"	"New York City, NY (Metropolitan Area)"	19805	AA	8330	17.11%	300.1908764	175	14.29%	250	5.16%	0.146458583
Table 5	2014	2	302.7549712	33044	31703	"Louisville, KY"	"New York City, NY (Metropolitan Area)"	19790	DL	14590	29.97%	327.044414	150	5.96%	250	6.58%	0.259081563
Table 5	2014	2	302.7549712	33044	31703	"Louisville, KY"	"New York City, NY (Metropolitan Area)"	19977	UA	10870	22.33%	329.7237351	200	11.04%	575	7.36%	0.038638454
Table 5	2014	2	302.7549712	33044	31703	"Louisville, KY"	"New York City, NY (Metropolitan Area)"	20355	US	8530	17.52%	271.8079719	175	14.19%	325	5.63%	0.076201641
Table 5	2014	2	373.7127318	33105	31650	"Cincinnati, OH"	"Minneapolis/St. Paul, MN"	19790	DL	15730	78.85%	403.1239669	225	13.41%	625	14.88%	0.017800381
Table 5	2014	2	375.2032879	33105	31703	"Cincinnati, OH"	"New York City, NY (Metropolitan Area)"	19790	DL	39200	56.78%	410.805	200	7.68%	650	7.35%	0.217602041
Table 5	2014	2	375.2032879	33105	31703	"Cincinnati, OH"	"New York City, NY (Metropolitan Area)"	19977	UA	17240	24.97%	355.4396172	175	8.18%	650	7.37%	0.23549884
Table 5	2014	2	309.331947	33105	34100	"Cincinnati, OH"	"Philadelphia, PA"	19790	DL	8530	31.39%	286.1206331	150	8.79%	400	11.49%	0.096131301
Table 5	2014	2	309.331947	33105	34100	"Cincinnati, OH"	"Philadelphia, PA"	20355	US	17160	63.16%	323.6209207	150	5.36%	475	6.24%	0.144522145
Table 5	2014	2	279.6458312	34100	30198	"Philadelphia, PA"	"Pittsburgh, PA"	20355	US	38470	96.61%	281.4342605	150	9.02%	400	12.37%	0.035612165
Table 5	2014	2	88.67391304	34492	35356	"Raleigh/Durham, NC"	"Trenton, NJ"	20436	F9	16100	100.00%	88.67391304	75	50.93%	150	7.20%	0.016149068
Table 5	2014	2	341.4922344	35412	30852	"Knoxville, TN"	"Washington, DC (Metropolitan Area)"	19790	DL	4520	21.53%	324.4980088	200	12.17%	425	5.31%	0.048672566
Table 5	2014	2	341.4922344	35412	30852	"Knoxville, TN"	"Washington, DC (Metropolitan Area)"	19977	UA	4410	21.01%	288.337415	125	25.62%	200	6.58%	0.292517007
Table 5	2014	2	341.4922344	35412	30852	"Knoxville, TN"	"Washington, DC (Metropolitan Area)"	20355	US	11710	55.79%	367.1408198	125	21.86%	675	8.28%	0.357813834
Table 5	2014	2	274.9030085	35412	31703	"Knoxville, TN"	"New York City, NY (Metropolitan Area)"	19805	AA	2870	12.89%	265.1832753	175	23.34%	375	5.92%	0.087108014
Table 5	2014	2	274.9030085	35412	31703	"Knoxville, TN"	"New York City, NY (Metropolitan Area)"	19790	DL	7810	35.07%	285.5387964	150	5.25%	550	5.51%	0.179257362
Table 5	2014	2	274.9030085	35412	31703	"Knoxville, TN"	"New York City, NY (Metropolitan Area)"	19977	UA	3800	17.06%	284.8413158	175	7.89%	325	5.00%	0.113157895
Table 5	2014	2	274.9030085	35412	31703	"Knoxville, TN"	"New York City, NY (Metropolitan Area)"	20355	US	7070	31.75%	261.4777935	175	12.87%	350	5.37%	0.043847242