Trump's Tweets Capture Media Attention Again In Aftermath Of Capitol Storming

How often are Trump's tweets embedded or linked to in worldwide online news coverage? The timeline below shows the total number of worldwide online news articles monitored per day since April 2016 that embedded or linked to a Donald Trump tweet using a rolling 7 day average to smooth the data. In all, 1.15 million articles have been monitored by GDELT that embedded or linked to one of his tweets.


Computing the timeline above took just a single line of SQL in BigQuery!

SELECT SUBSTR(CAST(DATE AS STRING), 0, 8) Day, count(1) Count FROM `gdelt-bq.gdeltv2.gkg_partitioned` WHERE LOWER(Extras) like '' group by day order by day asc