inspectomop.queries.care_site.facility_counts_by_type

inspectomop.queries.care_site.facility_counts_by_type(inspector, return_columns=None)

Returns facility counts by type in the OMOP CDM i.e. # Inpatient Hospitals, Offices, etc.

Parameters:

  • inspector (inspectomop.inspector.Inspector)

  • return_columns (list of str, optional) –

    • optional subset of columns to return from the query

    • columns : [‘place_of_service’, ‘place_of_service_concept_id’, ‘facility_count’]

Returns:

results

Return type:

sqlalchemy.sql.expression.Executable

Notes

Original SQL

CS01: Care site place of service counts:

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;