media
24 rows where area = 20
This data as json, CSV (advanced)
Suggested facets: audio_type, combi_type
| id ▼ | title | study_code | order | audio_type | combi_type | area | publisher |
|---|---|---|---|---|---|---|---|
| 870 | 89.0 RTL Audio Total | MA90090017 | 889 | Konvergenz 1 | Kombination 3 | Sachsen-Anhalt 20 | |
| 871 | 89.0 RTL | HGP890 | 890 | Klassik 2 | Einzelsender 4 | Sachsen-Anhalt 20 | |
| 872 | 89.0 RTL Online Audio | MA70000006 | 891 | Online-Audio 3 | Kombination 3 | Sachsen-Anhalt 20 | |
| 873 | MDR SACHSEN-ANHALT | HGMDS2 | 892 | Klassik 2 | Einzelsender 4 | Sachsen-Anhalt 20 | |
| 874 | MDR SACHSEN-ANHALT Livestream | MA10130000 | 893 | Online-Audio 3 | Einzelsender 4 | Sachsen-Anhalt 20 | |
| 875 | Radio Brocken Audio Total | MA90090016 | 894 | Konvergenz 1 | Kombination 3 | Sachsen-Anhalt 20 | |
| 876 | Radio Brocken | HGANSA | 895 | Klassik 2 | Einzelsender 4 | Sachsen-Anhalt 20 | |
| 877 | Radio Brocken Online Audio | MA70000082 | 896 | Online-Audio 3 | Kombination 3 | Sachsen-Anhalt 20 | |
| 878 | radio SAW - Audio Total | MA90090012 | 897 | Konvergenz 1 | Kombination 3 | Sachsen-Anhalt 20 | RMS 4 |
| 879 | radio SAW - Audio Kompakt | MA80090011 | 898 | Konvergenz 1 | Kombination 3 | Sachsen-Anhalt 20 | RMS 4 |
| 880 | radio SAW | HGRSAW | 899 | Klassik 2 | Einzelsender 4 | Sachsen-Anhalt 20 | RMS 4 |
| 881 | radio SAW - Online Audio | MA70000093 | 900 | Online-Audio 3 | Kombination 3 | Sachsen-Anhalt 20 | RMS 4 |
| 882 | radio SAW - Online Audio Kompakt | MA70000094 | 901 | Online-Audio 3 | Kombination 3 | Sachsen-Anhalt 20 | RMS 4 |
| 883 | ROCKLAND | HGRLSA | 902 | Klassik 2 | Einzelsender 4 | Sachsen-Anhalt 20 | |
| 884 | RADIO KOMBI Sachsen-Anhalt - Audio Total | MA90090014 | 903 | Konvergenz 1 | Kombination 3 | Sachsen-Anhalt 20 | |
| 885 | RADIO KOMBI Sachsen-Anhalt - Audio Kompakt | MA80090013 | 904 | Konvergenz 1 | Kombination 3 | Sachsen-Anhalt 20 | |
| 886 | RADIO KOMBI SACHSEN-ANHALT | HGRKSA | 905 | Klassik 2 | Kombination 3 | Sachsen-Anhalt 20 | |
| 887 | Sachsen-Anhalt Hit-Kombi Audio Total | MA90090018 | 906 | Konvergenz 1 | Kombination 3 | Sachsen-Anhalt 20 | |
| 888 | Sachsen-Anhalt Hit-Kombi | HGSAHK | 907 | Klassik 2 | Kombination 3 | Sachsen-Anhalt 20 | |
| 889 | Sachsen-Anhalt Hit-Kombi Online Audio | MA70000174 | 908 | Online-Audio 3 | Kombination 3 | Sachsen-Anhalt 20 | |
| 890 | 1A deutsche Hits | HG1ADH | 909 | Klassik 2 | Einzelsender 4 | Sachsen-Anhalt 20 | |
| 891 | 89.0 RTL in the mix | HG89MX | 910 | Klassik 2 | Einzelsender 4 | Sachsen-Anhalt 20 | |
| 892 | Radio Corax | HGRACO | 911 | Klassik 2 | Einzelsender 4 | Sachsen-Anhalt 20 | |
| 893 | radio hbw | HGRAHB | 912 | Klassik 2 | Einzelsender 4 | Sachsen-Anhalt 20 |
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_publisher ON media (publisher);
CREATE INDEX ix_media_audio_type ON media (audio_type);
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");