home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

260 rows where language = 28

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
9305 3312143142 4MYSQUAD 10 '@nickjonas @iHeartRadio Sup, Nickeeeeeeey' United States 2 Slovak 28 2015-09-19T01:51:00 2015-09-19T01:52:00 1451 615 2612   0 0
15594 2534421182 ABIGAILSSILK 28 Motorola Bravo Pager #SecondHandGifts United States 2 Slovak 28 2016-12-21T18:37:00 2016-12-21T18:37:00 1653 1459 1922 RETWEET 1 0 1
21385 1652138929 ACEJINEV 38 #NP: @djsyonkream - @INSOMNIACJEEZ - INSOMNIAC MOB #ListenLIVE - https://t.co/tEPugxWvjk United States 2 Slovak 28 2016-12-26T18:16:00 2016-12-26T18:16:00 793 906 3100 RETWEET 1 0 1
27727 1704035413 ADDIE_HOL 45 sad story � http://t.co/dMmoSBk8hg United States 2 Slovak 28 2015-05-25T12:11:00 2015-05-25T12:11:00 82 54 331   0 0
38354 1657833811 ADRIENNE_GG 57 sad story � http://t.co/lNxIH3IoJf United States 2 Slovak 28 2015-03-13T09:45:00 2015-03-13T09:45:00 149 142 535   0 0
47657 2570250275 AIDEN7757 81 Motorola Bravo Pager #SecondHandGifts United States 2 Slovak 28 2016-12-21T16:21:00 2016-12-21T16:22:00 2677 2611 3203 RETWEET 1 0 1
48548 2570250275 AIDEN7757 81 Nice quote! United States 2 Slovak 28 2015-03-18T09:47:00 2015-03-18T09:47:00 260 30 615   0 0
88715 2616344667 AMANDAVGREEN 138 #ThingsIYellWhenICum Mazel Tov!!! United States 2 Slovak 28 2016-05-16T08:57:00 2016-05-16T08:58:00 1550 1481 2026 RETWEET 1 0 1
122413 1679279490 AMELIEBALDWIN 146 '@Clever_Dove ��Haha! Sex slave!' United States 2 Slovak 28 2015-08-14T07:29:00 2015-08-14T07:29:00 492 373 1635   0 0
127136 1679279490 AMELIEBALDWIN 146 ChristiChat: RT ChristiChat: #NYCExplosion https://t.co/2uPDJEe4Ty United States 2 Slovak 28 2016-09-18T02:48:00 2016-09-18T02:57:00 1479 2171 7365 RETWEET 1 0 1
213127 1671936266 ARM_2_ALAN 269 '@N_Fatale picky picky!!!!!' United States 2 Slovak 28 2015-06-10T01:53:00 2015-06-10T01:54:00 68 158 7037 RETWEET 1 0 1
313902 725000000000000000 BERLINBOTE 372 Svetislav Pesic hört bei... https://t.co/tF5kpwuGGa Unknown 1 Slovak 28 2016-07-24T10:21:00 2016-07-24T10:21:00 0 5 4687   0 0
323920 2732675512 BGARNER2107 384 Nice quote! United States 2 Slovak 28 2015-01-20T10:50:00 2015-01-20T10:50:00 144 8 786   0 0
324408 2732675512 BGARNER2107 384 PINK LADY http://t.co/qJKeqwDMaF United States 2 Slovak 28 2015-01-26T00:23:00 2015-01-26T00:23:00 142 17 997   0 0
344815 3255856080 BIZGOD 393 Yessss I love a diet buddy. @AliveIsAwesome @Rawritz @ILoveMyIndiaa @GujaratiDhokla @letsdotweet @FollowMyHandle http://t.co/uO8XOOi8dG United States 2 Slovak 28 2015-07-04T16:16:00 2015-07-04T16:16:00 3 108 7766   1 0
377768 1685173321 BLMSOLDIER 418 #NP via @RadioKingzRadio Da Brat - Funkdafied #ListenLive:https://t.co/0yHdZiq3Zg United States 2 Slovak 28 2017-01-23T22:37:00 2017-01-23T22:39:00 696 708 3911 RETWEET 1 0 1
478745 1627699074 CANNONSHER 498 "Maniac" by Jhené Aiko is ... yep United States 2 Slovak 28 2017-02-09T09:41:00 2017-02-09T09:41:00 2446 2787 11778 RETWEET 1 0 1
480039 1627699074 CANNONSHER 498 I love platypus! https://t.co/Mo8y2iZY3j United States 2 Slovak 28 2015-05-28T18:51:00 2015-05-28T18:51:00 0 66 434 RETWEET 1 0 1
500330 2742482932 CASCASEYP 508 PINK LADY http://t.co/q0bmP7HoDZ United States 2 Slovak 28 2015-03-18T07:47:00 2015-03-18T07:47:00 362 76 978   0 0
500460 2742482932 CASCASEYP 508 Toro! Toro! Toro! #JapanAMovie @midnight United Kingdom 9 Slovak 28 2017-03-30T09:25:00 2017-03-30T09:25:00 4494 5373 4217   0 0
501511 2742482932 CASCASEYP 508 #IStartCryingWhen I'm sober United States 2 Slovak 28 2016-08-08T14:16:00 2016-08-08T14:16:00 326 528 1619   0 0
508704 1629828379 CASSISHERE 512 PINK LADY http://t.co/yl6citux7v United States 2 Slovak 28 2015-02-21T12:25:00 2015-02-21T12:25:00 210 225 297   0 0
608209 733000000000000000 CHRISUPORT_PORT 566 Sklave Sklave Sklave Sklave Sklave Sklave Tierarzt #firstsevenjobs https://t.co/hQ1m6YbSE1 Germany 13 Slovak 28 2016-08-06T08:40:00 2016-08-06T08:40:00 3832 3410 880   0 0
610238 1683408074 CHRIXCHASE 570 Motorola Bravo Pager #SecondHandGifts United States 2 Slovak 28 2016-12-21T15:59:00 2016-12-21T15:59:00 1879 2769 3277 RETWEET 1 1 1
612395 2882350436 CHRIXMORGAN 571 #ImProtestingBecause I'm sober United States 2 Slovak 28 2016-01-17T16:22:00 2016-01-17T16:22:00 6410 12489 2426   0 0
614468 2882350436 CHRIXMORGAN 571 I love Nickelback. ❤️ #MakeMeHateYouInOnePhrase https://t.co/eQGVQhj34E United States 2 Slovak 28 2016-10-17T13:15:00 2016-10-17T13:15:00 9535 17845 9502 RETWEET 1 0 1
694332 1668307436 CURTISBIGMAN 611 I love Nickelback. ❤️ #MakeMeHateYouInOnePhrase https://t.co/eQGVQhj34E United States 2 Slovak 28 2016-10-17T17:43:00 2016-10-17T17:43:00 2118 2978 5204 RETWEET 1 0 1
696279 1668307436 CURTISBIGMAN 611 #ThingsIYellWhenICum Mazel Tov!!! United States 2 Slovak 28 2016-05-16T08:21:00 2016-05-16T08:21:00 1807 1596 2332 RETWEET 1 0 1
696891 1668307436 CURTISBIGMAN 611 #IHatePokemonGoBecause i love alcohol United States 2 Slovak 28 2016-07-30T15:33:00 2016-07-30T15:33:00 3415 1995 2976 RETWEET 1 0 1
797822 2882037326 DANAGEEZUS 634 Hodor. Hodor. Hodor. Hodor. Hodor. #5WordFilmPlots United States 2 Slovak 28 2015-04-30T13:58:00 2015-04-30T13:59:00 1279 7106 853   0 0
798392 2882037326 DANAGEEZUS 634 Mysticky Icky River #AddPotInAMovie https://t.co/hkTOvGvA1V United States 2 Slovak 28 2016-05-11T14:18:00 2016-05-11T14:18:00 12229 17379 6695 RETWEET 1 0 1
799170 2882037326 DANAGEEZUS 634 I love platypus! https://t.co/Mo8y2iZY3j United States 2 Slovak 28 2015-05-28T18:17:00 2015-05-28T18:17:00 3509 8182 1322   0 0
800010 2882037326 DANAGEEZUS 634 Danky Duck #weedcartoons @midnight United States 2 Slovak 28 2015-06-11T08:34:00 2015-06-11T08:34:00 3195 8659 1513   0 0
804201 2882037326 DANAGEEZUS 634 #IStartCryingWhen I am sober United States 2 Slovak 28 2016-08-08T13:13:00 2016-08-08T13:13:00 17703 19629 11194 RETWEET 1 0 1
804304 2882037326 DANAGEEZUS 634 #IStartCryingWhen I'm sober United States 2 Slovak 28 2016-08-08T13:28:00 2016-08-08T13:30:00 17703 19623 11332 RETWEET 1 0 1
830645 1684524144 DATWISENIGGA 663 RT @patdefranchis: RT @patdefranchis: #art by Ekaterina Moré @Choco_Sandy1 @oadele53 @dyakomard @monicasloves @fryld https://t.co/zwxODVAGiK United States 2 Slovak 28 2017-05-03T04:52:00 2017-05-03T04:52:00 795 938 6244   0 0
880486 2598367019 DICKYIRWIN 707 #ThingsIYellWhenICum Mazel Tov!!! United States 2 Slovak 28 2016-05-16T08:52:00 2016-05-16T08:53:00 1744 1407 1564 RETWEET 1 0 1
887951 2573225349 DOMINICVALENT 734 I love Nickelback. ❤️ #MakeMeHateYouInOnePhrase https://t.co/eQGVQhj34E United States 2 Slovak 28 2016-10-17T14:19:00 2016-10-17T14:19:00 2294 3586 4104 RETWEET 1 0 1
889426 2573225349 DOMINICVALENT 734 #IdRunForPresidentIf I hated myself United States 2 Slovak 28 2016-12-07T15:34:00 2016-12-07T15:34:00 3750 4645 5148   0 0
890139 2573225349 DOMINICVALENT 734 #ThingsIYellWhenICum Mazel Tov!!! United States 2 Slovak 28 2016-05-16T08:01:00 2016-05-16T08:01:00 1916 2006 1914 RETWEET 1 0 1
890562 2573225349 DOMINICVALENT 734 Lisey's Stove #MakeABookWarm @StephenKing United States 2 Slovak 28 2017-07-14T10:13:00 2017-07-14T10:13:00 4182 5034 5691   0 0
911392 804000000000000000 DRESDENBOTE 756 Schönen #Freitag, #Dresden! Instagram photo via René Wojciechowski (https://t.co/YE5hDhIjbQ) https://t.co/E0TyGAB5ky United States 2 Slovak 28 2017-09-08T13:08:00 2017-09-08T13:09:00 2033 1113 3300   0 0
949951 892000000000000000 ELIZEESTR 819 RT LMDavens: Very very sad https://t.co/qKR7G93tWk United States 2 Slovak 28 2017-08-14T14:33:00 2017-08-14T14:33:00 1920 471 9585 QUOTE_TWEET 2 0 1
971223 1676481360 EMILEEWAREN 830 HOTEL TRANSYLVANIA 2 #hoteltransylvania2 #Now #madewithunity #videogame #apk #Android #giveaway #Hacked https://t.co/iOKMlRn9wU United States 2 Slovak 28 2017-02-04T13:31:00 2017-02-04T13:32:00 1857 2067 4373 RETWEET 1 0 1
1037403 3272640600 EXQUOTE 890 .@cervantess9 Erick @kuhkuhkatie Katie @DestinyDuhhh Destiny @WineIsBae Ayeesha @TravantiQuinn Travanti http://t.co/BAoeXzFlpj United States 2 Slovak 28 2015-08-14T23:01:00 2015-08-14T23:02:00 2 373 33987   1 0
1037470 3272640600 EXQUOTE 890 .@dennis_maxey dennis @BriggsLawana #Lawana @Walt_CEO_Watts Walt @Hawthorn_george Patrick @beautyfrominme GabbyMay17! http://t.co/IB1Is4x1bV United States 2 Slovak 28 2015-08-14T23:49:00 2015-08-14T23:49:00 2 372 34054   1 0
1037530 3272640600 EXQUOTE 890 .@aliviaann_ Liv @RaddOTF ↪ @colby_orr colby @anikfong Anik @mbsugden Mike @Gorhamabama Zachary @PJFly1883 Patrick http://t.co/VVLOePeqhH United States 2 Slovak 28 2015-08-15T00:36:00 2015-08-15T00:36:00 2 374 34113   1 0
1037960 3272640600 EXQUOTE 890 .@Sohaila01 JoEllen @Makailwilson_ Makaila @bennicknick Nick @healthfullylean Robin @RadaTanasijevic Rada http://t.co/KG3ekQ6bHw United States 2 Slovak 28 2015-08-15T15:36:00 2015-08-15T15:36:00 2 388 35131   1 0
1038083 3272640600 EXQUOTE 890 .@GalindoSabo GalindoSabo @Princesscammy1 Princess @chancealexia19 prom @kindlybassist maike @SisiphoKulati SK http://t.co/hRoNUY8h5d United States 2 Slovak 28 2015-08-15T16:55:00 2015-08-15T16:55:00 2 388 35252   1 0
1038830 3272640600 EXQUOTE 890 .@CindyChandter CindyChandter @Silentpoet Ty @accrues zariah @ericamorgann_ Erica @chloetemple_ chloe http://t.co/Krly9z3PFv United States 2 Slovak 28 2015-08-15T03:31:00 2015-08-15T03:31:00 2 375 34322   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 24.788ms · Data source: fivethirtyeight/russian-troll-tweets