Dataset: California WildFires (2013-2020)

About this Dataset

California WildFires (2013-2020)

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!!

Tables

California Fire Incidents

@kaggle.ananthu017_california_wildfire_incidents_20132020.california_fire_incidents

436.94 KB
1636 rows
40 columns


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
);