tbl	Year	quarter	citymarketid	city	markets	cur_passengers	cur_fare	cur_yield	distance	ly_passengers	ly_fare	ly_yield	ly_distance
Table 2	2014	2	30140	"Albuquerque, NM"	17	676110	211.7253095	21.7784009	972.1802369	693570	187.7239082	19.60792411	957.3879781
Table 2	2014	2	30158	"Atlantic City, NJ"	4	148320	112.6091019	12.10852841	929.998247	129470	103.7163667	11.19220409	926.6840195
Table 2	2014	2	30194	"Dallas/Fort Worth, TX"	72	6095690	231.5293921	24.46165711	946.4992134	5863400	220.6768639	23.48734796	939.5563274
Table 2	2014	2	30198	"Pittsburgh, PA"	24	1228250	235.0466412	23.31854765	1007.981478	1241090	219.2279214	21.85522126	1003.09175
Table 2	2014	2	30257	"Albany, NY"	10	270960	232.2854776	19.7257253	1177.576358	273080	221.0462282	18.9047105	1169.265343
Table 2	2014	2	30325	"Denver, CO"	64	5826490	193.3136726	18.82883328	1026.689597	5605510	184.2121001	17.9514526	1026.168211
Table 2	2014	2	30397	"Atlanta, GA (Metropolitan Area)"	61	5554470	235.2207464	26.48986882	887.9649345	5682130	208.5112055	23.97830474	869.5827656
Table 2	2014	2	30423	"Austin, TX"	31	1700070	228.9086426	19.88942134	1150.906498	1621040	217.8597919	18.95985107	1149.058561
Table 2	2014	2	30436	"Tucson, AZ"	11	377740	200.9425716	20.4238278	983.8634246	382410	188.0364086	19.47211947	965.6699616
Table 2	2014	2	30466	"Phoenix, AZ"	55	4467150	212.7024309	18.497705	1149.885518	4359570	199.6583512	17.517093	1139.79158
Table 2	2014	2	30529	"Hartford, CT"	20	948440	223.6648823	18.54243562	1206.232487	812050	226.8354596	18.89207408	1200.69114
Table 2	2014	2	30559	"Seattle, WA"	46	4361590	214.566548	15.45671908	1388.176539	4067890	213.8789675	15.21046636	1406.130242
Table 2	2014	2	30599	"Birmingham, AL"	10	293740	226.0239395	28.08325387	804.8352965	296490	205.8254275	25.859449	795.9389524
Table 2	2014	2	30615	"El Paso, TX"	10	330070	206.3861787	25.27420135	816.5883297	318270	194.1009175	24.66599657	786.9169887
Table 2	2014	2	30647	"Cleveland, OH (Metropolitan Area)"	26	1304370	247.5165927	25.35088068	976.3628955	1348310	230.9608265	23.61054621	978.2104338
Table 2	2014	2	30666	"Bellingham, WA"	5	188940	119.1375198	12.14194655	981.2060972	188610	122.6449446	12.44572791	985.4380998
Table 2	2014	2	30693	"Nashville, TN"	34	1678050	222.0683484	25.11960163	884.044069	1600440	206.8699058	23.50041393	880.2819662
Table 2	2014	2	30713	"Boise, ID"	9	307900	168.5825398	29.38336864	573.7345567	287610	169.9707555	29.68639967	572.5542923
Table 2	2014	2	30721	"Boston, MA (Metropolitan Area)"	52	6642050	225.643733	18.34520155	1229.987757	6528610	214.4599815	17.50768803	1224.94747
Table 2	2014	2	30792	"Buffalo, NY"	17	821340	191.6054898	19.69861147	972.6852582	896230	174.7613347	18.28157299	955.9425482
Table 2	2014	2	30852	"Washington, DC (Metropolitan Area)"	76	8858960	234.3600406	21.89618454	1070.323645	8825830	213.6244992	20.27543476	1053.612422
Table 2	2014	2	30977	"Chicago, IL"	71	8898590	228.0056845	23.7592593	959.6498007	8905600	207.5140053	21.86677359	948.9923352
Table 2	2014	2	30994	"Charleston, SC"	10	394480	210.9397663	26.1938662	805.3021446	371760	200.0327039	24.85763416	804.7133635
Table 2	2014	2	31057	"Charlotte, NC"	40	2013620	246.4390545	27.33114521	901.6784796	1976260	225.2566838	25.05047403	899.2112627
Table 2	2014	2	31066	"Columbus, OH"	22	1030670	235.9667944	25.27282245	933.6780444	1010260	220.6358363	24.0479452	917.4831133
Table 2	2014	2	31123	"St. Louis, MO"	33	1790470	222.2789033	23.99626034	926.3064335	1872240	199.6409355	21.7592665	917.4984617
Table 2	2014	2	31135	"Myrtle Beach, SC"	5	179480	126.9952585	19.31238724	657.5844662	159070	129.4452191	19.50564101	663.6296599
Table 2	2014	2	31136	"Jacksonville, FL"	20	812150	220.6518833	23.14502463	953.3447762	787470	207.203529	22.26051499	930.8119293
Table 2	2014	2	31267	"Dayton, OH"	10	255400	214.5685709	24.64861758	870.5095536	301570	190.9348808	20.43137491	934.5180223
Table 2	2014	2	31295	"Detroit, MI"	34	2768070	237.8039107	22.53884302	1055.084817	2654690	224.0462981	21.31825271	1050.95995
Table 2	2014	2	31423	"Des Moines, IA"	8	207590	215.159237	21.7573518	988.9036081	189000	210.813037	21.06339981	1000.85
Table 2	2014	2	31453	"Houston, TX"	58	4277840	253.7108613	25.03365097	1013.479263	4146770	242.8892287	24.40288927	995.3297989
Table 2	2014	2	31454	"Orlando, FL"	58	5614680	197.5825347	17.83527014	1107.819131	5819710	176.621427	16.15350301	1093.393965
Table 2	2014	2	31650	"Minneapolis/St. Paul, MN"	40	3110850	242.1464236	22.96827676	1054.264654	2973200	238.4751658	23.01452291	1036.194262
Table 2	2014	2	31703	"New York City, NY (Metropolitan Area)"	74	13689130	261.9142555	20.56138592	1273.816155	13513090	238.1450554	18.91040602	1259.33338
Table 2	2014	2	31714	"Fort Myers, FL"	22	1248830	205.1489658	18.19572656	1127.456852	1218850	185.4615351	16.49949477	1124.043722
Table 2	2014	2	31721	"Flint, MI"	5	101650	164.3854993	16.29148105	1009.027349	78080	155.0186732	17.5025085	885.6940318
Table 2	2014	2	31871	"Greenville/Spartanburg, SC"	6	137030	204.3441509	31.42813001	650.1950668	140430	188.6018159	29.89943155	630.7872962
Table 2	2014	2	31884	"Spokane, WA"	9	339410	173.0244719	25.82999449	669.8587254	322380	168.808642	25.11451985	672.1555618
Table 2	2014	2	31986	"Grand Rapids, MI"	10	227100	236.2039454	21.23133632	1112.525099	220980	217.9490044	19.41296684	1122.698072
Table 2	2014	2	31995	"Greensboro/High Point, NC"	8	160600	235.1667995	37.68812285	623.9811955	145910	235.2134741	36.92886341	636.9366733
Table 2	2014	2	32211	"Las Vegas, NV"	64	6119260	204.1011184	16.71937116	1220.746381	6208290	188.2756514	15.5563398	1210.282456
Table 2	2014	2	32337	"Indianapolis, IN"	23	1190670	235.1861607	22.93100857	1025.625018	1159670	221.0683306	21.67900111	1019.734856
Table 2	2014	2	32457	"San Francisco, CA (Metropolitan Area)"	56	9552790	233.1329173	17.50233904	1332.010063	9081620	227.9467525	17.09235592	1333.618101
Table 2	2014	2	32467	"Miami, FL (Metropolitan Area)"	50	5566580	213.7336291	17.23608797	1240.035613	5560000	189.2804331	15.45615839	1224.627933
Table 2	2014	2	32575	"Los Angeles, CA (Metropolitan Area)"	69	11761090	232.4148444	17.40460997	1335.363704	11480910	220.1401729	16.59032777	1326.918768
Table 2	2014	2	32600	"Little Rock, AR"	8	203090	211.3905116	27.48331334	769.1594859	215300	198.5601254	25.60811646	775.3796563
Table 2	2014	2	33044	"Louisville, KY"	16	473270	236.9998965	26.76723594	885.4104211	465830	223.5959535	25.25691537	885.28607
Table 2	2014	2	33105	"Cincinnati, OH"	20	618170	295.7216461	29.76358718	993.5685653	600460	278.0965293	29.06555845	956.7905939
Table 2	2014	2	33158	"Midland/Odessa, TX"	3	132680	221.1622098	52.43243543	421.8041905	122290	188.5667675	45.89482127	410.8672009
Table 2	2014	2	33192	"Sacramento, CA"	21	1454100	201.9892972	21.6109774	934.6606286	1429420	193.3958934	21.28932462	908.4172322
Table 2	2014	2	33195	"Tampa, FL (Metropolitan Area)"	46	3093940	198.4963092	18.67472591	1062.914177	2956210	183.0753945	17.3284177	1056.503817
Table 2	2014	2	33198	"Kansas City, MO"	34	1703780	216.8733551	23.003486	942.7847375	1692720	204.9739679	21.79184818	940.599284
Table 2	2014	2	33214	"San Antonio, TX"	27	1179340	229.4750801	21.65043053	1059.910009	1185050	218.4291473	20.80365787	1049.955487
Table 2	2014	2	33244	"Memphis, TN"	16	457110	254.4659141	27.076091	939.8177682	419200	251.9938955	27.07699924	930.6566555
Table 2	2014	2	33316	"Omaha, NE"	16	583990	215.6598452	21.76676851	990.775664	579780	203.4265549	20.37830364	998.2506813
Table 2	2014	2	33342	"Milwaukee, WI"	24	1153270	199.4435692	18.85715287	1057.65473	1098200	190.6863804	17.89619755	1065.513386
Table 2	2014	2	33495	"New Orleans, LA"	29	1671980	224.6236624	22.48582399	998.9567758	1587550	214.8378879	22.00081409	976.4997197
Table 2	2014	2	33570	"San Diego, CA"	41	3092550	218.792122	17.33280965	1262.30038	3019260	206.1471741	16.4682749	1251.783659
Table 2	2014	2	33667	"Norfolk, VA (Metropolitan Area)"	17	436520	243.4061166	21.55505573	1129.229818	458980	223.9727809	20.34740937	1100.743475
Table 2	2014	2	33851	"Oklahoma City, OK"	13	432800	230.7652056	24.93720355	925.3852588	423890	217.2912029	23.06615232	942.0348911
Table 2	2014	2	34027	"West Palm Beach/Palm Beach, FL"	11	896390	210.9153103	19.86977348	1061.488247	885960	178.0118324	17.3580057	1025.531593
Table 2	2014	2	34057	"Portland, OR"	32	2192640	194.5056676	16.33115679	1191.009737	2059300	197.4643607	16.529279	1194.633842
Table 2	2014	2	34100	"Philadelphia, PA"	44	3228030	249.9201051	20.63683356	1211.039011	3245600	230.8443619	19.143858	1205.840338
Table 2	2014	2	34262	"Palm Springs, CA"	5	145030	199.0532786	19.84719582	1002.92898	130780	190.8805475	19.68650462	969.6010093
Table 2	2014	2	34321	"Portland, ME"	4	125540	198.2635256	32.34604441	612.9451968	130080	174.0460793	28.37974601	613.2756765
Table 2	2014	2	34492	"Raleigh/Durham, NC"	29	1555300	218.2592554	24.00924948	909.0632161	1514350	205.1120514	22.76662383	900.9331066
Table 2	2014	2	34524	"Richmond, VA"	12	413130	236.4661172	24.05507994	983.0194612	373470	229.3748708	23.68737415	968.34233
Table 2	2014	2	34570	"Reno, NV"	13	439530	182.2571793	23.3457263	780.6875526	475860	175.3740428	23.46952004	747.2417097
Table 2	2014	2	34576	"Rochester, NY"	10	264440	205.6865716	23.68804605	868.3137952	284890	181.9272561	21.67888316	839.1910913
Table 2	2014	2	34614	"Salt Lake City, UT"	29	1648780	226.2763486	21.78178051	1038.833113	1630220	211.6014231	20.74949584	1019.790672
Table 2	2014	2	34653	"Tulsa, OK"	10	296050	227.4127174	30.07174684	756.2338119	297360	221.0848433	29.82784169	741.2029526
Table 2	2014	2	34685	"Savannah, GA"	5	190360	196.4679765	26.24545446	748.5790607	118020	244.7759871	32.07793232	763.0665989
Table 2	2014	2	34986	"Sarasota/Bradenton, FL"	5	130800	204.8883333	20.83154409	983.5484709	138460	178.3507295	17.86726913	998.1980355
Table 2	2014	2	35096	"Syracuse, NY"	6	155950	192.1718115	26.84265304	715.9195896	154570	192.8691402	28.05121049	687.5608462