tbl	Year	quarter	citymarketid	city	markets	cur_passengers	cur_fare	cur_yield	distance	ly_passengers	ly_fare	ly_yield	ly_distance
Table 2	2015	3	30140	"Albuquerque, NM"	16	655930	215.6324211	21.38250933	1008.452365	659890	215.4375214	21.69810763	992.8862235
Table 2	2015	3	30158	"Atlantic City, NJ"	6	156500	95.81601917	11.13676629	860.3576358	175460	100.0266101	11.55719762	865.491907
Table 2	2015	3	30194	"Dallas/Fort Worth, TX"	70	6902400	192.0451597	19.62302781	978.6724125	6013350	226.1715939	23.54879207	960.4381967
Table 2	2015	3	30198	"Pittsburgh, PA"	22	1156170	228.7007222	22.01738396	1038.727955	1166340	234.0497831	22.73661607	1029.395854
Table 2	2015	3	30257	"Albany, NY"	11	288330	255.1622655	20.08182208	1270.613117	283930	248.8740746	19.95299965	1247.301553
Table 2	2015	3	30325	"Denver, CO"	65	6742240	192.3770455	18.35403901	1048.145563	6306000	195.3963172	18.87710554	1035.096809
Table 2	2015	3	30397	"Atlanta, GA (Metropolitan Area)"	60	5998770	207.4734724	22.87138451	907.1312336	5343630	234.7578347	25.92136575	905.6538028
Table 2	2015	3	30423	"Austin, TX"	31	1911740	206.1794653	17.91450498	1150.907969	1660190	225.1806715	19.42187904	1159.417537
Table 2	2015	3	30436	"Tucson, AZ"	11	293940	218.6571443	22.25004817	982.7266109	331870	199.9274143	20.9621461	953.7545123
Table 2	2015	3	30466	"Phoenix, AZ"	48	4032150	200.1657319	17.48631971	1144.699029	3732630	210.3603009	18.40970807	1142.659623
Table 2	2015	3	30529	"Hartford, CT"	21	865260	229.8092516	18.20013123	1262.679091	914830	223.9364188	17.64092293	1269.414416
Table 2	2015	3	30559	"Seattle, WA"	52	5319930	218.0856731	15.36570613	1419.30134	5014850	218.9893578	15.55819699	1407.549717
Table 2	2015	3	30599	"Birmingham, AL"	8	249940	224.3980755	29.19951366	768.4993598	246210	220.8638236	29.37949744	751.7617481
Table 2	2015	3	30615	"El Paso, TX"	11	321340	230.1617072	27.0397136	851.1987614	334130	212.1162302	24.89486497	852.048125
Table 2	2015	3	30647	"Cleveland, OH (Metropolitan Area)"	26	1550320	199.0808343	19.11179153	1041.664953	1306040	240.5413065	23.84305543	1008.852692
Table 2	2015	3	30693	"Nashville, TN"	34	1705980	224.6357613	24.82354858	904.930093	1587490	223.3585264	25.09454487	890.0680508
Table 2	2015	3	30713	"Boise, ID"	12	396090	182.1720038	26.51444023	687.0671312	369370	181.0598154	27.31273612	662.9135014
Table 2	2015	3	30721	"Boston, MA (Metropolitan Area)"	53	6785190	222.7797188	17.69300052	1259.140407	6569580	225.6236898	18.0467711	1250.216388
Table 2	2015	3	30792	"Buffalo, NY"	17	781440	196.9095874	20.43163777	963.748426	816660	197.0267296	20.44542008	963.6717116
Table 2	2015	3	30852	"Washington, DC (Metropolitan Area)"	74	8918250	213.6105345	19.31067492	1106.178501	8357320	228.6016815	21.06802706	1085.064496
Table 2	2015	3	30977	"Chicago, IL"	71	9996660	195.5063789	19.93102669	980.9147415	8754930	227.8695741	23.49390272	969.9094133
Table 2	2015	3	30994	"Charleston, SC"	10	420220	192.0591642	24.29396263	790.5633478	398460	191.7878081	24.50546558	782.6327862
Table 2	2015	3	31057	"Charlotte, NC"	40	2006050	249.0948247	26.84086958	928.0430498	1935260	246.5102617	27.09554728	909.7814454
Table 2	2015	3	31066	"Columbus, OH"	23	1024640	227.6510775	23.8810778	953.2696947	993230	237.709605	24.70136094	962.3340415
Table 2	2015	3	31123	"St. Louis, MO"	33	1821400	217.0003673	22.87822195	948.5018887	1769480	220.4775776	23.60741132	933.9337319
Table 2	2015	3	31135	"Myrtle Beach, SC"	8	236340	125.9973386	20.57271226	612.4488449	244230	122.5225361	20.13138757	608.6144618
Table 2	2015	3	31136	"Jacksonville, FL"	18	753140	214.2781648	21.62359363	990.9461322	722900	216.8313335	22.21335498	976.1305021
Table 2	2015	3	31267	"Dayton, OH"	9	195580	217.0304939	25.56631456	848.8923714	213570	220.3675704	26.43293376	833.68563
Table 2	2015	3	31295	"Detroit, MI"	34	2800360	225.4089649	21.22175099	1062.160069	2618760	237.4904333	22.1715041	1071.151656
Table 2	2015	3	31423	"Des Moines, IA"	9	209660	226.7508919	21.6418247	1047.743871	214220	221.4208431	21.3437146	1037.405378
Table 2	2015	3	31453	"Houston, TX"	54	4385570	229.6797089	21.88468286	1049.499828	4149850	250.9918281	24.33318447	1031.479576
Table 2	2015	3	31454	"Orlando, FL"	54	5255370	178.9833195	15.96708688	1120.951623	5012050	186.9604551	16.82232099	1111.383234
Table 2	2015	3	31650	"Minneapolis/St. Paul, MN"	40	3289500	236.9971552	22.61579863	1047.927421	3138080	245.8770251	23.44370295	1048.797733
Table 2	2015	3	31703	"New York City, NY (Metropolitan Area)"	74	13918580	249.8022542	19.33020653	1292.289629	13149050	261.9241769	20.36981126	1285.844888
Table 2	2015	3	31714	"Fort Myers, FL"	19	807800	177.8723397	16.1970551	1098.177036	783210	184.9440406	16.90051606	1094.310019
Table 2	2015	3	31871	"Greenville/Spartanburg, SC"	5	131600	206.2175076	31.44352852	655.8344985	122320	209.6980952	31.9527177	656.2762426
Table 2	2015	3	31884	"Spokane, WA"	12	423440	181.9211624	22.54594978	806.8906575	404290	186.2467486	23.33436301	798.165129
Table 2	2015	3	31986	"Grand Rapids, MI"	12	271360	236.9392136	20.36039833	1163.725825	249910	247.3312953	21.3813817	1156.760114
Table 2	2015	3	31995	"Greensboro/High Point, NC"	6	118590	229.994755	35.0615642	655.9740282	118960	238.7877522	37.94921071	629.2298252
Table 2	2015	3	32211	"Las Vegas, NV"	64	6149740	185.8138812	14.96507171	1241.650457	5805800	196.922708	16.33107899	1205.81566
Table 2	2015	3	32337	"Indianapolis, IN"	24	1180160	221.3932924	21.10178892	1049.168359	1132760	235.8940729	22.47993434	1049.353923
Table 2	2015	3	32457	"San Francisco, CA (Metropolitan Area)"	58	10104990	236.0357674	17.58077056	1342.579192	9706000	233.9265585	17.4047156	1344.041258
Table 2	2015	3	32467	"Miami, FL (Metropolitan Area)"	48	5460420	183.1729004	14.8347015	1234.759597	4831020	206.6427742	16.5644937	1247.504318
Table 2	2015	3	32575	"Los Angeles, CA (Metropolitan Area)"	70	12512230	223.0264411	16.61676766	1342.177044	11735540	234.553994	17.63532396	1330.023733
Table 2	2015	3	32600	"Little Rock, AR"	9	188150	235.6829232	27.39901713	860.18751	197560	225.2211531	26.97614339	834.8901093
Table 2	2015	3	33044	"Louisville, KY"	16	409880	237.415607	24.99836208	949.7246511	432120	234.7708738	25.74143015	912.0350828
Table 2	2015	3	33105	"Cincinnati, OH"	20	713250	255.1403281	25.28693258	1008.980932	560060	303.8545692	30.22078316	1005.449023
Table 2	2015	3	33192	"Sacramento, CA"	22	1526810	200.2475606	20.74461334	965.2990745	1458500	198.5944923	21.23433135	935.2519232
Table 2	2015	3	33195	"Tampa, FL (Metropolitan Area)"	44	2873440	180.6842012	16.77806308	1076.90739	2646430	194.235351	18.00287252	1078.913106
Table 2	2015	3	33198	"Kansas City, MO"	33	1720470	209.0651229	22.09240105	946.321418	1670010	212.4136903	22.48532218	944.6771037
Table 2	2015	3	33214	"San Antonio, TX"	27	1101960	229.3081863	21.10904975	1086.302742	1122330	226.9425543	21.06419199	1077.385519
Table 2	2015	3	33244	"Memphis, TN"	16	513010	220.4529015	23.42112523	941.2566617	440420	247.8710912	26.58268752	932.4530902
Table 2	2015	3	33316	"Omaha, NE"	17	546180	219.8342982	21.56398857	1019.451005	565980	213.223439	21.12599954	1009.293968
Table 2	2015	3	33342	"Milwaukee, WI"	23	1064900	202.5992863	18.56766511	1091.140351	1077800	204.6484635	19.02691932	1075.573297
Table 2	2015	3	33495	"New Orleans, LA"	26	1547570	195.1145312	19.74591592	988.1260105	1447800	210.5692312	21.52544636	978.2339826
Table 2	2015	3	33570	"San Diego, CA"	43	3405070	213.3763232	16.47354123	1295.266879	3306770	215.4865497	17.09464072	1260.550329
Table 2	2015	3	33667	"Norfolk, VA (Metropolitan Area)"	15	383250	269.8089863	20.14714953	1339.191859	384430	266.9030383	20.30418882	1314.522046
Table 2	2015	3	33851	"Oklahoma City, OK"	12	389370	231.8644503	24.27663992	955.0928423	401810	231.2319654	25.37540123	911.2445683
Table 2	2015	3	34027	"West Palm Beach/Palm Beach, FL"	9	723930	185.4488956	17.48813222	1060.427113	692080	197.1337316	18.39792722	1071.499682
Table 2	2015	3	34057	"Portland, OR"	37	2714040	204.6111679	16.09403592	1271.347777	2528650	206.697609	16.36739629	1262.861883
Table 2	2015	3	34100	"Philadelphia, PA"	45	3469460	218.7531872	18.21607519	1200.879909	3106550	247.5813913	20.00535087	1237.575851
Table 2	2015	3	34321	"Portland, ME"	5	181710	232.5494854	44.99717387	516.8090914	168380	234.7666647	46.65505975	503.1965792
Table 2	2015	3	34492	"Raleigh/Durham, NC"	29	1593580	212.5823473	22.20018336	957.5702318	1487400	218.8082661	23.45813664	932.7606427
Table 2	2015	3	34524	"Richmond, VA"	11	391220	231.356651	23.85856523	969.7006032	369290	233.949541	23.64418128	989.4592597
Table 2	2015	3	34570	"Reno, NV"	12	498770	195.7295667	22.93516592	853.4037532	482710	192.3398252	24.1971226	794.8871786
Table 2	2015	3	34576	"Rochester, NY"	9	235270	213.0086709	24.96545953	853.2134994	236640	209.1020368	24.64672487	848.3968475
Table 2	2015	3	34614	"Salt Lake City, UT"	29	1970050	219.5459262	20.81227874	1054.886536	1801980	222.6789298	21.6141306	1030.246989
Table 2	2015	3	34653	"Tulsa, OK"	8	244450	225.2060217	29.32535338	767.9567192	254100	226.6899843	31.12669297	728.2816214
Table 2	2015	3	34685	"Savannah, GA"	5	174860	193.2319112	25.50408381	757.6508635	170320	185.0173673	24.54764691	753.7071395
Table 2	2015	3	35096	"Syracuse, NY"	7	150660	203.1538564	26.56869683	764.6361343	155800	200.3446919	27.15908043	737.6711168
Table 2	2015	3	35356	"Trenton, NJ"	7	159000	94.32083019	14.1121067	668.3681761	119170	114.7300411	16.87772163	679.7720903