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 – a cursor-like object with methods such as fetchone(), fetchmany() etc.
Return type:

inspectomop.results.Results

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;