Community Profile Data Table Instructions and Crosswalk to ...



Purpose:The Community Profile, submitted annually with the Agreement Funding Application, provides a snapshot of the health status of your local community. You may use the Community Profile to share information with stakeholders/community partners and to educate your population. It should provide key data, a description of the community, health resources/initiatives, and the health status and disparities of the MCAH population.Instructions:At the top of the 2019-2020 Community Profile template, click on the box labeled ‘Click here to enter text’ and enter the name of your LHJ. The table below shows where you can find your local data to add the Section 1, data table in the 2019-2020 Community Profile template. For your population data, the easiest place to find it is in your LHJ’ DataBooks for births (look at Indicators 3L your County MCAH Data page to download the DataBook excel file named FERT). The data is on the first tab of the spreadsheet [labeled with your county name] in Column Z in the row specified in the table below. For your data on the postpartum visit, you will be using the California Maternal, Infant Health Assessment (MIHA) data found in the MIHA County and Regional Report 2013-2014 (link in table below). If there is no county MIHA data for your county, please use the regional data for the region your county is in. You will use your CHSR Details for all the other data. Here is the link to the data you will need (Contact FHOP for your password, if you have not already done so, Fhop@ucsf.edu) Complete Sections 2-4 using the instructions in each Section. Please be sure to limit the Community Profile to two pages.Section 1 – DemographicsDemographicsLocalStateOur CommunityTotal Population 1FERT DataBook Row 4, Column Z38,896,969Total Population, African AmericanRow 6, Column Z2,236,361Total Population, American Indian/Alaskan NativesRow 9, Column Z172,948Total Population, Asian/Pacific IslanderRow 8, Column Z5,301,831Total Population, HispanicRow 7, Column Z15,172,006Total Population, WhiteRow 5, Column Z14,972,954Total Live BirthsRow 13, Column N491,789Our Mothers and Babies% of women delivering a baby who received prenatal care beginning in the first trimester of their pregnancy 2CHSR Details: 1C83.3%% of women delivering a baby who had a postpartum visit.6MIHA County and Regional Report 2013-201487.5%% of births covered by Medi-Cal 2CHSR Details: 1A44.3%% of women ages 18-64 without health insurance 3CHSR Details 1015.7%% of women giving birth to a second child within 18 months of a previous pregnancy 2CHSR Details: 1I26.6%DemographicsLocalStateOur Mothers and Babies (continued)% live births less than 37 weeks gestation 2CHSR Details: 2A8.4%Gestational diabetes per 1,000 females age 15-44CHSR Details: 1H9.2% of female population 18-64 living in poverty (0-200% FPL) 3CHSR Details: 5A34.7%Substance use diagnosis per 1,000 hospitalizations of pregnant womenCHSR Details: 1F19.9Unemployment Rate 4CHSR Details: 5D7.5Our Children and Teens FORMTEXT ?????Our Children and TeensTeen Birth Rate per 1,000 births (ages 15-19) 2CHSR Details: 3L21.0Motor vehicle injury hospitalizations per 100,000 children age 0-14CHSR Details: 3914.2% of children, ages 0-18 years living in poverty (0-200% FPL) 3CHSR Details: 5B45.9%Mental health hospitalizations per 100,000 age 15-24CHSR Details: 3K1,499.2Children in Foster Care per 1,000 children 5CHSR Details: 5H6.3Substance abuse hospitalization per 100,000 aged 15-24CHSR Details: 3J793.4Data sources: 1CA Dept. of Finance population estimates 2015, 2CA Birth Statistical Master Files 2013-2015, 3US Census Bureau - Small Area Health Insurance Estimates 2013-2015, 4CA Employment Development Dept. 2013-2015, 5 Data from CA Child Welfare Indicators Project, UC Berkeley 2013-2015, 6 Data from CA Maternal, Infant Health Assessment (MIHA) 2013-2014. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download