Healthcare Chronic Condition Prevalence

This dataset provides granular, patient-level diagnosis information for chronic conditions, including demographics, standardized condition codes, and diagnosis statuses. It is designed for healthcare analytics, enabling prevalence studies, trend analysis, and population health management. The schema supports interoperability and detailed stratification by demographic and clinical factors.

  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Analyzing prevalence and trends of chronic conditions across populations

Sample rows

preview · 8 of 200 rows · all 19 columns
patient_idstringgenderstringaddress_statestringfirst_namestringlast_namestringdate_of_birthdateethnicitystringaddress_streetstringaddress_citystringaddress_postal_codestringaddress_countrystringdiagnosis_idstringcondition_codestringcondition_namestringdiagnosis_datedatediagnosis_statusstringdiagnosed_bystringdiagnosis_notesstringlast_updateddatetime
PAT-1001maleILJamesSmith1982-03-15Caucasian1208 Maple AveChicago60614USADX-20001E11.9Type 2 diabetes mellitus without complications2021-06-10activeDr. Karen LiPatient advised lifestyle modification and metformin.2023-12-04T09:24:00
PAT-1002femaleCAMariaGarcia1974-11-02Hispanic892 W 17th StLos Angeles90007USADX-20002I10Essential (primary) hypertension2022-01-18activeDr. Samuel KentBlood pressure monitored, ACE inhibitors prescribed.2023-09-22T15:41:00
PAT-1003maleWAWeiZhang1990-06-05Asian3667 Lakeshore DrSeattle98115USADX-20003J45.909Unspecified asthma, uncomplicated2023-04-13activeDr. Angela MurrayPatient uses inhaler as needed.2024-02-11T11:17:00
PAT-1004femaleblankAmiraHassan1968-05-22Arab24 Al Maktoum StDubai112233UAEDX-20004M06.9Rheumatoid arthritis, unspecified2018-10-07activeDr. Fahad Al NuaimiMethotrexate therapy ongoing.2023-08-29T10:35:00
PAT-1005femaleblankSophiaNguyen2007-12-11Vietnamese187 Tran Hung DaoHo Chi Minh City700000VietnamDX-20005E66.9Obesity, unspecified2022-09-02activeDr. Lan VuDietary counseling initiated.2023-11-19T13:40:00
PAT-1006maleOHJohnSmith1950-01-11White501 Oak LaneSpringfield45503USADX-20006G30.9Alzheimer's disease, unspecified2016-03-20activeDr. Lisa CohenFamily education provided.2023-12-02T14:58:00
PAT-1007maleblankIvanPetrov1944-10-04SlavicUlitsa Tverskaya 14Moscow125009RussiaDX-20007I50.9Heart failure, unspecified2021-07-25activeDr. Olga SokolovaDiuretics prescribed.2023-06-16T16:31:00
PAT-1008femaleOHEmilyJohnson1989-08-16African American74 Cedar StreetCleveland44102USADX-20008F32.9Major depressive disorder, single episode, unspecified2023-02-05activeDr. Mark EvansSSRIs started, therapy recommended.2024-03-28T12:02:00

What the 200 rows show

from the 200-row sample
  • 3diagnosis statuses
  • 22ethnicities
  • 32address countries
  • 48condition codes
gender200 rows by value
05511093male47%107female54%
address_state63 rows with a value · 137 left blank
  1. IL8
  2. CA7
  3. OH7
  4. MH6
  5. TX6
  6. NY5
  7. MA4
  8. GA4
  9. WA2
  10. CO2
19 columns by typefrom the column list below
  • string 16
  • date 2
  • datetime 1

Columns

19 columns in two groups
blueprint · 19 columns
columntypedescriptionexample
Text 16 columns
patient_idstringUnique identifier for each patient in the datasetuniquePAT-1001
first_namestringPatient's first nameJames
last_namestringPatient's last nameSmith
genderstringPatient's gendermale · female · other · unknownmale
ethnicitystringPatient's self-reported ethnicityoptionalCaucasian
address_streetstringPatient's street addressoptional1208 Maple Ave
address_citystringPatient's city of residenceoptionalChicago
address_statestringPatient's state of residenceoptionalIL
address_postal_codestringPatient's postal codeoptional60614
address_countrystringPatient's country of residenceoptionalUSA
diagnosis_idstringUnique identifier for each diagnosis recorduniqueDX-20001
condition_codestringStandardized code for the chronic condition (e.g., ICD-10)E11.9
condition_namestringName of the chronic condition diagnosedObesity, unspecified
diagnosis_statusstringCurrent status of the diagnosis (e.g., active, resolved, remission)active · resolved · remission · unknownactive
diagnosed_bystringIdentifier or name of the healthcare provider who made the diagnosisoptionalDr. Karen Li
diagnosis_notesstringAdditional notes or comments about the diagnosisoptionalDiuretics prescribed.
Dates and times 3 columns
date_of_birthdatePatient's date of birth1982-03-15
diagnosis_datedateDate when the chronic condition was diagnosed2021-06-10
last_updateddatetimeTimestamp of the last update to this diagnosis record2023-12-04T09:24:00

Use it for

  • rows20019 columnsrows by gender93male107female

    A healthcare dashboard

    A breakdown of address_state. Excel, Power BI or Tableau.

  • What pattern can you find in 200 rows?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 200 rows.

  • A software demo

    Believable patients with first_name, last_name and date_of_birth to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 19 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows19 columns
Yours1,000 rows19 columnsaddress_street: UK only

blueprint · healthcare-chronic-condition-prevalence

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 19 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Include patient age and demographics
  • Log diagnosis dates and condition type
  • Flag comorbidities
  • Aggregate by provider and region
  • Integrate hospitalization rates
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
healthcare-chronic-condition-prevalence

What should your data show?

Preview 20 rows free
No signup. No card.