media
23 rows where area = 22
This data as json, CSV (advanced)
Suggested facets: audio_type, combi_type
| id ▼ | title | study_code | order | audio_type | combi_type | area | publisher |
|---|---|---|---|---|---|---|---|
| 979 | ANTENNE THÜRINGEN Audio Kompakt | MA80091005 | 1001 | Konvergenz 1 | Kombination 2 | Thüringen 22 | |
| 980 | ANTENNE THÜRINGEN | HHANTT | 1002 | Klassik 2 | Einzelsender 3 | Thüringen 22 | |
| 981 | ANTENNE THÜRINGEN ONLINE AUDIO | MA70001017 | 1003 | Online-Audio 3 | Kombination 2 | Thüringen 22 | |
| 982 | radio TOP 40 Audio Kompakt | MA80090006 | 1004 | Konvergenz 1 | Kombination 2 | Thüringen 22 | |
| 983 | radio TOP 40 | HHTOP4 | 1005 | Klassik 2 | Einzelsender 3 | Thüringen 22 | |
| 984 | radio TOP 40 ONLINE AUDIO | MA70000098 | 1006 | Online-Audio 3 | Kombination 2 | Thüringen 22 | |
| 985 | RADIOKOMBI Thüringen Audio Total | MA80091021 | 1007 | Konvergenz 1 | Kombination 2 | Thüringen 22 | |
| 986 | RADIOKOMBI Thüringen | HHRKT1 | 1008 | Klassik 2 | Kombination 2 | Thüringen 22 | |
| 987 | RADIOKOMBI Thüringen ONLINE AUDIO | MA70001163 | 1009 | Online-Audio 3 | Kombination 2 | Thüringen 22 | |
| 988 | LandesWelle Thüringen Audio Kompakt | MA80090077 | 1010 | Konvergenz 1 | Kombination 2 | Thüringen 22 | |
| 989 | LandesWelle Thüringen | HHLANT | 1011 | Klassik 2 | Einzelsender 3 | Thüringen 22 | |
| 990 | LandesWelle Thüringen Online Audio | MA70000216 | 1012 | Online-Audio 3 | Kombination 2 | Thüringen 22 | |
| 991 | MDR THÜRINGEN | HHMDR5 | 1013 | Klassik 2 | Einzelsender 3 | Thüringen 22 | |
| 992 | MDR THÜRINGEN Livestream | MA10140000 | 1014 | Online-Audio 3 | Einzelsender 3 | Thüringen 22 | |
| 993 | Antenne Thüringen Classics | HHANTC | 1015 | Online-Audio 3 | Einzelsender 3 | Thüringen 22 | |
| 994 | HSF Studentenradio | HZHSFS | 1016 | Klassik 2 | Einzelsender 3 | Thüringen 22 | |
| 995 | offener kanal jena | HHOKJN | 1017 | Klassik 2 | Einzelsender 3 | Thüringen 22 | |
| 996 | Offener Kanal Nordhausen | HZOKNH | 1018 | Klassik 2 | Einzelsender 3 | Thüringen 22 | |
| 997 | Radio Frei | HZRAFR | 1019 | Klassik 2 | Einzelsender 3 | Thüringen 22 | |
| 998 | Radio Funkwerk | HHRAFW | 1020 | Klassik 2 | Einzelsender 3 | Thüringen 22 | |
| 999 | Radio Lotte Weimar | HHRALT | 1021 | Klassik 2 | Einzelsender 3 | Thüringen 22 | |
| 1000 | radio SRB (Saalfeld, Rudolstadt, Bad Blankenburg) | HHRSAB | 1022 | Klassik 2 | Einzelsender 3 | Thüringen 22 | |
| 1001 | Wartburg-Radio 96,5 | HHWBRA | 1023 | Klassik 2 | Einzelsender 3 | Thüringen 22 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE media (
id INTEGER NOT NULL,
title VARCHAR(250),
study_code VARCHAR(100),
"order" INTEGER,
audio_type INTEGER,
combi_type INTEGER,
area INTEGER,
publisher INTEGER,
PRIMARY KEY (id),
UNIQUE (id),
FOREIGN KEY(audio_type) REFERENCES audio_type (id),
FOREIGN KEY(combi_type) REFERENCES combi_type (id),
FOREIGN KEY(area) REFERENCES area (id),
FOREIGN KEY(publisher) REFERENCES publisher (id)
);
CREATE INDEX ix_media_area ON media (area);
CREATE INDEX ix_media_combi_type ON media (combi_type);
CREATE UNIQUE INDEX ix_media_study_code ON media (study_code);
CREATE INDEX ix_media_order ON media ("order");
CREATE INDEX ix_media_publisher ON media (publisher);
CREATE INDEX ix_media_audio_type ON media (audio_type);