Create a gist now

Instantly share code, notes, and snippets.

@sweetieSong /Fields
Last active Dec 19, 2015

What would you like to do?
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