nhanes.librehealth.io has been updated with a new data. It now includes blood pressure readings, height,weight, BMI and waist circumference measurements.
For reporting, I’m old school for now, and run SQL directly against the database, either in a workbench tool, or if customers need to repeatedly run complicated reports, I write PHP to build up the queries and parse the results.
Here’s an interesting “basic” query that I don’t think is available through the EHR itself:
The forum won’t let attach a .CSV, so I’m just pasting the results here:
select count(), title,diagnosis from lists where type=‘medical_problem’ group by title,diagnosis order by count() desc;
count(*);title;diagnosis
1882;Essential (primary) hypertension;ICD10:I10
1826;Pure hypercholesterolemia, unspecified;ICD10:E78.00
1448;Mild intermittent asthma, uncomplicated;ICD10:J45.20
1365;Unspecified osteoarthritis, unspecified site;ICD10:M19.90
568;Type 2 diabetes mellitus without complications;ICD10:E11.9
511;Disorder of thyroid, unspecified;ICD10:E07.9
297;Unspecified chronic bronchitis;ICD10:J42
253;Elevated blood-pressure reading, without diagnosis of hypertension;ICD10:R03.0
239;Gout, unspecified;ICD10:M10.9
229;Cerebral infarction, unspecified;ICD10:I63.9
219;Liver disease, unspecified;ICD10:K76.9
203;Old myocardial infarction;ICD10:I25.2
200;Chronic kidney disease, unspecified;ICD10:N18.9
196;Chronic ischemic heart disease, unspecified;ICD10:I25.9
187;Heart failure, unspecified;ICD10:I50.9
140;Type 2 diabetes mellitus with unspecified diabetic retinopathy without macular edema;ICD10:E11.319
129;Angina pectoris, unspecified;ICD10:I20.9
100;Emphysema, unspecified;ICD10:J43.9
89;Malignant neoplasm of prostate;ICD10:C61
67;Malignant neoplasm of unspecified site of unspecified female breast;ICD10:C50.919
61;Other specified malignant neoplasm of skin, unspecified;ICD10:C44.99
40;Malignant neoplasm of colon, unspecified;ICD10:C18.9
38;Unspecified malignant neoplasm of skin, unspecified;ICD10:C44.90
33;Malignant neoplasm of cervix uteri, unspecified;ICD10:C53.9
33;Malignant melanoma of skin, unspecified;ICD10:C43.9
29;Malignant neoplasm of other specified ill-defined sites;ICD10:C76.8
27;Dependence on renal dialysis;ICD10:Z99.2
22;Malignant neoplasm of uterus, part unspecified;ICD10:C55
15;Malignant neoplasm of bladder, unspecified;ICD10:C67.9
15;Malignant neoplasm of lymphoid, hematopoietic and related tissue, unspecified;ICD10:C96.9
14;Malignant neoplasm of thyroid gland;ICD10:C73
14;Malignant neoplasm of unspecified part of unspecified bronchus or lung;ICD10:C34.90
12;Malignant neoplasm of unspecified ovary;ICD10:C56.9
10;Malignant neoplasm of unspecified kidney, except renal pelvis;ICD10:C64.9
9;Malignant neoplasm of stomach, unspecified;ICD10:C16.9
6;Malignant neoplasm of bone and articular cartilage, unspecified;ICD10:C41.9
6;Malignant neoplasm of larynx, unspecified;ICD10:C32.9
6;Malignant neoplasm of esophagus, unspecified;ICD10:C15.9
5;Malignant neoplasm of unspecified testis, unspecified whether descended or undescended;ICD10:C62.90
5;Malignant neoplasm of rectum;ICD10:C20
4;Malignant neoplasm of pancreas, unspecified;ICD10:C25.9
3;Malignant neoplasm of brain, unspecified;ICD10:C71.9
2;Leukemia, unspecified not having achieved remission;ICD10:C95.90
2;Malignant (primary) neoplasm, unspecified;ICD10:C80.1
1;Malignant neoplasm of liver, not specified as primary or secondary;ICD10:C22.9
1;Other and unspecified malignant neoplasms of lymphoid, hematopoietic and related tissue;ICD10:C96.9
1;Malignant neoplasm of mouth, unspecified;ICD10:C06.9
1;Malignant neoplasm of connective and soft tissue, unspecified;ICD10:C49.9