tbl	Year	quarter	citymarketid	city	markets	cur_passengers	cur_fare	cur_yield	distance	ly_passengers	ly_fare	ly_yield	ly_distance
Table 2	2015	1	30140	"Albuquerque, NM"	14	472400	206.7048243	24.04314296	859.7246401	483250	197.8578665	23.80579147	831.1333264
Table 2	2015	1	30158	"Atlantic City, NJ"	5	180010	96.03828121	10.27636149	934.5553025	183890	98.57907988	10.57710142	932.0046767
Table 2	2015	1	30194	"Dallas/Fort Worth, TX"	68	5605420	215.7064807	22.78630016	946.6498692	5196760	227.3275728	24.60279433	923.9908674
Table 2	2015	1	30198	"Pittsburgh, PA"	23	1036470	228.114945	23.00817334	991.4517835	1013780	228.9304751	23.24556807	984.8349346
Table 2	2015	1	30257	"Albany, NY"	7	219970	211.8091149	19.64552158	1078.154703	207170	212.3297775	20.05253422	1058.867548
Table 2	2015	1	30325	"Denver, CO"	58	5291510	192.1423253	18.5688357	1034.75699	5140460	189.491882	18.48316981	1025.213121
Table 2	2015	1	30397	"Atlanta, GA (Metropolitan Area)"	57	4711840	224.1753389	25.60007019	875.6825168	4446980	229.1713016	26.23085419	873.6707541
Table 2	2015	1	30423	"Austin, TX"	30	1557970	233.3285346	20.48397897	1139.078179	1462560	229.2476746	20.17575977	1136.252995
Table 2	2015	1	30436	"Tucson, AZ"	13	382500	216.6811216	22.48875352	963.5088105	401840	200.4505898	20.78422943	964.4359944
Table 2	2015	1	30466	"Phoenix, AZ"	63	5105440	213.0213831	18.36917013	1159.667974	4796380	206.0221029	18.01475396	1143.629846
Table 2	2015	1	30529	"Hartford, CT"	18	811030	218.4320777	17.79278188	1227.644329	802730	208.6492656	16.99232555	1227.902944
Table 2	2015	1	30559	"Seattle, WA"	41	3494120	203.6713496	15.64358099	1301.948382	3289680	201.5949357	15.2816231	1319.198454
Table 2	2015	1	30599	"Birmingham, AL"	10	257020	225.3222317	28.26955195	797.0491791	250670	230.1237683	28.05772344	820.1797582
Table 2	2015	1	30615	"El Paso, TX"	9	251310	215.7808484	29.07845064	742.0644622	253460	205.2996094	28.19154418	728.2311607
Table 2	2015	1	30647	"Cleveland, OH (Metropolitan Area)"	25	1298270	210.4511681	20.5524643	1023.970484	1132280	241.4618177	23.56161858	1024.809976
Table 2	2015	1	30666	"Bellingham, WA"	5	133210	120.9301028	11.97108602	1010.184896	164660	126.2858253	12.58674952	1003.323576
Table 2	2015	1	30693	"Nashville, TN"	32	1373330	223.9457982	25.37331746	882.6035403	1363440	215.6294072	24.2286083	889.9785102
Table 2	2015	1	30713	"Boise, ID"	10	314750	168.1278157	29.82377684	563.737506	294250	169.903079	30.23965087	561.8552931
Table 2	2015	1	30721	"Boston, MA (Metropolitan Area)"	47	5134410	225.4349951	18.07792433	1247.018136	5115330	213.8477394	17.20264372	1243.109739
Table 2	2015	1	30792	"Buffalo, NY"	15	641540	190.7957197	18.59524008	1026.046014	665910	186.3385968	18.11285381	1028.764428
Table 2	2015	1	30852	"Washington, DC (Metropolitan Area)"	69	7158710	219.5443626	20.27819246	1082.662387	6743750	225.8770361	21.0574248	1072.671697
Table 2	2015	1	30977	"Chicago, IL"	65	7462720	209.1924108	21.23572091	985.0968172	7002840	221.116132	22.38651816	987.7200664
Table 2	2015	1	30994	"Charleston, SC"	7	251970	184.3367028	23.94199229	769.9305076	235140	189.2922982	24.05528086	786.9053755
Table 2	2015	1	31057	"Charlotte, NC"	40	1668330	261.0708343	30.09203132	867.5746465	1617440	245.9487641	28.0171613	877.8504056
Table 2	2015	1	31066	"Columbus, OH"	22	919760	235.1375337	25.00691954	940.28988	912900	229.6369701	24.63122067	932.3004053
Table 2	2015	1	31123	"St. Louis, MO"	33	1555980	219.5280274	23.82260468	921.5114397	1509250	215.7205327	23.58350268	914.7094716
Table 2	2015	1	31136	"Jacksonville, FL"	19	674900	213.9945177	22.30860562	959.2464958	677720	214.6582453	22.64146943	948.0755917
Table 2	2015	1	31267	"Dayton, OH"	9	174370	221.116832	25.27146239	874.966508	201210	203.3261369	23.3276984	871.6082203
Table 2	2015	1	31295	"Detroit, MI"	34	2554990	230.8573145	21.55043067	1071.242232	2435830	228.5202325	21.34902451	1070.401284
Table 2	2015	1	31423	"Des Moines, IA"	10	205420	226.082324	21.16672023	1068.102765	208910	207.1409746	19.25212563	1075.938203
Table 2	2015	1	31453	"Houston, TX"	54	3765250	238.9997708	24.00920495	995.4505836	3604340	250.5324697	25.413895	985.8090219
Table 2	2015	1	31454	"Orlando, FL"	60	5912830	193.9293168	17.51777394	1107.043152	5584750	197.8003467	17.91965955	1103.817548
Table 2	2015	1	31650	"Minneapolis/St. Paul, MN"	43	3158020	238.0645427	20.98924611	1134.221503	3067880	227.2493174	20.25946386	1121.694626
Table 2	2015	1	31703	"New York City, NY (Metropolitan Area)"	73	11676760	256.2383137	19.83351598	1291.945987	11203680	252.4064175	19.66195389	1283.730086
Table 2	2015	1	31714	"Fort Myers, FL"	32	2159060	201.1010166	17.29387509	1162.845317	2034830	202.475251	17.33885405	1167.754515
Table 2	2015	1	31884	"Spokane, WA"	9	335260	159.1477182	24.04046789	661.9992543	319370	164.9214798	25.0710017	657.8176723
Table 2	2015	1	31986	"Grand Rapids, MI"	13	290480	217.0491979	18.43309871	1177.497074	268630	219.52394	18.71328364	1173.091501
Table 2	2015	1	32211	"Las Vegas, NV"	70	5799550	195.5382597	16.25049473	1203.275733	5730250	199.0475068	16.67347965	1193.797042
Table 2	2015	1	32337	"Indianapolis, IN"	24	1074320	231.6891299	22.63128535	1023.755948	1052770	226.9100563	21.88635602	1036.764896
Table 2	2015	1	32457	"San Francisco, CA (Metropolitan Area)"	50	8011780	229.3321547	18.42793895	1244.48076	7679860	218.6506333	17.53000325	1247.293741
Table 2	2015	1	32467	"Miami, FL (Metropolitan Area)"	60	6539760	215.2385152	17.28501511	1245.23186	6079830	216.318355	17.32578879	1248.533949
Table 2	2015	1	32575	"Los Angeles, CA (Metropolitan Area)"	65	10389800	229.6441453	17.8388129	1287.328628	10053230	221.3105119	17.30122973	1279.160588
Table 2	2015	1	32600	"Little Rock, AR"	9	154390	234.27665	28.57816977	819.7748559	178290	205.3954176	25.54686838	803.9945033
Table 2	2015	1	33044	"Louisville, KY"	15	358580	235.8599113	27.17760859	867.8464499	370670	217.9695632	25.88317483	842.1283891
Table 2	2015	1	33105	"Cincinnati, OH"	20	618160	267.6014009	27.39834976	976.7062735	531730	286.1155323	29.3780846	973.9080548
Table 2	2015	1	33192	"Sacramento, CA"	19	1207220	196.6827529	23.11445136	850.9081609	1185270	190.7890945	22.19300001	859.6814059
Table 2	2015	1	33195	"Tampa, FL (Metropolitan Area)"	53	3422380	190.4755235	17.64135914	1079.710026	3151270	196.2155829	18.10808907	1083.579731
Table 2	2015	1	33198	"Kansas City, MO"	31	1359770	216.7719739	23.11286501	937.8844805	1302200	214.0629466	22.97218684	931.8353018
Table 2	2015	1	33214	"San Antonio, TX"	27	1020200	233.7759822	22.3098347	1047.860665	1007030	226.6778021	21.82940076	1038.405976
Table 2	2015	1	33244	"Memphis, TN"	16	399270	244.8092043	26.43743925	925.9943898	374730	245.4948576	26.95430651	910.7815761
Table 2	2015	1	33316	"Omaha, NE"	16	494800	219.4653779	21.62136909	1015.039228	492250	205.1356018	20.43222395	1003.980782
Table 2	2015	1	33342	"Milwaukee, WI"	23	993460	200.4415588	17.75333533	1129.036066	988930	199.0081836	17.97568737	1107.096377
Table 2	2015	1	33495	"New Orleans, LA"	32	1648520	210.4830369	21.40103085	983.5182163	1534280	221.0819049	22.77855856	970.5702153
Table 2	2015	1	33570	"San Diego, CA"	42	2841430	218.2027081	17.39301433	1254.54222	2681390	211.2041822	16.88607427	1250.759524
Table 2	2015	1	33667	"Norfolk, VA (Metropolitan Area)"	13	260230	259.2905199	22.00544547	1178.301618	297130	218.876337	19.74230799	1108.666409
Table 2	2015	1	33851	"Oklahoma City, OK"	12	332660	231.6871671	26.54419865	872.8354175	342980	223.8371771	25.39206937	881.5239664
Table 2	2015	1	34027	"West Palm Beach/Palm Beach, FL"	16	1268060	212.064034	19.77064843	1072.620531	1196050	208.4951959	19.49459145	1069.502772
Table 2	2015	1	34057	"Portland, OR"	30	1803390	198.0812742	17.65720607	1121.815497	1734020	184.6540224	16.36294148	1128.48917
Table 2	2015	1	34100	"Philadelphia, PA"	41	2755240	244.0007128	20.8552455	1169.972863	2675270	239.1460593	19.83282263	1205.8095
Table 2	2015	1	34262	"Palm Springs, CA"	8	267290	221.7136032	20.57749981	1077.456471	254510	215.4749204	19.74926807	1091.052689
Table 2	2015	1	34492	"Raleigh/Durham, NC"	26	1219120	226.1291464	24.22217	933.5627092	1187980	212.1916261	23.28957157	911.1014579
Table 2	2015	1	34524	"Richmond, VA"	10	305940	231.6433516	24.70693753	937.5639995	292710	223.7383964	23.69673361	944.1739947
Table 2	2015	1	34570	"Reno, NV"	12	380420	182.6050181	25.24128316	723.437937	376540	181.378807	24.73343995	733.3343337
Table 2	2015	1	34576	"Rochester, NY"	9	239100	198.5462526	25.34124279	783.4905897	235660	188.98281	24.44235494	773.1775864
Table 2	2015	1	34614	"Salt Lake City, UT"	33	2000810	228.190064	21.40855367	1065.882673	1808790	240.3821488	22.15909815	1084.801138
Table 2	2015	1	34653	"Tulsa, OK"	8	211190	225.5452436	31.73049995	710.8152848	226810	214.552339	31.12086455	689.4163838
Table 2	2015	1	34685	"Savannah, GA"	3	105070	165.0911583	21.71096295	760.4045874	90190	186.1923717	24.78375981	751.2676572
Table 2	2015	1	34761	"Sanford, FL"	8	129680	120.312261	12.22436695	984.2003393	115980	121.9528367	12.52778744	973.4586998
Table 2	2015	1	34986	"Sarasota/Bradenton, FL"	6	167140	216.5261816	21.38024328	1012.73956	158070	208.4330297	20.5194572	1015.782375
Table 2	2015	1	35096	"Syracuse, NY"	7	157620	206.1809923	23.09860216	892.6124223	153220	202.3428795	22.77556337	888.4209633