nielsen_medias

86 rows where gattung = 6

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ mediaDetailCodeId code title gattung idTb studyCode noTablesGesamt time factorDefault costPerGroup
363 670 950010 RPR1. Radio 6 1 RHCRPR1 0   0.0 0
364 671 950015 HIT RADIO FFH Radio 6 1 RHCRFFH 0   0.0 0
365 672 950017 RADIO NRW Radio 6 1 RHBRNR2 0   0.0 0
366 673 950020 HAMBURG ZWEI Radio 6 1 RHAOKRA 0   0.0 0
367 674 950021 ENERGY BERLIN Radio 6 1 RHFENER 0   0.0 0
368 675 950500 RADIO HAMBURG Radio 6 1 RHARAHH 0   0.0 0
369 676 950700 MDR 1 Radio 6 1 RHGMDR1 0   0.0 0
370 677 950800 MDR JUMP Radio 6 1 RHGMDRJ 0   0.0 0
371 678 950900 ANTENNE BRANDENBURG Radio 6 1 RHFANBR 0   0.0 0
372 679 951000 BREMEN EINS Radio 6 1 RHARAB1 0   0.0 0
373 680 951500 RADIO FFN Radio 6 1 RHARFFN 0   0.0 0
374 681 951600 ANTENNE THUERINGEN Radio 6 1 RHHANTT 0   0.0 0
375 682 951700 80S80S RADIO Radio 6 1 RHGANMV 0   0.0 0
376 683 951800 HITRADIO RTL SACHSEN Radio 6 1 RHHANTS 0   0.0 0
377 684 951900 DELTA RADIO Radio 6 1 RHADELT 0   0.0 0
378 685 952000 HR 1 Radio 6 1 RHCHES1 0   0.0 0
379 686 952100 HR 3 Radio 6 1 RHCHES3 0   0.0 0
380 687 952200 HR 4 Radio 6 1 RHCHES4 0   0.0 0
381 688 952700 BB RADIO Radio 6 1 RHFBBRB 0   0.0 0
382 689 953200 SWR 3 Radio 6 1 RHCSW32 0   0.0 0
383 690 953300 SWR 4 BW Radio 6 1 RHDSWB5 0   0.0 0
384 691 953400 SWR 1 BW Radio 6 1 RHDSWB1 0   0.0 0
385 692 953500 SWR 1 RP Radio 6 1 RHCSWR1 0   0.0 0
386 693 953600 SWR 4 RP Radio 6 1 RHCSWR5 0   0.0 0
387 694 954500 BREMEN VIER Radio 6 1 RHARAB4 0   0.0 0
388 696 955200 FRITZ Radio 6 1 RHFODR1 0   0.0 0
389 697 955300 94'3 R.S. 2 Radio 6 1 RHFRRS2 0   0.0 0
390 698 955400 BERLINER RUNDFUNK 91!4 Radio 6 1 RHFBERU 0   0.0 0
391 699 955500 RADIO SAW Radio 6 1 RHGRSAW 0   0.0 0
392 700 955600 RADIO PSR Radio 6 1 RHHRPSR 0   0.0 0
393 701 955700 RBB24 INFORADIO Radio 6 1 RHFINF1 0   0.0 0
394 703 955900 RADIO BROCKEN Radio 6 1 RHGANSA 0   0.0 0
395 704 956000 BAYERN 1 Radio 6 1 RHEBAY1 0   0.0 0
396 705 956100 BAYERN 3 Radio 6 1 RHEBAY3 0   0.0 0
397 706 956200 BAYERN 2 Radio 6 1 RHEBY21 0   0.0 0
398 707 956300 ANTENNE BAYERN Radio 6 1 RHEANTB 0   0.0 0
399 708 956400 ANTENNE NIEDERSACHSEN Radio 6 1 RHAANTE 0   0.0 0
400 709 956500 BR24 Radio 6 1 RHEBY59 0   0.0 0
401 710 956600 BR KLASSIK Radio 6 1 RHEBA44 0   0.0 0
402 711 956700 BAYERN FUNKPAKET Radio 6 1 RHEBAFA 0   0.0 0
403 712 956800 ROCK ANTENNE HAMBURG Radio 6 1 RHAROHH 0   0.0 0
404 713 957000 RBB 88,8 Radio 6 1 RHFS881 0   0.0 0
405 714 957400 RADIOEINS Radio 6 1 RHFR104 0   0.0 0
406 716 957700 PLANET RADIO Radio 6 1 RHCPLRA 0   0.0 0
407 717 958000 RTL RADIO Radio 6 1 RHZRTLR 0   0.0 0
408 718 958002 104.6 RTL Radio 6 1 RHF1046 0   0.0 0
409 719 958500 RADIO KOMBI BADEN-WUERTT. Radio 6 1 RHDRKB8 0   0.0 0
410 720 958600 ENERGY SACHSEN Radio 6 1 RHHENSA 0   0.0 0
411 721 958700 RADIO BOB! ROCKT SH Radio 6 1 RHANORA 0   0.0 0
412 722 958800 ENERGY BREMEN Radio 6 1 RHARWVH 0   0.0 0
413 723 959000 NDR 2 Radio 6 1 RHAND2A 0   0.0 0
414 724 959100 WDR 2 Radio 6 1 RHBWD2A 0   0.0 0
415 726 959300 1 LIVE Radio 6 1 RHBW1LA 0   0.0 0
416 727 959400 105,5 SPREERADIO Radio 6 1 RHFSPRE 0   0.0 0
417 728 959500 R.SH RADIO SCHLESWIG-HOLSTEIN Radio 6 1 RHARASH 0   0.0 0
427 812 958100 JAM FM NEW MUSIC RADIO Radio 6 1 RHZJAMF 0   0.0 0
428 813 958300 LANDESWELLE THUERINGEN Radio 6 1 RHHLANT 0   0.0 0
436 868 952800 SR 3 SAARLANDWELLE Radio 6 1 RHCS3SW 0   0.0 0
437 869 952900 98 8 KISS FM Radio 6 1 RHFKISS 0   0.0 0
438 870 955100 SR 1 Radio 6 1 RHCS1EW 0   0.0 0
439 871 957800 R.SA Radio 6 1 RHHOLFM 0   0.0 0
441 897 951400 ENERGY HAMBURG Radio 6 1 RHAENHH 0   0.0 0
445 916 952400 BIGFM DEUTSCHLA. BIGGSTE BEATS Radio 6 1 RHDBIGF 0   0.0 0
448 924 950018 RADIO SALUE Radio 6 1 RHCRASA 0   0.0 0
465 1006 970991 RADIO 21 Radio 6 1 RHARA21 0   0.0 0
475 1053 971019 FUNK KOMBI WEST Radio 6 1 RHBFUK2 0   0.0 0
477 1060 971021 RHEINLAND KOMBI KOELN Radio 6 1 RHBRLKK 0   0.0 0
488 1087 971103 89.0 RTL Radio 6 1 RHGP890 0   0.0 0
576 1355 972176 YOU FM Radio 6 1 RHCHXXL 0   0.0 0
579 1368 972226 KLASSIK RADIO BERLIN Radio 6 1 RHFKLGB 0   0.0 0
590 1418 972221 KLASSIK RADIO NATIONAL Radio 6 1 RHZKLAR 0   0.0 0
623 1581 900701 HR-INFO Radio 6 1 RHCHRSL 0   0.0 0
626 1599 973028 ROCKLAND RADIO Radio 6 1 RHCROLA 0   0.0 0
677 1681 973155 STAR FM 87.9 Radio 6 1 RHFROCK 0   0.0 0
694 1791 973323 WESTFUNK KOMBI RUHR Radio 6 1 RHBRUH2 0   0.0 0
727 1936 974135 HARMONY.FM Radio 6 1 RHCHAFM 0   0.0 0
728 1937 974136 RADIO BOB! Radio 6 1 RHCSKYR 0   0.0 0
814 2298 974815 SACHSEN FUNKPAKET Radio 6 1 RHHSAFU 0   0.0 0
1279 163986 979691 BREMEN NEXT Radio 6 1 RHABRNE 0   0.0 0
1280 163987 979692 ENERGY NUERNBERG Radio 6 1   0   0.0 0
1281 163988 979693 ENERGY MUENCHEN Radio 6 1 RHEENER 0   0.0 0
1282 163989 979694 ENERGY STUTTGART Radio 6 1 RHDENER 0   0.0 0
1994 164701 980927 FUNK KOMBI OWL PLUS Radio 6 1 RHBFOWL 0   0.0 0
2138 164845 981190 SUNSHINE LIVE Radio 6 1 RHZSULI 0   0.0 0
2224     MDR BASIC Radio 6   RHGMDRK        
2435   981411 RADIO BOLLERWAGEN Radio 6 1 RHBRABL        

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE nielsen_medias (
	id INTEGER NOT NULL, 
	"mediaDetailCodeId" INTEGER, 
	code INTEGER, 
	title VARCHAR, 
	gattung INTEGER, 
	"idTb" INTEGER, 
	"studyCode" VARCHAR, 
	"noTablesGesamt" INTEGER, 
	time VARCHAR, 
	"factorDefault" FLOAT, 
	"costPerGroup" INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(gattung) REFERENCES media_gattung (id)
);
CREATE INDEX "ix_nielsen_medias_studyCode" ON nielsen_medias ("studyCode");
CREATE INDEX ix_nielsen_medias_time ON nielsen_medias (time);
CREATE INDEX ix_nielsen_medias_title ON nielsen_medias (title);