nielsen_medias

55 rows where gattung = 12

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: idTb, studyCode, costPerGroup

id ▼ mediaDetailCodeId code title gattung idTb studyCode noTablesGesamt time factorDefault costPerGroup
2517   971558 BUS/BAHN BY TRANSPORT MEDIA 12 13 A__FG       12455
2518   971559 BUS/BAHN BB TRANSPORT MEDIA 12 16 A__FG       13944
2519   971560 BUS/BAHN BE TRANSPORT MEDIA 12 14 A__FG       19902
2520   971561 BUS/BAHN HB TRANSPORT MEDIA 12 7 A__FG       17311
2521   971562 BUS/BAHN BW TRANSPORT MEDIA 12 12 A__FG       13664
2522   971563 BUS/BAHN HE TRANSPORT MEDIA 12 9 A__FG       14030
2523   971564 BUS/BAHN HH TRANSPORT MEDIA 12 5 A__FG       17959
2524   971565 BUS/BAHN MV TRANSPORT MEDIA 12 15 A__FG       16729
2525   971566 BUS/BAHN NI TRANSPORT MEDIA 12 6 A__FG       13448
2526   971567 BUS/BAHN NW TRANSPORT MEDIA 12 8 A__FG       14160
2527   971568 BUS/BAHN RP TRANSPORT MEDIA 12 10 A__FG       12865
2528   971569 BUS/BAHN SL TRANSPORT MEDIA 12 11 A__FG       13145
2529   971570 BUS/BAHN SH TRANSPORT MEDIA 12 4 A__FG       13405
2530   971571 BUS/BAHN SN TRANSPORT MEDIA 12 19 A__FG       15757
2531   971572 BUS/BAHN ST TRANSPORT MEDIA 12 17 A__FG       15175
2532   971612 BAHNHOF BY TRANSPORT MEDIA 12 13 A__FG       12455
2533   971613 BAHNHOF BB TRANSPORT MEDIA 12 16 A__FG       13944
2534   971614 BAHNHOF BE TRANSPORT MEDIA 12 14 A__FG       19902
2535   971616 BAHNHOF BW TRANSPORT MEDIA 12 12 A__FG       13664
2536   971617 BAHNHOF HE TRANSPORT MEDIA 12 9 A__FG       14030
2537   971618 BAHNHOF HH TRANSPORT MEDIA 12 5 A__FG       17959
2538   971619 BAHNHOF MV TRANSPORT MEDIA 12 15 A__FG       16729
2539   971620 BAHNHOF NI TRANSPORT MEDIA 12 6 A__FG       13448
2540   971621 BAHNHOF NW TRANSPORT MEDIA 12 8 A__FG       14160
2541   971622 BAHNHOF RP TRANSPORT MEDIA 12 10 A__FG       12865
2542   971623 BAHNHOF SL TRANSPORT MEDIA 12 11 A__FG       13145
2543   971624 BAHNHOF SH TRANSPORT MEDIA 12 4 A__FG       13405
2544   971625 BAHNHOF SN TRANSPORT MEDIA 12 19 A__FG       15757
2545   971626 BAHNHOF ST TRANSPORT MEDIA 12 17 A__FG       15175
2546   971627 BAHNHOF TH TRANSPORT MEDIA 12 18 A__FG       14182
2547   971630 FLUGHAFEN BY TRANSPORT MEDIA 12 13 A__FG       12455
2548   971634 FLUGHAFEN BW TRANSPORT MEDIA 12 12 A__FG       13664
2549   971636 FLUGHAFEN HH TRANSPORT MEDIA 12 5 A__FG       17959
2550   971637 FLUGHAFEN MV TRANSPORT MEDIA 12 15 A__FG       16729
2551   971638 FLUGHAFEN NI TRANSPORT MEDIA 12 6 A__FG       13448
2552   971639 FLUGHAFEN NW TRANSPORT MEDIA 12 8 A__FG       14160
2553   974082 BAHNHOF/STATION UEBERREGI TRANSPORT MEDIA 12 1 A__FG       14160
2554   977352 SONSTIGE TRANSPORT TRANSPORT MEDIA 12 1 A__FG       14160
2555   979230 BAHNHOF/STATION BB TRANSPORT MEDIA 12 16 A__FG       13944
2556   979231 BAHNHOF/STATION BE TRANSPORT MEDIA 12 14 A__FG       19902
2557   979233 BAHNHOF/STATION BY TRANSPORT MEDIA 12 13 A__FG       12455
2558   979234 BAHNHOF/STATION HB TRANSPORT MEDIA 12 7 A__FG       17311
2559   979235 BAHNHOF/STATION HE TRANSPORT MEDIA 12 9 A__FG       14030
2560   979236 BAHNHOF/STATION HH TRANSPORT MEDIA 12 5 A__FG       17959
2561   979237 BAHNHOF/STATION MV TRANSPORT MEDIA 12 15 A__FG       16729
2562   979238 BAHNHOF/STATION NI TRANSPORT MEDIA 12 6 A__FG       13448
2563   979239 BAHNHOF/STATION NW TRANSPORT MEDIA 12 8 A__FG       14160
2564   979240 BAHNHOF/STATION RP TRANSPORT MEDIA 12 10 A__FG       12865
2565   979241 BAHNHOF/STATION SH TRANSPORT MEDIA 12 4 A__FG       13405
2566   979242 BAHNHOF/STATION SL TRANSPORT MEDIA 12 11 A__FG       13145
2567   979243 BAHNHOF/STATION SN TRANSPORT MEDIA 12 19 A__FG       15757
2568   979244 BAHNHOF/STATION ST TRANSPORT MEDIA 12 17 A__FG       15175
2569   979245 BAHNHOF/STATION TH TRANSPORT MEDIA 12 18 A__FG       14182
2915   971573 BUS/BAHN TH TRANSPORT MEDIA 12 18 FG       14182
2996   971615 BAHNHOF HB TRANSPORT MEDIA 12 7 FG       17311

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