nielsen_medias

86 rows where gattung = 4

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: idTb

id ▼ mediaDetailCodeId code title gattung idTb studyCode noTablesGesamt time factorDefault costPerGroup
310 606 892003 GANZSAEULEN NI Plakate 4 0 SMA60000126 1594   16.099999999999998 0
311 607 892005 GANZSAEULEN NW Plakate 4 0 SMA60000136 3971   22.75 0
312 608 892006 GANZSAEULEN HE Plakate 4 0 SMA60000141 1326   17.779999999999998 0
313 609 892007 GANZSAEULEN RP Plakate 4 0 SMA60000146 727   11.339999999999998 0
314 610 892008 GANZSAEULEN BW Plakate 4 0 SMA60000151 2300   12.529999999999998 0
315 611 892009 GANZSAEULEN BY Plakate 4 0 SMA60000156 3214   21.07 0
316 612 892011 GANZSAEULEN BE Plakate 4 0 SMA60000166 1977   25.479999999999997 0
317 613 892013 GANZSAEULEN MV Plakate 4 0 SMA60000176 211   11.620000000000001 0
318 614 892016 GANZSAEULEN TH Plakate 4 0 SMA60000191 195   8.54 0
319 615 892101 GROSSFLAECHE SH Plakate 4 0 SMA60000113 3064   18.97 0
320 616 892102 GROSSFLAECHE HH Plakate 4 0 SMA60000118 3628   40.18 0
321 617 892103 GROSSFLAECHE NI Plakate 4 0 SMA60000123 11629   24.429999999999996 0
322 618 892104 GROSSFLAECHE HB Plakate 4 0 SMA60000128 1575   47.599999999999994 0
323 619 892105 GROSSFLAECHE NW Plakate 4 0 SMA60000133 37616   65.30999999999999 0
324 620 892106 GROSSFLAECHE HE Plakate 4 0 SMA60000138 11491   35.14 0
325 621 892107 GROSSFLAECHE RP Plakate 4 0 SMA60000143 6381   29.259999999999994 0
326 622 892108 GROSSFLAECHE BW Plakate 4 0 SMA60000148 14999   24.29 0
327 623 892109 GROSSFLAECHE BY Plakate 4 0 SMA60000153 23322   36.4 0
328 624 892110 GROSSFLAECHE SL Plakate 4 0 SMA60000158 2682   59.00999999999999 0
329 625 892111 GROSSFLAECHE BE Plakate 4 0 SMA60000163 7799   65.24 0
330 626 892112 GROSSFLAECHE BB Plakate 4 0 SMA60000168 3644   18.549999999999997 0
331 627 892113 GROSSFLAECHE MV Plakate 4 0 SMA60000173 2670   27.159999999999997 0
332 628 892114 GROSSFLAECHE SN Plakate 4 0 SMA60000178 9111   49.699999999999996 0
333 629 892115 GROSSFLAECHE ST Plakate 4 0 SMA60000183 5094   37.099999999999994 0
334 630 892116 GROSSFLAECHE TH Plakate 4 0 SMA60000188 4969   35.559999999999995 0
335 631 892501 CITY LIGHT SH Plakate 4 1 SMA210000019 1729   10.149999999999999 0
336 632 892502 CITY LIGHT HH Plakate 4 1 SMA210000034 4812   9.94 0
337 633 892503 CITY LIGHT NI Plakate 4 1 SMA210000040 4924   8.889999999999999 0
338 634 892504 CITY LIGHT HB Plakate 4 1 SMA210000058 2522   15.329999999999998 0
339 635 892505 CITY LIGHT NW Plakate 4 1 SMA210000067 23640   13.089999999999998 0
340 636 892506 CITY LIGHT HE Plakate 4 1 SMA210000085 5929   8.75 0
341 637 892507 CITY LIGHT RP Plakate 4 1 SMA210000103 2224   7.839999999999999 0
342 638 892508 CITY LIGHT BW Plakate 4 1 SMA210000118 11753   10.78 0
343 639 892509 CITY LIGHT BY Plakate 4 1 SMA210000136 9385   9.379999999999999 0
344 640 892510 CITY LIGHT SL Plakate 4 1 SMA210000154 1114   8.469999999999999 0
345 641 892511 CITY LIGHT BE Plakate 4 1 SMA210000166 9710   10.08 0
346 642 892512 CITY LIGHT BB Plakate 4 1 SMA210000172 1405   7.069999999999999 0
347 643 892513 CITY LIGHT MV Plakate 4 1 SMA210000187 1326   10.219999999999999 0
348 644 892514 CITY LIGHT SN Plakate 4 1 SMA210000202 5050   11.27 0
349 645 892515 CITY LIGHT ST Plakate 4 1 SMA210000220 1713   7.419999999999999 0
350 646 892516 CITY LIGHT TH Plakate 4 1 SMA210000235 1468   8.399999999999999 0
443 910 892002 GANZSAEULEN HH Plakate 4 0 SMA60000121 1807   7.56 0
446 920 892001 GANZSAEULEN SH Plakate 4 0 SMA60000116 411   12.179999999999998 0
478 1063 893002 CITY LIGHT BOARD HH Plakate 4 1 SMA210000036 1140   4.76 0
479 1064 893003 CITY LIGHT BOARD NI Plakate 4 1 SMA210000042 869   4.619999999999999 0
480 1065 893005 CITY LIGHT BOARD NW Plakate 4 1 SMA210000069 4103   6.369999999999999 0
481 1066 893006 CITY LIGHT BOARD HE Plakate 4 1 SMA210000087 921   4.55 0
482 1067 893009 CITY LIGHT BOARD BY Plakate 4 1 SMA210000138 1619   6.72 0
483 1068 893011 CITY LIGHT BOARD BE Plakate 4 1 SMA210000168 1949   4.83 0
485 1079 893007 CITY LIGHT BOARD RP Plakate 4 1 SMA210000105 317   3.7099999999999995 0
486 1080 893014 CITY LIGHT BOARD SN Plakate 4 1 SMA210000204 1040   5.04 0
487 1083 893001 CITY LIGHT BOARD SH Plakate 4 1 SMA210000021 166   5.8100000000000005 0
489 1090 892010 GANZSAEULEN SL Plakate 4 0 SMA60000161 48   7.139999999999999 0
491 1097 893004 CITY LIGHT BOARD HB Plakate 4 1 SMA210000060 484   5.109999999999999 0
492 1098 893008 CITY LIGHT BOARD BW Plakate 4 1 SMA210000120 1393   4.27 0
493 1100 892004 GANZSAEULEN HB Plakate 4 0 SMA60000131 309   20.509999999999998 0
494 1101 892014 GANZSAEULEN SN Plakate 4 0 SMA60000181 957   18.97 0
495 1102 892015 GANZSAEULEN ST Plakate 4 0 SMA60000186 308   11.27 0
496 1110 893013 CITY LIGHT BOARD MV Plakate 4 1 SMA210000189 166   4.34 0
508 1152 893015 CITY LIGHT BOARD ST Plakate 4 1 SMA210000222 286   4.13 0
509 1153 893016 CITY LIGHT BOARD TH Plakate 4 1 SMA210000237 263   5.18 0
519 1196 893010 CITY LIGHT BOARD SL Plakate 4 1 SMA210000156 84   3.01 0
607 1499 895008 RIESENPOSTER BW Plakate 4 0 SMA60000148 14999   104.10000000000001 0
614 1546 895005 RIESENPOSTER NW Plakate 4 0 SMA60000133 37616   279.9 0
621 1574 893012 CITY LIGHT BOARD BB Plakate 4 1 SMA210000174 45   3.08 0
678 1683 895006 RIESENPOSTER HE Plakate 4 0 SMA60000138 11491   150.60000000000002 0
700 1831 895009 RIESENPOSTER BY Plakate 4 0 SMA60000153 23322   156.0 0
731 1943 895002 RIESENPOSTER HH Plakate 4 0 SMA60000118 3628   172.2 0
732 1944 895011 RIESENPOSTER BE Plakate 4 0 SMA60000163 7799   279.6 0
739 1974 895003 RIESENPOSTER NI Plakate 4 0 SMA60000123 11629   104.69999999999999 0
748 2040 895004 RIESENPOSTER HB Plakate 4 0 SMA60000128 1575   204.0 0
868 163575 893000 CITY LIGHT BOARD Plakate 4 1   0   0.0 0
869 163576 894012 WERBETUERME BB Plakate 4 1   0   0.0 0
870 163577 895001 RIESENPOSTER SH Plakate 4 1 SMA60000113 3064   18.97 0
871 163578 895014 RIESENPOSTER SN Plakate 4 1 SMA60000178 9111   49.6999999999 0
905 163612 974083 RIESENPOSTER Plakate 4 1   0   0.0 0
906 163613 974164 SONSTIGE PLAKAT Plakate 4 1   0   0.0 0
2168 1130 892012 GANZSAEULEN BB Plakate 4 1 SMA60000171        
2191   895015 RIESENPOSTER ST Plakate 4 1 SMA60000183 5094   37.0999999999  
2192   895016 RIESENPOSTER TH Plakate 4 1 SMA60000188 4969   35.5599999999  
2273   892100 GROSSFLAECHE Plakate 4 1          
2274   892500 CITY LIGHT Plakate 4 1          
2896   894015 WERBETUERME ST Plakate 4 1          
2968   894013 WERBETUERME MV Plakate 4 1          
2979   895007 RIESENPOSTER RP Plakate 4 1          
2992 1531 894005 WERBETUERME NW Plakate 4 8          

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);