tbl	Year	quarter	citymarketid	city	markets	cur_passengers	cur_fare	cur_yield	distance	ly_passengers	ly_fare	ly_yield	ly_distance
Table 2	2014	4	30140	"Albuquerque, NM"	17	639670	214.2311801	23.22203642	922.5339941	657910	198.1534313	21.68356856	913.8414221
Table 2	2014	4	30158	"Atlantic City, NJ"	4	152060	102.9255886	11.08080519	928.8638038	146520	108.7805556	11.71674999	928.4191919
Table 2	2014	4	30194	"Dallas/Fort Worth, TX"	69	6220980	210.7355822	22.18426278	949.932771	5777730	215.8847719	23.00290797	938.5107836
Table 2	2014	4	30198	"Pittsburgh, PA"	24	1193180	229.828766	23.14899203	992.8240752	1150140	227.6701149	22.75354126	1000.592006
Table 2	2014	4	30257	"Albany, NY"	10	260500	236.4733282	19.73511613	1198.236315	257050	233.1636296	19.86127527	1173.961019
Table 2	2014	4	30325	"Denver, CO"	66	5869360	190.8193754	18.70960506	1019.900606	5478400	185.3615882	18.23292577	1016.631069
Table 2	2014	4	30397	"Atlanta, GA (Metropolitan Area)"	58	5605710	218.7304036	24.98355584	875.4974874	5143650	221.314716	25.10351194	881.6085834
Table 2	2014	4	30423	"Austin, TX"	32	1768960	225.83837	19.81107936	1139.959948	1664750	223.6540075	19.51459317	1146.085935
Table 2	2014	4	30436	"Tucson, AZ"	11	375050	212.2215758	22.13916898	958.5796827	389400	196.4429584	20.217432	971.6513867
Table 2	2014	4	30466	"Phoenix, AZ"	56	4688980	206.0903463	17.94812795	1148.255388	4430200	204.2023218	17.79791956	1147.338154
Table 2	2014	4	30529	"Hartford, CT"	21	936050	218.8135687	18.07226195	1210.770237	909260	210.1816059	17.10074766	1229.078459
Table 2	2014	4	30559	"Seattle, WA"	45	4085620	210.4410334	15.68851481	1341.370015	3818370	207.6484801	15.24756438	1361.846882
Table 2	2014	4	30599	"Birmingham, AL"	9	282830	220.2583495	29.53437037	745.7695789	283910	214.0709345	29.11940422	735.1487443
Table 2	2014	4	30615	"El Paso, TX"	11	339630	214.635577	25.88940586	829.0479051	335100	204.1747896	25.21323766	809.7920322
Table 2	2014	4	30647	"Cleveland, OH (Metropolitan Area)"	26	1383280	221.9249581	22.66624872	979.0987508	1286770	236.7306582	24.29052253	974.5803446
Table 2	2014	4	30666	"Bellingham, WA"	5	147800	123.4312652	12.42263813	993.5994587	137520	128.609315	13.34543423	963.6952443
Table 2	2014	4	30693	"Nashville, TN"	35	1653280	214.7510573	24.82202925	865.1631787	1557870	204.936263	23.53266239	870.8588072
Table 2	2014	4	30713	"Boise, ID"	10	359180	167.1113091	29.95992302	557.7828387	336140	173.001779	30.72693878	563.0296603
Table 2	2014	4	30721	"Boston, MA (Metropolitan Area)"	52	6156200	221.5011782	18.36890963	1205.848265	6135160	211.7515887	17.51474469	1208.990439
Table 2	2014	4	30792	"Buffalo, NY"	17	724290	189.5837261	19.73079982	960.851703	798050	180.0655585	18.50001397	973.3266086
Table 2	2014	4	30852	"Washington, DC (Metropolitan Area)"	74	8532670	216.7921454	20.74843625	1044.860166	8044490	218.7627789	21.0378933	1039.851166
Table 2	2014	4	30977	"Chicago, IL"	68	8664130	213.3291751	22.32090752	955.7370146	8198990	214.6242605	22.44781882	956.1029615
Table 2	2014	4	30994	"Charleston, SC"	9	363450	191.4881002	25.28370918	757.3576283	329430	198.2276994	25.47081663	778.2541966
Table 2	2014	4	31057	"Charlotte, NC"	42	2016440	237.7615173	27.32680402	870.0670489	1981720	227.6858431	25.56070373	890.7651585
Table 2	2014	4	31066	"Columbus, OH"	23	1003070	231.2171354	24.77905185	933.1153459	1002840	224.1824449	23.97064032	935.2376152
Table 2	2014	4	31123	"St. Louis, MO"	35	1775690	217.2854248	23.62066541	919.8954435	1789630	207.9861513	22.6552515	918.0483005
Table 2	2014	4	31136	"Jacksonville, FL"	19	764700	214.6351628	22.86777436	938.5922715	748220	210.7305432	22.38825175	941.2550186
Table 2	2014	4	31267	"Dayton, OH"	8	196850	221.4768453	27.23105505	813.324511	219310	195.7943368	23.72709445	825.1930601
Table 2	2014	4	31295	"Detroit, MI"	33	2722710	230.5533531	21.99502032	1048.207047	2636430	232.4781178	22.03437261	1055.070284
Table 2	2014	4	31423	"Des Moines, IA"	8	201580	209.8457238	20.92164243	1003.007888	196410	201.55543	20.50286727	983.059722
Table 2	2014	4	31453	"Houston, TX"	58	4410570	235.3544308	23.31654918	1009.38792	4121280	245.6635926	24.48402545	1003.362756
Table 2	2014	4	31454	"Orlando, FL"	56	5519890	198.0405095	18.0163447	1099.226912	5317430	192.0533051	17.55797264	1093.823922
Table 2	2014	4	31650	"Minneapolis/St. Paul, MN"	41	3102440	232.7828087	21.90382171	1062.749742	2971580	229.8126869	21.82007464	1053.216777
Table 2	2014	4	31703	"New York City, NY (Metropolitan Area)"	73	13695400	252.4897184	20.06711227	1258.22647	13308510	246.4357108	19.68329647	1252.004263
Table 2	2014	4	31714	"Fort Myers, FL"	23	1335850	207.9030625	18.50966697	1123.213415	1278240	208.2246534	18.51873482	1124.399995
Table 2	2014	4	31871	"Greenville/Spartanburg, SC"	5	129020	195.6503333	30.11062157	649.7718183	130650	195.6241255	30.57941332	639.7249139
Table 2	2014	4	31884	"Spokane, WA"	9	374270	162.7233601	25.5540062	636.7821893	355360	162.1824629	25.36879576	639.2990207
Table 2	2014	4	31986	"Grand Rapids, MI"	10	218700	229.464984	20.36559297	1126.728715	202560	235.7316746	20.9859286	1123.284459
Table 2	2014	4	31995	"Greensboro/High Point, NC"	6	132140	220.6123505	38.68412193	570.291736	133340	216.8386381	36.72589822	590.4243288
Table 2	2014	4	32211	"Las Vegas, NV"	68	5702140	192.0278881	16.24506899	1182.068776	5582820	187.3740694	15.80480757	1185.551096
Table 2	2014	4	32337	"Indianapolis, IN"	24	1161460	233.0054354	22.74189142	1024.564892	1162160	221.3447021	21.41889008	1033.408834
Table 2	2014	4	32457	"San Francisco, CA (Metropolitan Area)"	54	9373270	230.9393019	17.81316832	1296.452701	8938390	223.1453694	17.07955107	1306.506058
Table 2	2014	4	32467	"Miami, FL (Metropolitan Area)"	51	5784660	217.0961355	17.49355872	1241.006127	5523430	211.2594703	16.99391993	1243.147379
Table 2	2014	4	32575	"Los Angeles, CA (Metropolitan Area)"	68	11645570	231.5257266	17.5821746	1316.820768	11261950	220.5015954	16.66681877	1322.997499
Table 2	2014	4	32600	"Little Rock, AR"	9	194820	221.6873524	26.67345488	831.1160045	211820	199.3128175	24.50459707	813.369087
Table 2	2014	4	33044	"Louisville, KY"	16	428260	233.8085112	25.41247095	920.0542194	457500	213.9650623	24.59694267	869.8847869
Table 2	2014	4	33105	"Cincinnati, OH"	20	649630	271.6379693	27.82342361	976.2923972	587650	282.5940798	29.12498887	970.2804731
Table 2	2014	4	33158	"Midland/Odessa, TX"	3	128470	227.5265432	51.0288934	445.8778703	122520	211.6051094	47.45039744	445.9501306
Table 2	2014	4	33192	"Sacramento, CA"	21	1428580	192.4003703	21.7847498	883.1883409	1354200	193.8876813	21.40156527	905.9509378
Table 2	2014	4	33195	"Tampa, FL (Metropolitan Area)"	45	3025890	197.0570487	18.4363051	1068.853263	2873670	195.5960048	18.29406059	1069.177637
Table 2	2014	4	33198	"Kansas City, MO"	34	1655290	209.4753632	22.63513231	925.4435114	1581930	205.6046804	22.23034689	924.8829152
Table 2	2014	4	33214	"San Antonio, TX"	28	1164490	227.8280063	21.19957661	1074.681869	1143940	223.1440609	20.75388465	1075.191776
Table 2	2014	4	33244	"Memphis, TN"	16	483500	236.0463144	25.73447515	917.2377249	462720	232.9633342	25.91798661	898.8481155
Table 2	2014	4	33316	"Omaha, NE"	16	527000	213.7053472	21.77807946	981.2864706	544040	196.0399474	20.30147141	965.6440335
Table 2	2014	4	33342	"Milwaukee, WI"	23	1030920	201.2177026	18.86160734	1066.811004	1053380	191.5151807	17.93490677	1067.834827
Table 2	2014	4	33495	"New Orleans, LA"	30	1702750	214.37234	21.73117891	986.4735868	1557680	217.7092991	22.19816434	980.7536143
Table 2	2014	4	33570	"San Diego, CA"	42	3104820	216.3416124	17.17976657	1259.281443	2922770	211.687633	16.64203225	1272.005905
Table 2	2014	4	33667	"Norfolk, VA (Metropolitan Area)"	17	378810	254.3371532	21.95607898	1158.390592	426970	219.0866173	19.75126038	1109.228541
Table 2	2014	4	33851	"Oklahoma City, OK"	12	421290	221.0930903	25.16625074	878.5301099	395140	216.6466518	23.84955454	908.3886724
Table 2	2014	4	34027	"West Palm Beach/Palm Beach, FL"	12	1006510	214.7741115	20.17129048	1064.751468	965080	209.0821352	19.66574393	1063.179384
Table 2	2014	4	34057	"Portland, OR"	34	2181570	200.6163547	17.16128562	1169.005395	2088660	189.6000278	16.09268033	1178.175567
Table 2	2014	4	34100	"Philadelphia, PA"	42	3042080	242.5653162	20.49072031	1183.781304	3079440	230.1741911	18.9917129	1211.971729
Table 2	2014	4	34262	"Palm Springs, CA"	8	202740	211.6614827	19.95073946	1060.920489	184130	199.3473307	18.87082364	1056.378537
Table 2	2014	4	34321	"Portland, ME"	3	100800	182.3906548	33.67126368	541.6804563	103060	173.5875509	32.24089863	538.4079177
Table 2	2014	4	34492	"Raleigh/Durham, NC"	28	1546660	216.1492603	24.22084978	892.4098962	1492020	206.4104824	23.37724456	882.9547124
Table 2	2014	4	34524	"Richmond, VA"	11	375480	229.6645467	24.1136877	952.4239906	349040	226.829988	23.80617214	952.8200779
Table 2	2014	4	34570	"Reno, NV"	12	398240	177.8350542	25.0617784	709.5867316	403990	172.8453922	24.25116493	712.7302656
Table 2	2014	4	34576	"Rochester, NY"	9	247990	196.6741602	26.17442099	751.3983225	257520	184.8713692	24.89779255	742.5211246
Table 2	2014	4	34614	"Salt Lake City, UT"	30	1776280	215.1302565	21.51073359	1000.106554	1589070	225.1494585	22.08740547	1019.35675
Table 2	2014	4	34653	"Tulsa, OK"	10	282320	223.33914	29.26812768	763.0796968	291780	217.2700082	29.30467602	741.4175406
Table 2	2014	4	34685	"Savannah, GA"	5	171250	185.5351066	24.54281629	755.9650219	109730	233.9363529	30.41690143	769.0998815
Table 2	2014	4	34986	"Sarasota/Bradenton, FL"	5	129720	208.6249383	21.20195226	983.9892846	129060	206.0691384	20.63053841	998.8548737
Table 2	2014	4	35096	"Syracuse, NY"	8	181270	211.0711977	25.10406598	840.7849065	184680	209.3723684	24.48372448	855.149177