incidents

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

1 row where AcresBurned = "53.0", AdminUnit = "CAL FIRE Sonoma-Lake-Napa Unit" and County = "Sonoma" sorted by Updated descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Started (date)

IsActive 1

  • 1 1

County 1

  • Sonoma · 1 ✖

AdminUnit 1

  • CAL FIRE Sonoma-Lake-Napa Unit · 1 ✖
UniqueId Name Updated ▲ Started AdminUnit County Location AcresBurned PercentContained Longitude Latitude Url IsActive
43d81aa4-9deb-4235-bfdd-332cb4d60f16 Cougar Fire 2024-09-16 2024-09-15 CAL FIRE Sonoma-Lake-Napa Unit Sonoma Lakeville Highway, south of Cougar Mountain Road, Sears Point 53.0 100.0 -122.485218 38.145843 /incidents/2024/9/15/cougar-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
    );