This page has the list of all fields in the CHAVI database.

CHAVI hosts a wealth of clinical data related to the patients from whom the images have been obtained. This data is available in a relational database which allows you to construct complex queries to search the image data. Thus not only can you access this data of the dataset as a whole but you can also access data across different projects. The database architecture is described in the database page. This page has the list of all available database fields for which clinical data may be available. Please note that data in all fields may not be available for all patients.

Please note that this is the data dictionary and to search the available data you need credentials for the CHAVI repository

You can filter the list by the database table, field type as well as search for text keywords related to the field.

Select the database table to filter the list.
Choose the field type to filter the list.
Data Stored
Please enter one or more keywords to search and filter the list

Data Base Table Name comorbidity: This table allows storage of information on comorbidities that the patient has. As comorbidity grading and classification is variable the table allows multiple comorbidities to be coded separately. The table is linked to the patientinfo table. 
Database Table Field ID Field Type Data Stored in Field Allowed Values
comorbidity comorbidity_severity Character

Severity of the comorbidity

comorbidity comorbidity_type Character

Type of comorbidity. The name of the comorbidity is expected


Data Base Table Name survival: This table contains the information on the duration of survival of the patient. As the patient can be dead or alive the survival table is linked to the patientinfo table and not to the disease diagnosis tables. Queries can be used to obtain information on when the patient died after the diagnosis of a disease. The table is linked to the following table: patientinfo
Database Table Field ID Field Type Data Stored in Field Allowed Values
survival dateofdeath Date

Records the deidentified date of death of a patient

survival last_followup_date Date

The date of last follow up. This date can be increased as the length of follow up increases for a patient

survival overallsurvival Float

Stores the overall survival from the date of registration. It is preferable to calculate the overall survival in days. 

survival status Character

The status of the patient at last follow up. 

Alive, Dead, Unknown

Data Base Table Name recurrence: This table details the recurrences experienced by the patient for each diagnosis. This table allows the user to store data on tumor responses to therapy also. Since recurrence may occur independently for each diagnosis, the recurrence table is linked to the diagnosis table. The table is linked to the following tables: diagnosis. In this table, recurrence or progression can be entered. 
Database Table Field ID Field Type Data Stored in Field Allowed Values
recurrence dateresponseassess Date

Date on which response was assessed

recurrence durationrecurrencefree Float

Duration of time which the patient was recurrence free. This should be entered in days

recurrence recurrencedate Date

Date on which the recurrence was observed.

recurrence recurrencelocation Character

Recurrence location. For each diagnosis multiple recurrences can be entered. This can be on the same date or on multiple dates

Local, Regional, Nodal, Distant, Locoregional