The Los Angeles Data Resource (LADR) is a joint project of major Los Angeles health care provider organizations. The LADR helps clinical investigators to explore the size of potential research study cohorts using operational clinical data across all participating institutions. The Charles R. Drew University of Medicine and Science (CDU) LADR team sought to develop an innovative data architecture that would aggregate de-identified clinical data from safety-net providers in the community into CDU LADR node. This in turn would be federated with the other nodes of LADR for a shared view in a way that was never available before. This led to a self-service system to assess patients matching study criteria at each medical center and to search patients by demographics, ICD-9 codes, lab results and medications.