home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

2,973,371 rows sorted by post_type

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
1 906000000000000000 10_GOP 1 "We have a sitting Democrat US Senator on trial for corruption and you've barely heard a peep from the mainstream media." ~ @nedryun https://t.co/gh6g0D1oiC Unknown 1 English 1 2017-10-01T19:58:00 2017-10-01T19:59:00 1052 9636 253   0 0
2 906000000000000000 10_GOP 1 Marshawn Lynch arrives to game in anti-Trump shirt. Judging by his sagging pants the shirt should say Lynch vs. belt https://t.co/mLH1i30LZZ Unknown 1 English 1 2017-10-01T22:43:00 2017-10-01T22:43:00 1054 9637 254   0 0
4 906000000000000000 10_GOP 1 JUST IN: President Trump dedicates Presidents Cup golf tournament trophy to the people of Florida, Texas and Puerto Rico. https://t.co/z9wVa4djAE Unknown 1 English 1 2017-10-01T23:52:00 2017-10-01T23:52:00 1062 9642 256   0 0
6 906000000000000000 10_GOP 1 Dan Bongino: "Nobody trolls liberals better than Donald Trump." Exactly! https://t.co/AigV93aC8J Unknown 1 English 1 2017-10-01T02:47:00 2017-10-01T02:47:00 1050 9644 247   0 0
8 906000000000000000 10_GOP 1 '@SenatorMenendez @CarmenYulinCruz Doesn't matter that CNN doesn't report on your crimes. This won't change the fact that you're going down.' Unknown 1 English 1 2017-10-01T02:52:00 2017-10-01T02:53:00 1050 9644 249   0 0
9 906000000000000000 10_GOP 1 As much as I hate promoting CNN article, here they are admitting EVERYTHING Trump said about PR relief two days ago. https://t.co/tZmSeA48oh Unknown 1 English 1 2017-10-01T03:47:00 2017-10-01T03:47:00 1050 9646 250   0 0
10 906000000000000000 10_GOP 1 After the 'genocide' remark from San Juan Mayor the narrative has changed though. @CNN fixes it's reporting constantly. Unknown 1 English 1 2017-10-01T03:51:00 2017-10-01T03:51:00 1050 9646 251   0 0
11 906000000000000000 10_GOP 1 After the 'genocide' remark from San Juan Mayor the narrative has changed though. @CNN fixes its reporting constantly. Unknown 1 English 1 2017-10-01T03:58:00 2017-10-01T03:58:00 1050 9646 251   0 0
12 906000000000000000 10_GOP 1 '@thehill Why won't she apologize to us for lying?' Unknown 1 English 1 2017-10-01T04:11:00 2017-10-01T04:12:00 1050 9645 252   0 0
13 906000000000000000 10_GOP 1 Sarah Sanders destroys NBC reporter: "Trump made a joke, maybe you guys should get a sense of humor." https://t.co/IceJ8acE3G Unknown 1 English 1 2017-10-10T20:57:00 2017-10-10T20:57:00 1066 10319 301   0 0
14 906000000000000000 10_GOP 1 Hi @MichelleObama, remember when you said Weinstein is a "wonderful human being, a good friend and just a powerhouse." Do you disavow? https://t.co/pxNaJhhhRc Unknown 1 English 1 2017-10-10T21:59:00 2017-10-10T21:59:00 1066 10320 302   0 0
15 906000000000000000 10_GOP 1 Hi @MichelleObama, remember when you praised Harvey Weinstein as 'a wonderful human being, a good friend and a powerhouse." Do you disavow? https://t.co/sRc1TK78AW Unknown 1 English 1 2017-10-10T22:06:00 2017-10-10T22:06:00 1066 10320 302   0 0
16 906000000000000000 10_GOP 1 Wow! Even CNN is slamming the Obamas for silence on Weinstein: "Where is Michelle Obama? Where is President Obama?" https://t.co/UxIhO8GDOJ Unknown 1 English 1 2017-10-10T22:17:00 2017-10-10T22:17:00 1066 10322 303   0 0
17 906000000000000000 10_GOP 1 First lady Melania Trump visits infant opioid treatment center in Huntington, West Virginia. We love your grace and style @FLOTUS! ❤️❤️ https://t.co/hLAKPSOro6 Unknown 1 English 1 2017-10-10T23:42:00 2017-10-10T23:42:00 1068 10328 304   0 0
19 906000000000000000 10_GOP 1 '@Breaking911 Build that wall!! 👍' Unknown 1 English 1 2017-10-11T19:16:00 2017-10-11T19:16:00 1070 10361 307   0 0
20 906000000000000000 10_GOP 1 "It took Hillary abt 5 minutes to blame NRA for madman's rampage, but 5 days to sorta-kinda blame Harvey Weinstein 4 his sexually assaults." https://t.co/uzZ5obFGiO Unknown 1 English 1 2017-10-11T20:26:00 2017-10-11T20:27:00 1070 10358 308   0 0
22 906000000000000000 10_GOP 1 Congrats to Kirstjen Nielsen, our next Secretary of Homeland Security! Well deserved. https://t.co/UITBXQdUVx Unknown 1 English 1 2017-10-11T22:17:00 2017-10-11T22:17:00 1070 10358 310   0 0
23 906000000000000000 10_GOP 1 Pres. Trump: "We want lower taxes, bigger paychecks, and more jobs for American truckers and for American workers." https://t.co/gZe8mvpay3 Unknown 1 English 1 2017-10-11T22:20:00 2017-10-11T22:20:00 1070 10357 311   0 0
25 906000000000000000 10_GOP 1 This Eminem freestyle proves that celebs still haven't learned that nobody cares what they have to say. Sad! #HipHopAwards Unknown 1 English 1 2017-10-11T02:14:00 2017-10-11T02:14:00 1069 10337 306   0 0
27 906000000000000000 10_GOP 1 Pres. Trump just dropped a NUKE-truth-bomb: "The NFL should have suspended Kaepernick for one game and he would have never done it again" https://t.co/qKYPwhsglu Unknown 1 English 1 2017-10-12T00:38:00 2017-10-12T00:38:00 1070 10361 314   0 0
28 906000000000000000 10_GOP 1 Chief of Staff John Kelly destroys liberal reporters: "It is astounding to me how much is misreported." https://t.co/ggiHD3wKFU Unknown 1 English 1 2017-10-12T18:38:00 2017-10-12T18:38:00 1070 10395 318   0 0
30 906000000000000000 10_GOP 1 So we’ve gone from “Russia literally hacked the election for Trump” to “Russians helped Trump get elected by hacking Pokemon GO." Amazing! https://t.co/5IN03y54Ul Unknown 1 English 1 2017-10-12T20:01:00 2017-10-12T20:01:00 1070 10397 319   0 0
32 906000000000000000 10_GOP 1 '@realDonaldTrump We love you Mr. President!' Unknown 1 English 1 2017-10-12T20:19:00 2017-10-12T20:19:00 1070 10400 321   0 0
33 906000000000000000 10_GOP 1 '@realDonaldTrump Thank you for being the @POTUS we elected!' Unknown 1 English 1 2017-10-12T20:21:00 2017-10-12T20:21:00 1070 10400 322   0 0
37 906000000000000000 10_GOP 1 BOOM! Judge Napolitano calls out Hillary for bogus claim she can’t return Weinstein donation. https://t.co/bd8nrMxVWw Unknown 1 English 1 2017-10-12T22:26:00 2017-10-12T22:26:00 1070 10403 326   0 0
38 906000000000000000 10_GOP 1 Burgess Owens on the NFL protest: "One thing about leftists, they are all about principle until the dollars start leaving their pocketbooks" https://t.co/lZXtXdfoVW Unknown 1 English 1 2017-10-12T22:37:00 2017-10-12T22:37:00 1070 10405 327   0 0
39 906000000000000000 10_GOP 1 Let's show Sean Hannity some love! Take a minute to call his hotline (877) 225-8587. Let him know how much we support him! https://t.co/QMi3iTWaDX Unknown 1 English 1 2017-10-12T02:16:00 2017-10-12T02:16:00 1071 10363 316   0 0
40 906000000000000000 10_GOP 1 A cute 10 yo girl had a Trump dress on. Hannity asked her why she liked him. She said because he's doing great things for the country! ❤️❤️ https://t.co/QzXbuPgH2B Unknown 1 English 1 2017-10-12T03:02:00 2017-10-12T03:03:00 1072 10366 317   0 0
42 906000000000000000 10_GOP 1 Happy Birthday to the U.S. Navy and thank you to all the brave women and men who protect and serve! https://t.co/MwnTEOE59J Unknown 1 English 1 2017-10-13T20:15:00 2017-10-13T20:15:00 1070 10441 332   0 0
45 906000000000000000 10_GOP 1 “It was straight up prostitution and that’s the way Hollywood is run these days” ~ @Joy_Villa https://t.co/5peu8ZFbeA Unknown 1 English 1 2017-10-13T22:00:00 2017-10-13T22:01:00 1071 10442 335   0 0
49 906000000000000000 10_GOP 1 Liberals would rather side with Iran, North Korea, and Cuba then our President, our country, and our allies Israel, Japan, S. Korea. Sad! Unknown 1 English 1 2017-10-13T23:26:00 2017-10-13T23:26:00 1071 10445 339   0 0
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
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
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
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
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

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 2896.318ms · Data source: fivethirtyeight/russian-troll-tweets