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
Patient Explorer
- 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.
Database structure
- Ask CRATE to show you the structure of your database in different ways.
Archive view
- 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¶
- View and manage studies that you are part of.
- Submit contact requests, seeking to re-identify and communicate with patients subject to their explicit consent.
9.1.4. Your settings¶
9.1.4.1. 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).
9.1.4.2. Change your password¶
You can change your CRATE password here.
9.1.5. About CRATE¶
Show information about your CRATE server, including:
- a link to this documentation at https://crateanon.readthedocs.io/;
- the CRATE version your server is running;
- how to cite CRATE in publications;
- links to the CRATE source code and Python package;
- third-party licence details.