This query generates the list of all vocabularies in the CONCEPT table (Standard and non-standard), their class, level and frequency.
Input:
<None>
Sample query run:
The following query returns list of statistics.
SELECT voc.vocabulary_id,
r.vocabulary_name,
voc.concept_class,
voc.concept_level,
voc.cnt
FROM (
SELECT vocabulary_id, concept_class, concept_level, COUNT(concept_id) cnt
FROM vocabulary.concept
GROUP BY vocabulary_id, concept_class, concept_level
) voc
JOIN vocabulary.vocabulary r ON voc.vocabulary_id=r.vocabulary_ID
ORDER BY 1,2,4,3
Output:
Output field list:
| Field |
Description |
| vocabulary_id |
OMOP Vocabulary ID |
| vocabulary_name |
Vocabulary name |
| concept_class | Concept Class | | concept_level | Concept Level Number | | cnt | Number of concepts |
Sample output record:
| Field |
Value |
| vocabulary_id |
1 |
| vocabulary_name |
SNOMED-CT |
| concept_class | Procedure | | concept_level | 2 | | cnt | 20286 |
|
|
