inst/shinyApps/QueryLibrary/queries/care_site/CS01.md

In OHDSI/QueryLibrary: A Query Library for the OMOP-CDM

CS01: Care site place of service counts

Description

This query is used to count the care sites associated with the place of service type.

Query

SELECT
    cs.place_of_service_concept_id,
    COUNT(*) AS places_of_service_count
FROM @cdm.care_site AS cs
GROUP BY cs.place_of_service_concept_id
ORDER BY cs.place_of_service_concept_id
;

Input

None

Output

| 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 | Number of care sites associated with the place_of_service_concept_id |

Example output record

| Field | Description | | --- | --- | | place_of_service_concept_id | 8546 | | places_of_service_count | 1 |

Documentation

https://github.com/OHDSI/CommonDataModel/wiki/CARE_SITE

OHDSI/QueryLibrary documentation built on Aug. 1, 2023, 5:42 a.m.