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.

Input:
<None>

Sample query run:
The following is a sample run of the query to run a search in your database schema.

SELECT p.provider_id, 
       p.care_site_id, 
       count(1) num_person
FROM  person p
GROUP BY p.provider_id, p.care_site_id

Output:

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