Baselight

Maternal, Child, And Adolescent Health Needs Assessment, 2023-2024

City of San Francisco

@usgov.city_of_san_francisco_maternal_child_and_adolescent_he_a0c67553

Loading...
Loading...

About this Dataset

Maternal, Child, And Adolescent Health Needs Assessment, 2023-2024

SUMMARY This table contains data about women, ages 15 to 50, pregnant people, infants, children, and youths, up to age 24. It contains information about a wide range of health topics, including medical conditions, nutrition, dehydration, oral health, mental health, safety, access to health care, and basic needs, like housing. Local, county-level prevalence rates, time trends, and health disparities about national public health priorities, including preterm birth, infant death, childhood obesity, adolescent depression and substance use, and high blood pressure, diabetes, and kidney disease in young adults. The population data is from the 2023-2024 San Francisco Maternal Child and Adolescent Health needs assessment and is published on the Open Data Portal to share with community partners, plan services, and promote health. For more information see:

  • Maternal, Child, and Adolescent Health Homepage
  • Maternal, Child, and Adolescent Health Reports HOW THE DATASET IS CREATED The Maternal, Child, and Adolescent Health (MCAH) Needs Assessment for San Francisco included review of a wide range of citywide population data covering a ten-year span, from 2014 to 2023. Data from over 83,000 birth records, 59,000 death records, 261,000 emergency room visits, 66,000 hospital admissions, and 90,000 newborn screening discharges were gathered, along with citywide data from child welfare records, health screenings in childcare and schools, DMV records of first-time drivers, school surveys, and a state-run mailed survey of recent births (California Department of Public Health MIHA survey). The datasets provided information about approximately 700 health conditions. Each health condition was described in terms of the number of people affected or cases, and the rate affected, stratified by age, sex, race-ethnicity, insurance status, zip code, and time period. Rates were calculated by dividing the number of people or events by the population group estimate (e.g., total births or census estimates), then multiplying by 100 or 1,000 depending on the measure. Each rate was presented with its 95% confidence interval to support users to compare any two rates, either between groups or over time. Two rates differ “significantly” if their 95% confidence intervals do not overlap. The present dataset summarizes the group-level results for any age-, sex-, race-, insurance-, zip code-, and/or period-specific group that included at least 20 people or cases. Causes of death, health conditions that affected over 1000 people in the time frame, problems that got worse over time, and health disparities by insurance, race-ethnicity and/or zip code were flagged for the MCAH Needs Assessment. UPDATE PROCESS The dataset will be updated manually, bi-annually, each December and June. HOW TO USE THIS DATASET Population data from the MCAH needs assessment are shared in several formats, including aggregated datasets on DataSF.gov, downloadable PDF summary reports by age group, interactive online visualizations, data tables, trend graphs, and maps. Information about each variable is available in a linked data dictionary. The definition of each numerator and denominator depends on data source, life stage, and time. Health conditions may not be directly comparable across life stage, if the numerator definition includes age- or pregnancy-specific diagnosis codes (e.g. diabetes hospitalization). For small groups or rare conditions, consider combining time periods and/or groups. Data are suppressed if fewer than 20 cases happened in the group and period. Group-specific rates are available if the matched group-specific census estimates (denominator) were available. Census estim
    Organization: City of San Francisco
    Last updated: 2025-08-11T17:57:25.031922

Tables

Table 1

@usgov.city_of_san_francisco_maternal_child_and_adolescent_he_a0c67553.table_1
  • 1.69 MB
  • 62714 rows
  • 28 columns
Loading...

CREATE TABLE table_1 (
  "age_group" VARCHAR,
  "sex" VARCHAR,
  "topic" VARCHAR,
  "data_source" VARCHAR,
  "health_condition_data_source" VARCHAR,
  "period" VARCHAR,
  "year" DOUBLE,
  "denominator" DOUBLE,
  "denominator_is" VARCHAR,
  "number_with_outcome" DOUBLE,
  "numerator_is" VARCHAR,
  "rate_95ci" VARCHAR,
  "rate_sf_pop" DOUBLE,
  "ci_low" DOUBLE,
  "ci_high" DOUBLE,
  "rate_is" VARCHAR,
  "insurance" VARCHAR,
  "zip_code" VARCHAR,
  "race_ethnicity" VARCHAR,
  "rate_title" VARCHAR,
  "trend_title" VARCHAR,
  "filter_1000_or_more" VARCHAR,
  "sort_1000_or_more" BIGINT,
  "primary_neighborhood" VARCHAR,
  "cause_of_death_rank" DOUBLE,
  "death_tooltip" VARCHAR,
  "latest_data" DOUBLE,
  "unique_row_id" BIGINT
);

Share link

Anyone who has the link will be able to view this.