inspectomop.queries.person.patient_counts_by_year_of_birth¶

inspectomop.queries.person.patient_counts_by_year_of_birth(inspector, person_ids=None, return_columns=None)¶

Returns patient counts grouped by year of birth for the database or alternativily, for a supplied list of person_ids.

Parameters:	person_ids (list of int, optional) – list of person_ids [int]. If None (default), get the gender distribution for all individuals in the person table inspector (inspectomop.inspector.Inspector) – return_columns (list of str, optional) – optional subset of columns to return from the query columns : [‘year_of_birth’, ‘count’]
Returns:	results
Return type:	inspectomop.results.Results

Notes

Original SQL

PE06: Number of patients grouped by year of birth:

SELECT
    year_of_birth,
    COUNT(person_id) AS Num_Persons_count
FROM
    person
GROUP BY
    year_of_birth
ORDER BY
    year_of_birth;