{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Exploring data for the attention index\n", "\n", "The idea of the attention index is to provide a score that indicates the impact of an article, and can easily be aggregated by subject, publisher or other axis.\n", "\n", "The index comprises of two parts:\n", "\n", "- **promotion** how important the article was to the publisher, based on the extent to which they chose to editorially promote it\n", "- **response** how readers reacted to the article, based on social engagements\n", "\n", "The index will be a number between 0 and 100. 50% is driven by the promotion, and 50% by response:\n", "\n", "![Attention Index](../images/kaleida-attention-index-data-factors-chart.png)\n", "\n", "### Promotion Score\n", "\n", "The promotion score should take into account:\n", "\n", "- whether the publisher chose make the article a lead article on their primary front (30%)\n", "- how long the publisher chose to retain the article on their front (40%)\n", "- whether they chose to push the article on their facebook brand page (30%)\n", "\n", "It should be scaled based on the value of that promotion, so a popular, well-visited site should score higher than one on the fringes. And similarly a powerful, well-followed brand page should score higher than one less followed.\n", "\n", "### Response Score\n", "\n", "The response score takes into account the number of engagements on Facebook. \n", "\n", "\n", "\n", "The rest of this notebook explores how those numbers could work, starting with the response score because that is easier, I think." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Setup" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true, "scrolled": true }, "outputs": [], "source": [ "%matplotlib inline\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "import seaborn as sns\n", "import numpy as np" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/html": [ "
\n", " | url | \n", "headline | \n", "discovered | \n", "published | \n", "fb_engagements | \n", "fb_max_engagements_per_min | \n", "fb_comments | \n", "fb_reactions | \n", "fb_shares | \n", "publisher_name | \n", "publisher_id | \n", "mins_as_lead | \n", "mins_on_front | \n", "num_articles_on_front | \n", "fb_brand_page | \n", "fb_brand_page_likes | \n", "alexa_rank | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
0d2c10289ac562afa42b458bf238defd5b7d86d8 | \n", "https://www.nytimes.com/2017/04/30/nyregion/me... | \n", "April Fools’ With the Epitome of Cool | \n", "2017-05-01 00:05:00.022 | \n", "2017-05-01 00:00:00 | \n", "5 | \n", "0.083449 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "New York Times | \n", "nytimes_com | \n", "0 | \n", "0 | \n", "NaN | \n", "False | \n", "NaN | \n", "120 | \n", "
0d35eb2f3c53ad8218866a0927082b0a2a53576d | \n", "http://www.dailymail.co.uk/news/article-446135... | \n", "Young mother loses three teeth and is left nee... | \n", "2017-05-01 00:05:23.416 | \n", "2017-05-01 00:00:21 | \n", "8 | \n", "0.083449 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "Daily Mail | \n", "dailymail_co_uk | \n", "0 | \n", "584 | \n", "603.0 | \n", "False | \n", "NaN | \n", "158 | \n", "
20a659b9ee677b718b5834566795b6e231541a9b | \n", "http://www.dailymail.co.uk/tvshowbiz/article-4... | \n", "Holly Hagan slams 'jealous' trolls in angry Tw... | \n", "2017-05-01 00:05:19.176 | \n", "2017-05-01 00:00:32 | \n", "1 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "Daily Mail | \n", "dailymail_co_uk | \n", "0 | \n", "2352 | \n", "603.0 | \n", "False | \n", "NaN | \n", "158 | \n", "
7572bc3039f8f0ad83fea23d2692d5bd8a4cadd9 | \n", "http://www.dailymail.co.uk/news/article-446135... | \n", "Primary school headteachers could strike over ... | \n", "2017-05-01 00:05:19.083 | \n", "2017-05-01 00:00:32 | \n", "10 | \n", "0.083449 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "Daily Mail | \n", "dailymail_co_uk | \n", "0 | \n", "1012 | \n", "603.0 | \n", "False | \n", "NaN | \n", "158 | \n", "
a8e2c63260f908b2f091862fff1b884da0eb5fe9 | \n", "http://www.dailymail.co.uk/news/article-446138... | \n", "Man films student driver who 'fled from hit an... | \n", "2017-05-01 00:05:22.695 | \n", "2017-05-01 00:00:48 | \n", "12 | \n", "0.083449 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "Daily Mail | \n", "dailymail_co_uk | \n", "0 | \n", "0 | \n", "NaN | \n", "False | \n", "NaN | \n", "158 | \n", "
\n", " | url | \n", "headline | \n", "discovered | \n", "published | \n", "fb_engagements | \n", "fb_max_engagements_per_min | \n", "fb_comments | \n", "fb_reactions | \n", "fb_shares | \n", "publisher_name | \n", "publisher_id | \n", "mins_as_lead | \n", "mins_on_front | \n", "num_articles_on_front | \n", "fb_brand_page | \n", "fb_brand_page_likes | \n", "alexa_rank | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
c55509930e92f71ee534edf7d570b70ed81a2267 | \n", "https://www.indy100.com/article/divorced-fathe... | \n", "This dad's brilliant post about his ex-wife is... | \n", "2017-05-15 11:09:18.339 | \n", "2017-05-14 08:36:41 | \n", "1114468 | \n", "8.34 | \n", "58501.00 | \n", "914126.00 | \n", "141841.00 | \n", "indy100 | \n", "indy100_com | \n", "0 | \n", "9937 | \n", "100.00 | \n", "False | \n", "nan | \n", "5014 | \n", "
\n", " | size | \n", "amin | \n", "amax | \n", "
---|---|---|---|
response_score | \n", "\n", " | \n", " | \n", " |
0.00 | \n", "26315 | \n", "0 | \n", "1 | \n", "
1.00 | \n", "14791 | \n", "2 | \n", "6 | \n", "
2.00 | \n", "9188 | \n", "7 | \n", "13 | \n", "
3.00 | \n", "6501 | \n", "14 | \n", "21 | \n", "
4.00 | \n", "5544 | \n", "22 | \n", "31 | \n", "
5.00 | \n", "4380 | \n", "32 | \n", "42 | \n", "
6.00 | \n", "3603 | \n", "43 | \n", "54 | \n", "
7.00 | \n", "3591 | \n", "55 | \n", "69 | \n", "
8.00 | \n", "3145 | \n", "70 | \n", "86 | \n", "
9.00 | \n", "2944 | \n", "87 | \n", "106 | \n", "
10.00 | \n", "2740 | \n", "107 | \n", "129 | \n", "
11.00 | \n", "2533 | \n", "130 | \n", "155 | \n", "
12.00 | \n", "2364 | \n", "156 | \n", "186 | \n", "
13.00 | \n", "2383 | \n", "187 | \n", "222 | \n", "
14.00 | \n", "2338 | \n", "223 | \n", "264 | \n", "
15.00 | \n", "2108 | \n", "265 | \n", "312 | \n", "
16.00 | \n", "2145 | \n", "313 | \n", "368 | \n", "
17.00 | \n", "2010 | \n", "369 | \n", "433 | \n", "
18.00 | \n", "1904 | \n", "434 | \n", "509 | \n", "
19.00 | \n", "1966 | \n", "510 | \n", "597 | \n", "
20.00 | \n", "1794 | \n", "598 | \n", "699 | \n", "
21.00 | \n", "1751 | \n", "700 | \n", "818 | \n", "
22.00 | \n", "1664 | \n", "819 | \n", "956 | \n", "
23.00 | \n", "1549 | \n", "957 | \n", "1116 | \n", "
24.00 | \n", "1554 | \n", "1117 | \n", "1302 | \n", "
25.00 | \n", "1523 | \n", "1303 | \n", "1518 | \n", "
26.00 | \n", "1325 | \n", "1519 | \n", "1768 | \n", "
27.00 | \n", "1276 | \n", "1769 | \n", "2060 | \n", "
28.00 | \n", "1265 | \n", "2061 | \n", "2398 | \n", "
29.00 | \n", "1168 | \n", "2399 | \n", "2790 | \n", "
30.00 | \n", "1148 | \n", "2791 | \n", "3246 | \n", "
31.00 | \n", "1057 | \n", "3247 | \n", "3775 | \n", "
32.00 | \n", "972 | \n", "3777 | \n", "4390 | \n", "
33.00 | \n", "934 | \n", "4394 | \n", "5101 | \n", "
34.00 | \n", "873 | \n", "5108 | \n", "5932 | \n", "
35.00 | \n", "815 | \n", "5934 | \n", "6896 | \n", "
36.00 | \n", "761 | \n", "6897 | \n", "8014 | \n", "
37.00 | \n", "609 | \n", "8016 | \n", "9308 | \n", "
38.00 | \n", "618 | \n", "9314 | \n", "10818 | \n", "
39.00 | \n", "540 | \n", "10823 | \n", "12568 | \n", "
40.00 | \n", "498 | \n", "12571 | \n", "14604 | \n", "
41.00 | \n", "401 | \n", "14609 | \n", "16943 | \n", "
42.00 | \n", "385 | \n", "16989 | \n", "19704 | \n", "
43.00 | \n", "311 | \n", "19707 | \n", "22862 | \n", "
44.00 | \n", "276 | \n", "22916 | \n", "26583 | \n", "
45.00 | \n", "224 | \n", "26596 | \n", "30879 | \n", "
46.00 | \n", "188 | \n", "31006 | \n", "35813 | \n", "
47.00 | \n", "149 | \n", "35889 | \n", "41618 | \n", "
48.00 | \n", "115 | \n", "41659 | \n", "48277 | \n", "
49.00 | \n", "93 | \n", "48524 | \n", "55987 | \n", "
50.00 | \n", "202 | \n", "56212 | \n", "1114468 | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
publisher_id | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
anotherangryvoice_blogspot_co_uk | \n", "33.00 | \n", "5.19 | \n", "0.57 | \n", "2.57 | \n", "5.33 | \n", "5.33 | \n", "5.33 | \n", "5.33 | \n", "
bbc_co_uk | \n", "96.00 | \n", "12.68 | \n", "1.96 | \n", "0.88 | \n", "13.15 | \n", "13.15 | \n", "13.15 | \n", "13.15 | \n", "
breitbart_com | \n", "206.00 | \n", "8.55 | \n", "0.86 | \n", "2.03 | \n", "8.69 | \n", "8.69 | \n", "8.69 | \n", "8.69 | \n", "
brexitcentral_com | \n", "27.00 | \n", "4.43 | \n", "0.64 | \n", "1.45 | \n", "4.59 | \n", "4.59 | \n", "4.59 | \n", "4.59 | \n", "
buzzfeed_com | \n", "105.00 | \n", "11.86 | \n", "1.12 | \n", "1.80 | \n", "12.02 | \n", "12.02 | \n", "12.02 | \n", "12.02 | \n", "
cnn_com | \n", "181.00 | \n", "12.53 | \n", "1.44 | \n", "4.08 | \n", "12.89 | \n", "12.89 | \n", "12.89 | \n", "12.89 | \n", "
dailymail_co_uk | \n", "159.00 | \n", "11.46 | \n", "1.42 | \n", "3.75 | \n", "11.85 | \n", "11.85 | \n", "11.85 | \n", "11.85 | \n", "
economist_com | \n", "44.00 | \n", "7.55 | \n", "1.68 | \n", "0.67 | \n", "7.99 | \n", "7.99 | \n", "7.99 | \n", "7.99 | \n", "
evolvepolitics_com | \n", "26.00 | \n", "5.02 | \n", "0.59 | \n", "2.14 | \n", "5.13 | \n", "5.13 | \n", "5.13 | \n", "5.13 | \n", "
foxnews_com | \n", "214.00 | \n", "10.54 | \n", "0.50 | \n", "5.66 | \n", "10.61 | \n", "10.61 | \n", "10.61 | \n", "10.61 | \n", "
ft_com | \n", "76.00 | \n", "7.75 | \n", "1.54 | \n", "0.54 | \n", "8.14 | \n", "8.14 | \n", "8.14 | \n", "8.14 | \n", "
huffingtonpost_com | \n", "166.00 | \n", "10.72 | \n", "1.81 | \n", "0.56 | \n", "11.17 | \n", "11.17 | \n", "11.17 | \n", "11.17 | \n", "
independent_co_uk | \n", "160.00 | \n", "9.40 | \n", "1.93 | \n", "0.50 | \n", "10.07 | \n", "10.07 | \n", "10.07 | \n", "10.07 | \n", "
indy100_com | \n", "109.00 | \n", "5.65 | \n", "1.96 | \n", "1.06 | \n", "4.11 | \n", "7.04 | \n", "7.04 | \n", "7.04 | \n", "
libdemvoice_org | \n", "10.00 | \n", "4.58 | \n", "0.37 | \n", "3.53 | \n", "4.71 | \n", "4.71 | \n", "4.71 | \n", "4.71 | \n", "
nbcnews_com | \n", "111.00 | \n", "8.79 | \n", "1.07 | \n", "0.60 | \n", "8.93 | \n", "8.93 | \n", "8.93 | \n", "8.93 | \n", "
npr_org | \n", "164.00 | \n", "8.84 | \n", "1.82 | \n", "0.47 | \n", "9.39 | \n", "9.39 | \n", "9.39 | \n", "9.39 | \n", "
nytimes_com | \n", "67.00 | \n", "12.10 | \n", "2.02 | \n", "1.46 | \n", "12.53 | \n", "12.53 | \n", "12.53 | \n", "12.53 | \n", "
order-order_com | \n", "178.00 | \n", "4.13 | \n", "1.73 | \n", "0.39 | \n", "2.41 | \n", "4.72 | \n", "5.78 | \n", "5.78 | \n", "
propublica_org | \n", "24.00 | \n", "6.20 | \n", "0.00 | \n", "6.20 | \n", "6.20 | \n", "6.20 | \n", "6.20 | \n", "6.20 | \n", "
reuters_com | \n", "78.00 | \n", "9.23 | \n", "1.52 | \n", "0.48 | \n", "9.66 | \n", "9.66 | \n", "9.66 | \n", "9.66 | \n", "
rt_com | \n", "78.00 | \n", "9.71 | \n", "1.61 | \n", "0.85 | \n", "10.17 | \n", "10.17 | \n", "10.17 | \n", "10.17 | \n", "
skwawkbox_org | \n", "5.00 | \n", "3.77 | \n", "1.78 | \n", "1.26 | \n", "2.51 | \n", "5.03 | \n", "5.03 | \n", "5.03 | \n", "
telegraph_co_uk | \n", "98.00 | \n", "9.55 | \n", "1.94 | \n", "0.85 | \n", "10.15 | \n", "10.15 | \n", "10.15 | \n", "10.15 | \n", "
thecanary_co | \n", "205.00 | \n", "4.92 | \n", "1.76 | \n", "0.93 | \n", "3.52 | \n", "6.11 | \n", "6.21 | \n", "6.21 | \n", "
theguardian_com | \n", "132.00 | \n", "11.35 | \n", "2.33 | \n", "0.61 | \n", "12.11 | \n", "12.11 | \n", "12.11 | \n", "12.11 | \n", "
thetimes_co_uk | \n", "74.00 | \n", "6.60 | \n", "0.90 | \n", "1.71 | \n", "6.84 | \n", "6.84 | \n", "6.84 | \n", "6.84 | \n", "
washingtonpost_com | \n", "83.00 | \n", "11.01 | \n", "2.02 | \n", "0.57 | \n", "11.42 | \n", "11.42 | \n", "11.42 | \n", "11.42 | \n", "
westmonster_com | \n", "43.00 | \n", "4.96 | \n", "1.01 | \n", "0.78 | \n", "5.22 | \n", "5.22 | \n", "5.22 | \n", "5.22 | \n", "
yournewswire_com | \n", "169.00 | \n", "3.45 | \n", "2.29 | \n", "0.40 | \n", "1.00 | \n", "3.39 | \n", "5.99 | \n", "5.99 | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
publisher_id | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
anotherangryvoice_blogspot_co_uk | \n", "60.00 | \n", "0.45 | \n", "0.50 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "
bbc_co_uk | \n", "3682.00 | \n", "2.16 | \n", "5.27 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "15.00 | \n", "
breitbart_com | \n", "2722.00 | \n", "0.62 | \n", "0.93 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "2.00 | \n", "2.00 | \n", "
brexitcentral_com | \n", "47.00 | \n", "0.60 | \n", "0.50 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
buzzfeed_com | \n", "1962.00 | \n", "0.28 | \n", "0.45 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "
cnn_com | \n", "3923.00 | \n", "2.45 | \n", "4.30 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "10.00 | \n", "
dailymail_co_uk | \n", "25993.00 | \n", "0.46 | \n", "1.33 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "5.00 | \n", "
economist_com | \n", "576.00 | \n", "2.02 | \n", "1.41 | \n", "0.00 | \n", "0.00 | \n", "3.00 | \n", "3.00 | \n", "3.00 | \n", "
evolvepolitics_com | \n", "54.00 | \n", "0.72 | \n", "0.45 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
foxnews_com | \n", "6776.00 | \n", "0.58 | \n", "1.77 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "6.00 | \n", "
ft_com | \n", "3526.00 | \n", "0.59 | \n", "0.91 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "2.00 | \n", "2.00 | \n", "
huffingtonpost_com | \n", "4758.00 | \n", "1.10 | \n", "1.78 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "4.00 | \n", "4.00 | \n", "
independent_co_uk | \n", "6672.00 | \n", "0.59 | \n", "1.19 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "3.00 | \n", "
indy100_com | \n", "424.00 | \n", "0.14 | \n", "0.35 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "
libdemvoice_org | \n", "181.00 | \n", "0.56 | \n", "0.50 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
nbcnews_com | \n", "2253.00 | \n", "2.01 | \n", "2.00 | \n", "0.00 | \n", "0.00 | \n", "4.00 | \n", "4.00 | \n", "4.00 | \n", "
npr_org | \n", "2086.00 | \n", "1.42 | \n", "1.50 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "3.00 | \n", "3.00 | \n", "
nytimes_com | \n", "5434.00 | \n", "1.41 | \n", "2.39 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "5.00 | \n", "6.00 | \n", "
order-order_com | \n", "339.00 | \n", "0.47 | \n", "0.50 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "
propublica_org | \n", "42.00 | \n", "0.90 | \n", "0.30 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
reuters_com | \n", "5760.00 | \n", "0.34 | \n", "0.75 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "2.00 | \n", "
rt_com | \n", "2407.00 | \n", "0.51 | \n", "0.87 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "2.00 | \n", "2.00 | \n", "
skwawkbox_org | \n", "158.00 | \n", "0.70 | \n", "0.46 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
telegraph_co_uk | \n", "7886.00 | \n", "0.50 | \n", "0.86 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "2.00 | \n", "
thecanary_co | \n", "328.00 | \n", "0.87 | \n", "0.34 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
theguardian_com | \n", "9008.00 | \n", "0.52 | \n", "1.14 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "3.00 | \n", "
thetimes_co_uk | \n", "8681.00 | \n", "0.06 | \n", "0.24 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "
washingtonpost_com | \n", "22174.00 | \n", "0.19 | \n", "0.73 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "3.00 | \n", "
westmonster_com | \n", "249.00 | \n", "0.24 | \n", "0.43 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "
yournewswire_com | \n", "370.00 | \n", "0.04 | \n", "0.20 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "
\n", " | url | \n", "headline | \n", "discovered | \n", "published | \n", "fb_engagements | \n", "fb_max_engagements_per_min | \n", "fb_comments | \n", "fb_reactions | \n", "fb_shares | \n", "publisher_name | \n", "... | \n", "num_articles_on_front | \n", "fb_brand_page | \n", "fb_brand_page_likes | \n", "alexa_rank | \n", "response_score | \n", "lead_score | \n", "front_score | \n", "facebook_promotion_score | \n", "promotion_score | \n", "attention_index | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
2b068c2fa3bdb2732465fe524b599b97ba981fa2 | \n", "https://www.buzzfeed.com/juliareinstein/these-... | \n", "These Are The Victims Of The Portland Train St... | \n", "2017-05-27 21:48:12.860 | \n", "2017-05-27 21:31:28.000 | \n", "67262 | \n", "47.40 | \n", "7535.00 | \n", "52484.00 | \n", "7243.00 | \n", "Buzzfeed News | \n", "... | \n", "25.00 | \n", "True | \n", "2522745.00 | \n", "147 | \n", "50.00 | \n", "19.00 | \n", "15.00 | \n", "12.00 | \n", "46.00 | \n", "96.00 | \n", "
14b0e444e8db057a9aa6df60b8172cf700f280c5 | \n", "http://money.cnn.com/2017/05/02/news/economy/o... | \n", "The House just passed a bill that affects over... | \n", "2017-05-03 01:28:04.624 | \n", "2017-05-03 00:11:11.000 | \n", "85276 | \n", "258.69 | \n", "nan | \n", "nan | \n", "nan | \n", "CNN | \n", "... | \n", "62.00 | \n", "True | \n", "27386540.00 | \n", "105 | \n", "50.00 | \n", "20.00 | \n", "9.00 | \n", "15.00 | \n", "44.00 | \n", "94.00 | \n", "
fab8d9250617795d93b7383e0e1cf86352338181 | \n", "http://www.bbc.co.uk/news/live/world-europe-39... | \n", "French election: Macron and Le Pen in crucial ... | \n", "2017-05-07 14:24:01.542 | \n", "2017-05-07 14:17:24.671 | \n", "28022 | \n", "43.08 | \n", "nan | \n", "nan | \n", "nan | \n", "BBC | \n", "... | \n", "47.00 | \n", "True | \n", "41287024.00 | \n", "96 | \n", "45.00 | \n", "20.00 | \n", "12.00 | \n", "15.00 | \n", "47.00 | \n", "92.00 | \n", "
42294296116b94aff50a439a4fca04dd396aac0c | \n", "https://www.buzzfeed.com/salvadorhernandez/hey... | \n", "Hey Guys, What Do You Think About A Dwayne Joh... | \n", "2017-05-21 04:48:18.390 | \n", "2017-05-21 04:03:49.000 | \n", "32996 | \n", "77.86 | \n", "2486.00 | \n", "28269.00 | \n", "2241.00 | \n", "Buzzfeed News | \n", "... | \n", "25.00 | \n", "True | \n", "2505771.00 | \n", "147 | \n", "46.00 | \n", "19.00 | \n", "15.00 | \n", "12.00 | \n", "46.00 | \n", "92.00 | \n", "
f1ba80ccf9b7979418c5326503bc897b98eafd92 | \n", "http://www.bbc.co.uk/news/world-europe-39839349 | \n", "French election: Macron 'defeats Le Pen to bec... | \n", "2017-05-07 18:12:02.316 | \n", "2017-05-07 18:07:12.000 | \n", "64768 | \n", "68.76 | \n", "nan | \n", "nan | \n", "nan | \n", "BBC | \n", "... | \n", "47.00 | \n", "True | \n", "41277414.00 | \n", "96 | \n", "50.00 | \n", "20.00 | \n", "7.00 | \n", "15.00 | \n", "42.00 | \n", "92.00 | \n", "
8cb28169a5402b65b3cd89f1a0b0ce3f4ee70156 | \n", "https://www.buzzfeed.com/emaoconnor/students-w... | \n", "Students Walked Out Of Notre Dame's Graduation... | \n", "2017-05-21 18:27:14.894 | \n", "2017-05-21 18:26:18.000 | \n", "31643 | \n", "61.50 | \n", "2826.00 | \n", "27299.00 | \n", "1518.00 | \n", "Buzzfeed News | \n", "... | \n", "25.00 | \n", "True | \n", "2506360.00 | \n", "147 | \n", "46.00 | \n", "19.00 | \n", "15.00 | \n", "12.00 | \n", "46.00 | \n", "92.00 | \n", "
7f10cd0e6c28956ab1fdc0ca572b45fcfeaa8788 | \n", "https://www.buzzfeed.com/laurasilver/these-are... | \n", "These Are The Victims Of The Manchester Terror... | \n", "2017-05-23 13:00:16.480 | \n", "2017-05-23 12:57:53.000 | \n", "27291 | \n", "23.27 | \n", "1368.00 | \n", "21764.00 | \n", "4159.00 | \n", "Buzzfeed News | \n", "... | \n", "25.00 | \n", "True | \n", "2511571.00 | \n", "147 | \n", "45.00 | \n", "19.00 | \n", "15.00 | \n", "12.00 | \n", "46.00 | \n", "91.00 | \n", "
5d0e52fea29802318a75911f3371624df4595ae4 | \n", "http://www.cnn.com/2017/05/24/politics/jeff-se... | \n", "First on CNN: AG Sessions did not disclose mee... | \n", "2017-05-24 22:05:16.913 | \n", "2017-05-24 22:00:15.000 | \n", "49692 | \n", "51.92 | \n", "9803.00 | \n", "34058.00 | \n", "5831.00 | \n", "CNN | \n", "... | \n", "62.00 | \n", "True | \n", "27444874.00 | \n", "105 | \n", "49.00 | \n", "20.00 | \n", "7.00 | \n", "15.00 | \n", "42.00 | \n", "91.00 | \n", "
b09f91cf0b955b39e0e58b4ce530cd0942e4a92f | \n", "http://www.bbc.co.uk/news/entertainment-arts-4... | \n", "Blue Peter presenter John Noakes dies | \n", "2017-05-29 09:55:02.826 | \n", "2017-05-29 09:49:34.000 | \n", "45987 | \n", "49.74 | \n", "6860.00 | \n", "35256.00 | \n", "3871.00 | \n", "BBC | \n", "... | \n", "47.00 | \n", "True | \n", "41787920.00 | \n", "96 | \n", "48.00 | \n", "20.00 | \n", "7.00 | \n", "15.00 | \n", "42.00 | \n", "90.00 | \n", "
2f34e56453c871882bb30b655e234d8aba32dfdc | \n", "http://www.huffingtonpost.com/entry/portland-s... | \n", "The Portland Heroes Who Stood Up To Hate | \n", "2017-05-28 22:27:10.745 | \n", "2017-05-28 08:11:53.000 | \n", "57925 | \n", "43.39 | \n", "2182.00 | \n", "50049.00 | \n", "5694.00 | \n", "HuffPost | \n", "... | \n", "26.00 | \n", "True | \n", "9485928.00 | \n", "215 | \n", "50.00 | \n", "17.00 | \n", "10.00 | \n", "13.00 | \n", "40.00 | \n", "90.00 | \n", "
4accbfb7fefcf1eb39df7fac49bd18bc4527f539 | \n", "http://www.cnn.com/2017/05/01/politics/investi... | \n", "The FBI translator who went rogue and married ... | \n", "2017-05-01 19:47:57.988 | \n", "2017-05-01 19:39:14.000 | \n", "32070 | \n", "36.45 | \n", "nan | \n", "nan | \n", "nan | \n", "CNN | \n", "... | \n", "62.00 | \n", "True | \n", "27377584.00 | \n", "105 | \n", "46.00 | \n", "20.00 | \n", "9.00 | \n", "15.00 | \n", "44.00 | \n", "90.00 | \n", "
afeaaba2df87ace5da55c7e5aad38d7aca9546f8 | \n", "http://www.cnn.com/interactive/2017/05/politic... | \n", "Sheriff David Clarke plagiarized portions of h... | \n", "2017-05-20 23:45:04.481 | \n", "2017-05-20 23:36:34.000 | \n", "36361 | \n", "56.08 | \n", "13115.00 | \n", "18114.00 | \n", "5132.00 | \n", "CNN | \n", "... | \n", "62.00 | \n", "True | \n", "27393308.00 | \n", "105 | \n", "47.00 | \n", "20.00 | \n", "8.00 | \n", "15.00 | \n", "43.00 | \n", "90.00 | \n", "
09a3a8400c4395f2e18ba818b42912357e8e58ae | \n", "http://www.bbc.co.uk/news/election-2017-40053427 | \n", "General election 2017: Corbyn links terror thr... | \n", "2017-05-25 21:10:03.897 | \n", "2017-05-25 21:03:46.000 | \n", "28189 | \n", "34.00 | \n", "11358.00 | \n", "14371.00 | \n", "2460.00 | \n", "BBC | \n", "... | \n", "47.00 | \n", "True | \n", "41702575.00 | \n", "96 | \n", "45.00 | \n", "20.00 | \n", "10.00 | \n", "15.00 | \n", "45.00 | \n", "90.00 | \n", "
7638bc116fc4499d08b4070e417ad266fb3e23e9 | \n", "http://www.cnn.com/2017/05/09/politics/james-c... | \n", "FBI director James Comey fired | \n", "2017-05-09 21:55:19.328 | \n", "2017-05-09 21:53:47.000 | \n", "39822 | \n", "48.57 | \n", "nan | \n", "nan | \n", "nan | \n", "CNN | \n", "... | \n", "62.00 | \n", "True | \n", "27317096.00 | \n", "105 | \n", "47.00 | \n", "20.00 | \n", "7.00 | \n", "15.00 | \n", "42.00 | \n", "89.00 | \n", "
c8c4364097e3139baf5b82eda04df00d350e8343 | \n", "http://www.cnn.com/2017/05/26/us/portland-trai... | \n", "Man shouting anti-Muslim slurs kills 2 on Port... | \n", "2017-05-27 03:27:15.372 | \n", "2017-05-27 03:23:54.000 | \n", "27952 | \n", "24.50 | \n", "7626.00 | \n", "16105.00 | \n", "4221.00 | \n", "CNN | \n", "... | \n", "62.00 | \n", "True | \n", "27475760.00 | \n", "105 | \n", "45.00 | \n", "20.00 | \n", "9.00 | \n", "15.00 | \n", "44.00 | \n", "89.00 | \n", "
ddcf39b5f71753ab726057de7647b1922cb10d32 | \n", "http://www.bbc.co.uk/news/entertainment-arts-4... | \n", "Manchester attacks: Stars to join Ariana Grand... | \n", "2017-05-30 15:20:02.705 | \n", "2017-05-30 15:16:43.000 | \n", "41965 | \n", "37.72 | \n", "3029.00 | \n", "35012.00 | \n", "3924.00 | \n", "BBC | \n", "... | \n", "47.00 | \n", "True | \n", "41807079.00 | \n", "96 | \n", "48.00 | \n", "20.00 | \n", "6.00 | \n", "15.00 | \n", "41.00 | \n", "89.00 | \n", "
8d86ba1ca7e4dda9f0c9f4eafbf7108c6a332c81 | \n", "http://www.bbc.co.uk/news/uk-39802636 | \n", "Duke of Edinburgh to retire from royal duties | \n", "2017-05-04 09:08:01.799 | \n", "2017-05-04 09:06:23.000 | \n", "23879 | \n", "31.17 | \n", "nan | \n", "nan | \n", "nan | \n", "BBC | \n", "... | \n", "47.00 | \n", "True | \n", "41300131.00 | \n", "96 | \n", "44.00 | \n", "20.00 | \n", "10.00 | \n", "15.00 | \n", "45.00 | \n", "89.00 | \n", "
f52875ade537d88acc4d0070faa6f66107b28f6f | \n", "http://www.bbc.co.uk/news/election-2017-40105324 | \n", "Jeremy Corbyn to take part in seven-way TV debate | \n", "2017-05-31 11:30:11.567 | \n", "2017-05-31 11:24:24.000 | \n", "16409 | \n", "34.05 | \n", "4954.00 | \n", "9252.00 | \n", "2203.00 | \n", "BBC | \n", "... | \n", "45.00 | \n", "True | \n", "41822932.00 | \n", "96 | \n", "41.00 | \n", "20.00 | \n", "13.00 | \n", "15.00 | \n", "48.00 | \n", "89.00 | \n", "
2b382725ca5dc2e921e92f060dbb8920b9dc1fb1 | \n", "https://www.buzzfeed.com/claudiakoerner/jeremy... | \n", "The White Supremacist Accused Of The Portland ... | \n", "2017-05-30 22:30:14.879 | \n", "2017-05-30 22:29:38.000 | \n", "19853 | \n", "59.50 | \n", "4263.00 | \n", "13851.00 | \n", "1739.00 | \n", "Buzzfeed News | \n", "... | \n", "25.00 | \n", "True | \n", "2525437.00 | \n", "147 | \n", "43.00 | \n", "19.00 | \n", "15.00 | \n", "12.00 | \n", "46.00 | \n", "89.00 | \n", "
2c19bf826aa073d0675b97f04b199cdf8de521f2 | \n", "http://www.cnn.com/2017/05/15/politics/trump-r... | \n", "Washington Post: Trump leaked classified info ... | \n", "2017-05-15 22:15:13.349 | \n", "2017-05-15 22:10:37.000 | \n", "39566 | \n", "47.98 | \n", "19346.00 | \n", "15974.00 | \n", "4246.00 | \n", "CNN | \n", "... | \n", "62.00 | \n", "True | \n", "27352796.00 | \n", "105 | \n", "47.00 | \n", "20.00 | \n", "7.00 | \n", "15.00 | \n", "42.00 | \n", "89.00 | \n", "
332d434b07b350510549833225fe392117243c0c | \n", "http://www.cnn.com/2017/05/04/politics/health-... | \n", "Countdown is on to nail-biter Obamacare repeal... | \n", "2017-05-04 10:05:24.746 | \n", "2017-05-04 10:00:18.000 | \n", "27425 | \n", "39.17 | \n", "nan | \n", "nan | \n", "nan | \n", "CNN | \n", "... | \n", "62.00 | \n", "True | \n", "27396532.00 | \n", "105 | \n", "45.00 | \n", "20.00 | \n", "9.00 | \n", "15.00 | \n", "44.00 | \n", "89.00 | \n", "
15ca9ed39bb09eba36bf9b04989d120fdf2bf5c1 | \n", "https://www.nytimes.com/2017/05/12/us/politics... | \n", "Trump Threatens Retaliation Against Comey, War... | \n", "2017-05-12 13:05:04.079 | \n", "2017-05-12 13:03:08.000 | \n", "63535 | \n", "62.00 | \n", "16657.00 | \n", "39053.00 | \n", "7825.00 | \n", "New York Times | \n", "... | \n", "121.00 | \n", "True | \n", "13902139.00 | \n", "120 | \n", "50.00 | \n", "20.00 | \n", "4.00 | \n", "14.00 | \n", "38.00 | \n", "88.00 | \n", "
a6512f6b09240bd0ad24afe567bc301979abceca | \n", "http://www.bbc.co.uk/news/election-2017-39956541 | \n", "Conservative manifesto: Firms to pay more to h... | \n", "2017-05-17 21:15:08.119 | \n", "2017-05-17 21:14:28.000 | \n", "15755 | \n", "14.98 | \n", "6394.00 | \n", "7365.00 | \n", "1996.00 | \n", "BBC | \n", "... | \n", "47.00 | \n", "True | \n", "41465378.00 | \n", "96 | \n", "41.00 | \n", "20.00 | \n", "12.00 | \n", "15.00 | \n", "47.00 | \n", "88.00 | \n", "
e96d445a030fc2b1cbb0b318c131d96430a1c8e9 | \n", "https://www.nytimes.com/2017/05/17/us/politics... | \n", "Robert Mueller, Former F.B.I. Director, Named ... | \n", "2017-05-17 22:03:00.403 | \n", "2017-05-17 22:01:08.000 | \n", "71918 | \n", "76.27 | \n", "13759.00 | \n", "54141.00 | \n", "4018.00 | \n", "New York Times | \n", "... | \n", "121.00 | \n", "True | \n", "13931550.00 | \n", "120 | \n", "50.00 | \n", "20.00 | \n", "4.00 | \n", "14.00 | \n", "38.00 | \n", "88.00 | \n", "
ee25e1faebe21977e7e24f0ac56354e41e9f1246 | \n", "http://www.huffingtonpost.com/entry/portland-a... | \n", "2 Men Killed On Portland Train After Trying To... | \n", "2017-05-27 08:35:05.764 | \n", "2017-05-27 08:27:31.000 | \n", "42112 | \n", "54.08 | \n", "9485.00 | \n", "28201.00 | \n", "4426.00 | \n", "HuffPost | \n", "... | \n", "26.00 | \n", "True | \n", "9478319.00 | \n", "215 | \n", "48.00 | \n", "17.00 | \n", "10.00 | \n", "13.00 | \n", "40.00 | \n", "88.00 | \n", "
f8830bbc4e15dab7593e0751b9851c048c575257 | \n", "https://www.nytimes.com/2017/05/16/us/politics... | \n", "Comey Memo Says Trump Asked Him to End Flynn I... | \n", "2017-05-16 21:24:00.845 | \n", "2017-05-16 21:22:12.000 | \n", "83951 | \n", "49.67 | \n", "30914.00 | \n", "46208.00 | \n", "6829.00 | \n", "New York Times | \n", "... | \n", "121.00 | \n", "True | \n", "13926019.00 | \n", "120 | \n", "50.00 | \n", "20.00 | \n", "4.00 | \n", "14.00 | \n", "38.00 | \n", "88.00 | \n", "
83fe5a6430080e734127806ddea0514ed9975292 | \n", "http://www.cnn.com/2017/05/01/politics/trump-m... | \n", "Trump ending Michelle Obama's girls education ... | \n", "2017-05-01 17:15:20.675 | \n", "2017-05-01 17:11:32.000 | \n", "73117 | \n", "76.36 | \n", "nan | \n", "nan | \n", "nan | \n", "CNN | \n", "... | \n", "62.00 | \n", "True | \n", "27376924.00 | \n", "105 | \n", "50.00 | \n", "20.00 | \n", "3.00 | \n", "15.00 | \n", "38.00 | \n", "88.00 | \n", "
deb51f871b757906c47f036142fb61cf6fe10a58 | \n", "http://www.cnn.com/2017/05/12/politics/michell... | \n", "Michelle Obama slams Trump on school meals | \n", "2017-05-12 22:25:18.698 | \n", "2017-05-12 22:19:54.000 | \n", "26300 | \n", "46.17 | \n", "4436.00 | \n", "18902.00 | \n", "2962.00 | \n", "CNN | \n", "... | \n", "62.00 | \n", "True | \n", "27341319.00 | \n", "105 | \n", "44.00 | \n", "20.00 | \n", "9.00 | \n", "15.00 | \n", "44.00 | \n", "88.00 | \n", "
7cb9f49a9bd8be5a0c54a8fac7c5c829eaaa3255 | \n", "https://www.nytimes.com/2017/05/19/us/politics... | \n", "Trump Told Russians That Firing ‘Nut Job’ Come... | \n", "2017-05-19 18:57:03.616 | \n", "2017-05-19 18:54:34.000 | \n", "69396 | \n", "54.49 | \n", "18795.00 | \n", "43237.00 | \n", "7364.00 | \n", "New York Times | \n", "... | \n", "121.00 | \n", "True | \n", "13944205.00 | \n", "120 | \n", "50.00 | \n", "20.00 | \n", "4.00 | \n", "14.00 | \n", "38.00 | \n", "88.00 | \n", "
102ab96438ef79f8b34f6b10e2aa09098af012e4 | \n", "http://www.cnn.com/2017/05/12/politics/donald-... | \n", "Trump threatens Comey in new tweet | \n", "2017-05-12 12:55:16.670 | \n", "2017-05-12 12:47:08.000 | \n", "23738 | \n", "48.40 | \n", "8114.00 | \n", "12745.00 | \n", "2879.00 | \n", "CNN | \n", "... | \n", "62.00 | \n", "True | \n", "27338171.00 | \n", "105 | \n", "44.00 | \n", "20.00 | \n", "9.00 | \n", "15.00 | \n", "44.00 | \n", "88.00 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
80449f003315234c3f6f30cdec4278321b4c1fc1 | \n", "http://www.dailymail.co.uk/sport/cricket/artic... | \n", "Bairstow hasn't played into Champions Trophy t... | \n", "2017-05-08 17:05:26.615 | \n", "2017-05-08 16:59:03.000 | \n", "1 | \n", "0.08 | \n", "nan | \n", "nan | \n", "nan | \n", "Daily Mail | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "158 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
98c815a3be205bf97a20740d6a1435f8974b5650 | \n", "https://www.washingtonpost.com/sports/colleges... | \n", "Iowa State losing front court player Ray Kason... | \n", "2017-05-16 17:33:12.965 | \n", "2017-05-16 17:30:31.000 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
7c439ca28aa3385604265f55cb44ddcce0f8b814 | \n", "http://www.dailymail.co.uk/sport/rugbyunion/ar... | \n", "Joe Launchbury and Jimmy Gopperth short-listed... | \n", "2017-05-16 17:33:25.592 | \n", "2017-05-16 17:30:28.000 | \n", "1 | \n", "0.08 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "Daily Mail | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "158 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
acf1e0cf4830f40fe6ec36b8545c667d012a65d0 | \n", "https://www.washingtonpost.com/entertainment/b... | \n", "Tait tackles millennial friendship in ‘Fake Pl... | \n", "2017-05-08 17:10:14.074 | \n", "2017-05-08 17:02:15.000 | \n", "0 | \n", "0.00 | \n", "nan | \n", "nan | \n", "nan | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
95703cf06c6e7297ff5b5b02467066c2cc57a53b | \n", "http://www.telegraph.co.uk/racing/2017/05/16/m... | \n", "Marlborough racing tips for Wednesday, May 17 | \n", "2017-05-16 17:33:01.179 | \n", "2017-05-16 17:30:00.000 | \n", "1 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "The Telegraph | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "370 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
f98961b8ad120aba0f960d9a5b312f716a941c95 | \n", "https://www.washingtonpost.com/national/christ... | \n", "Christie signs bill inspired by ‘Snooki’ to ca... | \n", "2017-05-08 17:10:09.918 | \n", "2017-05-08 17:06:13.000 | \n", "0 | \n", "0.00 | \n", "nan | \n", "nan | \n", "nan | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
d0c0564a2aee55110d0a2ffcff033fd07801b8ba | \n", "https://www.washingtonpost.com/sports/wizards/... | \n", "Raptors PG Lowry will opt out of final year of... | \n", "2017-05-08 17:10:09.224 | \n", "2017-05-08 17:06:18.000 | \n", "0 | \n", "0.00 | \n", "nan | \n", "nan | \n", "nan | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
1433808a624391c2e49054b14162b0de6b1436d4 | \n", "http://www.dailymail.co.uk/sport/othersports/a... | \n", "Tom Dumoulin takes Giro d'Italia lead after ti... | \n", "2017-05-16 17:30:31.801 | \n", "2017-05-16 17:28:29.000 | \n", "1 | \n", "0.08 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "Daily Mail | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "158 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
b112785a000a557abf5fdaa99410d03753e0879c | \n", "https://www.washingtonpost.com/sports/saratoga... | \n", "Saratoga to rename major race for late trainer... | \n", "2017-05-16 17:33:13.191 | \n", "2017-05-16 17:27:15.000 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
61ff94a3f768868adc7aa624bb04bbe15a540981 | \n", "https://www.washingtonpost.com/national/south-... | \n", "South Dakota jury to get case of man charged i... | \n", "2017-05-24 14:00:31.445 | \n", "2017-05-24 13:58:13.000 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
09d731b52e6fb05732e8c519eef830a01363a29c | \n", "http://www.washingtonpost.com/video/entertainm... | \n", "A who's-who guide to famous Chrises | \n", "2017-05-08 17:25:13.871 | \n", "2017-05-08 16:53:46.000 | \n", "0 | \n", "0.00 | \n", "nan | \n", "nan | \n", "nan | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
112e8c790964fdb1bc39f4f2b92b203c1e67b2a0 | \n", "https://www.washingtonpost.com/sports/ferrari-... | \n", "Ferrari driver Sebastian Vettel wins Formula O... | \n", "2017-05-28 14:00:08.380 | \n", "2017-05-28 13:50:44.000 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
7a943c1d63edd5013f4582981831527ba812d67d | \n", "https://www.washingtonpost.com/national/texas-... | \n", "Texas woman dies while snorkeling in the Flori... | \n", "2017-05-24 14:00:14.929 | \n", "2017-05-24 13:50:13.000 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
5ced929e6f8432fca0c19b484cde443533a37589 | \n", "https://www.washingtonpost.com/national/nc-gov... | \n", "NC governor vows executive order to expand LGB... | \n", "2017-05-16 17:45:32.854 | \n", "2017-05-16 17:34:17.000 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
d6f997fab8de17bf6875e53d2151da58aaa8a833 | \n", "http://www.dailymail.co.uk/news/article-453741... | \n", "Lisa Wilkinson denies co-star is paid more tha... | \n", "2017-05-24 13:54:20.898 | \n", "2017-05-24 13:50:26.000 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "Daily Mail | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "158 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
cb74124b7a7bb495948313cf30cd25666cec8827 | \n", "https://www.washingtonpost.com/national/new-je... | \n", "New Jersey nightclub shooting kills 1, injures 5 | \n", "2017-05-28 14:12:08.244 | \n", "2017-05-28 14:02:16.000 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
92641649fb260f8c72db0078f7d284f9a93110bd | \n", "https://www.washingtonpost.com/sports/redskins... | \n", "Upstaged: Predators anthem singer replaced by ... | \n", "2017-05-16 17:45:16.358 | \n", "2017-05-16 17:39:27.000 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
01270e09e56dae2f9d089f2d231f1672907d2403 | \n", "https://www.washingtonpost.com/local/winning-n... | \n", "Winning numbers drawn in ‘Pick 4 Midday’ game | \n", "2017-05-08 16:55:14.913 | \n", "2017-05-08 16:43:11.000 | \n", "0 | \n", "0.00 | \n", "nan | \n", "nan | \n", "nan | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
112d5df1c5e46348b7ae146dabdb237270a7135d | \n", "https://www.washingtonpost.com/local/winning-n... | \n", "Winning numbers drawn in ‘Pick 3 Midday’ game | \n", "2017-05-08 16:55:11.897 | \n", "2017-05-08 16:43:18.000 | \n", "0 | \n", "0.00 | \n", "nan | \n", "nan | \n", "nan | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
9ab54f9d81d8cfe6c9df4880b95ff895a500f56b | \n", "https://www.washingtonpost.com/world/middle_ea... | \n", "Father of alleged Manchester bomber says son i... | \n", "2017-05-24 14:03:08.383 | \n", "2017-05-24 13:51:16.000 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
ca8dd321adbaa5a8348cde264ef99ba432af3f49 | \n", "https://www.washingtonpost.com/local/md-lotter... | \n", "MD Lottery | \n", "2017-05-08 16:55:08.122 | \n", "2017-05-08 16:43:25.000 | \n", "0 | \n", "0.00 | \n", "nan | \n", "nan | \n", "nan | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
be716a25981bc5b2cb462aadd7221f9039670851 | \n", "https://www.washingtonpost.com/national/slain-... | \n", "Slain Arkansas sheriff’s lieutenant is laid to... | \n", "2017-05-16 17:45:31.576 | \n", "2017-05-16 17:39:20.000 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
2cccfa0a1fd9def6c2a3131aae3a395b40a0ed62 | \n", "https://www.washingtonpost.com/national/higher... | \n", "Patients getting checks soon in gynecologist r... | \n", "2017-05-24 14:00:08.192 | \n", "2017-05-24 13:52:13.000 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
eaad80cc454df50c3226604e74cbd510d796a8f6 | \n", "http://www.nbcnews.com/card/forget-appropriate... | \n", "nbcnews:card_text | \n", "2017-05-16 17:39:06.609 | \n", "2017-05-16 17:36:51.000 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "NBC News | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "826 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
8b42a5d98a340d82b0893fa0213e211bcb0bb63d | \n", "http://www.telegraph.co.uk/travel/destinations... | \n", "The Wordsworth Hotel & Spa | \n", "2017-05-08 16:55:03.705 | \n", "2017-05-08 16:45:13.000 | \n", "0 | \n", "0.00 | \n", "nan | \n", "nan | \n", "nan | \n", "The Telegraph | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "370 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
d170b61ae117b326f993447d6a2278d84bf895c7 | \n", "https://www.washingtonpost.com/national/man-ar... | \n", "Man arrested in alleged racing crash that kill... | \n", "2017-05-08 16:50:10.899 | \n", "2017-05-08 16:46:18.000 | \n", "0 | \n", "0.00 | \n", "nan | \n", "nan | \n", "nan | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
fb86e77e8927140141f607b1f2eaa8e35e1f4091 | \n", "https://www.washingtonpost.com/national/us-cal... | \n", "US calls on Kosovo to ratify border deal with ... | \n", "2017-05-08 16:50:10.031 | \n", "2017-05-08 16:46:25.000 | \n", "0 | \n", "0.00 | \n", "nan | \n", "nan | \n", "nan | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
d976785cad88db062e345cb7a46b1602295b383b | \n", "https://www.washingtonpost.com/world/middle_ea... | \n", "Egypt says kills 8 Brotherhood members before ... | \n", "2017-05-08 16:50:11.888 | \n", "2017-05-08 16:46:32.000 | \n", "1 | \n", "0.08 | \n", "nan | \n", "nan | \n", "nan | \n", "The Washington Post | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
f3e21b3975b23fced3a0044a153dc2e01a5dbd74 | \n", "http://www.economist.com/news/21722600-wake-ma... | \n", "Babbage | \n", "2017-05-24 20:21:24.511 | \n", "2017-05-24 13:52:59.000 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "The Economist | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "1825 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
417329307c5f0c208d027e026b8c0fdcea64c446 | \n", "http://www.independent.co.uk/news/obituaries/g... | \n", "Glyn Tegai Hughes, obituary: esteemed literary... | \n", "2017-05-22 12:12:19.316 | \n", "2017-05-22 09:53:35.000 | \n", "1 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "The Independent | \n", "... | \n", "nan | \n", "False | \n", "nan | \n", "386 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
128531 rows × 23 columns
\n", "\n", " | url | \n", "headline | \n", "discovered | \n", "published | \n", "fb_engagements | \n", "fb_max_engagements_per_min | \n", "fb_comments | \n", "fb_reactions | \n", "fb_shares | \n", "publisher_name | \n", "... | \n", "fb_brand_page | \n", "fb_brand_page_likes | \n", "alexa_rank | \n", "response_score | \n", "lead_score | \n", "front_score | \n", "facebook_promotion_score | \n", "promotion_score | \n", "attention_index | \n", "score_diff | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
276f94591dbcc1637e7b17ef8c1f756f55875256 | \n", "https://www.buzzfeed.com/josephbernstein/the-p... | \n", "The Public Square Belongs to 4Chan | \n", "2017-05-18 19:45:20.292 | \n", "2017-05-17 16:56:19 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "Buzzfeed News | \n", "... | \n", "True | \n", "2498318.00 | \n", "147 | \n", "0.00 | \n", "19.00 | \n", "15.00 | \n", "12.00 | \n", "46.00 | \n", "46.00 | \n", "46.00 | \n", "
2e86caccaa0f4d2487fbfe7e66c7d9a1bd7d9700 | \n", "https://www.buzzfeed.com/jtes/california-non-b... | \n", "This 17-Year-Old Wanted A Name Change. They Ma... | \n", "2017-05-25 18:35:06.550 | \n", "2017-05-24 21:17:42 | \n", "1 | \n", "0.02 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "Buzzfeed News | \n", "... | \n", "True | \n", "2522329.00 | \n", "147 | \n", "0.00 | \n", "19.00 | \n", "15.00 | \n", "12.00 | \n", "46.00 | \n", "46.00 | \n", "46.00 | \n", "
b719c5a9926a584c03998c5cb3b966189d9f2355 | \n", "https://www.buzzfeed.com/jimdalrympleii/the-fa... | \n", "An Epic Legal Battle Is Brewing As Trump Sizes... | \n", "2017-05-26 22:15:06.656 | \n", "2017-05-25 23:53:39 | \n", "35 | \n", "0.27 | \n", "4.00 | \n", "7.00 | \n", "24.00 | \n", "Buzzfeed News | \n", "... | \n", "True | \n", "2521837.00 | \n", "147 | \n", "5.00 | \n", "19.00 | \n", "15.00 | \n", "12.00 | \n", "46.00 | \n", "51.00 | \n", "41.00 | \n", "
86e29ec1cdb2bfbaca4c7d5c7dced916b514bba8 | \n", "https://www.buzzfeed.com/bimadewunmi/flint-isn... | \n", "Flint Isn’t Ready To Trust Anyone Yet | \n", "2017-05-24 22:15:04.778 | \n", "2017-05-22 22:45:04 | \n", "43 | \n", "0.08 | \n", "2.00 | \n", "18.00 | \n", "23.00 | \n", "Buzzfeed News | \n", "... | \n", "True | \n", "2523526.00 | \n", "147 | \n", "6.00 | \n", "19.00 | \n", "15.00 | \n", "12.00 | \n", "46.00 | \n", "52.00 | \n", "40.00 | \n", "
08c2282049e8764a1cd56b1d7b548fa4bf4989c2 | \n", "https://www.buzzfeed.com/priya/uber-pool-burn-... | \n", "Leaked Internal Documents Show UberPool Was A ... | \n", "2017-05-31 13:42:26.876 | \n", "2017-05-26 23:56:21 | \n", "2 | \n", "0.08 | \n", "0.00 | \n", "0.00 | \n", "2.00 | \n", "Buzzfeed News | \n", "... | \n", "True | \n", "2526007.00 | \n", "147 | \n", "1.00 | \n", "19.00 | \n", "7.00 | \n", "12.00 | \n", "38.00 | \n", "39.00 | \n", "37.00 | \n", "
2386c9b079c7fe36ce6d834c70740d4944b87004 | \n", "http://www.huffingtonpost.com/entry/trump-kill... | \n", "While You Weren't Looking, Trump Basically Kil... | \n", "2017-05-22 11:21:11.792 | \n", "2017-05-16 10:01:54 | \n", "1 | \n", "0.08 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "HuffPost | \n", "... | \n", "True | \n", "9456258.00 | \n", "215 | \n", "0.00 | \n", "17.00 | \n", "6.00 | \n", "13.00 | \n", "36.00 | \n", "36.00 | \n", "36.00 | \n", "
d8e02170a5b45a4438d1eb145395cc016eb3899b | \n", "http://www.huffingtonpost.com/entry/portland-a... | \n", "One Official Tried To Warn Us About Attacks Li... | \n", "2017-05-31 19:21:15.995 | \n", "2017-05-30 07:41:50 | \n", "2 | \n", "0.17 | \n", "0.00 | \n", "0.00 | \n", "2.00 | \n", "HuffPost | \n", "... | \n", "True | \n", "9494109.00 | \n", "215 | \n", "1.00 | \n", "17.00 | \n", "6.00 | \n", "13.00 | \n", "36.00 | \n", "37.00 | \n", "35.00 | \n", "
fe77503974cdd9ed96e6269a1c663703f9c1836d | \n", "https://www.buzzfeed.com/dougbockclark/america... | \n", "Why Is The US Trying To Remake The World’s Pri... | \n", "2017-05-28 15:03:13.191 | \n", "2017-05-18 11:39:30 | \n", "0 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "Buzzfeed News | \n", "... | \n", "False | \n", "nan | \n", "147 | \n", "0.00 | \n", "19.00 | \n", "15.00 | \n", "0.00 | \n", "34.00 | \n", "34.00 | \n", "34.00 | \n", "
23856d48f503288938e10d5705d94e06399b2232 | \n", "https://www.buzzfeed.com/alisonwillmore/the-ne... | \n", "The New Fall Shows Are Opting For Comfort Over... | \n", "2017-05-21 17:10:15.705 | \n", "2017-05-19 22:37:04 | \n", "1 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "Buzzfeed News | \n", "... | \n", "False | \n", "nan | \n", "147 | \n", "0.00 | \n", "19.00 | \n", "15.00 | \n", "0.00 | \n", "34.00 | \n", "34.00 | \n", "34.00 | \n", "
55519241e5fcfb028a7378cda01fe05471e12497 | \n", "https://www.buzzfeed.com/priya/a-federal-judge... | \n", "A Federal Judge Ordered Uber To Return Documen... | \n", "2017-05-15 15:04:24.715 | \n", "2017-05-15 14:52:24 | \n", "29 | \n", "0.58 | \n", "0.00 | \n", "8.00 | \n", "21.00 | \n", "Buzzfeed News | \n", "... | \n", "False | \n", "nan | \n", "147 | \n", "4.00 | \n", "19.00 | \n", "15.00 | \n", "0.00 | \n", "34.00 | \n", "38.00 | \n", "30.00 | \n", "
d64c64f6678104353fffca22cbcc35d443008cd6 | \n", "http://www.bbc.co.uk/news/live/election-2017-4... | \n", "General election: Latest updates | \n", "2017-05-30 09:10:15.842 | \n", "2017-05-30 09:09:45 | \n", "421 | \n", "0.77 | \n", "146.00 | \n", "115.00 | \n", "160.00 | \n", "BBC | \n", "... | \n", "True | \n", "41829626.00 | \n", "96 | \n", "17.00 | \n", "20.00 | \n", "12.00 | \n", "15.00 | \n", "47.00 | \n", "64.00 | \n", "30.00 | \n", "
06ca61dd2f4e36da6778a41713a1bea8a2b80489 | \n", "https://www.buzzfeed.com/emmaloop/some-senator... | \n", "Some Senators Worry Special Counsel Will Hurt ... | \n", "2017-05-18 23:35:07.335 | \n", "2017-05-18 23:26:28 | \n", "24 | \n", "0.17 | \n", "3.00 | \n", "6.00 | \n", "15.00 | \n", "Buzzfeed News | \n", "... | \n", "False | \n", "nan | \n", "147 | \n", "4.00 | \n", "19.00 | \n", "13.00 | \n", "0.00 | \n", "32.00 | \n", "36.00 | \n", "28.00 | \n", "
d5d04b8bf3bba2309df65df92e328095aeb41dcd | \n", "https://www.buzzfeed.com/hannahalothman/these-... | \n", "These Pictures Show Salman Abedi On The Night ... | \n", "2017-05-27 20:48:17.614 | \n", "2017-05-27 19:48:33 | \n", "489 | \n", "2.34 | \n", "146.00 | \n", "308.00 | \n", "35.00 | \n", "Buzzfeed News | \n", "... | \n", "True | \n", "2522625.00 | \n", "147 | \n", "18.00 | \n", "19.00 | \n", "15.00 | \n", "12.00 | \n", "46.00 | \n", "64.00 | \n", "28.00 | \n", "
eec485815c62fe8f7d9f92cfc1a9e3b4505f9da1 | \n", "https://www.buzzfeed.com/johnhudson/turkeys-fo... | \n", "Turkey’s Foreign Minister Accuses European Int... | \n", "2017-05-27 14:54:12.773 | \n", "2017-05-27 14:41:30 | \n", "52 | \n", "0.29 | \n", "2.00 | \n", "24.00 | \n", "26.00 | \n", "Buzzfeed News | \n", "... | \n", "False | \n", "nan | \n", "147 | \n", "6.00 | \n", "19.00 | \n", "15.00 | \n", "0.00 | \n", "34.00 | \n", "40.00 | \n", "28.00 | \n", "
cdc9da260c2f69ac44612222743507f59fc1ea85 | \n", "https://www.buzzfeed.com/aishagani/these-are-t... | \n", "These Are The Children Left Behind In Calais | \n", "2017-05-29 08:12:11.176 | \n", "2017-05-25 14:23:45 | \n", "6 | \n", "0.50 | \n", "0.00 | \n", "4.00 | \n", "2.00 | \n", "Buzzfeed News | \n", "... | \n", "False | \n", "nan | \n", "147 | \n", "1.00 | \n", "19.00 | \n", "10.00 | \n", "0.00 | \n", "29.00 | \n", "30.00 | \n", "28.00 | \n", "
ad95623506020d40832341a492a716c089041357 | \n", "https://www.buzzfeed.com/buzzfeednews/live-upd... | \n", "Live Updates: President Trump Delivers Remarks... | \n", "2017-05-29 15:30:21.840 | \n", "2017-05-29 15:28:35 | \n", "47 | \n", "0.17 | \n", "21.00 | \n", "3.00 | \n", "23.00 | \n", "Buzzfeed News | \n", "... | \n", "False | \n", "nan | \n", "147 | \n", "6.00 | \n", "19.00 | \n", "15.00 | \n", "0.00 | \n", "34.00 | \n", "40.00 | \n", "28.00 | \n", "
46dca9508b04bf096559dae6de4c380aa43b5a1a | \n", "https://www.buzzfeed.com/borzoudaragahi/the-fa... | \n", "The Father Of The Manchester Suicide Bomber Pr... | \n", "2017-05-25 17:39:11.882 | \n", "2017-05-25 16:38:13 | \n", "444 | \n", "1.11 | \n", "73.00 | \n", "314.00 | \n", "57.00 | \n", "Buzzfeed News | \n", "... | \n", "True | \n", "2517728.00 | \n", "147 | \n", "18.00 | \n", "19.00 | \n", "15.00 | \n", "12.00 | \n", "46.00 | \n", "64.00 | \n", "28.00 | \n", "
a68cb2203f5f4adc936598ff48f48e88f90df114 | \n", "https://www.buzzfeed.com/gracewyler/north-kore... | \n", "North Korea Reportedly Launched Another Projec... | \n", "2017-05-13 23:15:15.684 | \n", "2017-05-13 23:05:54 | \n", "44 | \n", "0.17 | \n", "0.00 | \n", "18.00 | \n", "26.00 | \n", "Buzzfeed News | \n", "... | \n", "False | \n", "nan | \n", "147 | \n", "6.00 | \n", "19.00 | \n", "15.00 | \n", "0.00 | \n", "34.00 | \n", "40.00 | \n", "28.00 | \n", "
a753c5ecbc0ba12d832bd9a6f2c835c2ed48ba15 | \n", "https://www.buzzfeed.com/hannahallam/what-happ... | \n", "No, The Trump Administration's Attacks On Musl... | \n", "2017-05-17 18:57:16.139 | \n", "2017-05-17 18:55:43 | \n", "26 | \n", "0.08 | \n", "1.00 | \n", "12.00 | \n", "13.00 | \n", "Buzzfeed News | \n", "... | \n", "False | \n", "nan | \n", "147 | \n", "4.00 | \n", "19.00 | \n", "13.00 | \n", "0.00 | \n", "32.00 | \n", "36.00 | \n", "28.00 | \n", "
17a00d45c745161632b8bc4e925a98946ee4495b | \n", "https://www.buzzfeed.com/adolfoflores/undocume... | \n", "The Underground Network To Ferry Undocumented ... | \n", "2017-05-20 15:33:18.644 | \n", "2017-05-19 19:44:49 | \n", "66 | \n", "0.44 | \n", "1.00 | \n", "29.00 | \n", "36.00 | \n", "Buzzfeed News | \n", "... | \n", "False | \n", "nan | \n", "147 | \n", "7.00 | \n", "19.00 | \n", "15.00 | \n", "0.00 | \n", "34.00 | \n", "41.00 | \n", "27.00 | \n", "
a6f209e9944ba0d610b6434c94698fcbc6efc4c3 | \n", "https://www.buzzfeed.com/albertonardelli/g7-be... | \n", "Here's What's Going On Behind The Scenes Durin... | \n", "2017-05-26 20:12:22.410 | \n", "2017-05-26 20:10:27 | \n", "27 | \n", "0.16 | \n", "1.00 | \n", "4.00 | \n", "22.00 | \n", "Buzzfeed News | \n", "... | \n", "False | \n", "nan | \n", "147 | \n", "4.00 | \n", "19.00 | \n", "12.00 | \n", "0.00 | \n", "31.00 | \n", "35.00 | \n", "27.00 | \n", "
7a54ed2dd7aaa6b1570f8f4921d3ee48f5c94d05 | \n", "http://www.npr.org/2017/05/31/530929894/jury-s... | \n", "Jury Selection Begins In South Dakota 'Pink Sl... | \n", "2017-05-31 21:00:33.572 | \n", "2017-05-31 20:00:00 | \n", "14 | \n", "0.03 | \n", "0.00 | \n", "3.00 | \n", "11.00 | \n", "NPR | \n", "... | \n", "True | \n", "6008762.00 | \n", "594 | \n", "3.00 | \n", "15.00 | \n", "2.00 | \n", "13.00 | \n", "30.00 | \n", "33.00 | \n", "27.00 | \n", "
9ca581ae49a1d1c9378930a5692e5b277b39345a | \n", "https://www.buzzfeed.com/danvergano/how-lidar-... | \n", "Everything You Need To Know About The Technolo... | \n", "2017-05-15 18:12:03.981 | \n", "2017-05-12 21:14:37 | \n", "63 | \n", "0.50 | \n", "0.00 | \n", "13.00 | \n", "50.00 | \n", "Buzzfeed News | \n", "... | \n", "False | \n", "nan | \n", "147 | \n", "7.00 | \n", "19.00 | \n", "15.00 | \n", "0.00 | \n", "34.00 | \n", "41.00 | \n", "27.00 | \n", "
4ade00f8a8b024605911ff619d371603c1acad6f | \n", "https://www.buzzfeed.com/zoetillman/federal-ap... | \n", "Federal Appeals Court Upholds The Nationwide I... | \n", "2017-05-25 18:09:19.095 | \n", "2017-05-25 18:09:05 | \n", "518 | \n", "4.01 | \n", "57.00 | \n", "342.00 | \n", "119.00 | \n", "Buzzfeed News | \n", "... | \n", "True | \n", "2518012.00 | \n", "147 | \n", "19.00 | \n", "19.00 | \n", "15.00 | \n", "12.00 | \n", "46.00 | \n", "65.00 | \n", "27.00 | \n", "
35084b054f4015c12db62c965f792f634b09ceac | \n", "http://www.nbcnews.com/storyline/trumps-first-... | \n", "On Saudi Trip, Trump Tasked With Mending Relat... | \n", "2017-05-19 19:27:06.021 | \n", "2017-05-19 18:19:00 | \n", "3 | \n", "0.02 | \n", "0.00 | \n", "0.00 | \n", "3.00 | \n", "NBC News | \n", "... | \n", "True | \n", "8922889.00 | \n", "826 | \n", "1.00 | \n", "14.00 | \n", "1.00 | \n", "13.00 | \n", "28.00 | \n", "29.00 | \n", "27.00 | \n", "
25 rows × 24 columns
\n", "\n", " | url | \n", "headline | \n", "discovered | \n", "published | \n", "fb_engagements | \n", "fb_max_engagements_per_min | \n", "fb_comments | \n", "fb_reactions | \n", "fb_shares | \n", "publisher_name | \n", "... | \n", "fb_brand_page | \n", "fb_brand_page_likes | \n", "alexa_rank | \n", "response_score | \n", "lead_score | \n", "front_score | \n", "facebook_promotion_score | \n", "promotion_score | \n", "attention_index | \n", "score_diff | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
bc6d2a659ec806138ffbff7973f3849c2d5170fd | \n", "http://yournewswire.com/world-gets-behind-puti... | \n", "World Gets Behind Putin's Vow To Destroy New W... | \n", "2017-05-17 10:51:54.096 | \n", "2017-05-06 22:00:12.000 | \n", "166706 | \n", "0.00 | \n", "24418.00 | \n", "114380.00 | \n", "27908.00 | \n", "Your News Wire | \n", "... | \n", "False | \n", "nan | \n", "22568 | \n", "50.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "50.00 | \n", "-50.00 | \n", "
f9e0e40d7a2ae8a3ee8cea21e7a4972358b94f15 | \n", "https://www.washingtonpost.com/news/parenting/... | \n", "The important role of aunts and uncles in chil... | \n", "2017-05-26 10:06:13.945 | \n", "2017-05-26 10:00:00.000 | \n", "84117 | \n", "83.45 | \n", "8077.00 | \n", "62427.00 | \n", "13613.00 | \n", "The Washington Post | \n", "... | \n", "False | \n", "nan | \n", "191 | \n", "50.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "50.00 | \n", "-50.00 | \n", "
6f582dfe1ce09b7896bc16ff135c62d61eb46c44 | \n", "http://www.huffingtonpost.com/entry/chris-corn... | \n", "Chris Cornell: When Suicide Doesn't Make Sense | \n", "2017-05-19 13:30:19.144 | \n", "2017-05-18 14:47:50.000 | \n", "73548 | \n", "58.41 | \n", "11786.00 | \n", "50465.00 | \n", "11297.00 | \n", "HuffPost | \n", "... | \n", "False | \n", "nan | \n", "215 | \n", "50.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "50.00 | \n", "-50.00 | \n", "
a31e662de58eeb12d8dcb5f1d40f6302a7cb42a5 | \n", "https://www.nytimes.com/2017/05/19/business/li... | \n", "Lisa Su on the Art of Setting Ambitious Goals | \n", "2017-05-19 11:03:27.185 | \n", "2017-05-19 11:00:01.000 | \n", "149799 | \n", "72.18 | \n", "65.00 | \n", "149665.00 | \n", "69.00 | \n", "New York Times | \n", "... | \n", "False | \n", "nan | \n", "120 | \n", "50.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "50.00 | \n", "-50.00 | \n", "
3fb57d744f1b05e05f6745bd5244130eeb77aa69 | \n", "http://www.independent.co.uk/jeff-sessions-wom... | \n", "Woman found guilty and faces year in jail for ... | \n", "2017-05-03 17:50:18.534 | \n", "2017-05-03 17:48:28.000 | \n", "60406 | \n", "88.37 | \n", "nan | \n", "nan | \n", "nan | \n", "The Independent | \n", "... | \n", "False | \n", "nan | \n", "386 | \n", "50.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "50.00 | \n", "-50.00 | \n", "
971f61642849a7db6f16046b241cc16819f87a33 | \n", "http://www.cnn.com/2013/05/28/travel/100-best-... | \n", "World's 100 best beaches | \n", "2017-05-11 11:15:18.220 | \n", "2017-05-11 11:06:29.000 | \n", "82513 | \n", "0.00 | \n", "nan | \n", "nan | \n", "nan | \n", "CNN | \n", "... | \n", "False | \n", "nan | \n", "105 | \n", "50.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "50.00 | \n", "-50.00 | \n", "
238e488a22925512652eef984fb16fd547ac9512 | \n", "https://www.washingtonpost.com/local/obituarie... | \n", "Representative: Rocker Chris Cornell has died ... | \n", "2017-05-18 07:45:22.278 | \n", "2017-05-18 07:36:12.000 | \n", "57145 | \n", "267.37 | \n", "11497.00 | \n", "40224.00 | \n", "5424.00 | \n", "The Washington Post | \n", "... | \n", "False | \n", "nan | \n", "191 | \n", "50.00 | \n", "0.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "51.00 | \n", "-49.00 | \n", "
c55509930e92f71ee534edf7d570b70ed81a2267 | \n", "https://www.indy100.com/article/divorced-fathe... | \n", "This dad's brilliant post about his ex-wife is... | \n", "2017-05-15 11:09:18.339 | \n", "2017-05-14 08:36:41.000 | \n", "1114468 | \n", "8.34 | \n", "58501.00 | \n", "914126.00 | \n", "141841.00 | \n", "indy100 | \n", "... | \n", "False | \n", "nan | \n", "5014 | \n", "50.00 | \n", "0.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "51.00 | \n", "-49.00 | \n", "
d864ee5c2c85f8cb99380b309268422f81d48165 | \n", "https://www.indy100.com/article/luxembourg-gay... | \n", "Luxembourg's openly gay 'first husband' joined... | \n", "2017-05-26 12:05:12.044 | \n", "2017-05-26 11:57:01.000 | \n", "156503 | \n", "108.48 | \n", "5846.00 | \n", "141474.00 | \n", "9183.00 | \n", "indy100 | \n", "... | \n", "False | \n", "nan | \n", "5014 | \n", "50.00 | \n", "0.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "51.00 | \n", "-49.00 | \n", "
5811a42e5a65ce6dca6b1b85fb72b585914d495e | \n", "http://www.independent.co.uk/news/world/americ... | \n", "US citizens with cancer could pay up to $140,0... | \n", "2017-05-04 11:08:25.992 | \n", "2017-05-04 10:18:47.000 | \n", "75268 | \n", "108.33 | \n", "nan | \n", "nan | \n", "nan | \n", "The Independent | \n", "... | \n", "False | \n", "nan | \n", "386 | \n", "50.00 | \n", "0.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "51.00 | \n", "-49.00 | \n", "
7258bf39dbb64771f0a084202fb7aa15138274f3 | \n", "http://www.huffingtonpost.com/entry/black-farm... | \n", "Black Farmer Calls Out Liberal Racism In Power... | \n", "2017-05-24 19:21:13.921 | \n", "2017-05-24 07:00:55.000 | \n", "52881 | \n", "18.61 | \n", "5498.00 | \n", "38879.00 | \n", "8504.00 | \n", "HuffPost | \n", "... | \n", "False | \n", "nan | \n", "215 | \n", "49.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "49.00 | \n", "-49.00 | \n", "
7e4d3e7c555faa571afb985b7283f0a707d0662b | \n", "https://www.washingtonpost.com/national/repres... | \n", "Representative: Rocker Chris Cornell has died ... | \n", "2017-05-18 07:39:09.658 | \n", "2017-05-18 07:28:13.000 | \n", "49937 | \n", "62.50 | \n", "9600.00 | \n", "35506.00 | \n", "4831.00 | \n", "The Washington Post | \n", "... | \n", "False | \n", "nan | \n", "191 | \n", "49.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "49.00 | \n", "-49.00 | \n", "
6a9c8aa43c71cb24777862596739902fb4b06ff8 | \n", "https://www.indy100.com/article/luxembourg-gay... | \n", "Luxembourg's openly gay 'first husband' joined... | \n", "2017-05-26 09:35:12.615 | \n", "2017-05-26 09:30:24.000 | \n", "131750 | \n", "145.08 | \n", "4788.00 | \n", "120893.00 | \n", "6069.00 | \n", "indy100 | \n", "... | \n", "False | \n", "nan | \n", "5014 | \n", "50.00 | \n", "0.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "51.00 | \n", "-49.00 | \n", "
6c1158c4d5575103f2d3ea9666ea9fd8a94576c8 | \n", "https://www.indy100.com/article/white-privileg... | \n", "This student's message about white privilege i... | \n", "2017-05-15 11:09:03.877 | \n", "2017-05-13 15:05:34.000 | \n", "221132 | \n", "191.67 | \n", "27010.00 | \n", "143505.00 | \n", "50617.00 | \n", "indy100 | \n", "... | \n", "False | \n", "nan | \n", "5014 | \n", "50.00 | \n", "0.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "51.00 | \n", "-49.00 | \n", "
e029967f1b95be119e29603ec4b975a8ccedcfbe | \n", "http://www.huffingtonpost.com/entry/pharrell-n... | \n", "Pharrell To College Graduates: 'We Need To Lif... | \n", "2017-05-18 19:12:14.557 | \n", "2017-05-18 09:13:21.000 | \n", "50390 | \n", "36.58 | \n", "821.00 | \n", "45904.00 | \n", "3665.00 | \n", "HuffPost | \n", "... | \n", "False | \n", "nan | \n", "215 | \n", "49.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "49.00 | \n", "-49.00 | \n", "
0765a68170be1d1bc8d466cd312b4198b1bed52a | \n", "https://www.washingtonpost.com/news/morning-mi... | \n", "Kid genius brothers, 11 and 14, graduate high ... | \n", "2017-05-12 08:12:05.453 | \n", "2017-05-12 08:06:00.000 | \n", "68072 | \n", "58.41 | \n", "2142.00 | \n", "56282.00 | \n", "9648.00 | \n", "The Washington Post | \n", "... | \n", "False | \n", "nan | \n", "191 | \n", "50.00 | \n", "0.00 | \n", "2.00 | \n", "0.00 | \n", "2.00 | \n", "52.00 | \n", "-48.00 | \n", "
24c4629edddc8db232fe20107e1eeed658d04980 | \n", "http://evolvepolitics.com/one-britains-influen... | \n", "One of Britain's most influential rappers just... | \n", "2017-05-16 10:35:22.163 | \n", "2017-05-09 16:52:45.000 | \n", "55710 | \n", "1.61 | \n", "7810.00 | \n", "36702.00 | \n", "11198.00 | \n", "EvolvePolitics.com | \n", "... | \n", "False | \n", "nan | \n", "119412 | \n", "49.00 | \n", "0.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "50.00 | \n", "-48.00 | \n", "
7465f0aa8747b4b86761fe8c64da207a048347e7 | \n", "https://www.buzzfeed.com/aishamirza/until-whit... | \n", "Until White Women Ruined It | \n", "2017-05-23 20:25:14.205 | \n", "2017-05-23 17:25:19.000 | \n", "50599 | \n", "17.11 | \n", "17118.00 | \n", "28783.00 | \n", "4698.00 | \n", "Buzzfeed News | \n", "... | \n", "False | \n", "nan | \n", "147 | \n", "49.00 | \n", "0.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "50.00 | \n", "-48.00 | \n", "
8b2f321660974d49d7bbff5eb7bbacff15c034b9 | \n", "http://www.huffingtonpost.com/entry/mickey-row... | \n", "Finally, An Actor With Autism Is Starring In '... | \n", "2017-05-10 16:20:24.388 | \n", "2017-05-10 04:43:41.000 | \n", "43300 | \n", "31.04 | \n", "2726.00 | \n", "36456.00 | \n", "4118.00 | \n", "HuffPost | \n", "... | \n", "False | \n", "nan | \n", "215 | \n", "48.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "48.00 | \n", "-48.00 | \n", "
ec37e52e5822f54de86ca03fdccb331e63efce9f | \n", "http://yournewswire.com/melania-trump-bans-mon... | \n", "Melania Trump Bans Monsanto Products From The ... | \n", "2017-05-30 18:20:12.797 | \n", "2017-05-30 18:14:49.000 | \n", "64190 | \n", "43.00 | \n", "10865.00 | \n", "45276.00 | \n", "8049.00 | \n", "Your News Wire | \n", "... | \n", "False | \n", "nan | \n", "22568 | \n", "50.00 | \n", "2.00 | \n", "1.00 | \n", "0.00 | \n", "3.00 | \n", "53.00 | \n", "-47.00 | \n", "
1f5b4b137dd3d3590710c2b94575fe1b54dbda02 | \n", "https://www.washingtonpost.com/news/early-lead... | \n", "Torrey Smith just paid the adoption fee for 46... | \n", "2017-05-07 20:36:02.478 | \n", "2017-05-07 20:27:00.000 | \n", "70570 | \n", "49.83 | \n", "nan | \n", "nan | \n", "nan | \n", "The Washington Post | \n", "... | \n", "False | \n", "nan | \n", "191 | \n", "50.00 | \n", "0.00 | \n", "3.00 | \n", "0.00 | \n", "3.00 | \n", "53.00 | \n", "-47.00 | \n", "
f370c7baac0ce9a5d9a74e3a022790b8536ef400 | \n", "http://www.washingtonpost.com/politics/2017/li... | \n", "Democrats are demanding an investigation of Se... | \n", "2017-05-17 17:00:09.780 | \n", "2017-05-17 17:00:09.780 | \n", "42073 | \n", "92.58 | \n", "2922.00 | \n", "37359.00 | \n", "1792.00 | \n", "The Washington Post | \n", "... | \n", "False | \n", "nan | \n", "191 | \n", "48.00 | \n", "0.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "49.00 | \n", "-47.00 | \n", "
2ae7ddbb5ead761510ae0b05f24f3d9cc096c157 | \n", "https://www.washingtonpost.com/news/energy-env... | \n", "Scientists just published an entire study refu... | \n", "2017-05-24 17:57:12.090 | \n", "2017-05-24 17:46:23.000 | \n", "47462 | \n", "41.72 | \n", "2589.00 | \n", "37804.00 | \n", "7069.00 | \n", "The Washington Post | \n", "... | \n", "False | \n", "nan | \n", "191 | \n", "48.00 | \n", "0.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "49.00 | \n", "-47.00 | \n", "
dffa1bb577da46da34e2d0753a48ad497fde3e25 | \n", "https://www.indy100.com/article/justin-trudeau... | \n", "Two of the most popular world leaders went for... | \n", "2017-05-26 11:25:16.769 | \n", "2017-05-26 11:11:53.000 | \n", "42286 | \n", "48.39 | \n", "4105.00 | \n", "35844.00 | \n", "2337.00 | \n", "indy100 | \n", "... | \n", "False | \n", "nan | \n", "5014 | \n", "48.00 | \n", "0.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "49.00 | \n", "-47.00 | \n", "
0ae249e0a6761c5c59710c905a88de0341bcef4c | \n", "https://www.washingtonpost.com/national/health... | \n", "Journalist arrested during US health secretary... | \n", "2017-05-10 11:30:11.366 | \n", "2017-05-10 11:22:13.000 | \n", "41446 | \n", "300.40 | \n", "nan | \n", "nan | \n", "nan | \n", "The Washington Post | \n", "... | \n", "False | \n", "nan | \n", "191 | \n", "47.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "47.00 | \n", "-47.00 | \n", "
25 rows × 24 columns
\n", "