California WildFires (2013-2020)
List of WildFires in California between 2013 and 2020
@kaggle.ananthu017_california_wildfire_incidents_20132020
List of WildFires in California between 2013 and 2020
@kaggle.ananthu017_california_wildfire_incidents_20132020
California is one of the places having the most deadliest and destructive wildfire seasons. The dataset contains the list of Wildfires that has occurred in California between 2013 and 2020. The dataset contains the location where wildfires have occurred including the County name, latitude and longitude values and also details on when the wildfire has started.
This data helps to generate insights on what locations in California are under fire threat, what time do Wildfires usually occur and how frequent and devastating they are!!
CREATE TABLE california_fire_incidents (
"acresburned" DOUBLE,
"active" BOOLEAN,
"adminunit" VARCHAR,
"airtankers" DOUBLE,
"archiveyear" BIGINT,
"calfireincident" BOOLEAN,
"canonicalurl" VARCHAR,
"conditionstatement" VARCHAR,
"controlstatement" VARCHAR,
"counties" VARCHAR,
"countyids" BIGINT,
"crewsinvolved" DOUBLE,
"dozers" DOUBLE,
"engines" DOUBLE,
"extinguished" VARCHAR,
"fatalities" DOUBLE,
"featured" BOOLEAN,
"final" BOOLEAN,
"fueltype" VARCHAR,
"helicopters" DOUBLE,
"injuries" DOUBLE,
"latitude" DOUBLE,
"location" VARCHAR,
"longitude" DOUBLE,
"majorincident" BOOLEAN,
"name" VARCHAR,
"percentcontained" DOUBLE,
"personnelinvolved" DOUBLE,
"public" BOOLEAN,
"searchdescription" VARCHAR,
"searchkeywords" VARCHAR,
"started" VARCHAR,
"status" VARCHAR,
"structuresdamaged" DOUBLE,
"structuresdestroyed" DOUBLE,
"structuresevacuated" VARCHAR,
"structuresthreatened" DOUBLE,
"uniqueid" VARCHAR,
"updated" VARCHAR,
"watertenders" DOUBLE
);Anyone who has the link will be able to view this.