Data logistics system enabling real-time genomic epidemiology. Built for the Seattle Flu Study.
Source code
Contributors
Latest commits
Pages

Race and Ethnicity

Pull out responses about race and ethnicity.

Motivation

  1. Remove need for digging into the JSON for queries.

Challenges

  1. Should these instead be a custom domain (text[] with a check constraint on values)?

Sketch of a schema

For race and ethnicity (hispanic/latino):

race
  race_id
  name
  snomedct_term

encounter_race
  encounter_id
  race_id

encounter
  hispanic_or_latino (bool) ???

Prior art