{"action":"create","ckan_id":null,"date_created":"Sat, 28 Feb 2026 20:20:02 GMT","date_finished":null,"harvest_job_id":"3f329002-6845-4a0b-9d3d-13315f54fc75","harvest_source_id":"17aad263-f33f-4d22-891b-57bdef961cab","id":"db86cccd-6d9a-436b-ba9b-5c8adaaba4c6","identifier":"https://data.sfgov.org/api/views/iqtk-etij","parent_identifier":null,"source_hash":"c49bb8123cca2a7eafc306f28a1c1b0b03023e01610ae80fe419a9a9d3daf650","source_raw":"{\"@type\": \"dcat:Dataset\", \"accessLevel\": \"public\", \"contactPoint\": {\"@type\": \"vcard:Contact\", \"fn\": \"OpenData\", \"hasEmail\": \"mailto:no-reply@data.sfgov.org\"}, \"description\": \"SUMMARY\\nThis 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. \\n\\nThe 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.\\n\\nFor more information see:\\n
  • Maternal, Child, and Adolescent Health Homepage\\n
  • Maternal, Child, and Adolescent Health Reports\\n\\nHOW THE DATASET IS CREATED\\nThe 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. \\n\\nRates 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 \\u201csignificantly\\u201d if their 95% confidence intervals do not overlap.\\n\\nThe 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. \\n\\nCauses 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.\\n\\nUPDATE PROCESS\\nThe dataset will be updated manually, bi-annually, each December and June.\\n\\nHOW TO USE THIS DATASET\\nPopulation 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. \\nInformation 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. \\nHealth conditions may not be directly comparable across life stage, if the numerator definition includes age- or pregnancy-specific diagnosis codes (e.g. diabetes hospitalization).\\n\\nFor 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.\\n\\nGroup-specific rates are available if the matched group-specific census estimates (denominator) were available. Census estim\", \"distribution\": [{\"@type\": \"dcat:Distribution\", \"describedBy\": \"https://data.sfgov.org/api/views/iqtk-etij/columns.json\", \"describedByType\": \"application/json\", \"downloadURL\": \"https://data.sfgov.org/api/views/iqtk-etij/rows.json?accessType=DOWNLOAD\", \"mediaType\": \"application/json\"}, {\"@type\": \"dcat:Distribution\", \"describedBy\": \"https://data.sfgov.org/api/views/iqtk-etij/columns.rdf\", \"describedByType\": \"application/rdf+xml\", \"downloadURL\": \"https://data.sfgov.org/api/views/iqtk-etij/rows.rdf?accessType=DOWNLOAD\", \"mediaType\": \"application/rdf+xml\"}, {\"@type\": \"dcat:Distribution\", \"describedBy\": \"https://data.sfgov.org/api/views/iqtk-etij/columns.xml\", \"describedByType\": \"application/xml\", \"downloadURL\": \"https://data.sfgov.org/api/views/iqtk-etij/rows.xml?accessType=DOWNLOAD\", \"mediaType\": \"application/xml\"}, {\"@type\": \"dcat:Distribution\", \"downloadURL\": \"https://data.sfgov.org/api/views/iqtk-etij/rows.csv?accessType=DOWNLOAD\", \"mediaType\": \"text/csv\"}], \"identifier\": \"https://data.sfgov.org/api/views/iqtk-etij\", \"issued\": \"2025-08-05\", \"landingPage\": \"https://data.sfgov.org/d/iqtk-etij\", \"modified\": \"2025-08-07\", \"publisher\": {\"@type\": \"org:Organization\", \"name\": \"data.sfgov.org\"}, \"theme\": [\"Health and Social Services\"], \"title\": \"Maternal, Child, and Adolescent Health Needs Assessment, 2023-2024\"}","source_transform":null,"status":"error"}