Data logistics system enabling real-time pathogen surveillance. Built for the Seattle Flu Study.

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