inspectomop.queries.condition.place_of_service_counts_for_condition_concept_id

inspectomop.queries.condition.place_of_service_counts_for_condition_concept_id(condition_concept_id, inspector, return_columns=None)

Provides counts of conditions stratified by place_of_service (Office, Inpatient Hospital, etc.)

Parameters:

• condition_concept_id (int) – concept_id from the conditions table
• inspector (inspectomop.inspector.Inspector) –
• return_columns (list of str, optional) –
  • optional subset of columns to return from the query
  • columns : [‘condition_concept_id’, ‘condition_concept_id,’place_of_service_concept_id’, ‘place_of_service’, ‘place_freq’]

Returns:

results – a cursor-like object with methods such as fetchone(), fetchmany() etc.

Return type:

inspectomop.results.Results

Notes

SQL Modified from:

CO04: Count In what place of service where condition diagnoses:

SELECT
    c.concept_id AS condition_concept_id,
    c.concept_name AS condition_concept_id,
    cs.place_of_service_concept_id AS place_of_service_concept_id,
    c_place.concept_name AS place_of_service,
    count(cs.place_of_service_concept_id) AS place_freq
FROM
    main.concept AS c, main.concept AS c_place,
    (SELECT
        co.condition_concept_id AS condition_concept_id,
        co.visit_occurrence_id AS s1_visit_id
    FROM
        main.condition_occurrence AS co
    WHERE
        co.condition_concept_id = :condition_concept_id_1
        AND co.visit_occurrence_id IS NOT NULL)
JOIN
    main.visit_occurrence AS vo
ON
    s1_visit_id = vo.visit_occurrence_id
JOIN
    main.care_site AS cs
ON
    vo.care_site_id = cs.care_site_id
WHERE
    c_place.concept_id = cs.place_of_service_concept_id
    AND c.concept_id = :concept_id_1
GROUP BY c.concept_name