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: 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;