Utility FunctionsFunctions for reading or writing data from various sources |
|
---|---|
Clean and Read a SQL query |
|
Connect to a SQL database |
|
Read a table from a SQL database |
|
Write a table to a SQL database |
|
Download a csv from a zip |
|
Lookup table switch handler |
|
Data Management FunctionsFunctions for handling, cleaning and processing public health data |
|
NHS Number Validity Check |
|
Patient ID record grouping |
|
HES/SUS Episode Date Cleaning |
|
Continuous Inpatient (CIP) Spells |
|
Grouping of intervals or events in time together |
|
Respeciate unspecified samples |
|
Inpatient Codes cleanup |
|
Link A&E to Inpatient records |
|
Lookup tablesLookup tables used to reclassify, regroup, or translate data |
|
Bacterial Genus Gram Stain Lookup Table |
|
Respeciated organisms |
|
Specimen type grouping |