Airfares - 1.S_CODE: 2.S_CITY:startingcity...

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
1. S_CODE: starting airport’s code 2. S_CITY: starting city 3. E_CODE: ending airport’s code 4. E_CITY: ending city 5. COUPON: average number of coupons (a one-coupon flight is a non-stop flight, a two-coupon flight is a one stop 6. NEW: number of new carriers entering that route between Q3-96 and Q2-97 7. VACATION: whether a vacation route (Yes) or not (No); Florida and Las Vegas routes are generally considered v 8. SW: whether Southwest Airlines serves that route (Yes) or not (No) 9. HI: Herfindel Index – measure of market concentration (refer to BMGT 681) 10. S_INCOME: starting city’s average personal income 11. E_INCOME: ending city’s average personal income 12. S_POP: starting city’s population 13. E_POP: ending city’s population 14. SLOT: whether either endpoint airport is slot controlled or not; this is a measure of airport congestion 15. GATE: whether either endpoint airport has gate constraints or not; this is another measure of airport congestion 16. DISTANCE: distance between two endpoint airports in miles 17. PAX: number of passengers on that route during period of data collection 18. FARE: average fare on that route
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
p flight, etc.) for that route vacation routes
Image of page 2
S_CODE S_CITY E_CODE E_CITY COUPON NEW VACATION SW HI S_INCOME E_INCOME * Dallas/Fort  * Amarillo       1.00 3 No Yes 5291.99 $28,637 $21,112 * Atlanta      * Baltimore/Wash 1.06 3 No No 5419.16 $26,993 $29,838 * Boston       * Baltimore/Wash 1.06 3 No No 9185.28 $30,124 $29,838 ORD Chicago      * Baltimore/Wash 1.06 3 No Yes 2657.35 $29,260 $29,838 MDW Chicago      * Baltimore/Wash 1.06 3 No Yes 2657.35 $29,260 $29,838 * Cleveland    * Baltimore/Wash 1.01 3 No Yes 3408.11 $26,046 $29,838 * Dallas/Fort  * Baltimore/Wash 1.28 3 No No 6754.48 $28,637 $29,838 * Fort Lauderd * Baltimore/Wash 1.15 3 Yes Yes 5584.00 $26,752 $29,838 * Houston      * Baltimore/Wash 1.33 3 No Yes 4662.44 $27,211 $29,838 * Kansas City  * Baltimore/Wash 1.60 2 No Yes 2617.00 $25,450 $29,838 * Las Vegas    * Baltimore/Wash 1.57 3 Yes Yes 1772.59 $24,575 $29,838 * Los Angeles  * Baltimore/Wash 1.50 1 No Yes 3932.29 $24,706 $29,838 * Nashville    * Baltimore/Wash 1.12 3 No Yes 4471.62 $25,995 $29,838 * New Orleans  * Baltimore/Wash 1.29 3 No Yes 4356.12 $22,038 $29,838 JFK New York/New * Baltimore/Wash 1.00 3 No No 2626.90 $32,991 $29,838 LGA New York/New * Baltimore/Wash 1.00 3 No No 2626.90 $32,991 $29,838 EWR New York/New * Baltimore/Wash 1.00 3 No No 2626.90 $32,991 $29,838 * Orlando      * Baltimore/Wash 1.13 3 Yes Yes 5706.76 $22,360 $29,838 * Phoenix      * Baltimore/Wash 1.86 3 No Yes 1230.48 $23,025 $29,838 * Salt Lake Ci * Baltimore/Wash 1.93 3 No Yes 2000.67 $21,121 $29,838 * San Diego    * Baltimore/Wash 1.87 3 No Yes 1572.93 $23,903 $29,838 * San Francisc * Baltimore/Wash 1.52 3 No No 2967.59 $38,813 $29,838 * St Louis     * Baltimore/Wash 1.14 3 No Yes 4191.24 $25,824 $29,838 * Tampa        * Baltimore/Wash 1.13 3 Yes Yes 5201.34 $23,654 $29,838 ORD Chicago      * Birmingham     1.16 3 No Yes 3627.46 $29,260 $23,858 MDW Chicago      * Birmingham     1.16 3 No Yes 3627.46 $29,260 $23,858 * Seattle/Taco * Boise          1.07 3 No Yes 5255.24 $30,916 $23,901 * Atlanta      * Boston         1.25 3 No No 5736.34 $26,993 $30,124 JFK New York/New * Buffalo        1.01 3 No No 4040.09 $32,991 $23,184 LGA New York/New * Buffalo        1.01 3 No No 4040.09 $32,991 $23,184 EWR New York/New * Buffalo        1.01 3 No No 4040.09 $32,991 $23,184 JFK New York/New * Charleston     1.34 0 No No 2587.89 $32,991 $18,851 LGA New York/New * Charleston     1.34 3 No No 2587.89 $32,991 $18,851 EWR New York/New * Charleston     1.34 1 No No 2587.89 $32,991 $18,851 * Atlanta      * Charlotte      1.01 3 No No 4435.92 $26,993 $25,237 *
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern