Diff of /SCHEMA.md [000000] .. [363198]

Switch to unified view

a b/SCHEMA.md
1
**metadata**
2
3
Here is a list of each metadata field, with explanations where relevant
4
5
| Attribute | Description |
6
|------|-----|
7
| patientid | Internal identifier |
8
| offset | Number of days since the start of symptoms or hospitalization for each image. If a report indicates "after a few days", then 5 days is assumed. This is very important to have when there are multiple images for the same patient to track progression. |
9
| sex | Male (M), Female (F), or blank |
10
| age | Age of the patient in years |
11
| finding | Type of pneumonia |
12
| RT_PCR_positive | Yes (Y) or no (N) or blank if not reported/taken |
13
| survival | Yes (Y) or no (N) or blank if unknown|
14
| intubated | Yes (Y) if the patient was intubated (or ventilated) at any point during this illness or No (N) or blank if unknown. |
15
| went_icu | Yes (Y) if the patient was in the ICU (intensive care unit) or CCU (critical care unit) at any point during this illness or No (N) or blank if unknown.|
16
| needed_supplemental_O2 | Yes (Y) if the patient required supplemental oxygen at any point during this illness or No (N) or blank if unknown |
17
| extubated | Yes (Y) if the patient was successfully extubated or No (N) or blank if unknown |
18
| temperature | Temperature of the patient in Celsius at the time of the image|
19
| pO2 saturation | partial pressure of oxygen saturation in % at the time of the image |
20
| wbc count | white blood cell count in units of 10^3/uL at the time of the image |
21
| neutrophil count | neutrophil cell count in units of 10^3/uL at the time of the image |
22
| lymphocyte count | lymphocyte cell count in units of 10^3/uL at the time of the image |
23
| view | Posteroanterior (PA), Anteroposterior (AP), AP Supine (APS), or Lateral (L) for X-rays; Axial or Coronal for CT scans. Translations: Bettaufnahme->Supine, Liegend->Supine|
24
| modality | CT, X-ray, or something else |
25
| date | Date on which the image was acquired |
26
| location | Hospital name, city, state, country |
27
| filename | Name with extension |
28
| doi | Digital object identifier ([DOI](https://en.wikipedia.org/wiki/Digital_object_identifier)) of the research article |
29
| url | URL of the paper or website where the image came from |
30
| license | License of the image such as CC BY-NC-SA. Blank if unknown |
31
| clinical notes | Clinical notes about the image and/or the patient |
32
| other notes | e.g. credit |
33
34
Within the finding field, the following mappings have been used to simplify the findings in the source:
35
36
|       Original Finding        |       Simplified Finding      |
37
|       ------------------      |       -------------------     |
38
| Tuberculous spondylodiscitis | Spinal Tuberculosis |
39
| No Finding | No Finding |
40
| COVID-19 | COVID-19 |
41
| Swine-Origin Influenza A (H1N1) Viral Pneumonia | Swine-Origin Influenza A (H1N1) Viral Pneumonia |
42
| Complicated Legionnaires' disease. | Legionella |
43
| No Finding | No Finding |
44
| Disseminated "miliary" tuberculosis during biologic (adalimumab) treatment for Crohn's disease | Tuberculosis |
45
| Invasive Aspergillosis and Aspergilloma causing Pneumopericardium. | Invasive Aspergillosis |
46
| Herpes pneumonia and ARDS | "Herpes pneumonia" or "Herpes pneumonia, ARDS" based on sequence
47
| Acute Respiratory Distress Syndrome: a Sequela of Asphyxiation Injury | ARDS |
48
| ARDS secondary to fat embolism | ARDS |
49
| Accelerated Phase Usual Interstitial Pneumonia | Accelerated Phase Usual Interstitial Pneumonia |
50
| Cystic form of pneumocystis jirovecii pneumonia. | Pneumocystis |
51
| Round pneumonia | Round pneumonia |
52
| Pneumocytis jiroveci pneumonia | Pneumocystis |
53
| Lymphocytic interstitial pneumonia | Lymphocytic interstitial pneumonia |
54
| Idiopathic cryptogenic organizing pneumonia (COP) | Cryptogenic Organizing Pneumonia |
55
| Streptococcus pneumonia and multiple pulmonary emboli | Streptococcus |
56
| Fire-eater's pneumonia. | Lipoid |
57
| Allergic bronchopulmonary aspergillosis | Allergic bronchopulmonary aspergillosis |
58
| Cryptogenic organising pneumonia | Cryptogenic organising pneumonia |
59
| Chronic eosinophilic pneumonia | Chronic eosinophilic pneumonia |
60
| Aspiration pneumonia | Aspiration pneumonia |
61
| Pneumocystis Jirovecci Infection in an HIV patient. | Pneumocystis |
62
| Endobronchial tuberculosis (EBTB). | Tuberculosis |
63
| Endobronchial spread of tuberculosis. | Tuberculosis |
64
| Hydropneumothorax as the initial manifestation of postprimary tuberculosis. | Tuberculosis |
65
| Pulmonary nocardia infection in HIV | Nocardia |
66
| Empyema necessitans as manifestation of tuberculosis | Tuberculosis |
67
| MERS-CoV | MERS |
68
| Tuberculosis with consolidation | Tuberculosis |
69
| Klebsiella pneumonia | Klebsiella |
70
| Acute eosinophilic pneumonia | Eosinophilic pneumonia |
71
| Miliary tuberculosis | Tuberculosis |
72
| Bilateral pulmonary nodules - tuberculous granulomas | Tuberculosis |
73
| Pneumonia in transplant lungs (description mentions Mycoplasma) | Mycoplasma Bacterial Pneumonia |
74
| Tuberculosis - left upper lobe | Tuberculosis |
75
| Cavitating pneumonia - lingular segments | Pneumonia |
76
| Community acquired methicillin resistant staphylococcus aureus pneumonia | MRSA |
77
| Streptococcus | Pneumococcal pneumonia |
78
| Klebsiella pneumonia causing a bulging fissure | Klebsiella |
79
| Tree-in-bud caused by haemophilus influenzae | Influenza |
80
| Right middle lobe pneumonia | Pneumonia |
81
| Left lower lobe pneumonia | Pneumonia |
82
| Silhouette sign of Felson: right middle lobe pneumonia | Pneumonia |
83
| Left lower lobe pneumonia | Pneumonia |
84
85
When the view field is provided in the text/image, but is not explicit, the following mappings have been used:
86
87
| Original view | Simplified view |
88
| ------------- | --------------- |
89
| (AP) (Mobile) Sitting | AP |
90
| (AP) Seduto | AP |
91
| (AP) Seduto a letto | AP |
92
| (AP) (Mobile) AP Semi-Erect | AP |
93
| (AP) (Mobile) Semi-Erect | AP |
94
| (AP) Semiseduto | AP |
95
| (AP) (Mobile) Supine | AP Supine |
96
| (AP) Supino | AP Supine |
97
| SUP | AP Supine |
98
| Semi-Supine | AP Supine |