Project Overview:  This project was done for a databases class as a demonstration project.  It was a precursor to my getting involved with the Sequoia Foundation’s Pharmacy Interoperability task force.

Approach:  Python Code was used to parse a FHIR json patient data sample, and then autogenerate SQL database insert statements. A MySQL demonstration database was constructed with 555 patients with at least one diabetes medication.

Project Outputs (Links to github):

• Final Presentation
• Python Code for Parsing FHIR Data
• SQL Scripts to Generate DB and Query Data
  • Create Tables
  • Patient Load
  • Mutli-Patient Load

References:

Synthea Mass: Synthetic FHIR Data Set:  Downloads | Synthea (mitre.org); https://github.com/synthetichealth/syntheticmass

FIHR Background:  Note: FHIR standard that aligns with the date (2021) of the SyntheaMass data set: https://hl7.org/fhir/R4/index.html

Featured Image: