media_variant

24 rows where media = 152

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
3625 hr Hessen Kombi 152 DS 1 RHCHEK1_ZT unknown  
3626 hr Hessen Kombi 152 Pre-Stream 2 RHCHEK1_ZP unknown  
3627 hr Hessen Kombi 152 In-Stream 3 RHCHEK1_ZI unknown  
3628 hr Hessen Kombi 152 HpT 4 RHCHEK1_ZH unknown  
3629 hr Hessen Kombi 152 Ø 5 RHCHEK1_ZD unknown  
3630 hr Hessen Kombi 152 0500-0600 6 RHCHEK1_FAGA unknown  
3631 hr Hessen Kombi 152 0600-0700 7 RHCHEK1_GAHA unknown  
3632 hr Hessen Kombi 152 0700-0800 8 RHCHEK1_HAIA unknown  
3633 hr Hessen Kombi 152 0800-0900 9 RHCHEK1_IAJA unknown  
3634 hr Hessen Kombi 152 0900-1000 10 RHCHEK1_JAKA unknown  
3635 hr Hessen Kombi 152 1000-1100 11 RHCHEK1_KALA unknown  
3636 hr Hessen Kombi 152 1100-1200 12 RHCHEK1_LAMA unknown  
3637 hr Hessen Kombi 152 1200-1300 13 RHCHEK1_MANA unknown  
3638 hr Hessen Kombi 152 1300-1400 14 RHCHEK1_NAOA unknown  
3639 hr Hessen Kombi 152 1400-1500 15 RHCHEK1_OAPA unknown  
3640 hr Hessen Kombi 152 1500-1600 16 RHCHEK1_PAQA unknown  
3641 hr Hessen Kombi 152 1600-1700 17 RHCHEK1_QARA unknown  
3642 hr Hessen Kombi 152 1700-1800 18 RHCHEK1_RASA unknown  
3643 hr Hessen Kombi 152 1800-1900 19 RHCHEK1_SATA unknown  
3644 hr Hessen Kombi 152 1900-2000 20 RHCHEK1_TAUA unknown  
3645 hr Hessen Kombi 152 2000-2100 21 RHCHEK1_UAVA unknown  
3646 hr Hessen Kombi 152 2100-2200 22 RHCHEK1_VAWA unknown  
3647 hr Hessen Kombi 152 2200-2300 23 RHCHEK1_WAXA unknown  
3648 hr Hessen Kombi 152 2300-2400 24 RHCHEK1_XAYA unknown  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE media_variant (
	id INTEGER NOT NULL, 
	media INTEGER, 
	variant INTEGER, 
	study_code VARCHAR(100), 
	study_status VARCHAR(7), 
	raw_sample INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(media) REFERENCES media (id), 
	FOREIGN KEY(variant) REFERENCES variant (id)
);
CREATE INDEX ix_media_variant_media ON media_variant (media);
CREATE INDEX ix_media_variant_variant ON media_variant (variant);
CREATE INDEX ix_media_variant_study_status ON media_variant (study_status);
CREATE UNIQUE INDEX ix_media_variant_study_code ON media_variant (study_code);