home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

771 rows where language = 12

View and edit SQL

Suggested facets: 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
1269 839000000000000000 1LORENAFAVA1 5 Stasera cinema? https://t.co/g76sfh43nB Italy 3 Estonian 12 2017-03-25T14:36:00 2017-03-25T14:50:00 412 85 1180 RETWEET 1 0 1
1944 839000000000000000 1LORENAFAVA1 5 Peanuts 2017 aprile 11 https://t.co/ywBCrLIUif Italy 3 Estonian 12 2017-04-11T06:57:00 2017-04-11T06:58:00 408 90 2250 RETWEET 1 0 1
2803 839000000000000000 1LORENAFAVA1 5 Peanuts 2017 aprile 27 https://t.co/xTawFeCB3U Italy 3 Estonian 12 2017-04-27T06:11:00 2017-04-27T06:11:00 408 99 3262 RETWEET 1 0 1
5697 3312143142 4MYSQUAD 10 September 2015 http://t.co/KdzbbqFim8 United States 2 Estonian 12 2015-10-16T12:01:00 2015-10-18T01:11:00 1618 1248 4529   0 0
5927 3312143142 4MYSQUAD 10 '@missjillscott @Usher Looks like Stussy' United States 2 Estonian 12 2015-10-20T01:14:00 2015-10-20T01:14:00 1618 1240 4626   0 0
8103 3312143142 4MYSQUAD 10 '@kaiyahnapri @TifeTheBawse nigga's paradise' United States 2 Estonian 12 2015-08-24T16:51:00 2015-09-20T08:30:00 1287 411 744   0 0
16436 2534421182 ABIGAILSSILK 28 DC versus Marvel cage match #ComicConIn5Words @midnight United States 2 Estonian 12 2016-07-23T09:09:00 2016-07-23T09:09:00 741 495 1233   0 0
16717 2534421182 ABIGAILSSILK 28 sleeping #IShouldGetAMedalFor United States 2 Estonian 12 2016-08-08T10:19:00 2016-08-08T10:19:00 500 613 1427   0 0
20017 1652138929 ACEJINEV 38 #NP: @_ALEXGEM - FIND SLEEP #ListenLIVE - https://t.co/tEPugxWvjk United States 2 Estonian 12 2016-10-13T18:07:00 2016-10-13T18:07:00 809 893 1491 RETWEET 1 0 1
20325 1652138929 ACEJINEV 38 Mad I'm gonna miss #AtlantaHorrorStoryTonight �� United States 2 Estonian 12 2016-10-29T19:40:00 2016-10-29T19:40:00 806 905 1824 RETWEET 1 0 1
20428 1652138929 ACEJINEV 38 #NP: @djsyonkream - @OGShyne - Fake Nigga #AudioPa #ListenLIVE - https://t.co/tEPugxWvjk United States 2 Estonian 12 2016-10-09T11:47:00 2016-10-09T11:47:00 809 895 1395 RETWEET 1 0 1
20582 1652138929 ACEJINEV 38 #NP: 2trillfinalmix #ListenLIVE - https://t.co/tEPugxWvjk United States 2 Estonian 12 2016-11-15T09:56:00 2016-11-15T09:56:00 799 902 2150 RETWEET 1 0 1
21139 1652138929 ACEJINEV 38 #NowPlaying: Reks "Kites" #hiphop #rap https://t.co/DDuNAqaXMU United States 2 Estonian 12 2016-12-14T16:24:00 2016-12-14T16:24:00 796 897 2848 RETWEET 1 0 1
22322 1652138929 ACEJINEV 38 oh I love pandas https://t.co/dOKFgHzBbC Unknown 1 Estonian 12 2015-02-08T17:53:00 2015-02-08T17:53:00 266 86 220   0 0
22709 1652138929 ACEJINEV 38 oh I love pandas https://t.co/dOKFgHzBbC Unknown 1 Estonian 12 2015-03-18T12:17:00 2015-03-18T12:17:00 260 87 347   0 0
24846 1652138929 ACEJINEV 38 MOOD ASF like lol smh https://t.co/8f7o2vP4si United States 2 Estonian 12 2017-07-23T22:17:00 2017-07-23T22:18:00 779 911 6869 RETWEET 1 0 1
26285 1670762347 ADAMCHAPMANJR 42 Ma Ya MCM a communist United States 2 Estonian 12 2016-10-07T07:36:00 2016-10-07T07:37:00 582 949 2350 RETWEET 1 0 1
35659 1660186831 ADRGREERR 54 Midnight Snack in Paris #MakeAMovieFat United States 2 Estonian 12 2015-03-20T17:48:00 2015-03-20T17:48:00 269 95 324   0 0
37753 1657833811 ADRIENNE_GG 57 #SecondhandGifts used soap United States 2 Estonian 12 2016-12-21T16:09:00 2016-12-21T16:09:00 2316 2965 3063   0 0
37833 1657833811 ADRIENNE_GG 57 TMNT Teenage Mutant Ninja Trolls #AlternativeAcronymInterpretations https://t.co/nBSckBI7Rg United States 2 Estonian 12 2016-12-05T16:15:00 2016-12-05T16:15:00 2478 2627 2756 RETWEET 1 0 1
38177 1657833811 ADRIENNE_GG 57 tasty art http://t.co/X0lrA6qVIu United States 2 Estonian 12 2015-02-08T14:33:00 2015-02-08T14:33:00 265 122 201   0 0
39013 1657833811 ADRIENNE_GG 57 #SummerAMovie @midnight Swimming Deadpool United Kingdom 9 Estonian 12 2017-06-23T11:29:00 2017-06-23T11:29:00 3613 4353 3867   0 0
46845 2570250275 AIDEN7757 81 #BetterAlternativeToDebates Botulism. United States 2 Estonian 12 2016-10-10T15:50:00 2016-10-10T15:51:00 2188 1668 2125   0 0
47085 2570250275 AIDEN7757 81 #ImAlwaysOkWith sleeping. United States 2 Estonian 12 2016-11-19T09:45:00 2016-11-19T09:45:00 2106 1907 2457   0 0
48114 2570250275 AIDEN7757 81 Vegemite Soup #MakeTVShowsAustralian @midnight https://t.co/KpK0Cba9Br United States 2 Estonian 12 2017-02-08T10:43:00 2017-02-08T10:44:00 2670 3224 3771   0 0
48127 2570250275 AIDEN7757 81 #ValentinesDayIn3Words Roses, lackluster sex United States 2 Estonian 12 2017-02-08T15:47:00 2017-02-08T15:47:00 3248 3245 3787 RETWEET 1 0 1
62056 1652987412 ALECMOOOOODY 91 #BlackTwitter: #BUYBLACKFRIDAY November 25, 2016. https://t.co/UjjHCgjgiB https://t.co/IiFkKkWof2 United States 2 Estonian 12 2016-11-19T16:35:00 2016-11-19T16:36:00 529 887 4240 RETWEET 1 0 1
62126 1652987412 ALECMOOOOODY 91 '@kazkazkazan6 backstage gaming' United States 2 Estonian 12 2016-11-24T00:10:00 2016-11-24T00:10:00 530 883 4375 RETWEET 1 0 1
65879 1652987412 ALECMOOOOODY 91 Beadle>>>>>Sage Steele https://t.co/3ZmdvoVIA2 United States 2 Estonian 12 2017-04-05T01:40:00 2017-04-05T01:40:00 518 887 8422 RETWEET 1 0 1
70860 2586506586 ALEXHARRITONOV 100 Diana Vishneva, "Guiselle" - #art #ballet https://t.co/xFtWGtVyEz Azerbaijan 7 Estonian 12 2016-12-25T02:09:00 2016-12-25T02:09:00 134 2107 4308 RETWEET 1 0 1
86845 2616344667 AMANDAVGREEN 138 Let's eat grandma #RuinADinnerInOnePhrase United States 2 Estonian 12 2016-10-05T15:06:00 2016-10-05T15:07:00 2905 3262 3960 RETWEET 1 0 1
87010 2616344667 AMANDAVGREEN 138 #ThingsThatShouldBeCensored animal abuse. United States 2 Estonian 12 2016-11-23T15:45:00 2016-11-23T15:46:00 3489 3792 4809 RETWEET 1 0 1
88174 2616344667 AMANDAVGREEN 138 #ValentinesDayIn3Words Roses, lackluster sex United States 2 Estonian 12 2017-02-08T16:01:00 2017-02-08T16:01:00 4416 5706 6161 RETWEET 1 0 1
88223 2616344667 AMANDAVGREEN 138 Hill Street didgeridoos @midnight #MakeTVShowsAustralian United States 2 Estonian 12 2017-02-08T09:17:00 2017-02-08T09:17:00 4416 5704 6126   0 0
89612 2616344667 AMANDAVGREEN 138 just a gorilla #WorstPainEverIn3Words United States 2 Estonian 12 2016-08-24T09:22:00 2016-08-24T09:22:00 1580 2340 3059   0 0
89816 2616344667 AMANDAVGREEN 138 #IShouldGetAMedalFor sleeping https://t.co/2ASxsEQikS United States 2 Estonian 12 2016-08-08T10:37:00 2016-08-08T10:38:00 2071 1983 2750 RETWEET 1 0 1
101782 1679279490 AMELIEBALDWIN 146 November 8, 2016 https://t.co/Ax7bNvNDmB United States 2 Estonian 12 2016-10-06T20:10:00 2016-10-06T20:10:00 1944 2422 12524 RETWEET 1 0 1
109407 1679279490 AMELIEBALDWIN 146 Embarrassed. https://t.co/WrdFeGi1ue United States 2 Estonian 12 2016-12-31T03:22:00 2016-12-31T03:22:00 2353 2687 23845 RETWEET 1 0 1
114653 1679279490 AMELIEBALDWIN 146 George Steele vs. Roman Reigns' dad United States 2 Estonian 12 2017-03-18T11:04:00 2017-03-18T11:04:00 2306 2743 32997 RETWEET 1 0 1
147885 2612066397 ANDYDREWDANIELS 186 #ValentinesDayIn3Words Roses, lackluster sex United States 2 Estonian 12 2017-02-08T17:17:00 2017-02-08T17:17:00 3169 3010 2615 RETWEET 1 1 1
147914 2612066397 ANDYDREWDANIELS 186 #MakeTVShowsAustralian@midnight Kate plus 8 Mates United States 2 Estonian 12 2017-02-08T09:24:00 2017-02-08T09:24:00 2600 2972 2556   1 0
149885 2878166306 ANDYHASHTAGGER 187 #christmasin3words Grandma Reindeer HitNRun United States 2 Estonian 12 2015-12-21T15:23:00 2015-12-21T15:23:00 17308 17598 4904 RETWEET 1 1 1
152992 2878166306 ANDYHASHTAGGER 187 Anime makes teens gay!!! https://t.co/SE3pLX7lKW United States 2 Estonian 12 2016-05-30T14:07:00 2016-05-30T14:07:00 19932 22096 9547 QUOTE_TWEET 2 1 1
155451 2878166306 ANDYHASHTAGGER 187 #SummerACeleb Johny Deep pool United States 2 Estonian 12 2015-06-30T09:18:00 2015-06-30T09:18:00 10461 11879 2198   1 0
157437 2878166306 ANDYHASHTAGGER 187 ANIMAL ABUSE! #ThingsWeAlwaysHate http://t.co/GKxJ4HGh4T United States 2 Estonian 12 2015-09-18T17:14:00 2015-09-18T17:14:00 12434 14305 2831 RETWEET 1 1 1
172426 895000000000000000 ANNAMINGT 219 AriDavidUSA BBBBBWWWWWAAAAAAA😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂MAGA TRUMP🇺🇸😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂 Unknown 1 Estonian 12 2017-08-15T19:50:00 2017-08-15T19:51:00 22 1 770   0 0
177102 2500690416 ANNIEPOSHES 224 #BetterAlternativeToDebates Botulism. United States 2 Estonian 12 2016-10-10T14:47:00 2016-10-10T14:47:00 2683 2289 3259 RETWEET 1 1 1
177268 2500690416 ANNIEPOSHES 224 Let's eat grandma #RuinADinnerInOnePhrase United States 2 Estonian 12 2016-10-05T15:45:00 2016-10-05T15:45:00 2290 2253 3154 RETWEET 1 1 1
177549 2500690416 ANNIEPOSHES 224 #ThingsThatShouldBeCensored animal abuse. United States 2 Estonian 12 2016-11-23T15:35:00 2016-11-23T15:36:00 2825 2743 3814 RETWEET 1 1 1
178045 2500690416 ANNIEPOSHES 224 #SecondhandGifts used soap United States 2 Estonian 12 2016-12-21T15:50:00 2016-12-21T15:50:00 3315 3600 4495   1 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 138.566ms · Data source: fivethirtyeight/russian-troll-tweets