Concepts are built using queries and are used to build cohorts.


A concept is a list made up of one or more queries and are specific to a schema. Concepts are combined to build cohorts and are meant to be reused across multiple cohorts.

For example the concept below (which would be used here]) is for Depression for the EHR_TUVA_SCHEMA:

"name": "ehr_depression"
"schema": "EHR_TUVA_SCHEMA",
"definition": [
           {"table": "condition", "column": "code", "operator": "=", "value": "F329"}, 
           {"table": "condition", "column": "code", "operator": "=", "value": "F32A"}
"private": False

Concepts and Cohorts can get very complicated, making sure all possible ways a concept can be encoded are covered. With that in mind, we offer a large number of public concepts and cohorts to jumpstart your ability to download and explore cohorts.

A concept that is marked at private will not be offered to other users. A concept that is marked public may be offered if it will help the community.



If a concept has been submitted as public and private it will be marked as public for all users.


The information you will receive when either listing concepts or getting information on a specific concept is:

  • id: the id of the concept
  • name: the name of the concept
  • status: whether the concept
  • schema: the schema of the concept
  • definition: the definition of the concept
  • sql_query: the sql query that is created from the concept definition


You can list all concepts here.

For a given concept you can: