Fatal Aviation Accidents And Fatalities
@owid.aviation_statistics
@owid.aviation_statistics
CREATE TABLE owid_aviation_statistics_1 (
"country" VARCHAR,
"year" INTEGER,
"accidents_per_million_flights" FLOAT,
"accidents_with_passenger_and_cargo_flights_including_h_4ce80091" INTEGER,
"departures_worldwide" FLOAT,
"fatalities_per_million_flights" FLOAT,
"fatalities_per_million_passengers" FLOAT,
"fatalities_with_passenger_and_cargo_flights_including__d2fe2e2b" INTEGER,
"hijacking_fatalities" INTEGER,
"hijacking_incidents" INTEGER,
"million_flights_per_accident" FLOAT,
"million_passengers_per_fatality" FLOAT,
"passengers_carried" FLOAT
);
CREATE TABLE owid_aviation_statistics_2 (
"country" VARCHAR,
"year" INTEGER,
"accidents_per_million_flights" FLOAT,
"accidents_with_passenger_and_cargo_flights_including_h_4ce80091" INTEGER,
"departures_worldwide" UINTEGER,
"fatalities_per_million_flights" FLOAT,
"fatalities_per_million_passengers" FLOAT,
"fatalities_with_passenger_and_cargo_flights_including__d2fe2e2b" INTEGER,
"hijacking_fatalities" INTEGER,
"hijacking_incidents" INTEGER,
"million_flights_per_accident" FLOAT,
"million_passengers_per_fatality" FLOAT,
"passengers_carried" BIGINT
);
CREATE TABLE owid_aviation_statistics_3 (
"country" VARCHAR,
"year" INTEGER,
"accidents_per_million_flights" FLOAT,
"accidents_with_passenger_and_cargo_flights_including_h_4ce80091" INTEGER,
"departures_worldwide" UINTEGER,
"fatalities_per_million_flights" FLOAT,
"fatalities_per_million_passengers" FLOAT,
"fatalities_with_passenger_and_cargo_flights_including__d2fe2e2b" INTEGER,
"hijacking_fatalities" INTEGER,
"hijacking_incidents" INTEGER,
"million_flights_per_accident" FLOAT,
"million_passengers_per_fatality" FLOAT,
"passengers_carried" BIGINT
);
Anyone who has the link will be able to view this.