media_variant

22 rows where media = 114

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_sample

id ▼ media variant study_code study_status raw_sample
2713 radio NRW 114 DS 1 RHBRNR2_ZT ok 3148.53
2716 radio NRW 114 HpT 4 RHBRNR2_ZH ok 3148.53
2717 radio NRW 114 Ø 5 RHBRNR2_ZD ok 666.42
2718 radio NRW 114 0500-0600 6 RHBRNR2_FAGA ok 329.5
2719 radio NRW 114 0600-0700 7 RHBRNR2_GAHA ok 665.19
2720 radio NRW 114 0700-0800 8 RHBRNR2_HAIA ok 899.2
2721 radio NRW 114 0800-0900 9 RHBRNR2_IAJA ok 891.71
2722 radio NRW 114 0900-1000 10 RHBRNR2_JAKA ok 745.43
2723 radio NRW 114 1000-1100 11 RHBRNR2_KALA ok 629.24
2724 radio NRW 114 1100-1200 12 RHBRNR2_LAMA ok 604.18
2725 radio NRW 114 1200-1300 13 RHBRNR2_MANA ok 582.78
2726 radio NRW 114 1300-1400 14 RHBRNR2_NAOA ok 561.84
2727 radio NRW 114 1400-1500 15 RHBRNR2_OAPA ok 552.37
2728 radio NRW 114 1500-1600 16 RHBRNR2_PAQA ok 534.32
2729 radio NRW 114 1600-1700 17 RHBRNR2_QARA ok 548.62
2730 radio NRW 114 1700-1800 18 RHBRNR2_RASA ok 491.35
2731 radio NRW 114 1800-1900 19 RHBRNR2_SATA ok 399.99
2732 radio NRW 114 1900-2000 20 RHBRNR2_TAUA ok 268.81
2733 radio NRW 114 2000-2100 21 RHBRNR2_UAVA ok 130.92
2734 radio NRW 114 2100-2200 22 RHBRNR2_VAWA ok 112.07
2735 radio NRW 114 2200-2300 23 RHBRNR2_WAXA ok 73.81
2736 radio NRW 114 2300-2400 24 RHBRNR2_XAYA ok 61.07

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);