home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

2,973,371 rows

View and edit SQL

Link rowid external_author_id author content region language publish_date harvested_date following followers updates post_type new_june_2018 retweet
51 906000000000000000 10_GOP 1 Wait.. where were all these women when Bill Clinton raped Juanita Broderick? Oh yea they were making fun of her. #WomenBoycottTwitter Unknown 1 English 1 2017-10-13T03:09:00 2017-10-13T03:10:00 1071 10420 330   0 0
52 906000000000000000 10_GOP 1 A West Virginia coal miner sings the national anthem before going underground. Some people still have respect for their country! https://t.co/V5JhAjgYs5 Unknown 1 English 1 2017-10-13T04:04:00 2017-10-13T04:04:00 1071 10425 331   0 0
53 906000000000000000 10_GOP 1 After posting their support of President Trump, Arizona restaurant forced to close down due to death threats. This is the "peaceful" left. https://t.co/GPPQCSfYNe Unknown 1 English 1 2017-10-14T01:09:00 2017-10-14T01:09:00 1071 10451 341   0 0
54 906000000000000000 10_GOP 1 '@realDonaldTrump Thank you for being a POTUS we elected!' Unknown 1 English 1 2017-10-14T01:11:00 2017-10-14T01:11:00 1071 10451 342   0 0
55 906000000000000000 10_GOP 1 '@realDonaldTrump More proud now than ever, finally after 8 years of Obama we have a President who stands up for Americanism and puts Americans first.' Unknown 1 English 1 2017-10-14T01:12:00 2017-10-14T01:12:00 1071 10453 343   0 0
56 906000000000000000 10_GOP 1 '@realDonaldTrump Let's make America powerful, industrial, and proud again!' Unknown 1 English 1 2017-10-14T01:13:00 2017-10-14T01:13:00 1071 10453 344   0 0
57 906000000000000000 10_GOP 1 '@realDonaldTrump ObamaCare is a disaster!' Unknown 1 English 1 2017-10-14T01:18:00 2017-10-14T01:18:00 1071 10453 345   0 0
58 906000000000000000 10_GOP 1 '@realDonaldTrump We need to end ObamaCare as soon as possible before it kills millions.' Unknown 1 English 1 2017-10-14T01:18:00 2017-10-14T01:18:00 1071 10453 346   0 0
59 906000000000000000 10_GOP 1 '@realDonaldTrump Please Mr. president, take action! Get rid of it. We don’t want socialism in our country.' Unknown 1 English 1 2017-10-14T01:20:00 2017-10-14T01:20:00 1071 10453 347   0 0
60 906000000000000000 10_GOP 1 '@realDonaldTrump Please Mr. President, take action! Get rid of it. We don’t want socialism in our country.' Unknown 1 English 1 2017-10-14T01:21:00 2017-10-14T01:21:00 1071 10455 348   0 0
61 906000000000000000 10_GOP 1 Health Insurance stocks, which have gone through the roof during the ObamaCare years, plunged yesterday after I ended their Dems windfall! Unknown 1 English 1 2017-10-14T21:58:00 2017-10-14T21:58:00 1073 10465 351 RETWEET 1 0 1
62 906000000000000000 10_GOP 1 #FakeNews MSM has been out to get President Trump since he was a candidate. Be warned--We The People are fighting back & you're going down. Unknown 1 English 1 2017-10-14T02:09:00 2017-10-14T02:09:00 1073 10456 348 RETWEET 1 0 1
63 906000000000000000 10_GOP 1 President Trump tweeted this back in 2012. https://t.co/MZ8clJIykT Unknown 1 English 1 2017-10-14T02:21:00 2017-10-14T02:21:00 1073 10456 349   0 0
64 906000000000000000 10_GOP 1 President Trump tweeted this back in 2012. https://t.co/lW763v7iB7 Unknown 1 English 1 2017-10-14T02:26:00 2017-10-14T02:27:00 1073 10456 349   0 0
65 906000000000000000 10_GOP 1 Liberal's are the most hate filled, racist, hypocritical, bigoted, irrational & mentally unstable creatures on earth. A danger to the world. https://t.co/qpzuVTlhAL Unknown 1 English 1 2017-10-14T02:49:00 2017-10-14T02:49:00 1074 10458 350 RETWEET 1 0 1
66 906000000000000000 10_GOP 1 Photo of NFL players today protesting domestic violence, sexual assault, and child abuse https://t.co/jkLONjGZJu Unknown 1 English 1 2017-10-15T23:34:00 2017-10-15T23:34:00 1074 10462 352 RETWEET 1 0 1
67 906000000000000000 10_GOP 1 I have no sympathy for Hayley Geftman-Gold. #LasVegas https://t.co/x4nPHGsLYj Unknown 1 English 1 2017-10-02T18:51:00 2017-10-02T18:52:00 1066 9694 261   0 0
68 906000000000000000 10_GOP 1 President Trump and first lady Melania Trump lead White House staff in a moment of silence for #LasVegas. https://t.co/SNeRLafThC Unknown 1 English 1 2017-10-02T19:24:00 2017-10-02T19:24:00 1066 9696 262   0 0
69 906000000000000000 10_GOP 1 Ignorant, irrelevant and exploitative https://t.co/6XWGQxcDPt Unknown 1 English 1 2017-10-02T19:55:00 2017-10-02T19:55:00 1066 9699 263 RETWEET 1 0 1
70 906000000000000000 10_GOP 1 #LasVegasShooting victim Sonny Melton was a Tennessee nurse who died while shielding his wife from gunfire. https://t.co/xJwdLUPb6O Unknown 1 English 1 2017-10-02T20:08:00 2017-10-02T20:08:00 1066 9700 264   0 0
71 906000000000000000 10_GOP 1 TMZ now reporting Tom Petty is still “clinging to life”. So if he comes back to consciousness, he can read all the nice tributes. https://t.co/ed0UassJX3 Unknown 1 English 1 2017-10-02T21:03:00 2017-10-02T21:03:00 1066 9702 265   0 0
72 906000000000000000 10_GOP 1 Thousands of Americans are waiting in line to donate blood in Las Vegas. #LasVegasStrong🇺🇸 https://t.co/aRNromHfb5 Unknown 1 English 1 2017-10-02T21:20:00 2017-10-02T21:20:00 1066 9708 266 RETWEET 1 0 1
73 906000000000000000 10_GOP 1 Here is video of woman approaching the man saying "Hi Steve!" Could this be Stephen Paddock? #LasVegasShooting https://t.co/NEAUohASF1 Unknown 1 English 1 2017-10-02T21:23:00 2017-10-02T21:23:00 1066 9709 267   0 0
74 906000000000000000 10_GOP 1 Tom Petty hearing the reports of his own death: https://t.co/O0WgYuyo5J Unknown 1 English 1 2017-10-02T21:40:00 2017-10-02T21:40:00 1066 9713 268   0 0
75 906000000000000000 10_GOP 1 '@Cernovich @KFILE JOURNALISM 😱😱' Unknown 1 English 1 2017-10-02T22:37:00 2017-10-02T22:38:00 1066 9721 269   0 0
76 906000000000000000 10_GOP 1 Sunrise Hospital in Las Vegas today.. Let’s take a moment to thank dedicated and tireless doctors, nurses and hospital staff 🙏 #VegasStrong https://t.co/2ey9cvFAb8 Unknown 1 English 1 2017-10-02T23:20:00 2017-10-02T23:20:00 1066 9734 270   0 0
77 906000000000000000 10_GOP 1 Will players “take a knee” tonight to protest the lives saved by Las Vegas police officers? Will ESPN spit on first responders yet again? Unknown 1 English 1 2017-10-02T23:34:00 2017-10-02T23:35:00 1066 9737 271 RETWEET 1 0 1
78 906000000000000000 10_GOP 1 Wow.. this man was literally standing when everyone was laying down, sipping a beer and giving the shooter the finger. #VegasStrong https://t.co/Hk6uo5qsTr Unknown 1 English 1 2017-10-02T23:52:00 2017-10-02T23:52:00 1066 9741 272   0 0
79 906000000000000000 10_GOP 1 Crybaby Marshawn Lynch of the Oakland Raiders sitting during the anthem, hiding behind staff. What a joke the NFL has become. #BoycottNFL https://t.co/tuhU59v9My Unknown 1 English 1 2017-10-02T02:31:00 2017-10-02T02:31:00 1064 9653 257 RETWEET 1 0 1
80 906000000000000000 10_GOP 1 The truth about Puerto Rico 🇵🇷 & it's not the propaganda Mayor of #SanJuan has been spewing w/MSM & cluless celebrities♦️RT♦️ #TakeAKnee https://t.co/gRYqsM9g8M Unknown 1 English 1 2017-10-02T02:42:00 2017-10-02T02:42:00 1064 9651 258 RETWEET 1 0 1
81 906000000000000000 10_GOP 1 FEMA deputy rips Democrat San Juan Mayor: "She has not participated in any of our relief efforts." https://t.co/vYuE1XBdoJ Unknown 1 English 1 2017-10-02T02:48:00 2017-10-02T02:49:00 1064 9652 259   0 0
82 906000000000000000 10_GOP 1 WOW! CNN cuts off former Puerto Rico AG after accusing San Juan Mayor of being a political hack. #FakeNews https://t.co/eSXAzZUmjN Unknown 1 English 1 2017-10-02T03:44:00 2017-10-02T03:45:00 1065 9651 260   0 0
83 906000000000000000 10_GOP 1 Police stand-up and rush in to save lives in Las Vegas Marcus Peters sits during the anthem despite a national day of mourning Despicable. https://t.co/gIxLGBBoIB Unknown 1 English 1 2017-10-03T00:55:00 2017-10-03T00:56:00 1066 9758 274   0 0
84 906000000000000000 10_GOP 1 '@CNN in hysterics as Puerto Rico FULLY EMBRACES President Trump w/ Love and Cheers of Praise !! Fake News Narrative CRUSHED https://t.co/Mn6Jt7IO9B' Unknown 1 English 1 2017-10-03T21:51:00 2017-10-03T21:51:00 1067 10031 277 RETWEET 1 0 1
85 906000000000000000 10_GOP 1 A couple hours before the Las Vegas Mass Shooting - the crowd proudly sang "God Bless America" 🇺🇸 beautiful video. https://t.co/awQ1Uu17qH Unknown 1 English 1 2017-10-03T21:52:00 2017-10-03T21:52:00 1067 10031 278 RETWEET 1 0 1
86 906000000000000000 10_GOP 1 '@AP_Politics This is tragic' Unknown 1 English 1 2017-10-03T22:06:00 2017-10-03T22:06:00 1067 10033 279   0 0
87 906000000000000000 10_GOP 1 .@POTUS and @FLOTUS meet with storm survivors and pass out supplies at church in Puerto Rico today. #PRStrong https://t.co/RN9QC1b0Ax Unknown 1 English 1 2017-10-03T23:32:00 2017-10-03T23:32:00 1067 10045 280 RETWEET 1 0 1
88 906000000000000000 10_GOP 1 Kids, choose your idols wisely https://t.co/rqB3t5KZ25 Unknown 1 English 1 2017-10-03T03:08:00 2017-10-03T03:08:00 1067 9830 275   0 0
89 906000000000000000 10_GOP 1 House Democrat Katherine Clark refuses to participate in moment of silence for Las Vegas victims, walks out of Chamber. This is so sick. https://t.co/dKfLBjJGBf Unknown 1 English 1 2017-10-03T04:02:00 2017-10-03T04:02:00 1067 9849 276   0 0
90 906000000000000000 10_GOP 1 The Senate Intel Committee basically confirms today that they have absolutely nothing on Russian collusion. What a waste of time and money! Unknown 1 English 1 2017-10-04T19:10:00 2017-10-04T19:10:00 1068 10105 281 RETWEET 1 0 1
91 906000000000000000 10_GOP 1 Pres. Trump to Las Vegas first responders: "You showed the world—and the world is watching—and you showed what professionalism is all about" https://t.co/fwSNHainih Unknown 1 English 1 2017-10-04T19:18:00 2017-10-04T19:19:00 1068 10105 282   0 0
92 906000000000000000 10_GOP 1 This is the same woman who said don't politicise it, before politicising it in the very same tweet. https://t.co/khCpFsunpY Unknown 1 English 1 2017-10-04T22:11:00 2017-10-04T22:11:00 1069 10116 283 RETWEET 1 0 1
93 906000000000000000 10_GOP 1 '@PrisonPlanet A brilliantly spot on cartoon!' Unknown 1 English 1 2017-10-04T22:12:00 2017-10-04T22:12:00 1069 10116 284   0 0
94 906000000000000000 10_GOP 1 '@PrisonPlanet Love it! @GrrrGraphics,one of your very best.' Unknown 1 English 1 2017-10-04T22:14:00 2017-10-04T22:14:00 1069 10116 285   0 0
95 906000000000000000 10_GOP 1 Wow... Black Lives Matter protesters shut down the ACLU's campus free speech event because 'Liberalism is white supremacy' https://t.co/fmMiqIKrTF Unknown 1 English 1 2017-10-04T23:00:00 2017-10-04T23:00:00 1069 10116 286   0 0
96 906000000000000000 10_GOP 1 Guns don't kill people. People kill people. https://t.co/Ai151xGb65 Unknown 1 English 1 2017-10-04T23:49:00 2017-10-04T23:49:00 1070 10115 287 QUOTE_TWEET 2 0 1
97 906000000000000000 10_GOP 1 Las Vegas victim meets Trump, stands up on wounded leg: "I will always respect my country, my President,my flag!" You won't see this on CNN https://t.co/zHEFA3LELv Unknown 1 English 1 2017-10-05T00:51:00 2017-10-05T00:51:00 1070 10119 288   0 0
98 906000000000000000 10_GOP 1 50+ dead and 500+ injured in Las Vegas. Where's the Facebook photo filter to support victims of this tragedy? Unknown 1 English 1 2017-10-05T01:39:00 2017-10-05T01:39:00 1070 10129 289   0 0
99 906000000000000000 10_GOP 1 You won't see this picture on CNN! https://t.co/7qZ7LcZJzp Unknown 1 English 1 2017-10-05T21:08:00 2017-10-05T21:08:00 1070 10229 291   0 0
100 906000000000000000 10_GOP 1 Ivana Trump: "He still asks me for advice, he asks “Should I tweet? Should I not?” I say “I think you should tweet.” https://t.co/bmNSMb3ZA9 Unknown 1 English 1 2017-10-05T21:57:00 2017-10-05T21:57:00 1070 10232 292   0 0

Next page

Advanced export

JSON shape: default, array

CSV options:

CREATE TABLE "tweets" (
"external_author_id" INTEGER,
  "author" INTEGER,
  "content" TEXT,
  "region" INTEGER,
  "language" INTEGER,
  "publish_date" TEXT,
  "harvested_date" TEXT,
  "following" INTEGER,
  "followers" INTEGER,
  "updates" INTEGER,
  "post_type" INTEGER,
  "account_type" INTEGER,
  "new_june_2018" INTEGER,
  "retweet" INTEGER,
  "account_category" INTEGER
,
FOREIGN KEY ("author") REFERENCES [author](id),
    FOREIGN KEY ("region") REFERENCES [region](id),
    FOREIGN KEY ("language") REFERENCES [language](id),
    FOREIGN KEY ("post_type") REFERENCES [post_type](id),
    FOREIGN KEY ("account_type") REFERENCES [account_type](id),
    FOREIGN KEY ("account_category") REFERENCES [account_category](id))
Powered by Datasette · Query took 1662.655ms · Data source: fivethirtyeight/russian-troll-tweets