California County MCAH Data Spreadsheets (aka DataBooks)

Databooks and CHSR Details (link)

Databooks are Excel spreadsheet files that include rates and trends for key MCAH indicators. Data are given at the county and regional levels and include comparisons to statewide rates. For regional DataBooks click here.

Databooks have multiple pages of data and information, including County/Regional numbers, State numbers, definitions, data quality, rates, and graphs, for different racial/ethnic groups and across several years. We strongly encourage you to consult the materials from the County Data Spreadsheets webinar training before using the databooks as well as the publications: Title V 5-Year Needs Assessment Indicators: DATABOOK 2008 to 2019 and Trend Analysis Examples (a shorter overview). Population Databooks use population data from the Department of Finance (DOF). These data were summarized into age groups two ways, as DOF reported, and bridged into 5 longitudinally consistent race/ethnic groups.Please read these documents that pertain to important changes in methods for calculating some indicators derived from the birth certificate. Contact FHOP with any questions.

Note: Databooks are confidential. Please contact FHOP if you want permission to access these files.

Community Health Status Report (CHSR) Details

Is a spreadsheet that includes a subset of the data indicators that you see listed on your county databooks page that FHOP analyzes and produces the Databooks for. The CHRS Details includes more in-depth comparisons of your current LHJ rates with your past rates, with the state’s current rates, with Healthy People (HP) 2020 goals when available, and a summary of trends when available that include the period in years, the rate, and confidence intervals. 

Please review the document: Understanding your Community Health Status Reports - The Overview and the Details, for a better understanding of your CHSR.

Race/Ethnic Data Quality Databooks

FHOP has produced 3 race/ethnic data quality databooks for local health jurisdictions for birth certificate data, hospital patient discharge data and hospital emergency department data. These databooks show rates and trends for UNDEFINED race/ethnicity for data from each of these sources. LHJs can use this data to monitor if their rates of UNDEFINED race/ethnicity exceed the Centers for Disease Control standards and to what degree.

Boundary Files

These zip files contain shape files that you can use with epidemiological mapping programs.

California Regions Map

A map of regions of California for the MCAH programs.