After watching YouTube tutorial on Atlas, I am trying to select all unique patients in my
condition_occurrence table through Atlas like as shown below. So, I didn’t impose any observation period criteria but still I don’t get the same count of records as in my database.
- Earliest event - one record per patient - I expect to see 3712 but it’s 3236
- All events - All patient records - I expect to see 3712 records but its again 3236.
As you can see, I have changed the
restrict initial events section. I also verified the SQL generated manually. and the only difference is where the filter is applied for earliest event
WHERE P.ordinal = 1. Query does do
select * from condition_occurrence.
My cohort exit is
end of continuous observation, so there should be atmost
one record for each person. Right?
My observation periods are based on visit start and end dates. So, I don’t see any problem due to this.
When my objective is only to select all patients from a specific table, do I still have to be concerned about concept_ids?
Am I missing something here?
Here is the cohort created in public atlas click here
@Chris_Knoll - Can you help?