home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

1,631 rows where language = 8

View and edit SQL

Suggested facets: 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
554 839000000000000000 1LORENAFAVA1 5 La sapete l’ultima pensata fiscale di #Renzi il rottamatore? #LIBERA di Elisabetta De Dominis https://t.co/6UIhsAGZpv via @lavocedinewyork Italy 3 Romanian 8 2017-03-11T01:10:00 2017-03-11T01:10:00 416 62 269 RETWEET 1 0 1
699 839000000000000000 1LORENAFAVA1 5 .@CharlizeAfrica si rompe due denti sul #set di 'Atomic Blonde' https://t.co/tngDONYjPF https://t.co/yKNv8JAvnu Italy 3 Romanian 8 2017-03-14T17:12:00 2017-03-14T17:12:00 412 79 494 RETWEET 1 0 1
794 839000000000000000 1LORENAFAVA1 5 #Marocco: Re #MohammedVI revoca il mandato al premier #Benkirane https://t.co/SCiednLpcN Italy 3 Romanian 8 2017-03-16T11:04:00 2017-03-16T11:04:00 412 81 612 RETWEET 1 0 1
1393 839000000000000000 1LORENAFAVA1 5 I nemici d’Europa https://t.co/PYJZoHgiLs @DavideGiac Italy 3 Romanian 8 2017-03-27T07:05:00 2017-03-27T07:05:00 411 83 1290 RETWEET 1 0 1
1436 839000000000000000 1LORENAFAVA1 5 '++#Francia, indagata Penelope #Fillon ++ >>https://t.co/Fl8QTi3lAw' Italy 3 Romanian 8 2017-03-28T21:01:00 2017-03-28T21:01:00 409 87 1405 RETWEET 1 0 1
1549 839000000000000000 1LORENAFAVA1 5 Aprile al cinema, i film da non perdere https://t.co/THFM99EHtB https://t.co/rtseAuiiUT Italy 3 Romanian 8 2017-03-30T05:52:00 2017-03-30T05:52:00 409 83 1481 RETWEET 1 0 1
2032 839000000000000000 1LORENAFAVA1 5 Il 19 aprile asteroide gigante sfiorerà la Terra https://t.co/ZSeUCsL7cN https://t.co/hLHbF6f5Ya Italy 3 Romanian 8 2017-04-13T20:24:00 2017-04-13T20:24:00 408 89 2425 RETWEET 1 0 1
2165 839000000000000000 1LORENAFAVA1 5 Tre numeri per capire l'attualità Erdoğan https://t.co/AWFjRYSf33 La Corea del Nord https://t.co/e0N9fvYLxz Trump https://t.co/Es9BMHJAZK https://t.co/fnkLmWvZgh Italy 3 Romanian 8 2017-04-15T09:18:00 2017-04-15T09:18:00 407 88 2531 RETWEET 1 0 1
2258 839000000000000000 1LORENAFAVA1 5 Juve: Dybala, al Camp Nou ci saro' https://t.co/BNo9JI37eT Italy 3 Romanian 8 2017-04-17T21:07:00 2017-04-17T21:07:00 406 89 2703 RETWEET 1 0 1
2547 839000000000000000 1LORENAFAVA1 5 Liti fiscali, sanatoria in 3 rate https://t.co/lzbURdrPXs https://t.co/JjsWzPqFpn Italy 3 Romanian 8 2017-04-22T19:38:00 2017-04-22T19:39:00 406 95 3002 RETWEET 1 0 1
2557 839000000000000000 1LORENAFAVA1 5 Liti fiscali, sanatoria in 3 rate https://t.co/fwK6qq3hCQ https://t.co/v3CXpDZUbE Italy 3 Romanian 8 2017-04-22T22:25:00 2017-04-22T22:25:00 406 95 3013 RETWEET 1 0 1
2746 839000000000000000 1LORENAFAVA1 5 Arriva la sanatoria per le liti fiscali https://t.co/nEFU7F61j7 https://t.co/gqVapoqgRc Italy 3 Romanian 8 2017-04-26T04:47:00 2017-04-26T04:47:00 406 95 3195 RETWEET 1 0 1
2891 839000000000000000 1LORENAFAVA1 5 #Primarie del #Pd - IL VADEMECUM - VIDEO https://t.co/CQWgx99ihZ Italy 3 Romanian 8 2017-04-29T17:27:00 2017-04-29T17:27:00 408 99 3427 RETWEET 1 0 1
3017 839000000000000000 1LORENAFAVA1 5 #Primarie del #Pd - IL VADEMECUM - VIDEO https://t.co/CQWgx99ihZ Italy 3 Romanian 8 2017-04-30T05:53:00 2017-04-30T05:54:00 408 100 3447 RETWEET 1 0 1
3513 839000000000000000 1LORENAFAVA1 5 La #Juve batte il Monaco 0-2 e vede la finale https://t.co/0jaQI8pGmv https://t.co/MMGTwO4lS6 Italy 3 Romanian 8 2017-05-04T05:28:00 2017-05-04T05:28:00 406 103 3712 RETWEET 1 0 1
6269 3312143142 4MYSQUAD 10 #SnoopDogg roasting #DonaldTrump. #rap #BlackLivesMatter #president #nobodyforapresident #blackTwitter #blackpower http://t.co/ylgp8eAV4X United States 2 Romanian 8 2015-10-05T10:54:00 2015-10-05T10:54:00 1193 944 3704   0 0
8826 3312143142 4MYSQUAD 10 '@ParisHilton DOAMOND IN DE SKUY' United States 2 Romanian 8 2015-08-31T13:06:00 2015-08-31T13:06:00 1313 569 1720   0 0
9204 3312143142 4MYSQUAD 10 ALEXANDRIA, VA MON SEP 14 - 7:00 PM #BlackLivesMatter #Blackpeople #racism #racisminAmerica #StayWoke #blackgirl http://t.co/3AbjqGhtuk United States 2 Romanian 8 2015-09-18T15:41:00 2015-09-18T15:41:00 953 573 2549   0 0
9476 3312143142 4MYSQUAD 10 '@rickygervais bon ape tit' United States 2 Romanian 8 2015-09-22T23:07:00 2015-09-22T23:07:00 1730 661 2840   0 0
9639 3312143142 4MYSQUAD 10 '@Sarah_Hyland @EmeraudeToubia PeerPresure' United States 2 Romanian 8 2015-09-25T23:57:00 2015-09-25T23:58:00 1501 716 3045   0 0
9709 3312143142 4MYSQUAD 10 '@RyanSeacrest Bon Ape Tit!' United States 2 Romanian 8 2015-09-26T21:17:00 2015-09-26T21:17:00 2001 811 3147   0 0
15888 2534421182 ABIGAILSSILK 28 http://t.co/n9uTCuouEG ned a cat ASAP United States 2 Romanian 8 2015-03-13T09:24:00 2015-03-13T09:24:00 186 144 808   0 0
16452 2534421182 ABIGAILSSILK 28 #BodyPartActors Nicol-Arse Cage United States 2 Romanian 8 2016-07-27T12:08:00 2016-07-27T12:09:00 465 498 1268 RETWEET 1 0 1
21186 1652138929 ACEJINEV 38 #NowPlaying: JAY Z "Spiritual" #hiphop #rap #checkitout https://t.co/mcmlaH7Qcn United States 2 Romanian 8 2016-12-16T22:50:00 2016-12-16T22:52:00 796 894 2894 RETWEET 1 0 1
22277 1652138929 ACEJINEV 38 ned a cat ASAP http://t.co/Ph2Ze7P3UO Unknown 1 Romanian 8 2015-02-08T16:50:00 2015-02-08T16:50:00 266 86 160   0 0
24939 1652138929 ACEJINEV 38 '@fyahlite @Afurakani0 @Northside_Ahmed @Fresh_Flames1 @dijoni @MsKTweetsTruth @angelaw676 @wokemelaninaire @Browndeus @Asim_the_Great @ArielTheGoddess @RasThaFarEye @panafricanuk Absolute prophecy' United States 2 Romanian 8 2017-07-28T16:36:00 2017-07-28T16:36:00 777 915 6971 RETWEET 1 0 1
34702 1660186831 ADRGREERR 54 Robot Invasion http://t.co/aXAJvsRtA3 United States 2 Romanian 8 2015-01-29T15:47:00 2015-01-29T15:47:00 271 100 138   0 0
37332 1657833811 ADRIENNE_GG 57 #WhatIWantForChristmasIn4Words dormir, dormir, comer, dormir. United States 2 Romanian 8 2016-11-24T10:53:00 2016-11-24T10:53:00 2147 2204 2458   0 0
37509 1657833811 ADRIENNE_GG 57 America's Last Gasp! #2016ElectionIn3Words United States 2 Romanian 8 2016-11-07T15:11:00 2016-11-07T15:11:00 1709 1841 2130 RETWEET 1 0 1
38142 1657833811 ADRIENNE_GG 57 http://t.co/bHHTK5XWRU cat vs trashcan United States 2 Romanian 8 2015-02-08T14:04:00 2015-02-08T14:04:00 265 121 154   0 0
38198 1657833811 ADRIENNE_GG 57 http://t.co/bx6QTyqwXk ned a cat ASAP United States 2 Romanian 8 2015-02-08T14:46:00 2015-02-08T14:46:00 265 122 232   0 0
38385 1657833811 ADRIENNE_GG 57 http://t.co/01XtfmMPHC best cat vines lol United States 2 Romanian 8 2015-03-16T14:24:00 2015-03-16T14:24:00 150 142 610   0 0
38646 1657833811 ADRIENNE_GG 57 #SuperOldHeroes Centrum Silver Surfer @midnight United States 2 Romanian 8 2017-03-03T10:46:00 2017-03-03T10:46:00 3813 4383 3436   0 0
38842 1657833811 ADRIENNE_GG 57 Stray Cataracts #RetireASongOrBand United Kingdom 9 Romanian 8 2017-04-17T10:36:00 2017-04-17T10:37:00 3715 4504 3743   0 0
39100 1657833811 ADRIENNE_GG 57 #MyNewCatchPhraseIs : callate pendeja United States 2 Romanian 8 2016-08-10T11:05:00 2016-08-10T14:26:00 1493 702 1212   0 0
39584 1657833811 ADRIENNE_GG 57 #BathroomSchmovies Paseptic Rim United States 2 Romanian 8 2016-09-26T19:43:00 2016-09-26T19:43:00 1077 1358 1815 RETWEET 1 0 1
45198 1740465132 AHOGAN_AM 79 ridiculous http://t.co/Zk7skhG7jF United States 2 Romanian 8 2015-06-09T10:11:00 2015-06-09T10:11:00 63 68 477   0 0
46543 2570250275 AIDEN7757 81 Legalize POTUS ... #POTUSLastTweet United States 2 Romanian 8 2017-01-18T15:40:00 2017-01-18T15:40:00 2980 2941 3520 RETWEET 1 0 1
47247 2570250275 AIDEN7757 81 #AnimalJobs Animal Cop @KevinJames United States 2 Romanian 8 2016-11-28T11:16:00 2016-11-28T11:16:00 1827 2143 2670 RETWEET 1 0 1
48700 2570250275 AIDEN7757 81 #TakeAMovieToBreakfast cereal Mom United States 2 Romanian 8 2015-05-21T13:06:00 2015-05-21T13:06:00 429 149 857 RETWEET 1 0 1
48804 2570250275 AIDEN7757 81 #BodyPartActors Nicol-Arse Cage United States 2 Romanian 8 2016-07-27T11:00:00 2016-07-27T11:00:00 1086 555 1114 RETWEET 1 0 1
51619 1683415466 ALBERTA_HAYNESS 87 http://t.co/CoTKWY3A2y pet meee,cutie United States 2 Romanian 8 2015-07-04T09:45:00 2015-07-04T09:45:00 94 49 397   0 0
55574 3083086600 ALDRICH420 90 Horoscopes January 2017 https://t.co/POuA5WIiub United States 2 Romanian 8 2017-01-01T07:16:00 2017-01-01T07:16:00 1650 1534 1702 RETWEET 1 0 1
57798 3083086600 ALDRICH420 90 DRAMA ALERT https://t.co/DWFUbK5qpZ United States 2 Romanian 8 2017-03-13T20:37:00 2017-03-13T20:37:00 1638 1509 2831 RETWEET 1 0 1
66671 1652987412 ALECMOOOOODY 91 Rihanna's Valerian premiere dress>>>> https://t.co/d3VdnwCM85 United States 2 Romanian 8 2017-07-18T04:07:00 2017-07-18T04:07:00 507 872 9880 RETWEET 1 0 1
85456 1694331349 ALVA_MC_GHEE 131 Clintonator #MakeAMovieHillary United States 2 Romanian 8 2015-05-30T13:49:00 2015-05-30T13:49:00 218 113 551 RETWEET 1 0 1
86174 2616344667 AMANDAVGREEN 138 Artemi Panarin Scored. #3WordsBetterThanILoveYou United States 2 Romanian 8 2017-01-18T15:00:00 2017-01-18T15:01:00 4959 5269 5820   0 0
86507 2616344667 AMANDAVGREEN 138 A Pussy Grabbing Contest #BetterAlternativeToDebates https://t.co/FYZ5J16Xap United States 2 Romanian 8 2016-10-10T14:06:00 2016-10-10T14:06:00 3314 3302 4027 RETWEET 1 0 1
86759 2616344667 AMANDAVGREEN 138 Anaheim Duck-Faces #MillennialSportsTeams @MidweekMinute United States 2 Romanian 8 2016-10-19T18:00:00 2016-10-19T18:00:00 3099 3426 4329 RETWEET 1 0 1
87501 2616344667 AMANDAVGREEN 138 Ultimate!!� https://t.co/7rIGTWuGb1 United States 2 Romanian 8 2016-12-19T09:05:00 2016-12-19T09:05:00 3546 4642 5371 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 279.492ms · Data source: fivethirtyeight/russian-troll-tweets