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
0 rows where signed_by_name = "David Theodore Zmuda"
This data as json
0 records
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") );