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 date
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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> | |
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> | |
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> | |
056754 | 2015-07-07;2015-07-10 | LBE-MGW-ICT-SFO-RON(1)-SFO-BUR-RON(1)-BUR-CMA-SNA-RON(1)-SNA-DDC-MGW-LBE | Citation Encore | N511TH | 5 | President Gee, Cindi Roth, Laura Tuel, Clay Marsh and Robin Yorty will attend various donor relations meetings in California. Meetings are with donors, alums, and potential donors in the San Francisco, Burbank, Los Angeles and Orange County areas | 4.338679 knmi | 2788.09 | 1535.0 | 2100.0 | 68.0 | 13.7 h | 2420.0 | 33154.0 | Amy Garbrick | Amy Garbrick | 22044807 | <Binary: 674,358 bytes> | <Binary: 212,341 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> | |
056813 | 2015-07-12;2015-07-13 | LBE-MGW-FSD-RON(1)-APA-MGW-LBE | Hawker 900XP | N819JR | 1 | Present NACAA (National Association County Agricultural Agents) Keynote - "Critical Role of Extension in the Evolution of a Modern American Land Grant University" in Sioux Falls, SD. From there, President Gee will have an initial mecting a potential WVU donor in Denver, CO. | 2.465147 knmi | 1300.51 | 736.4 | 700.0 | 4.0 | 7.1 h | 3500.0 | 24850.0 | Amy Garbrick | Amy Garbrick | 16565787 | <Binary: 160,181 bytes> | <Binary: 192,571 bytes> | |
056799 | 2015-07-14 | LBE-CRW-MGW-LBE | Citation V Ultra | N6NY | 1 | Travel to Washington, DC to attend a meeting with Janet Brown, Exec Director, Commission on Presidential Debates, Brian Hemphill (WVSU President) & Mike Stuart (chair of the West Virginia Commission on Presidential Debates) | 306.828192 nmi | 213.2 | 181.0 | 100.0 | 0.0 | 2.0 h | 2370.0 | 4740.0 | Amy Garbrick | Amy Garbrick | 3486405 | <Binary: 107,221 bytes> | <Binary: 218,581 bytes> | |
056798 | 2015-07-14 | LBE-CRW-MGW-IAD-CRW-LBE | King Air B200 | N5AE | 2 | Travel to Washington, DC to attend a meeting with Janet Brown, Exec Director, Commission on Presidential Debates, Brian Hemphill (WVSU President) & Mike Stuart (chair of the West Virginia Commission on Presidential Debates) | 733.82307 nmi | 523.44 | 644.26 | 100.0 | 8.0 | 3.9 h | 1825.0 | 7117.5 | Amy Garbrick | Amy Garbrick | 3556133 | <Binary: 255,007 bytes> | <Binary: 218,581 bytes> | |
056910 | 2015-07-15;2015-07-16 | LBE-MGW-CMH-RON(1)-MRB-MGW-LBE | King Air B200 | N5AE | 1 | Travel to Columbus, OH for meetings related to the OSU Center for Higher Education Enterprise. Following the Columbus appointments, President Gee will travel to Martinsburg, WV for a dinner meeting with the former WVU BOG Chairman, Mr. Jim Dailey. | 548.384194 nmi | 180.44 | 290.0 | 700.0 | 0.0 | 4.0 h | 1825.0 | 7300.0 | Amy Garbrick | Amy Garbrick | 3647316 | <Binary: 152,920 bytes> | <Binary: 190,726 bytes> | |
056868 | 2015-07-17 | LBE-MGW-LAF-MGW-LBE | Citation V Ultra | N6NY | 6 | Visit with Purdue research computing staff Visiting Purdue to meet with their research computing staff to discuss possibilities, ask technical details about the cluster deployments, talk about potential partnerships, etc. | 741.246997 nmi | 399.84 | 150.0 | 100.0 | 0.0 | 3.8 h | 1825.0 | 6935.0 | Ann Claycomb | Amy Garbrick | 6624169 | <Binary: 139,883 bytes> | <Binary: 209,254 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> | |
056974 | 2015-07-24 | LBE-MGW-IAD-MGW-LWB-IAD-MGW-LBE | King Air B200 | N5AE | 2 | Meeting with Congressman McKinley (in Washington, DC wih Rob Alsop) | 717.543052 nmi | 314.03 | 422.52 | 100.0 | 0.0 | 4.6 h | 1825.0 | 8395.0 | James Robert Alsop | Amy Garbrick | 4194413 | <Binary: 290,155 bytes> | <Binary: 218,090 bytes> | |
056937 | 2015-07-27 | LBE-MGW-BKW-LWB-MGW-BKW-MGW-LBE | King Air B200 | N5AE | 4 | Attend HEPC Summit meeting: Beckley Attendance required per HEPC to attend Summit meeting: discussing WVU's move to Beckley area with other local institutions | 608.432716 nmi | 550.44 | 96.5 | 100.0 | 0.0 | 3.8 h | 1825.0 | 6935.0 | Laura Hackett | Amy Garbrick | 3464950 | Missing Gee | <Binary: 278,729 bytes> | <Binary: 640,061 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> | |
X20150802 | 2015-08-02;2015-08-04 | LBE-MGW-DSM-BJC-RON(2)-MGW-LBE | Citation Encore | N511TH | 6 | 2.414505 knmi | 2446.59 | 828.0 | 1400.0 | 20.0 | 7.4 h | 2420.0 | 17908.0 | 11907414 | ||||||
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 | ||||||
X20150806 | 2015-08-06 | LBE-MGW-LWB-CRW-LWB-CRW-LBE | Citation V Ultra | N6NY | 4 | 500.049454 nmi | 386.02 | 461.0 | 100.0 | 0.0 | 3.1 h | 2370.0 | 7347.0 | 5403927 | ||||||
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 | ||||||
X20150807 | 2015-08-07 | LBE-MGW-CRW-LWB-LBE | King Air B200 | N5AE | 3 | 370.604377 nmi | 297.29 | 26.5 | 100.0 | 0.0 | 3.1 h | 1825.0 | 5657.5 | 2826669 | ||||||
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 | |||||
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 | ||||||
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 | ||||||
X20150822 | 2015-08-22 | LBE-MGW-IAD-MGW-LBE | Citation V Ultra | N6NY | 3 | 333.103034 nmi | 262.82 | 726.34 | 100.0 | 0.0 | 2.4 h | 1825.0 | 4380.0 | 4183686 | ||||||
X20150825 | 2015-08-25;2015-08-26 | LBE-MGW-CMH-RON(1)-MGW-LBE | King Air B200 | N5AE | 1 | 367.019897 nmi | 106.33 | 90.0 | 700.0 | 0.0 | 2.4 h | 1825.0 | 4380.0 | 2188389 | ||||||
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 | ||||||
X20151025 | 2015-10-25;2015-10-26 | OUN-AGC-DFW-RON(1)-DFW-MGW-OUN | Citation V Ultra | N6NY | 1 | 3.61694 knmi | 1588.99 | 246.6 | 700.0 | 4.0 | 10.7 h | 2370.0 | 25359.0 | 18652266 | ||||||
X20151025-2 | 2015-10-25;2015-10-27 | LBE-MGW-SDF-OUN-RON(1)-MGW-LBE | Citation V Ultra | N6NY | 7 | 1.842053 knmi | 1946.0 | 470.0 | 700.0 | 28.0 | 5.8 h | 2370.0 | 13746.0 | 10110574 | ||||||
X20151026 | 2015-10-26;2015-10-27 | LBE-MGW-IND-RON(1)-MGW-LBE | Citation Bravo | N26AP | 3 | 678.696795 nmi | 385.66 | 690.0 | 700.0 | 0.0 | 4.0 h | 2150.0 | 8600.0 | 6114618 | ||||||
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 | ||||||
X20151027-2 | 2015-10-27;2015-10-28 | RON(1)-MGW-CRW-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 2 | 481.55079 nmi | 446.71 | 106.0 | 700.0 | 0.0 | 3.2 h | 1825.0 | 5840.0 | 2917852 | ||||||
X20151029 | 2015-10-29 | LBE-MGW-PKB-MGW-LBE | Citation V Ultra | N6NY | 4 | 234.904994 nmi | 119.04 | 213.6 | 100.0 | 0.0 | 2.0 h | 2370.0 | 4740.0 | 3486405 | ||||||
X20151029-2 | 2015-10-29;2015-10-30 | LBE-MGW-GKY-RON(1)-MGW-LBE | Citation V Ultra | N60KM | 1 | 1.949489 knmi | 1275.31 | 75.0 | 700.0 | 0.0 | 6.5 h | 2370.0 | 15405.0 | 11330816 | ||||||
X20151030 | 2015-10-30 | LBE-MGW-LWB-LBE | Citation V Ultra | N6NY | 1 | 306.614507 nmi | 120.9 | 228.0 | 100.0 | 0.0 | 2.0 h | 2370.0 | 4740.0 | 3486405 | ||||||
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 | ||||||
X20151102 | 2015-11-02 | LBE-MGW-LWB-IAD-MGW-LBE | King Air B200 | N5AE | 2 | 473.871572 nmi | 88.04 | 508.76 | 100.0 | 0.0 | 3.2 h | 1825.0 | 5840.0 | 2917852 | ||||||
X20151104 | 2015-11-04;2015-11-05 | LBE-MGW-CMH-RON(1)-MGW-LBE | Citation V Ultra | N60KM | 1 | 367.019897 nmi | 131.75 | 315.0 | 700.0 | 0.0 | 4.0 h | 2370.0 | 9480.0 | 6972810 | ||||||
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 | ||||||
X20151108 | 2015-11-08;2015-11-09 | LBE-MGW-LWC-RON(1)-MGW-LBE | Citation Bravo | N26AP | 1 | 1.510818 knmi | 1103.12 | 150.0 | 700.0 | 0.0 | 5.1 h | 2150.0 | 10965.0 | 7796137 | ||||||
X20151110 | 2015-11-10 | LBE-MGW-BKW-MGW-LBE | Citation V Ultra | N60KM | 7 | 339.328971 nmi | 127.84 | 185.0 | 100.0 | 0.0 | 2.1 h | 2370.0 | 4977.0 | 3660725 | ||||||
X20151114 | 2015-11-14 | LBE-MGW-MDW-LBE | Citation V Ultra | N60KM | 4 | 812.215057 nmi | 276.83 | 344.33 | 100.0 | 0.0 | 3.0 h | 2370.0 | 7110.0 | 5229607 | ||||||
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 | ||||||
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 | ||||||
X20151116 | 2015-11-16 | LBE-IND-RON(1)-MGW-IAD-MGW-LBE | Citation Bravo | N889B | 7 | 901.601195 nmi | 737.24 | 1251.47 | 700.0 | 0.0 | 4.3 h | 2150.0 | 9245.0 | 6573214 | ||||||
X20151118-1 | 2015-11-18 | LBE-MDW-MGW-LBE | Citation Bravo | N26AP | 4 | 812.215057 nmi | 267.43 | 479.37 | 100.0 | 0.0 | 3.2 h | 2150.0 | 6880.0 | 4891694 | ||||||
X20151118-2 | 2015-11-18 | LBE-MGW-IND-MGW-LBE | Citation V Ultra | N6NY | 5 | 678.696795 nmi | 327.38 | 525.0 | 100.0 | 0.0 | 3.0 h | 2370.0 | 7110.0 | 5229607 | ||||||
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 | ||||||
X20151123 | 2015-11-23 | LBE-IAD-MGW-LBE | Citation Encore | N511TH | 6 | 287.033374 nmi | 82.04 | 726.34 | 100.0 | 0.0 | 2.0 h | 2420.0 | 4840.0 | 3218220 | ||||||
X20151125 | 2015-11-25 | LBE-MGW-MSY-LBE | Citation Encore | N511TH | 1 | 1.629473 knmi | 357.92 | 457.0 | 100.0 | 0.0 | 4.7 h | 2420.0 | 11374.0 | 7562817 | ||||||
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 | ||||||
X20151201 | 2015-12-01 | LBE-MGW-HTS-MGW-LBE | King Air B200 | N5AE | 2 | 379.593501 nmi | 61.6 | 0.0 | 100.0 | 0.0 | 2.6 h | 1825.0 | 4745.0 | 2370755 | ||||||
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 | ||||||
X20151203-1 | 2015-12-03 | LBE-MGW-IAD-MGW-LBE | Citation Bravo | N26AP | 1 | 333.103034 nmi | 122.08 | 716.47 | 700.0 | 0.0 | 2.1 h | 2150.0 | 4515.0 | 3210174 | ||||||
X20151203-2 | 2015-12-03 | LBE-MGW-CRW-MGW-LBE | Citation V Ultra | N60KM | 7 | 307.849061 nmi | 140.28 | 278.0 | 700.0 | 0.0 | 2.0 h | 2370.0 | 4740.0 | 3486405 | ||||||
X20151207 | 2015-12-07 | LBE-MGW-TEB-LBE | King Air B200 | N5AE | 7 | 568.799075 nmi | 196.23 | 319.0 | 100.0 | 0.0 | 2.9 h | 1825.0 | 5292.5 | 2644304 | ||||||
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 | ||||||
X20151209-1 | 2015-12-09;2015-12-10 | LBE-TEB-MGW-ICT-PHX-RON(1)-ICT-MGW-LBE | Citation Encore | N511TH | 11 | 3.735264 knmi | 1239.72 | 850.05 | 700.0 | 56.0 | 11.5 h | 2420.0 | 27830.0 | 18504765 | ||||||
X20151210 | 2015-12-10 | LBE-MGW-TEB-MGW-LBE | King Air B200 | N5AE | 6 | 645.323216 nmi | 87.36 | 469.0 | 100.0 | 0.0 | 3.4 h | 1825.0 | 6205.0 | 3100218 | ||||||
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 | ||||||
X20151216-1 | 2015-12-16 | LBE-MGW-IAD-MGW-LBE | Citation Encore | N511TH | 2 | 333.103034 nmi | 60.48 | 736.34 | 100.0 | 0.0 | 2.0 h | 2420.0 | 4840.0 | 3218220 | ||||||
X20151216-2 | 2015-12-16 | LBE-OSU-MGW-OSU-LBE | King Air B200 | N5AE | 7 | 632.858351 nmi | 139.46 | 70.0 | 100.0 | 0.0 | 3.2 h | 1825.0 | 5840.0 | 2917852 | ||||||
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 | ||||||
X20151218 | 2015-12-18 | LBE-MGW-CRW-LWB-CMH-LBE | King Air B200 | N5AE | 4 | 552.498205 nmi | 462.4 | 150.0 | 100.0 | 0.0 | 3.4 h | 1825.0 | 6205.0 | 3100218 | ||||||
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 | ||||||
X20151221 | 2015-12-21 | LBE-MGW-OSU-MGW-LBE | King Air B200 | N5AE | 2 | 384.944257 nmi | 26.74 | 70.0 | 100.0 | 0.0 | 2.5 h | 1825.0 | 4562.5 | 2279572 | ||||||
X20151231 | 2015-12-31;2016-01-03 | LBE-MGW-CRW-LWB-PHX-RON(3)-CRW-MGW-LBE | Hawker 900XP | N819JR | 7 | 3.430655 knmi | 1473.72 | 1029.23 | 2100.0 | 28.0 | 10.6 h | 3500.0 | 37100.0 | 24732020 | ||||||
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 | ||||||
X20160112 | 2016-01-12 | LBE-MGW-DTW-MGW-LBE | King Air B200 | N5AE | 5 | 527.919984 nmi | 318.19 | 130.81 | 100.0 | 0.0 | 3.2 h | 1825.0 | 5840.0 | 2917852 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
X20160121 | 2016-01-21 | LBE-MGW-XNA-LBE | Citation Encore | N511TH | 4 | 1.495268 knmi | 279.3 | 75.0 | 100.0 | 0.0 | 4.5 h | 2420.0 | 10890.0 | 7240995 | ||||||
X20160125 | 2016-01-25;2016-01-26 | LBE-PIT-MGW-CMH-ADS-SUS-RON(1)-MGW-PIT-LBE | Citation Excel | N58LQ | 8 | 2.07605 knmi | 670.42 | 1589.4 | 700.0 | 64.0 | 7.4 h | 3150.0 | 23310.0 | 16405770 | ||||||
X20160127-1 | 2016-01-27;2016-01-28 | LBE-MGW-TEB-RON(1)-MGW-LBE | Citation V Ultra | N60KM | 1 | 645.323216 nmi | 0.0 | 740.05 | 700.0 | 0.0 | 4.0 h | 2370.0 | 9480.0 | 6972810 | ||||||
X20160127-2 | 2016-01-27;2016-01-28 | LBE-MGW-CMH-RON(1)-MGW-LBE | King Air B200 | N5AE | 1 | 367.019897 nmi | 0.0 | 259.0 | 700.0 | 0.0 | 4.0 h | 1825.0 | 7300.0 | 3647316 | ||||||
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 | ||||||
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 | ||||||
X20160204-2 | 2016-02-04 | LBE-MGW-DFW-RON(1)-MGW-LBE | Citation Encore | N511TH | 1 | 1.930105 knmi | 156.24 | 130.64 | 700.0 | 0.0 | 5.8 h | 2420.0 | 14036.0 | 9332838 | ||||||
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 | ||||||
X20160209 | 2016-02-09;2016-02-10 | LBE-MGW-DFW-RON(1)-SRQ-PBI-LBE | Citation Encore | N511TH | 1 | 2.740489 knmi | 447.06 | 1949.72 | 700.0 | 8.0 | 8.3 h | 2420.0 | 20086.0 | 13355613 | ||||||
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 | ||||||
X20160217-2 | 2016-02-17 | LBE-CRW-MGW-LBE | Citation Bravo | N26AP | 1 | 306.828192 nmi | 0.0 | 181.0 | 100.0 | 0.0 | 2.0 h | 2150.0 | 4300.0 | 3057309 | ||||||
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 | ||||||
X20160219-2 | 2016-02-19;2016-02-21 | LBE-CRW-DAL-RON(1)-SGR-RON(1)-MGW-LBE | Citation Encore | N511TH | 5 | 2.195335 knmi | 310.05 | 638.0 | 1400.0 | 28.0 | 7.1 h | 2420.0 | 17182.0 | 11424681 | ||||||
X20160223 | 2016-02-23 | LBE-MGW-IAD-MGW-LBE | King Air B200 | N5AE | 2 | 333.103034 nmi | 0.0 | 456.51 | 100.0 | 0.0 | 2.4 h | 1825.0 | 4380.0 | 2188389 | ||||||
X20160225-1 | 2016-02-25 | LBE-MGW-CRW-MGW-LBE | Citation V Ultra | N60KM | 1 | 307.849061 nmi | 0.0 | 358.0 | 100.0 | 0.0 | 2.0 h | 2370.0 | 4740.0 | 3486405 | ||||||
X20160225-2 | 2016-02-25;2016-02-28 | LBE-MGW-CRW-APF-RON(3)-MGW-LBE | Citation Encore | N511TH | 9 | 1.74775 knmi | 1046.29 | 546.0 | 2100.0 | 24.0 | 8.0 h | 2420.0 | 19360.0 | 12872880 | ||||||
X20160229 | 2016-02-29 | LBE-MGW-CRW-MGW-CRW-MGW-LBE | King Air B200 | N5AE | 7 | 526.266567 nmi | 72.0 | 212.0 | 100.0 | 0.0 | 3.6 h | 1825.0 | 6570.0 | 3282584 | ||||||
X20160302 | 2016-03-02 | LBE-MGW-IAD-MGW-LBE | King Air B200 | N5AE | 1 | 333.103034 nmi | 0.0 | 456.51 | 700.0 | 0.0 | 2.4 h | 1825.0 | 4380.0 | 2188389 | ||||||
X20160302-2 | 2016-03-02 | LBE-MGW-BOS-MGW-LBE | Citation V Ultra | N60KM | 2 | 960.115194 nmi | 478.72 | 1031.31 | 100.0 | 0.0 | 3.6 h | 2430.0 | 8748.0 | 6275529 | ||||||
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 | ||||||
X20160304 | 2016-03-04 | LBE-MGW-IAD-MGW-LBE | Citation V Ultra | N60KM | 2 | 333.103034 nmi | 0.0 | 755.16 | 100.0 | 0.0 | 2.0 h | 2370.0 | 4740.0 | 3486405 | ||||||
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 | ||||||
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 | ||||||
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 |
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") );