Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub
This data as json, copyable, CSV (advanced)
Suggested facets: name, query, date (date)
| Link | rowid ▼ | date | name | matched_clips | all_candidate_clips | total_clips | pct_of_all_candidate_clips | query |
|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 2018-12-30 | Amy Klobuchar | 12 | 1279 | 76029 | 0.009382329945269744 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 2 | 2 | 2019-01-06 | Amy Klobuchar | 7 | 1031 | 82964 | 0.006789524733268671 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 3 | 3 | 2019-01-13 | Amy Klobuchar | 45 | 615 | 82521 | 0.07317073170731707 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 4 | 4 | 2019-01-20 | Amy Klobuchar | 10 | 991 | 83649 | 0.010090817356205851 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 5 | 5 | 2019-01-27 | Amy Klobuchar | 16 | 1914 | 80994 | 0.008359456635318705 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 6 | 6 | 2019-02-03 | Amy Klobuchar | 64 | 1454 | 79183 | 0.04401650618982118 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 7 | 7 | 2019-02-10 | Amy Klobuchar | 384 | 1917 | 81893 | 0.20031298904538344 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 8 | 8 | 2019-02-17 | Amy Klobuchar | 231 | 2422 | 82454 | 0.0953757225433526 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 9 | 9 | 2019-02-24 | Amy Klobuchar | 52 | 1545 | 82804 | 0.033656957928802585 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 10 | 10 | 2019-03-03 | Amy Klobuchar | 57 | 1587 | 81321 | 0.03591682419659736 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 11 | 11 | 2019-03-10 | Amy Klobuchar | 68 | 2431 | 85812 | 0.02797202797202797 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 12 | 12 | 2019-03-17 | Amy Klobuchar | 114 | 3174 | 95383 | 0.03591682419659736 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 13 | 13 | 2019-03-24 | Amy Klobuchar | 69 | 1248 | 96184 | 0.055288461538461536 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 14 | 14 | 2019-03-31 | Amy Klobuchar | 42 | 4205 | 93472 | 0.009988109393579072 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 15 | 15 | 2019-04-07 | Amy Klobuchar | 51 | 2345 | 94405 | 0.021748400852878463 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 16 | 16 | 2019-04-14 | Amy Klobuchar | 65 | 2639 | 95286 | 0.024630541871921183 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 17 | 17 | 2019-04-21 | Amy Klobuchar | 102 | 5749 | 94002 | 0.017742216037571753 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 18 | 18 | 2019-04-28 | Amy Klobuchar | 88 | 3956 | 95339 | 0.022244691607684528 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 19 | 19 | 2019-05-05 | Amy Klobuchar | 130 | 2748 | 94528 | 0.04730713245997089 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 20 | 20 | 2019-05-12 | Amy Klobuchar | 43 | 3694 | 94318 | 0.011640498105035191 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 21 | 21 | 2019-05-19 | Amy Klobuchar | 46 | 2650 | 94883 | 0.017358490566037738 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 22 | 22 | 2019-05-26 | Amy Klobuchar | 51 | 3059 | 95289 | 0.016672115070284408 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 23 | 23 | 2019-06-02 | Amy Klobuchar | 40 | 3103 | 95313 | 0.012890750886239123 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 24 | 24 | 2019-06-09 | Amy Klobuchar | 85 | 4780 | 95839 | 0.017782426778242686 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 25 | 25 | 2019-06-16 | Amy Klobuchar | 42 | 4485 | 96026 | 0.009364548494983277 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 26 | 26 | 2019-06-23 | Amy Klobuchar | 167 | 7316 | 96553 | 0.022826681246582832 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 27 | 27 | 2019-06-30 | Amy Klobuchar | 53 | 4384 | 92126 | 0.01208941605839416 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 28 | 28 | 2019-07-07 | Amy Klobuchar | 55 | 3052 | 94299 | 0.01802096985583224 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 29 | 29 | 2019-07-14 | Amy Klobuchar | 71 | 3029 | 94481 | 0.02344007923407065 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 30 | 30 | 2019-07-21 | Amy Klobuchar | 25 | 2574 | 96027 | 0.009712509712509712 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 31 | 31 | 2019-07-28 | Amy Klobuchar | 145 | 7361 | 95970 | 0.019698410542045918 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 32 | 32 | 2019-08-04 | Amy Klobuchar | 48 | 3028 | 95881 | 0.015852047556142668 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 33 | 33 | 2019-08-11 | Amy Klobuchar | 50 | 3288 | 94920 | 0.015206812652068129 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 34 | 34 | 2019-08-18 | Amy Klobuchar | 16 | 3488 | 94494 | 0.004587155963302753 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 35 | 35 | 2019-08-25 | Amy Klobuchar | 54 | 3171 | 94380 | 0.017029328287606442 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 36 | 36 | 2019-09-01 | Amy Klobuchar | 39 | 1829 | 93825 | 0.021323127392017496 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 37 | 37 | 2019-09-08 | Amy Klobuchar | 138 | 4164 | 94278 | 0.03314121037463977 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 38 | 38 | 2019-09-15 | Amy Klobuchar | 77 | 4248 | 94504 | 0.01812617702448211 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 39 | 39 | 2019-09-22 | Amy Klobuchar | 24 | 4582 | 96953 | 0.005237887385421213 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 40 | 40 | 2019-09-29 | Amy Klobuchar | 44 | 3986 | 93672 | 0.011038635223281485 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 41 | 41 | 2019-10-06 | Amy Klobuchar | 40 | 3030 | 94074 | 0.0132013201320132 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 42 | 42 | 2019-10-13 | Amy Klobuchar | 169 | 4393 | 94893 | 0.03847029364898703 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 43 | 43 | 2019-10-20 | Amy Klobuchar | 102 | 3100 | 93205 | 0.032903225806451615 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 44 | 44 | 2018-12-30 | Andrew Yang | 0 | 1279 | 76029 | 0.0 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 45 | 45 | 2019-01-06 | Andrew Yang | 0 | 1031 | 82964 | 0.0 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 46 | 46 | 2019-01-13 | Andrew Yang | 0 | 615 | 82521 | 0.0 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 47 | 47 | 2019-01-20 | Andrew Yang | 1 | 991 | 83649 | 0.001009081735620585 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 48 | 48 | 2019-01-27 | Andrew Yang | 3 | 1914 | 80994 | 0.001567398119122257 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 49 | 49 | 2019-02-03 | Andrew Yang | 0 | 1454 | 79183 | 0.0 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 50 | 50 | 2019-02-10 | Andrew Yang | 3 | 1917 | 81893 | 0.001564945226917058 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 51 | 51 | 2019-02-17 | Andrew Yang | 6 | 2422 | 82454 | 0.002477291494632535 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 52 | 52 | 2019-02-24 | Andrew Yang | 3 | 1545 | 82804 | 0.001941747572815534 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 53 | 53 | 2019-03-03 | Andrew Yang | 5 | 1587 | 81321 | 0.0031505986137366107 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 54 | 54 | 2019-03-10 | Andrew Yang | 2 | 2431 | 85812 | 0.0008227067050596463 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 55 | 55 | 2019-03-17 | Andrew Yang | 13 | 3174 | 95383 | 0.004095778197857593 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 56 | 56 | 2019-03-24 | Andrew Yang | 4 | 1248 | 96184 | 0.003205128205128205 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 57 | 57 | 2019-03-31 | Andrew Yang | 32 | 4205 | 93472 | 0.00760998810939358 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 58 | 58 | 2019-04-07 | Andrew Yang | 21 | 2345 | 94405 | 0.008955223880597015 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 59 | 59 | 2019-04-14 | Andrew Yang | 39 | 2639 | 95286 | 0.014778325123152709 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 60 | 60 | 2019-04-21 | Andrew Yang | 18 | 5749 | 94002 | 0.0031309793007479572 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 61 | 61 | 2019-04-28 | Andrew Yang | 10 | 3956 | 95339 | 0.0025278058645096056 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 62 | 62 | 2019-05-05 | Andrew Yang | 20 | 2748 | 94528 | 0.00727802037845706 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 63 | 63 | 2019-05-12 | Andrew Yang | 11 | 3694 | 94318 | 0.002977801840822956 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 64 | 64 | 2019-05-19 | Andrew Yang | 13 | 2650 | 94883 | 0.004905660377358491 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 65 | 65 | 2019-05-26 | Andrew Yang | 10 | 3059 | 95289 | 0.0032690421706440013 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 66 | 66 | 2019-06-02 | Andrew Yang | 5 | 3103 | 95313 | 0.0016113438607798904 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 67 | 67 | 2019-06-09 | Andrew Yang | 42 | 4780 | 95839 | 0.008786610878661089 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 68 | 68 | 2019-06-16 | Andrew Yang | 47 | 4485 | 96026 | 0.010479375696767 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 69 | 69 | 2019-06-23 | Andrew Yang | 67 | 7316 | 96553 | 0.009158009841443413 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 70 | 70 | 2019-06-30 | Andrew Yang | 20 | 4384 | 92126 | 0.004562043795620439 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 71 | 71 | 2019-07-07 | Andrew Yang | 18 | 3052 | 94299 | 0.005897771952817824 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 72 | 72 | 2019-07-14 | Andrew Yang | 33 | 3029 | 94481 | 0.010894684714427205 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 73 | 73 | 2019-07-21 | Andrew Yang | 16 | 2574 | 96027 | 0.006216006216006216 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 74 | 74 | 2019-07-28 | Andrew Yang | 155 | 7361 | 95970 | 0.02105692161391116 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 75 | 75 | 2019-08-04 | Andrew Yang | 45 | 3028 | 95881 | 0.014861294583883753 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 76 | 76 | 2019-08-11 | Andrew Yang | 109 | 3288 | 94920 | 0.03315085158150852 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 77 | 77 | 2019-08-18 | Andrew Yang | 48 | 3488 | 94494 | 0.013761467889908258 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 78 | 78 | 2019-08-25 | Andrew Yang | 57 | 3171 | 94380 | 0.017975402081362345 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 79 | 79 | 2019-09-01 | Andrew Yang | 43 | 1829 | 93825 | 0.023510114816839803 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 80 | 80 | 2019-09-08 | Andrew Yang | 150 | 4164 | 94278 | 0.03602305475504323 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 81 | 81 | 2019-09-15 | Andrew Yang | 104 | 4248 | 94504 | 0.024482109227871945 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 82 | 82 | 2019-09-22 | Andrew Yang | 30 | 4582 | 96953 | 0.0065473592317765155 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 83 | 83 | 2019-09-29 | Andrew Yang | 37 | 3986 | 93672 | 0.009282488710486704 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 84 | 84 | 2019-10-06 | Andrew Yang | 14 | 3030 | 94074 | 0.004620462046204621 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 85 | 85 | 2019-10-13 | Andrew Yang | 62 | 4393 | 94893 | 0.014113362167083997 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 86 | 86 | 2019-10-20 | Andrew Yang | 16 | 3100 | 93205 | 0.005161290322580645 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 87 | 87 | 2018-12-30 | Bernie Sanders | 246 | 1279 | 76029 | 0.1923377638780297 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 88 | 88 | 2019-01-06 | Bernie Sanders | 134 | 1031 | 82964 | 0.12997090203685746 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 89 | 89 | 2019-01-13 | Bernie Sanders | 70 | 615 | 82521 | 0.11382113821138212 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 90 | 90 | 2019-01-20 | Bernie Sanders | 147 | 991 | 83649 | 0.14833501513622604 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 91 | 91 | 2019-01-27 | Bernie Sanders | 146 | 1914 | 80994 | 0.07628004179728318 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 92 | 92 | 2019-02-03 | Bernie Sanders | 162 | 1454 | 79183 | 0.11141678129298486 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 93 | 93 | 2019-02-10 | Bernie Sanders | 101 | 1917 | 81893 | 0.05268648930620762 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 94 | 94 | 2019-02-17 | Bernie Sanders | 1039 | 2422 | 82454 | 0.4289843104872007 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 95 | 95 | 2019-02-24 | Bernie Sanders | 664 | 1545 | 82804 | 0.4297734627831715 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 96 | 96 | 2019-03-03 | Bernie Sanders | 521 | 1587 | 81321 | 0.3282923755513548 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 97 | 97 | 2019-03-10 | Bernie Sanders | 451 | 2431 | 85812 | 0.18552036199095026 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 98 | 98 | 2019-03-17 | Bernie Sanders | 467 | 3174 | 95383 | 0.1471329552614997 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 99 | 99 | 2019-03-24 | Bernie Sanders | 142 | 1248 | 96184 | 0.11378205128205128 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
| 100 | 100 | 2019-03-31 | Bernie Sanders | 551 | 4205 | 93472 | 0.1310344827586207 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
JSON shape: default, array, newline-delimited
CREATE TABLE "media-mentions-2020/cable_weekly" ( "date" TEXT, "name" TEXT, "matched_clips" INTEGER, "all_candidate_clips" INTEGER, "total_clips" INTEGER, "pct_of_all_candidate_clips" REAL, "query" TEXT );