FieldTypeDescriptionExample
DATEDATEDate2022-07-01
HOURVARCHAR(5)Hour11:00
AIRPORTVARCHAR(50)IATA airport codeSFO
AIRPORT_NAMEVARCHAR(50)Airport nameSan Francisco International
LATITUDEFLOATLatitude of the airport37.6194
LONGITUDEFLOATLongitude of the airport-122.3728
CITYVARCHAR(50)City nameSan Francisco
STATEVARCHAR(2)State codeCA
ARR_FLIGHTSNUMBER(10,0)Number of arriving flights38
PAX_ARRIVALNUMBER(10,0)Number of total arriving passengers5128
PAX_STAYNUMBER(10,0)Number of locally arriving passengers5007
DEP_FLIGHTSNUMBER(10,0)Number of departing flights36
PAX_DEPARTURENUMBER(10,0)Number of total departing passengers4919
PAX_ENTRYNUMBER(10,0)Number of locally departing passengers4879