The Economist's Ukraine War-fire (daily Update)
Daily updated. Check out the files ukraine_fires.csv and ukraine_war_fires.csv
@kaggle.joebeachcapital_the_economists_ukraine_war_fire_daily_update
Daily updated. Check out the files ukraine_fires.csv and ukraine_war_fires.csv
@kaggle.joebeachcapital_the_economists_ukraine_war_fire_daily_update
CREATE TABLE cloud_cover_in_ukraine_by_day (
"date" TIMESTAMP,
"cloud_cover_in_country" DOUBLE,
"cloud_cover_in_east_of_country" DOUBLE
);
CREATE TABLE cloud_cover_in_ukraine_by_day_with_forecast_for_recent_days (
"date" TIMESTAMP,
"cloud_cover_in_country" DOUBLE,
"cloud_cover_in_east_of_country" DOUBLE
);
CREATE TABLE control_status_of_fires_ii (
"latitude" DOUBLE,
"longitude" DOUBLE,
"date" TIMESTAMP,
"acq_time" BIGINT,
"in_ukraine_held_area" BIGINT
);
CREATE TABLE dates_of_successfully_acquired_fire_data (
"da" BIGINT,
"es" VARCHAR
);
CREATE TABLE firms_update (
"country_id" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"scan" DOUBLE,
"track" DOUBLE,
"acq_date" TIMESTAMP,
"acq_time" BIGINT,
"satellite" VARCHAR,
"instrument" VARCHAR,
"confidence" VARCHAR,
"version" VARCHAR,
"frp" DOUBLE,
"daynight" VARCHAR
);
CREATE TABLE strikes_by_location_and_day (
"date" TIMESTAMP,
"cloud_cover_in_country" DOUBLE,
"cloud_cover_in_east_of_country" DOUBLE,
"fires_per_day" BIGINT,
"war_fires_per_day" BIGINT,
"fires_per_day_in_ukraine_held_area" BIGINT,
"war_fires_per_day_in_ukraine_held_area" BIGINT,
"fires_per_day_in_russia_held_area" BIGINT,
"war_fires_per_day_in_russia_held_area" BIGINT,
"fires_per_day_non_cloud_days_7dma" DOUBLE,
"fires_per_day_7dma" DOUBLE,
"war_fires_per_day_non_cloud_days_7dma" DOUBLE,
"war_fires_per_day_7dma" DOUBLE,
"fires_per_day_in_ukraine_held_area_non_cloud_days_7dma" DOUBLE,
"fires_per_day_in_ukraine_held_area_7dma" DOUBLE,
"war_fires_per_day_in_ukraine_held_area_non_cloud_days_7dma" DOUBLE,
"war_fires_per_day_in_ukraine_held_area_7dma" DOUBLE,
"fires_per_day_in_russia_held_area_non_cloud_days_7dma" DOUBLE,
"fires_per_day_in_russia_held_area_7dma" DOUBLE,
"war_fires_per_day_in_russia_held_area_non_cloud_days_7dma" DOUBLE,
"war_fires_per_day_in_russia_held_area_7dma" DOUBLE
);
CREATE TABLE ukraine_fires (
"latitude" DOUBLE,
"longitude" DOUBLE,
"date" TIMESTAMP,
"acq_time" BIGINT,
"id_w_time" VARCHAR,
"id" VARCHAR,
"x" DOUBLE,
"y" DOUBLE,
"year" BIGINT,
"time_of_year" BIGINT,
"fire" BIGINT,
"pop_density" DOUBLE,
"city" VARCHAR,
"in_urban_area" BOOLEAN,
"pop_exact" DOUBLE,
"excess_fire" BIGINT,
"predicted_fire" BIGINT,
"fire_in_window" BIGINT,
"war_fire" BIGINT,
"sustained_excess" BIGINT,
"id_big" VARCHAR,
"length_of_war_fire_area" BIGINT,
"war_fire_restrictive" BIGINT,
"in_ukraine_held_area" BIGINT,
"fires_per_day" BIGINT,
"war_fires_per_day" BIGINT,
"fires_per_day_in_ukraine_held_area" BIGINT,
"war_fires_per_day_in_ukraine_held_area" BIGINT,
"fires_per_day_in_russia_held_area" BIGINT,
"war_fires_per_day_in_russia_held_area" BIGINT
);
CREATE TABLE ukraine_war_fires (
"id_w_time" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"id" VARCHAR,
"x" DOUBLE,
"y" DOUBLE,
"year" BIGINT,
"time_of_year" BIGINT,
"acq_time" BIGINT,
"date" TIMESTAMP,
"fire" BIGINT,
"pop_density" DOUBLE,
"city" VARCHAR,
"in_urban_area" BOOLEAN,
"pop_exact" DOUBLE,
"excess_fire" BIGINT,
"predicted_fire" BIGINT,
"fire_in_window" BIGINT,
"war_fire" BIGINT,
"sustained_excess" BIGINT,
"id_big" VARCHAR,
"length_of_war_fire_area" BIGINT,
"war_fire_restrictive" BIGINT
);
CREATE TABLE war_fires_by_adm3 (
"latitude" DOUBLE,
"longitude" DOUBLE,
"adm3_pcode" VARCHAR,
"municipality" VARCHAR,
"adm3_en" VARCHAR,
"adm3_ua" VARCHAR,
"adm3_ru" VARCHAR,
"adm2_en" VARCHAR,
"adm2_ua" VARCHAR,
"adm2_ru" VARCHAR,
"adm2_pcode" VARCHAR,
"adm1_en" VARCHAR,
"adm1_ua" VARCHAR,
"adm1_ru" VARCHAR,
"adm1_pcode" VARCHAR,
"adm0_en" VARCHAR,
"year" BIGINT,
"acq_time" BIGINT,
"date" TIMESTAMP,
"pop_exact" DOUBLE
);
Anyone who has the link will be able to view this.