Last active

Embed URL

HTTPS clone URL

SSH clone URL

You can clone with HTTPS or SSH.

Download Gist

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

View 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|
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.