Download 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

Fields description

All data are exported from datasets microservice database.

:pencil: = editable after import

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