incidents

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

6 rows where IsActive = 1 and "Updated" is on date 2024-07-08 sorted by Updated descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

IsActive 1

UniqueId Name Updated ▲ Started AdminUnit County Location AcresBurned PercentContained Longitude Latitude Url IsActive
263df749-7279-4200-9c93-b36eb00526c7 Grande Fire 2024-07-08 2024-07-04 CAL FIRE Santa Clara Unit Stanislaus West of Patterson 323.0 80.0 -121.23728 37.46973 /incidents/2024/7/4/grande-fire/ 1
7701bdad-0622-432c-a822-1d6bf6de8c2d Lucerne Fire 2024-07-08 2024-07-06 San Bernardino County Fire Department San Bernardino HWY 18 and High Rd in Lucerne Valley 419.0 90.0 -117.03341 34.45196 /incidents/2024/7/6/lucerne-fire/ 1
dd88859f-53c8-41f4-b697-5e7623f8eeae Thompson Fire 2024-07-08 2024-07-02 CAL FIRE Butte Unit Butte Cherokee Road and Thompson Flat Road, Oroville 3789.0 100.0 -121.5467 39.53793 /incidents/2024/7/2/thompson-fire/ 1
50cb3627-a575-44c7-b740-498a14c33a1f Franklin Fire 2024-07-08 2024-07-08 CAL FIRE San Luis Obispo Unit San Luis Obispo 3000 Block Creston Road, Paso Robles 53.0 50.0 -120.645939 35.591462 /incidents/2024/7/8/franklin-fire/ 1
f030fe29-09cc-4912-91ce-4c47048f6fb4 Sand Fire 2024-07-08 2024-07-08 CAL FIRE Tulare Unit Tulare Sand Creek Road and Sand Creek Drive, North of Orange Cove 31.34 50.0 -119.242623 36.640352 /incidents/2024/7/8/sand-fire/ 1
6436e8b1-ccaf-427b-87f1-25334be1ab1a Caliente Fire 2024-07-08 2024-07-08 Kern County Fire Department Kern Bealville Road North of Highway 58, Bealville 60.0 0.0 -118.651434 35.273067 /incidents/2024/7/8/caliente-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
    );