Data on Trump tweets and approval rating

Data available for research

Below is a csv file with variable names on the top row. The data comes from the following sources:

For each day of Trump’s Presidency, I added up all his tweets for the day, and how many of those included the words “fake news,” “dumb,” “dummy,” “terrible,” “stupid,” “weak,” “dishonest,” “lightweight,” “incompetent,” “boring,” “fool,” “pathetic,” “clown,” and “disgusting,” assuming that these represented the bulk of his negative, attack tweets. Finally, I specifically added up the tweets each day that included “fake news.” The result is a database of all the days of his Presidency with the total number of tweets, the approximate number of negative tweets, and the actual number of tweets screaming “fake news.”

To that data, I attached Trump’s favorability and unfavorability ratings from three days after each tweetstorm, as downloaded from Nate Silver’s Fivethirtyeight. I figured it takes about three days for one day’s activity to impact the polls, so thus the delay.

Feel free to use the data as you see fit. I look forward to seeing interesting research!

Date+3,Fake news,Total neg,Tweet,Total,all polls approval,all polls disapprove,Adults approval,Adults disapprove,Voters approval,Voters disapprove,all_range,adults_range,voters_range

12/2/2018,0,0,14,Total,42.54106,52.68478,41.49432,53.37064,44.31874,51.39655,-10.14372,-11.87632,-7.07781