home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

237 rows where language = 45

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
94203 895000000000000000 AMBERRPAR 143 mchooyah I3LACKIRISH Jack and Dt Dew Unknown 1 Kurdish 45 2017-08-16T00:34:00 2017-08-16T00:34:00 22 7 820   0 0
94205 895000000000000000 AMBERRPAR 143 mchooyah I3LACKIRISH Jack and Dt Dew Unknown 1 Kurdish 45 2017-08-16T00:34:00 2017-08-16T00:34:00 22 7 820   0 0
157703 2878166306 ANDYHASHTAGGER 187 Bell Biv Dewey #HipHopCartoons @midnight United States 2 Kurdish 45 2015-09-30T07:59:00 2015-09-30T07:59:00 13448 15197 3133 RETWEET 1 1 1
174085 839000000000000000 ANNAROMAN0 220 Me & my bike ❤️ https://t.co/tOPJaFwNtq Italy 3 Kurdish 45 2017-03-31T21:42:00 2017-03-31T21:42:00 565 92 1615 RETWEET 1 0 1
191843 1652262638 ANTONHAYHAY 237 '@bmarczewska @matibo11 @Hakflak @GaiaGaudenzi @BrindusaB1 @beatrice_bea2 @ghegola @mariaireneali @karmendida @nellina99 @BPerrionni @Papryka5 @albertopetro2 @GucciPatrizia @paolo_barberio @AlessandraCicc6 @yebosfaye @PasqualeTotaro @alecoscino @FedericaAnto2 @PaolaChiocchi @Lunablucobalto @alfanor48 @lagatta4739 @_Vivi2013 #DonneDiSpalle #LoSpecchioNellArte 🎨Slava Groshev https://t.co/g1BzJSOfxJ' United States 2 Kurdish 45 2017-04-13T04:38:00 2017-04-13T04:38:00 303 745 9439 RETWEET 1 0 1
194211 1652262638 ANTONHAYHAY 237 It's asinine. https://t.co/eB4AW8opm9 United States 2 Kurdish 45 2017-07-22T14:52:00 2017-07-22T14:52:00 299 710 11566 RETWEET 1 0 1
199143 87588938 ANZGRI 246 ÜM - Mia Mia https://t.co/EowBfAj97r United States 2 Kurdish 45 2017-05-06T21:21:00 2017-05-06T21:21:00 32 1261 67142   0 0
200906 895000000000000000 APRRILSBRUSS 250 Dunkirk on Dunkirk https://t.co/kXZZw4jkdl United States 2 Kurdish 45 2017-08-08T10:11:00 2017-08-08T10:11:00 39 1 1 RETWEET 1 0 1
206458 1686370159 ARCHIEOLIVERS 254 MT @Saintly_Life: Hebrews 13:8 https://t.co/7oqN4R0sBh #IStandWithIsrael #PJNET United States 2 Kurdish 45 2016-08-12T17:14:00 2016-08-12T17:14:00 2398 2311 1778 RETWEET 1 0 1
270691 1658420976 BAOBAEHAM 326 #NowPlaying @EnVyDaTruth - Heaven Hell ft YungMurda :: Tune In: https://t.co/QzCAvH4YhE https://t.co/NwkdX2SaCy United States 2 Kurdish 45 2017-07-19T14:46:00 2017-07-19T14:46:00 797 1074 6931 RETWEET 1 0 1
301434 715000000000000000 BERKHOFF85 371 Junge, 13, trug scharfen #Sprengstoffgürtel unterm Trikot #Türkei #Irak #Terror #IS #ISIS https://t.co/n9MQBBHrou https://t.co/jeEjMOm4CT Germany 13 Kurdish 45 2016-08-22T07:37:00 2016-08-22T07:38:00 4412 1975 1250   0 0
313815 725000000000000000 BERLINBOTE 372 Es droht der Kampf um Kurdistan https://t.co/bgc2wKkHD8 Unknown 1 Kurdish 45 2017-07-22T17:37:00 2017-07-22T17:37:00 2181 1585 20156   0 0
316404 725000000000000000 BERLINBOTE 372 Sattel ve... https://t.co/hxyjV23s7M Unknown 1 Kurdish 45 2016-08-16T22:41:00 2016-08-16T22:41:00 0 8 7575   0 0
324338 2732675512 BGARNER2107 384 Naked Gun 22 United States 2 Kurdish 45 2017-01-25T12:39:00 2017-01-25T12:40:00 4334 4557 5695   0 0
334943 1621376306 BIGSEANBEAST 389 #NowPlaying Bone Thugs-N-Harmony - Mo' Murda - https://t.co/0Qv1KMY0xy United States 2 Kurdish 45 2017-03-16T05:05:00 2017-03-16T05:05:00 742 802 4275 RETWEET 1 0 1
346949 3255856080 BIZGOD 393 http://t.co/zTbgLXAJIn Ew fat bitch @hefhemcoded @misscollison @errrrnandez @Chriiissttiine @KristinRose9 @AmyB0o7 @Mike_Gruenling @karterb_ United States 2 Kurdish 45 2015-07-06T17:56:00 2015-07-06T17:56:00 3 158 10520   1 0
347014 3255856080 BIZGOD 393 http://t.co/cwBGOQjyvG I'm so fat I hate myself ew @cdenotae04 @DatDude_Tonio @fuckdarbz @Wise1Eli @therapymuke_ @itsaphrodisi @ZirryUpdates United States 2 Kurdish 45 2015-07-06T19:00:00 2015-07-06T19:01:00 3 160 10609   1 0
347356 3255856080 BIZGOD 393 http://t.co/KuAKidHZJK Ew I'm fat @SophiieRankin_ @Nigga_Narryy @irma_delcar @jaesleazy_ @erincandy @FMoukaddem @nialovesyou_ @Papasmurf5310 United States 2 Kurdish 45 2015-07-06T23:14:00 2015-07-06T23:14:00 3 160 11019   1 0
392417 1718000594 BOOTH_PRINCE 431 Sports? Sun? Ew. No. #MillennialSportsTeams https://t.co/xoEZma59X7 United States 2 Kurdish 45 2016-10-19T17:22:00 2016-10-19T17:23:00 3338 3698 9486 RETWEET 1 1 1
398615 1718000594 BOOTH_PRINCE 431 Dik Dik Pics #MustBeBanned https://t.co/X9Y52yR956 United States 2 Kurdish 45 2016-08-24T14:49:00 2016-08-24T14:49:00 5000 3396 7680 RETWEET 1 1 1
400765 1718000594 BOOTH_PRINCE 431 #ThingsMoreTrustedThanHillary Obi-Wan Kenobi https://t.co/hS0yByya2w United States 2 Kurdish 45 2016-09-27T02:22:00 2016-09-27T02:28:00 3197 3511 9250 RETWEET 1 1 1
406270 2482076083 BRATUHA_BORCUHA 442 🔥🔥🔥 I1 - Wot U Sayin #RuGrime @grimemusicgroup #GMGmandem https://t.co/SCJ0XKlByo https://t.co/f6UeVcRZ14 Unknown 1 Kurdish 45 2017-04-18T16:39:00 2017-04-18T16:40:00 226 111 4228 RETWEET 1 0 1
409881 1873206768 BRENTMCCLURE275 444 #NowPlaying Bone Thugs-N-Harmony - Mo' Murda - https://t.co/0Qv1KMY0xy United States 2 Kurdish 45 2017-03-13T09:20:00 2017-03-13T09:20:00 734 780 5358 RETWEET 1 0 1
411255 1873206768 BRENTMCCLURE275 444 '@A_ofAnon @Rasa171a @MrNegroMilitant L💗VE #FreePalestineFreetheWorld‼️ https://t.co/SVq6ql0aU8' United States 2 Kurdish 45 2017-04-22T04:06:00 2017-04-22T04:06:00 728 801 6884 RETWEET 1 0 1
420006 1868496344 BRIANAREGLAND 446 Sexy Bikini Blondes https://t.co/3To2mKReOh United States 2 Kurdish 45 2016-04-18T15:52:00 2016-04-18T15:52:00 494 212 868 RETWEET 1 0 1
428733 2668171329 BRIGHTANDGLORY 452 Sports? Sun? Ew. No. #MillennialSportsTeams https://t.co/xoEZma59X7 United States 2 Kurdish 45 2016-10-19T18:18:00 2016-10-19T18:18:00 2999 3044 3810 RETWEET 1 0 1
495082 1647045721 CARRIETHORNTHON 505 ✌️#BijiKurdistan✌️ https://t.co/GJEXsNePpC United States 2 Kurdish 45 2017-01-09T21:45:00 2017-01-09T21:45:00 2682 2382 4293 RETWEET 1 0 1
542185 1532863891 CHARLESJHARPER 533 #WithoutYouIam Ysf Islam @tlcprincess @iCanHash @TheRealJmar #WildWorld https://t.co/wN26ftsnw5 United States 2 Kurdish 45 2016-06-29T15:48:00 2016-06-29T15:48:00 1790 752 1501 RETWEET 1 0 1
609434 1683408074 CHRIXCHASE 570 Sports? Sun? Ew. No. #MillennialSportsTeams https://t.co/xoEZma59X7 United States 2 Kurdish 45 2016-10-19T19:10:00 2016-10-19T19:11:00 1801 1975 2150 RETWEET 1 1 1
650198 1711063908 COOKIIIEEESSSS 597 Amber Rose & Nicki Murdarris ������������ https://t.co/NXwqKF6Fzc United States 2 Kurdish 45 2016-04-30T13:36:00 2016-04-30T13:36:00 669 325 1174 RETWEET 1 0 1
661270 743167000000000000 COVFEFENATIONUS 603 Ewwwww Louis Ck https://t.co/bqB0MXCIyh United States 2 Kurdish 45 2017-11-10T03:15:00 2017-11-10T03:15:00 245 2080 142183 RETWEET 1 1 1
662925 743167000000000000 COVFEFENATIONUS 603 JOE BIDEN....... #OUTNUMBERED https://t.co/eWKfuslFjg United States 2 Kurdish 45 2017-11-13T17:47:00 2017-11-13T17:47:00 246 2160 145429 RETWEET 1 1 1
680333 743167000000000000 COVFEFENATIONUS 603 Nat Rothschild - Tony Hayward - Vallares - Genel Energy plc - Iraqi Kurdistan - #Turkey - #Oil - #Erdogan https://t.co/EAEX0q3vXj #QAnon #FollowTheWhiteRabbit #TheStorm United States 2 Kurdish 45 2017-12-05T01:05:00 2017-12-05T01:05:00 251 2581 161260 RETWEET 1 1 1
708252 1657694515 DAILEYJADON 622 Bob's Hindenburgers #AddCartoonsToHistory @midnight United States 2 Kurdish 45 2017-08-02T11:25:00 2017-08-02T11:25:00 4202 3439 4677   0 0
735251 2630842499 DAILYSANDIEGO 625 Romania: health chiefs, Hewlett Packard probed #business United States 2 Kurdish 45 2016-05-23T20:02:00 2016-05-23T20:02:00 4593 14556 15444   0 0
793530 2882037326 DANAGEEZUS 634 #RuinADinnerInOnePhrase ew, I don't like spicy food United States 2 Kurdish 45 2016-10-05T14:09:00 2016-10-05T14:10:00 15744 20336 13283   0 0
804701 2882037326 DANAGEEZUS 634 Ride by bike #ToFeelBetterI https://t.co/FoZagld0EQ United States 2 Kurdish 45 2016-09-12T14:03:00 2016-09-12T14:04:00 17078 20227 12973 RETWEET 1 0 1
848682 1693655748 DEBRA_STERN_ 677 https://t.co/uWvrvUaimt #bacon pancakes!!! United States 2 Kurdish 45 2015-07-04T09:02:00 2015-07-04T09:02:00 198 74 364   0 0
851741 2577152109 DENN_NIKITIN 690 Найдёмся во снах Unknown 1 Kurdish 45 2017-01-10T23:05:00 2017-01-10T23:06:00 69 104 4987 RETWEET 1 0 1
855707 2577152109 DENN_NIKITIN 690 Эх, щас бы его: https://t.co/JJmo3IWAyT Unknown 1 Kurdish 45 2016-12-15T07:15:00 2016-12-15T07:15:00 69 97 3567 RETWEET 1 0 1
857834 2577152109 DENN_NIKITIN 690 🔥🔥🔥 I1 - Wot U Sayin #RuGrime @grimemusicgroup #GMGmandem https://t.co/SCJ0XKlByo https://t.co/f6UeVcRZ14 Unknown 1 Kurdish 45 2017-04-18T16:47:00 2017-04-18T16:47:00 68 114 6388 RETWEET 1 0 1
888072 2573225349 DOMINICVALENT 734 Sports? Sun? Ew. No. #MillennialSportsTeams https://t.co/xoEZma59X7 United States 2 Kurdish 45 2016-10-19T17:39:00 2016-10-19T17:40:00 2955 3679 4287 RETWEET 1 0 1
897943 1720117201 DONNABRIVERA 741 SLAM dunk! @JimmyWWalker1 @RichardGrenell @Richzeoli @GREGSTOCKER @cciedotnyc @LindaSuhler @CarmineZozzora @ThePatriot143 @LyndaG1963 United States 2 Kurdish 45 2016-10-21T01:48:00 2016-10-21T01:48:00 1553 1611 2299 RETWEET 1 0 1
898403 1720117201 DONNABRIVERA 741 '@trumpgasm @clanceman65 Yup: ISLAM' United States 2 Kurdish 45 2015-11-16T17:43:00 2015-11-16T17:44:00 469 382 1287 RETWEET 1 0 1
902565 2537357265 DONNIELMILLER 742 #WithoutYouIam Ysf Islam @tlcprincess @iCanHash @TheRealJmar #WildWorld https://t.co/wN26ftsnw5 United States 2 Kurdish 45 2016-06-29T14:39:00 2016-06-29T14:39:00 1976 1200 1888 RETWEET 1 0 1
902673 2537357265 DONNIELMILLER 742 "Sat saheb ji United States 2 Kurdish 45 2017-07-14T10:19:00 2017-07-14T10:19:00 3775 4377 4111   0 0
981007 723000000000000000 ERDOLLUM 841 Ein #Sprengstoffgürtel unterm Trikot... #Irak #ISIS #IS #Türkei #Kirkuk #mondaymotivation https://t.co/YiLbKnDqOk https://t.co/HrJ4UZ7NL1 Germany 13 Kurdish 45 2016-08-22T07:18:00 2016-08-22T07:18:00 7141 6521 1750   0 0
985229 2540611879 ERICARUTTER 846 Mad Max: Bikini Road ???? #SummerAMovie @midnight Unknown 1 Kurdish 45 2017-06-23T09:29:00 2017-06-23T09:29:00 3587 4085 2947   0 0
993551 1662453998 ERRIVVVVERS 857 Amber Rose & Nicki Murdarris ������������ https://t.co/NXwqKF6Fzc United States 2 Kurdish 45 2016-04-30T13:57:00 2016-04-30T13:57:00 616 416 1079 RETWEET 1 0 1
997102 2533653547 EVAGREEN69 870 '@trumpgasm @clanceman65 Yup: ISLAM' United States 2 Kurdish 45 2015-11-17T08:43:00 2015-11-17T08:43:00 744 352 899 RETWEET 1 0 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 18.829ms · Data source: fivethirtyeight/russian-troll-tweets