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 |
|---|---|---|---|---|---|---|---|
| 944 | ANTENNE THÜRINGEN Audio Kompakt | MA90090005 | 965 | Konvergenz 1 | Kombination 3 | Thüringen 22 | |
| 945 | ANTENNE THÜRINGEN | HHANTT | 966 | Klassik 2 | Einzelsender 4 | Thüringen 22 | |
| 946 | ANTENNE THÜRINGEN ONLINE AUDIO | MA70000017 | 967 | Online-Audio 3 | Kombination 3 | Thüringen 22 | |
| 947 | radio TOP 40 Audio Kompakt | MA80090006 | 968 | Konvergenz 1 | Kombination 3 | Thüringen 22 | |
| 948 | radio TOP 40 | HHTOP4 | 969 | Klassik 2 | Einzelsender 4 | Thüringen 22 | |
| 949 | radio TOP 40 ONLINE AUDIO | MA70000098 | 970 | Online-Audio 3 | Kombination 3 | Thüringen 22 | |
| 950 | RADIOKOMBI Thüringen Audio Total | MA90090021 | 971 | Konvergenz 1 | Kombination 3 | Thüringen 22 | |
| 951 | RADIOKOMBI Thüringen | HHRKTU | 972 | Klassik 2 | Kombination 3 | Thüringen 22 | |
| 952 | RADIOKOMBI Thüringen ONLINE AUDIO | MA70000163 | 973 | Online-Audio 3 | Kombination 3 | Thüringen 22 | |
| 953 | LandesWelle Thüringen Audio Total | MA80090077 | 974 | Konvergenz 1 | Kombination 3 | Thüringen 22 | RMS 4 |
| 954 | LandesWelle Thüringen | HHLANT | 975 | Klassik 2 | Einzelsender 4 | Thüringen 22 | RMS 4 |
| 955 | LandesWelle Thüringen Online Audio | MA70000216 | 976 | Online-Audio 3 | Kombination 3 | Thüringen 22 | RMS 4 |
| 956 | MDR THÜRINGEN | HHMDR5 | 977 | Klassik 2 | Einzelsender 4 | Thüringen 22 | |
| 957 | MDR THÜRINGEN Livestream | MA10140000 | 978 | Online-Audio 3 | Einzelsender 4 | Thüringen 22 | |
| 958 | ANTENNE THÜRINGEN Classics | HHANTC | 979 | Klassik 2 | Einzelsender 4 | Thüringen 22 | |
| 959 | HSF Studentenradio | HZHSFS | 980 | Klassik 2 | Einzelsender 4 | Thüringen 22 | |
| 960 | offener kanal jena | HHOKJN | 981 | Klassik 2 | Einzelsender 4 | Thüringen 22 | |
| 961 | radio enno | HZOKNH | 982 | Klassik 2 | Einzelsender 4 | Thüringen 22 | |
| 962 | Radio Frei | HZRAFR | 983 | Klassik 2 | Einzelsender 4 | Thüringen 22 | |
| 963 | Radio Funkwerk | HHRAFW | 984 | Klassik 2 | Einzelsender 4 | Thüringen 22 | |
| 964 | Radio Lotte Weimar | HHRALT | 985 | Klassik 2 | Einzelsender 4 | Thüringen 22 | |
| 965 | radio SRB (Saalfeld, Rudolstadt, Bad Blankenburg) | HHRSAB | 986 | Klassik 2 | Einzelsender 4 | Thüringen 22 | |
| 966 | Wartburg-Radio 96,5 | HHWBRA | 987 | Klassik 2 | Einzelsender 4 | 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 UNIQUE INDEX ix_media_study_code ON media (study_code);
CREATE INDEX ix_media_order ON media ("order");
CREATE INDEX ix_media_audio_type ON media (audio_type);
CREATE INDEX ix_media_area ON media (area);
CREATE INDEX ix_media_publisher ON media (publisher);
CREATE INDEX ix_media_combi_type ON media (combi_type);