home / MAAudio_2023_I_HG

Menu
  • Log in

media_variant

190 rows where media = 79

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ media variant study_code study_status raw_sample
14821 Spotify 79 Schon mal gehört 1 <MA66250000>KOJF unknown  
14822 Spotify 79 Hörer in den letzten 14 Tagen 2 <MA66250000>KOJA unknown  
14823 Spotify 79 WHK 3 <MA66250000>KOJANEW unknown  
14824 Spotify 79 Tagesreichweite 4 <MA66250000>05002400 unknown  
14825 Spotify 79 Durchschnitt 6-18 Uhr 5 <MA66250000>D06001800 unknown  
14826 Spotify 79 5.00 - 6.00 Uhr 6 <MA66250000>05000600 unknown  
14827 Spotify 79 6.00 - 7.00 Uhr 7 <MA66250000>06000700 unknown  
14828 Spotify 79 7.00 - 8.00 Uhr 8 <MA66250000>07000800 unknown  
14829 Spotify 79 8.00 - 9.00 Uhr 9 <MA66250000>08000900 unknown  
14830 Spotify 79 9.00 - 10.00 Uhr 10 <MA66250000>09001000 unknown  
14831 Spotify 79 10.00 - 11.00 Uhr 11 <MA66250000>10001100 unknown  
14832 Spotify 79 11.00 - 12.00 Uhr 12 <MA66250000>11001200 unknown  
14833 Spotify 79 12.00 - 13.00 Uhr 13 <MA66250000>12001300 unknown  
14834 Spotify 79 13.00 - 14.00 Uhr 14 <MA66250000>13001400 unknown  
14835 Spotify 79 14.00 - 15.00 Uhr 15 <MA66250000>14001500 unknown  
14836 Spotify 79 15.00 - 16.00 Uhr 16 <MA66250000>15001600 unknown  
14837 Spotify 79 16.00 - 17.00 Uhr 17 <MA66250000>16001700 unknown  
14838 Spotify 79 17.00 - 18.00 Uhr 18 <MA66250000>17001800 unknown  
14839 Spotify 79 18.00 - 19.00 Uhr 19 <MA66250000>18001900 unknown  
14840 Spotify 79 19.00 - 20.00 Uhr 20 <MA66250000>19002000 unknown  
14841 Spotify 79 20.00 - 21.00 Uhr 21 <MA66250000>20002100 unknown  
14842 Spotify 79 21.00 - 22.00 Uhr 22 <MA66250000>21002200 unknown  
14843 Spotify 79 22.00 - 23.00 Uhr 23 <MA66250000>22002300 unknown  
14844 Spotify 79 23.00 - 24.00 Uhr 24 <MA66250000>23002400 unknown  
14845 Spotify 79 5.00 - 5.15 Uhr 25 <MA66250000>05000515 unknown  
14846 Spotify 79 5.15 - 5.30 Uhr 26 <MA66250000>05150530 unknown  
14847 Spotify 79 5.30 - 5.45 Uhr 27 <MA66250000>05300545 unknown  
14848 Spotify 79 5.45 - 6.00 Uhr 28 <MA66250000>05450600 unknown  
14849 Spotify 79 6.00 - 6.15 Uhr 29 <MA66250000>06000615 unknown  
14850 Spotify 79 6.15 - 6.30 Uhr 30 <MA66250000>06150630 unknown  
14851 Spotify 79 6.30 - 6.45 Uhr 31 <MA66250000>06300645 unknown  
14852 Spotify 79 6.45 - 7.00 Uhr 32 <MA66250000>06450700 unknown  
14853 Spotify 79 7.00 - 7.15 Uhr 33 <MA66250000>07000715 unknown  
14854 Spotify 79 7.15 - 7.30 Uhr 34 <MA66250000>07150730 unknown  
14855 Spotify 79 7.30 - 7.45 Uhr 35 <MA66250000>07300745 unknown  
14856 Spotify 79 7.45 - 8.00 Uhr 36 <MA66250000>07450800 unknown  
14857 Spotify 79 8.00 - 8.15 Uhr 37 <MA66250000>08000815 unknown  
14858 Spotify 79 8.15 - 8.30 Uhr 38 <MA66250000>08150830 unknown  
14859 Spotify 79 8.30 - 8.45 Uhr 39 <MA66250000>08300845 unknown  
14860 Spotify 79 8.45 - 9.00 Uhr 40 <MA66250000>08450900 unknown  
14861 Spotify 79 9.00 - 9.15 Uhr 41 <MA66250000>09000915 unknown  
14862 Spotify 79 9.15 - 9.30 Uhr 42 <MA66250000>09150930 unknown  
14863 Spotify 79 9.30 - 9.45 Uhr 43 <MA66250000>09300945 unknown  
14864 Spotify 79 9.45 - 10.00 Uhr 44 <MA66250000>09451000 unknown  
14865 Spotify 79 10.00 - 10.15 Uhr 45 <MA66250000>10001015 unknown  
14866 Spotify 79 10.15 - 10.30 Uhr 46 <MA66250000>10151030 unknown  
14867 Spotify 79 10.30 - 10.45 Uhr 47 <MA66250000>10301045 unknown  
14868 Spotify 79 10.45 - 11.00 Uhr 48 <MA66250000>10451100 unknown  
14869 Spotify 79 11.00 - 11.15 Uhr 49 <MA66250000>11001115 unknown  
14870 Spotify 79 11.15 - 11.30 Uhr 50 <MA66250000>11151130 unknown  
14871 Spotify 79 11.30 - 11.45 Uhr 51 <MA66250000>11301145 unknown  
14872 Spotify 79 11.45 - 12.00 Uhr 52 <MA66250000>11451200 unknown  
14873 Spotify 79 12.00 - 12.15 Uhr 53 <MA66250000>12001215 unknown  
14874 Spotify 79 12.15 - 12.30 Uhr 54 <MA66250000>12151230 unknown  
14875 Spotify 79 12.30 - 12.45 Uhr 55 <MA66250000>12301245 unknown  
14876 Spotify 79 12.45 - 13.00 Uhr 56 <MA66250000>12451300 unknown  
14877 Spotify 79 13.00 - 13.15 Uhr 57 <MA66250000>13001315 unknown  
14878 Spotify 79 13.15 - 13.30 Uhr 58 <MA66250000>13151330 unknown  
14879 Spotify 79 13.30 - 13.45 Uhr 59 <MA66250000>13301345 unknown  
14880 Spotify 79 13.45 - 14.00 Uhr 60 <MA66250000>13451400 unknown  
14881 Spotify 79 14.00 - 14.15 Uhr 61 <MA66250000>14001415 unknown  
14882 Spotify 79 14.15 - 14.30 Uhr 62 <MA66250000>14151430 unknown  
14883 Spotify 79 14.30 - 14.45 Uhr 63 <MA66250000>14301445 unknown  
14884 Spotify 79 14.45 - 15.00 Uhr 64 <MA66250000>14451500 unknown  
14885 Spotify 79 15.00 - 15.15 Uhr 65 <MA66250000>15001515 unknown  
14886 Spotify 79 15.15 - 15.30 Uhr 66 <MA66250000>15151530 unknown  
14887 Spotify 79 15.30 - 15.45 Uhr 67 <MA66250000>15301545 unknown  
14888 Spotify 79 15.45 - 16.00 Uhr 68 <MA66250000>15451600 unknown  
14889 Spotify 79 16.00 - 16.15 Uhr 69 <MA66250000>16001615 unknown  
14890 Spotify 79 16.15 - 16.30 Uhr 70 <MA66250000>16151630 unknown  
14891 Spotify 79 16.30 - 16.45 Uhr 71 <MA66250000>16301645 unknown  
14892 Spotify 79 16.45 - 17.00 Uhr 72 <MA66250000>16451700 unknown  
14893 Spotify 79 17.00 - 17.15 Uhr 73 <MA66250000>17001715 unknown  
14894 Spotify 79 17.15 - 17.30 Uhr 74 <MA66250000>17151730 unknown  
14895 Spotify 79 17.30 - 17.45 Uhr 75 <MA66250000>17301745 unknown  
14896 Spotify 79 17.45 - 18.00 Uhr 76 <MA66250000>17451800 unknown  
14897 Spotify 79 18.00 - 18.15 Uhr 77 <MA66250000>18001815 unknown  
14898 Spotify 79 18.15 - 18.30 Uhr 78 <MA66250000>18151830 unknown  
14899 Spotify 79 18.30 - 18.45 Uhr 79 <MA66250000>18301845 unknown  
14900 Spotify 79 18.45 - 19.00 Uhr 80 <MA66250000>18451900 unknown  
14901 Spotify 79 19.00 - 19.15 Uhr 81 <MA66250000>19001915 unknown  
14902 Spotify 79 19.15 - 19.30 Uhr 82 <MA66250000>19151930 unknown  
14903 Spotify 79 19.30 - 19.45 Uhr 83 <MA66250000>19301945 unknown  
14904 Spotify 79 19.45 - 20.00 Uhr 84 <MA66250000>19452000 unknown  
14905 Spotify 79 20.00 - 20.15 Uhr 85 <MA66250000>20002015 unknown  
14906 Spotify 79 20.15 - 20.30 Uhr 86 <MA66250000>20152030 unknown  
14907 Spotify 79 20.30 - 20.45 Uhr 87 <MA66250000>20302045 unknown  
14908 Spotify 79 20.45 - 21.00 Uhr 88 <MA66250000>20452100 unknown  
14909 Spotify 79 21.00 - 21.15 Uhr 89 <MA66250000>21002115 unknown  
14910 Spotify 79 21.15 - 21.30 Uhr 90 <MA66250000>21152130 unknown  
14911 Spotify 79 21.30 - 21.45 Uhr 91 <MA66250000>21302145 unknown  
14912 Spotify 79 21.45 - 22.00 Uhr 92 <MA66250000>21452200 unknown  
14913 Spotify 79 22.00 - 22.15 Uhr 93 <MA66250000>22002215 unknown  
14914 Spotify 79 22.15 - 22.30 Uhr 94 <MA66250000>22152230 unknown  
14915 Spotify 79 22.30 - 22.45 Uhr 95 <MA66250000>22302245 unknown  
14916 Spotify 79 22.45 - 23.00 Uhr 96 <MA66250000>22452300 unknown  
14917 Spotify 79 23.00 - 23.15 Uhr 97 <MA66250000>23002315 unknown  
14918 Spotify 79 23.15 - 23.30 Uhr 98 <MA66250000>23152330 unknown  
14919 Spotify 79 23.30 - 23.45 Uhr 99 <MA66250000>23302345 unknown  
14920 Spotify 79 23.45 - 24.00 Uhr 100 <MA66250000>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