public
Last active

The fields that were downloaded from the flights website. The corresponding name in MongoDB document. The data type in MongoDB.

  • Download Gist
Fields
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64
| FAA fields | MongoDB field | Data Type |
| :========: | :===========: | :=======: |
| Year | year | int |
| Quarter | quarter | int |
| Month | month | int |
| Day of Month | dayOfMonth | int |
| Day of Week | dayOfWeek | int |
| Flight Date | date | ISODate |
 
| Unique Carrier ID | carrierId | String |
| Airline ID | airlineId | int |
| Carrier | carrier | String |
| TailNum | tailNum | String |
| FlightNum | flightNum | int |
 
| OriginAirportID | origAirportId | int |
| OriginCityMarketID | origCityId | int |
| Origin | origAirport | String
| Origin City Name | origCity | String |
| Origin State (Code) | origStateId | String |
| Origin State Name | origState | String |
| Origin Airport, World Area Code | origWAC | int |
 
| DestAirportID | destAirportId | int |
| DestCityMarketID | destCityId | int |
| Dest | destAirport | String |
| Dest City Name | destCity | String |
| Dest State (Code) | destStateId | String |
| Dest State Name | destState | String |
| Dest Airport, World Area Code | destWAC | int |
 
| CRS Departure Time | crsDepTime | ISODate |
| DepTime | depTime | ISODate |
| DepDelay | depDelay | int |
| TaxiOut | taxiOut | int |
| Wheels Off | wheelsOff | ISODate |
 
| Wheels On | wheelsOn | ISODate |
| Taxi In | taxiIn | int |
| CRSArrTime | crsArrTime | ISODate |
| ArrTime | arrTime | ISODate |
| ArrDelay | arrDelay | int |
 
| Cancelled | not included | |
| CancellationCode | cancelCode | int |
| Diverted | diverted | boolean |
 
| CRSElapsedTime | crsElapsedTime | int |
| ActualElapsedTime | elapsedTime | int |
| AirTime | airTime | ISODate |
| Flights | numFlights | int |
| Distance | distance | int |
 
| CarrierDelay | carrierDelay | int |
| WeatherDelay | weatherDelay | int |
| NASDelay | nasDelay | int |
| SecurityDelay | securityDelay | int |
| LateAircraftDelay | lateAircraftDelay | int |
 
| DivAirportLanding | numDivAirportLandings | int |
| DivReachedDest | divReachedDest | int |
| DivActualElapsedTime | divElapsedTime | int |
| DivArryDelay | divArrDelay | int |
| DivDistance | divDistance | int|

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.