home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

990 rows where language = 15

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
3078 839000000000000000 1LORENAFAVA1 5 Blitz contro la #ndrangheta in #Calabria, coinvolta la cosca #Pesce https://t.co/P5tGVBdj5A Italy 3 Vietnamese 15 2017-04-04T07:54:00 2017-04-04T07:54:00 409 89 1813 RETWEET 1 0 1
8061 3312143142 4MYSQUAD 10 #WUTANG SO TRUE THOOOOO #Follow #FollowMeIfYoureBlack http://t.co/yTwb3OqaFa United States 2 Vietnamese 15 2015-08-23T23:30:00 2015-08-23T23:30:00 1725 404 681   0 0
8819 3312143142 4MYSQUAD 10 '@StevenHilleard @lilyallen wow so cute' United States 2 Vietnamese 15 2015-08-31T12:19:00 2015-08-31T12:19:00 1314 560 1712   0 0
11246 714000000000000000 666STEVEROGERS 13 I hate when GIRLS die Unknown 1 Vietnamese 15 2017-09-06T18:56:00 2017-09-06T18:56:00 133 10 148 RETWEET 1 0 1
13371 1709314117 AANTIRACIST 20 Lmaoooo Tommy tho! https://t.co/36WtN24fNw United States 2 Vietnamese 15 2016-10-06T16:09:00 2016-10-06T16:09:00 997 1053 1739 RETWEET 1 0 1
13494 1709314117 AANTIRACIST 20 Watch DDark Ft FlirtaD & Krucial - Not My Cousin Official Music Video https://t.co/r7KW5mlSiO United States 2 Vietnamese 15 2016-10-07T00:04:00 2016-10-07T00:04:00 997 1060 1882 RETWEET 1 0 1
18448 4104541313 ACAB_ZONE 36 ACAB Girls https://t.co/QnWHJGQMf3 United States 2 Vietnamese 15 2015-12-16T18:23:00 2015-12-16T18:23:00 3625 646 162   0 0
18449 4104541313 ACAB_ZONE 36 A.C.A.B. girls https://t.co/nRKvSYWfms United States 2 Vietnamese 15 2015-12-16T18:25:00 2015-12-16T18:25:00 3625 646 162   0 0
19215 1652138929 ACEJINEV 38 Desiigner - Panda DDark Remix (Official Music Video) https://t.co/I9E9lsLNut United States 2 Vietnamese 15 2017-01-01T07:01:00 2017-01-01T07:01:00 792 901 3258 RETWEET 1 0 1
19415 1652138929 ACEJINEV 38 DDark - Man Of The Century (Dark Horse 3) https://t.co/N8ME8o2q4M United States 2 Vietnamese 15 2017-01-17T11:20:00 2017-01-17T11:20:00 790 905 3660 RETWEET 1 0 1
19532 1652138929 ACEJINEV 38 Joe Biden tho ��� https://t.co/8DivpLYxxM United States 2 Vietnamese 15 2017-01-20T05:35:00 2017-01-20T05:35:00 790 907 3736 RETWEET 1 0 1
19573 1652138929 ACEJINEV 38 DDark - Mad https://t.co/FE1ozT3ICS United States 2 Vietnamese 15 2017-01-23T06:03:00 2017-01-23T06:03:00 790 902 3811 RETWEET 1 0 1
19838 1652138929 ACEJINEV 38 DDark - All Day Everyday Official Video https://t.co/dEREaQ7dre United States 2 Vietnamese 15 2017-01-06T01:55:00 2017-01-06T01:55:00 792 909 3374 RETWEET 1 0 1
19905 1652138929 ACEJINEV 38 DDark - Making the track https://t.co/mp2KPIznkf United States 2 Vietnamese 15 2017-01-07T08:06:00 2017-01-07T08:06:00 791 906 3422 RETWEET 1 0 1
20009 1652138929 ACEJINEV 38 Watch DDark Ft FlirtaD & Krucial - Not My Cousin Official Music Video https://t.co/cMQYLRwVTo United States 2 Vietnamese 15 2016-10-13T12:06:00 2016-10-13T12:06:00 809 891 1483 RETWEET 1 0 1
20024 1652138929 ACEJINEV 38 DDark - Boom (Dark Horse 3) https://t.co/ThzchwkQ8q United States 2 Vietnamese 15 2016-10-14T00:07:00 2016-10-14T00:07:00 809 895 1495 RETWEET 1 0 1
20177 1652138929 ACEJINEV 38 I'm saying tho � https://t.co/onIfkoPsoR United States 2 Vietnamese 15 2016-10-21T06:37:00 2016-10-21T06:37:00 806 895 1649 RETWEET 1 0 1
20343 1652138929 ACEJINEV 38 DDark - Free Bags Official Music Video https://t.co/b7BE8gDJ4P United States 2 Vietnamese 15 2016-10-30T07:44:00 2016-10-30T07:44:00 805 904 1836 RETWEET 1 0 1
20412 1652138929 ACEJINEV 38 DDark - Lake Days 2016 Official Video https://t.co/dzkPrSjITM United States 2 Vietnamese 15 2016-10-08T11:42:00 2016-10-08T11:42:00 808 896 1380 RETWEET 1 0 1
20537 1652138929 ACEJINEV 38 Watch DDark Ft Nutty P - Fly Away (Official Music Video) https://t.co/fcttAvg9J2 United States 2 Vietnamese 15 2016-11-13T09:36:00 2016-11-13T09:36:00 801 903 2108 RETWEET 1 0 1
20644 1652138929 ACEJINEV 38 DDark - Free Bags Official Music Video https://t.co/JcCWumZr3I United States 2 Vietnamese 15 2016-11-17T10:13:00 2016-11-17T10:13:00 798 900 2242 RETWEET 1 0 1
20661 1652138929 ACEJINEV 38 DDark - All Day Everyday Official Video https://t.co/ixbnJlU3cd United States 2 Vietnamese 15 2016-11-18T16:31:00 2016-11-18T16:31:00 799 899 2270 RETWEET 1 0 1
20799 1652138929 ACEJINEV 38 DDark - Dark Horse 3 Mixtape out now Itunes https://t.co/Z9m9pDZA5r United States 2 Vietnamese 15 2016-11-25T11:43:00 2016-11-25T11:43:00 797 894 2398 RETWEET 1 0 1
20946 1652138929 ACEJINEV 38 DDark - DarkHorse 2 Mixtape Out On Itunes https://t.co/FFc0qW8zuD #DarkHorse2 United States 2 Vietnamese 15 2016-11-04T20:29:00 2016-11-04T20:29:00 805 898 1938 RETWEET 1 0 1
20963 1652138929 ACEJINEV 38 Stream DDARK DARK HORSE 2 MIXTAPE https://t.co/mysJZAUG4m United States 2 Vietnamese 15 2016-11-05T20:38:00 2016-11-05T20:38:00 805 897 1951 RETWEET 1 0 1
21112 1652138929 ACEJINEV 38 C/O Teddie Cain - Dope #Music https://t.co/uinFnOwPwQ via @YouTube @TeddieCainJr #Listen United States 2 Vietnamese 15 2016-12-12T22:08:00 2016-12-12T22:08:00 797 896 2810 RETWEET 1 0 1
21115 1652138929 ACEJINEV 38 DDark - All Day Everyday Official Video https://t.co/r1FxYAwwmj United States 2 Vietnamese 15 2016-12-13T16:15:00 2016-12-13T16:16:00 797 896 2824 RETWEET 1 0 1
21350 1652138929 ACEJINEV 38 DDark - On A Mission (Music Video) https://t.co/Bf2XXQpeAt United States 2 Vietnamese 15 2016-12-24T05:50:00 2016-12-24T05:50:00 793 906 3036 RETWEET 1 0 1
24057 1652138929 ACEJINEV 38 😂😩 love bette & joan tho 🖤🙏🏾 https://t.co/TK0JjZpk3L United States 2 Vietnamese 15 2017-04-06T23:05:00 2017-04-06T23:05:00 784 916 5657 RETWEET 1 0 1
24561 1652138929 ACEJINEV 38 SO DAMN TRUE https://t.co/a76Z1Xmlz1 United States 2 Vietnamese 15 2017-07-10T08:58:00 2017-07-10T08:58:00 779 905 6536 RETWEET 1 0 1
25396 1652138929 ACEJINEV 38 [Mixtape] Co-Signed & Plugged 8 :: #GetItLIVE! https://t.co/vQWviH7IPB @LiveMixtapes @TheRealDJDuce @DigitalPlugg @Bill_Thousand United States 2 Vietnamese 15 2017-08-08T17:32:00 2017-08-08T17:32:00 775 907 7235 RETWEET 1 0 1
25949 1670762347 ADAMCHAPMANJR 42 DDark Ft Flirta D & Krucial - Not My Cousin Official Audio https://t.co/fLPdE83Nku #DarkHorse2 United States 2 Vietnamese 15 2016-10-06T21:31:00 2016-10-06T21:32:00 582 940 1938 RETWEET 1 0 1
26092 1670762347 ADAMCHAPMANJR 42 DDark X Nytz - Time runs out (Acceleration EP) Audio https://t.co/QmeGcZhiqM United States 2 Vietnamese 15 2016-10-07T00:20:00 2016-10-07T00:21:00 582 943 2109 RETWEET 1 0 1
26163 1670762347 ADAMCHAPMANJR 42 DDark Ft Allstars - Mission Riddim X Official Video (Bang) https://t.co/4YGoOiIgBQ?gpceV United States 2 Vietnamese 15 2016-10-07T02:49:00 2016-10-07T02:49:00 582 944 2192 RETWEET 1 0 1
26186 1670762347 ADAMCHAPMANJR 42 DDark - On A Mission (Music Video) https://t.co/Q6Hg5gnlGk United States 2 Vietnamese 15 2016-10-07T03:21:00 2016-10-07T03:21:00 582 945 2220 RETWEET 1 0 1
26192 1670762347 ADAMCHAPMANJR 42 FREE ALBUM @DeUceDouble #BeautifulStruggle https://t.co/Mz52fvs3fk United States 2 Vietnamese 15 2016-10-07T03:55:00 2016-10-07T03:55:00 582 945 2227 RETWEET 1 0 1
26216 1670762347 ADAMCHAPMANJR 42 DDark - On A Mission (Music Video) https://t.co/60G30OmFS3 United States 2 Vietnamese 15 2016-10-07T04:22:00 2016-10-07T04:22:00 582 945 2263 RETWEET 1 0 1
26246 1670762347 ADAMCHAPMANJR 42 DDark - Time of Day (Official Video) https://t.co/QB1ggIttrs United States 2 Vietnamese 15 2016-10-07T07:30:00 2016-10-07T07:31:00 582 949 2293 RETWEET 1 0 1
57968 3083086600 ALDRICH420 90 SO BIO-WOKE https://t.co/gBWOmZfU87 United States 2 Vietnamese 15 2017-03-21T01:44:00 2017-03-21T01:44:00 1635 1504 2952 RETWEET 1 0 1
61434 1652987412 ALECMOOOOODY 91 It's a secret! Nice try tho � #MySecretSkill United States 2 Vietnamese 15 2016-10-07T03:49:00 2016-10-07T03:49:00 529 908 2502 RETWEET 1 0 1
61743 1652987412 ALECMOOOOODY 91 E be ke eng engwe e nka e shebang ha ho le tje?! United States 2 Vietnamese 15 2016-10-08T19:03:00 2016-10-08T19:04:00 529 921 2906 RETWEET 1 0 1
65211 1652987412 ALECMOOOOODY 91 Ahh so proud! https://t.co/FC2tUEfysB United States 2 Vietnamese 15 2017-04-13T14:46:00 2017-04-13T14:46:00 516 908 8753 RETWEET 1 0 1
66609 1652987412 ALECMOOOOODY 91 .@dedd_thoo - Dedd Tho - Tragic - Houston - https://t.co/HeVP4Eogkk #DHHJ United States 2 Vietnamese 15 2017-07-16T17:45:00 2017-07-16T17:45:00 506 873 9835 RETWEET 1 0 1
84667 1706359664 ALMOSTSAINTGIRL 127 So damn true https://t.co/JKMBVdwpKg United States 2 Vietnamese 15 2015-07-03T09:09:00 2015-07-03T09:09:00 53 48 247   1 0
85840 1677511772 ALYSSABEDOLLA 134 We're SO FAT #UnitedStatesIn3Words United States 2 Vietnamese 15 2015-07-04T14:19:00 2015-07-04T14:19:00 278 250 715 RETWEET 1 0 1
86091 2616344667 AMANDAVGREEN 138 Tommy girl #InsultingMovies United States 2 Vietnamese 15 2017-01-14T10:25:00 2017-01-14T10:25:00 4409 5117 5772   0 0
88581 2616344667 AMANDAVGREEN 138 '@midnight U.F.Ozone Baby #ConspiracySongs' United States 2 Vietnamese 15 2017-04-25T09:34:00 2017-04-25T09:34:00 5875 7379 6748   0 0
91187 890000000000000000 AMBERLINETR 142 RT vanbadham: Ba ha haaaaaaa ba ha ha haaaa haaaaaaaa https://t.co/wPtn36VOWG #amb United States 2 Vietnamese 15 2017-08-01T01:15:00 2017-08-01T01:15:00 2955 173 648 QUOTE_TWEET 2 0 1
92482 890000000000000000 AMBERLINETR 142 MarkDiStef CFMEU Sophie freebie Sophie loves Adani Sophie ? #amb United States 2 Vietnamese 15 2017-08-17T03:55:00 2017-08-17T03:55:00 3905 445 2747   0 0
101357 1679279490 AMELIEBALDWIN 146 '@horseaunt @YouTube this guy tho https://t.co/efDkHd0prE' United States 2 Vietnamese 15 2016-10-06T15:12:00 2016-10-06T15:12:00 1944 2397 12051 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 61.103ms · Data source: fivethirtyeight/russian-troll-tweets