media_variant

24 rows where media = 108

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
2569 Bremen Total 108 DS 1 RHARBTO_ZT unknown  
2570 Bremen Total 108 Pre-Stream 2 RHARBTO_ZP unknown  
2571 Bremen Total 108 In-Stream 3 RHARBTO_ZI unknown  
2572 Bremen Total 108 HpT 4 RHARBTO_ZH unknown  
2573 Bremen Total 108 Ø 5 RHARBTO_ZD unknown  
2574 Bremen Total 108 0500-0600 6 RHARBTO_FAGA unknown  
2575 Bremen Total 108 0600-0700 7 RHARBTO_GAHA unknown  
2576 Bremen Total 108 0700-0800 8 RHARBTO_HAIA unknown  
2577 Bremen Total 108 0800-0900 9 RHARBTO_IAJA unknown  
2578 Bremen Total 108 0900-1000 10 RHARBTO_JAKA unknown  
2579 Bremen Total 108 1000-1100 11 RHARBTO_KALA unknown  
2580 Bremen Total 108 1100-1200 12 RHARBTO_LAMA unknown  
2581 Bremen Total 108 1200-1300 13 RHARBTO_MANA unknown  
2582 Bremen Total 108 1300-1400 14 RHARBTO_NAOA unknown  
2583 Bremen Total 108 1400-1500 15 RHARBTO_OAPA unknown  
2584 Bremen Total 108 1500-1600 16 RHARBTO_PAQA unknown  
2585 Bremen Total 108 1600-1700 17 RHARBTO_QARA unknown  
2586 Bremen Total 108 1700-1800 18 RHARBTO_RASA unknown  
2587 Bremen Total 108 1800-1900 19 RHARBTO_SATA unknown  
2588 Bremen Total 108 1900-2000 20 RHARBTO_TAUA unknown  
2589 Bremen Total 108 2000-2100 21 RHARBTO_UAVA unknown  
2590 Bremen Total 108 2100-2200 22 RHARBTO_VAWA unknown  
2591 Bremen Total 108 2200-2300 23 RHARBTO_WAXA unknown  
2592 Bremen Total 108 2300-2400 24 RHARBTO_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);