home / MAAudio_2024_II_HG_Update

Menu
  • Log in

media_variant

190 rows where media = 476

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
90251 Trigger FM 476 Schon mal gehört 1 <HCTRIG>KOJF unknown  
90252 Trigger FM 476 Hörer in den letzten 14 Tagen 2 <HCTRIG>KOJA unknown  
90253 Trigger FM 476 WHK 3 <HCTRIG>KOJANEW unknown  
90254 Trigger FM 476 Tagesreichweite 4 <HCTRIG>05002400 unknown  
90255 Trigger FM 476 Durchschnitt 6-18 Uhr 5 <HCTRIG>D06001800 unknown  
90256 Trigger FM 476 5.00 - 6.00 Uhr 6 <HCTRIG>05000600 unknown  
90257 Trigger FM 476 6.00 - 7.00 Uhr 7 <HCTRIG>06000700 unknown  
90258 Trigger FM 476 7.00 - 8.00 Uhr 8 <HCTRIG>07000800 unknown  
90259 Trigger FM 476 8.00 - 9.00 Uhr 9 <HCTRIG>08000900 unknown  
90260 Trigger FM 476 9.00 - 10.00 Uhr 10 <HCTRIG>09001000 unknown  
90261 Trigger FM 476 10.00 - 11.00 Uhr 11 <HCTRIG>10001100 unknown  
90262 Trigger FM 476 11.00 - 12.00 Uhr 12 <HCTRIG>11001200 unknown  
90263 Trigger FM 476 12.00 - 13.00 Uhr 13 <HCTRIG>12001300 unknown  
90264 Trigger FM 476 13.00 - 14.00 Uhr 14 <HCTRIG>13001400 unknown  
90265 Trigger FM 476 14.00 - 15.00 Uhr 15 <HCTRIG>14001500 unknown  
90266 Trigger FM 476 15.00 - 16.00 Uhr 16 <HCTRIG>15001600 unknown  
90267 Trigger FM 476 16.00 - 17.00 Uhr 17 <HCTRIG>16001700 unknown  
90268 Trigger FM 476 17.00 - 18.00 Uhr 18 <HCTRIG>17001800 unknown  
90269 Trigger FM 476 18.00 - 19.00 Uhr 19 <HCTRIG>18001900 unknown  
90270 Trigger FM 476 19.00 - 20.00 Uhr 20 <HCTRIG>19002000 unknown  
90271 Trigger FM 476 20.00 - 21.00 Uhr 21 <HCTRIG>20002100 unknown  
90272 Trigger FM 476 21.00 - 22.00 Uhr 22 <HCTRIG>21002200 unknown  
90273 Trigger FM 476 22.00 - 23.00 Uhr 23 <HCTRIG>22002300 unknown  
90274 Trigger FM 476 23.00 - 24.00 Uhr 24 <HCTRIG>23002400 unknown  
90275 Trigger FM 476 5.00 - 5.15 Uhr 25 <HCTRIG>05000515 unknown  
90276 Trigger FM 476 5.15 - 5.30 Uhr 26 <HCTRIG>05150530 unknown  
90277 Trigger FM 476 5.30 - 5.45 Uhr 27 <HCTRIG>05300545 unknown  
90278 Trigger FM 476 5.45 - 6.00 Uhr 28 <HCTRIG>05450600 unknown  
90279 Trigger FM 476 6.00 - 6.15 Uhr 29 <HCTRIG>06000615 unknown  
90280 Trigger FM 476 6.15 - 6.30 Uhr 30 <HCTRIG>06150630 unknown  
90281 Trigger FM 476 6.30 - 6.45 Uhr 31 <HCTRIG>06300645 unknown  
90282 Trigger FM 476 6.45 - 7.00 Uhr 32 <HCTRIG>06450700 unknown  
90283 Trigger FM 476 7.00 - 7.15 Uhr 33 <HCTRIG>07000715 unknown  
90284 Trigger FM 476 7.15 - 7.30 Uhr 34 <HCTRIG>07150730 unknown  
90285 Trigger FM 476 7.30 - 7.45 Uhr 35 <HCTRIG>07300745 unknown  
90286 Trigger FM 476 7.45 - 8.00 Uhr 36 <HCTRIG>07450800 unknown  
90287 Trigger FM 476 8.00 - 8.15 Uhr 37 <HCTRIG>08000815 unknown  
90288 Trigger FM 476 8.15 - 8.30 Uhr 38 <HCTRIG>08150830 unknown  
90289 Trigger FM 476 8.30 - 8.45 Uhr 39 <HCTRIG>08300845 unknown  
90290 Trigger FM 476 8.45 - 9.00 Uhr 40 <HCTRIG>08450900 unknown  
90291 Trigger FM 476 9.00 - 9.15 Uhr 41 <HCTRIG>09000915 unknown  
90292 Trigger FM 476 9.15 - 9.30 Uhr 42 <HCTRIG>09150930 unknown  
90293 Trigger FM 476 9.30 - 9.45 Uhr 43 <HCTRIG>09300945 unknown  
90294 Trigger FM 476 9.45 - 10.00 Uhr 44 <HCTRIG>09451000 unknown  
90295 Trigger FM 476 10.00 - 10.15 Uhr 45 <HCTRIG>10001015 unknown  
90296 Trigger FM 476 10.15 - 10.30 Uhr 46 <HCTRIG>10151030 unknown  
90297 Trigger FM 476 10.30 - 10.45 Uhr 47 <HCTRIG>10301045 unknown  
90298 Trigger FM 476 10.45 - 11.00 Uhr 48 <HCTRIG>10451100 unknown  
90299 Trigger FM 476 11.00 - 11.15 Uhr 49 <HCTRIG>11001115 unknown  
90300 Trigger FM 476 11.15 - 11.30 Uhr 50 <HCTRIG>11151130 unknown  
90301 Trigger FM 476 11.30 - 11.45 Uhr 51 <HCTRIG>11301145 unknown  
90302 Trigger FM 476 11.45 - 12.00 Uhr 52 <HCTRIG>11451200 unknown  
90303 Trigger FM 476 12.00 - 12.15 Uhr 53 <HCTRIG>12001215 unknown  
90304 Trigger FM 476 12.15 - 12.30 Uhr 54 <HCTRIG>12151230 unknown  
90305 Trigger FM 476 12.30 - 12.45 Uhr 55 <HCTRIG>12301245 unknown  
90306 Trigger FM 476 12.45 - 13.00 Uhr 56 <HCTRIG>12451300 unknown  
90307 Trigger FM 476 13.00 - 13.15 Uhr 57 <HCTRIG>13001315 unknown  
90308 Trigger FM 476 13.15 - 13.30 Uhr 58 <HCTRIG>13151330 unknown  
90309 Trigger FM 476 13.30 - 13.45 Uhr 59 <HCTRIG>13301345 unknown  
90310 Trigger FM 476 13.45 - 14.00 Uhr 60 <HCTRIG>13451400 unknown  
90311 Trigger FM 476 14.00 - 14.15 Uhr 61 <HCTRIG>14001415 unknown  
90312 Trigger FM 476 14.15 - 14.30 Uhr 62 <HCTRIG>14151430 unknown  
90313 Trigger FM 476 14.30 - 14.45 Uhr 63 <HCTRIG>14301445 unknown  
90314 Trigger FM 476 14.45 - 15.00 Uhr 64 <HCTRIG>14451500 unknown  
90315 Trigger FM 476 15.00 - 15.15 Uhr 65 <HCTRIG>15001515 unknown  
90316 Trigger FM 476 15.15 - 15.30 Uhr 66 <HCTRIG>15151530 unknown  
90317 Trigger FM 476 15.30 - 15.45 Uhr 67 <HCTRIG>15301545 unknown  
90318 Trigger FM 476 15.45 - 16.00 Uhr 68 <HCTRIG>15451600 unknown  
90319 Trigger FM 476 16.00 - 16.15 Uhr 69 <HCTRIG>16001615 unknown  
90320 Trigger FM 476 16.15 - 16.30 Uhr 70 <HCTRIG>16151630 unknown  
90321 Trigger FM 476 16.30 - 16.45 Uhr 71 <HCTRIG>16301645 unknown  
90322 Trigger FM 476 16.45 - 17.00 Uhr 72 <HCTRIG>16451700 unknown  
90323 Trigger FM 476 17.00 - 17.15 Uhr 73 <HCTRIG>17001715 unknown  
90324 Trigger FM 476 17.15 - 17.30 Uhr 74 <HCTRIG>17151730 unknown  
90325 Trigger FM 476 17.30 - 17.45 Uhr 75 <HCTRIG>17301745 unknown  
90326 Trigger FM 476 17.45 - 18.00 Uhr 76 <HCTRIG>17451800 unknown  
90327 Trigger FM 476 18.00 - 18.15 Uhr 77 <HCTRIG>18001815 unknown  
90328 Trigger FM 476 18.15 - 18.30 Uhr 78 <HCTRIG>18151830 unknown  
90329 Trigger FM 476 18.30 - 18.45 Uhr 79 <HCTRIG>18301845 unknown  
90330 Trigger FM 476 18.45 - 19.00 Uhr 80 <HCTRIG>18451900 unknown  
90331 Trigger FM 476 19.00 - 19.15 Uhr 81 <HCTRIG>19001915 unknown  
90332 Trigger FM 476 19.15 - 19.30 Uhr 82 <HCTRIG>19151930 unknown  
90333 Trigger FM 476 19.30 - 19.45 Uhr 83 <HCTRIG>19301945 unknown  
90334 Trigger FM 476 19.45 - 20.00 Uhr 84 <HCTRIG>19452000 unknown  
90335 Trigger FM 476 20.00 - 20.15 Uhr 85 <HCTRIG>20002015 unknown  
90336 Trigger FM 476 20.15 - 20.30 Uhr 86 <HCTRIG>20152030 unknown  
90337 Trigger FM 476 20.30 - 20.45 Uhr 87 <HCTRIG>20302045 unknown  
90338 Trigger FM 476 20.45 - 21.00 Uhr 88 <HCTRIG>20452100 unknown  
90339 Trigger FM 476 21.00 - 21.15 Uhr 89 <HCTRIG>21002115 unknown  
90340 Trigger FM 476 21.15 - 21.30 Uhr 90 <HCTRIG>21152130 unknown  
90341 Trigger FM 476 21.30 - 21.45 Uhr 91 <HCTRIG>21302145 unknown  
90342 Trigger FM 476 21.45 - 22.00 Uhr 92 <HCTRIG>21452200 unknown  
90343 Trigger FM 476 22.00 - 22.15 Uhr 93 <HCTRIG>22002215 unknown  
90344 Trigger FM 476 22.15 - 22.30 Uhr 94 <HCTRIG>22152230 unknown  
90345 Trigger FM 476 22.30 - 22.45 Uhr 95 <HCTRIG>22302245 unknown  
90346 Trigger FM 476 22.45 - 23.00 Uhr 96 <HCTRIG>22452300 unknown  
90347 Trigger FM 476 23.00 - 23.15 Uhr 97 <HCTRIG>23002315 unknown  
90348 Trigger FM 476 23.15 - 23.30 Uhr 98 <HCTRIG>23152330 unknown  
90349 Trigger FM 476 23.30 - 23.45 Uhr 99 <HCTRIG>23302345 unknown  
90350 Trigger FM 476 23.45 - 24.00 Uhr 100 <HCTRIG>23452400 unknown  

Next page

Advanced export

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

CSV options:

CREATE TABLE media_variant (
	id INTEGER NOT NULL, 
	media INTEGER, 
	variant INTEGER, 
	study_code VARCHAR(100), 
	study_status VARCHAR(7), 
	raw_sample INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(media) REFERENCES media (id), 
	FOREIGN KEY(variant) REFERENCES variant (id)
);
CREATE INDEX ix_media_variant_study_status ON media_variant (study_status);
CREATE UNIQUE INDEX ix_media_variant_study_code ON media_variant (study_code);
CREATE INDEX ix_media_variant_media ON media_variant (media);
CREATE INDEX ix_media_variant_variant ON media_variant (variant);
Powered by Datasette · Queries took 1.2ms