tbl	Year	quarter	citymarketid	city	markets	cur_passengers	cur_fare	cur_yield	distance	ly_passengers	ly_fare	ly_yield	ly_distance
Table 2	2015	2	30140	"Albuquerque, NM"	17	658950	212.346829	21.55809921	984.9979209	671350	212.0039056	21.69507842	977.198153
Table 2	2015	2	30158	"Atlantic City, NJ"	4	143980	106.8838589	11.48114379	930.9513127	148320	112.6091019	12.10852841	929.998247
Table 2	2015	2	30194	"Dallas/Fort Worth, TX"	71	6697010	210.3328232	21.72776884	968.036915	6081540	231.6072039	24.43818804	947.7265808
Table 2	2015	2	30198	"Pittsburgh, PA"	22	1197160	227.0292066	22.41184321	1012.987662	1199090	234.8738018	23.22241948	1011.409694
Table 2	2015	2	30257	"Albany, NY"	10	276570	239.5734028	20.17689478	1187.365079	271430	232.3629039	19.73533206	1177.395461
Table 2	2015	2	30325	"Denver, CO"	56	5583930	194.9563514	18.53055035	1052.080741	5691220	193.4456624	18.7934943	1029.322484
Table 2	2015	2	30397	"Atlanta, GA (Metropolitan Area)"	60	6080030	215.0856726	23.85112715	901.7841014	5538910	233.9172409	26.24158864	891.3989323
Table 2	2015	2	30423	"Austin, TX"	31	1893200	220.0736848	19.16005144	1148.606962	1702140	228.9486928	19.89041839	1151.05016
Table 2	2015	2	30436	"Tucson, AZ"	11	349330	212.0430453	21.53162179	984.7982996	387180	200.2917635	20.6422333	970.300842
Table 2	2015	2	30466	"Phoenix, AZ"	53	4635110	209.5689451	17.81408876	1176.422482	4418250	213.1103973	18.39367686	1158.606835
Table 2	2015	2	30529	"Hartford, CT"	21	962640	229.5112389	18.88212146	1215.494983	966690	224.8177141	18.31932385	1227.216222
Table 2	2015	2	30559	"Seattle, WA"	47	4687160	216.4198835	15.42974753	1402.614547	4374740	215.1755012	15.44159417	1393.479837
Table 2	2015	2	30599	"Birmingham, AL"	10	284400	227.2250105	28.25233544	804.2698312	293830	226.0187217	28.08395286	804.7966852
Table 2	2015	2	30615	"El Paso, TX"	10	318940	223.8072459	26.5630667	842.5504797	326450	206.4329698	25.21272564	818.764987
Table 2	2015	2	30647	"Cleveland, OH (Metropolitan Area)"	26	1576820	205.634685	20.17765546	1019.120806	1301480	247.472801	25.10928261	985.582921
Table 2	2015	2	30666	"Bellingham, WA"	5	131550	116.4603421	11.72967198	992.8695553	188940	119.1375198	12.14194655	981.2060972
Table 2	2015	2	30693	"Nashville, TN"	35	1782290	228.4200674	24.95310733	915.3972866	1698620	223.3635145	24.60870874	907.660442
Table 2	2015	2	30713	"Boise, ID"	11	357870	175.1399223	27.31458454	641.1956297	334640	177.2141645	28.19360925	628.561469
Table 2	2015	2	30721	"Boston, MA (Metropolitan Area)"	53	6817920	231.7718716	18.8032862	1232.613646	6656800	225.8814136	18.36974046	1229.638568
Table 2	2015	2	30792	"Buffalo, NY"	16	765240	186.7266884	19.01230901	982.1357744	807790	190.5531574	19.33809592	985.3770411
Table 2	2015	2	30852	"Washington, DC (Metropolitan Area)"	75	9391610	221.162323	20.31127504	1088.864793	8834550	234.6287848	21.82078001	1075.253885
Table 2	2015	2	30977	"Chicago, IL"	69	9625360	210.1480909	21.65021017	970.651505	8864710	228.165003	23.74752208	960.7949927
Table 2	2015	2	30994	"Charleston, SC"	10	428100	208.5363607	26.27342356	793.7159776	394560	210.9256514	26.19955215	805.0734996
Table 2	2015	2	31057	"Charlotte, NC"	41	2051140	255.0087512	27.78650044	917.7433183	2022890	246.3847901	27.04207262	911.1165165
Table 2	2015	2	31066	"Columbus, OH"	23	1091820	234.5015973	24.64390221	951.5603305	1045290	236.9399554	24.94300063	949.9256283
Table 2	2015	2	31123	"St. Louis, MO"	33	1856300	219.628538	23.37804607	939.4649033	1790850	222.3057375	23.98137726	926.9932043
Table 2	2015	2	31135	"Myrtle Beach, SC"	5	169140	134.6380395	20.44247869	658.6189547	179480	126.9952585	19.31238724	657.5844662
Table 2	2015	2	31136	"Jacksonville, FL"	18	798620	215.7729859	21.8511463	987.4675816	783650	220.0146851	22.64200243	971.7103681
Table 2	2015	2	31267	"Dayton, OH"	8	192480	221.967872	27.4419808	808.8624273	229510	206.6690384	26.02794061	794.0276241
Table 2	2015	2	31295	"Detroit, MI"	34	2880550	231.8685925	21.80290047	1063.475902	2769440	237.5852804	22.50987124	1055.471521
Table 2	2015	2	31423	"Des Moines, IA"	8	201290	226.7678772	22.71875234	998.152864	207520	215.180214	21.76734519	988.5459715
Table 2	2015	2	31453	"Houston, TX"	58	4385420	236.0209882	22.91348374	1030.052832	4282040	253.6643551	25.01672004	1013.979269
Table 2	2015	2	31454	"Orlando, FL"	56	5936150	187.7128998	16.8268988	1115.552557	5592530	197.508732	17.81127976	1108.896916
Table 2	2015	2	31650	"Minneapolis/St. Paul, MN"	39	3192160	241.7627525	22.72323186	1063.945278	3095300	242.3330869	22.92242916	1057.187636
Table 2	2015	2	31703	"New York City, NY (Metropolitan Area)"	73	14322020	255.0772791	19.86331033	1284.162986	13674200	261.9554361	20.55805288	1274.22299
Table 2	2015	2	31714	"Fort Myers, FL"	22	1270990	199.173202	17.61437916	1130.742107	1252440	204.9643688	18.14248084	1129.748299
Table 2	2015	2	31871	"Greenville/Spartanburg, SC"	5	132800	208.7072816	31.87762958	654.7139307	130680	202.5629094	30.97961339	653.8587389
Table 2	2015	2	31884	"Spokane, WA"	9	351610	167.7822388	24.71738639	678.8025085	339360	173.0199081	25.830998	669.8150342
Table 2	2015	2	31986	"Grand Rapids, MI"	10	242060	229.1635421	20.20657459	1134.103859	227030	236.2222085	21.23442673	1112.449192
Table 2	2015	2	31995	"Greensboro/High Point, NC"	7	142350	251.2722374	45.71577506	549.6401124	145610	237.6496875	43.99894441	540.1258842
Table 2	2015	2	32211	"Las Vegas, NV"	65	6408430	193.7532739	15.38572829	1259.305184	6118830	204.4054046	16.70757902	1223.429226
Table 2	2015	2	32337	"Indianapolis, IN"	24	1253870	231.298582	21.98629037	1052.012768	1206590	235.6012125	22.67450824	1039.05765
Table 2	2015	2	32457	"San Francisco, CA (Metropolitan Area)"	52	9836230	239.1557199	17.69991922	1351.168426	9486430	233.4272303	17.48982736	1334.645709
Table 2	2015	2	32467	"Miami, FL (Metropolitan Area)"	49	6035530	196.7542363	15.93020679	1235.101583	5547840	213.7518081	17.20275783	1242.543842
Table 2	2015	2	32575	"Los Angeles, CA (Metropolitan Area)"	68	12179590	232.9081591	17.28365856	1347.562834	11770700	232.6224353	17.44226319	1333.671168
Table 2	2015	2	32600	"Little Rock, AR"	9	190990	239.2062621	27.99805241	854.3675062	218090	212.2765372	26.19974376	810.223715
Table 2	2015	2	33044	"Louisville, KY"	16	449100	251.0913226	26.60377198	943.8185037	473750	236.8727937	26.71775011	886.574628
Table 2	2015	2	33105	"Cincinnati, OH"	22	769430	252.5080787	25.35921379	995.7251862	634290	290.7220073	29.4080536	988.5795614
Table 2	2015	2	33192	"Sacramento, CA"	23	1541840	202.4808657	21.0056677	963.934442	1485690	204.1482914	21.49554874	949.7235628
Table 2	2015	2	33195	"Tampa, FL (Metropolitan Area)"	49	3376850	187.5737489	17.46532868	1073.977778	3132460	198.3713771	18.61740559	1065.515687
Table 2	2015	2	33198	"Kansas City, MO"	34	1759470	215.2887387	22.72096884	947.5332685	1704660	216.7413255	22.9850113	942.9681051
Table 2	2015	2	33214	"San Antonio, TX"	28	1200970	230.3341158	21.30571824	1081.090593	1193660	229.9907402	21.5815387	1065.682774
Table 2	2015	2	33244	"Memphis, TN"	16	525990	229.5572787	24.13830954	951.008099	457270	254.4146784	27.07631044	939.6209242
Table 2	2015	2	33316	"Omaha, NE"	17	588530	225.64743	21.9923926	1026.024927	594850	216.2593427	21.6723565	997.8579978
Table 2	2015	2	33342	"Milwaukee, WI"	22	1093920	200.0048678	18.37277346	1088.593773	1095230	201.216119	18.84973586	1067.474476
Table 2	2015	2	33495	"New Orleans, LA"	28	1803250	217.1212045	21.18200565	1025.026657	1657180	225.1560766	22.30905805	1009.258554
Table 2	2015	2	33570	"San Diego, CA"	43	3344450	220.5024339	16.94287004	1301.446764	3134880	219.9785912	17.26110539	1274.417751
Table 2	2015	2	33667	"Norfolk, VA (Metropolitan Area)"	16	394140	272.5587228	21.07374771	1293.356675	426130	249.6678666	20.30412086	1229.641354
Table 2	2015	2	33851	"Oklahoma City, OK"	13	408480	236.5877987	25.14538764	940.8795045	431450	230.5701333	24.83162781	928.5341059
Table 2	2015	2	34027	"West Palm Beach/Palm Beach, FL"	11	957670	201.9621665	19.12932479	1055.772583	896610	210.9100032	19.87265566	1061.307592
Table 2	2015	2	34057	"Portland, OR"	36	2373290	207.5407573	16.57706261	1251.975469	2245390	197.1860051	16.16043531	1220.177559
Table 2	2015	2	34100	"Philadelphia, PA"	43	3400380	236.4178174	19.91518624	1187.123307	3214050	249.8556952	20.54600228	1216.07937
Table 2	2015	2	34262	"Palm Springs, CA"	5	139490	199.0664205	20.22177645	984.4160872	142720	198.1220291	19.9800962	991.5969731
Table 2	2015	2	34321	"Portland, ME"	4	128420	203.2814126	33.31467034	610.1858745	125690	198.3161986	32.32004103	613.6013207
Table 2	2015	2	34492	"Raleigh/Durham, NC"	29	1611560	225.0310898	23.92799908	940.4509295	1562270	218.2550359	23.73331106	919.6147785
Table 2	2015	2	34524	"Richmond, VA"	13	435590	238.094302	24.63117117	966.6381689	421910	236.0114788	24.28913766	971.6750018
Table 2	2015	2	34570	"Reno, NV"	11	417790	182.8423251	22.79493554	802.1181934	427630	181.8182985	22.82771608	796.4804621
Table 2	2015	2	34576	"Rochester, NY"	9	233780	211.897442	25.8130627	820.8922919	249140	204.6192823	24.35281016	840.2286265
Table 2	2015	2	34614	"Salt Lake City, UT"	30	1868280	215.2533651	20.29650373	1060.544062	1672050	226.9099531	21.74799444	1043.36036
Table 2	2015	2	34653	"Tulsa, OK"	10	280890	234.6544448	29.83470666	786.5150059	296570	227.4072799	30.04805082	756.8120848
Table 2	2015	2	34685	"Savannah, GA"	5	183190	207.7689066	27.48690495	755.883236	190360	196.4679765	26.24545446	748.5790607
Table 2	2015	2	34986	"Sarasota/Bradenton, FL"	5	126470	211.7656677	21.67083908	977.1918241	130800	204.8883333	20.83154409	983.5484709
Table 2	2015	2	35096	"Syracuse, NY"	7	163700	203.2726206	26.3509093	771.4064753	169590	195.4576036	25.59310326	763.7120113