media_variant

24 rows where media = 326

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
7801 JazzRadio 326 DS 1 RHFJAZZ_ZT unknown  
7802 JazzRadio 326 Pre-Stream 2 RHFJAZZ_ZP unknown  
7803 JazzRadio 326 In-Stream 3 RHFJAZZ_ZI unknown  
7804 JazzRadio 326 HpT 4 RHFJAZZ_ZH unknown  
7805 JazzRadio 326 Ø 5 RHFJAZZ_ZD unknown  
7806 JazzRadio 326 0500-0600 6 RHFJAZZ_FAGA unknown  
7807 JazzRadio 326 0600-0700 7 RHFJAZZ_GAHA unknown  
7808 JazzRadio 326 0700-0800 8 RHFJAZZ_HAIA unknown  
7809 JazzRadio 326 0800-0900 9 RHFJAZZ_IAJA unknown  
7810 JazzRadio 326 0900-1000 10 RHFJAZZ_JAKA unknown  
7811 JazzRadio 326 1000-1100 11 RHFJAZZ_KALA unknown  
7812 JazzRadio 326 1100-1200 12 RHFJAZZ_LAMA unknown  
7813 JazzRadio 326 1200-1300 13 RHFJAZZ_MANA unknown  
7814 JazzRadio 326 1300-1400 14 RHFJAZZ_NAOA unknown  
7815 JazzRadio 326 1400-1500 15 RHFJAZZ_OAPA unknown  
7816 JazzRadio 326 1500-1600 16 RHFJAZZ_PAQA unknown  
7817 JazzRadio 326 1600-1700 17 RHFJAZZ_QARA unknown  
7818 JazzRadio 326 1700-1800 18 RHFJAZZ_RASA unknown  
7819 JazzRadio 326 1800-1900 19 RHFJAZZ_SATA unknown  
7820 JazzRadio 326 1900-2000 20 RHFJAZZ_TAUA unknown  
7821 JazzRadio 326 2000-2100 21 RHFJAZZ_UAVA unknown  
7822 JazzRadio 326 2100-2200 22 RHFJAZZ_VAWA unknown  
7823 JazzRadio 326 2200-2300 23 RHFJAZZ_WAXA unknown  
7824 JazzRadio 326 2300-2400 24 RHFJAZZ_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);