media_variant

24 rows where media = 41

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
961 RMS SUPER KOMBI 41 DS 1 RHZRS24_ZT unknown  
962 RMS SUPER KOMBI 41 Pre-Stream 2 RHZRS24_ZP unknown  
963 RMS SUPER KOMBI 41 In-Stream 3 RHZRS24_ZI unknown  
964 RMS SUPER KOMBI 41 HpT 4 RHZRS24_ZH unknown  
965 RMS SUPER KOMBI 41 Ø 5 RHZRS24_ZD unknown  
966 RMS SUPER KOMBI 41 0500-0600 6 RHZRS24_FAGA unknown  
967 RMS SUPER KOMBI 41 0600-0700 7 RHZRS24_GAHA unknown  
968 RMS SUPER KOMBI 41 0700-0800 8 RHZRS24_HAIA unknown  
969 RMS SUPER KOMBI 41 0800-0900 9 RHZRS24_IAJA unknown  
970 RMS SUPER KOMBI 41 0900-1000 10 RHZRS24_JAKA unknown  
971 RMS SUPER KOMBI 41 1000-1100 11 RHZRS24_KALA unknown  
972 RMS SUPER KOMBI 41 1100-1200 12 RHZRS24_LAMA unknown  
973 RMS SUPER KOMBI 41 1200-1300 13 RHZRS24_MANA unknown  
974 RMS SUPER KOMBI 41 1300-1400 14 RHZRS24_NAOA unknown  
975 RMS SUPER KOMBI 41 1400-1500 15 RHZRS24_OAPA unknown  
976 RMS SUPER KOMBI 41 1500-1600 16 RHZRS24_PAQA unknown  
977 RMS SUPER KOMBI 41 1600-1700 17 RHZRS24_QARA unknown  
978 RMS SUPER KOMBI 41 1700-1800 18 RHZRS24_RASA unknown  
979 RMS SUPER KOMBI 41 1800-1900 19 RHZRS24_SATA unknown  
980 RMS SUPER KOMBI 41 1900-2000 20 RHZRS24_TAUA unknown  
981 RMS SUPER KOMBI 41 2000-2100 21 RHZRS24_UAVA unknown  
982 RMS SUPER KOMBI 41 2100-2200 22 RHZRS24_VAWA unknown  
983 RMS SUPER KOMBI 41 2200-2300 23 RHZRS24_WAXA unknown  
984 RMS SUPER KOMBI 41 2300-2400 24 RHZRS24_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);