Generate & Download

Initiate export of patient database and download the resulting CSV table. This table has the same structure as the one that is necessary to upload a batch of patients, so it may also be used as a template.

Data description

The data is provided as a CSV-table containing one row for each of the patients in the database. The table has a header with three levels that describe the columns. Below we explain each column in the form of a list with three levels. So, for example, list entry 1.1.7 refers to a column with the three-level header patient | # | hpv_status and underneath it tha patients' HPV status is listed.


  1. patient: General information about the patient’s condition can be found under this top-level header.
    1. #: The second level under patient has no meaning and exists solely as a filler.
      1. id: Enumeration of the patients
      2. sex: Sex of the patient
      3. age: Patient’s age at diagnosis
      4. diagnose_date: Date of diagnosis (format YYYY-mm-dd) defined as the date of first histological confirmation of HNSCC.
      5. alcohol_abuse: true for patients who stated that they consume alcohol regularly, false otherwise
      6. nicotine_abuse: true for patients who have been regular smokers (> 10 pack years)
      7. hpv_status: true for patients with human papilloma virus associated tumors (as defined by p16 immunohistochemistry)
      8. neck_dissection: Indicates whether the patient has received a neck dissection as part of the treatment.
      9. tnm_edition: The edition of the TNM classification used to classify the patient [1]
      10. n_stage: Degree of spread to regional lymph nodes
      11. m_stage: Presence of distant metastases
  2. tumor: Information about tumors is stored under this top-level header
    1. <number>: The second level enumerates the synchronous tumors. In our database, no patient has had a second tumor, but this structure of the file allows us to include such patients in the future. The third-level headers are the same for each tumor.
      1. location: Anatomic location of the tumor
      2. subsite: ICD-O-3 code associated with a tumor at the particular location according to the world health organization [2], [3]
      3. side: Lateralization of the tumor. Can be “left” or “right” for tumors that have their center of mass clearly on the respective side of the mid-sagittal line and “central” for patients with a tumor on the mid-sagittal line.
      4. extension: True if part of the tumor extends over the mid-sagittal line
      5. volume: Volume of the tumor in cm3
      6. stage_prefix: Prefix modifier of the T-category. Can be “c” or “p”
      7. t_stage: T-category of the tumor, according to TNM staging
  3. <diagnostic modality>: Each recorded diagnostic modality is indicated by its own top-level header. In this file FNA, CT, MRI, PET, path (pathology) and pCT (planning CT) are provided
    1. info:
      1. date: Day on which a diagnose with the respective modality was performed
    2. right: All findings of involved lymph nodes on the right side of the patient’s neck
      1. <LNL>: One column is provided for each recorded lymph node level. For each level true indicates at least one finding diagnosed as malignant lymph node in the respective LNL, false means no malignant lymph node has been found and an empty field indicates that no diagnosis is available for this LNL according to the respective diagnostic modality. <LNL> can be: I, Ia, Ib, II, IIa, IIb, III, IV, V, VI, VII, VIII, IX, X.
    3. left: Same as 3.2 but for the left side of the patient’s neck
      1. <LNL>: same as under 3.2.1

Data repository

The data we extracted at our institution and uploaded to this interface is also available in one of our GitHub repositories: lyDATA


  • [1] J. D. Brierley, M. K. Gospodarowicz, and C. Wittekind, TNM Classification of Malignant Tumours. John Wiley & Sons, 2017.

  • [2] World Health Organization, Ed., International statistical classification of diseases and related health problems, 10th revision, 2nd edition. Geneva: World Health Organization, 2004.

  • [3] A. G. Fritz, Ed., International classification of diseases for oncology: ICD-O, 3rd ed. Geneva: World Health Organization, 2000.