Problem List and Diagnoses
This dataset provides a comprehensive record of active and historical patient problems and diagnoses, including standardized ICD-10 codes, onset and resolution dates, severity, and clinical status. It is designed for chronic disease management, clinical quality reporting, and longitudinal patient care analytics, supporting both clinical workflows and regulatory compliance.
Sample rows
preview · 8 of 100 rows · all 12 columns| problem_idstring | severitystring | entered_bystring | patient_idstring | problem_namestring | icd10_codestring | onset_datedate | resolution_datedate | clinical_statusstring | problem_typestring | entry_datedatetime | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|
| PL100001 | moderate | dr.j.smith | PAT001 | Type 2 Diabetes Mellitus | E11.9 | 2019-04-12 | blank | active | chronic | 2019-04-12T10:22:00 | Patient shows increased fasting glucose levels. |
| PL100002 | mild | nurse.a.hall | PAT002 | Hypertension | I10 | 2021-02-18 | blank | active | chronic | 2021-02-19T08:15:00 | Blood pressure elevated during annual check. |
| PL100003 | moderate | dr.m.lee | PAT003 | Asthma | J45.909 | 2012-08-25 | blank | active | chronic | 2012-08-25T09:10:00 | Prescribed inhaler. |
| PL100004 | mild | dr.s.ramirez | PAT004 | Acute Bronchitis | J20.9 | 2023-01-03 | 2023-01-18 | resolved | acute | 2023-01-04T10:05:00 | Symptoms resolved post antibiotics. |
| PL100005 | mild | dr.e.chen | PAT005 | Hyperlipidemia | E78.5 | 2020-05-11 | blank | active | chronic | 2020-05-11T11:30:00 | Total cholesterol 220 mg/dL. |
| PL100006 | severe | dr.s.brown | PAT006 | Major Depressive Disorder | F32.9 | 2022-03-14 | blank | active | chronic | 2022-03-14T14:00:00 | Referred to psychiatry. |
| PL100007 | mild | nurse.c.evans | PAT007 | Acute Sinusitis | J01.90 | 2024-02-05 | 2024-02-15 | resolved | acute | 2024-02-05T08:50:00 | Patient responded well to antibiotics. |
| PL100008 | moderate | dr.g.martin | PAT008 | Obesity | E66.9 | 2015-11-28 | blank | active | chronic | 2015-11-28T12:35:00 | BMI 32.4. |
| PL100009 | mild | dr.t.jones | PAT009 | Seasonal Allergic Rhinitis | J30.2 | 2023-04-21 | blank | active | chronic | 2023-04-21T10:10:00 | Prescribed antihistamines. |
| PL100010 | moderate | dr.h.patel | PAT010 | Chronic Kidney Disease Stage 3 | N18.3 | 2018-09-13 | blank | active | chronic | 2018-09-13T15:45:00 | eGFR 48 mL/min/1.73m2. |
| PL100011 | severe | dr.r.cho | PAT011 | Acute Appendicitis | K35.80 | 2022-06-07 | 2022-06-10 | resolved | acute | 2022-06-07T10:30:00 | Appendectomy performed. |
| PL100012 | severe | dr.a.nguyen | PAT012 | Chronic Obstructive Pulmonary Disease | J44.9 | 2017-10-19 | blank | active | chronic | 2017-10-20T09:15:00 | Patient is a lifelong smoker. |
| PL100013 | mild | nurse.l.torres | PAT013 | Iron Deficiency Anemia | D50.9 | 2020-01-09 | 2020-03-17 | resolved | acute | 2020-01-09T13:20:00 | Patient responded to iron supplementation. |
| PL100014 | moderate | dr.s.barton | PAT014 | Migraine | G43.909 | 2023-07-22 | blank | active | chronic | 2023-07-22T16:30:00 | Prescribed triptans. |
| PL100015 | mild | dr.j.baker | PAT015 | Acute Pharyngitis | J02.9 | 2022-12-05 | 2022-12-14 | resolved | acute | 2022-12-05T10:00:00 | Symptoms improved with supportive care. |
| PL100016 | moderate | dr.j.smith | PAT001 | Hyperthyroidism | E05.90 | 2021-03-17 | blank | active | chronic | 2021-03-17T12:40:00 | Patient started on methimazole. |
| PL100017 | mild | dr.e.chen | PAT016 | Gastroesophageal Reflux Disease | K21.9 | 2016-06-03 | blank | active | chronic | 2016-06-03T10:38:00 | Lifestyle modification recommended. |
| PL100018 | mild | nurse.c.evans | PAT017 | Acute Otitis Media | H66.90 | 2024-04-11 | 2024-04-20 | resolved | acute | 2024-04-11T07:55:00 | Amoxicillin prescribed. |
| PL100019 | moderate | dr.g.martin | PAT018 | Osteoarthritis | M19.90 | 2013-09-17 | blank | active | chronic | 2013-09-17T11:05:00 | Joint pain in knees and hips. |
| PL100020 | unknown | dr.t.jones | PAT019 | History of Smoking | Z87.891 | 2008-03-12 | 2017-05-01 | resolved | historical | 2017-05-01T10:15:00 | Patient quit smoking in 2017. |
What the 100 rows show
from the 100-row sample- 4clinical statuses
- 4problem types
- string 9
- date 2
- datetime 1
Columns
12 columns in two groups| column | type | description | example |
|---|---|---|---|
| Text 9 columns | |||
problem_id | string | Unique identifier for each problem or diagnosis entryunique | PL100001 |
patient_id | string | Unique identifier for the patient associated with the problem | PAT001 |
problem_name | string | Clinical name or description of the problem or diagnosis | Type 2 Diabetes Mellitus |
icd10_code | string | ICD-10 code representing the diagnosis | E11.9 |
severity | string | Severity level of the problem (e.g., mild, moderate, severe)mild · moderate · severe · unknown · optional | moderate |
clinical_status | string | Current clinical status of the problem (e.g., active, inactive, resolved)6 values | active |
problem_type | string | Type of problem (e.g., chronic, acute, historical)chronic · acute · historical · other · optional | chronic |
entered_by | string | Identifier or name of the clinician who entered the problemoptional | dr.j.smith |
notes | string | Additional notes or comments about the problem or diagnosisoptional | Prescribed inhaler. |
| Dates and times 3 columns | |||
onset_date | date | Date when the problem or diagnosis was first identified | 2019-04-12 |
resolution_date | date | Date when the problem or diagnosis was resolved, if applicableoptional | 2023-01-18 |
entry_date | datetime | Date and time when the problem was entered into the system | 2019-04-12T10:22:00 |
Use it for
A healthcare dashboard
A breakdown of entered_
by. Excel, Power BI or Tableau. What pattern can you find in 100 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 100 rows.
- Problems100PL100001moderatePL100002mildPL100003moderate
A software demo
Believable problems with patient_
id, problem_ name and icd10_ code to fill a screen in front of a buyer.
This dataset100 rows12 columns
Yours1,000 rows12 columns
blueprint · problem-list-and-diagnoses
Behind this dataset
Same schema. As many rows as you need.
These 100 rows came out of a blueprint — 12 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
- Problem ID unique per problem
- ICD-10-CM diagnosis code required
- Problem status: active, inactive, resolved
- Onset date and resolution date
- Severity: mild, moderate, severe
- Chronic vs acute classification
- Primary problem designation
- Provider who added problem documented
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
- problem-list-and-diagnoses