home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

186 rows where language = 24

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
8388 3312143142 4MYSQUAD 10 '@tnyphotobooth @NewYorker @mjabdulaziz nice photo' United States 2 Czech 24 2015-08-27T12:22:00 2015-09-23T05:44:00 828 518 1124   0 0
9652 3312143142 4MYSQUAD 10 '@kellanlutz nice hat dude' United States 2 Czech 24 2015-09-26T00:20:00 2015-09-26T00:20:00 1501 715 3050   0 0
48508 2570250275 AIDEN7757 81 dude u rock http://t.co/3Ru6vwN6BY United States 2 Czech 24 2015-03-18T10:13:00 2015-03-18T10:13:00 260 31 677   0 0
117797 1679279490 AMELIEBALDWIN 146 El expresidente #iraní Mahmud #Ahmadinejad registra para las elecciones presidenciales #انتخوابات… https://t.co/bByNxN2U6w United States 2 Czech 24 2017-04-12T07:47:00 2017-04-12T07:48:00 2295 2790 36481 RETWEET 1 0 1
214042 1671936266 ARM_2_ALAN 269 Nice photo! https://t.co/lhYPsyAuWT United States 2 Czech 24 2015-06-11T20:13:00 2015-06-11T20:13:00 66 167 8631 RETWEET 1 0 1
269576 1658420976 BAOBAEHAM 326 Rafika wavy fro doll - $60.00 #blacktwitter #BlackOwnedStores https://t.co/0qOYlRQbNM https://t.co/HzVzU81zkj United States 2 Czech 24 2017-04-02T14:15:00 2017-04-02T14:16:00 811 1099 5671 RETWEET 1 0 1
328181 2732675512 BGARNER2107 384 #OneLetterOffSports Mace ball United States 2 Czech 24 2016-09-09T08:41:00 2016-09-09T08:41:00 1649 1856 3331   0 0
345465 3255856080 BIZGOD 393 http://t.co/JcNxU6UMPE Eu sou FITNESS @tabithaconley @IanMolloy82 @LoisKeat @c1aranc @rajieboy05 @NjtheSeth @nancywelker @_bearari United States 2 Czech 24 2015-07-05T16:16:00 2015-07-05T16:16:00 3 121 8496   1 0
352242 3978316814 BLACKMATTERSUS 400 '@deray I apologize' Unknown 1 Czech 24 2016-01-05T19:46:00 2016-01-05T19:46:00 4534 3027 776   0 0
362792 4840551713 BLACKTOLIVE 406 Nice try, nice try... #PoliceBrutality https://t.co/nrn14yTH6h United States 2 Czech 24 2017-04-29T07:29:00 2017-04-29T07:49:00 12610 24294 4902   0 0
376616 1687183549 BLEEPTHEPOLICE 415 Psychological Warfare https://t.co/evVAM1Pckq United States 2 Czech 24 2016-09-22T18:18:00 2016-09-22T18:18:00 5009 11677 13273 RETWEET 1 0 1
395789 1718000594 BOOTH_PRINCE 431 #INeedALawyerBecause I stole WIFI United States 2 Czech 24 2016-06-20T13:50:00 2016-06-20T13:51:00 3063 2194 4469 RETWEET 1 1 1
397289 1718000594 BOOTH_PRINCE 431 #IHatePokemonGoBecause it's devil's hanky-panky United States 2 Czech 24 2016-07-30T14:23:00 2016-07-30T14:24:00 4373 2914 5451   1 0
399253 1718000594 BOOTH_PRINCE 431 #igetdepressedwhen my slaves are so brazen United States 2 Czech 24 2016-08-31T14:30:00 2016-08-31T14:30:00 4085 3404 7980   1 0
419883 1868496344 BRIANAREGLAND 446 #blackhistorymonth emoji too nice #AmericanHistoryIsBlack United States 2 Czech 24 2016-02-02T13:16:00 2016-02-02T13:16:00 400 204 666   0 0
419892 1868496344 BRIANAREGLAND 446 Rafika wavy fro doll - $60.00 #blacktwitter #BlackOwnedStores https://t.co/Tqiq12YxWB https://t.co/mPRS6ElWpv United States 2 Czech 24 2016-02-25T08:14:00 2016-02-25T08:14:00 400 210 766   0 0
444329 2532597577 BRUCIEDUBLIN 464 #ThingsThatYouCouldLearnFromMe squirrel psychology United States 2 Czech 24 2015-05-11T14:24:00 2015-05-11T14:24:00 115 135 674 RETWEET 1 0 1
444469 2532597577 BRUCIEDUBLIN 464 #INeedALawyerBecause I stole WIFI United States 2 Czech 24 2016-06-20T13:50:00 2016-06-20T13:50:00 1335 631 1006   0 0
447296 2670490950 BYDRBRE 472 '@realDonaldTrump 36%??? - Very nice' Unknown 1 Czech 24 2015-10-27T14:44:00 2015-10-27T14:44:00 2887 28451 11540   0 0
471581 1681162956 CAMOSASEKO 494 Nice try pal. https://t.co/zGHfFmwufs United States 2 Czech 24 2017-04-03T17:30:00 2017-04-03T17:30:00 2225 2529 11827 RETWEET 1 0 1
483341 1627699074 CANNONSHER 498 . @neiltyson Haha... Nice try sap ... United States 2 Czech 24 2015-06-03T03:12:00 2015-06-03T03:13:00 0 80 1186 RETWEET 1 0 1
500101 2742482932 CASCASEYP 508 nice try lol https://t.co/Uc5U3EAGF7 United States 2 Czech 24 2015-02-08T14:35:00 2015-02-08T14:35:00 150 14 512   0 0
500346 2742482932 CASCASEYP 508 nice try lol https://t.co/Uc5U3EAGF7 United States 2 Czech 24 2015-03-18T07:53:00 2015-03-18T07:53:00 362 76 996   0 0
506794 1629828379 CASSISHERE 512 nice try lol https://t.co/XCdLoqY5DW United States 2 Czech 24 2015-01-12T08:44:00 2015-01-12T08:44:00 260 165 143   0 0
561818 1877492857 CHESPLAYSCHESS 547 ya @FreeBeacon, nice try https://t.co/8Hcny6TAJN United States 2 Czech 24 2015-06-02T19:33:00 2015-06-02T19:33:00 74 81 677 RETWEET 1 0 1
564415 1877492857 CHESPLAYSCHESS 547 Republicans are Psychopaths. https://t.co/0OBaO2jIcD United States 2 Czech 24 2015-06-05T17:30:00 2015-06-05T17:30:00 74 149 3394 RETWEET 1 0 1
621388 2882350436 CHRIXMORGAN 571 #RejectedLegoMinifigures Lego South Park https://t.co/zt2NCrizf9 United States 2 Czech 24 2017-03-01T15:57:00 2017-03-01T15:57:00 10335 21068 18494 RETWEET 1 0 1
622456 2882350436 CHRIXMORGAN 571 Let's rock!!! United States 2 Czech 24 2015-04-25T08:50:00 2015-04-25T08:51:00 1459 684 698   0 0
631461 1626302035 CLAYPAIGEBOO 580 PSYCHO BABBLE TAKE 2 #RELEASEDATE2014 #LATLY #grindhard https://t.co/OA0oLZLQie United States 2 Czech 24 2016-10-07T02:11:00 2016-10-07T02:11:00 776 922 1678 RETWEET 1 0 1
635368 1659378644 CLYDEDAWS0N 584 '@Clever_Dove @Rickagain @BlkLightDisco haha nice!' United States 2 Czech 24 2015-08-20T16:40:00 2015-08-20T16:40:00 643 243 1122   0 0
655373 1710804738 COOKNCOOKS 598 Yemení se declara culpable de atentados como miembro de Al QaedA #noticias United States 2 Czech 24 2015-05-27T01:51:00 2015-05-27T01:51:00 28 110 632 RETWEET 1 0 1
668902 743167000000000000 COVFEFENATIONUS 603 Psychopathic guru... https://t.co/eqM3kC5EcD United States 2 Czech 24 2017-11-20T07:06:00 2017-11-20T07:06:00 248 2385 150896 RETWEET 1 1 1
678093 743167000000000000 COVFEFENATIONUS 603 '@JackPosobiec Psycho Joe #MorningJoe https://t.co/5g27tqpL6D' United States 2 Czech 24 2017-12-02T05:52:00 2017-12-02T05:52:00 245 2546 158603 RETWEET 1 1 1
685402 4437233895 CRYSTAL1JOHNSON 606 "Nice van, must've stolen it" https://t.co/ZlIXAEpPEO United States 2 Czech 24 2016-10-13T20:00:00 2016-10-13T20:17:00 16268 17830 2258   0 0
690549 4437233895 CRYSTAL1JOHNSON 606 Dat glance❤ https://t.co/CAm4vP6xid United States 2 Czech 24 2017-06-02T20:41:00 2017-06-02T20:45:00 30262 43138 6310   0 0
695826 1668307436 CURTISBIGMAN 611 Very niiiiice! http://t.co/lMQ7X51LDM United States 2 Czech 24 2015-03-16T13:03:00 2015-03-16T13:03:00 410 120 1042   0 0
696976 1668307436 CURTISBIGMAN 611 #IHatePokemonGoBecause it's devil's hanky-panky United States 2 Czech 24 2016-07-30T15:48:00 2016-07-30T15:48:00 3418 1998 3096 RETWEET 1 0 1
704075 2548383456 C__WELLS 619 Very niiiiice! http://t.co/z0mZIVO2JW United States 2 Czech 24 2015-02-09T17:17:00 2015-02-09T17:17:00 140 21 205   0 0
705878 1657694515 DAILEYJADON 622 Voi Vodka #DrunkBands @midnight United States 2 Czech 24 2017-01-26T10:39:00 2017-01-26T10:39:00 3153 3366 4261   0 0
796867 2882037326 DANAGEEZUS 634 #ThereIsNoSexyWayTo dance gangnam style United States 2 Czech 24 2015-04-12T07:34:00 2015-04-12T07:34:00 1035 1034 481   0 0
797924 2882037326 DANAGEEZUS 634 #IAmNotThePresidentBecause I'm psycho. Really https://t.co/zEVzF00yAg United States 2 Czech 24 2016-04-06T14:09:00 2016-04-06T14:09:00 9792 16084 4806   0 0
801035 2882037326 DANAGEEZUS 634 106th & Park host #ObamaNextJob United States 2 Czech 24 2016-06-21T15:33:00 2016-06-21T15:33:00 15407 18494 9017 RETWEET 1 0 1
802329 2882037326 DANAGEEZUS 634 #IHatePokemonGoBecause it's devil's hanky-panky United States 2 Czech 24 2016-07-30T14:24:00 2016-07-30T14:26:00 18107 19363 10067 RETWEET 1 0 1
854859 2577152109 DENN_NIKITIN 690 ���very nice ! https://t.co/GV1LuK8PGb Unknown 1 Czech 24 2016-11-27T03:59:00 2016-11-27T03:59:00 69 94 2676 RETWEET 1 0 1
889628 2573225349 DOMINICVALENT 734 Very niiiiice! http://t.co/LSYEdLwiD1 United States 2 Czech 24 2015-03-16T11:52:00 2015-03-16T11:52:00 357 63 480   0 0
889701 2573225349 DOMINICVALENT 734 dude u rock http://t.co/jdqUmJkOp5 United States 2 Czech 24 2015-03-16T12:21:00 2015-03-16T12:21:00 357 63 583   0 0
983868 2540611879 ERICARUTTER 846 Vodka vodka vodka vodka #My4WordNewYearsResolution Unknown 1 Czech 24 2016-12-21T14:19:00 2016-12-21T14:19:00 2393 1231 1147   0 0
984648 2540611879 ERICARUTTER 846 haha very very very nice!!!! https://t.co/j8qdSj0XGh Unknown 1 Czech 24 2015-03-16T14:35:00 2015-03-16T14:35:00 325 105 1333   0 0
1039129 3272640600 EXQUOTE 890 .@Zama__ It'sTooEasy @CuddleofDeath Kristen @julie_syson Juel @zpravycz Zprávy @Swhittingstall Steven @MattKison Matt http://t.co/JunAJkWuN5 United States 2 Czech 24 2015-08-15T08:01:00 2015-08-15T08:01:00 2 378 34621   1 0
1043937 3272640600 EXQUOTE 890 .@NadiaOfficial Nadia @AMcNeeseMechan Amy @hugolord64 Hugo @ashleighhey ashleigh @__JByrd Naní @shelby_gw13 shelby http://t.co/u7EougL7RY United States 2 Czech 24 2015-08-18T21:44:00 2015-08-18T21:44:00 2 520 40745   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 56.229ms · Data source: fivethirtyeight/russian-troll-tweets