media_variant

22 rows where media = 119

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
2833 radio NRW 119 DS 1 RHBRNR2_ZT ok 3244.25
2836 radio NRW 119 HpT 4 RHBRNR2_ZH ok 3244.25
2837 radio NRW 119 Ø 5 RHBRNR2_ZD ok 718.17
2838 radio NRW 119 0500-0600 6 RHBRNR2_FAGA ok 319.69
2839 radio NRW 119 0600-0700 7 RHBRNR2_GAHA ok 666.87
2840 radio NRW 119 0700-0800 8 RHBRNR2_HAIA ok 912.55
2841 radio NRW 119 0800-0900 9 RHBRNR2_IAJA ok 957.03
2842 radio NRW 119 0900-1000 10 RHBRNR2_JAKA ok 780.69
2843 radio NRW 119 1000-1100 11 RHBRNR2_KALA ok 696.72
2844 radio NRW 119 1100-1200 12 RHBRNR2_LAMA ok 638.15
2845 radio NRW 119 1200-1300 13 RHBRNR2_MANA ok 603.24
2846 radio NRW 119 1300-1400 14 RHBRNR2_NAOA ok 616.7
2847 radio NRW 119 1400-1500 15 RHBRNR2_OAPA ok 648.46
2848 radio NRW 119 1500-1600 16 RHBRNR2_PAQA ok 632.32
2849 radio NRW 119 1600-1700 17 RHBRNR2_QARA ok 618.43
2850 radio NRW 119 1700-1800 18 RHBRNR2_RASA ok 537.97
2851 radio NRW 119 1800-1900 19 RHBRNR2_SATA ok 443.42
2852 radio NRW 119 1900-2000 20 RHBRNR2_TAUA ok 279.89
2853 radio NRW 119 2000-2100 21 RHBRNR2_UAVA ok 181.22
2854 radio NRW 119 2100-2200 22 RHBRNR2_VAWA ok 93.64
2855 radio NRW 119 2200-2300 23 RHBRNR2_WAXA ok 76.35
2856 radio NRW 119 2300-2400 24 RHBRNR2_XAYA ok 58.49

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 UNIQUE INDEX ix_media_variant_study_code ON media_variant (study_code);
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);