home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

122,582 rows where account_category = 8

View and edit SQL

author

region

account_category

Link rowid external_author_id author content region language publish_date harvested_date following followers updates post_type new_june_2018 retweet
132972 813407000000000000 AMYGRABMYESSAY 154 Guide to Writing Research Papers in APA Style https://t.co/cOR0H2X96x https://t.co/P2r2nVjqNB United States 2 English 1 2017-01-01T10:12:00 2017-01-01T10:12:00 1040 39 52 RETWEET 1 1 1
132973 813407000000000000 AMYGRABMYESSAY 154 Why Classroom Allergies Were The Worst - https://t.co/EMfO3R0ycu https://t.co/aUjdNUC1xG United States 2 English 1 2017-01-01T11:57:00 2017-01-01T11:57:00 1040 40 53 RETWEET 1 1 1
132974 813407000000000000 AMYGRABMYESSAY 154 Don't come to class next week, I am going to be sick. (c) Greatest College Professor Ever https://t.co/0dbna978dr United States 2 English 1 2017-01-01T13:27:00 2017-01-01T13:27:00 1040 40 54 RETWEET 1 1 1
132975 813407000000000000 AMYGRABMYESSAY 154 Don't come to class next week, I am going to be sick. (c) Greatest College Professor Ever https://t.co/igbTgwawIF United States 2 English 1 2017-01-01T16:52:00 2017-01-01T16:52:00 949 40 56 RETWEET 1 1 1
132976 813407000000000000 AMYGRABMYESSAY 154 15 Idiots On Facebook Getting Called Out - https://t.co/4A0xFzbaaY https://t.co/VbMVNsINVE United States 2 English 1 2017-01-01T20:13:00 2017-01-01T20:13:00 846 43 58 RETWEET 1 1 1
132977 813407000000000000 AMYGRABMYESSAY 154 18 Pop Culture Billionaires Ranked - https://t.co/T3vMPaAT23 https://t.co/HiFN3kG9ci United States 2 English 1 2017-01-01T05:06:00 2017-01-01T05:06:00 1040 40 49 RETWEET 1 1 1
132978 813407000000000000 AMYGRABMYESSAY 154 https://t.co/Qmt2LttaHX United States 2 English 1 2017-01-01T07:15:00 2017-01-01T07:15:00 1040 39 50 RETWEET 1 1 1
132979 813407000000000000 AMYGRABMYESSAY 154 10 Gifs of Robot Sex Stuff That Are Really Weird and Not Even A Little Sexy - https://t.co/xyRIQRoLWz https://t.co/YeM5TJasro United States 2 English 1 2017-01-10T11:14:00 2017-01-10T11:14:00 2648 93 164 RETWEET 1 1 1
132980 813407000000000000 AMYGRABMYESSAY 154 10 Unfortunate People Who Got Hilariously Ripped Off - https://t.co/gWwY8SsuLJ https://t.co/ptnLTHxaLv United States 2 English 1 2017-01-10T14:11:00 2017-01-10T14:11:00 2640 96 165 RETWEET 1 1 1
132981 813407000000000000 AMYGRABMYESSAY 154 National Cut Your Energy Costs Day https://t.co/POOyMQnTx6 United States 2 English 1 2017-01-10T15:14:00 2017-01-10T15:14:00 2670 97 166 RETWEET 1 1 1
132982 813407000000000000 AMYGRABMYESSAY 154 13 Tinderers Who've Mastered The Art Of Innuendo - https://t.co/DK4j4Nz6TN https://t.co/sVmmmHjYg9 United States 2 English 1 2017-01-10T17:04:00 2017-01-10T17:04:00 2727 99 167 RETWEET 1 1 1
132983 813407000000000000 AMYGRABMYESSAY 154 25 Facebook Posts That Might Make You Give Up on Humanity - https://t.co/2MOBnfzqJC https://t.co/WxxWVTbU0g United States 2 English 1 2017-01-10T18:09:00 2017-01-10T18:09:00 2755 101 168 RETWEET 1 1 1
132984 813407000000000000 AMYGRABMYESSAY 154 If Fictional Characters Acted Like Their Fans - https://t.co/c9B38zwW3q https://t.co/XosYAnJSqi United States 2 English 1 2017-01-10T19:15:00 2017-01-10T19:16:00 2792 101 169 RETWEET 1 1 1
132985 813407000000000000 AMYGRABMYESSAY 154 15 Late-Era Simpsons Jokes That Are Genuinely Great - https://t.co/IRz3KF3cpK https://t.co/lbiVvcikOK United States 2 English 1 2017-01-10T04:51:00 2017-01-10T04:51:00 2771 92 160 RETWEET 1 1 1
132986 813407000000000000 AMYGRABMYESSAY 154 13 Tweets That We Guarantee Will Make You Smile A Little Bit - https://t.co/4L40n0VMhy https://t.co/Q25dNJVkhl United States 2 English 1 2017-01-10T07:28:00 2017-01-10T07:29:00 2672 93 161 RETWEET 1 1 1
132987 813407000000000000 AMYGRABMYESSAY 154 10 Times Tumblr Avatar Posts Made Us Super Nostalgic - https://t.co/R0nRXvotZ8 https://t.co/fvKTknswaP United States 2 English 1 2017-01-10T08:56:00 2017-01-10T08:57:00 2663 93 162 RETWEET 1 1 1
132988 813407000000000000 AMYGRABMYESSAY 154 17 Terrifying Toys That Need to be Burned in a Fire - https://t.co/RxfrnDO7QW https://t.co/vqtdf06sYl United States 2 English 1 2017-01-10T09:52:00 2017-01-10T09:53:00 2663 93 163 RETWEET 1 1 1
132989 813407000000000000 AMYGRABMYESSAY 154 A "joint" statement? I bet it's that they love smokin em, amirite!? ������� https://t.co/MmCwtgvHsE United States 2 English 1 2017-01-11T11:22:00 2017-01-11T11:22:00 2882 106 173 RETWEET 1 1 1
132990 813407000000000000 AMYGRABMYESSAY 154 15 People Admit The Secret That Could Literally Ruin Their Life - https://t.co/9TruHmmb8B https://t.co/MwznPaUW16 United States 2 English 1 2017-01-11T12:46:00 2017-01-11T12:46:00 2878 107 174 RETWEET 1 1 1
132991 813407000000000000 AMYGRABMYESSAY 154 12 Clever Tinderers That Know How To Play The Game - https://t.co/Yc96O7Qo4k https://t.co/ZgSmX45bI0 United States 2 English 1 2017-01-11T13:52:00 2017-01-11T13:52:00 2896 106 175 RETWEET 1 1 1
132992 813407000000000000 AMYGRABMYESSAY 154 International Thank You Day https://t.co/YDpLKk3zmk United States 2 English 1 2017-01-11T16:58:00 2017-01-11T16:59:00 2960 107 176 RETWEET 1 1 1
132993 813407000000000000 AMYGRABMYESSAY 154 The 6 Creatures in Every Comment Section (Besides Trolls) - https://t.co/slS6WDStHz https://t.co/rli8Ji4KYH United States 2 English 1 2017-01-11T19:24:00 2017-01-11T19:24:00 3045 110 178 RETWEET 1 1 1
132994 813407000000000000 AMYGRABMYESSAY 154 If Harry Potter Had a Yearbook - https://t.co/JMBmLJzrRS https://t.co/VaVGWUpC3O United States 2 English 1 2017-01-11T20:54:00 2017-01-11T20:57:00 3076 113 177 RETWEET 1 1 1
132995 813407000000000000 AMYGRABMYESSAY 154 How Skyrim Prepares You For a Life as a Professional Artist - https://t.co/7LogXFLWaf https://t.co/GOSTykJaap United States 2 English 1 2017-01-11T04:28:00 2017-01-11T04:28:00 2945 108 171 RETWEET 1 1 1
132996 813407000000000000 AMYGRABMYESSAY 154 10 Yelp Reviews That Deserver Five Stars - https://t.co/Na7IeHD19w https://t.co/19LNji2InV United States 2 English 1 2017-01-11T07:39:00 2017-01-11T07:39:00 2855 108 172 RETWEET 1 1 1
132997 813407000000000000 AMYGRABMYESSAY 154 What You Want As a Kid vs What You Want as an Adult - https://t.co/q6LyfkdMYC https://t.co/GhZ9Gm5m7i United States 2 English 1 2017-01-12T10:19:00 2017-01-12T10:19:00 2915 121 182 RETWEET 1 1 1
132998 813407000000000000 AMYGRABMYESSAY 154 16 Honest Tinder Users Who Took The Straightforward Approach - https://t.co/F0zvycRldF https://t.co/adrqY6O7lR United States 2 English 1 2017-01-12T13:58:00 2017-01-12T13:59:00 2872 123 183 RETWEET 1 1 1
132999 813407000000000000 AMYGRABMYESSAY 154 This Oreo shake from Jack in the Box looks so good � click here for a coupon for $1 off: https://t.co/WZ2DGJKs0q #ad https://t.co/U8OCvzlRIG United States 2 English 1 2017-01-12T21:03:00 2017-01-12T21:04:00 3112 130 186 RETWEET 1 1 1
133000 813407000000000000 AMYGRABMYESSAY 154 6 Crappy Jobs of the Past You Should Be Glad Don't Exist Today - https://t.co/8qydUpxZ67 https://t.co/YRpQeVYJ1V United States 2 English 1 2017-01-12T03:09:00 2017-01-12T03:09:00 3131 114 178 RETWEET 1 1 1
133001 813407000000000000 AMYGRABMYESSAY 154 For anyone who hasn't bought books yet... https://t.co/bXqUT1lHoT United States 2 English 1 2017-01-12T04:25:00 2017-01-12T04:25:00 3160 115 179 RETWEET 1 1 1
133002 813407000000000000 AMYGRABMYESSAY 154 Why The Weasley Twins Are the Most Useless Characters in Harry Potter - https://t.co/fpi03IdOF5 https://t.co/Lhj1D2022g United States 2 English 1 2017-01-12T07:10:00 2017-01-12T07:10:00 3038 117 180 RETWEET 1 1 1
133003 813407000000000000 AMYGRABMYESSAY 154 10 Times Pornhub Proved To Be The Most Clever Porn Site - https://t.co/M3pDIlM53O https://t.co/QCukRPRtwY United States 2 English 1 2017-01-12T08:30:00 2017-01-12T08:30:00 2948 119 181 RETWEET 1 1 1
133004 813407000000000000 AMYGRABMYESSAY 154 10 Ways Cats Play Life Like a Video Game - https://t.co/eRElzVj64R https://t.co/xQ1i5Rb57O United States 2 English 1 2017-01-13T12:45:00 2017-01-13T12:46:00 2946 135 193 RETWEET 1 1 1
133005 813407000000000000 AMYGRABMYESSAY 154 7 Emojis That Would Be Useful for Sexting - https://t.co/ewDXsh8Zlt https://t.co/aCfF7eUKnR United States 2 English 1 2017-01-13T15:18:00 2017-01-13T15:18:00 2855 136 195 RETWEET 1 1 1
133006 813407000000000000 AMYGRABMYESSAY 154 12 Confusing Conversations That Could Only Happen On Tinder - https://t.co/winJUKm28k https://t.co/b9RkOuVJEk United States 2 English 1 2017-01-13T19:22:00 2017-01-13T19:23:00 3001 138 198 RETWEET 1 1 1
133007 813407000000000000 AMYGRABMYESSAY 154 10 Immature Jokes That'll Give Your Dirty Mind a Chortle - https://t.co/xcynyZABre https://t.co/v1gOYltTzj United States 2 English 1 2017-01-13T20:52:00 2017-01-13T20:52:00 3026 139 199 RETWEET 1 1 1
133008 813407000000000000 AMYGRABMYESSAY 154 12 Awful Couples Who Need to be Blasted Into Space on a F*ck Rocket - https://t.co/KSzVEenubE https://t.co/KM57rwCfi0 United States 2 English 1 2017-01-13T04:50:00 2017-01-13T04:51:00 3202 134 188 RETWEET 1 1 1
133009 813407000000000000 AMYGRABMYESSAY 154 Playing Video Games All Weekend: Childhood Vs. Adulthood - https://t.co/xbEQ4hpslT https://t.co/WCoFZD9ffT United States 2 English 1 2017-01-13T05:53:00 2017-01-13T05:53:00 3199 134 189 RETWEET 1 1 1
133010 813407000000000000 AMYGRABMYESSAY 154 Typical adult. https://t.co/8uJ9vzbS2k United States 2 English 1 2017-01-13T07:29:00 2017-01-13T07:29:00 3130 135 190 RETWEET 1 1 1
133011 813407000000000000 AMYGRABMYESSAY 154 13 Animated Characters That Look Exactly Like Their Voice Actors - https://t.co/klsSJBVcRc https://t.co/Tk7j77Zm7Q United States 2 English 1 2017-01-13T09:58:00 2017-01-13T09:58:00 3069 135 192 RETWEET 1 1 1
133012 813407000000000000 AMYGRABMYESSAY 154 National Vision Board Day https://t.co/9zDarN8YjN United States 2 English 1 2017-01-14T14:03:00 2017-01-14T14:03:00 2927 157 208 RETWEET 1 1 1
133013 813407000000000000 AMYGRABMYESSAY 154 Sorority girls pose exactly like meerkats in pictures https://t.co/3kzfEdro90 United States 2 English 1 2017-01-14T17:00:00 2017-01-14T17:01:00 2899 158 210 RETWEET 1 1 1
133014 813407000000000000 AMYGRABMYESSAY 154 15 Mistakes People Good At Resume Writing Never Make https://t.co/3bimCX5dL1 https://t.co/n27lVlrC0D United States 2 English 1 2017-01-14T19:26:00 2017-01-14T19:27:00 2865 160 212 RETWEET 1 1 1
133015 813407000000000000 AMYGRABMYESSAY 154 The Best and Worst Parts of Being Single - https://t.co/XIEJo7xWHd https://t.co/WzPDH7S4GY United States 2 English 1 2017-01-14T20:51:00 2017-01-14T20:51:00 2842 161 213 RETWEET 1 1 1
133016 813407000000000000 AMYGRABMYESSAY 154 This is all quite normal. Stream new episodes of #TheGrandTour every Friday on Prime Video - https://t.co/hsKryEqd93 [sponsored by Amazon] https://t.co/aXIGHE5H5W United States 2 English 1 2017-01-14T03:37:00 2017-01-14T03:37:00 3060 154 200 RETWEET 1 1 1
133017 813407000000000000 AMYGRABMYESSAY 154 The Truth About Monopoly Pieces - https://t.co/GUWm92fBmQ https://t.co/ht5vZv7oG7 United States 2 English 1 2017-01-14T04:35:00 2017-01-14T04:36:00 3099 156 201 RETWEET 1 1 1
133018 813407000000000000 AMYGRABMYESSAY 154 Typical adult. https://t.co/U2RgCnzcGL United States 2 English 1 2017-01-14T06:00:00 2017-01-14T06:00:00 3089 157 202 RETWEET 1 1 1
133019 813407000000000000 AMYGRABMYESSAY 154 Guide to Writing Research Papers in APA Style https://t.co/cOR0H2X96x https://t.co/xfnOn2CcC2 United States 2 English 1 2017-01-14T08:37:00 2017-01-14T08:37:00 3042 158 204 RETWEET 1 1 1
133020 813407000000000000 AMYGRABMYESSAY 154 Why The Trump Piss Story Explains EVERYTHING - https://t.co/SKMGuzSE5K https://t.co/pbEbhU4EKK United States 2 English 1 2017-01-14T09:54:00 2017-01-14T09:54:00 3006 156 205 RETWEET 1 1 1
133021 813407000000000000 AMYGRABMYESSAY 154 12 Movie Cliches That Can Officially Be Retired - https://t.co/QqMe4oeTi8 https://t.co/TxxaxGB0uP United States 2 English 1 2017-01-16T12:43:00 2017-01-16T12:43:00 2525 166 216 RETWEET 1 1 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 630.981ms · Data source: fivethirtyeight/russian-troll-tweets