home / MAAudio_2023_I_HG

Menu
  • Log in

media_variant

190 rows where media = 231

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
43701 Radio Jade 231 Schon mal gehört 1 <HARAJA>KOJF unknown  
43702 Radio Jade 231 Hörer in den letzten 14 Tagen 2 <HARAJA>KOJA unknown  
43703 Radio Jade 231 WHK 3 <HARAJA>KOJANEW unknown  
43704 Radio Jade 231 Tagesreichweite 4 <HARAJA>05002400 unknown  
43705 Radio Jade 231 Durchschnitt 6-18 Uhr 5 <HARAJA>D06001800 unknown  
43706 Radio Jade 231 5.00 - 6.00 Uhr 6 <HARAJA>05000600 unknown  
43707 Radio Jade 231 6.00 - 7.00 Uhr 7 <HARAJA>06000700 unknown  
43708 Radio Jade 231 7.00 - 8.00 Uhr 8 <HARAJA>07000800 unknown  
43709 Radio Jade 231 8.00 - 9.00 Uhr 9 <HARAJA>08000900 unknown  
43710 Radio Jade 231 9.00 - 10.00 Uhr 10 <HARAJA>09001000 unknown  
43711 Radio Jade 231 10.00 - 11.00 Uhr 11 <HARAJA>10001100 unknown  
43712 Radio Jade 231 11.00 - 12.00 Uhr 12 <HARAJA>11001200 unknown  
43713 Radio Jade 231 12.00 - 13.00 Uhr 13 <HARAJA>12001300 unknown  
43714 Radio Jade 231 13.00 - 14.00 Uhr 14 <HARAJA>13001400 unknown  
43715 Radio Jade 231 14.00 - 15.00 Uhr 15 <HARAJA>14001500 unknown  
43716 Radio Jade 231 15.00 - 16.00 Uhr 16 <HARAJA>15001600 unknown  
43717 Radio Jade 231 16.00 - 17.00 Uhr 17 <HARAJA>16001700 unknown  
43718 Radio Jade 231 17.00 - 18.00 Uhr 18 <HARAJA>17001800 unknown  
43719 Radio Jade 231 18.00 - 19.00 Uhr 19 <HARAJA>18001900 unknown  
43720 Radio Jade 231 19.00 - 20.00 Uhr 20 <HARAJA>19002000 unknown  
43721 Radio Jade 231 20.00 - 21.00 Uhr 21 <HARAJA>20002100 unknown  
43722 Radio Jade 231 21.00 - 22.00 Uhr 22 <HARAJA>21002200 unknown  
43723 Radio Jade 231 22.00 - 23.00 Uhr 23 <HARAJA>22002300 unknown  
43724 Radio Jade 231 23.00 - 24.00 Uhr 24 <HARAJA>23002400 unknown  
43725 Radio Jade 231 5.00 - 5.15 Uhr 25 <HARAJA>05000515 unknown  
43726 Radio Jade 231 5.15 - 5.30 Uhr 26 <HARAJA>05150530 unknown  
43727 Radio Jade 231 5.30 - 5.45 Uhr 27 <HARAJA>05300545 unknown  
43728 Radio Jade 231 5.45 - 6.00 Uhr 28 <HARAJA>05450600 unknown  
43729 Radio Jade 231 6.00 - 6.15 Uhr 29 <HARAJA>06000615 unknown  
43730 Radio Jade 231 6.15 - 6.30 Uhr 30 <HARAJA>06150630 unknown  
43731 Radio Jade 231 6.30 - 6.45 Uhr 31 <HARAJA>06300645 unknown  
43732 Radio Jade 231 6.45 - 7.00 Uhr 32 <HARAJA>06450700 unknown  
43733 Radio Jade 231 7.00 - 7.15 Uhr 33 <HARAJA>07000715 unknown  
43734 Radio Jade 231 7.15 - 7.30 Uhr 34 <HARAJA>07150730 unknown  
43735 Radio Jade 231 7.30 - 7.45 Uhr 35 <HARAJA>07300745 unknown  
43736 Radio Jade 231 7.45 - 8.00 Uhr 36 <HARAJA>07450800 unknown  
43737 Radio Jade 231 8.00 - 8.15 Uhr 37 <HARAJA>08000815 unknown  
43738 Radio Jade 231 8.15 - 8.30 Uhr 38 <HARAJA>08150830 unknown  
43739 Radio Jade 231 8.30 - 8.45 Uhr 39 <HARAJA>08300845 unknown  
43740 Radio Jade 231 8.45 - 9.00 Uhr 40 <HARAJA>08450900 unknown  
43741 Radio Jade 231 9.00 - 9.15 Uhr 41 <HARAJA>09000915 unknown  
43742 Radio Jade 231 9.15 - 9.30 Uhr 42 <HARAJA>09150930 unknown  
43743 Radio Jade 231 9.30 - 9.45 Uhr 43 <HARAJA>09300945 unknown  
43744 Radio Jade 231 9.45 - 10.00 Uhr 44 <HARAJA>09451000 unknown  
43745 Radio Jade 231 10.00 - 10.15 Uhr 45 <HARAJA>10001015 unknown  
43746 Radio Jade 231 10.15 - 10.30 Uhr 46 <HARAJA>10151030 unknown  
43747 Radio Jade 231 10.30 - 10.45 Uhr 47 <HARAJA>10301045 unknown  
43748 Radio Jade 231 10.45 - 11.00 Uhr 48 <HARAJA>10451100 unknown  
43749 Radio Jade 231 11.00 - 11.15 Uhr 49 <HARAJA>11001115 unknown  
43750 Radio Jade 231 11.15 - 11.30 Uhr 50 <HARAJA>11151130 unknown  
43751 Radio Jade 231 11.30 - 11.45 Uhr 51 <HARAJA>11301145 unknown  
43752 Radio Jade 231 11.45 - 12.00 Uhr 52 <HARAJA>11451200 unknown  
43753 Radio Jade 231 12.00 - 12.15 Uhr 53 <HARAJA>12001215 unknown  
43754 Radio Jade 231 12.15 - 12.30 Uhr 54 <HARAJA>12151230 unknown  
43755 Radio Jade 231 12.30 - 12.45 Uhr 55 <HARAJA>12301245 unknown  
43756 Radio Jade 231 12.45 - 13.00 Uhr 56 <HARAJA>12451300 unknown  
43757 Radio Jade 231 13.00 - 13.15 Uhr 57 <HARAJA>13001315 unknown  
43758 Radio Jade 231 13.15 - 13.30 Uhr 58 <HARAJA>13151330 unknown  
43759 Radio Jade 231 13.30 - 13.45 Uhr 59 <HARAJA>13301345 unknown  
43760 Radio Jade 231 13.45 - 14.00 Uhr 60 <HARAJA>13451400 unknown  
43761 Radio Jade 231 14.00 - 14.15 Uhr 61 <HARAJA>14001415 unknown  
43762 Radio Jade 231 14.15 - 14.30 Uhr 62 <HARAJA>14151430 unknown  
43763 Radio Jade 231 14.30 - 14.45 Uhr 63 <HARAJA>14301445 unknown  
43764 Radio Jade 231 14.45 - 15.00 Uhr 64 <HARAJA>14451500 unknown  
43765 Radio Jade 231 15.00 - 15.15 Uhr 65 <HARAJA>15001515 unknown  
43766 Radio Jade 231 15.15 - 15.30 Uhr 66 <HARAJA>15151530 unknown  
43767 Radio Jade 231 15.30 - 15.45 Uhr 67 <HARAJA>15301545 unknown  
43768 Radio Jade 231 15.45 - 16.00 Uhr 68 <HARAJA>15451600 unknown  
43769 Radio Jade 231 16.00 - 16.15 Uhr 69 <HARAJA>16001615 unknown  
43770 Radio Jade 231 16.15 - 16.30 Uhr 70 <HARAJA>16151630 unknown  
43771 Radio Jade 231 16.30 - 16.45 Uhr 71 <HARAJA>16301645 unknown  
43772 Radio Jade 231 16.45 - 17.00 Uhr 72 <HARAJA>16451700 unknown  
43773 Radio Jade 231 17.00 - 17.15 Uhr 73 <HARAJA>17001715 unknown  
43774 Radio Jade 231 17.15 - 17.30 Uhr 74 <HARAJA>17151730 unknown  
43775 Radio Jade 231 17.30 - 17.45 Uhr 75 <HARAJA>17301745 unknown  
43776 Radio Jade 231 17.45 - 18.00 Uhr 76 <HARAJA>17451800 unknown  
43777 Radio Jade 231 18.00 - 18.15 Uhr 77 <HARAJA>18001815 unknown  
43778 Radio Jade 231 18.15 - 18.30 Uhr 78 <HARAJA>18151830 unknown  
43779 Radio Jade 231 18.30 - 18.45 Uhr 79 <HARAJA>18301845 unknown  
43780 Radio Jade 231 18.45 - 19.00 Uhr 80 <HARAJA>18451900 unknown  
43781 Radio Jade 231 19.00 - 19.15 Uhr 81 <HARAJA>19001915 unknown  
43782 Radio Jade 231 19.15 - 19.30 Uhr 82 <HARAJA>19151930 unknown  
43783 Radio Jade 231 19.30 - 19.45 Uhr 83 <HARAJA>19301945 unknown  
43784 Radio Jade 231 19.45 - 20.00 Uhr 84 <HARAJA>19452000 unknown  
43785 Radio Jade 231 20.00 - 20.15 Uhr 85 <HARAJA>20002015 unknown  
43786 Radio Jade 231 20.15 - 20.30 Uhr 86 <HARAJA>20152030 unknown  
43787 Radio Jade 231 20.30 - 20.45 Uhr 87 <HARAJA>20302045 unknown  
43788 Radio Jade 231 20.45 - 21.00 Uhr 88 <HARAJA>20452100 unknown  
43789 Radio Jade 231 21.00 - 21.15 Uhr 89 <HARAJA>21002115 unknown  
43790 Radio Jade 231 21.15 - 21.30 Uhr 90 <HARAJA>21152130 unknown  
43791 Radio Jade 231 21.30 - 21.45 Uhr 91 <HARAJA>21302145 unknown  
43792 Radio Jade 231 21.45 - 22.00 Uhr 92 <HARAJA>21452200 unknown  
43793 Radio Jade 231 22.00 - 22.15 Uhr 93 <HARAJA>22002215 unknown  
43794 Radio Jade 231 22.15 - 22.30 Uhr 94 <HARAJA>22152230 unknown  
43795 Radio Jade 231 22.30 - 22.45 Uhr 95 <HARAJA>22302245 unknown  
43796 Radio Jade 231 22.45 - 23.00 Uhr 96 <HARAJA>22452300 unknown  
43797 Radio Jade 231 23.00 - 23.15 Uhr 97 <HARAJA>23002315 unknown  
43798 Radio Jade 231 23.15 - 23.30 Uhr 98 <HARAJA>23152330 unknown  
43799 Radio Jade 231 23.30 - 23.45 Uhr 99 <HARAJA>23302345 unknown  
43800 Radio Jade 231 23.45 - 24.00 Uhr 100 <HARAJA>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 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);
CREATE INDEX ix_media_variant_study_status ON media_variant (study_status);
Powered by Datasette · Queries took 1.2ms