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
All data are exported from datasets microservice database.
📝 = editable after import
| Label | Description | Database | Source | Format | 📝 | Note |
|---|---|---|---|---|---|---|
patient_id |
Subject unique id | subject.id |
generated (sequence) | number | ❌ | |
shanoir_name |
Subject full name | subject.name |
DICOM : (0010,0010) PatientName | string | ❌ | |
double_hash |
TODO | subject.identifier |
TODO | Hash | ❌ | |
birthname1..3 |
TODO | subject.birth_name_hash1..3 |
TODO | Hash | ❌ | |
lastname1..3 |
TODO | subject.last_name_hash1..3 |
TODO | Hash | ❌ | |
firstname1..3 |
TODO | subject.first_name_hash1..3 |
TODO | Hash | ❌ | |
birthdate1 |
Subject date of birth | subject.birth_date_hash |
(Hashed) | Hash | ❌ | always at first day of the month (01) |
sex |
Subject sex | subject.sex |
DICOM : (0010,0040) PatientSex |
M or F
|
❌ | |
birthyear |
Subject birth year | year(subject.birthdate) |
Extracted from birth date | YYYY |
❌ | |
study_id |
Study unique id | study.id |
generated (sequence) | number | ❌ | |
study_name |
Study name | study.name |
TODO | string | ✔️ | |
sequence_id |
Dataset unique id | dataset.id |
generated (sequence) | number | ❌ | |
norm_sequence_name |
Dataset name | dataset_metadata.name |
TODO | string | ✔️ | |
sequence_name |
Dataset comment | dataset_metadata.comment |
TODO | string | ✔️ | |
center_id |
Acquisition center unique id | center.id |
generated (sequence) | number | ❌ | |
center |
Acquisition center name | center.name |
TODO | string | ✔️ | |
center_postcode |
Acquisition center postcode | center.postal_code |
TODO | string | ✔️ | |
center_city |
Acquisition center city name | center.city |
TODO | string | ✔️ | |
device_manufacturer |
Acquisition equipment name | manufacturer.name |
TODO | string | ✔️ | |
device_model |
Acquisition equipment model name | manufacturer_model.name |
TODO | string | ✔️ | |
device_field_strength |
Acquisition equipment field strength | manufacturer_model.magnetic_field |
TODO | number (float) | ✔️ | In Tesla (T) |
device_serial_number |
Acquisition equipment serial number | acquisition_equipment.serial_number |
TODO | string | ✔️ | |
examination_id |
Examination unique id | examination.id |
generated (sequence) | number | ❌ | |
examination_date |
Examination date | examination.examination_date |
TODO | YYYY-MM-DD |
✔️ | |
import_date |
Acquisition import date | dataset_acquisition.import_date |
TODO | YYYY-MM-DD |
❌ | |
creation_date |
Dataset/sequence creation date | dataset.creation_date |
TODO | YYYY-MM-DD |
✔️ | |
series_number |
Acquisition series number | dataset_acquisition.sorting_index |
DICOM : (0020,0011) Series number | number | ❌ | |
protocol_type |
Acquisition protocol name | mr_protocol_metadata.name |
DICOM : (0018,1030) Protocol name | string | ❌ | |
dicom_size_mo |
Dataset DICOM files size on Shanoir PACS | sum(dataset_expression.size) |
calculated | number | ❌ | In megabyte (MB) |
execution |
VIP execution results | dataset_property.* |
VIP | JSON | ❌ |