9.1. Overview for clinicians and researchers using the CRATE web interface¶
Welcome to CRATE. CRATE creates de-identified research databases from clinical records. Here are some of the things you can do.
9.1.1. For clinicians¶
There are some special (privileged) functions for clinicians:
- Search all text for an identified patient.
- Look up research IDs for identified patients.
- Request that your patient is contacted about a study.
Your administrator might also have set up a “standalone” clinician-only instance of CRATE so that you can use its Archive View to browse a read-only copy of a patient’s electronic health record (EHR).
9.1.2. For researchers¶
Standard query functions
- Build a database query interactively
- Write your own SQL queries
- Highlight text in results
- View query results in a standard table
- View query results in a “record-wise” table
- Download query results in TSV or Excel format
- Use a Patient Explorer query to find patients in the de-identified database.
More query functions
- Use SQL helpers to aid you in constructing lengthy queries.
- Use standard site queries, defined by your local database administrator, to answer commonly asked questions about your local data.
- Ask CRATE to show you the structure of your database in different ways.
- Use the Archive View to browse a de-identified record like a front-end electronic health record (EHR).
9.1.3. For researchers wishing to re-identify and contact patients¶
9.1.4. Your settings¶
188.8.131.52. Change your settings¶
You can change your display formatting settings here (such as the default number of items to show per page, and how long textual result fields need to be before the site “collapses” the result so you have to click to see everything).
184.108.40.206. Change your password¶
You can change your CRATE password here.