home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

236 rows where language = 40

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
23213 1652138929 ACEJINEV 38 Gang Shyt @lilchrisktown @djnehpets @djflashmcfly ���� @vlive_chicago https://t.co/ad2UFoaLug United States 2 Malay 40 2017-03-04T06:32:00 2017-03-04T06:32:00 787 903 4766 RETWEET 1 0 1
49525 2570250275 AIDEN7757 81 #SomedayIdLikeToSee my penis again United States 2 Malay 40 2016-09-08T10:09:00 2016-09-09T05:30:00 1002 1193 1835   0 0
87601 2616344667 AMANDAVGREEN 138 My Pet Fat #LastMinuteGifts2016 United States 2 Malay 40 2016-12-22T10:09:00 2016-12-22T10:09:00 4022 4706 5567 RETWEET 1 0 1
95921 1679279490 AMELIEBALDWIN 146 Petraeus again... https://t.co/SzLY7StdYi United States 2 Malay 40 2017-01-15T00:19:00 2017-01-15T00:31:00 2345 2721 25589 RETWEET 1 0 1
126387 1679279490 AMELIEBALDWIN 146 kesian tertipu dgn pelaburan emas. guna ayat agama sikit, bagitau orang harga emas takkan jatuh terus orang percaya https://t.co/TRP4vJcjC7 United States 2 Malay 40 2016-09-18T10:55:00 2016-09-18T10:55:00 1479 2203 8129 RETWEET 1 0 1
147439 2612066397 ANDYDREWDANIELS 186 BTS COMES TO MALAYSIA #My4WordNewYearsResolution United States 2 Malay 40 2016-12-21T14:43:00 2016-12-21T14:43:00 1727 1994 2092   1 0
175201 839000000000000000 ANNAROMAN0 220 60' PESCARA-ROMA 0-4, gol della Roma. Rete di Salah. https://t.co/241RCGxAdi Italy 3 Malay 40 2017-04-24T20:15:00 2017-04-24T20:15:00 564 96 3213 RETWEET 1 0 1
185994 1652262638 ANTONHAYHAY 237 My nigga coming back!! ���� https://t.co/Gh5jEdlKH8 United States 2 Malay 40 2017-01-04T05:33:00 2017-01-04T05:33:00 306 693 4338 RETWEET 1 0 1
191032 1652262638 ANTONHAYHAY 237 #ASAPFerg Ft. #LilUziVert & #MartyBaller "Uzi Gang" #Video #PRO https://t.co/JfXTMncPkY #Mixtapes #4 #Monday #NYC #Rap #Money #Rt United States 2 Malay 40 2017-03-27T20:54:00 2017-03-27T20:54:00 303 729 8445 RETWEET 1 0 1
205291 1686370159 ARCHIEOLIVERS 254 Malaysia: VX nerve agent killed outcast North Korean scion https://t.co/HMl9hZZZL7 United States 2 Malay 40 2017-02-24T16:24:00 2017-02-24T16:26:00 3320 2601 2411 RETWEET 1 0 1
207651 4440342138 ARGENTINACATLE1 256 Kalau lah "maaf" tu boleh mengubah semuanya . � United States 2 Malay 40 2016-06-05T10:39:00 2016-06-05T10:52:00 330 24 694 RETWEET 1 1 1
214117 1671936266 ARM_2_ALAN 269 #news Remembering Tanya Tandoc United States 2 Malay 40 2015-06-11T21:33:00 2015-06-11T21:33:00 66 166 8699 RETWEET 1 0 1
215442 1671936266 ARM_2_ALAN 269 Malaysian navy in contact with pirates aboard hijacked tanker Orkim Harmony: KUALA LUMPUR (Reuters) - Malaysia's Chief o... #world #news United States 2 Malay 40 2015-06-18T08:51:00 2015-06-18T08:52:00 65 163 9781 RETWEET 1 0 1
216205 1671936266 ARM_2_ALAN 269 ★★★ ISIS Expands To Malaysia – BB4SP http://t.co/TatK35Fi5N United States 2 Malay 40 2015-06-03T10:13:00 2015-06-03T10:13:00 68 98 1264 RETWEET 1 0 1
313208 725000000000000000 BERLINBOTE 372 Berliner Zoo: Pandadame Meng Meng frisst Deko-Bambus https://t.co/AK4bWxN0JN https://t.co/OYEw8VsDHE Unknown 1 Malay 40 2017-07-18T10:40:00 2017-07-18T10:40:00 2184 1585 19955   0 0
321273 725000000000000000 BERLINBOTE 372 Sorge um Meng Meng: Was fehlt der Berliner Pandadame? https://t.co/qKtC3ZHQeD https://t.co/ejtjM287Od Unknown 1 Malay 40 2017-09-30T06:39:00 2017-09-30T06:39:00 2218 1817 24009   0 0
324301 2732675512 BGARNER2107 384 Dikembe Mu-jumbo #SexySports @midnight United States 2 Malay 40 2017-01-24T10:19:00 2017-01-24T10:19:00 3810 4519 5659   0 0
328652 1584279696 BIGBOYJASIAH 387 #ASAPFerg Ft. #LilUziVert & #MartyBaller "Uzi Gang" #Video #PRO https://t.co/JfXTMncPkY #Friday #Payday #GetThisRap United States 2 Malay 40 2017-01-06T21:57:00 2017-01-06T21:57:00 387 732 3555 RETWEET 1 0 1
335446 1621376306 BIGSEANBEAST 389 #NowPlaying Wiz Khalifa - Gang Bang ft. @BigSean - https://t.co/0Qv1KMY0xy United States 2 Malay 40 2017-03-08T14:45:00 2017-03-08T14:45:00 744 805 4099 RETWEET 1 0 1
338903 3255856080 BIZGOD 393 Wrong notice: central malaysian finance v loke kok lai @_caitlin_long @Lionthrax @KPMG_TO @ZarynneAmeera @BRBBlog http://t.co/3dptgyfDsp United States 2 Malay 40 2015-06-27T01:37:00 2015-06-27T01:37:00 7 21 1061   1 0
367395 2633875617 BLAMEYOURRSELF 413 Hill Kong #MakeAMovieHillary http://t.co/rHSUaNr97A United States 2 Malay 40 2015-05-30T13:10:00 2015-05-30T13:10:00 152 147 796 RETWEET 1 0 1
398650 1718000594 BOOTH_PRINCE 431 Burkinis #MustBeBanned United States 2 Malay 40 2016-08-24T14:58:00 2016-08-24T14:58:00 5000 3397 7721 RETWEET 1 1 1
410994 1873206768 BRENTMCCLURE275 444 #NowPlaying Tangalang - Rider Ft @JustEnoughCT - https://t.co/0Qv1KMY0xy United States 2 Malay 40 2017-04-16T05:25:00 2017-04-16T05:26:00 728 795 6641 RETWEET 1 0 1
429542 2668171329 BRIGHTANDGLORY 452 My Pet Fat #LastMinuteGifts2016 United States 2 Malay 40 2016-12-22T09:31:00 2016-12-22T09:31:00 3257 3996 4982   0 0
430286 2668171329 BRIGHTANDGLORY 452 Malaysian Airlines travel voucher #RejectedMothersDayGifts United States 2 Malay 40 2015-05-08T16:06:00 2015-05-08T16:06:00 151 108 881 RETWEET 1 0 1
484970 1627699074 CANNONSHER 498 Malaysian jungle graves add to Obama's trade pact headache https://t.co/bb1iBCm0cX #ObamaTrade #tcot #uniteblue #tcot #pjnet #tgdn #p2 United States 2 Malay 40 2015-06-05T20:13:00 2015-06-05T20:13:00 0 119 3818 RETWEET 1 0 1
498772 2742482932 CASCASEYP 508 Malaysian flight boarding. Call tomorrow? #CancelPlansIn5Words United States 2 Malay 40 2016-11-19T08:22:00 2016-11-19T08:23:00 1863 2141 2685   0 0
506591 2589353987 CASSIEWELTCH 511 #BathroomSchmovies John Juan United States 2 Malay 40 2016-09-26T20:05:00 2016-09-26T20:06:00 866 1192 2221 RETWEET 1 0 1
510389 1629828379 CASSISHERE 512 Bakal terjawab 24 jam kemudian. http://t.co/nlTJldkgse #BBUK Bayern #TonyRobinson #WelcomeBackKidrauhl Ter Stegen United States 2 Malay 40 2015-05-12T22:40:00 2015-05-12T22:40:00 114 274 835 RETWEET 1 0 1
512913 1512371617 CATELINEWATKINS 514 Hill Kong #MakeAMovieHillary http://t.co/rHSUaNr97A United States 2 Malay 40 2015-05-30T13:11:00 2015-05-30T13:11:00 354 279 987 RETWEET 1 0 1
541835 1532863891 CHARLESJHARPER 533 Malaysian Airlines travel voucher #RejectedMothersDayGifts United States 2 Malay 40 2015-05-08T15:53:00 2015-05-08T15:53:00 195 168 818 RETWEET 1 0 1
564567 1877492857 CHESPLAYSCHESS 547 Malaysian jungle graves add to Obama's trade pact headache https://t.co/bb1iBCm0cX #ObamaTrade #tcot #uniteblue #tcot #pjnet #tgdn #p2 United States 2 Malay 40 2015-06-05T20:13:00 2015-06-05T20:13:00 74 150 3520 RETWEET 1 0 1
610300 1683408074 CHRIXCHASE 570 My Pet Fat #LastMinuteGifts2016 United States 2 Malay 40 2016-12-22T10:25:00 2016-12-22T10:25:00 2331 2819 3359 RETWEET 1 1 1
616269 2882350436 CHRIXMORGAN 571 #RealLifeMagicSpells Liquid Plumber United States 2 Malay 40 2016-11-14T14:31:00 2016-11-14T14:31:00 10292 18798 11541 RETWEET 1 0 1
623080 2882350436 CHRIXMORGAN 571 '@BrendonWScott Gang Bang!' United States 2 Malay 40 2015-05-13T09:47:00 2015-05-13T09:47:00 3152 7189 829   0 0
629585 1664988493 CLAUDIA42KERN 578 My Pet Fat #LastMinuteGifts2016 United States 2 Malay 40 2016-12-22T10:21:00 2016-12-22T10:21:00 3068 3472 3719 RETWEET 1 0 1
629723 1664988493 CLAUDIA42KERN 578 #AlternativeAcronymInterpretations OP - Old Plumbus   Malay 40 2016-12-05T14:54:00 2016-12-05T14:58:00 2705 2990 3281   0 0
655851 1710804738 COOKNCOOKS 598 bernamadotcom: Datuk Iskandar Mohd Kaus dilantik Ketua Setiausaha Sulit Kepada Perdana Menteri mulai 1 Oktober 201… https://t.co/vlOT4jxPxH United States 2 Malay 40 2016-09-30T11:29:00 2016-09-30T11:29:00 1458 1443 1826 RETWEET 1 0 1
755062 2495567768 DAILYSANFRAN 626 Malaysia seizes 18 rhino horns from Mozambique https://t.co/xL92w13LR8 https://t.co/2I30x9Hi71 United States 2 Malay 40 2017-04-10T13:08:00 2017-04-10T13:08:00 6000 17116 39472   0 0
799136 2882037326 DANAGEEZUS 634 RT if Emperor Penguin, FAV if Kim Kardashian #whoworeitbetter http://t.co/TXm1k5hdiU United States 2 Malay 40 2015-05-27T10:08:00 2015-05-27T10:08:00 3071 8046 1296   0 0
822552 1039581360 DARKNALLY 655 Foke Skydivers jump off 300m Kuala Lumpur Tower in Malaysia  https://t.co/gNsP4rE2ll #Foke United States 2 Malay 40 2016-10-02T11:40:00 2016-10-02T11:40:00 40 21 21497   0 0
822953 1039581360 DARKNALLY 655 Foke James Packer 'DUMPS' fiancée Mariah Carey over 'excessive spending' https://t.co/m1uX6bFn3O #Foke United States 2 Malay 40 2016-10-27T01:07:00 2016-10-27T01:07:00 40 22 22664   0 0
823283 1039581360 DARKNALLY 655 Foke Kim Kardashian's personal bodyguard Pascal Duvier filed BANKRUPTCY https://t.co/3zLDA0cBBo #Foke United States 2 Malay 40 2016-10-05T19:23:00 2016-10-05T19:24:00 40 21 21669   0 0
823941 1039581360 DARKNALLY 655 Foke Dame Sarah Storey wins 14th Paralympic gold medal https://t.co/xggiIaipxG #Foke United States 2 Malay 40 2016-09-18T01:43:00 2016-09-18T01:44:00 40 19 20865   0 0
824127 1039581360 DARKNALLY 655 Foke Angelina Jolie's estranged relative gives rare glimpse into star's bizarre childhood https://t.co/5uWEvwsnBr #Foke United States 2 Malay 40 2016-09-22T02:31:00 2016-09-22T02:32:00 40 19 21052   0 0
824275 1039581360 DARKNALLY 655 Foke Alberto Mugrabi marries Colby Jordan, in French Riviera fete https://t.co/LZv8fl1fE1 #Foke United States 2 Malay 40 2016-09-26T18:50:00 2016-09-26T18:50:00 40 19 21224   0 0
827697 1684524144 DATWISENIGGA 663 #BeanieSigel "Gang Gang" #MeekMillDiss #Video #PRO https://t.co/nqvn3umeYb #TBT #Day #Follows #Play #Meet #Rap #Rt United States 2 Malay 40 2016-12-01T18:42:00 2016-12-01T18:42:00 804 912 2732 RETWEET 1 0 1
844673 892000000000000000 DEBESSTRS 674 RT Rana_Semancik: #CriminalClinton #LockHerUp #Corrupt #WhyIsSheNotInJail #IAmAgainstHer https://t.co/fZhsMKBzCs Unknown 1 Malay 40 2017-08-07T14:54:00 2017-08-07T14:54:00 1731 1161 4536 QUOTE_TWEET 2 0 1
847660 890000000000000000 DEBORRTH 676 #lost RT jojoh888: .SenateMajLdr #DitchMitch2020 👋 https://t.co/tIRxXW42us #love Unknown 1 Malay 40 2017-08-11T20:10:00 2017-08-11T20:10:00 1967 558 933   0 0
863611 2571870453 DETROITDAILYNEW 699 Report: Kim Jong-un’s half-brother killed in Malaysia https://t.co/0VVFo9Bm4H https://t.co/kTljg2oAhG United States 2 Malay 40 2017-02-14T12:57:00 2017-02-14T12:57:00 5858 18634 21123   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 83.188ms · Data source: fivethirtyeight/russian-troll-tweets