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
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
3 906000000000000000 10_GOP 1 Daughter of fallen Navy Sailor delivers powerful monologue on anthem protests, burns her NFL packers gear. #BoycottNFL https://t.co/qDlFBGMeag Unknown 1 English 1 2017-10-01T22:50:00 2017-10-01T22:51:00 1054 9637 255 RETWEET 1 0 1
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
5 906000000000000000 10_GOP 1 19,000 RESPECTING our National Anthem! #StandForOurAnthem🇺🇸 https://t.co/czutyGaMQV Unknown 1 English 1 2017-10-01T02:13:00 2017-10-01T02:13:00 1050 9645 246 RETWEET 1 0 1
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
7 906000000000000000 10_GOP 1 🐝🐝🐝 https://t.co/MorL3AQW0z Unknown 1 English 1 2017-10-01T02:48:00 2017-10-01T02:48:00 1050 9644 248 RETWEET 1 0 1
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
18 906000000000000000 10_GOP 1 BREAKING: The audio of sexual predator Harvey Weinstein admitting to assaulting model Ambra Gutierrez has leaked. I am truly disgusted. https://t.co/ka1nhd0ReR Unknown 1 English 1 2017-10-11T00:49:00 2017-10-11T00:49:00 1069 10330 305 RETWEET 1 0 1
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
21 906000000000000000 10_GOP 1 Because he hates women so much, President Trump just nominated another woman, Kirstjen Nielsen, to be in his Cabinet. Unknown 1 English 1 2017-10-11T22:14:00 2017-10-11T22:14:00 1070 10358 309 RETWEET 1 0 1
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
24 906000000000000000 10_GOP 1 I am an Eagle Scout Only boys should be in Boy Scouts Only girls should be in Girl Scouts Don't change things that work Unknown 1 English 1 2017-10-11T23:22:00 2017-10-11T23:22:00 1070 10362 312 RETWEET 1 0 1
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
26 906000000000000000 10_GOP 1 Do you agree with the Boy Scouts for allowing girls to join? Unknown 1 English 1 2017-10-12T00:12:00 2017-10-12T00:12:00 1070 10362 313 RETWEET 1 0 1
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
29 906000000000000000 10_GOP 1 Network news has become so partisan, distorted and fake that licenses must be challenged and, if appropriate, revoked. Not fair to public! Unknown 1 English 1 2017-10-12T01:40:00 2017-10-12T01:40:00 1071 10363 315 RETWEET 1 0 1
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
31 906000000000000000 10_GOP 1 To be clear, when we say "Pokémon Go was used" we mean "there is no evidence Pokemon Go was used" https://t.co/R5uvyhZIE5 Unknown 1 English 1 2017-10-12T20:03:00 2017-10-12T20:03:00 1070 10397 320 RETWEET 1 0 1
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
34 906000000000000000 10_GOP 1 So wait, did the Russians also purchase Hillary Clinton? "Pokemon Go to the polls"! https://t.co/2I1ayPLMBu Unknown 1 English 1 2017-10-12T20:31:00 2017-10-12T20:32:00 1070 10399 323 RETWEET 1 0 1
35 906000000000000000 10_GOP 1 Students describe what it’s like being a conservative on a college campus. The described behavior is inexplicable and inexcusable. https://t.co/OBEZKBTamL Unknown 1 English 1 2017-10-12T20:54:00 2017-10-12T20:55:00 1070 10401 324 RETWEET 1 0 1
36 906000000000000000 10_GOP 1 Eminem is a Trump supporter?! 😮 https://t.co/JnCUJ7sqnU Unknown 1 English 1 2017-10-12T21:38:00 2017-10-12T21:38:00 1070 10401 325 RETWEET 1 0 1
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
41 906000000000000000 10_GOP 1 Is this real? https://t.co/QUTSZc3quW Unknown 1 English 1 2017-10-13T00:39:00 2017-10-13T00:40:00 1071 10414 328 RETWEET 1 0 1
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
43 906000000000000000 10_GOP 1 oh https://t.co/XU3MBQ5f2K Unknown 1 English 1 2017-10-13T20:23:00 2017-10-13T20:23:00 1070 10441 333 RETWEET 1 0 1
44 906000000000000000 10_GOP 1 President Trump: #Iran was Economically BANKRUPT until Obama gifted them 1.7 BILLION in CASH & infused 150 BILLION into their economy ...... https://t.co/GocTNG4KyL Unknown 1 English 1 2017-10-13T20:38:00 2017-10-13T20:38:00 1070 10441 334 RETWEET 1 0 1
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
46 906000000000000000 10_GOP 1 All of the good guys I know wanted us out of Iran deal and all of the globalists wanted us in it. Look at whose mad today - deep state. Unknown 1 English 1 2017-10-13T22:01:00 2017-10-13T22:01:00 1071 10442 336 RETWEET 1 0 1
47 906000000000000000 10_GOP 1 NFL having to write out how players conduct themselves during the anthem is HILARIOUS. I learned how to honor the flag in GRADE SCHOOL #MAGA https://t.co/pe7ijVpslF Unknown 1 English 1 2017-10-13T22:31:00 2017-10-13T22:31:00 1071 10443 337 RETWEET 1 0 1
48 906000000000000000 10_GOP 1 Dear CNN: When will you be interviewing one of the mayors in Puerto Rico's other 77 municipios? https://t.co/MKNFP3IHZe Unknown 1 English 1 2017-10-13T23:07:00 2017-10-13T23:07:00 1071 10445 338 RETWEET 1 0 1
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
50 906000000000000000 10_GOP 1 .@Joy_Villa: The Hollywood swamp is starting to crumble. If Weinstein is getting pulled to the surface, all these other smaller players will https://t.co/9j2wgxnMwH Unknown 1 English 1 2017-10-13T02:26:00 2017-10-13T02:26:00 1071 10417 329 RETWEET 1 0 1

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