Race and Ethnicity
Pull out responses about race and ethnicity.
Motivation
- Remove need for digging into the JSON for queries.
Challenges
- 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) ???