home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

1,685 rows where language = 21

View and edit SQL

Suggested facets: region, post_type, account_type, new_june_2018, retweet, account_category

Link rowid external_author_id author content region language publish_date harvested_date following followers updates post_type new_june_2018 retweet
6195 3312143142 4MYSQUAD 10 thnx 4 Boost, mane https://t.co/Gw2rWdDwMD United States 2 Farsi (Persian) 21 2015-10-04T18:46:00 2015-10-04T18:46:00 1173 909 3610 QUOTE_TWEET 2 0 1
8144 3312143142 4MYSQUAD 10 f*ckin shiiid((( https://t.co/EqBhJbjPPz United States 2 Farsi (Persian) 21 2015-08-25T11:43:00 2015-08-25T11:43:00 1314 411 803 QUOTE_TWEET 2 0 1
8339 3312143142 4MYSQUAD 10 '@Mimi_La_Reina Yes bae. I'll share. #BlackFam' United States 2 Farsi (Persian) 21 2015-08-26T17:41:00 2015-08-26T17:41:00 825 518 1074   0 0
9901 3312143142 4MYSQUAD 10 '@Xpressionable @CCN_Updates @GuardianUS @AlterNet @AnonCopWatch @drumbeats4peace @BlueNationRev @KilledByCops @miserablecitytv thnkx 4 boost' United States 2 Farsi (Persian) 21 2015-09-30T19:33:00 2015-09-30T19:33:00 1938 873 3395   0 0
10014 3312143142 4MYSQUAD 10 '@CakeBossBuddy Nasty shit, mane' United States 2 Farsi (Persian) 21 2015-09-09T01:58:00 2015-09-09T01:58:00 1311 620 2106   0 0
15272 2534421182 ABIGAILSSILK 28 Kim kardashian's ice bucket challenge http://t.co/BieiCRtHLF Kim kardashian's ice bucket challenge United States 2 Farsi (Persian) 21 2015-01-25T19:59:00 2015-01-25T19:59:00 295 104 726   0 0
15784 2534421182 ABIGAILSSILK 28 Oh, moon of alabama #America United States 2 Farsi (Persian) 21 2014-12-06T09:02:00 2014-12-06T09:03:00 299 95 410   0 0
16039 2534421182 ABIGAILSSILK 28 Good Morning Kardashians!!! @midnight #CaliforniaMovies United States 2 Farsi (Persian) 21 2017-03-07T09:47:00 2017-03-07T09:47:00 3464 2511 2099   0 0
16135 2534421182 ABIGAILSSILK 28 #StonedComicBooks Hash Gordon United States 2 Farsi (Persian) 21 2017-04-20T08:57:00 2017-04-20T08:57:00 3696 2862 2332   0 0
16411 2534421182 ABIGAILSSILK 28 Don't hashtag much #DescribeBabiesIn3Words United States 2 Farsi (Persian) 21 2015-07-16T12:09:00 2015-07-16T12:09:00 106 210 1049 RETWEET 1 0 1
22718 1652138929 ACEJINEV 38 http://t.co/ZsEIdQoQme Kim kardashian's ice bucket challenge Unknown 1 Farsi (Persian) 21 2015-03-18T12:25:00 2015-03-18T12:25:00 260 87 358   0 0
26056 1670762347 ADAMCHAPMANJR 42 #RobandChyna \| Rob Kardashian wants a fresh start \| E! [VIDEO] https://t.co/h9twhsoDPr https://t.co/dZjQ5cHBKo United States 2 Farsi (Persian) 21 2016-10-06T23:52:00 2016-10-06T23:52:00 582 943 2069 RETWEET 1 0 1
27960 1660099243 ADELE_BROCK 46 http://t.co/TktEwn8aZ7 Kim kardashian's ice bucket challenge United States 2 Farsi (Persian) 21 2015-07-03T11:32:00 2015-07-03T11:32:00 53 59 356   1 0
28090 2591304615 ADKEZLATE 50 #TrumpenASong She don't lie, she don't lie, she don't lie, Rogaine United States 2 Farsi (Persian) 21 2015-08-15T15:16:00 2015-08-15T15:16:00 225 229 794 RETWEET 1 1 1
35597 1660186831 ADRGREERR 54 GOD DAMNIT MAROSH! http://t.co/TrPdbcpgQ1 United States 2 Farsi (Persian) 21 2015-03-17T16:22:00 2015-03-17T16:23:00 269 92 260   0 0
35882 1660186831 ADRGREERR 54 Guys, new hashtag #SearchesGoogleIsAshamedOf � @secretbee1 @swissmistress @spencedbyus @Ckandrew14 @Giutarman @TheSiouxfan @JRNoblin United States 2 Farsi (Persian) 21 2015-05-23T18:47:00 2015-05-23T18:47:00 270 95 391 RETWEET 1 0 1
37731 1657833811 ADRIENNE_GG 57 #4 Hashtag USA #How2016CanRedeemItself w/@thebruceharris @firstandmonday United States 2 Farsi (Persian) 21 2016-12-02T14:42:00 2016-12-02T14:42:00 2182 2489 2668 RETWEET 1 0 1
38133 1657833811 ADRIENNE_GG 57 #ILikePeopleWho share pizza United States 2 Farsi (Persian) 21 2017-02-06T15:47:00 2017-02-06T15:47:00 3398 3741 3295 RETWEET 1 0 1
38297 1657833811 ADRIENNE_GG 57 rank more Boost #UnlikelyMagic8BallAnswers https://t.co/7Nf56OM66v United Kingdom 9 Farsi (Persian) 21 2017-03-12T14:14:00 2017-03-12T14:14:00 3692 4398 3590   0 0
38425 1657833811 ADRIENNE_GG 57 http://t.co/ubqIdjoz5e more cash bae *_* United States 2 Farsi (Persian) 21 2015-03-16T14:39:00 2015-03-16T14:39:00 150 142 667   0 0
39004 1657833811 ADRIENNE_GG 57 RT @ChrisElmlund: #ObamaNextJob Gun salesman. United States 2 Farsi (Persian) 21 2016-06-21T16:35:00 2016-06-21T16:35:00 989 479 1045   0 0
39118 1657833811 ADRIENNE_GG 57 #DontTellAnyoneBut I'm REALLY Kim Kardashian https://t.co/TNrGogfygS United States 2 Farsi (Persian) 21 2016-08-10T15:26:00 2016-08-10T15:27:00 1492 726 1230 RETWEET 1 0 1
44088 2657041133 AHMADHUSSEINII 73 #داعش #باريس https://t.co/oYLqJfEhVn Israel 6 Farsi (Persian) 21 2015-11-22T09:18:00 2015-11-22T09:18:00 122 8 781 QUOTE_TWEET 2 1 1
44142 2657041133 AHMADHUSSEINII 73 '@dw_arabic @YouTube نموذج جديد من سيارات مازدا لم نشهده من قبل' Israel 6 Farsi (Persian) 21 2015-11-28T09:39:00 2015-11-28T09:39:00 577 56 1406   1 0
44361 2186395434 AHMADYUSUFF03 76 Rabih Baroud khayef Sammiki Omri ربيع بارود خايف سميكي عمري https://t.co/6LNZTNnBQX عبر @YouTube Turkey 11 Farsi (Persian) 21 2015-10-14T12:33:00 2015-10-14T12:33:00 2001 515 1921   0 0
44445 2186395434 AHMADYUSUFF03 76 يسعد صباحكم احلى ناس https://t.co/aXG8qvFox8 عبر @YouTube Israel 6 Farsi (Persian) 21 2015-10-27T08:02:00 2015-10-27T08:02:00 2086 519 3207   0 0
44458 2186395434 AHMADYUSUFF03 76 اشتقتلك ياوجعي https://t.co/aFn4QubZh6 عبر @YouTube Israel 6 Farsi (Persian) 21 2015-11-01T10:27:00 2015-11-01T10:27:00 2130 514 3561   0 0
44509 2186395434 AHMADYUSUFF03 76 #بلجيكا تحارب #داعش!!! https://t.co/jxIpfiymLR Unknown 1 Farsi (Persian) 21 2015-11-19T11:59:00 2015-11-19T12:00:00 2545 561 5047   0 0
44513 2186395434 AHMADYUSUFF03 76 فيس بوك يقفل حساب #داعش https://t.co/fo4uOTPfBt Unknown 1 Farsi (Persian) 21 2015-11-19T14:26:00 2015-11-19T14:26:00 2550 561 5082 QUOTE_TWEET 2 0 1
47372 2570250275 AIDEN7757 81 #ThingsPeopleOnTwitterLike A Pine Fresh Scent United States 2 Farsi (Persian) 21 2016-11-08T10:04:00 2016-11-08T10:04:00 1957 1829 2346   0 0
47667 2570250275 AIDEN7757 81 #makecelebscute Ashton coochie-coochie-Kutcher #SometimesTwitterMakesMe   Farsi (Persian) 21 2016-12-22T09:18:00 2016-12-22T09:24:00 2676 2649 3214   0 0
47767 2570250275 AIDEN7757 81 #2016In4Words Good gosh all mighty. United States 2 Farsi (Persian) 21 2016-12-28T16:06:00 2016-12-28T16:06:00 2480 2638 3368 RETWEET 1 0 1
48108 2570250275 AIDEN7757 81 #ILikePeopleWho share pizza United States 2 Farsi (Persian) 21 2017-02-06T15:20:00 2017-02-06T15:20:00 2818 3212 3758 RETWEET 1 0 1
48766 2570250275 AIDEN7757 81 Don't hashtag much #DescribeBabiesIn3Words United States 2 Farsi (Persian) 21 2015-07-16T11:32:00 2015-07-16T11:34:00 287 145 892 RETWEET 1 0 1
48904 2570250275 AIDEN7757 81 #DontTellAnyoneBut I'm REALLY Kim Kardashian https://t.co/TNrGogfygS United States 2 Farsi (Persian) 21 2016-08-10T14:41:00 2016-08-10T14:41:00 1908 857 1360 RETWEET 1 0 1
49124 2570250275 AIDEN7757 81 Stacy Dash #mustbebanned United States 2 Farsi (Persian) 21 2016-08-24T15:52:00 2016-08-24T15:52:00 1406 1133 1658   0 0
51580 1683415466 ALBERTA_HAYNESS 87 Kim kardashian's ice bucket challenge http://t.co/MR3DuERgWm Kim kardashian's ice bucket challenge United States 2 Farsi (Persian) 21 2015-07-04T08:54:00 2015-07-04T08:54:00 94 49 346   0 0
56321 3083086600 ALDRICH420 90 Tah-Dah! Turkey's done. #RealLifeMagicSpells United States 2 Farsi (Persian) 21 2016-11-14T14:41:00 2016-11-14T14:42:00 1665 1530 1293 RETWEET 1 0 1
62489 1652987412 ALECMOOOOODY 91 Shameful https://t.co/VxwpoG6ZGL United States 2 Farsi (Persian) 21 2016-11-09T23:41:00 2016-11-09T23:42:00 530 907 3939 RETWEET 1 0 1
71121 2586506586 ALEXHARRITONOV 100 Demi Moore, 1981 https://t.co/mAgg9bTWoW https://t.co/AdbXh4GiKy Azerbaijan 7 Farsi (Persian) 21 2017-03-15T00:16:00 2017-03-15T00:16:00 132 1975 5472 RETWEET 1 0 1
84660 1706359664 ALMOSTSAINTGIRL 127 https://t.co/atyfmSTIy4 tasty cookies...��� United States 2 Farsi (Persian) 21 2015-07-03T09:02:00 2015-07-03T09:02:00 53 48 236   1 0
85666 1677511772 ALYSSABEDOLLA 134 Corned Beef Hashtag #MakeTechEdible @NoompsyDahling #JustNeighing United States 2 Farsi (Persian) 21 2015-05-18T15:05:00 2015-05-18T15:05:00 281 257 670 RETWEET 1 0 1
85747 1677511772 ALYSSABEDOLLA 134 #ThingsITryToForgetButCant hashtag games United States 2 Farsi (Persian) 21 2015-06-27T16:25:00 2015-06-27T16:25:00 278 251 696   0 0
85862 1677511772 ALYSSABEDOLLA 134 Crash random cars #MyDoomsdayPlans United States 2 Farsi (Persian) 21 2015-08-30T14:43:00 2015-08-30T14:43:00 276 244 781   0 0
86873 2616344667 AMANDAVGREEN 138 #AlternativeUsesForABoner Bachelor/ettes hat stand. United States 2 Farsi (Persian) 21 2015-10-08T08:26:00 2015-10-08T08:26:00 826 911 1291 RETWEET 1 0 1
87085 2616344667 AMANDAVGREEN 138 Win lottery. Marry nymphomaniac. #WhatIWantForChristmasIn4Words United States 2 Farsi (Persian) 21 2016-11-24T08:08:00 2016-11-24T08:08:00 3486 3821 4866 RETWEET 1 0 1
87312 2616344667 AMANDAVGREEN 138 #ICelebrateTrumpWith a hashtag game United States 2 Farsi (Persian) 21 2016-11-09T16:17:00 2016-11-09T16:19:00 3297 3558 4497 RETWEET 1 0 1
88541 2616344667 AMANDAVGREEN 138 Hash Gordon #StonedComicBooks @midnight United States 2 Farsi (Persian) 21 2017-04-20T08:43:00 2017-04-20T08:43:00 5908 7400 6694   0 0
89115 2616344667 AMANDAVGREEN 138 Sweat Home Alabama #SummerAMovie United States 2 Farsi (Persian) 21 2017-06-23T10:02:00 2017-06-23T10:02:00 5509 7143 6743   0 0
89130 2616344667 AMANDAVGREEN 138 #ThingsITryToForgetButCant hashtag games United States 2 Farsi (Persian) 21 2015-06-27T15:05:00 2015-06-27T15:05:00 182 286 1189   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 60.484ms · Data source: fivethirtyeight/russian-troll-tweets