Hi all,
Does anyone know if it’s possible to query the location.state column within an ATLAS cohort definition? It sounds like adding a location region is the suggested method (from this post), but that seems to rely on location concept ids, which my database doesn’t seem to have populated (they all show 0 persons/records). We do have the location.state column, which contains a two digit state code (e.g., NY for New York) for each person_id, but those don’t seem to have any relationship with the concept table. Are state concept ids supposed to be stored in the country_concept_id column (I don’t see state_concept_id)? Any help would be greatly appreciated.