trips
Data license: PDDL
- id
- Trip ID (assigned by the vendor)
- date
- Date of trip (a date range separated with a semicolon for multi-day trips)
- route
- Route of trip
- billing_amount
- Billing Amount (flight_hours * hourly_rate)
- fuel
- Fuel Surcharge
- crew_expense
- Crew Expenses
- landing
- Landing & De-icing Fees
- dom_tax
- Domestic Segment Tax
- justification
- Justification
- distance
- Distance (in nautical miles)
- flight_hours
- Flight hours
5 rows where reg_no = "N871RF"
This data as json, CSV (advanced)
Suggested facets: num_pax, crew_expense, flight_hours, hourly_rate, billing_amount, signed_by_name, carbon_footprint, date (date)
id ▼ | date | route | aircraft | reg_no | num_pax | justification | distance | fuel | landing | crew_expense | dom_tax | flight_hours | hourly_rate | billing_amount | signed_by_name | approved_by_name | carbon_footprint | notes | itinerary | reservation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
061000 | 2016-12-03;2016-12-04 | LBE-MGW-LBF-SJC-RON(1)-LBF-MGW-LBE | Citation Excel | N871RF | 7 | WU's participation in the 2016 NCAA Wamen's College Cup Travel related to WV's participation in the 2016 NCAA Women's College Cup (women's soccer championship). WVU played in the final game. Interactions at official events with donors, alums. students, potential students and potential donors. All passengers traveled in an official capacity to represent WVU. | 4.013942 knmi | 3485.43 | 765.0 | 700.0 | 0.0 | 12.1 h | 3150.0 | 38115.0 | Amy Garbrick | Amy Garbrick | 26825651 | <Binary: 1,343,359 bytes> | <Binary: 459,017 bytes> | |
063656 | 2017-11-12;2017-11-14 | LBE-MGW-ATL-RON(2)-MGW-LBE | Citation Excel | N871RF | 6 | Promote WVU at 2017 AMA Symposiun for Marketing Higher ED Travel to Allanta to support the WVU UR team at the 2017 American Marketing Association Symposium for the Marketing of Higher Education. Sharon Martin and Tony Dobies have been asked to speak at the event (Becomig a Social-First Uriversity: How WVU Went from Forgotten to Foliowed on Social Media). Also, the UR team is a finalist for the AMA Marketing Team of the Year Award which recognizes extraordinary leadership and achievement in the field of higher education marketing. As a finalist, they were roquired to submit a 60-90 second video at will answer the questions, "What makes my team AMA-ing?" The videos will be shared with all conference attendees via mobile conference app, and attendees will select this year's team winner. This event is geared toward senior leaders in marketing communications at colleges and universities and is designed to encourage greater conversation, discussion of recommended topics, and tore opportunties to engage with colleagues. This year, the group will discuss the challenges of leading one of the most complex and dynamic functions in higher education. Leadership expert and veteran Chief Marketing Officer Dr. Jessica McWade will guide us through a half-day, highly-interactive workshop that will explore techniques for gaining greater influence with our president, board, peers and staff. | 931.230569 nmi | 1812.95 | 1089.36 | 1400.0 | 0.0 | 6.0 h | 3150.0 | 18900.0 | Sharon Martin | Amy Garbrick | 13301976 | <Binary: 461,258 bytes> | <Binary: 891,838 bytes> | |
066281 | 2018-06-06 | LBE-CRW-MGW-LBE | Citation Excel | N871RF | 4 | Various meetings at the State Capitol - see below Meetings with the WV Governor as well as other state officials at the state capitol regarding higher education in the West Virginia. President Gee will also speak at "Moving West Virginia Forward: A Leadership Learning Exchange." This is a working dinner of the WV Public Education Collaborative. The WVPEC collaborative is working with the Federal Reserve to have an Emerging Issues Learning Exchange with thought leaders in WV and other states, i.e. NC and Georgia. This is in conjunction with the Hunt Institute. | 306.828192 nmi | 337.5 | 203.0 | 130.0 | 0.0 | 2.0 h | 3160.0 | 6320.0 | Amy Garbrick | Amy Garbrick | 4433992 | <Binary: 282,459 bytes> | <Binary: 396,380 bytes> | |
066867 | 2018-07-19 | LBE-MGW-CRW-MGW-LBE | Citation Excel | N871RF | 6 | To provide clinical services in Southern West Virginia Clinical Services | 307.849061 nmi | 772.73 | 278.0 | 700.0 | 0.0 | 2.0 h | 3160.0 | 6320.0 | Clay Braden Marsh | Amy Garbrick | 4433992 | <Binary: 419,891 bytes> | <Binary: 646,863 bytes> | |
067045 | 2018-08-16 | LBE-MGW-CRW-MGW-LWB-MGW-LBE | Citation Excel | N871RF | 12 | Governor's Day at the State Fair of WV Represent WVW at Goveror's Day at the State Fair of WV. Meet with state government officials, donors and alums throughout the course of the day | 526.892393 nmi | 908.3 | 471.0 | 130.0 | 0.0 | 2.6 h | 3160.0 | 8216.0 | Amy Garbrick | Amy Garbrick | 5764189 | <Binary: 917,787 bytes> | <Binary: 1,110,158 bytes> |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trips" ( "id" text, "date" text, "route" text, "aircraft" text, "reg_no" text, "num_pax" integer, "justification" text, "distance" real, "fuel" real, "landing" real, "crew_expense" real, "dom_tax" real, "flight_hours" real, "hourly_rate" real, "billing_amount" real, "signed_by_name" text, "approved_by_name" text, "carbon_footprint" integer, "notes" text, "itinerary" blob, "reservation" blob, PRIMARY KEY("id"), CONSTRAINT "fk_trips_signed_by" FOREIGN KEY("signed_by_name") REFERENCES "people"("name"), CONSTRAINT "fk_trips_approved_by" FOREIGN KEY("approved_by_name") REFERENCES "people"("name") );