{"action":"created","issue":{"url":"https://api.github.com/repos/OHDSI/Atlas/issues/375","repository_url":"https://api.github.com/repos/OHDSI/Atlas","labels_url":"https://api.github.com/repos/OHDSI/Atlas/issues/375/labels{/name}","comments_url":"https://api.github.com/repos/OHDSI/Atlas/issues/375/comments","events_url":"https://api.github.com/repos/OHDSI/Atlas/issues/375/events","html_url":"https://github.com/OHDSI/Atlas/issues/375","id":213949753,"number":375,"title":"Duplicate rows in Cohort","user":{"login":"gowthamrao","id":13936600,"avatar_url":"https://avatars0.githubusercontent.com/u/13936600?v=4","gravatar_id":"","url":"https://api.github.com/users/gowthamrao","html_url":"https://github.com/gowthamrao","followers_url":"https://api.github.com/users/gowthamrao/followers","following_url":"https://api.github.com/users/gowthamrao/following{/other_user}","gists_url":"https://api.github.com/users/gowthamrao/gists{/gist_id}","starred_url":"https://api.github.com/users/gowthamrao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gowthamrao/subscriptions","organizations_url":"https://api.github.com/users/gowthamrao/orgs","repos_url":"https://api.github.com/users/gowthamrao/repos","events_url":"https://api.github.com/users/gowthamrao/events{/privacy}","received_events_url":"https://api.github.com/users/gowthamrao/received_events","type":"User","site_admin":false},"labels":[{"id":423994270,"url":"https://api.github.com/repos/OHDSI/Atlas/labels/cohort","name":"cohort","color":"5319e7","default":false},{"id":233937472,"url":"https://api.github.com/repos/OHDSI/Atlas/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2017-03-14T02:14:09Z","updated_at":"2017-09-08T13:24:41Z","closed_at":null,"author_association":"NONE","body":"\r\n[Request for Atlas UX changes for new Cohort Exit Criteria.pdf](https://github.com/OHDSI/Atlas/files/1218562/Request.for.Atlas.UX.changes.for.new.Cohort.Exit.Criteria.pdf)\r\nIn our instance, duplicate rows were produced. This probably can be resolved by using distinct as part of the SQL script. But, we dont know if this is an Atlas issue or how ETL was done into OMOP.\r\n\r\n### Expected behavior\r\nRows should be unique combination of cohort_definition_id, subject_id, cohort_start_date, cohort_end_date\r\n\r\n### Actual behavior\r\nDuplicate rows with same data\r\n\r\n### Steps to reproduce behavior\r\nhttp://www.ohdsi.org/web/atlas/#/cohortdefinition/98643\r\n\r\nFor the above query, visit_occurrence has duplicate rows. During our ETL, we allowed visits with same dates to be different rows i.e. there are multiple rows for the same person with same visit_start_date and visit_end_date. Is this the reason?"},"comment":{"url":"https://api.github.com/repos/OHDSI/Atlas/issues/comments/328102344","html_url":"https://github.com/OHDSI/Atlas/issues/375#issuecomment-328102344","issue_url":"https://api.github.com/repos/OHDSI/Atlas/issues/375","id":328102344,"user":{"login":"gowthamrao","id":13936600,"avatar_url":"https://avatars0.githubusercontent.com/u/13936600?v=4","gravatar_id":"","url":"https://api.github.com/users/gowthamrao","html_url":"https://github.com/gowthamrao","followers_url":"https://api.github.com/users/gowthamrao/followers","following_url":"https://api.github.com/users/gowthamrao/following{/other_user}","gists_url":"https://api.github.com/users/gowthamrao/gists{/gist_id}","starred_url":"https://api.github.com/users/gowthamrao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gowthamrao/subscriptions","organizations_url":"https://api.github.com/users/gowthamrao/orgs","repos_url":"https://api.github.com/users/gowthamrao/repos","events_url":"https://api.github.com/users/gowthamrao/events{/privacy}","received_events_url":"https://api.github.com/users/gowthamrao/received_events","type":"User","site_admin":false},"created_at":"2017-09-08T13:24:41Z","updated_at":"2017-09-08T13:24:41Z","author_association":"NONE","body":"Closed - Cohort era-fy option OHDSI/WebAPI#234"}}
{"actor":{"display_login":"gowthamrao"}}