home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

499 rows where language = 29

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
9673 3312143142 4MYSQUAD 10 '@KaraRBrown Hey Rihanna !' United States 2 Icelandic 29 2015-09-26T14:28:00 2015-09-26T14:28:00 2001 793 3103   0 0
19326 1652138929 ACEJINEV 38 TMZ Stars https://t.co/O1DIcFUn6R #tmzstars United States 2 Icelandic 29 2017-01-13T16:46:00 2017-01-13T16:46:00 791 901 3566 RETWEET 1 0 1
19327 1652138929 ACEJINEV 38 TMZ Stars https://t.co/2TQ9E9O8dB #tmzstars United States 2 Icelandic 29 2017-01-13T16:46:00 2017-01-13T16:46:00 791 901 3567 RETWEET 1 0 1
19328 1652138929 ACEJINEV 38 TMZ Stars https://t.co/pH7HXKjP5N #tmzstars United States 2 Icelandic 29 2017-01-13T16:46:00 2017-01-13T16:47:00 791 901 3568 RETWEET 1 0 1
25715 1670762347 ADAMCHAPMANJR 42 DJ Paul ft. OG Boobie Black - Extendos @DJPaulKOM https://t.co/QW7Xx9sFHJ United States 2 Icelandic 29 2016-10-06T20:26:00 2016-10-06T20:27:00 582 933 1662 RETWEET 1 0 1
35660 1660186831 ADRGREERR 54 Star Taco #MakeAMovieFat United States 2 Icelandic 29 2015-03-20T17:57:00 2015-03-20T17:57:00 269 95 325   0 0
37269 1657833811 ADRIENNE_GG 57 '@midnight #CatTV Magnum C.A.T.' United States 2 Icelandic 29 2016-11-16T09:07:00 2016-11-16T09:07:00 1390 1941 2220   0 0
39237 1657833811 ADRIENNE_GG 57 #ICantBeUrFriendBecause you're vegan. United States 2 Icelandic 29 2016-08-23T10:34:00 2016-08-23T10:34:00 734 1014 1383   0 0
48181 2570250275 AIDEN7757 81 ⚠️Running Back Got Skills✊ https://t.co/96ykRK1kI4 United States 2 Icelandic 29 2015-02-09T11:09:00 2015-02-09T11:10:00 133 11 185   0 0
48507 2570250275 AIDEN7757 81 Bubble gum… https://t.co/kKQ9PMStsE United States 2 Icelandic 29 2015-03-18T10:12:00 2015-03-18T10:12:00 260 31 676   0 0
48604 2570250275 AIDEN7757 81 V for Vegan #CaliforniaMovies @midnight United States 2 Icelandic 29 2017-03-07T10:07:00 2017-03-07T10:07:00 3182 3685 4065   0 0
67036 1652987412 ALECMOOOOODY 91 She's running. https://t.co/GD6ANTIrjq United States 2 Icelandic 29 2017-07-30T08:47:00 2017-07-30T08:47:00 509 877 10275 RETWEET 1 0 1
87571 2616344667 AMANDAVGREEN 138 #SecondHandGifts Chewing gum. United States 2 Icelandic 29 2016-12-21T16:25:00 2016-12-21T16:25:00 4029 4671 5516 RETWEET 1 0 1
90051 2616344667 AMANDAVGREEN 138 Gills Island #FishTV United States 2 Icelandic 29 2016-09-22T09:37:00 2016-09-22T09:37:00 2593 3037 3744   0 0
91287 890000000000000000 AMBERLINETR 142 RT samdastyari: Same. https://t.co/MDrM4K7lRv #amb United States 2 Icelandic 29 2017-08-10T21:05:00 2017-08-10T21:05:00 2941 369 1566 QUOTE_TWEET 2 0 1
92255 890000000000000000 AMBERLINETR 142 RT samdastyari: https://t.co/uVSttNEEGw #amb United States 2 Icelandic 29 2017-08-16T05:06:00 2017-08-16T05:06:00 2932 367 2429   0 0
103113 1679279490 AMELIEBALDWIN 146 mjanemann: #GlassSteagall #StopTPP #Peace https://t.co/ZA4MCVAX31 United States 2 Icelandic 29 2016-11-10T06:34:00 2016-11-10T06:34:00 2391 2543 17465 RETWEET 1 0 1
106669 1679279490 AMELIEBALDWIN 146 mjanemann: https://t.co/Rvxe9CTsvD #PedoGate https://t.co/o5P796nRpr United States 2 Icelandic 29 2016-12-11T08:17:00 2016-12-11T08:17:00 2361 2617 21352 RETWEET 1 0 1
147950 2612066397 ANDYDREWDANIELS 186 #SuperOldHeroes @midnight Ms. Marvel-Whitman-Myers-Steinberg-Marvel United States 2 Icelandic 29 2017-03-03T09:03:00 2017-03-03T09:03:00 3145 3594 2836   1 0
148989 2878166306 ANDYHASHTAGGER 187 #ModernDeadlySins being vegan https://t.co/pw85sq3VXS United States 2 Icelandic 29 2015-10-25T16:46:00 2015-10-25T16:46:00 13283 15847 3538 RETWEET 1 1 1
149615 2878166306 ANDYHASHTAGGER 187 Pan's Lasagna #MakeAMovieEdible United States 2 Icelandic 29 2015-11-09T15:37:00 2015-11-09T15:37:00 14067 16462 3954 RETWEET 1 1 1
149650 2878166306 ANDYHASHTAGGER 187 #StarWarsCharactersWishList chubakka fur coat United States 2 Icelandic 29 2015-12-14T14:23:00 2015-12-14T14:23:00 17041 17484 4571 RETWEET 1 1 1
151827 2878166306 ANDYHASHTAGGER 187 #ISISaMovie Enslaving Sarah Marshall United States 2 Icelandic 29 2016-04-27T15:43:00 2016-04-27T15:43:00 16879 20870 8078   1 0
155122 2878166306 ANDYHASHTAGGER 187 #DraftMeBecause I chew a gum United States 2 Icelandic 29 2015-06-26T08:35:00 2015-06-26T08:35:00 10468 11881 2138   1 0
155460 2878166306 ANDYHASHTAGGER 187 No running #SillyGymRules United States 2 Icelandic 29 2016-06-30T16:33:00 2016-06-30T16:33:00 20827 22761 12262 RETWEET 1 1 1
157735 2878166306 ANDYHASHTAGGER 187 I'm vegan #MakeAChefMadIn3Words United States 2 Icelandic 29 2015-09-07T07:14:00 2015-09-07T07:14:00 12764 13671 2703   1 0
177387 2500690416 ANNIEPOSHES 224 '@midnight #CatTV Magnum C.A.T.' United States 2 Icelandic 29 2016-11-16T09:53:00 2016-11-16T09:53:00 2425 2564 3531   1 0
179260 2500690416 ANNIEPOSHES 224 Fur Coats. #MustBeBanned United States 2 Icelandic 29 2016-08-24T15:46:00 2016-08-24T15:47:00 1790 1696 2505   1 0
179727 2500690416 ANNIEPOSHES 224 Semi-exact ��� #debatenight United States 2 Icelandic 29 2016-09-27T01:35:00 2016-09-27T01:37:00 2270 2162 3005 RETWEET 1 1 1
188245 1652262638 ANTONHAYHAY 237 Magnum Bareskin Condoms. https://t.co/ss8oGZZtZI United States 2 Icelandic 29 2015-12-25T21:17:00 2015-12-25T21:17:00 397 187 505 RETWEET 1 0 1
192248 1652262638 ANTONHAYHAY 237 loookin fresh af 😩 https://t.co/zp5OzKNfUT United States 2 Icelandic 29 2017-04-20T06:39:00 2017-04-20T06:39:00 301 750 9852 RETWEET 1 0 1
250369 2532835560 BABYJANNYMEOW 313 #MentalIllnessIcebreakers I'm a vegan United States 2 Icelandic 29 2016-11-28T08:37:00 2016-11-28T08:37:00 2975 3589 4766 RETWEET 1 1 1
252536 2532835560 BABYJANNYMEOW 313 Hanna Barbera Laff-A-Lympics #MyFavChildhoodCartoon https://t.co/f2vycLc3b4 United States 2 Icelandic 29 2016-09-04T08:45:00 2016-09-04T08:45:00 2294 2278 3327 RETWEET 1 1 1
269192 1658420976 BAOBAEHAM 326 SNAP • FERRARI FATBOY � United States 2 Icelandic 29 2017-03-06T13:47:00 2017-03-06T13:47:00 812 1098 4982 RETWEET 1 0 1
272587 1659487244 BARELYBARBOZA 331 '@USDA_ERS go vegan bro #KochFarms https://t.co/Mpnq3iv6a2' United States 2 Icelandic 29 2015-11-27T00:09:00 2015-11-27T00:10:00 50 48 319   0 0
309097 725000000000000000 BERLINBOTE 372 Barbra Streisand trauert um Hündin Samantha https://t.co/iAAdWHrX5s https://t.co/DMPZS1qM0d Unknown 1 Icelandic 29 2017-05-29T12:19:00 2017-05-29T12:19:00 1350 1268 17510   0 0
311220 725000000000000000 BERLINBOTE 372 Island bes... https://t.co/uvz110S8Cw Unknown 1 Icelandic 29 2016-06-27T21:01:00 2016-06-27T21:01:00 0 4 1404   0 0
314307 725000000000000000 BERLINBOTE 372 Thomas Manns Zaub... https://t.co/ZHtzKkY72J Unknown 1 Icelandic 29 2016-07-28T18:43:00 2016-07-28T18:43:00 0 7 5211   0 0
319526 725000000000000000 BERLINBOTE 372 Mann attackiert – weil er ein Kreuz trug https://t.co/ltl330xwsU https://t.co/xSik0ePwVk Unknown 1 Icelandic 29 2017-09-12T12:19:00 2017-09-12T12:19:00 2228 1786 22608   0 0
319804 725000000000000000 BERLINBOTE 372 Fuchs Bjarki Elisson verschiebt sein Comeback https://t.co/Z9veiXDxwW https://t.co/8Jdo9oYKqQ Unknown 1 Icelandic 29 2017-09-15T16:19:00 2017-09-15T16:19:00 2228 1801 22894   0 0
321409 725000000000000000 BERLINBOTE 372 Todesfall: Mann rennt bei „Burning Man“ Festival ins Feuer https://t.co/iFruDsE5MN https://t.co/0NMzMLMBqP Unknown 1 Icelandic 29 2017-09-04T22:53:00 2017-09-04T22:53:00 2159 1769 21971   0 0
324580 2732675512 BGARNER2107 384 Flea Fallin' #DogSongs @midnight United States 2 Icelandic 29 2017-01-31T09:53:00 2017-01-31T09:53:00 4882 4821 5958   0 0
324803 2732675512 BGARNER2107 384 #RuinADinnerInOnePhrase I'm vegan United States 2 Icelandic 29 2016-10-05T14:34:00 2016-10-05T14:34:00 2422 2250 3732   0 0
326541 2732675512 BGARNER2107 384 Sugar-Free Hill Gang #DadRappers @midnight United States 2 Icelandic 29 2015-05-29T12:57:00 2015-05-29T12:57:00 169 173 1390 RETWEET 1 0 1
327965 2732675512 BGARNER2107 384 Semi-exact ��� #debatenight United States 2 Icelandic 29 2016-09-27T02:07:00 2016-09-27T02:13:00 2495 2160 3578 RETWEET 1 0 1
334482 1621376306 BIGSEANBEAST 389 Retweeted OG Mack Drama (@mackdrama1017): #NP @SpecialEd "I Got It Made" #LiveInTheMacCave w @MacPill1017... https://t.co/5qytEdPVfn United States 2 Icelandic 29 2017-02-23T09:38:00 2017-02-23T09:38:00 743 793 3803 RETWEET 1 0 1
347420 3255856080 BIZGOD 393 http://t.co/sG51wE8vkx I hate runningfitness @PJC_HB4L @jimm53036094 @alonsoG12 @__belloooo @sWilliaaams @JordanKemp2 @Deb14Tester @mgonzo United States 2 Icelandic 29 2015-07-06T02:56:00 2015-07-06T02:56:00 3 138 9355   1 0
347440 3255856080 BIZGOD 393 http://t.co/1z4b3WLSJs Bc ur fitness af @GoTellChurch @NikeSystem @unfilteredbxtch @RealKidPoker @Johnny__Munoz @jadakeiana @MarkyJr83 United States 2 Icelandic 29 2015-07-06T03:15:00 2015-07-06T03:15:00 3 138 9375   1 0
380410 1685173321 BLMSOLDIER 418 Jungle boi!!! https://t.co/cr3qOqqvpJ United States 2 Icelandic 29 2017-03-10T18:55:00 2017-03-10T18:55:00 694 708 4916 RETWEET 1 0 1
391846 1718000594 BOOTH_PRINCE 431 Get nekkid. #OtherThingsToDoIn6Seconds United States 2 Icelandic 29 2017-01-18T08:54:00 2017-01-18T08:54:00 4321 5246 10273   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 112.256ms · Data source: fivethirtyeight/russian-troll-tweets