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.
Sample output record: