Name: Ukraine Airspace
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Ukraine Airspace

Context

During the build-up to the Ukrainian invasions, I wrote an API to pull down data every minute from the OpenSky API for a geofence around the Ukraine (42.0, 56.5, 20.74, 46.6) and started collection of flight data in Ukrainian airspace on 2/22/2022. This data set is being continuous collected and will updated daily until I can set up automated upload.

Content

The data contains ICAO 24-bit code, callsign, origin country, time, last contact time, longitude, latitude, barometic altitude, a boolean if the aircraft is one the ground, velocity, heading, vertical_rate, sensors, geo_altitude, squawk, spi, and position source.

Acknowledgements

Thanks to the OpenSky API

Tables

Ukraineflights

@kaggle.rtwillett_ukrainian_airspace.ukraineflights

511.97 MB
22,517,263 rows
17 columns

CREATE TABLE ukraineflights (
  "n_5110c8" VARCHAR  -- 5110c8,
  "atg2101" VARCHAR,
  "estonia" VARCHAR,
  "n_2022_02_22_15_28_35" TIMESTAMP  -- 2022-02-22–15:28:35,
  "n_2022_02_22_15_28_35_1" TIMESTAMP  -- 2022-02-22–15:28:35.1,
  "n_27_1995" DOUBLE  -- 27.1995,
  "n_45_5531" DOUBLE  -- 45.5531,
  "n_4884_42" DOUBLE  -- 4884.42,
  "false" BOOLEAN,
  "n_122_59" DOUBLE  -- 122.59,
  "n_224_49" DOUBLE  -- 224.49,
  "n_0_0" DOUBLE  -- 0.0,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "n_4823_46" DOUBLE  -- 4823.46,
  "n_5565" DOUBLE  -- 5565,
  "false_1" BOOLEAN,
  "n_0" BIGINT  -- 0
);