← Back to the chart

The data behind the chart

Every number in the chart comes from one SQLite database, extracted from Harris County's own budget books and the County Auditor's reports. You can download it, or explore it right here in your browser. No account, no install and no AI needed.

Explore it in your browser Download the database (1 MB)

"Explore in your browser" opens Datasette Lite, a free open-source tool that runs the database entirely inside your browser. Nothing you do is sent to a server. The first load takes a few seconds. The download is a standard SQLite file that opens in DB Browser for SQLite, Python, R and most spreadsheet tools that support SQLite.

Before you draw conclusions

Try a question

Each link runs the query in your browser. Edit the SQL there to ask your own.

What's in the database

gf_adopted

General Fund budget by department, FY2025 and FY2026 adopted, FY2027 proposed (status). The Working Capital reserve is the row with is_reserve = 1.

Source: FY25 and FY26 Adopted Volume I spreadsheets; FY27 Proposed Volume I, Appendix A.

fy27_changes

Every line of every department's FY2027 "Change Table": what was added or cut, and by how much. The 81 tables add up to $326.0M. page is the PDF page in Volume II.

Source: FY27 Proposed Volume II.

auditor_budget

For FY2024 and FY2025: each department's original budget, amended ("adjusted") budget, spending and encumbrances at year end.

Source: County Auditor, September 2024 and September 2025 Monthly Financial Reports, "Budget Status – By Department".

actuals

Adopted vs. actual spending by department for FY2024 and FY2025, with the difference.

Source: FY25 and FY26 Adopted Volume I spreadsheets.

fund_overview

FY2024 and FY2025 adopted budgets by department and fund, split into Labor, Non-Labor and TOTAL. Also SFY2022 and FY2023 actuals.

Source: FY25 Adopted budget book.

dollars_by_program · positions_by_program

FY2025 adopted dollars and budgeted positions, broken down by each department's programs.

Source: FY25 Adopted budget book.

departments

Department codes and names.

vol1_pages · vol1_fts

The full text of the FY25 Adopted Volume I, one row per page, with full-text search.

Source: FY25 Adopted Volume I.

Original documents

All public, no login: