{ "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_max_engagements_per_min_time | \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", "fb_brand_page_time | \n", "alexa_rank | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
103d30e1ada75aa031d84f88af50d113184ea4ed | \n", "https://www.theguardian.com/lifeandstyle/2017/... | \n", "Break down barriers to breastfeeding in the UK | \n", "2017-08-01 00:03:02.887 | \n", "2017-08-01 00:00:02.000 | \n", "294 | \n", "0.822802 | \n", "2017-08-01T08:32:01.637Z | \n", "20 | \n", "220 | \n", "54 | \n", "The Guardian | \n", "theguardian_com | \n", "0 | \n", "449 | \n", "85.0 | \n", "False | \n", "NaN | \n", "NaN | \n", "142 | \n", "
dedd4245cfa237afcd5f543960e04ae90b26ac48 | \n", "https://www.thetimes.co.uk/article/breastfeedi... | \n", "Breastfeeding ‘should be a school subject’ | \n", "2017-08-01 00:00:03.958 | \n", "2017-08-01 00:00:03.958 | \n", "41 | \n", "0.112903 | \n", "2017-08-01T14:42:00.635Z | \n", "21 | \n", "12 | \n", "8 | \n", "The Times | \n", "thetimes_co_uk | \n", "0 | \n", "1380 | \n", "238.0 | \n", "False | \n", "NaN | \n", "NaN | \n", "6435 | \n", "
18c2ab6d72b11232f9df96b3748b26519368b810 | \n", "http://www.huffingtonpost.com/entry/washington... | \n", "Washington's Marijuana Legalization: The Kids ... | \n", "2017-08-01 00:03:18.131 | \n", "2017-08-01 00:00:20.436 | \n", "122 | \n", "0.258134 | \n", "2017-08-01T08:32:01.645Z | \n", "7 | \n", "70 | \n", "45 | \n", "HuffPost | \n", "huffingtonpost_com | \n", "0 | \n", "0 | \n", "NaN | \n", "False | \n", "NaN | \n", "NaN | \n", "215 | \n", "
e798d89b959cf713fe3658c2ee296af4bc9361e5 | \n", "http://www.huffingtonpost.com/entry/an-ounce-o... | \n", "An Ounce of Love Creates a Ton of Healing | \n", "2017-08-01 00:03:18.059 | \n", "2017-08-01 00:00:23.485 | \n", "4 | \n", "0.016133 | \n", "2017-08-01T20:56:00.086Z | \n", "0 | \n", "1 | \n", "3 | \n", "HuffPost | \n", "huffingtonpost_com | \n", "0 | \n", "0 | \n", "NaN | \n", "False | \n", "NaN | \n", "NaN | \n", "215 | \n", "
092977d2eacec21b414928bf580d5caeb849e9c0 | \n", "https://www.washingtonpost.com/news/retropolis... | \n", "The only communications director booted faster... | \n", "2017-08-01 00:03:09.289 | \n", "2017-08-01 00:00:28.000 | \n", "1611 | \n", "11.112903 | \n", "2017-08-01T01:18:02.072Z | \n", "198 | \n", "1266 | \n", "147 | \n", "The Washington Post | \n", "washingtonpost_com | \n", "0 | \n", "1020 | \n", "74.0 | \n", "True | \n", "5962099.0 | \n", "2017-08-01T00:15:15.000Z | \n", "191 | \n", "
\n", " | url | \n", "headline | \n", "discovered | \n", "published | \n", "fb_engagements | \n", "fb_max_engagements_per_min | \n", "fb_max_engagements_per_min_time | \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", "fb_brand_page_time | \n", "alexa_rank | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
478a416c259d9028be1860e8b63518fae553fa8f | \n", "http://www.huffingtonpost.com/entry/tina-fey-s... | \n", "Tina Fey Absolutely Destroys Nazis, Trump & Pa... | \n", "2017-08-18 07:55:03.814 | \n", "2017-08-18 07:46:45 | \n", "1053024 | \n", "971.27 | \n", "2017-08-18T15:50:00.454Z | \n", "122164 | \n", "815305 | \n", "115555 | \n", "HuffPost | \n", "huffingtonpost_com | \n", "0 | \n", "1909 | \n", "28.00 | \n", "True | \n", "9683181.00 | \n", "2017-08-18T12:30:59.000Z | \n", "215 | \n", "
01c376d7653532da2d4251733e10e3f400ca4afa | \n", "http://www.bbc.co.uk/news/entertainment-arts-4... | \n", "Sir Bruce Forsyth: TV legend dies aged 89 | \n", "2017-08-18 15:36:07.209 | \n", "2017-08-18 15:35:22 | \n", "1033767 | \n", "8477.44 | \n", "2017-08-18T16:02:02.360Z | \n", "125104 | \n", "695601 | \n", "213062 | \n", "BBC | \n", "bbc_co_uk | \n", "0 | \n", "1134 | \n", "55.00 | \n", "True | \n", "43514982.00 | \n", "2017-08-18T15:36:50.000Z | \n", "96 | \n", "
3a62bf1003c686e38634844245aeb7a11f1c2be7 | \n", "http://www.independent.co.uk/news/world/americ... | \n", "Trapped Mexican bakers make 'pan dulce' bread ... | \n", "2017-08-30 20:42:20.971 | \n", "2017-08-30 18:47:44 | \n", "2362234 | \n", "2191.75 | \n", "2017-08-31T03:50:01.773Z | \n", "80669 | \n", "2064103 | \n", "217462 | \n", "The Independent | \n", "independent_co_uk | \n", "0 | \n", "434 | \n", "221.00 | \n", "True | \n", "7368466.00 | \n", "2017-08-30T23:01:00.000Z | \n", "386 | \n", "
\n", " | size | \n", "amin | \n", "amax | \n", "
---|---|---|---|
response_score | \n", "\n", " | \n", " | \n", " |
0.00 | \n", "35077 | \n", "0 | \n", "1 | \n", "
1.00 | \n", "16107 | \n", "2 | \n", "6 | \n", "
2.00 | \n", "9464 | \n", "7 | \n", "12 | \n", "
3.00 | \n", "7642 | \n", "13 | \n", "20 | \n", "
4.00 | \n", "5955 | \n", "21 | \n", "29 | \n", "
5.00 | \n", "5346 | \n", "30 | \n", "40 | \n", "
6.00 | \n", "4387 | \n", "41 | \n", "52 | \n", "
7.00 | \n", "4140 | \n", "53 | \n", "67 | \n", "
8.00 | \n", "3831 | \n", "68 | \n", "85 | \n", "
9.00 | \n", "3495 | \n", "86 | \n", "106 | \n", "
10.00 | \n", "3356 | \n", "107 | \n", "131 | \n", "
11.00 | \n", "3112 | \n", "132 | \n", "160 | \n", "
12.00 | \n", "3092 | \n", "161 | \n", "195 | \n", "
13.00 | \n", "2775 | \n", "196 | \n", "235 | \n", "
14.00 | \n", "2765 | \n", "236 | \n", "284 | \n", "
15.00 | \n", "2550 | \n", "285 | \n", "341 | \n", "
16.00 | \n", "2440 | \n", "342 | \n", "408 | \n", "
17.00 | \n", "2409 | \n", "409 | \n", "488 | \n", "
18.00 | \n", "2317 | \n", "489 | \n", "583 | \n", "
19.00 | \n", "1982 | \n", "584 | \n", "694 | \n", "
20.00 | \n", "2101 | \n", "695 | \n", "826 | \n", "
21.00 | \n", "1858 | \n", "827 | \n", "983 | \n", "
22.00 | \n", "1810 | \n", "984 | \n", "1167 | \n", "
23.00 | \n", "1715 | \n", "1168 | \n", "1385 | \n", "
24.00 | \n", "1645 | \n", "1386 | \n", "1643 | \n", "
25.00 | \n", "1576 | \n", "1644 | \n", "1949 | \n", "
26.00 | \n", "1487 | \n", "1950 | \n", "2309 | \n", "
27.00 | \n", "1400 | \n", "2310 | \n", "2736 | \n", "
28.00 | \n", "1371 | \n", "2737 | \n", "3240 | \n", "
29.00 | \n", "1199 | \n", "3241 | \n", "3837 | \n", "
30.00 | \n", "1195 | \n", "3838 | \n", "4542 | \n", "
31.00 | \n", "1076 | \n", "4543 | \n", "5376 | \n", "
32.00 | \n", "1075 | \n", "5377 | \n", "6362 | \n", "
33.00 | \n", "942 | \n", "6366 | \n", "7528 | \n", "
34.00 | \n", "803 | \n", "7531 | \n", "8903 | \n", "
35.00 | \n", "601 | \n", "8908 | \n", "10532 | \n", "
36.00 | \n", "556 | \n", "10537 | \n", "12463 | \n", "
37.00 | \n", "565 | \n", "12466 | \n", "14730 | \n", "
38.00 | \n", "563 | \n", "14743 | \n", "17436 | \n", "
39.00 | \n", "422 | \n", "17443 | \n", "20610 | \n", "
40.00 | \n", "406 | \n", "20629 | \n", "24375 | \n", "
41.00 | \n", "346 | \n", "24405 | \n", "28839 | \n", "
42.00 | \n", "276 | \n", "28864 | \n", "34097 | \n", "
43.00 | \n", "231 | \n", "34126 | \n", "40296 | \n", "
44.00 | \n", "211 | \n", "40349 | \n", "47634 | \n", "
45.00 | \n", "142 | \n", "47773 | \n", "56179 | \n", "
46.00 | \n", "129 | \n", "56432 | \n", "66572 | \n", "
47.00 | \n", "99 | \n", "66743 | \n", "78676 | \n", "
48.00 | \n", "94 | \n", "78958 | \n", "92860 | \n", "
49.00 | \n", "58 | \n", "93911 | \n", "110017 | \n", "
50.00 | \n", "197 | \n", "110686 | \n", "2362234 | \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", "6.00 | \n", "5.33 | \n", "0.00 | \n", "5.33 | \n", "5.33 | \n", "5.33 | \n", "5.33 | \n", "5.33 | \n", "
bbc_co_uk | \n", "97.00 | \n", "12.83 | \n", "1.78 | \n", "0.88 | \n", "13.15 | \n", "13.15 | \n", "13.15 | \n", "13.15 | \n", "
breitbart_com | \n", "205.00 | \n", "8.36 | \n", "1.27 | \n", "0.72 | \n", "8.69 | \n", "8.69 | \n", "8.69 | \n", "8.69 | \n", "
brexitcentral_com | \n", "21.00 | \n", "4.41 | \n", "0.84 | \n", "0.77 | \n", "4.59 | \n", "4.59 | \n", "4.59 | \n", "4.59 | \n", "
buzzfeed_com | \n", "259.00 | \n", "11.80 | \n", "1.08 | \n", "2.81 | \n", "12.02 | \n", "12.02 | \n", "12.02 | \n", "12.02 | \n", "
cnn_com | \n", "193.00 | \n", "12.38 | \n", "1.79 | \n", "1.07 | \n", "12.89 | \n", "12.89 | \n", "12.89 | \n", "12.89 | \n", "
dailymail_co_uk | \n", "168.00 | \n", "11.49 | \n", "1.56 | \n", "0.99 | \n", "11.85 | \n", "11.85 | \n", "11.85 | \n", "11.85 | \n", "
economist_com | \n", "39.00 | \n", "7.31 | \n", "2.02 | \n", "0.53 | \n", "7.99 | \n", "7.99 | \n", "7.99 | \n", "7.99 | \n", "
evolvepolitics_com | \n", "54.00 | \n", "4.99 | \n", "0.60 | \n", "2.05 | \n", "5.13 | \n", "5.13 | \n", "5.13 | \n", "5.13 | \n", "
foxnews_com | \n", "180.00 | \n", "10.33 | \n", "1.35 | \n", "0.71 | \n", "10.61 | \n", "10.61 | \n", "10.61 | \n", "10.61 | \n", "
ft_com | \n", "99.00 | \n", "7.43 | \n", "1.97 | \n", "0.54 | \n", "8.14 | \n", "8.14 | \n", "8.14 | \n", "8.14 | \n", "
huffingtonpost_com | \n", "171.00 | \n", "10.74 | \n", "1.68 | \n", "0.74 | \n", "11.17 | \n", "11.17 | \n", "11.17 | \n", "11.17 | \n", "
independent_co_uk | \n", "140.00 | \n", "9.53 | \n", "1.85 | \n", "0.84 | \n", "10.07 | \n", "10.07 | \n", "10.07 | \n", "10.07 | \n", "
indy100_com | \n", "61.00 | \n", "7.04 | \n", "0.00 | \n", "7.04 | \n", "7.04 | \n", "7.04 | \n", "7.04 | \n", "7.04 | \n", "
libdemvoice_org | \n", "94.00 | \n", "4.67 | \n", "0.18 | \n", "3.53 | \n", "4.71 | \n", "4.71 | \n", "4.71 | \n", "4.71 | \n", "
mirror_co_uk | \n", "359.00 | \n", "8.45 | \n", "1.67 | \n", "1.37 | \n", "9.15 | \n", "9.15 | \n", "9.15 | \n", "9.15 | \n", "
nbcnews_com | \n", "101.00 | \n", "8.71 | \n", "1.12 | \n", "0.74 | \n", "8.93 | \n", "8.93 | \n", "8.93 | \n", "8.93 | \n", "
newstatesman_com | \n", "76.00 | \n", "6.09 | \n", "0.98 | \n", "1.48 | \n", "6.35 | \n", "6.35 | \n", "6.35 | \n", "6.35 | \n", "
npr_org | \n", "156.00 | \n", "8.95 | \n", "1.47 | \n", "0.63 | \n", "9.39 | \n", "9.39 | \n", "9.39 | \n", "9.39 | \n", "
nytimes_com | \n", "53.00 | \n", "12.51 | \n", "0.17 | \n", "11.28 | \n", "12.53 | \n", "12.53 | \n", "12.53 | \n", "12.53 | \n", "
order-order_com | \n", "153.00 | \n", "5.07 | \n", "1.36 | \n", "0.48 | \n", "5.29 | \n", "5.78 | \n", "5.78 | \n", "5.78 | \n", "
propublica_org | \n", "28.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", "79.00 | \n", "8.92 | \n", "2.20 | \n", "0.64 | \n", "9.66 | \n", "9.66 | \n", "9.66 | \n", "9.66 | \n", "
rt_com | \n", "148.00 | \n", "9.48 | \n", "2.01 | \n", "0.68 | \n", "10.17 | \n", "10.17 | \n", "10.17 | \n", "10.17 | \n", "
skwawkbox_org | \n", "97.00 | \n", "4.82 | \n", "0.73 | \n", "0.84 | \n", "5.03 | \n", "5.03 | \n", "5.03 | \n", "5.03 | \n", "
telegraph_co_uk | \n", "103.00 | \n", "9.95 | \n", "1.09 | \n", "2.37 | \n", "10.15 | \n", "10.15 | \n", "10.15 | \n", "10.15 | \n", "
thecanary_co | \n", "204.00 | \n", "4.84 | \n", "1.80 | \n", "0.93 | \n", "3.62 | \n", "6.21 | \n", "6.21 | \n", "6.21 | \n", "
theguardian_com | \n", "148.00 | \n", "11.44 | \n", "1.97 | \n", "1.01 | \n", "12.11 | \n", "12.11 | \n", "12.11 | \n", "12.11 | \n", "
thetimes_co_uk | \n", "71.00 | \n", "6.81 | \n", "0.28 | \n", "4.45 | \n", "6.84 | \n", "6.84 | \n", "6.84 | \n", "6.84 | \n", "
washingtonpost_com | \n", "81.00 | \n", "10.83 | \n", "2.33 | \n", "0.76 | \n", "11.42 | \n", "11.42 | \n", "11.42 | \n", "11.42 | \n", "
westmonster_com | \n", "66.00 | \n", "4.77 | \n", "1.24 | \n", "0.35 | \n", "5.22 | \n", "5.22 | \n", "5.22 | \n", "5.22 | \n", "
yournewswire_com | \n", "105.00 | \n", "5.82 | \n", "0.46 | \n", "3.79 | \n", "5.99 | \n", "5.99 | \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", "6.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
bbc_co_uk | \n", "12344.00 | \n", "0.65 | \n", "3.07 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "15.00 | \n", "
breitbart_com | \n", "2778.00 | \n", "0.79 | \n", "0.98 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "2.00 | \n", "2.00 | \n", "
brexitcentral_com | \n", "23.00 | \n", "0.78 | \n", "0.42 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
buzzfeed_com | \n", "2006.00 | \n", "0.22 | \n", "0.42 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "
cnn_com | \n", "3733.00 | \n", "2.54 | \n", "4.35 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "10.00 | \n", "10.00 | \n", "
dailymail_co_uk | \n", "24170.00 | \n", "0.58 | \n", "1.60 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "5.00 | \n", "
economist_com | \n", "533.00 | \n", "1.86 | \n", "1.46 | \n", "0.00 | \n", "0.00 | \n", "3.00 | \n", "3.00 | \n", "3.00 | \n", "
evolvepolitics_com | \n", "68.00 | \n", "0.94 | \n", "0.24 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
foxnews_com | \n", "6935.00 | \n", "0.64 | \n", "1.86 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "6.00 | \n", "
ft_com | \n", "3002.00 | \n", "0.66 | \n", "0.94 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "2.00 | \n", "2.00 | \n", "
huffingtonpost_com | \n", "11210.00 | \n", "0.48 | \n", "1.30 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "4.00 | \n", "
independent_co_uk | \n", "6236.00 | \n", "0.67 | \n", "1.25 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "3.00 | \n", "
indy100_com | \n", "528.00 | \n", "0.46 | \n", "0.50 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "
libdemvoice_org | \n", "95.00 | \n", "0.99 | \n", "0.10 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
mirror_co_uk | \n", "10541.00 | \n", "0.24 | \n", "0.43 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "
nbcnews_com | \n", "1891.00 | \n", "2.08 | \n", "2.00 | \n", "0.00 | \n", "0.00 | \n", "4.00 | \n", "4.00 | \n", "4.00 | \n", "
newstatesman_com | \n", "472.00 | \n", "0.74 | \n", "0.44 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
npr_org | \n", "2049.00 | \n", "1.46 | \n", "1.50 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "3.00 | \n", "3.00 | \n", "
nytimes_com | \n", "4857.00 | \n", "1.54 | \n", "2.31 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "5.00 | \n", "5.00 | \n", "
order-order_com | \n", "158.00 | \n", "0.78 | \n", "0.41 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
propublica_org | \n", "46.00 | \n", "0.85 | \n", "0.36 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
reuters_com | \n", "5228.00 | \n", "0.65 | \n", "0.94 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "2.00 | \n", "2.00 | \n", "
rt_com | \n", "2160.00 | \n", "1.06 | \n", "1.00 | \n", "0.00 | \n", "0.00 | \n", "2.00 | \n", "2.00 | \n", "2.00 | \n", "
skwawkbox_org | \n", "99.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
telegraph_co_uk | \n", "7340.00 | \n", "0.56 | \n", "0.90 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "2.00 | \n", "2.00 | \n", "
thecanary_co | \n", "225.00 | \n", "0.98 | \n", "0.15 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
theguardian_com | \n", "8376.00 | \n", "0.53 | \n", "1.14 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "3.00 | \n", "
thetimes_co_uk | \n", "8693.00 | \n", "0.06 | \n", "0.23 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "
washingtonpost_com | \n", "22061.00 | \n", "0.21 | \n", "0.77 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "3.00 | \n", "
westmonster_com | \n", "306.00 | \n", "0.27 | \n", "0.45 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "
yournewswire_com | \n", "222.00 | \n", "0.06 | \n", "0.24 | \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_max_engagements_per_min_time | \n", "fb_comments | \n", "fb_reactions | \n", "fb_shares | \n", "... | \n", "fb_brand_page | \n", "fb_brand_page_likes | \n", "fb_brand_page_time | \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", " |
5bc8df6cf7ba6fda075fdec7a8a27e5b00a054fb | \n", "http://www.bbc.co.uk/news/world-europe-40965581 | \n", "Injuries as van hits crowds in Barcelona | \n", "2017-08-17 15:21:04.046 | \n", "2017-08-17 15:19:47.000 | \n", "173441 | \n", "675.67 | \n", "2017-08-17T17:10:00.551Z | \n", "35777 | \n", "107789 | \n", "29875 | \n", "... | \n", "True | \n", "43501654.00 | \n", "2017-08-17T21:03:24.000Z | \n", "96 | \n", "50.00 | \n", "20.00 | \n", "9.00 | \n", "15.00 | \n", "44.00 | \n", "94.00 | \n", "
f9a431a718aea4611db8680cb9a2b32935932221 | \n", "https://www.buzzfeed.com/anupkaphle/south-asia... | \n", "South Asia Is Also Experiencing The Worst Floo... | \n", "2017-08-29 10:21:13.664 | \n", "2017-08-29 09:38:35.000 | \n", "405094 | \n", "182.59 | \n", "2017-08-30T01:03:59.596Z | \n", "29194 | \n", "303992 | \n", "71908 | \n", "... | \n", "True | \n", "2663443.00 | \n", "2017-09-03T00:10:00.000Z | \n", "147 | \n", "50.00 | \n", "19.00 | \n", "14.00 | \n", "11.00 | \n", "44.00 | \n", "94.00 | \n", "
9d3d837c118469c6be614d62b79ccc67d4222ed6 | \n", "http://www.cnn.com/2017/08/20/asia/us-navy-des... | \n", "US destroyer collides with merchant ship near ... | \n", "2017-08-21 00:03:14.430 | \n", "2017-08-20 23:58:37.000 | \n", "137608 | \n", "267.58 | \n", "2017-08-21T02:27:59.624Z | \n", "42828 | \n", "72468 | \n", "22312 | \n", "... | \n", "True | \n", "28047682.00 | \n", "2017-08-21T00:30:29.000Z | \n", "105 | \n", "50.00 | \n", "20.00 | \n", "9.00 | \n", "15.00 | \n", "44.00 | \n", "94.00 | \n", "
2f7b62a0d2a4675bfaa7b32ec314ce5acf001ac9 | \n", "http://www.cnn.com/2017/08/12/us/charlottesvil... | \n", "Torch-bearing white nationalists march ahead o... | \n", "2017-08-12 06:27:27.189 | \n", "2017-08-12 06:22:15.000 | \n", "422742 | \n", "704.31 | \n", "2017-08-12T16:41:59.688Z | \n", "117325 | \n", "250533 | \n", "54884 | \n", "... | \n", "True | \n", "28007316.00 | \n", "2017-08-12T16:32:58.000Z | \n", "105 | \n", "50.00 | \n", "20.00 | \n", "9.00 | \n", "15.00 | \n", "44.00 | \n", "94.00 | \n", "
5c22bca605c658ebd6d1afbadd26884feb2f2fb4 | \n", "https://www.buzzfeed.com/davidmack/ehs-cheerle... | \n", "Police Are Investigating This Video Of A Teen ... | \n", "2017-08-24 15:30:12.427 | \n", "2017-08-24 15:04:18.000 | \n", "117849 | \n", "170.40 | \n", "2017-08-24T17:33:59.839Z | \n", "35187 | \n", "70329 | \n", "12333 | \n", "... | \n", "True | \n", "2649391.00 | \n", "2017-08-24T23:34:00.000Z | \n", "147 | \n", "50.00 | \n", "19.00 | \n", "13.00 | \n", "11.00 | \n", "43.00 | \n", "93.00 | \n", "
8e3d4660760facbf3164d02034b7b726ffd7716b | \n", "https://www.buzzfeed.com/kristinharris/taylor-... | \n", "Taylor Swift Just Announced Her New Album And ... | \n", "2017-08-23 18:05:10.321 | \n", "2017-08-23 17:02:32.000 | \n", "112303 | \n", "878.50 | \n", "2017-08-23T19:06:02.548Z | \n", "21292 | \n", "82021 | \n", "8990 | \n", "... | \n", "True | \n", "2646799.00 | \n", "2017-08-23T18:02:40.000Z | \n", "147 | \n", "50.00 | \n", "19.00 | \n", "13.00 | \n", "11.00 | \n", "43.00 | \n", "93.00 | \n", "
2a7d9f5e137fe37f993840df08c956a63ea8a9f1 | \n", "http://www.cnn.com/2017/08/25/us/hurricane-har... | \n", "Hurricane Harvey strengthens to Category 2 | \n", "2017-08-25 06:18:13.423 | \n", "2017-08-25 06:15:26.000 | \n", "168217 | \n", "305.26 | \n", "2017-08-25T16:54:00.927Z | \n", "38640 | \n", "111205 | \n", "18372 | \n", "... | \n", "True | \n", "28100799.00 | \n", "2017-08-25T06:45:02.000Z | \n", "105 | \n", "50.00 | \n", "20.00 | \n", "8.00 | \n", "15.00 | \n", "43.00 | \n", "93.00 | \n", "
f5f4bbb52b32df81f30e9f83cb79fd090c90b048 | \n", "http://www.cnn.com/2017/08/31/us/hurricane-irm... | \n", "Powerful Hurricane Irma could be next weather ... | \n", "2017-08-31 23:09:18.131 | \n", "2017-08-31 23:04:08.000 | \n", "155332 | \n", "295.08 | \n", "2017-09-01T03:14:00.674Z | \n", "30702 | \n", "95261 | \n", "29369 | \n", "... | \n", "True | \n", "28173209.00 | \n", "2017-09-01T03:00:46.000Z | \n", "105 | \n", "50.00 | \n", "20.00 | \n", "8.00 | \n", "15.00 | \n", "43.00 | \n", "93.00 | \n", "
513f414d516e4d00495c7d9bf28359787432cbd5 | \n", "http://www.cnn.com/2017/08/03/politics/mueller... | \n", "One year into the FBI's Russia investigation, ... | \n", "2017-08-03 20:03:27.148 | \n", "2017-08-03 19:59:07.000 | \n", "96561 | \n", "427.50 | \n", "2017-08-03T21:16:03.290Z | \n", "19602 | \n", "66142 | \n", "10817 | \n", "... | \n", "True | \n", "27957228.00 | \n", "2017-08-03T20:07:04.000Z | \n", "105 | \n", "49.00 | \n", "20.00 | \n", "8.00 | \n", "15.00 | \n", "43.00 | \n", "92.00 | \n", "
112452b06d5c5258740297738f9e06d00aa9c9b5 | \n", "http://www.cnn.com/2017/08/20/entertainment/je... | \n", "Comedian Jerry Lewis dies at 91, publicist says | \n", "2017-08-20 18:36:11.103 | \n", "2017-08-20 18:33:48.000 | \n", "79243 | \n", "145.03 | \n", "2017-08-20T19:14:01.425Z | \n", "9078 | \n", "52326 | \n", "17839 | \n", "... | \n", "True | \n", "28046550.00 | \n", "2017-08-20T18:36:25.000Z | \n", "105 | \n", "48.00 | \n", "20.00 | \n", "9.00 | \n", "15.00 | \n", "44.00 | \n", "92.00 | \n", "
792373740c48788621261190c2aa513bcbb30584 | \n", "http://www.cnn.com/2017/08/18/politics/heather... | \n", "Mother of Charlottesville victim says she won'... | \n", "2017-08-18 12:30:19.614 | \n", "2017-08-18 12:23:01.000 | \n", "89112 | \n", "280.08 | \n", "2017-08-18T13:46:01.819Z | \n", "16659 | \n", "65132 | \n", "7321 | \n", "... | \n", "True | \n", "28038684.00 | \n", "2017-08-18T13:00:13.000Z | \n", "105 | \n", "48.00 | \n", "20.00 | \n", "8.00 | \n", "15.00 | \n", "43.00 | \n", "91.00 | \n", "
ff28c43982b9fbace7a7037fedee1ee77de2c288 | \n", "http://www.cnn.com/2017/08/23/politics/donald-... | \n", "Exclusive: Top Trump aide's email draws new sc... | \n", "2017-08-23 23:08:52.155 | \n", "2017-08-23 23:00:30.000 | \n", "70927 | \n", "727.59 | \n", "2017-08-24T01:10:00.187Z | \n", "11787 | \n", "48412 | \n", "10728 | \n", "... | \n", "True | \n", "28096369.00 | \n", "2017-08-23T23:17:40.000Z | \n", "105 | \n", "47.00 | \n", "20.00 | \n", "9.00 | \n", "15.00 | \n", "44.00 | \n", "91.00 | \n", "
7e11b41f3b01e4600644f96180e797a0ee4d8fa2 | \n", "http://www.cnn.com/2017/08/25/politics/sheriff... | \n", "Trump pardons former Sheriff Joe Arpaio | \n", "2017-08-26 00:12:13.114 | \n", "2017-08-26 00:08:53.000 | \n", "367691 | \n", "1471.54 | \n", "2017-08-26T00:38:01.696Z | \n", "109735 | \n", "227193 | \n", "30763 | \n", "... | \n", "True | \n", "28106048.00 | \n", "2017-08-26T00:17:16.000Z | \n", "105 | \n", "50.00 | \n", "20.00 | \n", "6.00 | \n", "15.00 | \n", "41.00 | \n", "91.00 | \n", "
814b1b017e3be7459408e36be2a5206f4c348631 | \n", "http://www.bbc.co.uk/news/world-us-canada-4094... | \n", "Trump stance on Charlottesville violence anger... | \n", "2017-08-16 10:03:07.016 | \n", "2017-08-16 10:00:31.000 | \n", "62964 | \n", "149.17 | \n", "2017-08-17T01:58:00.704Z | \n", "3159 | \n", "56289 | \n", "3516 | \n", "... | \n", "True | \n", "43487706.00 | \n", "2017-08-17T01:00:32.000Z | \n", "96 | \n", "46.00 | \n", "20.00 | \n", "10.00 | \n", "15.00 | \n", "45.00 | \n", "91.00 | \n", "
9157b50690c17e478aae8c0cbbfbb9c3db6b038c | \n", "https://www.buzzfeed.com/tahliapritchard/wtf-l... | \n", "Anna Faris And Chris Pratt Have Separated And ... | \n", "2017-08-07 04:15:07.564 | \n", "2017-08-07 03:51:14.000 | \n", "394990 | \n", "1458.83 | \n", "2017-08-07T04:28:02.423Z | \n", "96493 | \n", "268928 | \n", "29569 | \n", "... | \n", "True | \n", "2628374.00 | \n", "2017-08-07T04:12:23.000Z | \n", "147 | \n", "50.00 | \n", "19.00 | \n", "11.00 | \n", "11.00 | \n", "41.00 | \n", "91.00 | \n", "
f52d21c6a22899376b57b365c99a4523b7cad841 | \n", "http://www.cnn.com/2017/08/19/us/uss-indianapo... | \n", "USS Indianapolis wreckage found after 72 years | \n", "2017-08-19 21:48:54.983 | \n", "2017-08-19 21:42:53.000 | \n", "74720 | \n", "143.53 | \n", "2017-08-20T09:04:00.053Z | \n", "8148 | \n", "54663 | \n", "11909 | \n", "... | \n", "True | \n", "28043784.00 | \n", "2017-08-19T23:00:09.000Z | \n", "105 | \n", "47.00 | \n", "20.00 | \n", "9.00 | \n", "15.00 | \n", "44.00 | \n", "91.00 | \n", "
01df60472742a7c78b459655420a8853276dc27d | \n", "http://www.cnn.com/2017/08/15/politics/trump-n... | \n", "A Trump meltdown for the ages | \n", "2017-08-16 00:09:12.292 | \n", "2017-08-16 00:04:13.000 | \n", "91711 | \n", "122.42 | \n", "2017-08-16T02:36:01.474Z | \n", "25210 | \n", "57318 | \n", "9183 | \n", "... | \n", "True | \n", "28025271.00 | \n", "2017-08-16T07:31:02.000Z | \n", "105 | \n", "48.00 | \n", "20.00 | \n", "8.00 | \n", "15.00 | \n", "43.00 | \n", "91.00 | \n", "
4ec50c8407848cb16f316e3e0c2e14aaa304d179 | \n", "http://www.cnn.com/2017/08/12/us/charlottesvil... | \n", "Charlottesville Car Crash Suspect ID'd | \n", "2017-08-13 00:48:16.687 | \n", "2017-08-13 00:44:39.000 | \n", "58241 | \n", "386.00 | \n", "2017-08-13T01:26:00.541Z | \n", "18589 | \n", "33135 | \n", "6517 | \n", "... | \n", "True | \n", "28009351.00 | \n", "2017-08-13T01:13:53.000Z | \n", "105 | \n", "46.00 | \n", "20.00 | \n", "9.00 | \n", "15.00 | \n", "44.00 | \n", "90.00 | \n", "
b22459b17924232209165651ca966817e62bae0d | \n", "http://www.huffingtonpost.com/entry/mother-of-... | \n", "Mother Of Charlottesville Victim Heather Heyer... | \n", "2017-08-13 17:18:10.345 | \n", "2017-08-13 17:13:55.007 | \n", "362776 | \n", "1219.61 | \n", "2017-08-13T18:31:59.604Z | \n", "18095 | \n", "319256 | \n", "25425 | \n", "... | \n", "True | \n", "9667599.00 | \n", "2017-08-13T18:15:02.000Z | \n", "215 | \n", "50.00 | \n", "17.00 | \n", "10.00 | \n", "13.00 | \n", "40.00 | \n", "90.00 | \n", "
eb1ea0977d72adf0202b9b664a4a654518e1ce9d | \n", "http://www.huffingtonpost.com/entry/boston-ral... | \n", "Provocative ‘Free Speech’ Rally In Boston Rail... | \n", "2017-08-19 15:18:14.650 | \n", "2017-08-19 15:12:13.499 | \n", "179591 | \n", "984.25 | \n", "2017-08-19T18:46:01.039Z | \n", "13594 | \n", "156017 | \n", "9980 | \n", "... | \n", "True | \n", "9688346.00 | \n", "2017-08-19T15:30:14.000Z | \n", "215 | \n", "50.00 | \n", "17.00 | \n", "10.00 | \n", "13.00 | \n", "40.00 | \n", "90.00 | \n", "
6e2393cf8bac39690bf4b94992ccfba6db274864 | \n", "http://money.cnn.com/2017/08/01/media/rod-whee... | \n", "Lawsuit: Fox News concocted Seth Rich story wi... | \n", "2017-08-01 15:05:04.309 | \n", "2017-08-01 14:57:38.000 | \n", "81594 | \n", "6806.29 | \n", "2017-08-25T05:16:00.976Z | \n", "23323 | \n", "42758 | \n", "15513 | \n", "... | \n", "True | \n", "27943487.00 | \n", "2017-08-01T15:14:04.000Z | \n", "105 | \n", "48.00 | \n", "20.00 | \n", "7.00 | \n", "15.00 | \n", "42.00 | \n", "90.00 | \n", "
a5a37e29d0b2e7640e19f583868777c1493555e3 | \n", "http://www.cnn.com/2017/08/17/europe/barcelona... | \n", "Barcelona: Van hits crowd near Las Ramblas tou... | \n", "2017-08-17 15:30:14.333 | \n", "2017-08-17 15:25:03.000 | \n", "111971 | \n", "318.36 | \n", "2017-08-18T15:08:00.299Z | \n", "19298 | \n", "75050 | \n", "17623 | \n", "... | \n", "True | \n", "28034233.00 | \n", "2017-08-17T15:54:05.000Z | \n", "105 | \n", "50.00 | \n", "20.00 | \n", "5.00 | \n", "15.00 | \n", "40.00 | \n", "90.00 | \n", "
e2e204c9d6597400ca2e5de9814a6fda4c4bfe70 | \n", "http://www.bbc.co.uk/news/world-latin-america-... | \n", "Brazil opens vast Amazon reserve to mining | \n", "2017-08-24 01:00:02.079 | \n", "2017-08-24 00:58:16.000 | \n", "59106 | \n", "63.31 | \n", "2017-08-24T14:41:14.857Z | \n", "5037 | \n", "48396 | \n", "5673 | \n", "... | \n", "True | \n", "43604821.00 | \n", "2017-08-24T10:31:05.000Z | \n", "96 | \n", "46.00 | \n", "20.00 | \n", "9.00 | \n", "15.00 | \n", "44.00 | \n", "90.00 | \n", "
f828a5f05babd9e0649d18d84b772da0e7ef8401 | \n", "https://www.buzzfeed.com/katebubacz/17-photos-... | \n", "17 Photos Show Just How Bad The Flooding In Ho... | \n", "2017-08-29 13:36:12.544 | \n", "2017-08-29 13:35:39.000 | \n", "517210 | \n", "379.25 | \n", "2017-08-31T09:05:59.786Z | \n", "78481 | \n", "363072 | \n", "75657 | \n", "... | \n", "True | \n", "2658046.00 | \n", "2017-08-29T19:47:00.000Z | \n", "147 | \n", "50.00 | \n", "19.00 | \n", "10.00 | \n", "11.00 | \n", "40.00 | \n", "90.00 | \n", "
098aede0a3d2b2599c5b811ccd9753b831bad17e | \n", "http://www.bbc.co.uk/news/world-us-canada-4098... | \n", "Top White House aide Bannon out | \n", "2017-08-18 16:57:02.011 | \n", "2017-08-18 16:55:20.000 | \n", "71003 | \n", "710.07 | \n", "2017-08-18T17:10:02.373Z | \n", "14694 | \n", "48131 | \n", "8178 | \n", "... | \n", "True | \n", "43515983.00 | \n", "2017-08-18T16:59:10.000Z | \n", "96 | \n", "47.00 | \n", "20.00 | \n", "7.00 | \n", "15.00 | \n", "42.00 | \n", "89.00 | \n", "
2fce23ab50ee1745425b42e66c742e9825e48a23 | \n", "http://www.cnn.com/2017/08/23/politics/james-c... | \n", "James Clapper questions Trump's fitness for of... | \n", "2017-08-23 05:12:20.942 | \n", "2017-08-23 05:09:07.000 | \n", "78220 | \n", "246.93 | \n", "2017-08-23T13:26:01.041Z | \n", "11993 | \n", "55529 | \n", "10698 | \n", "... | \n", "True | \n", "28095696.00 | \n", "2017-08-23T10:00:43.000Z | \n", "105 | \n", "47.00 | \n", "20.00 | \n", "7.00 | \n", "15.00 | \n", "42.00 | \n", "89.00 | \n", "
a0bdb495002919e09d1914f3bb24dcf4d5cbc08d | \n", "https://www.buzzfeed.com/franciswhittaker/hund... | \n", "Hundreds Of Torch-Wielding White Nationalists ... | \n", "2017-08-12 11:24:16.334 | \n", "2017-08-12 11:13:01.000 | \n", "188331 | \n", "558.53 | \n", "2017-08-12T17:41:59.747Z | \n", "31255 | \n", "144074 | \n", "13002 | \n", "... | \n", "True | \n", "2637450.00 | \n", "2017-08-12T12:21:00.000Z | \n", "147 | \n", "50.00 | \n", "19.00 | \n", "9.00 | \n", "11.00 | \n", "39.00 | \n", "89.00 | \n", "
31ef7cec6f7147227efec4dd20fc6b8a41a10335 | \n", "http://www.cnn.com/2017/08/08/politics/trump-r... | \n", "Trump retweets Fox News story containing class... | \n", "2017-08-08 14:45:16.587 | \n", "2017-08-08 14:43:33.000 | \n", "60213 | \n", "207.37 | \n", "2017-08-08T16:48:00.411Z | \n", "17783 | \n", "32555 | \n", "9875 | \n", "... | \n", "True | \n", "27979804.00 | \n", "2017-08-08T16:30:54.000Z | \n", "105 | \n", "46.00 | \n", "20.00 | \n", "8.00 | \n", "15.00 | \n", "43.00 | \n", "89.00 | \n", "
2d0ddfd661c23998c276541a016b256730b8ca1b | \n", "http://www.cnn.com/2017/08/09/politics/north-k... | \n", "North Korea 'seriously examining' a strike dir... | \n", "2017-08-09 22:51:15.957 | \n", "2017-08-09 22:46:41.000 | \n", "46202 | \n", "69.01 | \n", "2017-08-10T00:18:01.784Z | \n", "15566 | \n", "23075 | \n", "7561 | \n", "... | \n", "True | \n", "27991392.00 | \n", "2017-08-10T07:00:02.000Z | \n", "105 | \n", "44.00 | \n", "20.00 | \n", "9.00 | \n", "15.00 | \n", "44.00 | \n", "88.00 | \n", "
be905b7cba28714bc3ad434ada164772afed06de | \n", "https://www.nytimes.com/2017/08/01/us/politics... | \n", "Justice Dept. to Take On Affirmative Action in... | \n", "2017-08-02 00:09:00.463 | \n", "2017-08-02 00:06:27.000 | \n", "292124 | \n", "663.59 | \n", "2017-08-02T01:10:00.882Z | \n", "71964 | \n", "173472 | \n", "46688 | \n", "... | \n", "True | \n", "14358478.00 | \n", "2017-08-02T00:13:17.000Z | \n", "120 | \n", "50.00 | \n", "20.00 | \n", "4.00 | \n", "14.00 | \n", "38.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", "
ea230b14069c1fe526e7f42d4f4ba7c38bbc88cf | \n", "http://www.dailymail.co.uk/tvshowbiz/article-4... | \n", "Roxy Jacenko makes light of her rough year | \n", "2017-08-28 05:30:16.907 | \n", "2017-08-28 05:27:23.000 | \n", "0 | \n", "0.00 | \n", "2017-08-28T05:44:01.142Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "158 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
feff1a6e1719b32589f732d78f0674b16eda7362 | \n", "http://www.dailymail.co.uk/news/article-480178... | \n", "Footage emerges police pursuing three teens in... | \n", "2017-08-18 08:57:15.138 | \n", "2017-08-18 08:52:22.000 | \n", "1 | \n", "0.02 | \n", "2017-08-18T14:20:02.194Z | \n", "0 | \n", "0 | \n", "1 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "158 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
09adeb0c3ea57cca3be66948b344ae5f11d9fd9c | \n", "https://www.washingtonpost.com/sports/wizards/... | \n", "AP source: Pelicans get Clark on 1-year deal a... | \n", "2017-08-02 14:30:10.098 | \n", "2017-08-02 14:27:18.000 | \n", "0 | \n", "0.00 | \n", "2017-08-03T00:02:01.056Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
2449b63cc77bb3703652f186d50c61471d5e5413 | \n", "http://www.bbc.co.uk/news/av/world-middle-east... | \n", "Syria: Fighters and families leave Lebanese bo... | \n", "2017-08-02 14:27:04.281 | \n", "2017-08-02 14:24:42.000 | \n", "0 | \n", "0.00 | \n", "2017-08-03T02:02:00.328Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "96 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
2871dd160a1d8304572bd7252fbc453570d8e6c4 | \n", "http://www.dailymail.co.uk/tvshowbiz/article-4... | \n", "Bachelor Leah Costa spruiking whitening on Ins... | \n", "2017-08-18 08:39:16.278 | \n", "2017-08-18 08:36:48.000 | \n", "0 | \n", "0.00 | \n", "2017-08-18T10:56:01.931Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "158 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
e7bff28fd2679057599d7ed22b60c38c4180a063 | \n", "https://www.washingtonpost.com/sports/colleges... | \n", "Stadium Formerly Known as Turner Field begins ... | \n", "2017-08-28 06:03:08.409 | \n", "2017-08-28 05:55:27.000 | \n", "0 | \n", "0.00 | \n", "2017-08-28T06:16:01.250Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
e0e12393c45c788a21b219e7f11514e3259d6516 | \n", "https://www.washingtonpost.com/politics/estima... | \n", "Estimates of North Korea’s nuclear weapons har... | \n", "2017-08-18 08:30:02.897 | \n", "2017-08-18 08:24:12.000 | \n", "0 | \n", "0.00 | \n", "2017-08-18T11:50:01.962Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
41585d376ffd7791f8c499de2dfdff11d10c3c60 | \n", "https://www.theguardian.com/education/2017/aug... | \n", "Clearing: how to book a campus visit | \n", "2017-08-18 08:03:00.966 | \n", "2017-08-18 08:00:18.000 | \n", "0 | \n", "0.00 | \n", "2017-08-18T11:22:02.489Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "142 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
922ae172676d3ac344c7271f1f474babc439fb4b | \n", "https://www.washingtonpost.com/world/asia_paci... | \n", "IS cleric granted early release in Indonesia i... | \n", "2017-08-18 08:09:10.806 | \n", "2017-08-18 08:02:17.000 | \n", "1 | \n", "0.08 | \n", "2017-08-18T10:38:01.961Z | \n", "0 | \n", "0 | \n", "1 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
3da538b715310642f0052392dd4a2dcbb1970a28 | \n", "https://www.washingtonpost.com/world/europe/2-... | \n", "2 bears, not 1, killed Swedish wildlife park e... | \n", "2017-08-18 08:09:10.617 | \n", "2017-08-18 08:04:14.000 | \n", "0 | \n", "0.00 | \n", "2017-08-18T11:28:03.101Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
94d289cea79893321d4e461b6b6f3dad2ff0c55b | \n", "http://www.huffingtonpost.com/entry/when-the-c... | \n", "When the City Went Dark | \n", "2017-08-18 08:18:15.815 | \n", "2017-08-18 08:06:36.831 | \n", "0 | \n", "0.00 | \n", "2017-08-18T11:38:02.348Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "215 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
5ec7b3f8d818d6fd77eb5cef16779a709f7e2792 | \n", "https://www.washingtonpost.com/national/ap-pho... | \n", "AP PHOTOS: Editor selections from the past wee... | \n", "2017-08-28 06:48:09.793 | \n", "2017-08-28 06:04:09.000 | \n", "0 | \n", "0.00 | \n", "2017-08-28T07:02:01.176Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
534aceb294e07e723db4511fe18de4e24010daef | \n", "https://www.washingtonpost.com/sports/dcunited... | \n", "Jackson-Hamel scores late to rally Impact past... | \n", "2017-08-06 04:18:06.971 | \n", "2017-08-06 04:15:11.000 | \n", "0 | \n", "0.00 | \n", "2017-08-07T03:16:00.321Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
bae1995a13356f0253db5122dd5677a29737b7b3 | \n", "https://www.washingtonpost.com/sports/redskins... | \n", "As he so often did on the field, LT stole the ... | \n", "2017-08-06 04:18:07.131 | \n", "2017-08-06 04:10:52.000 | \n", "0 | \n", "0.00 | \n", "2017-08-07T03:16:00.322Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
5876875e2c6c0b653ce4b13d120d5aa1c4b260d9 | \n", "https://www.washingtonpost.com/world/europe/au... | \n", "Austrians first in Europe to make bacon on ind... | \n", "2017-08-18 08:21:06.251 | \n", "2017-08-18 08:16:11.000 | \n", "0 | \n", "0.00 | \n", "2017-08-18T11:40:02.479Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
848a780fc988417184a63cf9fae5fec626700494 | \n", "https://www.washingtonpost.com/national/health... | \n", "APNewsBreak: Judge retires after leave for alc... | \n", "2017-08-02 14:30:11.544 | \n", "2017-08-02 14:23:16.000 | \n", "1 | \n", "0.02 | \n", "2017-08-02T18:52:01.387Z | \n", "0 | \n", "0 | \n", "1 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
f1878be211ca091760999efaa1376302dff74b4c | \n", "http://www.huffingtonpost.com/entry/keeping-st... | \n", "Keeping Student Loan Debt Manageable | \n", "2017-08-18 08:33:19.258 | \n", "2017-08-18 08:24:09.443 | \n", "0 | \n", "0.00 | \n", "2017-08-18T13:56:01.615Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "215 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
0c59cf32da069488867a72869d4b0aa6715b12e6 | \n", "https://www.washingtonpost.com/world/africa/si... | \n", "Sierra Leone mudslides death toll now above 40... | \n", "2017-08-18 08:30:09.886 | \n", "2017-08-18 08:28:19.000 | \n", "0 | \n", "0.00 | \n", "2017-08-18T11:50:01.976Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
1656ad7fc35b3762dd6e8ed3df3fc28d5505984d | \n", "http://www.huffingtonpost.com/entry/8-common-c... | \n", "8 Common Cover Letter Mistakes To Avoid | \n", "2017-08-18 08:48:21.492 | \n", "2017-08-18 08:36:12.612 | \n", "1 | \n", "0.00 | \n", "2017-08-18T14:12:00.928Z | \n", "0 | \n", "0 | \n", "1 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "215 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
8e142110e7b53e0939ddd4fee7c6cfd77887fc9f | \n", "https://www.washingtonpost.com/world/asia_paci... | \n", "The Latest: Disagreements in ASEAN delay joint... | \n", "2017-08-06 04:09:09.650 | \n", "2017-08-06 04:06:28.000 | \n", "1 | \n", "0.02 | \n", "2017-08-06T19:52:00.178Z | \n", "0 | \n", "0 | \n", "1 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
ec63335baa0d359e0a21ec3d739f60b12cbb3744 | \n", "http://www.telegraph.co.uk/travel/destinations... | \n", "Taj Jai Mahal Palace | \n", "2017-08-18 08:33:00.274 | \n", "2017-08-18 08:30:11.000 | \n", "0 | \n", "0.00 | \n", "2017-08-18T13:56:00.979Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "370 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
9bbfbfa88f510e893f9cd9351feeb2e804ed653b | \n", "https://www.washingtonpost.com/world/europe/it... | \n", "Italian authorities sequester German group’s r... | \n", "2017-08-02 14:33:09.928 | \n", "2017-08-02 14:24:18.000 | \n", "0 | \n", "0.00 | \n", "2017-08-03T00:03:59.812Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
d691879d8e93adaac69382b77139e947e78d2900 | \n", "https://www.theguardian.com/artanddesign/2017/... | \n", "Giacometti and Rashid Johnson: this week’s bes... | \n", "2017-08-18 08:33:01.161 | \n", "2017-08-18 08:30:18.000 | \n", "1 | \n", "0.08 | \n", "2017-08-18T08:46:01.439Z | \n", "0 | \n", "0 | \n", "1 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "142 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
916d02e97272090b68aa4a7f174db860e599f8f0 | \n", "https://www.washingtonpost.com/world/africa/si... | \n", "Sierra Leone mudslides death toll now above 40... | \n", "2017-08-18 08:42:12.821 | \n", "2017-08-18 08:30:50.000 | \n", "0 | \n", "0.00 | \n", "2017-08-18T11:00:02.361Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
144b7032d6d5f4c5bf515120000b20c449076201 | \n", "http://www.telegraph.co.uk/films/2017/08/18/br... | \n", "Brad Pitt loses court case after failing to pa... | \n", "2017-08-18 08:36:00.369 | \n", "2017-08-18 08:31:26.000 | \n", "0 | \n", "0.00 | \n", "2017-08-18T12:58:00.255Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "370 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
87dcccefc3866303de4d1ce37bcf1752cbaa6393 | \n", "http://www.bbc.co.uk/news/uk-england-dorset-40... | \n", "Bournemouth flats 'fake bomb': Man charged | \n", "2017-08-18 08:36:02.405 | \n", "2017-08-18 08:33:39.000 | \n", "0 | \n", "0.00 | \n", "2017-08-18T12:58:01.643Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "96 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
895ce04b567747b53e4019158f2eeb2096ec5084 | \n", "https://www.washingtonpost.com/world/asia_paci... | \n", "Vietnam battles dengue outbreaks with 42 perce... | \n", "2017-08-18 08:42:11.430 | \n", "2017-08-18 08:34:13.000 | \n", "0 | \n", "0.00 | \n", "2017-08-18T11:00:02.358Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
363e164d7ef68963ee54da261b3b40bcfabadbea | \n", "https://www.washingtonpost.com/sports/redskins... | \n", "FANTASY PLAYS: Prospects for old faces in new ... | \n", "2017-08-28 06:03:15.513 | \n", "2017-08-28 05:57:18.000 | \n", "0 | \n", "0.00 | \n", "2017-08-28T06:16:01.257Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
e62c5553a5f0b912f2467075cb7c21e266f85e9f | \n", "https://www.washingtonpost.com/world/europe/ca... | \n", "Catalan regional president: at least one more ... | \n", "2017-08-18 08:42:12.091 | \n", "2017-08-18 08:36:09.000 | \n", "0 | \n", "0.00 | \n", "2017-08-18T11:00:02.360Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "191 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
084a7ac1c07cb222a7aa283f5b6d84d484cb54ec | \n", "https://www.theguardian.com/crosswords/crosswo... | \n", "Crossword blog: Cracking the Cryptics in real-... | \n", "2017-08-21 09:51:00.501 | \n", "2017-08-21 09:48:42.000 | \n", "1 | \n", "0.02 | \n", "2017-08-21T18:20:00.629Z | \n", "0 | \n", "0 | \n", "1 | \n", "... | \n", "False | \n", "nan | \n", "NaN | \n", "142 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
148391 rows × 25 columns
\n", "\n", " | url | \n", "headline | \n", "discovered | \n", "published | \n", "fb_engagements | \n", "fb_max_engagements_per_min | \n", "fb_max_engagements_per_min_time | \n", "fb_comments | \n", "fb_reactions | \n", "fb_shares | \n", "... | \n", "fb_brand_page_likes | \n", "fb_brand_page_time | \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", " |
a96c040af2ed0a2561a1bf0f4c19297f271ae3ed | \n", "http://www.bbc.co.uk/news/world-europe-41057304 | \n", "Man shot after attacking Brussels troops | \n", "2017-08-25 19:33:00.838 | \n", "2017-08-25 19:30:37 | \n", "0 | \n", "147.96 | \n", "2017-08-25T21:10:02.357Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "43641284.00 | \n", "2017-08-25T19:37:22.000Z | \n", "96 | \n", "0.00 | \n", "20.00 | \n", "10.00 | \n", "15.00 | \n", "45.00 | \n", "45.00 | \n", "45.00 | \n", "
5dd70fc9ea42b2d127033bcd64660f1940030c92 | \n", "http://www.bbc.co.uk/news/world-europe-40982926 | \n", "Key Barcelona attack suspect confirmed dead | \n", "2017-08-18 20:30:03.116 | \n", "2017-08-18 20:29:14 | \n", "0 | \n", "1668.82 | \n", "2017-08-19T21:52:00.484Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "43518815.00 | \n", "2017-08-18T20:35:08.000Z | \n", "96 | \n", "0.00 | \n", "20.00 | \n", "10.00 | \n", "15.00 | \n", "45.00 | \n", "45.00 | \n", "45.00 | \n", "
a891d138c2bcf31d948afcfb856a59f991d78e4f | \n", "http://www.bbc.co.uk/news/world-us-canada-4090... | \n", "Trump: US 'locked and loaded' on N Korea | \n", "2017-08-11 11:42:01.493 | \n", "2017-08-11 11:39:05 | \n", "0 | \n", "2549.83 | \n", "2017-08-12T19:19:59.811Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "43416675.00 | \n", "2017-08-11T11:48:41.000Z | \n", "96 | \n", "0.00 | \n", "20.00 | \n", "8.00 | \n", "15.00 | \n", "43.00 | \n", "43.00 | \n", "43.00 | \n", "
7871898fe8e346056041debe5afffde02118dd33 | \n", "https://www.buzzfeed.com/melissasegura/sixteen... | \n", "Sixteen Years Ago He Was Granted A New Hearing... | \n", "2017-08-25 09:51:14.099 | \n", "2017-08-23 01:44:46 | \n", "0 | \n", "0.00 | \n", "2017-08-25T10:04:01.518Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "2650108.00 | \n", "2017-08-25T14:48:20.000Z | \n", "147 | \n", "0.00 | \n", "19.00 | \n", "13.00 | \n", "11.00 | \n", "43.00 | \n", "43.00 | \n", "43.00 | \n", "
2eee49e0cf12b7f87a2cdafb4cabfd17bdb53965 | \n", "https://www.buzzfeed.com/borzoudaragahi/these-... | \n", "These Are The Western Fighters Who Volunteered... | \n", "2017-08-13 14:06:14.093 | \n", "2017-08-09 14:00:57 | \n", "1 | \n", "0.08 | \n", "2017-08-13T14:20:01.132Z | \n", "0 | \n", "0 | \n", "1 | \n", "... | \n", "2638724.00 | \n", "2017-08-13T18:33:00.000Z | \n", "147 | \n", "0.00 | \n", "19.00 | \n", "13.00 | \n", "11.00 | \n", "43.00 | \n", "43.00 | \n", "43.00 | \n", "
de58848c3fba3550be9fa164194024dc17baacb3 | \n", "https://www.buzzfeed.com/claudiarosenbaum/tayl... | \n", "Taylor Swift's Trial Over A DJ Allegedly Grabb... | \n", "2017-08-05 12:21:17.776 | \n", "2017-08-01 18:54:02 | \n", "3 | \n", "0.25 | \n", "2017-08-05T12:34:01.753Z | \n", "0 | \n", "0 | \n", "3 | \n", "... | \n", "2626421.00 | \n", "2017-08-05T17:39:00.000Z | \n", "147 | \n", "1.00 | \n", "19.00 | \n", "14.00 | \n", "11.00 | \n", "44.00 | \n", "45.00 | \n", "43.00 | \n", "
e0e54d8a3ca097df78e14a8ca6d30abb26e5ecb9 | \n", "https://www.buzzfeed.com/leticiamiranda/scams-... | \n", "People Are Losing A Bunch Of Money From These ... | \n", "2017-08-17 15:42:18.068 | \n", "2017-08-16 15:28:55 | \n", "2 | \n", "0.17 | \n", "2017-08-17T15:56:01.851Z | \n", "0 | \n", "0 | \n", "2 | \n", "... | \n", "2643708.00 | \n", "2017-08-17T18:09:00.000Z | \n", "147 | \n", "1.00 | \n", "19.00 | \n", "14.00 | \n", "11.00 | \n", "44.00 | \n", "45.00 | \n", "43.00 | \n", "
6666e26a4ec8a7875c73b728cad8f353e2045bc4 | \n", "https://www.buzzfeed.com/borzoudaragahi/the-wa... | \n", "The US Is Far More Deeply Involved In Syria Th... | \n", "2017-08-06 15:12:15.694 | \n", "2017-08-05 15:12:13 | \n", "3 | \n", "0.25 | \n", "2017-08-06T15:26:00.707Z | \n", "0 | \n", "0 | \n", "3 | \n", "... | \n", "2627238.00 | \n", "2017-08-06T22:40:00.000Z | \n", "147 | \n", "1.00 | \n", "19.00 | \n", "14.00 | \n", "11.00 | \n", "44.00 | \n", "45.00 | \n", "43.00 | \n", "
927c56158391f50dfc3b1549195deebf175e2478 | \n", "https://www.buzzfeed.com/tylerkingkade/want-to... | \n", "Want To Fire A Professor For Sexual Harassment... | \n", "2017-08-17 14:09:15.759 | \n", "2017-08-15 15:41:29 | \n", "1 | \n", "0.08 | \n", "2017-08-17T14:22:01.807Z | \n", "0 | \n", "0 | \n", "1 | \n", "... | \n", "2643633.00 | \n", "2017-08-17T16:39:00.000Z | \n", "147 | \n", "0.00 | \n", "19.00 | \n", "12.00 | \n", "11.00 | \n", "42.00 | \n", "42.00 | \n", "42.00 | \n", "
d6047b1d2d2a850fa9053b6bd9c0aeef7df8fdae | \n", "http://www.bbc.co.uk/news/world-asia-40957725 | \n", "US-South Korea set for divisive military drills | \n", "2017-08-21 00:33:02.151 | \n", "2017-08-21 00:30:00 | \n", "0 | \n", "53.16 | \n", "2017-08-21T03:02:00.081Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "43546090.00 | \n", "2017-08-21T02:37:12.000Z | \n", "96 | \n", "0.00 | \n", "20.00 | \n", "5.00 | \n", "15.00 | \n", "40.00 | \n", "40.00 | \n", "40.00 | \n", "
a611b0ede73ab49dc8a7b82ef7a47fb5b0c8e0d8 | \n", "https://www.buzzfeed.com/buzzfeednews/taylor-s... | \n", "Taylor Swift Prepares To Battle DJ In Court Ov... | \n", "2017-08-07 18:57:18.050 | \n", "2017-08-07 18:54:12 | \n", "37 | \n", "0.11 | \n", "2017-08-08T18:55:59.837Z | \n", "6 | \n", "9 | \n", "22 | \n", "... | \n", "2636375.00 | \n", "2017-08-12T00:13:39.000Z | \n", "147 | \n", "5.00 | \n", "19.00 | \n", "13.00 | \n", "11.00 | \n", "43.00 | \n", "48.00 | \n", "38.00 | \n", "
7c61a13b28222804ce718ff15fc6c5349e246369 | \n", "https://www.theguardian.com/us-news/2017/aug/1... | \n", "Charlottesville: violent clashes break out bet... | \n", "2017-08-12 15:51:00.487 | \n", "2017-08-12 15:48:52 | \n", "0 | \n", "2478.92 | \n", "2017-08-14T10:24:00.752Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "7643415.00 | \n", "2017-08-12T15:59:29.000Z | \n", "142 | \n", "0.00 | \n", "19.00 | \n", "4.00 | \n", "13.00 | \n", "36.00 | \n", "36.00 | \n", "36.00 | \n", "
2711716851862d1880226d271c35931b00411551 | \n", "https://www.buzzfeed.com/shannonrosenberg/do-y... | \n", "Do You Need To Give Up Alcohol If You're Tryin... | \n", "2017-08-24 18:48:19.569 | \n", "2017-08-24 00:59:23 | \n", "63 | \n", "0.37 | \n", "2017-08-25T00:12:01.927Z | \n", "16 | \n", "27 | \n", "20 | \n", "... | \n", "2650910.00 | \n", "2017-08-26T17:44:00.000Z | \n", "147 | \n", "7.00 | \n", "19.00 | \n", "13.00 | \n", "11.00 | \n", "43.00 | \n", "50.00 | \n", "36.00 | \n", "
3ba536b7e826a1d9d8873c786d733f3e4a49cbc8 | \n", "https://www.theguardian.com/us-news/2017/aug/2... | \n", "Donald Trump says he'll expand US military int... | \n", "2017-08-22 01:57:00.862 | \n", "2017-08-22 01:55:06 | \n", "0 | \n", "6.50 | \n", "2017-08-22T02:10:01.693Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "7655513.00 | \n", "2017-08-22T08:20:00.000Z | \n", "142 | \n", "0.00 | \n", "19.00 | \n", "4.00 | \n", "13.00 | \n", "36.00 | \n", "36.00 | \n", "36.00 | \n", "
2ebf576335435e03111cda6dca10e98892c8f3d2 | \n", "https://www.buzzfeed.com/scaachikoul/hey-ameri... | \n", "Hey, America, Now You Have Our Worst People. Y... | \n", "2017-08-19 14:25:03.772 | \n", "2017-08-18 21:12:12 | \n", "60 | \n", "0.25 | \n", "2017-08-19T14:38:01.259Z | \n", "4 | \n", "23 | \n", "33 | \n", "... | \n", "2645223.00 | \n", "2017-08-20T00:30:00.000Z | \n", "147 | \n", "7.00 | \n", "19.00 | \n", "12.00 | \n", "11.00 | \n", "42.00 | \n", "49.00 | \n", "35.00 | \n", "
e7222e4d2eb1eea9c874b5f07b5fe82b6167f006 | \n", "https://www.buzzfeed.com/mikehayes/police-and-... | \n", "Police Around The US Are Bracing For Newly Emb... | \n", "2017-08-18 19:06:16.126 | \n", "2017-08-18 16:26:10 | \n", "64 | \n", "0.50 | \n", "2017-08-18T19:20:03.083Z | \n", "7 | \n", "17 | \n", "40 | \n", "... | \n", "2645358.00 | \n", "2017-08-20T21:03:00.000Z | \n", "147 | \n", "7.00 | \n", "19.00 | \n", "11.00 | \n", "11.00 | \n", "41.00 | \n", "48.00 | \n", "34.00 | \n", "
89008fd54697f1ab1c7ce17b39827ff84d5af7a3 | \n", "https://www.buzzfeed.com/mitchprothero/the-big... | \n", "The Big Question for Investigators: Was The Ch... | \n", "2017-08-15 02:09:13.889 | \n", "2017-08-15 01:05:44 | \n", "70 | \n", "0.24 | \n", "2017-08-15T03:24:01.573Z | \n", "3 | \n", "49 | \n", "18 | \n", "... | \n", "2640309.00 | \n", "2017-08-15T15:00:24.000Z | \n", "147 | \n", "8.00 | \n", "19.00 | \n", "11.00 | \n", "11.00 | \n", "41.00 | \n", "49.00 | \n", "33.00 | \n", "
c8feb6222f1e07129625c8562c2ec6b9153c5a08 | \n", "https://www.buzzfeed.com/johnstanton/what-its-... | \n", "What It’s Like To Be Deported To Mexico After ... | \n", "2017-08-03 14:24:16.235 | \n", "2017-08-01 17:19:53 | \n", "5 | \n", "0.42 | \n", "2017-08-03T14:38:02.873Z | \n", "0 | \n", "0 | \n", "5 | \n", "... | \n", "nan | \n", "NaN | \n", "147 | \n", "1.00 | \n", "19.00 | \n", "15.00 | \n", "0.00 | \n", "34.00 | \n", "35.00 | \n", "33.00 | \n", "
89a7ab6236bad1abd7afc15172b9e8a953eea9d4 | \n", "http://www.foxnews.com/politics/2017/08/01/pen... | \n", "Pentagon investigators find ‘security risks’ i... | \n", "2017-08-01 22:05:04.897 | \n", "2017-08-01 22:00:00 | \n", "0 | \n", "130.83 | \n", "2017-08-02T01:18:00.243Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "15585866.00 | \n", "2017-08-02T09:30:00.000Z | \n", "285 | \n", "0.00 | \n", "17.00 | \n", "2.00 | \n", "14.00 | \n", "33.00 | \n", "33.00 | \n", "33.00 | \n", "
46b0401e9b8415dc7d7980c1c777748c5807ca72 | \n", "http://www.dailymail.co.uk/news/article-476969... | \n", "Sinead O'Connor says she is suicidal and livin... | \n", "2017-08-07 23:24:14.335 | \n", "2017-08-07 23:21:28 | \n", "0 | \n", "79.36 | \n", "2017-08-08T00:52:01.245Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "12014442.00 | \n", "2017-08-08T00:15:10.000Z | \n", "158 | \n", "0.00 | \n", "18.00 | \n", "1.00 | \n", "14.00 | \n", "33.00 | \n", "33.00 | \n", "33.00 | \n", "
adf8f08cd9b3c9d8308dfe6c72c4d61cff4fd797 | \n", "https://www.buzzfeed.com/dominicholden/6-reaso... | \n", "6 Reasons Why Trump Would Hit A Wall If He Tri... | \n", "2017-08-25 14:03:21.184 | \n", "2017-08-23 15:45:55 | \n", "1 | \n", "0.08 | \n", "2017-08-25T14:16:01.942Z | \n", "0 | \n", "0 | \n", "1 | \n", "... | \n", "nan | \n", "NaN | \n", "147 | \n", "0.00 | \n", "19.00 | \n", "14.00 | \n", "0.00 | \n", "33.00 | \n", "33.00 | \n", "33.00 | \n", "
73580f28cdc22b2cf6f133f5d8d0c76f2f92da92 | \n", "http://www.dailymail.co.uk/news/article-482068... | \n", "Neighbour calls autistic boy 'it' in horrifyin... | \n", "2017-08-24 17:30:14.417 | \n", "2017-08-24 17:29:55 | \n", "0 | \n", "43.08 | \n", "2017-08-24T20:50:00.443Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "12173156.00 | \n", "2017-08-24T19:45:28.000Z | \n", "158 | \n", "0.00 | \n", "18.00 | \n", "1.00 | \n", "14.00 | \n", "33.00 | \n", "33.00 | \n", "33.00 | \n", "
cbce8eb31a83066977187d0dde3cbe4d29793374 | \n", "https://www.theguardian.com/politics/2017/aug/... | \n", "UK will 'mirror' much of EU customs system for... | \n", "2017-08-15 11:33:00.655 | \n", "2017-08-15 11:31:05 | \n", "0 | \n", "77.77 | \n", "2017-08-16T09:11:59.702Z | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "7646421.00 | \n", "2017-08-15T12:56:36.000Z | \n", "142 | \n", "0.00 | \n", "19.00 | \n", "1.00 | \n", "13.00 | \n", "33.00 | \n", "33.00 | \n", "33.00 | \n", "
d896f7176dd863588481711c0eb8e19905b961ca | \n", "https://www.theguardian.com/education/2017/aug... | \n", "GCSE overhaul means results are ‘incomparable ... | \n", "2017-08-23 23:03:03.669 | \n", "2017-08-23 23:01:03 | \n", "12 | \n", "1.00 | \n", "2017-08-24T22:30:02.773Z | \n", "2 | \n", "4 | \n", "6 | \n", "... | \n", "7657721.00 | \n", "2017-08-24T06:19:07.000Z | \n", "142 | \n", "2.00 | \n", "19.00 | \n", "3.00 | \n", "13.00 | \n", "35.00 | \n", "37.00 | \n", "33.00 | \n", "
034dadb1c814df55b110fb56d45f220a0af64ba8 | \n", "https://www.buzzfeed.com/rosebuchanan/karate-kid | \n", "Meet The Little Syrian Girl Who Wants To Be A ... | \n", "2017-08-15 16:57:17.726 | \n", "2017-08-14 22:17:29 | \n", "13 | \n", "0.08 | \n", "2017-08-15T17:10:02.786Z | \n", "0 | \n", "6 | \n", "7 | \n", "... | \n", "2641800.00 | \n", "2017-08-16T04:54:00.000Z | \n", "147 | \n", "3.00 | \n", "19.00 | \n", "6.00 | \n", "11.00 | \n", "36.00 | \n", "39.00 | \n", "33.00 | \n", "
25 rows × 26 columns
\n", "\n", " | url | \n", "headline | \n", "discovered | \n", "published | \n", "fb_engagements | \n", "fb_max_engagements_per_min | \n", "fb_max_engagements_per_min_time | \n", "fb_comments | \n", "fb_reactions | \n", "fb_shares | \n", "... | \n", "fb_brand_page_likes | \n", "fb_brand_page_time | \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", " |
18189c494eb422d1b0ab26167076175e05a18985 | \n", "https://www.washingtonpost.com/local/the-lates... | \n", "The Latest: Police identify helicopter, troope... | \n", "2017-08-13 01:06:07.377 | \n", "2017-08-13 01:04:19.000 | \n", "339268 | \n", "4231.07 | \n", "2017-08-13T05:28:00.473Z | \n", "90555 | \n", "207253 | \n", "41460 | \n", "... | \n", "nan | \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", "
bf626f6b535a51ccffbebca41b61027d9dc8bf6d | \n", "http://www.cnn.com/2016/01/06/health/adult-col... | \n", "Why adult coloring books are good for you | \n", "2017-08-01 17:42:17.336 | \n", "2017-08-01 17:37:24.000 | \n", "255341 | \n", "1.31 | \n", "2017-08-02T16:39:59.574Z | \n", "52448 | \n", "162431 | \n", "40462 | \n", "... | \n", "nan | \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", "
ecd92911b177889b3a902a7ddfde0d1ff086f8c4 | \n", "http://www.huffingtonpost.com/entry/remove-him... | \n", "Remove Him Now | \n", "2017-08-19 18:03:21.545 | \n", "2017-08-19 17:48:07.484 | \n", "105278 | \n", "213.55 | \n", "2017-08-20T00:40:00.669Z | \n", "10282 | \n", "87549 | \n", "7447 | \n", "... | \n", "nan | \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", "
284b3454ef8d5235469a5c32f9ea20ba029b9ff4 | \n", "http://www.foxnews.com/us/2017/08/14/boston-ho... | \n", "Boston Holocaust Memorial smashed to pieces | \n", "2017-08-15 00:25:03.656 | \n", "2017-08-15 00:09:00.000 | \n", "130061 | \n", "90.42 | \n", "2017-08-15T20:36:00.218Z | \n", "26095 | \n", "87829 | \n", "16137 | \n", "... | \n", "nan | \n", "NaN | \n", "285 | \n", "50.00 | \n", "0.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "51.00 | \n", "-49.00 | \n", "
976ee1af9f57e6a45c1a02cc7a05cc6eccfa498b | \n", "http://www.huffingtonpost.com/entry/the-proble... | \n", "The Problem With Melania Isn't Her Shoes | \n", "2017-08-31 01:03:14.487 | \n", "2017-08-31 00:47:41.413 | \n", "95153 | \n", "207.42 | \n", "2017-09-02T15:08:00.267Z | \n", "18286 | \n", "67948 | \n", "8919 | \n", "... | \n", "nan | \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", "
9d5416e1d850656cec86528c97dfeef0b738d032 | \n", "http://yournewswire.com/charlottesville-hillar... | \n", "Charlottesville Killer Was Hillary Supporter, ... | \n", "2017-08-13 20:35:16.681 | \n", "2017-08-13 19:04:01.000 | \n", "162946 | \n", "102.64 | \n", "2017-08-14T14:12:00.081Z | \n", "65217 | \n", "66428 | \n", "31301 | \n", "... | \n", "nan | \n", "NaN | \n", "22568 | \n", "50.00 | \n", "0.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "51.00 | \n", "-49.00 | \n", "
0a5ef01bb7614fe47fe1e2bff6ed8d90b3bf88d1 | \n", "https://www.rt.com/on-air/400998-barcelona-ant... | \n", "Anti-terrorism march in Barcelona in wake of a... | \n", "2017-08-26 16:20:14.530 | \n", "2017-08-26 16:20:14.530 | \n", "175444 | \n", "2826.47 | \n", "2017-08-26T23:48:01.315Z | \n", "24072 | \n", "10417 | \n", "140955 | \n", "... | \n", "nan | \n", "NaN | \n", "365 | \n", "50.00 | \n", "0.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "51.00 | \n", "-49.00 | \n", "
558e0d04a7977fafaee4d2c5e7f78d514470d153 | \n", "https://www.buzzfeed.com/alexandrearagao/esse-... | \n", "Esse é o tamanho da área que Temer liberou par... | \n", "2017-08-24 20:33:16.676 | \n", "2017-08-24 20:32:56.000 | \n", "79416 | \n", "185.92 | \n", "2017-08-25T19:52:00.145Z | \n", "4568 | \n", "65462 | \n", "9386 | \n", "... | \n", "nan | \n", "NaN | \n", "147 | \n", "48.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "48.00 | \n", "-48.00 | \n", "
597bc58ed2caa997c80434e8db5fa7f37d0167bc | \n", "http://www.foxnews.com/us/2017/08/04/planned-p... | \n", "Planned Parenthood: Teach your preschoolers 't... | \n", "2017-08-04 15:15:06.479 | \n", "2017-08-04 12:29:00.000 | \n", "275925 | \n", "166.25 | \n", "2017-08-07T16:22:00.043Z | \n", "100038 | \n", "147626 | \n", "28261 | \n", "... | \n", "nan | \n", "NaN | \n", "285 | \n", "50.00 | \n", "0.00 | \n", "2.00 | \n", "0.00 | \n", "2.00 | \n", "52.00 | \n", "-48.00 | \n", "
8e862d36fc0c1b6f14b78bb64ddebfe62c9426fd | \n", "https://www.washingtonpost.com/news/post-polit... | \n", "Trump doubles down on initial Charlottesville ... | \n", "2017-08-15 20:35:02.695 | \n", "2017-08-15 20:31:00.000 | \n", "95511 | \n", "2332.74 | \n", "2017-08-15T23:36:01.987Z | \n", "31677 | \n", "54688 | \n", "9146 | \n", "... | \n", "nan | \n", "NaN | \n", "191 | \n", "49.00 | \n", "0.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "50.00 | \n", "-48.00 | \n", "
6404530570733ce02f88d193eb64a0597ac829ae | \n", "http://www.cnn.com/2017/08/20/entertainment/je... | \n", "Jerry Lee Lewis dies at 91 | \n", "2017-08-20 18:24:15.530 | \n", "2017-08-20 18:20:54.000 | \n", "80427 | \n", "322.55 | \n", "2017-08-20T21:42:01.255Z | \n", "9256 | \n", "52707 | \n", "18464 | \n", "... | \n", "nan | \n", "NaN | \n", "105 | \n", "48.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "48.00 | \n", "-48.00 | \n", "
eb4883d5690803f0708b472e24ff3345b586f2c9 | \n", "https://www.nytimes.com/2017/08/17/us/politics... | \n", "Trump ‘Sad’ Over Removal of ‘Our Beautiful Sta... | \n", "2017-08-17 13:24:00.082 | \n", "2017-08-17 13:22:51.000 | \n", "92464 | \n", "263.08 | \n", "2017-08-17T15:01:59.775Z | \n", "29592 | \n", "54307 | \n", "8565 | \n", "... | \n", "nan | \n", "NaN | \n", "120 | \n", "48.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "48.00 | \n", "-48.00 | \n", "
f026f1d592c1ea91ee7a2a69531b74e7fada42cc | \n", "http://www.foxnews.com/entertainment/2017/08/2... | \n", "ESPN pulls Asian-American announcer from Virgi... | \n", "2017-08-23 01:35:04.690 | \n", "2017-08-23 01:07:00.000 | \n", "287252 | \n", "357.92 | \n", "2017-08-23T13:36:01.174Z | \n", "123252 | \n", "133264 | \n", "30736 | \n", "... | \n", "nan | \n", "NaN | \n", "285 | \n", "50.00 | \n", "0.00 | \n", "2.00 | \n", "0.00 | \n", "2.00 | \n", "52.00 | \n", "-48.00 | \n", "
d7300e64ac7f445fd36cf88631473f8a0814a919 | \n", "https://www.washingtonpost.com/national/black-... | \n", "Black-clad anarchists storm Berkeley rally, as... | \n", "2017-08-28 00:42:14.796 | \n", "2017-08-28 00:34:51.000 | \n", "100159 | \n", "577.62 | \n", "2017-08-28T19:32:00.579Z | \n", "53284 | \n", "34686 | \n", "12189 | \n", "... | \n", "nan | \n", "NaN | \n", "191 | \n", "49.00 | \n", "0.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "50.00 | \n", "-48.00 | \n", "
8ea9f43ab02d1b7c56cdef6169ecf819fff2bf6c | \n", "https://www.buzzfeed.com/beatrizserranomolina/... | \n", "11 actos de pura bondad tras el atentado para ... | \n", "2017-08-17 19:36:12.550 | \n", "2017-08-17 19:31:30.000 | \n", "81083 | \n", "188.33 | \n", "2017-08-18T03:04:00.413Z | \n", "2054 | \n", "66208 | \n", "12821 | \n", "... | \n", "nan | \n", "NaN | \n", "147 | \n", "48.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "48.00 | \n", "-48.00 | \n", "
d59d637fc9a6a7afc160f03452e26f3fff3eef93 | \n", "http://www.foxnews.com/sports/2017/08/23/hank-... | \n", "Hank Aaron says he won't watch NFL because of ... | \n", "2017-08-23 16:15:57.261 | \n", "2017-08-23 15:57:00.000 | \n", "106640 | \n", "7311.08 | \n", "2017-08-25T09:16:00.526Z | \n", "9576 | \n", "80768 | \n", "16296 | \n", "... | \n", "nan | \n", "NaN | \n", "285 | \n", "49.00 | \n", "0.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "50.00 | \n", "-48.00 | \n", "
146b733457836a9790f68079b387d3a64fc9908c | \n", "https://www.theguardian.com/sport/2017/aug/30/... | \n", "Aaron Rodgers: Racial injustice is 'real' and ... | \n", "2017-08-30 17:03:20.697 | \n", "2017-08-30 16:59:10.000 | \n", "75615 | \n", "186.68 | \n", "2017-09-01T17:04:00.374Z | \n", "9522 | \n", "57462 | \n", "8631 | \n", "... | \n", "nan | \n", "NaN | \n", "142 | \n", "47.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "47.00 | \n", "-47.00 | \n", "
9c2aefdd909a169662e267ac4674e29cd5ddf360 | \n", "http://www.foxnews.com/opinion/2017/08/23/cour... | \n", "Court rules high school football coach cannot ... | \n", "2017-08-23 23:30:10.887 | \n", "2017-08-23 23:15:00.000 | \n", "421505 | \n", "466.92 | \n", "2017-08-25T13:04:00.035Z | \n", "90276 | \n", "275289 | \n", "55940 | \n", "... | \n", "nan | \n", "NaN | \n", "285 | \n", "50.00 | \n", "0.00 | \n", "3.00 | \n", "0.00 | \n", "3.00 | \n", "53.00 | \n", "-47.00 | \n", "
7364eb9055281cb9954c8444bee1d5366d35a1ad | \n", "https://www.nytimes.com/2017/08/18/internation... | \n", "Crusader Who Saved Elephants From Poachers Is ... | \n", "2017-08-18 17:48:02.978 | \n", "2017-08-18 17:47:46.000 | \n", "74154 | \n", "130.18 | \n", "2017-08-19T03:43:59.592Z | \n", "4033 | \n", "64964 | \n", "5157 | \n", "... | \n", "nan | \n", "NaN | \n", "120 | \n", "47.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "47.00 | \n", "-47.00 | \n", "
6fc9f70c910c724431d9f1cfc073e02e95a30a67 | \n", "http://www.foxnews.com/us/2017/08/29/florida-p... | \n", "Florida professor who tweeted Texans deserved ... | \n", "2017-08-29 17:05:04.018 | \n", "2017-08-29 16:00:00.000 | \n", "90959 | \n", "99.39 | \n", "2017-08-30T02:05:59.449Z | \n", "27757 | \n", "53203 | \n", "9999 | \n", "... | \n", "nan | \n", "NaN | \n", "285 | \n", "48.00 | \n", "0.00 | \n", "2.00 | \n", "0.00 | \n", "2.00 | \n", "50.00 | \n", "-46.00 | \n", "
f6f5d20cf87c8e50560130566d95203f4a3bef05 | \n", "https://www.washingtonpost.com/news/energy-env... | \n", "The Trump administration just disbanded a fede... | \n", "2017-08-20 11:09:09.339 | \n", "2017-08-20 11:00:32.000 | \n", "87692 | \n", "192.43 | \n", "2017-08-21T15:07:59.825Z | \n", "11504 | \n", "66531 | \n", "9657 | \n", "... | \n", "nan | \n", "NaN | \n", "191 | \n", "48.00 | \n", "0.00 | \n", "2.00 | \n", "0.00 | \n", "2.00 | \n", "50.00 | \n", "-46.00 | \n", "
8dc913cfa338ad0c6ffe32dc68abcdb9214dcb19 | \n", "http://www.foxnews.com/us/2017/08/18/two-polic... | \n", "Two police officers slain near Orlando, Fla. | \n", "2017-08-19 04:10:03.038 | \n", "2017-08-19 03:50:00.000 | \n", "68737 | \n", "161.97 | \n", "2017-08-19T13:34:00.065Z | \n", "11217 | \n", "49251 | \n", "8269 | \n", "... | \n", "nan | \n", "NaN | \n", "285 | \n", "47.00 | \n", "0.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "48.00 | \n", "-46.00 | \n", "
0051d5757667245ff75ba7ffae654e5007c0fb47 | \n", "http://www.foxnews.com/us/2017/08/15/college-s... | \n", "College student, 22, arrested for her role in ... | \n", "2017-08-15 22:30:03.616 | \n", "2017-08-15 21:58:00.000 | \n", "67150 | \n", "390.96 | \n", "2017-08-16T23:00:01.574Z | \n", "12099 | \n", "49717 | \n", "5334 | \n", "... | \n", "nan | \n", "NaN | \n", "285 | \n", "47.00 | \n", "0.00 | \n", "2.00 | \n", "0.00 | \n", "2.00 | \n", "49.00 | \n", "-45.00 | \n", "
e0d90ecadd5a0983f52e7fe1006e87d1dea782be | \n", "http://www.dailymail.co.uk/tvshowbiz/article-4... | \n", "SPOILER ALERT! Pia Miller’s Home And Away char... | \n", "2017-08-10 07:42:16.320 | \n", "2017-08-10 07:41:08.000 | \n", "49578 | \n", "139.86 | \n", "2017-08-10T10:24:02.068Z | \n", "27929 | \n", "17486 | \n", "4163 | \n", "... | \n", "nan | \n", "NaN | \n", "158 | \n", "45.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "45.00 | \n", "-45.00 | \n", "
cc2ddab940518388e6fdba6cb66fc182b187eb3d | \n", "https://www.nytimes.com/2017/08/16/business/tr... | \n", "Trump’s Council of C.E.O.’s in Disarray Follow... | \n", "2017-08-16 16:27:00.512 | \n", "2017-08-16 16:23:56.000 | \n", "52568 | \n", "216.16 | \n", "2017-08-16T17:42:02.788Z | \n", "9229 | \n", "32937 | \n", "10402 | \n", "... | \n", "nan | \n", "NaN | \n", "120 | \n", "45.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "45.00 | \n", "-45.00 | \n", "
25 rows × 26 columns
\n", "