fire.ca.gov incidents

Data source: simonw/ca-fires-history · About: About these demos

Custom SQL query

Tables

columns

id, namespace, name

41 rows

commits

id, namespace, hash, commit_at

1,796 rows

incident

_id, _item_id, UniqueId, Name, Location, Latitude, Longitude, AcresBurned, FuelType, PercentContained, ControlStatement, ConditionStatement, Counties, CountyIds, SearchDescription, SearchKeywords, AdminUnit, Updated, Started, Extinguished, ArchiveYear, Public, Active, Featured, CalFireIncident, MajorIncident, Final, Status, CanonicalUrl, StructuresDestroyed, StructuresDamaged, StructuresThreatened, StructuresEvacuated, PersonnelInvolved, CrewsInvolved, Injuries, Fatalities, Helicopters, Engines, Dozers, WaterTenders, AirTankers, _commit, ExternalIncidentLink

392 rows

incident_changed

item_version, column

24,367 rows

incident_version

_id, _item, _version, _commit, UniqueId, Name, Location, Latitude, Longitude, AcresBurned, FuelType, PercentContained, ControlStatement, ConditionStatement, Counties, CountyIds, SearchDescription, SearchKeywords, AdminUnit, Updated, Started, Extinguished, ArchiveYear, Public, Active, Featured, CalFireIncident, MajorIncident, Final, Status, CanonicalUrl, StructuresDestroyed, StructuresDamaged, StructuresThreatened, StructuresEvacuated, PersonnelInvolved, CrewsInvolved, Injuries, Fatalities, Helicopters, Engines, Dozers, WaterTenders, AirTankers, _item_full_hash, ExternalIncidentLink

2,646 rows

namespaces

id, name

1 row

Views

Download SQLite DB: ca-fires.db 8.3 MB