home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

219 rows where language = 36

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
16663 2534421182 ABIGAILSSILK 28 Tiny Saskatoons #MakeTVShowsCanadian @midnight United States 2 Latvian 36 2017-08-03T09:30:00 2017-08-03T09:31:00 2418 2748 2515   0 0
19806 1652138929 ACEJINEV 38 WOW!! Nice panties !! Unknown 1 Latvian 36 2015-01-06T15:14:00 2015-01-06T15:14:00 89 64 26   0 0
21792 1652138929 ACEJINEV 38 Lie. Lie. Lie. Lie. #ShowYourLoveIn4Words Unknown 1 Latvian 36 2015-02-14T14:57:00 2015-02-14T14:57:00 266 88 237   0 0
39291 1657833811 ADRIENNE_GG 57 XL yoga pants #MustBeBanned United States 2 Latvian 36 2016-08-24T16:04:00 2016-08-24T16:04:00 915 1045 1468 RETWEET 1 0 1
47186 2570250275 AIDEN7757 81 #ThingsThatShouldBeCensored yoga-pants https://t.co/y2TzB7Z4O7 United States 2 Latvian 36 2016-11-23T16:04:00 2016-11-23T16:04:00 2368 2041 2592 RETWEET 1 0 1
67292 1652987412 ALECMOOOOODY 91 LIE LIE LIE LIE LIE LIE LIE LIE LIE LIE LIE LIE LIE LIE LIE LIE LIE LIELIELIELIELIELIELIELIE - @realDonaldTrump https://t.co/7rAtQBMu1e United States 2 Latvian 36 2017-08-02T05:37:00 2017-08-02T05:37:00 509 877 10377 RETWEET 1 0 1
104525 1679279490 AMELIEBALDWIN 146 PIES!!! I LUV PIE!! https://t.co/2CHlxBvgEl United States 2 Latvian 36 2016-11-24T22:42:00 2016-11-24T22:42:00 2372 2563 19139 RETWEET 1 0 1
110871 1679279490 AMELIEBALDWIN 146 Ladies Race, July 4th 1911, Valdez, Alaska. https://t.co/MXqCB4XOtr United States 2 Latvian 36 2017-02-13T05:38:00 2017-02-13T05:39:00 2333 2733 28892 RETWEET 1 0 1
124903 1679279490 AMELIEBALDWIN 146 NEVADA..UH-OH.. https://t.co/cDEGwc3wRk United States 2 Latvian 36 2016-09-17T15:11:00 2016-09-17T15:11:00 1481 2120 6400 RETWEET 1 0 1
134218 895000000000000000 AMYYSLEGENTR 156 gshelley13 piersmorgan https://t.co/ZWZ2a9rqvJ Unknown 1 Latvian 36 2017-08-17T11:25:00 2017-08-17T11:25:00 1012 52 1123 QUOTE_TWEET 2 0 1
147040 2612066397 ANDYDREWDANIELS 186 #ThingsThatShouldBeCensored yoga-pants https://t.co/y2TzB7Z4O7 United States 2 Latvian 36 2016-11-23T17:27:00 2016-11-23T17:27:00 1752 1336 1570 RETWEET 1 1 1
156967 2878166306 ANDYHASHTAGGER 187 XL yoga pants #MustBeBanned United States 2 Latvian 36 2016-08-24T15:02:00 2016-08-24T15:02:00 19760 23721 13643 RETWEET 1 1 1
177568 2500690416 ANNIEPOSHES 224 #ThingsThatShouldBeCensored yoga-pants https://t.co/y2TzB7Z4O7 United States 2 Latvian 36 2016-11-23T16:00:00 2016-11-23T16:00:00 2825 2744 3845 RETWEET 1 1 1
178059 2500690416 ANNIEPOSHES 224 Today's panties #LastMinuteGifts2016 https://t.co/Cq1s0tsXcX United States 2 Latvian 36 2016-12-22T09:11:00 2016-12-22T09:11:00 3310 3619 4509   1 0
185738 1652262638 ANTONHAYHAY 237 �����Serena Slams����� 99—�� 02—������ 03—���� 05—�� 07—�� 08—�� 09—���� 10—���� 12—���� 13—���� 14—�� 15—������ 16—�� 17—�� =23 #AusOpen United States 2 Latvian 36 2017-01-28T12:33:00 2017-01-28T12:33:00 302 693 5492 RETWEET 1 0 1
198309 87588938 ANZGRI 246 #nowplaying Crazy Penis — Friday United States 2 Latvian 36 2015-11-25T23:46:00 2015-11-25T23:47:00 35 1280 56323   0 0
198936 87588938 ANZGRI 246 #NowPlaying Boney M — Sunny https://t.co/BszFddKJd2 United States 2 Latvian 36 2016-04-22T10:13:00 2016-04-22T10:13:00 36 1288 59049   0 0
199196 87588938 ANZGRI 246 #NowPlaying 2pac — Gangsta Party United States 2 Latvian 36 2017-06-13T17:51:00 2017-06-13T17:51:00 32 1257 68190   0 0
208222 895000000000000000 ARIEENSLPE 259 IvankaTrump #Charlottesville https://t.co/0ohD29Tu1M Unknown 1 Latvian 36 2017-08-13T16:23:00 2017-08-13T16:23:00 36 6 338   0 0
208949 2620631626 ARIELLE_BROWNIN 260 WOW!! Nice panties !! United States 2 Latvian 36 2015-07-03T14:41:00 2015-07-03T14:41:00 3 0 351   0 0
209002 1527687456 ARIELSHINING 261 baby kitties http://t.co/8KOwXGrKEd United States 2 Latvian 36 2015-05-25T16:31:00 2015-05-25T16:31:00 78 55 339   0 0
220207 1671936266 ARM_2_ALAN 269 Motor City Pride Festival 2015 — Saturday #entertainment United States 2 Latvian 36 2015-06-07T02:33:00 2015-06-07T02:33:00 68 140 4652 RETWEET 1 0 1
268095 1658420976 BAOBAEHAM 326 Jay Pres @JayPrezi "Amazin" Ft. @JusSmith #Audio https://t.co/6vFX3llYyv #Midnight #Mixtape #Monday #Music #Money #Rt United States 2 Latvian 36 2017-02-21T06:47:00 2017-02-21T06:47:00 815 1092 4693 RETWEET 1 0 1
301796 715000000000000000 BERKHOFF85 371 '@madsiges @KasperLusche @MXLola5 Sarkasmus, oder?' Germany 13 Latvian 36 2016-08-05T08:27:00 2016-08-05T08:30:00 2288 1617 932   0 0
312653 725000000000000000 BERLINBOTE 372 May baut ihr Kabinett... https://t.co/nvpSesoTcX Unknown 1 Latvian 36 2016-07-14T11:21:00 2016-07-14T11:21:00 0 5 3494   0 0
325058 2732675512 BGARNER2107 384 #SurvivalGuideToThanksgiving sweatpants United States 2 Latvian 36 2016-11-21T17:11:00 2016-11-21T17:12:00 2864 2798 4291 RETWEET 1 0 1
325235 2732675512 BGARNER2107 384 #BetterElfNames Emma Ness-Mincepies United States 2 Latvian 36 2016-11-29T14:48:00 2016-11-29T14:48:00 2799 3161 4533 RETWEET 1 0 1
327481 2732675512 BGARNER2107 384 XL yoga pants #MustBeBanned United States 2 Latvian 36 2016-08-24T15:50:00 2016-08-24T15:50:00 1815 1529 3021 RETWEET 1 0 1
344156 3255856080 BIZGOD 393 Diet sodas gross @richardwinton @mumsy446 @LapBandTips @BryceJerry1 @Mattiiyaas @TheOtherBagel @WrestlerSwagCo http://t.co/8UH3ZdIFOR United States 2 Latvian 36 2015-07-03T21:09:00 2015-07-03T21:09:00 3 96 7395   1 0
374305 1687183549 BLEEPTHEPOLICE 415 NY's Shittiest! https://t.co/e66p25mf2B United States 2 Latvian 36 2016-06-27T01:20:00 2016-06-27T01:22:00 4628 9059 11035 QUOTE_TWEET 2 0 1
378861 1685173321 BLMSOLDIER 418 Atlas: Peru https://t.co/1fEX4vPNiK United States 2 Latvian 36 2016-11-23T16:23:00 2016-11-23T16:23:00 699 692 2544 RETWEET 1 0 1
390906 3091269436 BOGDANOVAO2 424 '@zapvv Uz granīta plāksnes Ielieciet to konfektes Tas ir tāpat kā jūs esat bērns bija Kā jūs to ko viņš mīlēja Salaspils nogalināja viņu' Unknown 1 Latvian 36 2017-03-18T20:11:00 2017-03-18T20:11:00 42 3949 246 RETWEET 1 0 1
418778 1868496344 BRIANAREGLAND 446 Oh ladiiiiiiiies https://t.co/cPhDey7GWZ United States 2 Latvian 36 2016-12-20T18:03:00 2016-12-20T18:04:00 408 767 7018 RETWEET 1 0 1
430864 2668171329 BRIGHTANDGLORY 452 XL yoga pants #MustBeBanned United States 2 Latvian 36 2016-08-24T16:46:00 2016-08-24T16:49:00 2132 2281 2732 RETWEET 1 0 1
445211 2532597577 BRUCIEDUBLIN 464 XL yoga pants #MustBeBanned United States 2 Latvian 36 2016-08-24T16:41:00 2016-08-24T16:41:00 1616 1369 2110 RETWEET 1 0 1
458954 2535353390 CALEBPAAR 481 #ThingsThatShouldBeCensored yoga-pants https://t.co/y2TzB7Z4O7 United States 2 Latvian 36 2016-11-23T17:05:00 2016-11-23T17:05:00 1758 1613 3196 RETWEET 1 0 1
461116 2535353390 CALEBPAAR 481 SpongeBob E=MC2 pants #ScientificTVShows United States 2 Latvian 36 2015-05-13T09:25:00 2015-05-13T09:25:00 284 215 1625 RETWEET 1 0 1
476730 1627699074 CANNONSHER 498 WOW!! Nice panties !! United States 2 Latvian 36 2015-01-29T14:22:00 2015-01-29T14:22:00 0 74 154   0 0
498899 2742482932 CASCASEYP 508 #SurvivalGuideToThanksgiving sweatpants United States 2 Latvian 36 2016-11-21T17:08:00 2016-11-21T17:08:00 1710 2155 2815 RETWEET 1 0 1
498942 2742482932 CASCASEYP 508 #ThingsThatShouldBeCensored yoga-pants https://t.co/y2TzB7Z4O7 United States 2 Latvian 36 2016-11-23T17:23:00 2016-11-23T17:24:00 2457 2324 2924 RETWEET 1 0 1
499208 2742482932 CASCASEYP 508 it's a lie #hate United States 2 Latvian 36 2014-12-10T14:49:00 2014-12-10T14:49:00 0 0 39   0 0
500184 2742482932 CASCASEYP 508 http://t.co/NKBfIyh9RJ baby kitties United States 2 Latvian 36 2015-03-13T07:38:00 2015-03-13T07:38:00 289 55 791   0 0
500208 2742482932 CASCASEYP 508 baby kitties http://t.co/NKBfIyh9RJ United States 2 Latvian 36 2015-03-13T08:10:00 2015-03-13T08:10:00 289 55 822   0 0
500325 2742482932 CASCASEYP 508 WOW!! Nice panties !! United States 2 Latvian 36 2015-03-18T07:44:00 2015-03-18T07:44:00 362 76 969   0 0
558946 1877492857 CHESPLAYSCHESS 547 #MakeAMoviePainful Trauma Mia! United States 2 Latvian 36 2015-06-10T21:13:00 2015-06-10T21:13:00 74 163 7803 RETWEET 1 0 1
565912 1877492857 CHESPLAYSCHESS 547 Royal pants #RejectedTVShowSpinoffs United States 2 Latvian 36 2015-06-07T17:12:00 2015-06-07T17:12:00 74 149 5014 RETWEET 1 0 1
566189 1877492857 CHESPLAYSCHESS 547 Motor City Pride Festival 2015 — Saturday #entertainment United States 2 Latvian 36 2015-06-07T02:33:00 2015-06-07T02:33:00 74 148 4648 RETWEET 1 0 1
609770 1683408074 CHRIXCHASE 570 #ThingsThatShouldBeCensored yoga-pants https://t.co/y2TzB7Z4O7 United States 2 Latvian 36 2016-11-23T17:05:00 2016-11-23T17:05:00 1879 2128 2588 RETWEET 1 1 1
615055 2882350436 CHRIXMORGAN 571 #ImTooOldFor Yoga Pants United States 2 Latvian 36 2016-10-24T13:07:00 2016-10-24T13:08:00 9033 18062 10118 RETWEET 1 0 1
615245 2882350436 CHRIXMORGAN 571 #HillaryGiftIdeas hot granny panties United States 2 Latvian 36 2015-10-26T14:33:00 2015-10-26T14:33:00 6249 10967 1453   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 49.097ms · Data source: fivethirtyeight/russian-troll-tweets