inspectomop.queries.payer_plan.counts_by_years_of_coverage

inspectomop.queries.payer_plan.counts_by_years_of_coverage(inspector)

Returns counts of payer coverage based on continuous coverage (payer_plan_period_start_date - payer_plan_period_end_date)365.25. Note this method may count patients with more than one insurance plan multiple times. Ex pt with Medicare Parts A, B, and D.

Parameters:inspector (inspectomop.inspector.Inspector) – Returns:df Return type:pandas.DataFrame

Notes

Original SQL

PP01: Continuous years with patient counts:

SELECT
    floor((p.payer_plan_period_end_date - p.payer_plan_period_start_date)/365) AS year_int,
    count(1) AS num_patients
FROM
    payer_plan_period p
GROUP BY
    floor((p.payer_plan_period_end_date - p.payer_plan_period_start_date)/365)
ORDER BY 1;