flightdata

Data license: Open Database License (ODbL)

Custom SQL query

Queries

Tables

fd_baltimore

PurchaseActive, metaData_properties_vendorName, flifo_scheduledArrivalTimeLocal, isSubscriptionAvailable, flifo_flightMapPath, flifo_arrivalTerminal, internet_timeRemaining, metaData_properties_Mac, flifo_departureConcourse, flifo_flightNumber, isPortalInitialized, flifo_groundSpeedMPH, host, ShowCoverageArea, flifo_scheduledDepartureTime, flifo_originState, weather_currently_lowtempc, metaData_properties_UserAgent, flifo_originAirportCode, flifo_arrivalConcourse, flifo_actualDepartureTime, flifo_airTemperatureC, devicePlatform, internet_accessType, internet_tier, version, weather_currently_hightempc, flifo_scheduledDepartureTimeLocal, flifo_flightStatus, metaData_properties_version, internet_fulfilmentState, weather_currently_hightempf, flifo_destinationAirportCode, internetConnectionIsAvailable, metaData_properties_IpAddress, metaData_properties_vendor, flifo_departureGate, flifo_airTemperatureF, flifo_estimatedArrivalTime, flifo_departureTerminal, flifo_originCity, flifo_actualArrivalTimeLocal, flifo_estimatedDepartureTimeLocal, flifo_actualDepartureTimeLocal, weather_currently_day, flightOffersInternetService, metaData_properties_FramedIp, flifo_aircraftModel, VendorCode, flifo_estimatedArrivalTimeLocal, internet_orderState, flifo_windDirection, VendorName, isPDEServiceAvailable, flifo_flightDurationMinutes, flifo_noseNumber, flifo_scheduledArrivalTime, weather_currently_lowtempf, CoverageMessage, internet_tierDescription, flifo_destinationCity, deviceCAS, weather_currently_currtempc, weather_currently_text, flifo_altitudeMeters, flifo_destinationState, flifo_arrivalGate, weather_forecast, flifo_equipmentCode, IsLoggedIn, flifo_groundSpeedKPH, flifo_tailNumber, flifo_altitudeFt, metaData_properties_Content-Type, weather_currently_currtempf, flifo_airSpeedKPH, flifo_airSpeedMPH, weather_currently_code, flifo_flightGuid, flifo_timeRemainingToDestination, flifo_isFake

95 rows

fd_chicago

flifo_estimatedArrivalTime, internet_tierDescription, flifo_departureTerminal, metaData_properties_version, flifo_flightNumber, flifo_airTemperatureC, flifo_flightGuid, host, CoverageMessage, metaData_properties_vendorName, PurchaseActive, flightOffersInternetService, devicePlatform, flifo_actualDepartureTime, flifo_altitudeFt, metaData_properties_IpAddress, IsLoggedIn, flifo_departureGate, metaData_properties_Content-Type, metaData_properties_FramedIp, flifo_airSpeedMPH, isPortalInitialized, flifo_scheduledArrivalTime, internet_orderState, flifo_equipmentCode, flifo_airTemperatureF, flifo_altitudeMeters, flifo_actualDepartureTimeLocal, flifo_isFake, isSubscriptionAvailable, isPDEServiceAvailable, flifo_estimatedArrivalTimeLocal, flifo_noseNumber, flifo_aircraftModel, VendorCode, VendorName, flifo_groundSpeedKPH, flifo_tailNumber, flifo_originCity, flifo_timeRemainingToDestination, flifo_scheduledArrivalTimeLocal, flifo_groundSpeedMPH, internet_timeRemaining, weather_currently_currtempf, flifo_destinationState, flifo_originAirportCode, metaData_properties_UserAgent, internetConnectionIsAvailable, flifo_arrivalGate, flifo_departureConcourse, weather_currently_currtempc, weather_currently_lowtempc, weather_currently_lowtempf, flifo_arrivalTerminal, weather_currently_hightempf, metaData_properties_Mac, deviceCAS, flifo_flightMapPath, internet_accessType, weather_currently_hightempc, flifo_flightDurationMinutes, flifo_actualArrivalTimeLocal, flifo_flightStatus, flifo_scheduledDepartureTime, ShowCoverageArea, version, weather_currently_text, flifo_windDirection, flifo_destinationAirportCode, metaData_properties_vendor, flifo_destinationCity, internet_tier, flifo_originState, weather_currently_code, flifo_scheduledDepartureTimeLocal, flifo_estimatedDepartureTimeLocal, weather_forecast, weather_currently_day, flifo_arrivalConcourse, flifo_airSpeedKPH, internet_fulfilmentState

403 rows

fd_denver

internet_tier, flifo_scheduledArrivalTimeLocal, host, flifo_isFake, flifo_flightDurationMinutes, flifo_actualDepartureTimeLocal, internetConnectionIsAvailable, flifo_departureGate, weather_currently_lowtempf, flifo_destinationAirportCode, weather_currently_day, flifo_arrivalConcourse, flifo_aircraftModel, flifo_windDirection, weather_currently_text, internet_timeRemaining, flifo_arrivalTerminal, metaData_properties_MileagePlusId, flifo_scheduledArrivalTime, weather_forecast, flifo_altitudeFt, flifo_originState, IsLoggedIn, flifo_flightNumber, isPortalInitialized, flifo_flightGuid, ShowCoverageArea, weather_currently_code, metaData_properties_version, isSubscriptionAvailable, internet_orderState, flifo_airSpeedMPH, flifo_estimatedArrivalTime, flifo_airSpeedKPH, metaData_tags, PurchaseActive, flifo_airTemperatureC, flifo_arrivalGate, metaData_properties_IsDeviceHasActiveTimedProductOfSameAccessPlan, metaData_properties_TransactionId, flifo_equipmentCode, weather_currently_hightempf, metaData_properties_Channel, metaData_properties_FramedIp, metaData_properties_Mac, devicePlatform, flifo_actualDepartureTime, flifo_estimatedArrivalTimeLocal, flifo_scheduledDepartureTimeLocal, weather_currently_currtempc, flifo_flightStatus, flifo_tailNumber, flifo_originAirportCode, CoverageMessage, weather_currently_currtempf, deviceCAS, flifo_estimatedDepartureTimeLocal, flifo_actualArrivalTimeLocal, flifo_originCity, flifo_groundSpeedKPH, isPDEServiceAvailable, weather_currently_hightempc, flightOffersInternetService, flifo_altitudeMeters, metaData_properties_vendorName, flifo_timeRemainingToDestination, VendorName, metaData_properties_IpAddress, metaData_properties_Content-Type, internet_tierDescription, weather_currently_lowtempc, internet_fulfilmentState, flifo_departureConcourse, metaData_properties_UserAgent, flifo_destinationCity, flifo_noseNumber, metaData_properties_vendor, flifo_destinationState, flifo_flightMapPath, internet_accessType, flifo_groundSpeedMPH, flifo_departureTerminal, VendorCode, version, flifo_airTemperatureF, flifo_scheduledDepartureTime

923 rows

fd_portland

flifo_actualDepartureTimeLocal, flifo_scheduledArrivalTimeLocal, flifo_departureGate, metaData_properties_UserAgent, weather_forecast, internet_tierDescription, flifo_tailNumber, flifo_arrivalTerminal, host, metaData_properties_vendorName, flifo_groundSpeedMPH, IsLoggedIn, internetConnectionIsAvailable, flifo_destinationState, flifo_flightNumber, weather_currently_code, flifo_departureConcourse, weather_currently_hightempc, deviceCAS, flifo_scheduledDepartureTimeLocal, flifo_flightGuid, internet_timeRemaining, weather_currently_lowtempc, flifo_scheduledArrivalTime, flifo_originState, flifo_flightMapPath, flifo_scheduledDepartureTime, weather_currently_currtempc, weather_currently_text, flifo_originAirportCode, CoverageMessage, flifo_estimatedDepartureTimeLocal, metaData_properties_Content-Type, flifo_airTemperatureC, flifo_originCity, VendorCode, flifo_aircraftModel, flifo_altitudeMeters, flifo_noseNumber, flifo_airSpeedMPH, metaData_properties_IpAddress, weather_currently_lowtempf, isPortalInitialized, flifo_estimatedArrivalTime, version, metaData_properties_FramedIp, isPDEServiceAvailable, flifo_flightDurationMinutes, flifo_arrivalGate, internet_tier, flifo_departureTerminal, metaData_properties_Mac, flifo_airTemperatureF, flightOffersInternetService, flifo_windDirection, flifo_airSpeedKPH, flifo_destinationAirportCode, flifo_flightStatus, flifo_timeRemainingToDestination, isSubscriptionAvailable, metaData_properties_vendor, weather_currently_currtempf, internet_orderState, flifo_actualDepartureTime, flifo_arrivalConcourse, devicePlatform, flifo_equipmentCode, flifo_actualArrivalTimeLocal, VendorName, internet_fulfilmentState, metaData_properties_version, flifo_altitudeFt, internet_accessType, weather_currently_hightempf, flifo_isFake, flifo_groundSpeedKPH, flifo_destinationCity, ShowCoverageArea, PurchaseActive, weather_currently_day, flifo_estimatedArrivalTimeLocal

858 rows

Download SQLite DB: flightdata.db 4.1 MB