Download Flight Data

Click one of the buttons below to download the flight data in the format of your choice. Remember, all flight data is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Weather information from OpenWeatherMap, which is made available here under the Open Database License (ODbL). You are encouraged to analyse this data. Just make sure to give credit to users who uploaded the data. Also, if you distribute any works directly based on this data, you must distribute them under a similar license.

File Structure

The downloaded file contains the fields listed below. All times are in local except for the times for comments, which are in UTC. The date and time fields should appear as actual dates and times in the spreadsheet. If they show up as #########, expand the column to view the date.

• flightID: identification number for the flight, important for record keeping and for accessing the flight through the API
• genus: flight genus
• species: flight species
• confidence_level: reporting user's confidence in species identification
• date_of_Flight: date and time that the flight occurred
• latitude: latitude of flight
• longitude: longitude of flight
• flight_size: size of the flight observed (either single queen or many queens)
• reported_by: username of the user who reported the flight, use this to give credit to the original user
• user_professional: indicates whether the reporting user is a professional
• user_flagged: indicates whether the reporting user account has been flagged and suspended
• date_recorded: date and time when the flight was recorded
• image: URL of the image, if the flight has an image
• desc: short weather description
• longDesc: long weather description
• temperature: temperature at approximately the time of flight (°C)
• pressure: pressure at approximately the time of flight (hPa)
• pressureSea: pressure at sea level (hPa)
• pressureGround: pressure at ground level (hPa)
• humidity: humidity level (%)
• tempMin: minimum temperature (°C)
• tempMax: maximum temperature (°C)
• clouds: cloud cover (%)
• sunrise: time of sunrise
• sunset: time of sunset
• rain1: amount of rain in previous hour (mm)
• rain3: amount of rain in previous three hours (mm)
• windSpeed: speed of wind (m/s)
• windDegree: wind direction (°)
• time_weather_fetched: time that the weather was loaded
• author_n: username of the n^th comment
• text_n: text of the n^th comment
• time_n: time of the n^th comment

Weather Fields

The fields that constitute "Weather Information" are desc, longDesc, temperature, pressure, pressureSea, pressureGround, humidity, tempMin, tempMax, clouds, sunrise, sunset, rain1, rain3, windSpeed, windDegree and time_weather_fetched. The information in these fields was fetched from OpenWeatherMap. This data is licensed under the Open Database License (ODbL).