home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

14,705 rows where author = 571

View and edit SQL

Suggested facets: post_type

region

author

account_category

Link rowid external_author_id author content region language publish_date harvested_date following followers updates post_type new_june_2018 retweet
611710 2882350436 CHRIXMORGAN 571 Not many sounds are worse than someone you can't stand chewing an apple United States 2 English 1 2016-01-10T12:52:00 2016-01-10T12:52:00 6427 12494 2141 RETWEET 1 0 1
611711 2882350436 CHRIXMORGAN 571 #WhatYouNeedIn5Words I need about tree fiddy United States 2 English 1 2017-01-10T08:27:00 2017-01-10T08:27:00 9744 20125 15259 RETWEET 1 0 1
611712 2882350436 CHRIXMORGAN 571 A surprise twist before inauguration... #WhatYouNeedIn5Words https://t.co/XUZlfXo6j7 United States 2 English 1 2017-01-10T08:27:00 2017-01-10T08:27:00 9744 20125 15260 RETWEET 1 0 1
611713 2882350436 CHRIXMORGAN 571 Brains, Heart, Courage, Great Shoes. #WhatYouNeedIn5Words https://t.co/ybv3S5zGDu United States 2 English 1 2017-01-10T08:28:00 2017-01-10T08:28:00 9744 20125 15261 RETWEET 1 0 1
611714 2882350436 CHRIXMORGAN 571 #WhatYouNeedIn5Words Ability to read women's minds United States 2 English 1 2017-01-10T08:39:00 2017-01-10T08:39:00 9744 20126 15262 RETWEET 1 0 1
611715 2882350436 CHRIXMORGAN 571 You have been played by Ben Affleck in a movie at some point. #SignsYoureASuperhero United States 2 English 1 2017-01-10T08:40:00 2017-01-10T08:41:00 9744 20126 15263 RETWEET 1 0 1
611716 2882350436 CHRIXMORGAN 571 #SignsYoureASuperhero surving politics and you're still complaining� United States 2 English 1 2017-01-10T08:43:00 2017-01-10T08:43:00 9744 20126 15266 RETWEET 1 0 1
611717 2882350436 CHRIXMORGAN 571 #SignsYoureASuperhero when you put on glasses no one recognizes you https://t.co/sNQdjkskWL United States 2 English 1 2017-01-10T08:43:00 2017-01-10T08:43:00 9742 20127 15265   0 0
611718 2882350436 CHRIXMORGAN 571 '@mselayan and to wear panties over pants �� #SignsYoureASuperhero' United States 2 English 1 2017-01-10T08:45:00 2017-01-10T08:45:00 9744 20126 15267   0 0
611719 2882350436 CHRIXMORGAN 571 You don't kill someone when they're eating loudly! �� #SignsYoureASuperhero United States 2 English 1 2017-01-10T08:46:00 2017-01-10T08:46:00 9744 20126 15268 RETWEET 1 0 1
611720 2882350436 CHRIXMORGAN 571 You get hit by a train and the train comes off worse #SignsYoureASuperhero United States 2 English 1 2017-01-10T08:48:00 2017-01-10T08:48:00 9744 20126 15269 RETWEET 1 0 1
611721 2882350436 CHRIXMORGAN 571 #SignsYoureASuperhero when you put on glasses no one recognizes you https://t.co/sNQdjkskWL United States 2 English 1 2017-01-10T08:51:00 2017-01-10T08:51:00 9744 20126 15270 RETWEET 1 0 1
611722 2882350436 CHRIXMORGAN 571 You enounter a lot of people w/the irrational desire to destroy the world they themselves need to survive. #SignsYoureASuperhero United States 2 English 1 2017-01-10T08:52:00 2017-01-10T08:52:00 9744 20126 15271 RETWEET 1 0 1
611723 2882350436 CHRIXMORGAN 571 This week's @WorldOfHashtags hosted by @AndyHashtagger is #IfIWereACop ���� United States 2 English 1 2016-01-11T14:05:00 2016-01-11T14:05:00 6422 12488 2143 RETWEET 1 0 1
611724 2882350436 CHRIXMORGAN 571 #IfIWereACop I wouldn't be Chris Morgan United States 2 English 1 2016-01-11T14:05:00 2016-01-11T14:05:00 6422 12488 2145   0 0
611725 2882350436 CHRIXMORGAN 571 #IfIWereACop �� I guess I would be the good one United States 2 English 1 2016-01-11T14:05:00 2016-01-11T14:06:00 6422 12488 2144 RETWEET 1 0 1
611726 2882350436 CHRIXMORGAN 571 #IfIWereACop I would serve and protect people. All kinds of people. United States 2 English 1 2016-01-11T14:06:00 2016-01-11T14:06:00 6422 12488 2147 RETWEET 1 0 1
611727 2882350436 CHRIXMORGAN 571 #IfIWereACop I would not be racist United States 2 English 1 2016-01-11T14:06:00 2016-01-11T14:07:00 6422 12488 2148 RETWEET 1 0 1
611728 2882350436 CHRIXMORGAN 571 #IfIWereACop I would have no wife United States 2 English 1 2016-01-11T14:06:00 2016-01-11T14:06:00 6422 12488 2146   0 0
611729 2882350436 CHRIXMORGAN 571 #IfIWereACop I'd be 1 of 3 in the family. United States 2 English 1 2016-01-11T14:07:00 2016-01-11T14:07:00 6422 12488 2150 RETWEET 1 0 1
611730 2882350436 CHRIXMORGAN 571 #IfIWereACop i would have Triple H's music playing on my walk up to my pulled over car United States 2 English 1 2016-01-11T14:08:00 2016-01-11T14:08:00 6422 12488 2154 RETWEET 1 0 1
611731 2882350436 CHRIXMORGAN 571 #IfIWereACop I would drink at least 40 cups of coffee per day https://t.co/53wMmiBBiT United States 2 English 1 2016-01-11T14:09:00 2016-01-11T14:09:00 6422 12488 2157 RETWEET 1 0 1
611732 2882350436 CHRIXMORGAN 571 #IfIWereACop I'd ask for King fu training instead of a gun ��✋ United States 2 English 1 2016-01-11T14:09:00 2016-01-11T14:09:00 6422 12488 2158 RETWEET 1 0 1
611733 2882350436 CHRIXMORGAN 571 #IfIWereACop I wouldn't fear anything https://t.co/JYHaRBQY1r United States 2 English 1 2016-01-11T14:10:00 2016-01-11T14:10:00 6422 12488 2159   0 0
611734 2882350436 CHRIXMORGAN 571 #IfIWereACop I'd be very pragmatic so everyone would point at me and say 'it's a fair cop' United States 2 English 1 2016-01-11T14:10:00 2016-01-11T14:11:00 6422 12488 2161 RETWEET 1 0 1
611735 2882350436 CHRIXMORGAN 571 #IfIWereACop. Would come up with a bacon filled donut United States 2 English 1 2016-01-11T14:10:00 2016-01-11T14:10:00 6422 12488 2160 RETWEET 1 0 1
611736 2882350436 CHRIXMORGAN 571 #IfIWereACop I'd be certain to take down a fine lady's particulars. United States 2 English 1 2016-01-11T14:11:00 2016-01-11T14:11:00 6422 12488 2165 RETWEET 1 0 1
611737 2882350436 CHRIXMORGAN 571 #IfIWereACop does that mean I have to drink coffee? I don't mind the donuts but coffee? United States 2 English 1 2016-01-11T14:11:00 2016-01-11T14:11:00 6422 12488 2166 RETWEET 1 0 1
611738 2882350436 CHRIXMORGAN 571 #IfIWereACop I would always carry my notebook and say things like 'I was proceeding in a northerly direction' without smiling United States 2 English 1 2016-01-11T14:11:00 2016-01-11T14:11:00 6422 12488 2167 RETWEET 1 0 1
611739 2882350436 CHRIXMORGAN 571 #IfIWereACop I wouldn't have to pay for my concealed handgun license. United States 2 English 1 2016-01-11T14:11:00 2016-01-11T14:11:00 6422 12488 2168 RETWEET 1 0 1
611740 2882350436 CHRIXMORGAN 571 #IfIWereACop I would work on my Irish accent, like the ones on the Bugs Bunny cartoons. Those cops are awesome !! United States 2 English 1 2016-01-11T14:11:00 2016-01-11T14:11:00 6422 12488 2163 RETWEET 1 0 1
611741 2882350436 CHRIXMORGAN 571 #IfIWereACop I would want to have a K-9 partner.......and a Tardis! https://t.co/wuCONwQHW3 United States 2 English 1 2016-01-11T14:11:00 2016-01-11T14:11:00 6422 12488 2162 RETWEET 1 0 1
611742 2882350436 CHRIXMORGAN 571 #IfIWereACop I wouldn't fear the #Gov United States 2 English 1 2016-01-11T14:12:00 2016-01-11T14:12:00 6422 12488 2169   0 0
611743 2882350436 CHRIXMORGAN 571 #IfIWereACop I would arrest those who steal tweets and get more RTs than the original one. United States 2 English 1 2016-01-11T14:13:00 2016-01-11T14:14:00 6422 12488 2177 RETWEET 1 0 1
611744 2882350436 CHRIXMORGAN 571 #IfIWereACop I wouldn't be paying lodge bills I just enter do my game and move you ask for money I show you a pistol United States 2 English 1 2016-01-11T14:13:00 2016-01-11T14:13:00 6422 12488 2172 RETWEET 1 0 1
611745 2882350436 CHRIXMORGAN 571 #IfIWereACop the other cops would mock my little 13-shot #Beretta .380 until I humiliated them on the gun range. United States 2 English 1 2016-01-11T14:13:00 2016-01-11T14:13:00 6422 12488 2173 RETWEET 1 0 1
611746 2882350436 CHRIXMORGAN 571 #IfIWereACop I would beat pregnant woman United States 2 English 1 2016-01-11T14:13:00 2016-01-11T14:13:00 6422 12488 2175   0 0
611747 2882350436 CHRIXMORGAN 571 #IfIWereACop I would serve in #Philadelphia United States 2 English 1 2016-01-11T14:13:00 2016-01-11T14:13:00 6422 12488 2176   0 0
611748 2882350436 CHRIXMORGAN 571 #IfIWereACop I would try to stay away from donuts. United States 2 English 1 2016-01-11T14:13:00 2016-01-11T14:13:00 6422 12488 2174 RETWEET 1 0 1
611749 2882350436 CHRIXMORGAN 571 #IfIWereACop I'd rig up a siren and flashing lights in the bedroom. United States 2 English 1 2016-01-11T14:14:00 2016-01-11T14:14:00 6422 12489 2181 RETWEET 1 0 1
611750 2882350436 CHRIXMORGAN 571 #IfIWereACop , I would protect and serve all people of Color ! United States 2 English 1 2016-01-11T14:14:00 2016-01-11T14:14:00 6422 12489 2179 RETWEET 1 0 1
611751 2882350436 CHRIXMORGAN 571 #IfIWereACop I'd make it my life's work to switch the stereotype from donuts to ice cream �� United States 2 English 1 2016-01-11T14:14:00 2016-01-11T14:14:00 6422 12488 2178 RETWEET 1 0 1
611752 2882350436 CHRIXMORGAN 571 #IfIWereACop I'd investigate just what the hell is going on with peyton manning's forehead... https://t.co/JjHwzhaDCz United States 2 English 1 2016-01-11T14:14:00 2016-01-11T14:14:00 6422 12489 2180 RETWEET 1 0 1
611753 2882350436 CHRIXMORGAN 571 #IfIWereACop I would wear black United States 2 English 1 2016-01-11T14:15:00 2016-01-11T14:16:00 6422 12488 2183   0 0
611754 2882350436 CHRIXMORGAN 571 #IfIWereACop I'd be John McClane. United States 2 English 1 2016-01-11T14:16:00 2016-01-11T14:18:00 6422 12488 2185 RETWEET 1 0 1
611755 2882350436 CHRIXMORGAN 571 #IfIWereACop I'd have WAYYYY fewer black friends... United States 2 English 1 2016-01-11T14:16:00 2016-01-11T14:16:00 6422 12488 2188 RETWEET 1 0 1
611756 2882350436 CHRIXMORGAN 571 #IfIWereACop I'd stream all my video online so parents can see just how fucking stupid their kids are being. United States 2 English 1 2016-01-11T14:16:00 2016-01-11T14:18:00 6422 12488 2189 RETWEET 1 0 1
611757 2882350436 CHRIXMORGAN 571 #IfIWereACop I would shoot just as many white people as black people #BlackLivesMatters United States 2 English 1 2016-01-11T14:16:00 2016-01-11T14:16:00 6422 12488 2187 RETWEET 1 0 1
611758 2882350436 CHRIXMORGAN 571 #IfIWereACop I would be fired in the end of month after not making enough arrests... #quota United States 2 English 1 2016-01-11T14:17:00 2016-01-11T14:17:00 6422 12488 2194 RETWEET 1 0 1
611759 2882350436 CHRIXMORGAN 571 #IfIWereACop I would fuck the victims https://t.co/RSIeYfC2S7 United States 2 English 1 2016-01-11T14:17:00 2016-01-11T14:17:00 6422 12488 2190   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 255.926ms · Data source: fivethirtyeight/russian-troll-tweets