Data Management & Extraction Consultation

We offer data expertise in three areas:

1. 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).

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

Learn more about using clinical data for research

2. Data Management Services

  • Data cleaning & formatting
  • Data de-identification
  • General management advice
  • Choosing platform
  • Querying existing database
  • REDCap database advice
  • Grant preparation
  • Merging datasets
  • NLP (Natural Language Processing)
  • Data De-identification Validation
  • Other data management issues

3. Comparative Effectiveness Large Dataset Analysis

  • Study design/conceptualization
  • Addressing common methodological issues in analysis of observational data
  • Data dataset selection
  • Dataset acquisition
  • Administrative support
  • Dataset uploading and downloading
  • Query design and cohort selection
  • Dataset cleaning
  • Dataset linking
  • Programming support
  • Collaboration, building collaborative relationships for data sharing

Login to request consultation UCSFnon-UCSF