media_variant

24 rows where media = 114

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
2713 radio NRW 114 DS 1 RHBRNR2_ZT unknown  
2714 radio NRW 114 Pre-Stream 2 RHBRNR2_ZP unknown  
2715 radio NRW 114 In-Stream 3 RHBRNR2_ZI unknown  
2716 radio NRW 114 HpT 4 RHBRNR2_ZH unknown  
2717 radio NRW 114 Ø 5 RHBRNR2_ZD unknown  
2718 radio NRW 114 0500-0600 6 RHBRNR2_FAGA unknown  
2719 radio NRW 114 0600-0700 7 RHBRNR2_GAHA unknown  
2720 radio NRW 114 0700-0800 8 RHBRNR2_HAIA unknown  
2721 radio NRW 114 0800-0900 9 RHBRNR2_IAJA unknown  
2722 radio NRW 114 0900-1000 10 RHBRNR2_JAKA unknown  
2723 radio NRW 114 1000-1100 11 RHBRNR2_KALA unknown  
2724 radio NRW 114 1100-1200 12 RHBRNR2_LAMA unknown  
2725 radio NRW 114 1200-1300 13 RHBRNR2_MANA unknown  
2726 radio NRW 114 1300-1400 14 RHBRNR2_NAOA unknown  
2727 radio NRW 114 1400-1500 15 RHBRNR2_OAPA unknown  
2728 radio NRW 114 1500-1600 16 RHBRNR2_PAQA unknown  
2729 radio NRW 114 1600-1700 17 RHBRNR2_QARA unknown  
2730 radio NRW 114 1700-1800 18 RHBRNR2_RASA unknown  
2731 radio NRW 114 1800-1900 19 RHBRNR2_SATA unknown  
2732 radio NRW 114 1900-2000 20 RHBRNR2_TAUA unknown  
2733 radio NRW 114 2000-2100 21 RHBRNR2_UAVA unknown  
2734 radio NRW 114 2100-2200 22 RHBRNR2_VAWA unknown  
2735 radio NRW 114 2200-2300 23 RHBRNR2_WAXA unknown  
2736 radio NRW 114 2300-2400 24 RHBRNR2_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);