home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

590 rows where language = 10

View and edit SQL

Suggested facets: region, post_type, account_type, new_june_2018, account_category

Link rowid external_author_id author content region language publish_date harvested_date following followers updates post_type new_june_2018 retweet
683 839000000000000000 1LORENAFAVA1 5 Far west a Lodi, la sinistra tace, la destra incassa. @fcancellato https://t.co/PVZYN9LQzU https://t.co/9tDpknMtDD Italy 3 Catalan 10 2017-03-14T10:41:00 2017-03-14T10:41:00 412 79 474 RETWEET 1 0 1
1065 839000000000000000 1LORENAFAVA1 5 Alle radici del #genocidio del #Rwanda del ‘94. https://t.co/ih7I0JVI9Y https://t.co/3A6hvkxISY Italy 3 Catalan 10 2017-03-21T12:26:00 2017-03-21T12:29:00 412 83 935 RETWEET 1 0 1
1524 839000000000000000 1LORENAFAVA1 5 #SalviamoFlixbus. Una firma per la #concorrenza. @Strade_Magazine @FlixBus_IT https://t.co/K3jDlnrYBh Italy 3 Catalan 10 2017-03-30T16:23:00 2017-03-30T16:23:00 409 86 1518 RETWEET 1 0 1
1878 839000000000000000 1LORENAFAVA1 5 #Trump avverte #Kim, portaerei #Usa verso la #Corea del Nord https://t.co/vZBlL2YewQ Italy 3 Catalan 10 2017-04-10T05:27:00 2017-04-10T05:28:00 408 89 2182 RETWEET 1 0 1
2481 839000000000000000 1LORENAFAVA1 5 Champions, la @juventusfc pesca l'@AS_Monaco https://t.co/kK3OrGzjUL https://t.co/lE94MopCeV Italy 3 Catalan 10 2017-04-21T10:47:00 2017-04-21T10:47:00 406 94 2908 RETWEET 1 0 1
2583 839000000000000000 1LORENAFAVA1 5 Il #Sassuolo frena la corsa del #Napoli https://t.co/h8zYy5x4xk https://t.co/DPMTGysK3a Italy 3 Catalan 10 2017-04-23T13:12:00 2017-04-23T13:12:00 406 95 3042 RETWEET 1 0 1
2866 839000000000000000 1LORENAFAVA1 5 Blitz #antiterrorismo a #Londra: 6 arresti, ferita 20enne https://t.co/rQe3M94nw0 https://t.co/ULWQ4235CQ Italy 3 Catalan 10 2017-04-28T09:03:00 2017-04-28T09:03:00 408 99 3336 RETWEET 1 0 1
3436 839000000000000000 1LORENAFAVA1 5 #Facebook, arriva la #truffa della #pensione https://t.co/vgYdX0DjuK https://t.co/gO3MlayiMZ Italy 3 Catalan 10 2017-05-02T04:36:00 2017-05-02T04:36:00 406 102 3578 RETWEET 1 0 1
3517 839000000000000000 1LORENAFAVA1 5 A #Roma la mostra di #YokoOno - https://t.co/FdgpxO4Gzl Italy 3 Catalan 10 2017-05-04T06:34:00 2017-05-04T06:34:00 406 103 3717 RETWEET 1 0 1
7353 4036537452 4MYSQUAD 10 '@FreakOutNation Brits hate racist morons' United States 2 Catalan 10 2015-12-09T23:07:00 2015-12-09T23:07:00 4999 897 592   0 0
15877 2534421182 ABIGAILSSILK 28 HOT AbERCROMBIE ModELS http://t.co/jHSXK3tUXB HOT AbERCROMBIE ModELS United States 2 Catalan 10 2015-03-13T09:07:00 2015-03-13T09:07:00 186 143 795   0 0
17378 893000000000000000 ABIISSROSB 29 AMike4761 RealAudreyLamb TruthFeedNews realDonaldTrump hummm United States 2 Catalan 10 2017-08-07T16:54:00 2017-08-07T16:54:00 974 616 93   0 0
17473 893000000000000000 ABIISSROSB 29 winkie1111 MaxineWaters POTUS 😂😂 https://t.co/ahMZuxAONK United States 2 Catalan 10 2017-08-08T01:10:00 2017-08-08T01:10:00 974 624 185   0 0
19280 1652138929 ACEJINEV 38 http://t.co/GXRCrgicBc cats do wiggle Unknown 1 Catalan 10 2015-01-12T08:40:00 2015-01-12T08:41:00 275 83 116   0 0
22294 1652138929 ACEJINEV 38 luxury cats http://t.co/eNpjnGCgrr Unknown 1 Catalan 10 2015-02-08T17:03:00 2015-02-08T17:04:00 266 86 181   0 0
27721 1704035413 ADDIE_HOL 45 HOT AbERCROMBIE ModELS http://t.co/N1DPdvU2vP HOT AbERCROMBIE ModELS United States 2 Catalan 10 2015-05-25T12:05:00 2015-05-25T12:07:00 82 54 327   0 0
35928 1660186831 ADRGREERR 54 America's Supergun... https://t.co/rOVSLUuHSC United States 2 Catalan 10 2016-05-28T13:58:00 2016-05-28T13:58:00 569 418 1128 RETWEET 1 0 1
36988 1657833811 ADRIENNE_GG 57 http://t.co/KYvIyiUJ0C Cat vs Parrot United States 2 Catalan 10 2015-01-25T21:53:00 2015-01-25T21:53:00 127 117 106   0 0
37781 1657833811 ADRIENNE_GG 57 La petite mort.... #betterthanitsounds United States 2 Catalan 10 2016-12-03T13:47:00 2016-12-03T13:47:00 2571 2553 2686 RETWEET 1 0 1
38001 1657833811 ADRIENNE_GG 57 5 SOS 5 SOS 5 SOS http://t.co/xAh24p4308 United States 2 Catalan 10 2015-02-16T14:11:00 2015-02-16T14:11:00 108 129 388   0 0
38151 1657833811 ADRIENNE_GG 57 luxury cats http://t.co/ubqIdjG9WM United States 2 Catalan 10 2015-02-08T14:09:00 2015-02-08T14:09:00 265 121 166   0 0
38176 1657833811 ADRIENNE_GG 57 5 SOS 5 SOS 5 SOS http://t.co/xAh24oMrBy United States 2 Catalan 10 2015-02-08T14:33:00 2015-02-08T14:33:00 265 122 202   0 0
38252 1657833811 ADRIENNE_GG 57 babies cats=? http://t.co/MB8lPOezmK United States 2 Catalan 10 2015-02-08T15:28:00 2015-02-08T15:28:00 265 122 302   0 0
38357 1657833811 ADRIENNE_GG 57 J Lo!! My queen!!! http://t.co/HxiKWB8A43 United States 2 Catalan 10 2015-03-13T09:47:00 2015-03-13T09:47:00 149 142 540   0 0
38449 1657833811 ADRIENNE_GG 57 http://t.co/ikHEN1jrTK Cat vs Parrot United States 2 Catalan 10 2015-03-16T14:50:00 2015-03-16T14:50:00 150 142 696   0 0
47415 2570250275 AIDEN7757 81 Bomb bons #DangerousFoods United States 2 Catalan 10 2016-11-08T22:11:00 2016-11-08T22:11:00 1958 1833 2394 RETWEET 1 0 1
48655 2570250275 AIDEN7757 81 Buns 'N Noses #UnpopularRockBands http://t.co/eMIuBWbAap United States 2 Catalan 10 2015-05-11T09:49:00 2015-05-11T09:50:00 136 72 804 RETWEET 1 0 1
49025 2570250275 AIDEN7757 81 #OneWordOffMovieQuotes asshole la vista baby United States 2 Catalan 10 2016-08-16T10:41:00 2016-08-16T10:41:00 1837 1003 1527   0 0
52406 3082043421 ALBERTMORENMORE 88 excellent! http://t.co/H1yfpWdIiE United States 2 Catalan 10 2015-04-27T10:21:00 2015-04-27T10:21:00 142 73 213   0 0
53020 802673000000000000 ALBUQUERQUEON 89 Rockies caravan plans Albuquerque visit https://t.co/iTtoBcWLin https://t.co/npAIjgLnGY Unknown 1 Catalan 10 2017-01-19T03:28:00 2017-01-19T03:28:00 60 10 1309   1 0
53261 802673000000000000 ALBUQUERQUEON 89 Updated: Rockies, Albuquerque fans enjoy caravan visit https://t.co/kMqbl7wqyo https://t.co/BTLTsAGUyr Unknown 1 Catalan 10 2017-01-28T04:54:00 2017-01-28T04:54:00 61 13 1544   1 0
55017 802673000000000000 ALBUQUERQUEON 89 Albuquerque BioPark celebrates marine mammals https://t.co/rwudocwGnf https://t.co/ja7sJJIOnH Unknown 1 Catalan 10 2017-03-14T23:18:00 2017-03-14T23:18:00 2982 338 2476   1 0
55090 802673000000000000 ALBUQUERQUEON 89 Albuquerque BioPark introduces new Malayan tiger https://t.co/qpzrWSlZty https://t.co/fNK51LUn8B Unknown 1 Catalan 10 2017-03-20T23:01:00 2017-03-20T23:01:00 3356 381 2523   1 0
57164 3083086600 ALDRICH420 90 Millennials. https://t.co/cXKmQlJ6Cz United States 2 Catalan 10 2017-02-15T00:26:00 2017-02-15T00:26:00 1642 1531 2414 RETWEET 1 0 1
66510 1652987412 ALECMOOOOODY 91 excellent https://t.co/jaUKHb1t61 United States 2 Catalan 10 2017-07-12T20:44:00 2017-07-12T20:44:00 506 867 9713 RETWEET 1 0 1
72360 2559217373 ALEXSVLADIMIROV 104 16/03/1968: Matanza de Mỹ Lai. Tropas de EEUU masacran a cientos de civiles vietnamitas. Vietnam resistió y venció. https://t.co/dMZqSpUJcf Unknown 1 Catalan 10 2017-03-17T00:07:00 2017-03-17T00:07:00 70 1988 1922 RETWEET 1 0 1
75714 893000000000000000 ALEXXDRTRR 107 RT peplamb: peplamb #Jesus is our #Lord #RedeemerLives 💖😇🙏 #OneNationUnderGOD https://t.co/NxJtKKXd5n Unknown 1 Catalan 10 2017-08-18T15:05:00 2017-08-18T15:06:00 34 6 3168   0 0
75881 893000000000000000 ALEXXDRTRR 107 RT peplamb: peplamb GOD Bless #OurPresident #Trump 🙏❤️🌹 #PrayForTrump #OneNationUnderGOD https://t.co/1ZgZ9FZNOF Unknown 1 Catalan 10 2017-08-18T01:05:00 2017-08-18T01:05:00 34 6 2824   0 0
77992 2570636705 ALFREDTHREE 112 Spectacular https://t.co/MFRvLCzwpK United States 2 Catalan 10 2015-12-02T13:12:00 2015-12-02T13:12:00 1336 256 678 RETWEET 1 0 1
86211 2616344667 AMANDAVGREEN 138 #RenameMillionWomenMarch Valtrex Vixen March United States 2 Catalan 10 2017-01-19T14:36:00 2017-01-19T14:36:00 4730 5346 5871   0 0
88336 2616344667 AMANDAVGREEN 138 Grumpy Cats #DumberBroadway @midnight United States 2 Catalan 10 2017-03-29T09:46:00 2017-03-29T09:47:00 5503 6918 6565   0 0
89451 2616344667 AMANDAVGREEN 138 Alan Embree’s Company #AthleticsTVShows United States 2 Catalan 10 2016-08-15T09:55:00 2016-08-15T09:56:00 2394 2191 2889   0 0
95750 1679279490 AMELIEBALDWIN 146 Fire Emblem #Switchmas United States 2 Catalan 10 2017-01-13T04:51:00 2017-01-13T04:51:00 2346 2734 25356 RETWEET 1 0 1
99299 1679279490 AMELIEBALDWIN 146 '@TheWelshTwitt @HillaryClinton @bsdorazi @RogerJStoneJr @KazmierskiR @wikileaks Podesta strikes back.... https://t.co/h89oPe3d7F' United States 2 Catalan 10 2016-10-16T21:06:00 2016-10-16T21:06:00 1941 2471 14564 RETWEET 1 0 1
100431 1679279490 AMELIEBALDWIN 146 #GrandiOpere arresti per la #TAV Milano-Genova e per la #SalernoReggioCalabria lo sa @matteorenzi? e @graziano_delrio #IoVotoNO https://t.co/g5hDGB8m8H United States 2 Catalan 10 2016-10-26T09:04:00 2016-10-26T09:04:00 1930 2451 15604 RETWEET 1 0 1
122416 1679279490 AMELIEBALDWIN 146 '@Jenn_Abrams Terrible!' United States 2 Catalan 10 2015-08-18T08:24:00 2015-08-18T08:24:00 763 398 1642   0 0
126155 1679279490 AMELIEBALDWIN 146 https://t.co/LX8lmjwRUz Antoni⭐Tolmos~Like a bird ~avui es publica el nou CD Energy, amb la meva obra PAU. Merci ❤ https://t.co/dc4lBBuguV United States 2 Catalan 10 2016-09-17T08:57:00 2016-09-17T08:57:00 1481 2091 5808 RETWEET 1 0 1
129453 1679279490 AMELIEBALDWIN 146 '@JamesLewisMurr1 @Elena07617349 @BLang71 @TheVoiceOfPaulR @reda2448 Excellent' United States 2 Catalan 10 2016-09-29T14:03:00 2016-09-29T14:03:00 1947 2345 10647 RETWEET 1 0 1
138131 895000000000000000 ANAALESSIS 160 RT jordipc: Estampida ahora mismo en El Corte Inglés de Plaza Catalunya en Barcelona https://t.co/aHrJur3jLi Unknown 1 Catalan 10 2017-08-17T17:51:00 2017-08-17T17:51:00 1005 219 1162   0 0
138171 895000000000000000 ANAALESSIS 160 RT peplamb: peplamb Pray for realDonaldTrump #GodBlessAmerica 🙏🇺🇸❤️🌹 #OneNationUnderGOD https://t.co/453CeGYSHj Unknown 1 Catalan 10 2017-08-17T18:55:00 2017-08-17T18:55:00 1005 219 1208   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 97.131ms · Data source: fivethirtyeight/russian-troll-tweets