| Field | Type | Description | Example |
|---|---|---|---|
| DATE | DATE | Date | 2022-07-01 |
| HOUR | VARCHAR(5) | Hour | 11:00 |
| AIRPORT | VARCHAR(50) | IATA airport code | SFO |
| AIRPORT_NAME | VARCHAR(50) | Airport name | San Francisco International |
| LATITUDE | FLOAT | Latitude of the airport | 37.6194 |
| LONGITUDE | FLOAT | Longitude of the airport | -122.3728 |
| CITY | VARCHAR(50) | City name | San Francisco |
| STATE | VARCHAR(2) | State code | CA |
| ARR_FLIGHTS | NUMBER(10,0) | Number of arriving flights | 38 |
| PAX_ARRIVAL | NUMBER(10,0) | Number of total arriving passengers | 5128 |
| PAX_STAY | NUMBER(10,0) | Number of locally arriving passengers | 5007 |
| DEP_FLIGHTS | NUMBER(10,0) | Number of departing flights | 36 |
| PAX_DEPARTURE | NUMBER(10,0) | Number of total departing passengers | 4919 |
| PAX_ENTRY | NUMBER(10,0) | Number of locally departing passengers | 4879 |
Flight BI
Flight Business Intelligence