media_variant

24 rows where media = 363

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
8689 radio SAW 363 DS 1 RHGRSAW_ZT unknown  
8690 radio SAW 363 Pre-Stream 2 RHGRSAW_ZP unknown  
8691 radio SAW 363 In-Stream 3 RHGRSAW_ZI unknown  
8692 radio SAW 363 HpT 4 RHGRSAW_ZH unknown  
8693 radio SAW 363 Ø 5 RHGRSAW_ZD unknown  
8694 radio SAW 363 0500-0600 6 RHGRSAW_FAGA unknown  
8695 radio SAW 363 0600-0700 7 RHGRSAW_GAHA unknown  
8696 radio SAW 363 0700-0800 8 RHGRSAW_HAIA unknown  
8697 radio SAW 363 0800-0900 9 RHGRSAW_IAJA unknown  
8698 radio SAW 363 0900-1000 10 RHGRSAW_JAKA unknown  
8699 radio SAW 363 1000-1100 11 RHGRSAW_KALA unknown  
8700 radio SAW 363 1100-1200 12 RHGRSAW_LAMA unknown  
8701 radio SAW 363 1200-1300 13 RHGRSAW_MANA unknown  
8702 radio SAW 363 1300-1400 14 RHGRSAW_NAOA unknown  
8703 radio SAW 363 1400-1500 15 RHGRSAW_OAPA unknown  
8704 radio SAW 363 1500-1600 16 RHGRSAW_PAQA unknown  
8705 radio SAW 363 1600-1700 17 RHGRSAW_QARA unknown  
8706 radio SAW 363 1700-1800 18 RHGRSAW_RASA unknown  
8707 radio SAW 363 1800-1900 19 RHGRSAW_SATA unknown  
8708 radio SAW 363 1900-2000 20 RHGRSAW_TAUA unknown  
8709 radio SAW 363 2000-2100 21 RHGRSAW_UAVA unknown  
8710 radio SAW 363 2100-2200 22 RHGRSAW_VAWA unknown  
8711 radio SAW 363 2200-2300 23 RHGRSAW_WAXA unknown  
8712 radio SAW 363 2300-2400 24 RHGRSAW_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);