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
816 rows sorted by billing_amount
This data as json, CSV (advanced)
Suggested facets: aircraft, reg_no, num_pax, crew_expense, signed_by_name, approved_by_name, notes, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
079351 | 2022-03-17 | LBE-CMH-MGW | Citation CJ3 | N369MN | 1 | Travel to Charleston, WV for an event of President Bidens Interagency Working Group (IWG) on Coal and Power Plant Communities and Economic Revitalization, a partnership among the White House and nearly a dozen federal agencies, committed to pursuing near and long-term actions to support coal, oil and gas, and power plant communities as the nation transitions to a clean energy economy. Several federal investments will be announced during the IWG-hosted listening session at the West Virginia Regional Technology Park where federal government officials will meet with leaders from the private sector, philanthropy, labor and community organizers to identify key opportunities to advance energy infrastructure projects, workforce development and training strategies, and environmental clean-up priorities across the Appalachia region, which is comprised of 13 states from southern New York to northern Mississippi. | 299.713096 nmi | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 h | 2788.25 | 0.0 | Amy Garbrick | Amy Garbrick | 0 | multi-leg / see trip #079379 for flight costs | <Binary: 33,741 bytes> | <Binary: 94,522 bytes> |
067554 | 2018-09-20 | LBE-MGW-LBE | Citation Bravo | N26AP | 0 | To provide clinical services in Southern West Virginia Clinical Services | 89.431554 nmi | 190.4 | 0.0 | 0.0 | 0.0 | 800.0 mh | 2265.0 | 1812.0 | Clay Braden Marsh | Amy Garbrick | 1222923 | * trip was canceled due to weather, once plane was already in Morgantown. Two hour minimum waived. -AG | <Binary: 405,285 bytes> | <Binary: 848,253 bytes> |
X20150807-2 | 2015-08-07 | CRW-MGW-LBE | Citation V Ultra | N60KM | 2 | 153.92453 nmi | 239.94 | 155.0 | 100.0 | 0.0 | 1.1 h | 1825.0 | 2007.5 | 1917522 | Mechanical in N5AE | |||||
X20151115-2 | 2015-11-15 | MGW-IAD-LBE | Citation V Ultra | N6NY | 7 | 242.317597 nmi | 186.32 | 570.34 | 50.0 | 0.0 | 1.2 h | 2370.0 | 2844.0 | 2091843 | ||||||
066484 | 2018-08-24 | MGW-LWB-LBE | Citation V Ultra | N6NY | 2 | Annual Meeting of the WV Bar Association speaking engagement Meeting on August 24 with potential WVU donors regarding the WVU Energy Institute. Speaking engagement on August 25 re: WV Forward at the Annual Meeting of the WV Bar Association as well as a meeting with the Marshall University President and his wife. President Gee and Mrs. Erickson traveled between the two destinations by car. | 261.89873 nmi | 327.5 | 153.0 | 65.0 | 0.0 | 1.2 h | 2375.0 | 2850.0 | Amy Garbrick | Amy Garbrick | 2091843 | <Binary: 315,518 bytes> | <Binary: 388,624 bytes> | |
078890 | 2022-03-05 | BCT-APF | Citation Latitude | N61JD | 2 | WVU Foundation Board Meeting, WVU Alumni Association Board Meeting and donor relations meetings Return travel to MGW for passengers as they traveled from multiple donor relations meetings and the WVU Foundation Board meeting and the WVU Alumni Association Board meetings and associated events in multiple locations in Florida. | 90.80407 nmi | 795.23 | 802.5 | 0.0 | 8.6 | 700.0 mh | 4089.75 | 2862.82 | Amy Garbrick | Amy Garbrick | 1846006 | <Binary: 44,188 bytes> | <Binary: 74,873 bytes> | |
059880 | 2016-07-21 | LBE-MGW-CRW-MGW-LBE | Citation Encore | N511TH | 6 | To attend meeting at the State Auditor's Office Attending meeting at the State Auditors Office regarding SeiQuest and the impact it has on WVU computer and payroll systems. | 307.849061 nmi | 147.42 | 203.0 | 50.0 | 0.0 | 1.3 h | 2420.0 | 3146.0 | James Robert Alsop | Amy Garbrick | 2091843 | <Binary: 286,137 bytes> | <Binary: 423,903 bytes> | |
059387 | 2016-05-17;2016-05-18 | RON(1)-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 4 | Attend meeting at WVU Tech with members from the Chinese Delegation and Tech President, Carolyn Long and also attend Legislative Meeting on behalf of WVU Members of the Chinese Delegation will be visiting WVU TECH for an extensive tour of campus - top administrators from WVU (Dean, Weese, Taylor, and Lang) will be part of the visit and potential negotiations due to their extensive knowledge of the grounds and facilities, alongside President Long. While in Charleston, this group will also attend a Legislative Meeting taking place at the Capitol alongside Rob Aslop | 263.133284 nmi | 231.6 | 106.0 | 700.0 | 0.0 | 1.8 h | 1825.0 | 3285.0 | Laura Hackett | Amy Garbrick | 1641292 | <Binary: 187,695 bytes> | <Binary: 281,967 bytes> | |
X20151115-1 | 2015-11-15 | LBE-MGW-IND-MGW | Citation V Ultra | N6NY | 4 | 633.981018 nmi | 402.0 | 405.0 | 50.0 | 0.0 | 1.4 h | 2370.0 | 3318.0 | 2440483 | ||||||
067186 | 2018-08-24 | LBE-MGW-CRW-MGW | Citation V Ultra | N6NY | 1 | Attend the Higher Education Policy Commission Meeting (HEPC) Attend and represent WVU at the HEPC meeting. During the meeting, the funding model that greatly impacts WVU will be discussed and Provost McConnell will provide information, clarification, and data as needed. | 263.133284 nmi | 393.0 | 318.0 | 65.0 | 0.0 | 1.4 h | 2375.0 | 3325.0 | Stephen Ballant | Amy Garbrick | 2440483 | <Binary: 393,266 bytes> | <Binary: 747,222 bytes> | |
075670 | 2021-02-18 | LBE-MGW-LBE | Citation Encore | N511TH | 0 | Clinic in Gilbert clinical | 89.431554 nmi | 335.4 | 2766.56 | 750.0 | 0.0 | 1.3 h | 2612.5 | 3396.25 | Amy Garbrick | Amy Garbrick | 2091843 | (Trip canceled after arrival at MGW-weather) "Plane Deiced at LBE & MGW. Crew Log Of - Rooms already checked in for early arrival. this reservation form is handwritten | <Binary: 49,242 bytes> | <Binary: 108,205 bytes> |
X20160416-1 | 2016-04-16 | LBE-MGW-IAD-MGW | King Air B200 | N5AE | 6 | 288.387257 nmi | 89.28 | 292.01 | 50.0 | 0.0 | 1.9 h | 1825.0 | 3467.5 | 1732475 | ||||||
X20220519-2 | 2022-05-19 | MGW-CRW-MGW-LBE | Citation CJ3 | N40WV | 2 | 263.133284 nmi | 897.72 | 320.0 | 77.5 | 0.0 | 1.3 h | 2788.25 | 3624.72 | 1975629 | ||||||
059424 | 2016-06-09 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 2 | Attend Alumni Association and Mountaineer Athletic Club fundraiser The WVU Alumni Association will hold a fundraiser in Charleston, WV featuring talented and creative fashions of local stores and WVU alumni nationwide. All proceeds from this event will benefit WVU alumni and student programming. President Gee and AD Lyons will represent WVU at this event. In addition lo the Alumni fundraiser, President Gee and AD Lyons will attend a Mountaineer Athletics Club reception. President Gee and AD Lyons will speak at this event. | 307.849061 nmi | 62.64 | 106.0 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | Amy Garbrick | Amy Garbrick | 1823658 | <Binary: 180,617 bytes> | <Binary: 187,405 bytes> | |
059477 | 2016-06-12 | LBE-LWB-MGW-LBE | King Air B200 | N5AE | 1 | Meeting with former WV governor Business meeting with President Gee and former WV Goveror Gaston Caperton. Governor Caperton is a partner with WVU on the Center for Big Ideas. | 306.614507 nmi | 70.18 | 76.5 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | Amy Garbrick | Amy Garbrick | 1823658 | <Binary: 155,563 bytes> | <Binary: 158,594 bytes> | |
059481 | 2016-06-18 | LBE-MGW-CMH-LBE | King Air B200 | N5AE | 2 | Association of Ohio Commodores summer meeting President Gee will travel to Columbus, OH to attend the Association of Ohio Commodores summer meeting and introduce new inductee Jim Tressel. The people that President Gee will meet/network with at this event are valuable in elevating the recruitment and presence of West Virginia University. The mission of the Commodores is to "assist the State of Ohio in its advancement in all areas contributing to the economic growth and development of the State, and the greater prosperity of its citizens." Mrs. Erickson will accompany President Gee to the events of this mecting. | 344.428873 nmi | 59.4 | 75.0 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | Amy Garbrick | Amy Garbrick | 1823658 | <Binary: 155,934 bytes> | <Binary: 184,431 bytes> | |
059673 | 2016-06-19 | LBE-CMH-MGW-LBE | King Air B200 | N5AE | 2 | Association of Ohio Commodores summer meeting President Gee will travel to Columbus, OH to attend the Association of Ohio Commodores summer meeting and introduce new inductee Jim Tressel. The people that President Gee will meet/network with at this event are valuable in elevating the recruitment and presence of West Virginia University. The mission of the Commodores is to "assist the State of Ohio in its advancement in all areas contributing to the economic growth and development of the State, and the greater prosperity of its citizens." Mrs. Erickson will accompany President Gee to the events of this mecting. | 344.428873 nmi | 75.9 | 75.0 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | Amy Garbrick | Amy Garbrick | 1823658 | <Binary: 153,397 bytes> | <Binary: 184,431 bytes> | |
059135 | 2016-05-04 | LBE-MGW-MRB-MGW-LBE | King Air B200 | N5AE | 6 | 1. Transport WVU and WVU Medicine leadership group to Martinsburg to participate in ceremonies marking the full integration of the cancer program at University Healthcare/Berkeley Medical Center into the WVU Cancer Institute. 2. While in Martinsburg, E. Gordon Gee and Clay Marsh will meet with area news media to discuss WVU's activities statewide and in the Eastern Panhandle region. 3. Mike Esposito and Bill Case of University Relations are joining the trip. Esposito will review existing signage and branding on the WVU Eastern Division campus so that he can advise the UR and HSC on how to bring branding into line with WVU standards. Case will provide staff assistance related to the media interviews. Travel to Eastern Division Event | 270.807801 nmi | 26.72 | 100.0 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | Clay Braden Marsh | Amy Garbrick | 1823658 | this reservation form is an old version | <Binary: 195,354 bytes> | <Binary: 305,215 bytes> |
059055 | 2016-05-24 | LBE-MGW-LWB-LBE | King Air B200 | N5AE | 1 | Multi-purpose: Lewisburg- attend the Fourth Circuit Judicial Conference. San Diego- attend the National Boy Scouts of America Board meeting. Houston- donor relations President Gee will attend The Judicial Conference of the Fourth Circuit at The Groenbrier in Lewisburg, WV upon the invitation of Judge Robert King. Judge King is a federal judge on the US Court of Appeals for the Fourth Circuit. From there, he will travel to San Diego, CA for the National Boy Scouts of America Board meeting. From San Diego, President Gee will travel to Houston, TX to meet with WVU donors in the Houston area. | 306.614507 nmi | 49.14 | 76.5 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | Amy Garbrick | Amy Garbrick | 1823658 | <Binary: 165,709 bytes> | <Binary: 216,264 bytes> | |
X20160424 | 2016-04-24 | LBE-LWB-MGW-LBE | King Air B200 | N5AE | 6 | 306.614507 nmi | 12.9 | 76.5 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | 1823658 | ||||||
X20160309-2 | 2016-03-09 | LBE-MGW-CMH-LBE | King Air B200 | N5AE | 1 | 344.428873 nmi | 0.0 | 75.0 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | 1823658 | ||||||
X20160318 | 2016-03-18 | LBE-MGW-PKB-MGW-LBE | King Air B200 | N5AE | 4 | 234.904994 nmi | 6.51 | 63.6 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | 1823658 | ||||||
X20160330 | 2016-03-30 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 6 | 307.849061 nmi | 7.96 | 106.0 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | 1823658 | ||||||
X20160114 | 2016-01-14 | LBE-CRW-MGW-LBE | King Air B200 | N5AE | 2 | 306.828192 nmi | 0.0 | 106.0 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | 1823658 | ||||||
X20151220 | 2015-12-20 | LBE-CMH-MGW-LBE | King Air B200 | N5AE | 1 | 344.428873 nmi | 45.78 | 75.0 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | 1823658 | ||||||
X20151027 | 2015-10-27 | LBE-MGW-BKW-MGW | King Air B200 | N5AE | 6 | 294.613194 nmi | 74.09 | 35.0 | 0.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | 1823658 | ||||||
X20150805 | 2015-08-05 | LBE-MGW-MRB-MGW-LBE | King Air B200 | N5AE | 4 | 270.807801 nmi | 83.42 | 150.0 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | 1823658 | ||||||
X20150808 | 2015-08-08 | LBE-LWB-MGW-LBE | Citation V Ultra | N60KM | 2 | 306.614507 nmi | 227.9 | 228.0 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | 3486405 | ||||||
056815 | 2015-07-01 | LBE-LWB-MGW-LBE | King Air B200 | N5AE | 4 | Pick President Gee up from a WVU meeting in Pittsburgh PA (Allegany County Airport), travel to MGW to pick up passengers to then travel to Beckley, WV for county visits as part of President Gee's 55-county tour in the state of WV. | 306.614507 nmi | 114.05 | 76.5 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | Amy Garbrick | Amy Garbrick | 1823658 | <Binary: 117,919 bytes> | <Binary: 226,877 bytes> | |
056822 | 2015-07-05 | LBE-LWB-MGW-LBE | King Air B200 | N5AE | 1 | After county tour visits (Nicholas County) as part of President Gee's 55-county tour during the summer of 2015, President Gee will stay in Lewisburg for events surrounding the Greenbrier Classic. While in Lewisburg, he will conduct business mectings with WVU donors, potential donors, the former WV governor and attend the United Bank dinner. | 306.614507 nmi | 131.32 | 76.5 | 100.0 | 0.0 | 2.0 h | 1825.0 | 3650.0 | Amy Garbrick | Amy Garbrick | 1823658 | <Binary: 109,922 bytes> | <Binary: 190,578 bytes> | |
060589 | 2016-10-28 | LBE-IAD-MGW-LBE | King Air B200 | N5AE | 4 | WVU trip to the Middle East Travel to and from Washington, DC for commercial connecting flights for WV trip to the Middle East. Trip includes meetings with the Minister of Energy, visits to the Royal University for Women (including a private meeting with RUW president), meeting with the General Secretary of the Higher Education Council, Meeting w/ the Deputy Prime Minister in charge of Education and the Royal University for Woman Board of Trustees. | 287.033374 nmi | 200.88 | 456.51 | 100.0 | 0.0 | 2.0 h | 1850.0 | 3700.0 | Amy Garbrick | Amy Garbrick | 1823658 | <Binary: 321,127 bytes> | <Binary: 436,864 bytes> | |
060235 | 2016-09-01 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 6 | Trip 1 - To provide clinical services in Southern West Virginia Clinical Services | 307.849061 nmi | 115.32 | 106.0 | 700.0 | 0.0 | 2.0 h | 1850.0 | 3700.0 | Clay Braden Marsh | Amy Garbrick | 1823658 | <Binary: 198,496 bytes> | <Binary: 238,840 bytes> | |
060210 | 2016-09-02 | LBE-LWB-MGW-LBE | King Air B200 | N5AE | 3 | Attend the annual WV Business Summit Attend the annual WV Business Summit. This is the largest gathering of business, industry, financial and political leaders from around the state, | 306.614507 nmi | 121.52 | 76.5 | 100.0 | 0.0 | 2.0 h | 1850.0 | 3700.0 | Amy Garbrick | Amy Garbrick | 1823658 | <Binary: 177,471 bytes> | <Binary: 264,709 bytes> | |
060178 | 2016-08-25 | LBE-MGW-SHD-MGW-LBE | King Air B200 | N5AE | 2 | to attend meeting regarding BRNI To attend mecting with opposing counsel regarding the Blanchette Rockefeller Neuroscience Institute and Daniel Alkon. | 280.567455 nmi | 115.2 | 150.0 | 100.0 | 0.0 | 2.0 h | 1850.0 | 3700.0 | James Robert Alsop | Amy Garbrick | 1823658 | <Binary: 238,469 bytes> | <Binary: 378,474 bytes> | |
060072 | 2016-08-30 | LBE-MGW-LWB-LBE | King Air B200 | N5AE | 2 | Attend the annual WV Business Summit Attend the annual WV Business Summit. This is the largest gathering of business, industry, financial and political leaders from around the state, | 306.614507 nmi | 90.52 | 76.5 | 100.0 | 0.0 | 2.0 h | 1850.0 | 3700.0 | Amy Garbrick | Amy Garbrick | 1823658 | <Binary: 225,745 bytes> | <Binary: 337,206 bytes> | |
059723 | 2016-07-05 | LBE-MGW-IAD-LBE | King Air B200 | N5AE | 5 | Donor relations/fundraising Travel from Morgantown to Dulles airport for a commercial flight out of Dulles, Passengers are traveling overseas for a donor relations/fundraising trip with many other WV donors. President Gee and Mrs. Erickson will travel back on 7/15, Robin and Mr. and Mrs. Hardesty will travel back separately. | 287.033374 nmi | 119.4 | 373.51 | 100.0 | 0.0 | 2.0 h | 1850.0 | 3700.0 | Amy Garbrick | Amy Garbrick | 1823658 | <Binary: 240,646 bytes> | <Binary: 409,024 bytes> | |
059724 | 2016-07-15 | LBE-IAD-MGW-LBE | King Air B200 | N5AE | 2 | Donor relations/fundraising Travel from Morgantown to Dulles airport for a commercial flight out of Dulles, Passengers are traveling overseas for a donor relations/fundraising trip with many other WV donors. President Gee and Mrs. Erickson will travel back on 7/15, Robin and Mr. and Mrs. Hardesty will travel back separately. | 287.033374 nmi | 437.85 | 527.13 | 50.0 | 0.0 | 2.0 h | 1850.0 | 3700.0 | Amy Garbrick | Amy Garbrick | 1823658 | <Binary: 220,883 bytes> | <Binary: 420,792 bytes> | |
059775 | 2016-07-22 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 2 | Attend Alumni fundraiser President Gee and Mrs. Erickson will travel to Charleston, WV and then on to Boone County, Wy for the annual. Boone County Pig Roast. This annual fundraiser is the Boone County Alumni Association Chapter's largest fundraising event. This money is earmarked for scholarships to WVU. Since the chapter's inception, more than 200 scholarships have been awarded. | 307.849061 nmi | 322.98 | 26.0 | 100.0 | 0.0 | 2.0 h | 1850.0 | 3700.0 | Amy Garbrick | Amy Garbrick | 1823658 | <Binary: 263,203 bytes> | <Binary: 377,750 bytes> | |
056921 | 2015-07-21 | LBE-MGW-BKW-LBE | King Air B200 | N5AE | 5 | Travel as part of President Gee's 55-county tour to Logan and Wyoming counties. | 339.231248 nmi | 130.08 | 35.0 | 100.0 | 0.0 | 2.1 h | 1825.0 | 3832.5 | Amy Garbrick | Amy Garbrick | 1914840 | <Binary: 124,528 bytes> | <Binary: 196,747 bytes> | |
060577 | 2016-11-01 | LBE-MGW-CMH-LBE | King Air B200 | N5AE | 1 | Various business meetings in Columbus, OH. See below. meeting with Herb Asher, faculty member at OSU, regarding a book he is writing on E. Gordon Gee's leadership in higher education; meeting with Jeff Kaplan regarding possible collaboration with WVU; meeting with Senior Vice President of Huntington Bank regarding President's Gee's TIAA account and a donation to WVU. | 344.428873 nmi | 110.36 | 75.0 | 100.0 | 0.0 | 2.1 h | 1850.0 | 3885.0 | Amy Garbrick | Amy Garbrick | 1914840 | <Binary: 284,572 bytes> | <Binary: 395,413 bytes> | |
060222 | 2016-09-19 | LBE-MGW-MRB-MGW-LBE | King Air B200 | N5AE | 1 | WV Economic Development Conference President Gee will participate in an education and economic development panel discussion as well as provide the keynote address to the WV Economic Development Conference. The WV Economic Development Council promotes activities to retain and expand current business and industry in West Virginia and to attract new business and industry to West Virginia. This conference was hosted by the Jefferson County Development Authority. Attendees include economic developers throughout the state, as well as state officials. | 270.807801 nmi | 168.72 | 150.0 | 100.0 | 0.0 | 2.1 h | 1850.0 | 3885.0 | Amy Garbrick | Amy Garbrick | 1914840 | <Binary: 189,576 bytes> | <Binary: 273,880 bytes> | |
060355 | 2016-09-27 | LBE-IAD-MRB-MGW-LBE | King Air B200 | N5AE | 5 | American Council on Education Board meeting (in Washington DC) and WVU recruiting event (Martinsburg, WV) President Gee will travel to Washington DC to attend the American Council on Education Board meeting. Following the two-day meeting in DC, President Gee will travel to Martinsburg. WV to speak at the "Meet WV in the Eastern Panhandle" event. Coordinated through the Admissions Office, the Meet WVU events give prospective students and their families an opportunity to learn about majors and minoes, admission requirements, financial aid and scholarships, the Honors College, housing, studying abroad, Adventure WV, the Mountaineer Parents Club and how to apply. | 292.763748 nmi | 165.5 | 586.51 | 100.0 | 0.0 | 2.1 h | 1850.0 | 3885.0 | Amy Garbrick | Amy Garbrick | 1914840 | <Binary: 226,674 bytes> | <Binary: 324,957 bytes> | |
X20220519-1 | 2022-05-19 | LBE-MGW-LWB-MGW | Citation CJ3 | N40WV | 6 | 263.759109 nmi | 1201.2 | 206.5 | 77.5 | 0.0 | 1.4 h | 2788.25 | 3903.55 | 2127600 | ||||||
059447 | 2016-06-02 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 7 | Trip 1 - To provide clinical services in Southern West Virginia Clinical Services | 307.849061 nmi | 44.4 | 131.0 | 700.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | Clay Braden Marsh | Amy Garbrick | 2006023 | <Binary: 195,397 bytes> | <Binary: 204,660 bytes> | |
059478 | 2016-06-13 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 3 | Attend State Journal's Who's Who in WV Business awards luncheon On June 13, President Gee will be honored at this event with the Lorenelle White Lifetime Achievement Award. President Gee will speak at this event with Congresswoman Shelly Moore Capito giving the keynote address. WW sponsored a table at this event. Diane Lewis, WVU BOG menhers and prominent Morgantown businesswoman, attended and sat at WWU's table. Luella Gunter of the WVU Foundation also attended and represented WVU at this event. The State Joumal has built several traditions throughout its 30-gear history. The most prestigious of those is the annual Who's Who in West Virginia Business award, which honors people who make a difference in West Virginia's business climale. | 307.849061 nmi | 70.47 | 106.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | Amy Garbrick | Amy Garbrick | 2006023 | <Binary: 181,780 bytes> | <Binary: 198,227 bytes> | |
059277 | 2016-05-05 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 7 | Trip 1 - To provide clinical services in Southern West Virginia Clinical Services | 307.849061 nmi | 145.6 | 106.0 | 700.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | Clay Braden Marsh | Amy Garbrick | 2006023 | <Binary: 195,628 bytes> | <Binary: 214,187 bytes> | |
X20160406 | 2016-04-06 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 2 | 307.849061 nmi | 0.0 | 106.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160407 | 2016-04-07 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 7 | 307.849061 nmi | 0.0 | 106.0 | 700.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160411 | 2016-04-11 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 3 | 307.849061 nmi | 0.0 | 106.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160428 | 2016-04-28 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 0 | 307.849061 nmi | 130.14 | 106.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160303 | 2016-03-03 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 6 | 307.849061 nmi | 0.0 | 2632.19 | 700.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160204-1 | 2016-02-04 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 6 | 307.849061 nmi | 0.0 | 106.0 | 700.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160207 | 2016-02-07 | LBE-MGW-CMH-MGW-LBE | King Air B200 | N5AE | 2 | 367.019897 nmi | 0.0 | 75.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160212 | 2016-02-12 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 2 | 307.849061 nmi | 0.0 | 373.12 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160217-1 | 2016-02-17 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 3 | 307.849061 nmi | 0.0 | 888.28 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160219-1 | 2016-02-19 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 3 | 307.849061 nmi | 0.0 | 106.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160105 | 2016-01-05 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 1 | 307.849061 nmi | 0.0 | 106.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160113 | 2016-01-13 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 4 | 307.849061 nmi | 0.0 | 132.5 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160119 | 2016-01-19 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 1 | 307.849061 nmi | 0.0 | 26.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20160129 | 2016-01-29 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 1 | 307.849061 nmi | 0.0 | 106.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20151202 | 2015-12-02 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 1 | 307.849061 nmi | 76.72 | 106.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20151209-2 | 2015-12-09 | LBE-MGW-BKW-MGW-LBE | King Air B200 | N5AE | 6 | 339.328971 nmi | 52.08 | 35.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20151215 | 2015-12-15 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 2 | 307.849061 nmi | 34.16 | 106.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20151217 | 2015-12-17 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 6 | 307.849061 nmi | 39.76 | 106.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20151101 | 2015-11-01 | LBE-LWB-MGW-LBE | King Air B200 | N5AE | 2 | 306.614507 nmi | 54.87 | 76.5 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20151105 | 2015-11-05 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 7 | 307.849061 nmi | 62.93 | 106.0 | 700.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20151130 | 2015-11-30 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 1 | 307.849061 nmi | 68.75 | 106.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20150806-2 | 2015-08-06 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 7 | 307.849061 nmi | 53.32 | 106.0 | 700.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20150819 | 2015-08-19 | LBE-MGW-CRW-MGW-LBE | Citation Bravo | N26AP | 3 | 307.849061 nmi | 149.11 | 278.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 3363039 | ||||||
X20150820 | 2015-08-20 | LBE-MGW-LWB-MGW-LBE | King Air B200 | N5AE | 6 | 308.474886 nmi | 64.38 | 76.5 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20150827 | 2015-08-27 | LBE-MGW-BKW-MGW-LBE | King Air B200 | N5AE | 7 | 339.328971 nmi | 44.33 | 35.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
X20150831 | 2015-08-31 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 2 | 307.849061 nmi | 79.98 | 106.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | 2006023 | ||||||
056854 | 2015-07-02 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 4 | Trip 1 - To provide clinical services in Southern West Virginia Clinical Services | 307.849061 nmi | 167.5 | 106.0 | 700.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | Clay Braden Marsh | Amy Garbrick | 2006023 | <Binary: 139,747 bytes> | <Binary: 204,237 bytes> | |
056858 | 2015-07-09 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 3 | Meet with HEPC Chancellor Hill re: Beckley campus | 307.849061 nmi | 152.46 | 252.5 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | Ann Claycomb | Amy Garbrick | 2006023 | <Binary: 134,611 bytes> | <Binary: 182,356 bytes> | |
057040 | 2015-07-28 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 4 | To mect with the State Budget Office and State Auditor to discuss OASIS payroll implementation | 307.849061 nmi | 230.08 | 106.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | Melissa A. Patterson | Amy Garbrick | 2006023 | <Binary: 139,676 bytes> | <Binary: 211,801 bytes> | |
057047 | 2015-07-29 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 1 | Variety of Meetings with Charleston constituents - see attached agenda | 307.849061 nmi | 142.41 | 106.0 | 700.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | Clay Braden Marsh | Amy Garbrick | 2006023 | <Binary: 132,926 bytes> | <Binary: 451,380 bytes> | |
057049 | 2015-07-31 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 2 | CTSI Collaborative meeting - see attached itinerary | 307.849061 nmi | 98.7 | 106.0 | 100.0 | 0.0 | 2.2 h | 1825.0 | 4015.0 | Clay Braden Marsh | Amy Garbrick | 2006023 | <Binary: 131,811 bytes> | <Binary: 3,523,161 bytes> | |
X20151120 | 2015-11-20 | LBE-MGW-CRW-MGW-LBE | Citation V Ultra | N6NY | 3 | 307.849061 nmi | 148.4 | 150.0 | 50.0 | 0.0 | 1.7 h | 2370.0 | 4029.0 | 2963444 | ||||||
X20151120-2 | 2015-11-20 | CRW-CMH-MGW-CRW | Citation V Ultra | N6NY | 1 | 362.763134 nmi | 235.0 | 331.0 | 50.0 | 0.0 | 1.7 h | 2370.0 | 4029.0 | 2963444 | ||||||
060480 | 2016-10-05 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 5 | WV recruiting event in Charleston, WV President Gee will speak at the "Meet WVU in the Kanawha Valley" event, Coordinated through the Admissions Office and University Relations, the Meet WVU events give prospective students and their families a chance to learn about majors and minors, admission requirements, financial aid and scholarships, the Honors College, housing, studying abroad, Adventure WV, the Mountaincer Parents Club and how to apply. While in the Charleston area, President Gee will also do a taping with state-wide media as well as visit with the Charleston Gazette. | 307.849061 nmi | 64.66 | 106.0 | 100.0 | 0.0 | 2.2 h | 1850.0 | 4070.0 | Amy Garbrick | Amy Garbrick | 2006023 | <Binary: 407,807 bytes> | <Binary: 470,287 bytes> | |
060629 | 2016-10-20 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 4 | To provide clinical services in Southern West Virginia Clinical Services | 307.849061 nmi | 115.32 | 106.0 | 700.0 | 0.0 | 2.2 h | 1850.0 | 4070.0 | Clay Braden Marsh | Amy Garbrick | 2006023 | <Binary: 400,411 bytes> | <Binary: 598,219 bytes> | |
060286 | 2016-09-07 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 1 | To attend meeting Kanawha Valley Council meeting To meet with the Upper Kanawha Valley Resiliency and Revitalization Council meeting to discuss moving TECH to Beckley and impact on the community. | 307.849061 nmi | 135.85 | 106.0 | 100.0 | 0.0 | 2.2 h | 1850.0 | 4070.0 | James Robert Alsop | Amy Garbrick | 2006023 | <Binary: 186,997 bytes> | <Binary: 272,336 bytes> | |
060407 | 2016-09-21 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 1 | To attend mectings at the Higher Education Policy Commission and to meet with Senate Education Legislative Staff regarding issues effecting WVU. | 307.849061 nmi | 97.24 | 106.0 | 100.0 | 0.0 | 2.2 h | 1850.0 | 4070.0 | James Robert Alsop | Amy Garbrick | 2006023 | <Binary: 202,944 bytes> | <Binary: 269,843 bytes> | |
060385 | 2016-09-22 | LBE-MGW-HTS-MGW-LBE | King Air B200 | N5AE | 4 | Investiture Ceremony for Marshall University President Jerome Gilbert All passengers will represent WVU at the Investiture Ceremony for Marshall University President Jerome Gilbert. Events include the Investiture Ceremony, followed by luncheon/reception. Later that day, Dean and Mrs. Dunaway will attend dinner and associated events to represent WVU as President Gee and Mrs. Erickson must return to Morgantown for an event on campus that evening. Both Dean Dunaway and President Gilbert were administrators at Mississippi State prior to taking positions in West Virginia. | 379.593501 nmi | 105.04 | 0.0 | 100.0 | 0.0 | 2.2 h | 1850.0 | 4070.0 | Amy Garbrick | Amy Garbrick | 2006023 | <Binary: 208,986 bytes> | <Binary: 298,805 bytes> | |
060043 | 2016-08-04 | LBE-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 6 | Trip 1 - To provide clinical services in Southern West Virginia Clinical Services | 307.849061 nmi | 69.3 | 106.0 | 700.0 | 0.0 | 2.2 h | 1850.0 | 4070.0 | Clay Braden Marsh | Amy Garbrick | 2006023 | <Binary: 272,251 bytes> | <Binary: 393,797 bytes> | |
X20160305 | 2016-03-05 | LBE-MGW-CMH-MGW-LBE | King Air B200 | N5AE | 1 | 367.019897 nmi | 0.0 | 268.0 | 100.0 | 0.0 | 2.3 h | 1825.0 | 4197.5 | 2097206 | ||||||
061033 | 2016-12-15 | LBE-MGW-CRW-MGW-LBE | Citation Bravo | N26AP | 7 | Governor Elect Justice transition team of Healthcare Attend hay-day working session hosted by Governor-elect Justice as he begins his fransition into office. Members of WVU faculty were invited by the Governor's team to participate as experts on difference topics during this think-tank style working session. VP Marsh served as co-chair of the Healthcare Team. | 307.849061 nmi | 221.34 | 256.0 | 100.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | Clay Braden Marsh | Amy Garbrick | 3057309 | <Binary: 424,761 bytes> | <Binary: 1,588,392 bytes> | |
062180 | 2017-05-02 | LBE-MGW-CRW-MGW-LBE | Citation Bravo | N26AP | 6 | See explanation below The overall purpose of the planned travel is to connect leadership representatives of the National Network for Manufacturing Innovation (NNMI) Rapid Advancement in Process Intensification Deployment (RAPID) Institute with research and facilitics leadership in West Virginia, with larger goals of economic and technology development initiatives for the state, utilizing unique facilities and capabilities. NNMI-RAPID is a $100M+ collaboration with the US Department of Energy Advanced Manufacturing Office. The primary destination of the travel is the West Virginia Regional Technology Park (WVRTP), a state-of-the-art facility near Charleston, West Virginia with outstanding available facilities that provide unique opportunities for collaboration between West Virginia businesses, WVU, and NMI-RAPID. While at the WVRIP, representatives of the West Virginia Department of Commerce will join with the team to meet with representatives from NNMI-RAPID, the WVU Energy Institute, and the WV Regional Technology Park. | 307.849061 nmi | 266.34 | 278.0 | 100.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | Joyce Ellen McConnell | Amy Garbrick | 3057309 | <Binary: 382,586 bytes> | <Binary: 999,319 bytes> | |
061950 | 2017-05-04 | LBE-MGW-CRW-MGW-LBE | Citation Bravo | N26AP | 5 | Trip 1 - To provide clinical services in Southern West Virginia Clinical Services | 307.849061 nmi | 171.0 | 278.0 | 700.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | Clay Braden Marsh | Amy Garbrick | 3057309 | <Binary: 389,982 bytes> | <Binary: 654,913 bytes> | |
062343 | 2017-05-16 | LBE-MGW-IAD-MGW-LBE | Citation Bravo | N26AP | 5 | WVU presentation at the Coalition for National Science Funding (CNSF) and Capitol Hill meetings with WV Congressional Delegation | 333.103034 nmi | 145.04 | 687.19 | 100.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | Fred King | Amy Garbrick | 3057309 | <Binary: 394,040 bytes> | <Binary: 1,128,046 bytes> | |
061821 | 2017-03-13 | LBE-MGW-CRW-MGW-LBE | Citation Bravo | N26AP | 6 | Request from Govemor Jim Justice | 307.849061 nmi | 213.52 | 278.0 | 100.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | Clay Braden Marsh | Amy Garbrick | 3057309 | ~~Rob Alsop, VP, Legal Services** Drove instead. Did not fly. AG | <Binary: 170,983 bytes> | <Binary: 1,090,640 bytes> |
061964 | 2017-03-29 | LBE-MGW-BKW-MGW-LBE | Citation Bravo | N26AP | 3 | Narvel, Shannon, Randy and Carolyn are meeting with 1. Kur King to discuss leasing of hotel 2. Jenny Wang to discuss building a residence hall and 3. David McClure to discuss potential lease of apartment building. | 339.328971 nmi | 220.4 | 185.0 | 100.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | Melissa A. Patterson | Amy Garbrick | 3057309 | To discuss WVU Beckley campus facilities opportunities. AG | <Binary: 159,725 bytes> | <Binary: 245,746 bytes> |
063954 | 2017-11-10 | LBE-IAD-MGW-LBE | Citation Bravo | N26AP | 6 | Collaboration between WVU and Education Advisory Board This two-day meeting will be a collaboration between WW and the Education Advisory Board (EAB) to work together to address student success, enrollment, and programm innovation at WVU Agenda for the mecting includes: Kickoff and KAB Partnership Overview - Sally Amoruso, Executive Principal, Office of the Fresident and Hannah Bottigheimer, Executive Advisor Enrollment Management - Alex White, Managing Director, Royall and Company • Building a Best Practice Blueprint • Enrollment Landscape including look at WVU and prumary markets • Ehniding for Future Entering Classes: Search Strategy and Results • 7 key takeaways (pertinent to search, app marketing and yield) Financial Aid for Student Success: Early Findings and Road Ahead - Sarah Panot, Principal Hardwick Day In consultation with Hardwick Day and Student Suocess Collaborative, EAB is investigating the strategie use of aid dollars to support student retention and persistence. This exploration looks at: • Student Segmentation Around Financial Risk • Targeted Recalibration of Aid Awards • Holistic Aid Policy Kequirements • Student-Centered Communication Frogram Innovation: Launching Financially Sustainable Academie Programs Avoiding the Most Damnging Mistakes in New Program Planning Using multi-faceted market demand information to inform program modality desgn and approval processes | 287.033374 nmi | 440.86 | 687.19 | 100.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | Sharon Martin | Amy Garbrick | 3057309 | <Binary: 269,743 bytes> | <Binary: 1,316,277 bytes> | |
061461 | 2017-02-02 | LBE-MGW-CRW-MGW-LBE | Citation Bravo | N26AP | 6 | Trip 1 - To provide clinical services in Southern West Virginia Clinical Services | 307.849061 nmi | 365.82 | 256.0 | 700.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | Clay Braden Marsh | Amy Garbrick | 3057309 | <Binary: 384,155 bytes> | <Binary: 686,949 bytes> | |
061667 | 2017-02-22 | LBE-MGW-CRW-MGW-LBE | Citation Bravo | N26AP | 2 | to attend meetings w/ various legislators To meet with various legislators regarding WVU and human resource issues and the impact of various bills on WVU and human resources. | 307.849061 nmi | 364.08 | 278.0 | 100.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | James Robert Alsop | Amy Garbrick | 3057309 | <Binary: 370,671 bytes> | <Binary: 726,694 bytes> | |
060064 | 2016-08-09 | LBE-MGW-CRW-MGW-LBE | Citation Bravo | N26AP | 2 | Request from FDA Commissioner to be on an Opioid Panel Request to represent WVU on Federal Opioid panel | 307.849061 nmi | 186.75 | 278.0 | 100.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | Clay Braden Marsh | Amy Garbrick | 3057309 | Both Dr Marsh and Dr Sullivan will speak during a roundtable discussion on opioid abuse with Dr. Rubert Califf, commissioner of the Food and Drug Administration | <Binary: 246,559 bytes> | <Binary: 425,893 bytes> |
X20160414 | 2016-04-14 | LBE-MGW-CRW-MGW-LBE | Citation Bravo | N26AP | 1 | 307.849061 nmi | 0.0 | 216.0 | 100.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | 3057309 | ||||||
X20160416-2 | 2016-04-16 | MGW-IAD-LBE | King Air B200 | N5AE | 4 | 242.317597 nmi | 19.2 | 581.3 | 100.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | 1823658 | ||||||
X20160309-1 | 2016-03-09 | LBE-MGW-IAD-MGW-LBE | Citation Bravo | N26AP | 4 | 333.103034 nmi | 0.0 | 744.3 | 100.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | 3057309 | ||||||
X20160322 | 2016-03-22 | LBE-MGW-BKW-MGW-LBE | Citation Bravo | N26AP | 6 | 339.328971 nmi | 12.4 | 185.0 | 100.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | 3057309 |
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") );