Statistics export
The "Download statistics" feature allow you to download a TSV (Tab Separated Value) statistics file.
Excluding the first header row, each row corresponds to one Shanoir dataset / sequence.
You need to be an administrator to access this feature.
Before launching download, regular expressions can be defined to filter results
- study name(s) to includes
- study name(s) to excludes
- subject name(s) to include
- subject name(s) to exclude
| Label | Description | Database | Source | Format | 📝 | Note |
|---|---|---|---|---|---|---|
patient_id |
Subject unique id | datasets.subject.id |
generated (sequence) | number | ❌ | |
shanoir_name |
Subject name | datasets.subject.name |
TODO | string | ❌ | |
double_hash |
TODO | datasets.subject.name |
TODO | string | ❌ | |
birthname1..3 |
TODO | datasets.subject.name |
TODO | string | ❌ | |
lastname1..3 |
TODO | datasets.subject.name |
TODO | string | ❌ | |
firstname1..3 |
TODO | datasets.subject.name |
TODO | string | ❌ | |
birthdate1 |
Subject date of birth | datasets.subject.name |
TODO | YYYY-MM-DD |
❌ | always at first day of the month (01) |
sex |
Subject sex | datasets.subject.sex |
TODO |
M or F
|
❌ | |
birthyear |
Subject birth year | year(datasets.subject.birthdate) |
Extracted from birth date | YYYY |
❌ | |
study_id |
Study unique id | datasets.study.id |
generated (sequence) | number | ❌ | |
study_name |
Study name | datasets.study.name |
TODO | string | ✔️ | |
sequence_id |
Dataset unique id | datasets.dataset.id |
generated (sequence) | number | ❌ | |
norm_sequence_name |
Dataset name | datasets.dataset_metadata.name |
TODO | string | ✔️ | |
sequence_name |
Dataset comment | datasets.dataset_metadata.comment |
TODO | string | ✔️ | |
center_id |
Acquisition center unique id | datasets.center.id |
generated (sequence) | number | ❌ | |
center |
Acquisition center name | datasets.center.name |
TODO | string | ✔️ | |
center_postcode |
Acquisition center postcode | datasets.center.postal_code |
TODO | string | ✔️ | |
center_city |
Acquisition center city name | datasets.center.city |
TODO | string | ✔️ | |
device_manufacturer |
Acquisition equipment name | datasets.manufacturer.name |
TODO | string | ✔️ | |
device_model |
Acquisition equipment model name | datasets.manufacturer_model.name |
TODO | string | ✔️ | |
device_field_strength |
Acquisition equipment field strength | datasets.manufacturer_model.magnetic_field |
TODO | number (float) | ✔️ | In Tesla (T) |
device_serial_number |
Acquisition equipment serial number | datasets.acquisition_equipment.serial_number |
TODO | string | ✔️ | |
examination_id |
Examination unique id | datasets.examination.id |
generated (sequence) | number | ❌ | |
examination_date |
Examination date | datasets.examination.examination_date |
TODO | YYYY-MM-DD |
✔️ | |
import_date |
Acquisition import date | datasets.dataset_acquisition.import_date |
TODO | YYYY-MM-DD |
❌ | |
creation_date |
Dataset/sequence creation date | datasets.dataset.creation_date |
TODO | YYYY-MM-DD |
✔️ | |
series_number |
Acquisition series number | datasets.dataset_acquisition.sorting_index |
DICOM : (0020,0011) Series number | number | ❌ | |
protocol_type |
Acquisition protocol name | datasets.mr_protocol_metadata.name |
DICOM : (0018,1030) Protocol name | string | ❌ | |
dicom_size_mo |
Dataset DICOM files size on Shanoir PACS | sum(datasets.dataset_expression.size) |
calculated | number | ❌ | In megabyte (MB) |
execution |
VIP execution results | datasets.dataset_property.* |
VIP | JSON | ❌ |