media
22 rows where area = 5
This data as json, CSV (advanced)
Suggested facets: audio_type, combi_type
| id ▼ | title | study_code | order | audio_type | combi_type | area | publisher |
|---|---|---|---|---|---|---|---|
| 164 | delta radio Audio Total | MA90090058 | 168 | Konvergenz 1 | Kombination 3 | Schleswig-Holstein 5 | |
| 165 | delta radio | HADELT | 169 | Klassik 2 | Einzelsender 4 | Schleswig-Holstein 5 | |
| 166 | delta radio Online Audio | MA70000026 | 170 | Online-Audio 3 | Kombination 3 | Schleswig-Holstein 5 | |
| 167 | AUDIO HOUSE Kombi Schleswig-Holstein/Hamburg Audio Total | MA90090033 | 171 | Konvergenz 1 | Kombination 3 | Schleswig-Holstein 5 | |
| 168 | AUDIO HOUSE Kombi Schleswig-Holstein/Hamburg | HASHKB | 172 | Klassik 2 | Kombination 3 | Schleswig-Holstein 5 | |
| 169 | AUDIO HOUSE Kombi Schleswig-Holstein/Hamburg Online Audio | MA70000160 | 173 | Online-Audio 3 | Kombination 3 | Schleswig-Holstein 5 | |
| 170 | R.SH Audio Total | MA90090059 | 174 | Konvergenz 1 | Kombination 3 | Schleswig-Holstein 5 | |
| 171 | R.SH Radio Schleswig-Holstein | HARASH | 175 | Klassik 2 | Einzelsender 4 | Schleswig-Holstein 5 | |
| 172 | R.SH Online Audio | MA70000072 | 176 | Online-Audio 3 | Kombination 3 | Schleswig-Holstein 5 | |
| 173 | RADIO BOB! rockt Schleswig-Holstein Audio Total | MA80090078 | 177 | Konvergenz 1 | Kombination 3 | Schleswig-Holstein 5 | |
| 174 | RADIO BOB! rockt Schleswig-Holstein | HANORA | 178 | Klassik 2 | Einzelsender 4 | Schleswig-Holstein 5 | |
| 175 | Antenne Sylt | HANSYL | 179 | Klassik 2 | Einzelsender 4 | Schleswig-Holstein 5 | |
| 176 | Freie RadioCooperative Husum | HAFRKH | 180 | Klassik 2 | Einzelsender 4 | Schleswig-Holstein 5 | |
| 177 | Kiel FM | HZKIFM | 181 | Klassik 2 | Einzelsender 4 | Schleswig-Holstein 5 | |
| 178 | Meer Radio | HZMEER | 182 | Klassik 2 | Einzelsender 4 | Schleswig-Holstein 5 | |
| 179 | Offener Kanal Lübeck | HAOKLB | 183 | Klassik 2 | Einzelsender 4 | Schleswig-Holstein 5 | |
| 180 | Ostseewelle HIT-RADIO Schleswig-Holstein & Hamburg | HAOWKI | 184 | Klassik 2 | Einzelsender 4 | Schleswig-Holstein 5 | |
| 181 | Radio Lübeck | HARALU | 185 | Klassik 2 | Einzelsender 4 | Schleswig-Holstein 5 | |
| 182 | Radio Ostfriesland | HAOKOF | 186 | Klassik 2 | Einzelsender 4 | Schleswig-Holstein 5 | |
| 183 | radio SWS (Norderney) | HARSWS | 187 | Klassik 2 | Einzelsender 4 | Schleswig-Holstein 5 | |
| 184 | Syltfunk - Söl'ring Radio | HASYFU | 188 | Klassik 2 | Einzelsender 4 | Schleswig-Holstein 5 | |
| 185 | Offener Kanal Westküste | HAOKWK | 189 | Klassik 2 | Einzelsender 4 | Schleswig-Holstein 5 |
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");