Independent Investigative Journalism in the Public InterestSupport Nonprofit Journalism →

The Dismal Freedom Press Data Library has two components: curated public databases maintained by government agencies and research institutions that inform our reporting, and our CPRA Records Library — a growing collection of documents obtained through California Public Records Act requests and other investigative filings, published as records clear legal review.

Every external dataset linked here comes from a verified government or academic source. If you find a broken link or have a data source to suggest, contact us at data@dismalfreedompress.org.

Public Databases

Police Use-of-Force Database

California law enforcement use-of-force incidents reported under AB 71 (the URSUS system). Covers officer-involved shootings, serious bodily injury, and other reportable force incidents across every law enforcement agency in the state.

What's tracked: Incident type, agency, date, civilian demographics, officer information, type of force used, injuries, weapons involved.

DFP coverage area agencies include: Stockton PD, San Joaquin County Sheriff, Modesto PD, Stanislaus County Sheriff, Merced PD, Merced County Sheriff, Oakland PD, Alameda County Sheriff, and all other reporting agencies in San Joaquin, Stanislaus, Merced, and Alameda counties. AB 71 (2015) requires all California law enforcement agencies to report use-of-force incidents to the CA DOJ through the URSUS (Use of Force Incident Reporting) system.

Updated annually by CA DOJ. Most recent release: 2023 data (published mid-2024).

Valley Eviction Tracker

County-level eviction filing rates for San Joaquin, Stanislaus, and other Central Valley counties. Tracks the post-pandemic surge in evictions following the expiration of California's COVID-19 tenant protections.

What's tracked: Eviction filing rates, unlawful detainer case counts, filing trends over time, geographic breakdowns by county and city.

Context: Central Valley eviction filings have risen sharply since the end of California's pandemic-era eviction moratorium (AB 832 expired in 2022). San Joaquin County consistently has one of the highest eviction filing rates in the state. The Eviction Lab tracks filings in real time for select jurisdictions, while the Judicial Council publishes annual caseload data for all 58 California counties, including unlawful detainer (eviction) filings.

Eviction Lab updates weekly for tracked cities. Judicial Council data published annually.

Drinking Water Quality Monitor

Real-time violation data and water quality reports for Central Valley water systems. Covers contamination levels, MCL violations, and compliance orders for public water systems serving disadvantaged communities.

What's tracked: Maximum contaminant level (MCL) violations, monitoring violations, treatment technique violations, enforcement actions, nitrate levels, arsenic levels, 1,2,3-TCP contamination.

Context: Hundreds of small community water systems in the Central Valley — many serving unincorporated, low-income communities — rely on groundwater contaminated with nitrates, arsenic, and the pesticide byproduct 1,2,3-TCP. The state's SAFER (Safe and Affordable Funding for Equity and Resilience) program tracks failing water systems. San Joaquin, Stanislaus, and Merced counties are among the hardest hit. Use the Drinking Water Watch tool to search for specific water systems by name, county, or violation type.

SDWIS updated continuously. EPA ECHO updated quarterly.

San Joaquin Valley Air Quality

Real-time and historical air quality data for the San Joaquin Valley, which consistently ranks among the most polluted regions in the United States for both ozone and particulate matter (PM2.5).

What's tracked: Air Quality Index (AQI), PM2.5 concentrations, ozone levels, wildfire smoke impacts, agricultural burn permits, health advisories.

Context: The San Joaquin Valley Air Basin — stretching from Stockton to Bakersfield — is classified as "extreme" nonattainment for ozone and "serious" nonattainment for PM2.5 by the EPA. The American Lung Association consistently ranks Fresno, Bakersfield, and other Valley cities among the most polluted in the nation. Key pollution sources include agricultural burning, vehicle emissions, industrial operations, and seasonal wildfire smoke. PurpleAir sensors provide hyperlocal readings that often show worse conditions than official monitors in disadvantaged neighborhoods.

AirNow and PurpleAir update in real time. SJVAPCD and CARB publish daily and annual summaries.

Campaign Finance & Lobbying

Follow the money in California politics. Track campaign contributions, independent expenditures, and lobbying activity for state and local races across the Central Valley and East Bay.

Data Sources

What's tracked: Campaign contributions, independent expenditures, lobbyist activity filings, Form 460/461 reports, FPPC enforcement actions, late contribution reports (Form 497).

DFP coverage: We monitor campaign finance filings for San Joaquin County Board of Supervisors, Stockton City Council, Stanislaus County supervisors, Modesto City Council, Merced County supervisors, and Alameda County races. Cal-Access covers all state-level races and ballot measures. For city-level filings not in Cal-Access, check with local city clerk offices in Stockton, Modesto, Tracy, Manteca, Merced, and Oakland.

Cal-Access updated as filings are submitted. FPPC enforcement updates posted periodically.

Court Records & Case Data

Statewide caseload statistics and court records for California’s trial and appellate courts. Covers civil, criminal, family, juvenile, and small claims filings across all 58 counties.

Data Sources

What's tracked: Case filings by type (criminal, civil, family, juvenile), dispositions, pending caseloads, time-to-disposition metrics, unlawful detainer filings.

DFP coverage: We track caseload trends in San Joaquin, Stanislaus, Merced, and Alameda county courts, with particular focus on criminal case backlogs, unlawful detainer (eviction) filings, and juvenile justice proceedings. The Judicial Council publishes county-level data that allows comparison across jurisdictions.

Judicial Council data published annually. Local court records updated as cases are filed.

School Accountability Data

Performance metrics, enrollment demographics, graduation rates, and accountability indicators for every public school and district in the Central Valley and East Bay.

Data Sources

What's tracked: CAASPP test scores, graduation and dropout rates, chronic absenteeism, suspension and expulsion rates, English Learner progress, college/career readiness, per-pupil spending.

DFP coverage: Key districts we monitor include Stockton Unified, Lodi Unified, Manteca Unified, Tracy Unified (San Joaquin County); Modesto City Schools, Turlock Unified (Stanislaus County); Merced Union High, Merced City School District (Merced County); and Oakland Unified, Hayward Unified (Alameda County). The Dashboard allows filtering by student groups including race/ethnicity, socioeconomic status, English Learners, foster youth, and students with disabilities.

DataQuest updated annually with prior-year data. School Dashboard updated each fall.

Public Employee Compensation

Searchable salary and benefits data for state, county, city, and special district employees across California. See how much public employees earn in total compensation including overtime, benefits, and pension contributions.

Data Sources

What's tracked: Base pay, overtime pay, other pay, benefits, total compensation, pension contributions, employer name, job title, department.

DFP coverage: We regularly analyze compensation data for San Joaquin County, City of Stockton, Stanislaus County, City of Modesto, Merced County, Alameda County, and City of Oakland employees. Particular focus on law enforcement overtime, executive compensation, and pension costs. The State Controller requires all local agencies to report compensation data annually.

State Controller data published annually. Transparent California updates as agencies report.

Homelessness & Housing Data

Point-in-Time homeless counts, housing inventory data, and shelter capacity information for Central Valley and East Bay Continuums of Care (CoCs). Tracks unsheltered and sheltered populations over time.

Data Sources

What's tracked: Sheltered and unsheltered homeless populations, chronic homelessness, veteran homelessness, family homelessness, youth homelessness, housing inventory by type (emergency, transitional, permanent supportive).

DFP coverage: We track the Stockton/San Joaquin County CoC (CA-511), Stanislaus County CoC (CA-510), Merced County CoC (CA-525), and Oakland/Alameda County CoC (CA-502). Central Valley communities have seen sharp increases in unsheltered homelessness, driven by housing costs, the eviction surge, and limited shelter capacity. HDIS allows state-level analysis of service utilization and outcomes.

PIT counts conducted annually (odd years required, many CoCs count annually). HDIS updated quarterly.

Crime & Arrest Statistics

Comprehensive crime and arrest data reported by California law enforcement agencies to the CA Department of Justice. Covers violent crime, property crime, hate crimes, arrests, and deaths in custody.

Data Sources

What's tracked: Violent crimes (homicide, robbery, assault, sexual assault), property crimes (burglary, theft, motor vehicle theft), hate crimes, juvenile arrests, deaths in custody, law enforcement staffing levels.

DFP coverage: We track crime trends for Stockton, Modesto, Merced, Tracy, Manteca, Oakland, and Hayward, as well as county-level data for San Joaquin, Stanislaus, Merced, and Alameda counties. Stockton and Oakland consistently rank among the highest in California for violent crime rates. OpenJustice allows comparison across agencies and jurisdictions over time.

CA DOJ data published annually. FBI UCR/NIBRS data released annually with a one-year lag.

Public Health & Vital Statistics

Health outcomes, disease surveillance, vital statistics, and community health data for Central Valley and East Bay counties. Covers everything from chronic disease rates to maternal and child health indicators.

Data Sources

What's tracked: Leading causes of death, infant mortality, birth outcomes, communicable disease rates, chronic disease prevalence, mental health indicators, substance use, health insurance coverage, health professional shortage areas.

DFP coverage: San Joaquin, Stanislaus, and Merced counties consistently rank in the bottom quartile statewide for health outcomes including life expectancy, diabetes prevalence, and access to primary care. County Health Rankings provide annual comparisons across all 58 California counties. Alameda County shows significant health disparities between affluent and low-income communities, particularly in East Oakland and South Hayward.

County Health Rankings updated annually each spring. CDPH vital statistics published with a one- to two-year lag.

Government Budget & Spending

State and local government budgets, expenditures, and financial reports for California. Track how taxpayer dollars are allocated and spent by state agencies, counties, cities, and special districts.

Data Sources

What's tracked: General fund revenues and expenditures, department-level budgets, capital improvement plans, debt obligations, pension liabilities, Comprehensive Annual Financial Reports (CAFRs).

DFP coverage: We analyze budgets for San Joaquin County, City of Stockton (which exited Chapter 9 bankruptcy in 2015), Stanislaus County, City of Modesto, Merced County, Alameda County, and City of Oakland. Key areas of focus include law enforcement spending as a share of general funds, pension obligations, and allocation of state and federal grant funding. The State Controller publishes annual financial transaction reports for every county, city, and special district in California.

State budget published annually (January proposal, June revision). Local CAFRs published annually, typically 6 months after fiscal year end.

How We Use Data

Data analysis is central to Dismal Freedom Press's investigative reporting. We use public databases to identify patterns, verify claims made by officials, and hold institutions accountable. Here is how we approach data journalism:

  • Source verification: We only use data from official government agencies, peer-reviewed academic institutions, or established research organizations. Every dataset is linked directly so readers can verify our work.
  • Local context: State and federal datasets often require local knowledge to interpret correctly. We cross-reference data with on-the-ground reporting, public records requests, and interviews with affected community members.
  • Limitations disclosed: Every dataset has gaps. We disclose known limitations — underreporting, delayed updates, missing agencies — in our published analyses.
  • Reproducibility: When we publish data-driven findings, we describe our methodology in enough detail that another journalist or researcher could reproduce our analysis.
  • Public records supplements: Government databases are a starting point. We routinely file California Public Records Act requests to obtain data that agencies have not published proactively.

If you are a researcher, community organizer, or journalist who wants to collaborate on data analysis, reach out at data@dismalfreedompress.org.

Data Library Maintenance

This Data Library is maintained by the Dismal Freedom Press reporting team. External links point to databases operated by government agencies and research institutions; we do not control their availability or update schedules. We review all links monthly and archive key datasets to our internal document library. Last reviewed: March 2026. Report broken links to data@dismalfreedompress.org.

Loading records…