📚
Reference & Data Sources
Datasets, Definitions, and Methods
Sources / Links / Attribution
🌐 Primary Data Sources
NYC Environment & Health Data Portal (EHDP)
github.com/nychealth/EHDP-data
Borough-level and neighborhood-level diabetes indicators including prevalence, A1C control, amputations, and dialysis. JSON format, organized by IndicatorID.
NYC DOHMH Indicator Explorer — Chronic Disease (Diabetes)
a816-dohbesp.nyc.gov/IndicatorPublic/data-explorer/chronic-disease/?id=2465
Direct link to the NYC Environment & Health Data Portal chronic disease explorer, pre-loaded with all four diabetes indicators: Adults with Diabetes, A1C > 9% (very high blood sugar), Lower Extremity Amputations (diabetes-related), and Dialysis Patients (diabetes-related). Includes maps, trend charts, borough and neighborhood breakdowns, and correlation views by poverty level.
🏥 2024 SPARCS Data — Diabetes · NYC 5 Boroughs · By Age Group
Hospital inpatient discharges filtered to diabetes CCSR diagnoses, NYC hospital counties, discharge year 2024. Each link opens directly in NY State Open Data pre-filtered to that age group.
Diabetes Without Complication
Diabetes With Complication
Prediabetes
Maternal Diabetes
NYC 5 Boroughs · sf4k-39ay
🏥 2023 SPARCS Data — Diabetes · NYC 5 Boroughs · By Age Group
Same four diabetes CCSR categories, NYC boroughs, discharge year 2023. Note: 2023 uses 3-digit zip and hospital_service_area field — Manhattan coded as "Manhattan" (vs "New York" in 2024).
Diabetes Without Complication
Diabetes With Complication
Prediabetes
Maternal Diabetes
NYC 5 Boroughs · 46xm-urtu · 3-digit zip
NYSDOH SPARCS De-Identified Overview 2024
NYSDOH_SPARCS_De-Identified_Overview_2024.pdf (Download)
Official NY State DOH overview document for the 2024 SPARCS de-identified inpatient dataset (sf4k-39ay). Describes the scope, methodology, data collection process, suppression rules, and intended use of the discharge-level hospital data. Essential companion document for understanding how SPARCS data is structured and how to interpret its fields correctly.
NYSDOH SPARCS De-Identified Data Dictionary 2024
NYSDOH_SPARCS_De-Identified_Data_Dictionary_2024.pdf (Download)
Complete field-by-field data dictionary for the 2024 SPARCS de-identified dataset. Defines every column including APR-DRG codes, CCSR diagnosis and procedure codes, severity of illness levels, risk of mortality categories, payment typology values, and all demographic fields. Required reference for any analysis using the SPARCS Endocrine inpatient discharge data.
AHRQ Quality Indicators (QI) — Indicators List v2023
qualityindicators.ahrq.gov — AHRQ QI Indicators List (PDF)
Agency for Healthcare Research and Quality (AHRQ) standardized quality measures used with SPARCS and other hospital discharge data. Covers four indicator modules: Prevention Quality Indicators (PQI), Inpatient Quality Indicators (IQI), Patient Safety Indicators (PSI), and Pediatric Quality Indicators (PDI). Published October 2023, AHRQ Pub. No. 24-0007.
🩸 Diabetes-Relevant Indicators:
PQI 01 — Diabetes Short-Term Complications
PQI 03 — Diabetes Long-Term Complications
PQI 14 — Uncontrolled Diabetes Admission Rate
PQI 16 — Lower-Extremity Amputation (Diabetes)
PQI 93 — Prevention Quality Diabetes Composite
PDI 15 — Pediatric Diabetes Short-Term Complications
👶 SPARCS — Pediatric Prevention Quality Indicators (PDI) by Patient County · NYC · Beginning 2009
health.data.ny.gov — SPARCS PDI by County (vh2s-8wb2) · Filtered to NYC · Diabetes
Hospital inpatient discharge data measuring Pediatric Prevention Quality Indicators (PDI) for all five NYC counties — Bronx, New York (Manhattan), Kings (Brooklyn), Queens, and Richmond (Staten Island) — filtered to diabetes, beginning 2009. Reports observed rate, expected rate, risk-adjusted rate, and difference in rates per 100,000 people by discharge year and PDI number. Directly relevant to AHRQ PDI 15 (Pediatric Diabetes Short-Term Complications Admission Rate).
PDI 15 — Pediatric Diabetes Short-Term Complications
All 5 NYC Counties
Risk-Adjusted Rates
Beginning 2009
📖 Key Definitions
A1C (HbA1c)
A blood test measuring average blood glucose over the prior 2 to 3 months. A1C greater than 9% indicates poor glycemic control and is associated with significantly higher risk of diabetes complications.
Diabetes Prevalence
The percentage of the adult population (age 18 and older) who report being told by a healthcare provider that they have diabetes. Measured via NYC Community Health Survey.
SPARCS
Statewide Planning and Research Cooperative System. Collects patient-level detail on every hospital inpatient discharge in New York State, including diagnosis, procedure, cost, and payment information. This hub uses the 2024 de-identified dataset filtered to Endocrine diagnoses (dataset ID: sf4k-39ay) for diabetes hospitalization analysis.
EHDP
Environment and Health Data Portal, maintained by NYC DOHMH. Provides hundreds of indicators on how environmental and social conditions shape health outcomes across NYC neighborhoods.
📚 Research Literature — Peer-Reviewed Sources
The Prevalence of Type 1 Diabetes in Hispanic/Latino Populations
journals.lww.com — Epidemiology Journal · 2020
Dominicans have the highest Type 1 prevalence of all Hispanic subgroups at 6.1 per 1,000. Among Puerto Ricans with Type 1, average A1C was 11.52 — severely uncontrolled. Critical evidence for the misdiagnosis crisis in Caribbean communities.
Dominican Type 1: 6.1/1,000
Puerto Rican A1C: 11.52
Epidemiology Journal · 2020
Understanding the Growing Epidemic of Type 2 Diabetes in the Hispanic Population
pmc.ncbi.nlm.nih.gov — PMC/NIH · Free Full Text
Diagnosed diabetes projected to increase 198% overall by 2050 — but 481% for Hispanic populations, more than double the national rate. Puerto Ricans and Dominicans at the highest current burden will drive this disproportionately.
481% Hispanic Projection
vs 198% Overall
PMC/NIH · Free Full Text
Profiles of Social Determinants of Health and Change in Diabetes Status — HCHS/SOL 2008–2024
diabetesjournals.org — Diabetes Care, ADA · 2025
High-adversity profile had 51% greater odds of worse diabetes status at baseline and 32% greater odds of worsening 12 years later. Acculturation stress, limited education, low income, and psychosocial burden compound into a trajectory that medication alone cannot address.
51% Greater Odds Baseline
32% Worse at 12 Years
HCHS/SOL 2008–2024