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

Fields

| 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|