rw251 Github contribution chart
rw251 Github Stats
rw251 Most Used Languages

Activity

23 Nov 2022

Rw251

RLS to SharedCare schema

Pushed On 18 Nov 2022 at 09:19:46

Rw251

Add scripts for population counts - RQ051

Pushed On 18 Nov 2022 at 09:11:02

Rw251

Change RLS into SharedCare tables

Pushed On 18 Nov 2022 at 09:11:02

Rw251

Merge pull request #97 from rw251/change-RLS-to-SharedCare-reusable-queries

Change RLS into SharedCare tables

Pushed On 18 Nov 2022 at 09:11:02

Rw251

Merge branch 'master' into add-population-counts-RQ051

Pushed On 18 Nov 2022 at 09:11:02

Rw251

Create extraction files after updating reusable queries

Pushed On 18 Nov 2022 at 09:11:02

Rw251

Merge pull request #98 from rw251/add-population-counts-RQ051

Add population counts rq051

Pushed On 18 Nov 2022 at 09:11:02

Rw251

Merge branches 'master' and 'data-extract/rq038' of github.com:rw251/gm-idcr

Pushed On 18 Nov 2022 at 09:11:02

Rw251

Initial empty project

Pushed On 18 Nov 2022 at 09:02:59

Rw251

Started to work on extract sql

Pushed On 18 Nov 2022 at 09:02:59

Rw251

Merge branch 'master' into data-extract/rq038

Pushed On 18 Nov 2022 at 09:02:59

Rw251

Merge branch 'master' into data-extract/rq038

Pushed On 18 Nov 2022 at 09:02:59

Rw251

Merge branch 'data-extract/rq038' of github.com:rw251/gm-idcr into data-extract/rq038

Pushed On 18 Nov 2022 at 09:02:59

Rw251

Merge branch 'master' into data-extract/rq038

Pushed On 18 Nov 2022 at 09:02:59

Rw251

Merge branch 'master' into data-extract/rq038

Pushed On 18 Nov 2022 at 09:02:59

Rw251

Initial work on RQ038

Pushed On 18 Nov 2022 at 09:02:59

Rw251

Merge branch 'master' into data-extract/rq038

Pushed On 18 Nov 2022 at 09:02:59

Rw251

More files for rq038

Pushed On 18 Nov 2022 at 09:02:59

Rw251

Merge branches 'master' and 'data-extract/rq038' of github.com:rw251/gm-idcr

Pushed On 18 Nov 2022 at 09:02:59

Rw251

More files for rq038

Pushed On 18 Nov 2022 at 08:59:17

Rw251

Extra code sets for RQ019

Pushed On 09 Nov 2022 at 03:46:13

Rw251

Slight tweak to RQ019

Pushed On 09 Nov 2022 at 03:46:13

Rw251

Merge branch 'master' of github.com:rw251/gm-idcr

Pushed On 09 Nov 2022 at 03:46:13

Rw251

Moved some scripts to new schema (SharedCare instead of RLS)

Pushed On 09 Nov 2022 at 03:46:13

Rw251

Merge branch 'master' into data-extract/rq038

Pushed On 09 Nov 2022 at 03:46:13

Rw251

Initial work on RQ038

Pushed On 09 Nov 2022 at 03:45:28

Rw251

Moved some scripts to new schema (SharedCare instead of RLS)

Pushed On 09 Nov 2022 at 03:43:41

Rw251

Extra code sets for RQ019

Pushed On 09 Nov 2022 at 03:40:52

Rw251

Slight tweak to RQ019

Pushed On 09 Nov 2022 at 03:40:52

Rw251

Merge branch 'master' of github.com:rw251/gm-idcr

Pushed On 09 Nov 2022 at 03:40:52

Rw251

new hormone medications code sets for RQ041

  • male sex hormones
  • female sex hormones
  • anabolic steroids

Pushed On 09 Nov 2022 at 02:54:29

Rw251

Data extract/rq042 byrne (#69)

  • Added initial pass of SNOMED codes for new meds

  • Initial commit of main cohort sql

  • Just the med code sets to go now

  • Added dental codes from PI

  • Added todo

  • Dental problems validated

  • Code set for antibac drugs

  • Final checks for RQ042

  • Added missing commas

  • Added GP Encounter flag

  • Removed copy/pasted RDE check

  • Changes following approved PR

Pushed On 09 Nov 2022 at 02:54:29

Rw251

Filter RQ042 to events prior to 1st July 2022

Pushed On 09 Nov 2022 at 02:54:29

Rw251

Filter RQ048 to events prior to 1st July 2022

Pushed On 09 Nov 2022 at 02:54:29

Rw251

Code sets for RQ051

Pushed On 09 Nov 2022 at 02:54:29

Rw251

Add folder 2 for benzodiazepine

Pushed On 09 Nov 2022 at 02:54:29

Rw251

Add new medication code set

Pushed On 09 Nov 2022 at 02:54:29

Rw251

update commenting for RQ041 files

Pushed On 09 Nov 2022 at 02:54:29

Rw251

run JS to generate SQL for RQ041

Pushed On 09 Nov 2022 at 02:54:29

Rw251

Merge branch 'master' of https://github.com/rw251/gm-idcr

Pushed On 09 Nov 2022 at 02:54:29

Rw251

Fix BMI -> BP typo

Pushed On 09 Nov 2022 at 02:54:29

Rw251

Update-with-requested-changes

Pushed On 09 Nov 2022 at 02:54:29

Rw251

Merge pull request #73 from rw251/medication-codes-RQ051

Code sets for RQ051

Pushed On 09 Nov 2022 at 02:54:29

Rw251

Exclude concentration codes from benzodiazepine codes

Pushed On 09 Nov 2022 at 02:54:29

Rw251

Merge pull request #74 from rw251/add-benzodiazepine-RQ051

Add folder 2 for benzodiazepine

Pushed On 09 Nov 2022 at 02:54:29

Rw251

Add codes to MCH code set

  • README still needs updating with prevalence

Pushed On 09 Nov 2022 at 02:54:29

Rw251

Tidy extraction folder for RQ041

Pushed On 09 Nov 2022 at 02:54:29

Rw251

Update RQ041 template scripts based on Richard's comments

  • Uses a reusable query to define the cohort

Pushed On 09 Nov 2022 at 02:54:29

Rw251

New reusable query for defining RQ041 cohort

  • adjusted logic for ACR and EGFR tests
  • split out ACR and EGFR tables

Pushed On 09 Nov 2022 at 02:54:29

Rw251

fix code set format and delete empty files

Pushed On 09 Nov 2022 at 02:54:29

Rw251

Feat/efi (#91)

  • Add efi skeleton

  • Removed 33 snomed lists

  • 33 CTV lists for efi

  • Readv2 for the 33 efi deficits

  • Readv2 stroke and chd

  • Added chd/stroke ctv3 codes

  • Removed two codes that aren't actually in efi

  • Added extra logic for deficits from values

  • Further efi work

  • Final version of EFI logic

  • Revert unnecessary change

  • Add readme to efi code sets

  • Revert unnecessary change

Pushed On 09 Nov 2022 at 02:52:24
Pull Request

Rw251

Feat/efi

Created On 09 Nov 2022 at 02:52:23

Rw251

Revert unnecessary change

Pushed On 09 Nov 2022 at 02:52:04

Rw251

Revert unnecessary change

Pushed On 09 Nov 2022 at 02:48:47

Rw251

Add readme to efi code sets

Pushed On 09 Nov 2022 at 02:48:47

Rw251

Final version of EFI logic

Pushed On 09 Nov 2022 at 02:37:15

Rw251

Allow national projects to be "stitched"

Pushed On 08 Nov 2022 at 10:42:56

Rw251

Script to define the cohort

Pushed On 08 Nov 2022 at 10:42:56

Rw251

Script to perform the matching

Pushed On 08 Nov 2022 at 10:42:56

Rw251

Script to collate data

Pushed On 08 Nov 2022 at 10:42:56

Rw251

Script for smoking status

Pushed On 08 Nov 2022 at 10:42:56

Rw251

Updated main scripts

Pushed On 08 Nov 2022 at 10:42:56

Rw251

Script to get patient LSOA

Pushed On 08 Nov 2022 at 10:42:56

Rw251

Script for townsend score

Pushed On 08 Nov 2022 at 10:42:56

Rw251

Removed redundant files

Pushed On 08 Nov 2022 at 10:42:56

Rw251

Extra diabetes codes

Pushed On 08 Nov 2022 at 10:42:56

Rw251

Insert limited to 1000 entrie

Pushed On 04 Nov 2022 at 10:16:53

Rw251

Updated to the latest system suppliers

Pushed On 04 Nov 2022 at 10:09:57

Rw251

Limit to just people with a record from the GP spine

Pushed On 04 Nov 2022 at 10:09:57

Rw251

Fixed typo

Pushed On 03 Nov 2022 at 05:02:15
Create Branch
Rw251 In rw251/gm-idcr Create Branchdata-extract-change/rq043

Rw251

All scripts and clinical code sets for interacting with the Greater Manchester Integrated Digital Care Record

On 03 Nov 2022 at 05:00:57

Rw251

Death within 28 days correction (#93)

    • Death within 28 days corrected
  • Prevent post COPI processed data
  • Remove typo

Pushed On 03 Nov 2022 at 03:29:14
Pull Request

Rw251

Death within 28 days correction

Created On 03 Nov 2022 at 03:29:14

Rw251

RQ041 changes requested by PI

PI has requested that we search back further than 2016 when looking for biochemical evidence of CKD. This does not mean we are providing data which goes back further, but the cohort will now be more comprehensive as it looks further back. The following fields have been added to the patient file:

• EarliestEgfrEvidence = Earliest date of Egfr evidence for CKD (as per agreed criteria) • EarliestAcrEvidence = Earliest date of ACR evidence for CKD (as per agreed criteria) • CodedCKDAtStudyStart = 1 if patient was diagnosed with CKD before March 2018, 0 if not • CodedCKDDuringStudyPeriod = 1 if patient was diagnosed with CKD between March 2018 and March 2022, 0 if no

Merged On 03 Nov 2022 at 10:52:35

Rw251

Commented On 03 Nov 2022 at 10:52:35
Pull Request

Rw251

Fix for death within 28 days

Created On 03 Nov 2022 at 10:48:07

Rw251

  • No data post-COPI (#92)

  • Death within 28 days corrected

Pushed On 03 Nov 2022 at 10:48:08

Rw251

Typo fixed

Pushed On 28 Oct 2022 at 12:51:31
Create Branch
Rw251 In rw251/gm-idcr Create Branchdata-extract-change/rq037-heald

Rw251

All scripts and clinical code sets for interacting with the Greater Manchester Integrated Digital Care Record

On 28 Oct 2022 at 09:52:51