Data Management & Extraction Consultation

We offer data expertise in three areas:

Request Clinical Data for Research

Select the Data Extraction option in your consultation request. A consultant will help you define a data specification, coordinate the request process, and estimate time required (initial hour is free).

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

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

Clinical Data for Research: Summary for Five Common Scenarios

ScenarioSelf-serve (Free)Consult Required (may have recharge)IRB neededRequires MyResearch account or other secure environmentIncludes clinical notesUC Health data available in addition to UCSF data
Counts Yes No No No No Yes   
De-ided data Yes No No No No Yes *
Limited data No Yes Yes Yes No Yes *
Id’ed data No Yes Yes Yes Yes Yes *
Recruitment No Yes Yes Yes No Yes *

* Process to obtain data from UC Health sites can be very lengthy

Explore APeX Data Codes

Use the APeX Pick List (Excel 26MB) tool to prepare for your UCSF Medical Record extraction request. Explore the most commonly used data codes to help define variables needed for your research and to define your cohort.

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

The codes will help you and your consultant define the Data Specification for your project.

Login to request consultation UCSFnon-UCSF