tbl	Year	quarter	citymarketid	city	markets	cur_passengers	cur_fare	cur_yield	distance	ly_passengers	ly_fare	ly_yield	ly_distance
Table 2	2014	3	30140	"Albuquerque, NM"	18	690230	216.1335004	21.88155579	987.7428393	693130	204.2326562	20.84146362	979.9343269
Table 2	2014	3	30158	"Atlantic City, NJ"	5	162180	101.4254902	11.29203238	898.2040326	150760	103.7486203	11.63488556	891.7029716
Table 2	2014	3	30194	"Dallas/Fort Worth, TX"	71	6025270	226.1726762	23.57435583	959.4012999	5585970	221.9728386	23.48354266	945.2272246
Table 2	2014	3	30198	"Pittsburgh, PA"	23	1181070	233.6758067	22.71709903	1028.63401	1117860	228.3890934	22.12782019	1032.135527
Table 2	2014	3	30257	"Albany, NY"	11	283930	248.8740746	19.95299965	1247.301553	269620	246.9433462	20.32218858	1215.141495
Table 2	2014	3	30325	"Denver, CO"	67	6335290	195.5565368	18.88198262	1035.677983	5867210	193.6793825	18.76207253	1032.292047
Table 2	2014	3	30397	"Atlanta, GA (Metropolitan Area)"	57	5301910	234.1417634	25.75698382	909.0418547	4964360	227.0610195	25.26269322	898.7997345
Table 2	2014	3	30423	"Austin, TX"	31	1660190	225.1806715	19.42187904	1159.417537	1519660	220.3728038	19.01625033	1158.865707
Table 2	2014	3	30436	"Tucson, AZ"	11	331870	199.9274143	20.9621461	953.7545123	338720	192.8534424	20.30812249	949.6369863
Table 2	2014	3	30466	"Phoenix, AZ"	47	3723590	209.8985377	18.44122662	1138.202691	3522570	210.922598	18.67031904	1129.721445
Table 2	2014	3	30529	"Hartford, CT"	21	914830	223.9364188	17.64092293	1269.414416	776920	230.25104	17.84927741	1289.974013
Table 2	2014	3	30559	"Seattle, WA"	49	4972260	219.350427	15.49709383	1415.42943	4297130	226.0670613	15.55114666	1453.700272
Table 2	2014	3	30599	"Birmingham, AL"	9	260610	224.1133878	27.82128945	805.546372	256130	221.1519072	27.63964627	800.1256784
Table 2	2014	3	30615	"El Paso, TX"	10	318710	209.1584387	24.79160361	843.6664366	298090	214.6025328	26.58603205	807.2003086
Table 2	2014	3	30647	"Cleveland, OH (Metropolitan Area)"	27	1318730	240.8357147	24.02444775	1002.460981	1256450	245.6788937	24.3377637	1009.455498
Table 2	2014	3	30666	"Bellingham, WA"	3	143750	108.3607583	11.59125215	934.8494609	143610	115.321064	12.27200099	939.708725
Table 2	2014	3	30693	"Nashville, TN"	34	1585720	222.1209022	24.82415377	894.7773377	1454450	217.9951879	24.08110886	905.2539448
Table 2	2014	3	30713	"Boise, ID"	10	340230	166.866217	29.8428272	559.1501631	309900	177.0492901	31.68534627	558.7734108
Table 2	2014	3	30721	"Boston, MA (Metropolitan Area)"	54	6578460	225.5969542	18.04302679	1250.327657	6318720	209.2673261	17.12623209	1221.911072
Table 2	2014	3	30792	"Buffalo, NY"	18	832020	196.4584974	20.50585343	958.0605755	896350	183.1430669	19.35388074	946.2860155
Table 2	2014	3	30852	"Washington, DC (Metropolitan Area)"	77	8399120	228.3085008	21.13479382	1080.249482	7962010	219.8334716	20.81089229	1056.33852
Table 2	2014	3	30977	"Chicago, IL"	70	8736060	227.6932656	23.50367879	968.7558602	8247870	220.3995674	23.21369433	949.4377082
Table 2	2014	3	30994	"Charleston, SC"	10	398460	191.7878081	24.50546558	782.6327862	351270	196.4489253	24.45863658	803.1883736
Table 2	2014	3	31057	"Charlotte, NC"	38	1908870	247.1526411	26.9576969	916.8166035	1829590	235.7362147	25.03574778	941.5984565
Table 2	2014	3	31066	"Columbus, OH"	22	978010	236.3616742	25.01493917	944.8820666	928760	232.2305999	24.68315035	940.8466773
Table 2	2014	3	31123	"St. Louis, MO"	34	1782330	221.1409486	23.50531564	940.8125039	1736350	212.0653987	22.71377613	933.6421977
Table 2	2014	3	31135	"Myrtle Beach, SC"	7	230950	124.7984239	20.23271465	616.8150249	222080	119.5091363	19.18683252	622.8705872
Table 2	2014	3	31136	"Jacksonville, FL"	18	722900	216.8313335	22.21335498	976.1305021	693710	214.3625074	22.16715195	967.0277349
Table 2	2014	3	31267	"Dayton, OH"	9	213570	220.3675704	26.43293376	833.68563	245160	199.2575053	23.22416779	857.974792
Table 2	2014	3	31295	"Detroit, MI"	35	2632040	239.1792894	22.34759337	1070.268666	2499200	235.08889	22.03130322	1067.067562
Table 2	2014	3	31423	"Des Moines, IA"	9	214220	221.4208431	21.3437146	1037.405378	201760	215.0083515	20.12236162	1068.50456
Table 2	2014	3	31453	"Houston, TX"	57	4192940	250.7222464	24.46610558	1024.773827	3870910	255.5391898	25.2877203	1010.526796
Table 2	2014	3	31454	"Orlando, FL"	55	5027890	187.1774613	16.83665845	1111.725714	4797840	181.0200296	16.42440027	1102.14088
Table 2	2014	3	31650	"Minneapolis/St. Paul, MN"	42	3167510	246.182036	23.50422903	1047.394644	2915700	246.0015698	23.90865468	1028.922677
Table 2	2014	3	31703	"New York City, NY (Metropolitan Area)"	74	13149050	261.9241769	20.36981126	1285.844888	12630880	243.8599199	19.65945406	1240.42061
Table 2	2014	3	31714	"Fort Myers, FL"	19	787390	184.6334929	16.78645631	1099.895592	743380	183.6799255	16.69088506	1100.480441
Table 2	2014	3	31871	"Greenville/Spartanburg, SC"	6	135900	222.12195	34.26785631	648.1933039	132800	212.5769729	33.04140396	643.3654367
Table 2	2014	3	31884	"Spokane, WA"	12	404380	187.3740838	23.65978151	791.9518769	386550	184.6825663	23.49363088	786.0963135
Table 2	2014	3	31986	"Grand Rapids, MI"	12	249910	247.3312953	21.3813817	1156.760114	240110	236.9736662	20.74757037	1142.175503
Table 2	2014	3	31995	"Greensboro/High Point, NC"	5	107500	242.7606791	39.55045876	613.799907	100530	236.2282304	37.33280429	632.7631553
Table 2	2014	3	32211	"Las Vegas, NV"	66	5835240	196.9395548	16.31855402	1206.844397	5587790	191.9478407	15.60610002	1229.953932
Table 2	2014	3	32337	"Indianapolis, IN"	24	1132760	235.8940729	22.47993434	1049.353923	1064520	229.4709183	21.83121882	1051.113638
Table 2	2014	3	32457	"San Francisco, CA (Metropolitan Area)"	58	9704180	234.0359468	17.39639509	1345.312897	8139730	236.1583631	17.47352527	1351.520998
Table 2	2014	3	32467	"Miami, FL (Metropolitan Area)"	45	4795820	206.6732849	16.53582267	1249.851846	4578290	192.3061628	15.67447945	1226.874318
Table 2	2014	3	32575	"Los Angeles, CA (Metropolitan Area)"	71	11751250	234.7381611	17.62738129	1331.667803	10421960	228.5097308	17.25558905	1324.265026
Table 2	2014	3	32600	"Little Rock, AR"	8	182850	219.3277222	25.57067274	857.7315286	197120	205.3156605	24.31063094	844.5509334
Table 2	2014	3	33044	"Louisville, KY"	15	419370	233.1512817	26.24453578	888.3802847	405100	221.9814737	25.84805626	858.7936806
Table 2	2014	3	33105	"Cincinnati, OH"	17	523550	305.9611919	30.32888093	1008.811346	513760	289.64513	29.44427659	983.7060495
Table 2	2014	3	33158	"Midland/Odessa, TX"	2	115080	228.3207855	58.62528702	389.4578554	103460	206.8814614	52.90778617	391.0227141
Table 2	2014	3	33192	"Sacramento, CA"	22	1457800	199.3847407	21.11388175	944.3301002	1353400	205.0466743	21.80600104	940.3222255
Table 2	2014	3	33195	"Tampa, FL (Metropolitan Area)"	46	2671700	194.2237325	18.01597485	1078.063963	2464710	194.3563202	18.00043403	1079.731299
Table 2	2014	3	33198	"Kansas City, MO"	35	1698730	212.3058726	22.40349481	947.6462239	1611380	212.3015422	22.48557988	944.167521
Table 2	2014	3	33214	"San Antonio, TX"	27	1122330	226.9425543	21.06419199	1077.385519	1055020	225.1584586	21.03166799	1070.568719
Table 2	2014	3	33244	"Memphis, TN"	17	454690	250.2381711	26.99327287	927.0390156	412650	248.7049291	26.85357386	926.1520659
Table 2	2014	3	33316	"Omaha, NE"	16	551180	212.4640299	21.4359975	991.1553213	549110	199.4558959	20.34664879	980.2886853
Table 2	2014	3	33342	"Milwaukee, WI"	23	1076450	204.3134841	19.36192838	1055.233137	1055460	198.5297756	18.69290221	1062.059671
Table 2	2014	3	33485	"Madison, WI"	5	104660	264.3512517	26.86285179	984.0773935	113840	235.2811402	23.39559515	1005.664266
Table 2	2014	3	33495	"New Orleans, LA"	26	1447800	210.5692312	21.52544636	978.2339826	1288960	203.1391059	21.07226274	964.0118312
Table 2	2014	3	33570	"San Diego, CA"	42	3291550	214.9832839	17.10637304	1256.743808	2976000	218.0636526	16.99444783	1283.146442
Table 2	2014	3	33667	"Norfolk, VA (Metropolitan Area)"	19	438760	261.2172099	20.99793756	1244.013652	480300	234.9308911	20.0830739	1169.795482
Table 2	2014	3	33851	"Oklahoma City, OK"	13	417650	232.165337	25.15448354	922.9580749	396190	226.0378051	24.21552448	933.4417073
Table 2	2014	3	34027	"West Palm Beach/Palm Beach, FL"	9	692080	197.1337316	18.39792722	1071.499682	689980	175.1319806	16.78872765	1043.152193
Table 2	2014	3	34057	"Portland, OR"	35	2499810	206.0212788	16.39817076	1256.367444	2242690	206.7735875	16.28882017	1269.420285
Table 2	2014	3	34100	"Philadelphia, PA"	45	3106550	247.5813913	20.00535087	1237.575851	3007200	233.8574162	19.27718962	1213.130237
Table 2	2014	3	34321	"Portland, ME"	5	168380	234.7666647	46.65505975	503.1965792	169650	210.6518067	41.95917088	502.0399646
Table 2	2014	3	34492	"Raleigh/Durham, NC"	29	1489420	219.3298096	23.4587767	934.9584268	1397960	214.2612249	22.97340223	932.6490815
Table 2	2014	3	34524	"Richmond, VA"	11	369290	233.949541	23.64418128	989.4592597	338380	227.9383031	23.58599579	966.413736
Table 2	2014	3	34570	"Reno, NV"	13	495690	193.1795074	24.52079886	787.8189796	489890	190.4529792	24.50318621	777.2580171
Table 2	2014	3	34576	"Rochester, NY"	10	250960	212.2189512	23.78810947	892.1219716	262240	197.6094341	22.72231508	869.6712172
Table 2	2014	3	34614	"Salt Lake City, UT"	32	1844420	222.8871315	21.83905364	1020.589698	1683780	230.6733582	22.34233502	1032.449643
Table 2	2014	3	34653	"Tulsa, OK"	9	268970	227.1661747	30.49552818	744.9163475	263820	224.1746797	31.13788025	719.9420059
Table 2	2014	3	34685	"Savannah, GA"	5	170320	185.0173673	24.54764691	753.7071395	108310	235.5665959	31.19234832	755.2063521
Table 2	2014	3	35096	"Syracuse, NY"	7	159780	214.8954062	24.58206713	874.1958318	156660	216.0315843	24.92384471	866.7666922