incidents

Data license: MIT · Data source: California Department of Forestry and Fire Protection (CAL FIRE) · About: Made by jerrynsh.com

2 rows where AdminUnit = "Six Rivers National Forest", County = "Trinity" and IsActive = 1 sorted by Updated descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Updated (date), Started (date)

IsActive 1

County 1

  • Trinity · 2 ✖

AdminUnit 1

  • Six Rivers National Forest · 2 ✖
UniqueId Name Updated ▲ Started AdminUnit County Location AcresBurned PercentContained Longitude Latitude Url IsActive
dbf89663-4a51-4869-aabd-9b3b49661af5 Lake Fire 2024-11-06 2024-11-05 Six Rivers National Forest Trinity 200 block of Lower West Side Road, Mad River 44.0 0.0 -123.420067 40.342148 /incidents/2024/11/5/lake-fire/ 1
cb115973-a1bd-4023-8445-3566116629e7 Pickett Fire 2024-07-20 2024-07-14 Six Rivers National Forest Trinity East of Ruth Reservoir 22.0 100.0 -123.362 40.3464 /incidents/2024/7/14/pickett-fire/ 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE incidents (
        UniqueId TEXT PRIMARY KEY,
        Name TEXT,
        Updated TEXT,
        Started TEXT,
        AdminUnit TEXT,
        County TEXT,
        Location TEXT,
        AcresBurned REAL,
        PercentContained REAL,
        Longitude REAL,
        Latitude REAL,
        Url TEXT,
        IsActive INTEGER
    );