This query is used to count the care sites associated with the place of service type. This query is only available from CDM V4 and above.
Input:
<None>
Sample query run:
The following is a sample run of the query.
select cs.place_of_service_concept_id, count(1) places_of_service_count
from care_site cs
group by cs.place_of_service_concept_id
order by 1
;
Output:
Output field list:
| Field |
Description |
| place_of_service_concept_id |
A foreign key that refers to a place of service concept identifier in the vocabulary. |
| places_of_service_count |
|
Sample output record:
| Field |
Description |
| place_of_service_concept_id |
|
| places_of_service_count |
|
| 