home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

488 rows where language = 33

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
15900 2534421182 ABIGAILSSILK 28 Sweet kisses :) https://t.co/Gk7eP7g9Ps United States 2 Pushto 33 2015-03-13T09:44:00 2015-03-13T09:44:00 186 144 826   0 0
22747 1652138929 ACEJINEV 38 am I wrong?? lol https://t.co/66fWodejJx Unknown 1 Pushto 33 2015-03-18T12:42:00 2015-03-18T12:43:00 260 87 411   0 0
27715 1704035413 ADDIE_HOL 45 Candy mountain http://t.co/5os4dqSSsj United States 2 Pushto 33 2015-05-25T12:01:00 2015-05-25T12:01:00 82 54 321   0 0
36999 1657833811 ADRIENNE_GG 57 it's sooo sweet https://t.co/KyGjJRebOk United States 2 Pushto 33 2015-01-25T22:45:00 2015-01-25T22:45:00 127 117 127   0 0
37005 1657833811 ADRIENNE_GG 57 devilish kitties https://t.co/t9l2DAqayt United States 2 Pushto 33 2015-01-25T23:30:00 2015-01-25T23:30:00 127 117 134   0 0
37953 1657833811 ADRIENNE_GG 57 Awwww yes…don`t stop! https://t.co/jnYi2X0Nl3 United States 2 Pushto 33 2015-02-16T13:15:00 2015-02-16T13:15:00 108 128 319   0 0
38015 1657833811 ADRIENNE_GG 57 https://t.co/RGRb2nwJPy so lovely! United States 2 Pushto 33 2015-02-16T14:25:00 2015-02-16T14:25:00 108 129 406   0 0
38022 1657833811 ADRIENNE_GG 57 it's sooo sweet https://t.co/8bluKiD1ZA United States 2 Pushto 33 2015-02-16T14:33:00 2015-02-16T14:33:00 108 129 419   0 0
38026 1657833811 ADRIENNE_GG 57 My hairbrush song!!! http://t.co/HxiKWB8A43 United States 2 Pushto 33 2015-02-16T14:38:00 2015-02-16T14:38:00 108 129 425   0 0
38140 1657833811 ADRIENNE_GG 57 am I wrong?? lol https://t.co/TUdlmCtgkh United States 2 Pushto 33 2015-02-08T14:01:00 2015-02-08T14:02:00 265 121 148   0 0
38175 1657833811 ADRIENNE_GG 57 minaj's brother lol https://t.co/whyul60iDB United States 2 Pushto 33 2015-02-08T14:32:00 2015-02-08T14:32:00 265 122 200   0 0
38236 1657833811 ADRIENNE_GG 57 so lovely http://t.co/W72fweFFnr United States 2 Pushto 33 2015-02-08T15:15:00 2015-02-08T15:15:00 265 122 285   0 0
38335 1657833811 ADRIENNE_GG 57 devilish kitties https://t.co/zFj0ododgu United States 2 Pushto 33 2015-03-13T09:34:00 2015-03-13T09:34:00 149 142 508   0 0
38358 1657833811 ADRIENNE_GG 57 https://t.co/xEycKmEE8M beautifull! United States 2 Pushto 33 2015-03-13T09:47:00 2015-03-13T09:47:00 149 142 537   0 0
38399 1657833811 ADRIENNE_GG 57 Sweet kisses :) https://t.co/RYyihNU54f United States 2 Pushto 33 2015-03-16T14:27:00 2015-03-16T14:28:00 150 142 623   0 0
38457 1657833811 ADRIENNE_GG 57 Awwww yes…don`t stop! https://t.co/jnYi2X0Nl3 United States 2 Pushto 33 2015-03-16T14:52:00 2015-03-16T14:52:00 150 142 705   0 0
44141 2657041133 AHMADHUSSEINII 73 '@AJArabic هؤلاء ليسو قتلى انما شهداء لانهم يقدمون ارواحهم فداء لسوريا وارض سوريا' Israel 6 Pushto 33 2015-11-28T09:18:00 2015-11-28T09:21:00 572 51 1385   1 0
44158 2657041133 AHMADHUSSEINII 73 سيناريو روسي رهيب لحرب شاملة مع تركيا https://t.co/LPqhJv7l5T #تركيا #روسيا https://t.co/xIKsQMwhHN Israel 6 Pushto 33 2015-11-29T12:57:00 2015-11-29T13:09:00 597 73 1616 RETWEET 1 1 1
44449 2186395434 AHMADYUSUFF03 76 كيفك ياوجعي https://t.co/aFn4QubZh6 عبر @YouTube Israel 6 Pushto 33 2015-10-31T12:58:00 2015-10-31T12:58:00 2100 512 3454   0 0
44519 2186395434 AHMADYUSUFF03 76 #ساوثمبتون يفوز 2-0 على #بورنموث https://t.co/I8cN8Dadmb Israel 6 Pushto 33 2015-11-02T12:03:00 2015-11-02T12:03:00 2135 516 3714 QUOTE_TWEET 2 0 1
48374 2570250275 AIDEN7757 81 Goodness gracious, JaKarr. https://t.co/MSV7xJa127 United States 2 Pushto 33 2015-03-16T12:13:00 2015-03-16T12:13:00 260 30 466   0 0
52310 3082043421 ALBERTMORENMORE 88 omg! lol im laughing so hard http://t.co/Kf7Xm8RitZ United States 2 Pushto 33 2015-04-21T13:28:00 2015-04-21T13:28:00 142 72 79   0 0
52456 3082043421 ALBERTMORENMORE 88 omg! lol im laughing so hard http://t.co/Kf7Xm8RitZ United States 2 Pushto 33 2015-05-03T14:56:00 2015-05-03T14:56:00 142 74 267   0 0
132680 1656919058 AMIRAFERRR 150 Awwwwwww that's my fav cartoon! https://t.co/9GH8jy7pTX United States 2 Pushto 33 2015-05-25T12:49:00 2015-05-25T12:50:00 55 52 375   0 0
182280 1649593796 ANN_HANAH 228 https://t.co/BO67vC1ICT beautifull! United States 2 Pushto 33 2015-05-25T11:51:00 2015-05-25T11:51:00 58 57 400   0 0
206139 1686370159 ARCHIEOLIVERS 254 #ff Blessings! @MikeRumbo66 @BettinaVLA @theMblaze @cleflore23 @WEdwarda @evil_bun_bun @Johnny_Petrini @AnewTrackrecord @conservateach United States 2 Pushto 33 2015-05-29T22:55:00 2015-05-29T22:56:00 2 87 557 RETWEET 1 0 1
210822 2582643409 ARKADII_TROFIM 264 NEW MAP Military situation in #Aleppo #حلب #Hanano #هنانو liberated HD: https://t.co/O6hnG2iJG6 #Syria #سوريا https://t.co/ZG6Lr9g0HC Azerbaijan 7 Pushto 33 2016-11-27T00:47:00 2016-11-27T00:47:00 261 2085 1841 RETWEET 1 0 1
214162 1671936266 ARM_2_ALAN 269 Great�import Jihadis�#Obamatrade relaxes Pakistani visa requirements @LodiSilverado @MaydnUSA http://t.co/Ex9wLLNWtd http://t.co/v2o7u5Ceqq United States 2 Pushto 33 2015-06-11T22:14:00 2015-06-11T22:14:00 66 167 8747 RETWEET 1 0 1
214478 1671936266 ARM_2_ALAN 269 �� Pakistan-born Muslims face prison for NYC bomb plot http://t.co/CIX9np6h6u United States 2 Pushto 33 2015-06-12T00:12:00 2015-06-12T00:12:00 66 168 8840 RETWEET 1 0 1
216565 1671936266 ARM_2_ALAN 269 Man pushes woman off #subway #platform http://t.co/LhAt6cZ68l United States 2 Pushto 33 2015-06-03T18:51:00 2015-06-03T18:51:00 68 111 1623 RETWEET 1 0 1
216652 1671936266 ARM_2_ALAN 269 "Muhammad Ali's 7 Daughters" #OnceUponATime http://t.co/3qk3Wk2UPX United States 2 Pushto 33 2015-06-03T01:11:00 2015-06-03T01:11:00 68 87 1033 RETWEET 1 0 1
216799 1671936266 ARM_2_ALAN 269 #ComplimentYourselfIn4Words I'm a decent uncle � http://t.co/nASsGaWSnl United States 2 Pushto 33 2015-06-03T21:55:00 2015-06-03T21:55:00 68 126 1822 RETWEET 1 0 1
217042 1671936266 ARM_2_ALAN 269 �� Hillary's 3am Call (Cartoon) http://t.co/poo10mGDzm #WIunion United States 2 Pushto 33 2015-06-03T07:51:00 2015-06-03T07:51:00 68 99 1223 RETWEET 1 0 1
217046 1671936266 ARM_2_ALAN 269 �� TSA Screening (Cartoon) http://t.co/t3W7NoFyg5 #WIunion United States 2 Pushto 33 2015-06-03T07:53:00 2015-06-03T07:53:00 68 99 1226 RETWEET 1 0 1
217421 1671936266 ARM_2_ALAN 269 "drownding!" United States 2 Pushto 33 2015-06-04T17:33:00 2015-06-04T17:33:00 68 140 2497 RETWEET 1 0 1
217864 1671936266 ARM_2_ALAN 269 #HillarySoOld she's fluent in Aramaic. United States 2 Pushto 33 2015-06-04T03:51:00 2015-06-04T03:51:00 68 139 2075 RETWEET 1 0 1
217924 1671936266 ARM_2_ALAN 269 #ComplimentYourselfIn4Words I don't believe OBAMA http://t.co/f59cLkIuCu United States 2 Pushto 33 2015-06-04T05:33:00 2015-06-04T05:33:00 68 140 2139 RETWEET 1 0 1
218111 1671936266 ARM_2_ALAN 269 #news Wichita Art Museum spends $3M for outdoor sculpture garden United States 2 Pushto 33 2015-06-05T12:51:00 2015-06-05T12:51:00 68 141 3216 RETWEET 1 0 1
218371 1671936266 ARM_2_ALAN 269 Obama secretly backing Muslim Brotherhood http://t.co/TGn4dUu9kT via @washtimes @ThePatriot143 @GOP #pjnet #tcot #OiP #GOP #teaparty United States 2 Pushto 33 2015-06-05T17:54:00 2015-06-05T17:54:00 68 141 3478 RETWEET 1 0 1
218553 1671936266 ARM_2_ALAN 269 WATCH: Kay Burley Skewers Alton Towers Boss http://t.co/mtuaQNdYW4 United States 2 Pushto 33 2015-06-05T21:11:00 2015-06-05T21:11:00 68 139 3625 RETWEET 1 0 1
218901 1671936266 ARM_2_ALAN 269 Obama secretly backing Muslim Brotherhood http://t.co/SZCArWcF22 via @wordpressdotcom United States 2 Pushto 33 2015-06-05T07:51:00 2015-06-05T07:51:00 68 140 3092 RETWEET 1 0 1
219049 1671936266 ARM_2_ALAN 269 #EdibleBands Sara Lee Lewis United States 2 Pushto 33 2015-06-06T13:12:00 2015-06-06T13:12:00 68 137 4123 RETWEET 1 0 1
219820 1671936266 ARM_2_ALAN 269 #HorseAroundWithAMovie Mr. Ed Wood United States 2 Pushto 33 2015-06-07T13:33:00 2015-06-07T13:33:00 68 142 4890 RETWEET 1 0 1
220334 1671936266 ARM_2_ALAN 269 �� Fracking Fool (Cartoon) http://t.co/7IYUUomg3h #WIunion United States 2 Pushto 33 2015-06-07T07:32:00 2015-06-07T07:32:00 68 142 4782 RETWEET 1 0 1
322624 1594719241 BERT_HENLEY 377 #ff Blessings! @MikeRumbo66 @BettinaVLA @theMblaze @cleflore23 @WEdwarda @evil_bun_bun @Johnny_Petrini @AnewTrackrecord @conservateach United States 2 Pushto 33 2015-05-29T23:01:00 2015-05-29T23:01:00 247 105 502 RETWEET 1 0 1
324423 2732675512 BGARNER2107 384 minaj's brother lol https://t.co/YnAp1oKo7z United States 2 Pushto 33 2015-01-26T01:42:00 2015-01-26T01:42:00 143 19 1023   0 0
326373 2732675512 BGARNER2107 384 https://t.co/SqwT12FhHz so lovely! United States 2 Pushto 33 2015-03-13T08:58:00 2015-03-13T08:59:00 159 45 1168   0 0
326395 2732675512 BGARNER2107 384 LAla I love dance United States 2 Pushto 33 2015-03-18T18:02:00 2015-03-18T18:02:00 159 53 1293   0 0
326881 2732675512 BGARNER2107 384 Charlie Sheen's Angels #MistakeAMovie http://t.co/TJD2FEYv0H United States 2 Pushto 33 2015-06-03T14:43:00 2015-06-03T14:43:00 169 176 1419 RETWEET 1 0 1
412614 1873206768 BRENTMCCLURE275 444 Afghanistan 2017 https://t.co/rgPGHdRjrv United States 2 Pushto 33 2017-07-21T07:10:00 2017-07-21T07:10:00 715 762 7966 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 84.831ms · Data source: fivethirtyeight/russian-troll-tweets