oxford-pharmacoepi / cdm-etl-gold

Apache License 2.0
0 stars 0 forks source link

Keeping only patients with observation period end date after 2001? #22

Closed edward-burn closed 9 months ago

edward-burn commented 9 months ago

A sizeable minority of patients have observation end dates that mean they will not be included in almost any of our studies. Excluding these patients from the omop version would mean a smaller database and quicker queries.

Based on the 100k sample from cdm_gold_202301

I don´t know what you think about this @daniprietoalhambra @ajoedicke @catalamarti? Are there any studies where you think we would need people who had left the database by 2005 for example?

daniprietoalhambra commented 9 months ago

I would be very happy to exclude those if this improves performance. It would be very rare for us to study patients who left GOLD before 2005

On 13 Feb 2024, at 14:54, edward-burn @.***> wrote:



A sizeable minority of patients have observation end dates that mean they will not be included in almost any of our studies. Excluding these patients from the omop version would mean a smaller database and quicker queries.

Based on the 100k sample from cdm_gold_202301

I don´t know what you think about this @daniprietoalhambrahttps://github.com/daniprietoalhambra @ajoedickehttps://github.com/ajoedicke @catalamartihttps://github.com/catalamarti? Are there any studies where you think we would need people who had left the database by 2005 for example?

— Reply to this email directly, view it on GitHubhttps://github.com/oxford-pharmacoepi/cdm-etl-gold/issues/22, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AJXXJRXQQVTGHHQMU6MC763YTNV75AVCNFSM6AAAAABDGRT4CWVHI2DSMVQWIX3LMV43ASLTON2WKOZSGEZTEMZYGAYTSMQ. You are receiving this because you were mentioned.Message ID: @.***>

catalamarti commented 9 months ago

Happy with that for me!

ajoedicke commented 9 months ago

I agree, happy to not have them included


From: catalamarti @.> Sent: Tuesday, February 13, 2024 4:09 PM To: oxford-pharmacoepi/cdm-etl-gold @.> Cc: Annika Jodicke @.>; Mention @.> Subject: Re: [oxford-pharmacoepi/cdm-etl-gold] Keeping only patients with observation period end date after 2001? (Issue #22)

Happy with that for me!

— Reply to this email directly, view it on GitHubhttps://github.com/oxford-pharmacoepi/cdm-etl-gold/issues/22#issuecomment-1941901239, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ACSOWBR2DUUXRX3SL7LB7ZTYTOF2PAVCNFSM6AAAAABDGRT4CWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNBRHEYDCMRTHE. You are receiving this because you were mentioned.Message ID: @.***>

adelmestri commented 9 months ago

Dear @daniprietoalhambra, @edward-burn, @catalamarti, @ajoedicke, sorry to be always the bad guy We have onboarded CDM GOLD with a certain amont of patients and followup time. Moreover, we have prepared the CDM GOLD metadata for the Erasmus Medical centre: these metadata have been published in the HMA and EMA public electronic catalogues of real-world data sources. All this work is based on the patients currently present in our CDM GOLD and changing that would require a big effort. Thanks