home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

192 rows where language = 34

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
16072 2534421182 ABIGAILSSILK 28 #Bandwiches Clinton Melt http://t.co/cqnBJPgXYC United States 2 Hungarian 34 2015-04-16T08:35:00 2015-04-16T08:35:00 238 210 1135 RETWEET 1 0 1
46752 2570250275 AIDEN7757 81 14:04 Pink Yetti! http://t.co/uLGDULY8nx United States 2 Hungarian 34 2015-01-29T20:31:00 2015-01-29T20:32:00 133 11 134   0 0
58317 3083086600 ALDRICH420 90 Stalin Monument In Budapest https://t.co/wYex6HQNcn United States 2 Hungarian 34 2017-03-09T07:58:00 2017-03-09T07:58:00 1639 1510 2759 RETWEET 1 0 1
63407 1652987412 ALECMOOOOODY 91 Rénzél strikes ��� again - No more @IamDEELISHIS✌� @rickyrozay has wifed up @thegame's ex PYT @Indialoveinc: https://t.co/dCjOEeD839 https://t.co/3h8myaQmDN United States 2 Hungarian 34 2017-02-11T17:20:00 2017-02-11T17:21:00 521 881 6773 RETWEET 1 0 1
103030 1679279490 AMELIEBALDWIN 146 Les passagers d’un TER gazés et frappés par une bande d’adolescents https://t.co/trCXut2y0e United States 2 Hungarian 34 2016-11-10T11:40:00 2016-11-10T11:40:00 2391 2542 17484 RETWEET 1 0 1
122788 1679279490 AMELIEBALDWIN 146 Never Forgotten https://t.co/LyG0jGCban United States 2 Hungarian 34 2016-09-11T14:51:00 2016-09-11T14:54:00 1484 1989 3244 RETWEET 1 0 1
127773 1679279490 AMELIEBALDWIN 146 Evo, kaj želijo Madžari svojega ohraniti s svojim uporom multikulti EU... KATICA ILLÉNYI - Monti Czardas https://t.co/fv3nTgCT5L @YouTube United States 2 Hungarian 34 2016-09-19T10:05:00 2016-09-19T10:05:00 1479 2265 9020 RETWEET 1 0 1
153963 2878166306 ANDYHASHTAGGER 187 #PresentsTrumpGot Megyn Kelly United States 2 Hungarian 34 2016-06-15T14:56:00 2016-06-15T14:56:00 19121 22414 10554 RETWEET 1 1 1
221641 1671936266 ARM_2_ALAN 269 #MusicalInstrumentMovies Lyre, Lyre United States 2 Hungarian 34 2015-06-09T19:53:00 2015-06-09T19:53:00 68 157 6726 RETWEET 1 0 1
245536 2497991305 AUSTINLOVESBEER 298 14:04 Pink Yetti! http://t.co/CpTGnrmlfy United States 2 Hungarian 34 2015-03-19T13:53:00 2015-03-19T13:53:00 48 42 188   0 0
248822 3487717396 BABCHENKOVA_EVA 311 Si estás buscando ese hogar ideal, entonces asesórate con los mejores http://t.co/TW7GiZraz3 #ColdwellBankerCaribe http://t.co/jEB3THN2if Unknown 1 Hungarian 34 2015-10-16T21:27:00 2015-10-27T07:04:00 0 0 14 RETWEET 1 1 1
304375 725000000000000000 BERLINBOTE 372 Kamellen-Zombies https://t.co/v3JPcgqwh0 Unknown 1 Hungarian 34 2017-02-17T17:09:00 2017-02-17T17:09:00 3143 410 12832   0 0
304747 725000000000000000 BERLINBOTE 372 BER: Technikchef Jörg Marks gefeuert! https://t.co/r09GSs8U6R https://t.co/K6mNG50Wzs Unknown 1 Hungarian 34 2017-02-23T11:10:00 2017-02-23T11:11:00 3533 502 13161   0 0
305385 725000000000000000 BERLINBOTE 372 Spandau 04 beim 7:12 in Szolnok ohne Chance https://t.co/0qfPWMmrOt https://t.co/6rmjYiAbLM Unknown 1 Hungarian 34 2017-02-08T20:39:00 2017-02-08T20:39:00 1723 283 12239   0 0
308908 725000000000000000 BERLINBOTE 372 Kreuzberg: Szeneladen „M99“ umgezogen https://t.co/yJxnv2Q8mm https://t.co/vLaBMwX1VS Unknown 1 Hungarian 34 2017-05-24T15:29:00 2017-05-24T15:29:00 1351 1267 17314   0 0
316315 725000000000000000 BERLINBOTE 372 #Köln #Cologne #Instagramphoto via suzywan_kenobi (https://t.co/2lYUMtf8Tc) https://t.co/Uje0hhX234 Unknown 1 Hungarian 34 2017-08-15T14:43:00 2017-08-15T14:43:00 1525 1661 20970   0 0
320396 725000000000000000 BERLINBOTE 372 Gezeter um Ceta https://t.co/Jkj9KnJfZF Unknown 1 Hungarian 34 2017-09-20T22:34:00 2017-09-20T22:34:00 2224 1807 23366   0 0
379661 1685173321 BLMSOLDIER 418 President Buhari, Tunnel Vision and Optics, By Bámidélé Adémólá-Olátéjú https://t.co/iQQwkihlOi United States 2 Hungarian 34 2016-12-06T08:23:00 2016-12-06T08:23:00 701 700 2808 RETWEET 1 0 1
395310 1718000594 BOOTH_PRINCE 431 #PresentsTrumpGot Megyn Kelly United States 2 Hungarian 34 2016-06-15T14:55:00 2016-06-15T14:55:00 2803 2126 3990   1 0
415215 1868496344 BRIANAREGLAND 446 oh hell yes https://t.co/PBURFb6fXV United States 2 Hungarian 34 2016-10-17T04:29:00 2016-10-17T04:29:00 415 763 2490 RETWEET 1 0 1
478875 1627699074 CANNONSHER 498 14:04 Pink Yetti! http://t.co/eiJuauoFBa United States 2 Hungarian 34 2015-03-17T15:49:00 2015-03-17T15:49:00 0 65 175   0 0
487559 1627699074 CANNONSHER 498 Strategy? https://t.co/KHBJTwyRXy United States 2 Hungarian 34 2015-06-09T00:34:00 2015-06-09T00:34:00 0 137 6319 RETWEET 1 0 1
621392 2882350436 CHRIXMORGAN 571 George Soros #RejectedLegoMinifigures United States 2 Hungarian 34 2017-03-01T16:01:00 2017-03-01T16:01:00 10335 21067 18502 RETWEET 1 0 1
632706 2491401030 CLIFTONHUGHES_ 583 jódete ❤️ United States 2 Hungarian 34 2016-10-05T13:46:00 2016-10-05T13:48:00 900 957 1306 RETWEET 1 0 1
653784 1710804738 COOKNCOOKS 598 14:04 Pink Yetti! http://t.co/i7CoqthHTH United States 2 Hungarian 34 2015-02-08T14:05:00 2015-02-08T14:05:00 83 110 183   0 0
658071 1692501152 CORNELLBURCHET 599 He forgot!!!���� https://t.co/ZwBI28LbSS United States 2 Hungarian 34 2017-03-02T06:43:00 2017-03-02T06:44:00 704 767 3201 RETWEET 1 0 1
662096 743167000000000000 COVFEFENATIONUS 603 Benchmark #Obamacare plan premium hikes, 2014-18: TN 278% OK 209% NE 207% IA 182% AZ 158% UT 153% PA 138% AL 118% KS 116% IL 115% NC 111% United States 2 Hungarian 34 2017-11-11T07:27:00 2017-11-11T07:27:00 245 2117 143427 RETWEET 1 1 1
664840 743167000000000000 COVFEFENATIONUS 603 Yes yes yes. @SpeakerRyan @GOP @SenateMajLdr https://t.co/3U0xSRwdqD United States 2 Hungarian 34 2017-11-15T22:44:00 2017-11-15T22:45:00 246 2196 147378 RETWEET 1 1 1
665636 743167000000000000 COVFEFENATIONUS 603 Oh hell yes! #MAGA #BREAKING #AlFrankenResignNow #AlFranken #ResignAl https://t.co/F23RWOPcIo United States 2 Hungarian 34 2017-11-16T21:38:00 2017-11-16T21:38:00 248 2223 148037 RETWEET 1 1 1
698197 1668307436 CURTISBIGMAN 611 Ray Megalodonovan #FishTV @midnight United States 2 Hungarian 34 2016-09-22T08:16:00 2016-09-22T08:16:00 2966 2745 4797   0 0
704053 2548383456 C__WELLS 619 14:04 Pink Yetti! http://t.co/yBHbFoLfyY United States 2 Hungarian 34 2015-02-09T17:01:00 2015-02-09T17:02:00 140 21 184   0 0
707631 1657694515 DAILEYJADON 622 14:04 Pink Yetti! http://t.co/rnrPyRJYcZ United States 2 Hungarian 34 2015-03-16T12:23:00 2015-03-16T12:23:00 377 119 709   0 0
791132 1660804459 DAMANIMILES 633 '@RRYrevolucion Más info en @BDSGaliza @rumboagaza #SOSWomenFlotilla #SOSwomenToGaza #Flotilla' United States 2 Hungarian 34 2016-10-06T15:40:00 2016-10-06T15:41:00 590 856 1712 RETWEET 1 0 1
800865 2882037326 DANAGEEZUS 634 #ObamaNextJob HIV tester United States 2 Hungarian 34 2016-06-21T14:21:00 2016-06-21T14:21:00 15410 18503 8821 RETWEET 1 0 1
803251 2882037326 DANAGEEZUS 634 YES YES YES https://t.co/kcOqkptmTe United States 2 Hungarian 34 2016-08-24T14:13:00 2016-08-24T14:15:00 17190 20137 12066 QUOTE_TWEET 2 0 1
951105 892000000000000000 ELIZEESTR 819 RT ster2807: .JoseColinaP \| LISTA A INTERPOL \| PARTE 2 \| AGÁR…: https://t.co/dxfIYFXfpv United States 2 Hungarian 34 2017-08-15T06:19:00 2017-08-15T06:19:00 2914 501 10303   0 0
955140 892000000000000000 ELIZEESTR 819 RT megseff: Go Kelli Ward Go! https://t.co/Dw1jXw0a6b United States 2 Hungarian 34 2017-08-06T17:53:00 2017-08-06T17:53:00 1959 297 3642 QUOTE_TWEET 2 0 1
957060 892000000000000000 ELIZEESTR 819 RT megseff: Sad huh? https://t.co/GNQGOjNIlu United States 2 Hungarian 34 2017-08-09T00:32:00 2017-08-09T00:32:00 1924 351 5596 QUOTE_TWEET 2 0 1
957368 892000000000000000 ELIZEESTR 819 RT terrymendozer: Amén!!! https://t.co/fXrvn2EwlL United States 2 Hungarian 34 2017-08-09T04:27:00 2017-08-09T04:27:00 1923 354 5685 QUOTE_TWEET 2 0 1
971439 1676481360 EMILEEWAREN 830 1810-ben; A Napóleon Bonaparte házas proxy főhercegnő Marie Louise Ausztria. United States 2 Hungarian 34 2017-03-11T09:16:00 2017-03-11T09:16:00 1847 2081 5001 RETWEET 1 0 1
972264 1676481360 EMILEEWAREN 830 '@2017Soutiens @MLP_officiel @f_philippot @BaptisteLedoux @avec_marine @MarineElysee @fandetv @HenriIVlepieux @AvecMarine2017 @j21unis @rdinho3 https://t.co/JZ6PKF17xa RT . 300 sites autopostés sur @StopHaineux @AntiLeftistsFas @AntiLeftistFas1 .' United States 2 Hungarian 34 2017-04-17T09:22:00 2017-04-17T09:22:00 1835 2087 5738 RETWEET 1 0 1
992383 1662453998 ERRIVVVVERS 857 14:04 Pink Yetti! http://t.co/Bvvs8E9FyQ United States 2 Hungarian 34 2015-03-19T12:59:00 2015-03-19T12:59:00 309 92 284   0 0
1038361 3272640600 EXQUOTE 890 .@palmaprats841 palma @AudreyOCTW smelly @Phahle_K Legénd @Mehescs Méhes @sarah_crandall Sarah @AymanShamshad Ayman http://t.co/eBSTArF7tx United States 2 Hungarian 34 2015-08-15T19:59:00 2015-08-15T19:59:00 2 396 35530   1 0
1039324 3272640600 EXQUOTE 890 .@amir_fikri23 Amir @Accelerate22 ♚》ⓝⓔⓢⓣⓞⓡ《♚ @darlingbaeb szerethetetlen @nerdytomlinson Esraa @EJPFITNESS Elliot http://t.co/ARoJmDnM7Q United States 2 Hungarian 34 2015-08-16T10:51:00 2015-08-16T10:52:00 2 418 36483   1 0
1042352 3272640600 EXQUOTE 890 .@Ecrobinson15 Eli @DanDrusch Dan @_Reeyy Reycitó @frankkush13 Mark @toriwright82 tori @turkboyz20 TuRk http://t.co/bsMsabNHpf United States 2 Hungarian 34 2015-08-17T02:18:00 2015-08-17T02:18:00 2 441 37725   1 0
1042653 3272640600 EXQUOTE 890 .@xskinnydreamerx sad @Tstubbsxo Taylor @viannaposadas vip @DameVenus Meghan @Hello_DoctorSA HelloDoctor http://t.co/3My7JLhrQf United States 2 Hungarian 34 2015-08-17T07:16:00 2015-08-17T07:16:00 2 447 38026   1 0
1043745 3272640600 EXQUOTE 890 .@_idontKAYre Kémichelle? @_bella_ellaa Ella @Rayfuckinright RaeP @Verb5005 Ain't @melissa___renee mel @solared1 lil http://t.co/0Vj5vpGZoK United States 2 Hungarian 34 2015-08-18T01:41:00 2015-08-18T01:41:00 2 476 39449   1 0
1044355 3272640600 EXQUOTE 890 .@melissam129 mely @BOBBYpins_x MF @Antlersquid brynna @xQueenElisabeth Pretty @Caliboytatted42 Robert @mvgdalena v http://t.co/tYOXBjgXQK United States 2 Hungarian 34 2015-08-18T04:37:00 2015-08-18T04:37:00 2 481 39693   1 0
1044806 3272640600 EXQUOTE 890 .@thefabulousnerd cc @xnxnxthegreat Bert @snowlove123 MegaFan @1NUBIE_ Me @tanikacharles7 Tanika @FunSizeMela Me-luh http://t.co/bj9mOn8HQx United States 2 Hungarian 34 2015-08-19T14:00:00 2015-08-19T14:00:00 2 534 42126   1 0
1045054 3272640600 EXQUOTE 890 .@vernonmcwhite11 ? @mrskjfournier Mrs @megkilco Meg @PLarzKC Stevvey @ceeJongz #GPINVASION28AUG @Skoop23 Don http://t.co/YwgmHQ2h7u United States 2 Hungarian 34 2015-08-19T16:41:00 2015-08-19T16:41:00 2 544 42374   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 36.721ms · Data source: fivethirtyeight/russian-troll-tweets