Goal
Using GitHub - openemr/demo-data-generator: Generate fictional demo data for testing of OpenEMR, supply realistic test data into OpenEMR with 100% record/encounter coverage.
Resources:
- GitHub - johnschrom/ambulatory-ehr-data: 300k patient records generated to be representative to US-states using NAMCS reference sqlite database
- NAMCS FHIR Solution · Issue #1 · MatthewVita/fake-patient-web · GitHub some thoughts on this problem, but from a generic FHIR perspective
- May just want to bug @andremillet and our other providers until we have ~100 really good sample patient records ?
Notes
- NAMCS isn’t perfect
- https://mimic.physionet.org may be a good idea…
How to fetch NAMCS data
SELECT *
FROM patient pat
LEFT JOIN diagnosis dia ON pat.patientid = dia.patientid
LEFT JOIN encounter enc ON pat.patientid = enc.patientid
LEFT JOIN prescription pre ON pat.patientid = pre.patientid
LEFT JOIN labresult lab ON pat.patientid = lab.patientid
LEFT JOIN measurement mea ON enc.encounterid = mea.encounterid
WHERE pat.patientid = ?;