Sheet 01
OMOP Vocabulary & SQL
Concepts, standard vs classification vs source, mappings, the hierarchy, and the SQL patterns you actually write.
Open sheetQuick reference
Cheat sheets.
Printable quick-reference sheets; written against OMOP CDM v5.4.
Sheet 02
Cohort Definition Design
The five moving parts: entry, initial event limit, inclusion, exit and censoring, plus worked patterns and what to export.
Open sheetSheet 03
Characterization & Treatment Pathways
Target and event cohorts, persistence windows, a session flow that works, and how to read the sunburst and the tables.
Open sheetEach sheet prints cleanly to a few pages. They are written against OMOP CDM v5.4, the version supported by the OHDSI tool stack.
See the sheets do something
Worked examples
Dated walkthroughs that follow one clinical idea from a vocabulary search to a concept set, a cohort, and a research question.
Example 01 · Vocabulary release 29 Aug 2026
Menopause in the OMOP vocabularies
Review menopause and perimenopause vocabulary domains, source mappings, and open clinical questions, with current reference examples and a review prompt.
Open the exampleExample 02 · Current as of 4 Aug 2026
Preterm labor in the OMOP vocabularies
Preterm labor is not preterm birth, and the vocabulary keeps them apart. Search it, build both concept sets, and see which one your question needs.
Open the example