Barn Fire Stats

Updated June 2026 · Special Functions

On This Page

Annual Update

Run through this each time new annual data comes in. Allie's data often has errors—validate carefully before importing.

Copy the spreadsheet tab for the new year. Remove everything except the yellow-highlighted rows.
Ensure column headers are exactly: Date / City/County / State / Animal Deaths / Species / Link—no extra spaces, no extra columns.
Clean the data:
- All state names written out in full—no abbreviations
- Animal Deaths must be numbers only—no commas, no text
- Remove Allie's extra notes from the tab
- Verify all links work
Export the existing year first as a backup via Tools → Barn Fire Stats → Export CSV.
Export the new tab as CSV: File → Download → CSV.
Import the new CSV in Tools → Barn Fire Stats. Check "First row is header (skip it)" before importing.
Verify the row count matches your spreadsheet. Spot-check links.
Update Theme Options with the new total deaths and last-updated date: Appearance → Theme Options. Enter numbers without commas—the theme formats them automatically.
Check that the graphic on the Barn Fires page is updated.
View the front-end page and confirm the new total, updated date, and all links are correct.

Use the 2026 tab as a template. Work through tabs 2025–2020. The column structure and data cleaning rules are the same as the annual update above.

For each year tab, delete extra columns and create a new column named Animal Deaths.
Extract the animal death totals into the Animal Deaths column. Rename the original column Species.
Follow the same data cleaning checklist: full state names, numbers only, working links.
Download each tab as a CSV and import via Tools → Barn Fire Stats—select the year before importing.
After each year, verify row counts match under View and manage data.
Once all years are imported, update the page summary: Row 1 = 2026, Row 2 = 2025, and so on.