Critical terminology

For your data query, you can access different data tables. Some information can be found across 2 or more data tables. For example, questions can be found in the “OBSERVATION” table. the “DS_SURVEY” table and the “CONCEPT” table. However, in your script, each of these tables refers to the question using a different terminology or ID.

Open

Example:

The question “How confident are you filling out medical forms by yourself?” has the question ID 1585766 and the question code “OverallHealth_MedicalFormConfidence”. If we want to request information about this question from the DS_SURVEY table, our question ID is stored under “question_concept_id“:

Find your IDs and PHI here Athena

And see instructions here Athena lookup table

Open