Data Extraction Consultation

Request Clinical Data for Research

Access UCSF/ZSFG electronic health records. A consultant will help you define a data specification, coordinate the request process, and estimate time required (initial hour is free).

Data Codes

Use the APeX Pick List (Excel 26MB via UCSF Box) tool to prepare for your extraction request. It includes the most commonly used data codes to help define variables needed for your research and to define your cohort. Find codes for:

  • Diagnoses
  • Meds
  • Labs
  • Procedures
  • Flowsheet
  • Departments
  • Smart Data Elements


Request Consultation

Hourly recharge fees may apply

Questions about UCSF COVID-19 Electronic Health Record Data For Research? We can help! Click on the link above to request a consultation.



Please send comments or questions to CTSI Consultation Services:
Email: [email protected]
Phone: 415-514-8021

If you have not been contacted by a member of the consulting team within three business days of submitting your request, please get in touch with us.

About Your Request

Cite CTSI CTSI heavily subsidizes consultations. Any publications that benefit from a consultation should cite the CTSI grant.

By submitting a request, you agree to provide feedback and a short evaluation of our services, providing the titles of manuscripts or grants resulting from your consultation(s) upon request.