Dataset: Ukraine Airspace

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

488.25 MB
22517263 rows
17 columns


CREATE TABLE ukraineflights (
  "n_5110c8" VARCHAR,
  "atg2101" VARCHAR,
  "estonia" VARCHAR,
  "n_2022_02_22_15_28_35" TIMESTAMP,
  "n_2022_02_22_15_28_35_1" TIMESTAMP,
  "n_27_1995" DOUBLE,
  "n_45_5531" DOUBLE,
  "n_4884_42" DOUBLE,
  "false" BOOLEAN,
  "n_122_59" DOUBLE,
  "n_224_49" DOUBLE,
  "n_0_0" DOUBLE,
  "unnamed_12" VARCHAR,
  "n_4823_46" DOUBLE,
  "n_5565" DOUBLE,
  "false_1" BOOLEAN,
  "n_0" BIGINT
);