CONDITION ERA‎ > ‎

CE14: Counts of condition types

This query is used to count the condition types (condition_type_concept_id) across all condition era records. The input to the query is a value (or a comma-separated list of values) of a condition_type_concept_id. If the input is omitted, all possible values are summarized.

Input:
<None>

Sample query run:
The following is a sample run of the query. The input parameters are highlighted in blue
SELECT condition_type_concept_id, count(*) AS conditions_count
  FROM condition_era 
 GROUP BY condition_type_concept_id;
Output:
Output field list:
 Field  Description
condition_type_concept_id A foreign key to the predefined concept identifier in the vocabulary reflecting the parameters used to construct the condition era.

Sample output record:
 Field  Description
condition_type_concept_id  
Comments