Person‎ > ‎

PE14: Count of care sites, stratified by provider

This query is used to count the care sites (care_site_id) across all person records stratified by the provider (provider_id). All existing value combinations are summarized. This query is only available from CDM V4 and above.


Sample query run:
The following is a sample run of the query to run a search in your database schema.
SELECT p.provider_id, 
       count(1) num_person
FROM  person p
GROUP BY p.provider_id, p.care_site_id
 Field  Description
 provider_id  Provider identifier
 care_site_id  Care site identifier
 num_persons  Number of patients in the dataset  

Sample output record:
 Field  Value
 provider_id  71
 care_site_id  0
 num_persons  13070