Last Trip:
Next Trip:
Commuting - Union
Flight / N526AS
Seat 30A / Window / Coach Class
Commuting - Union
Flight / N520AS
Seat 16D / Aisle / Coach Class
flights
airports
airlines
aircraft
Flight Time | 10 h 24 m |
---|---|
Flight Time (w/ layovers) | 10 h 24 m |
Trip Length | 4 d 21 h 32 m |
% Flying | 8.8% of trip |
% Flying (w/ layovers) | 8.8% of trip |
Flight Types | |
---|---|
Commuting - Union | 2 |
Query Template: /flights/trips/include_trip.cfm:39 Execution Time: 2.66 ms Record Count: 1 Cached: No Lazy: No SQL: SELECT *, convert_tz(startdate, 'UTC', 'America/Los_Angeles') AS startdate_local, convert_tz(enddate, 'UTC', 'America/Los_Angeles') AS enddate_local FROM blog.trips WHERE tripnumber = 393 | ||||||||||||||||||||||||||||
entry | tripnumber | startdate | enddate | flts_num | airports_num | airports_list | full_routing | flt_length_mins | trip_length_mins | cal_days_flown | miles_total | miles_avg | miles_per_flight_avg | airlines_num | airlines_list | aircraft_num | aircraft_list | uq_field | ty_pers | ty_crew | ty_co_u | ty_co_c | ty_comp | times | startdate_local | enddate_local | ||
1 | 392 | 393 | {ts '2013-02-03 21:30:00'} | {ts '2013-02-08 19:02:00'} | 2 | 2 | LAX,DCA | LAX,DCA,LAX | 37440 | 423120 | 2 | 4622 | 2311 |
| 1 | Alaska Airlines | 2 | N526AS,N520AS | 20130203213020130208110237440423120246222311212002002 | 0 | 0 | 2 | 0 | 0 | {"COLUMNS":["city","secondshere","ord"],"DATA":[["DCA",385680,2234]]} | {ts '2013-02-03 13:30:00'} | {ts '2013-02-08 11:02:00'} |
Time Spent | |||
---|---|---|---|
Flight Time | 10 h 24 m | 8.85% |
|
DCA | 4 d 11 h 8 m | 91.15% |
|