Person‎ > ‎

PE13: Count of providers

This query is used to count the providers (provider_id) across all person records. This query is only available from CDM V4 and above.

Input:
<None>

Sample query run: 
SELECT provider_id, 
       count(*) AS num_person
FROM   PERSON
GROUP BY provider_id
Output:
Output field list:
 Field  Description
 provider_id  Primary care provider ID
 num_person  Number of patients associated with specific provider

Sample output record:
 Field  Value
provider_id  
 num_person  4466771
Comments