The-Strategy-Unit / The-Strategy-Unit/nhp_data
Readmission of previously well babies
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 2
- Forks
- 3
- Avg merge
- 17h 57m
- Merged PRs (30d)
- 7
Description
There is a subtle difference between the old logic used when we extracted from our Sql server and what we are using here.
Previously, we join the nhp inpatients view to itself. We now join the nhp inpatients table (which only includes a subset of providers) to the base inpatients table (which includes all providers).
The subtle difference is in the Sql version, the inpatients view is filtered to remove well babies. So, our new logic is including more "readmissions" because we have cases where a baby is readmitted within 28 days of birth, but we previously didn't count this as a readmission because we were filtering out the well baby rows.
I think that this is an oversite, and the new logic is correct. This issue is being created purely to note this difference and allow anyone to have a differing opinion.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.