phea
An R package for electronic phenotyping. You write formulas over long-form patient-event tables and phea generates the SQL, including for values that change over time.
Work
A decade of health-data work: at NIH and Columbia, in pharma and health systems, and at value-based-care companies and startups.
An R package for electronic phenotyping. You write formulas over long-form patient-event tables and phea generates the SQL, including for values that change over time.
Scrapes the full WHO ATC/DDD index into an analysis-ready table. My most-used open-source tool.
Maps FDA National Drug Codes to ATC classes (plus VA classes, MeSH and SNOMED) via RxNorm. It began as an AMIA 2017 paper.
Interactive county maps of Medicaid provider spending by HCPCS code and by drug class, 2018–2024, built from 238M claim rows.
An ETL from the CMS VRDC to the OHDSI CDM, plus SAS study code on Medicare Shared Savings, opioid use, and drugs and dementia risk in the elderly.
Things I build end to end in my own time, from firmware to mobile apps.
A pixel-art social network built around physical displays, with a web app, an iOS/Android app with an offline editor, and real-time delivery to devices over MQTT. Built solo.
A 4-inch touchscreen pixel-art player on the ESP32-P4. It plays Makapix, museum collections and PICO-8, and was featured in Make: magazine.
A 64×64 RGB LED desk display in a 3D-printed shell, showing pixel art, a clock and the weather.
Email me a few lines about your data, your question and your timeline. I reply personally.