Skip to content

Embed URL

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
The fields that were downloaded from the flights website. The corresponding name in MongoDB document. The data type in MongoDB.
| 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.