inspectomop.queries.care_site.patient_counts_by_care_site_type

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

Returns pateints counts by facility type.

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’, ‘patient_count’]
Returns:

results

Return type:

inspectomop.results.Results

Notes

Original SQL

CS02: Patient count per care site place of service:

SELECT
    cs.place_of_service_concept_id,
    count(1) num_patients
FROM
    care_site cs,
    person p
WHERE
    p.care_site_id = cs.care_site_id
GROUP BY
    cs.place_of_service_concept_id
ORDER BY 1;