search

ExposuresProvider / icees-api

MIT License
2 stars 8 forks source link

Integrated feature tables - single-selection cohort? #75

Open karafecho opened 3 years ago

karafecho commented 3 years ago

This issue was initiated wrt the 2017-2019 integrated feature tables, which were deployed in late Nov 2020 / early Dec 2020, but appears to apply more generally to all tables. The tables are missing data, with column headers either not represented or empty. For instance:

image

karafecho commented 3 years ago

Also see this summary, from related queries:

Create cohort: {}, year 2019, N = 161,911, COHORT:3 Create cohort: CervicalCancerDx <>”0”, year 2019, N <=10*

Create cohort: {}, year 2018, N = 162,691, COHORT:13 Create cohort: CervicalCancerDx <>”0”, year 2018, N <=10*

Create cohort: {}, year 2017, N = 163,392, COHORT:14 Create cohort: CervicalCancerDx <>”0”, year 2017, N <=10*

Create cohort: {}, year 2016, N = 163,986, COHORT:12 Create cohort: CervicalCancerDx <>”0”, year 2016, N = 64, COHORT:300

Create cohort: {}, year 2015, N 164,493, COHORT:15 Create cohort: CervicalCancerDx <>”0”, year 2015, N = 85, COHORT:299

Create cohort: {}, year 2014, N = 164,909, COHORT:16 Create cohort: CervicalCancerDx <>”0”, year 2014, N = 64, COHORT:298

Create cohort: {}, year 2013, N =165,244, COHORT:17 Create cohort: CervicalCancerDx <>”0”, year 2013, N = 37, COHORT:297

Create cohort: {}, year 2012, N = 165,517, COHORT:18 Create cohort: CervicalCancerDx <>”0”, year 2012, N = 24, COHORT:296

Create cohort: {}, year 2011, N = 165,746, COHORT:19 Create cohort: CervicalCancerDx <>”0”, year 2011, N = 19, COHORT:295

Create cohort: {}, year 2010, N = 165,904, COHORT:11 Create cohort: CervicalCancerDx <>”0”, year 2010, N = 16, COHORT:294

*Does not seem correct, but may be real?

karafecho commented 3 years ago

A quick check of the underlying patient tables for counts of patients with CervicalCancerDx=1 reveals the following:

year 2010, N =16 year 2011, N = 19 year 2012, N = 24 year 2013, N = 37 year 2014, N = 64 year 2015, N = 85 year 2016, N = 64

(Note that I did not have the 2017-2019 tables available locally when I ran this test.)