home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

1,221 rows where search matches "statues"

View and edit SQL

Suggested facets: post_type, account_type, new_june_2018, retweet

author

account_category

region

Link rowid external_author_id author content region language publish_date harvested_date following followers updates post_type new_june_2018 retweet
304 906000000000000000 10_GOP 1 It starts with the confederate flag. Then the statues. Then the US flag. Now the Tomb of the Unknown Soldier. Sick! https://t.co/iRwMfezCED Unknown 1 English 1 2017-09-27T21:54:00 2017-09-27T21:54:00 1039 9055 209   0 0
17101 893000000000000000 ABIISSROSB 29 #abi Watch Liberals Cheer as they STOMP on Confederate Statues https://t.co/PgoFzi1HlM #ABISS https://t.co/7197L4vaWg United States 2 English 1 2017-08-15T17:14:00 2017-08-15T17:14:00 1964 617 628   0 0
17130 893000000000000000 ABIISSROSB 29 #abi Dems Make Bold Move to Destroy MORE Confederate Statues https://t.co/sMmPTmIInn #ABISS https://t.co/OV9B3c3gZ2 United States 2 English 1 2017-08-16T14:09:00 2017-08-16T14:09:00 1965 729 664   0 0
17139 893000000000000000 ABIISSROSB 29 #abi Baltimore SURRENDERS to Antifa, Removes Confederate Statues Overnight https://t.co/cRExc6ax8R #ABISS https://t.co/PsgD6Zkbav United States 2 English 1 2017-08-16T14:14:00 2017-08-16T14:15:00 1965 730 669   0 0
17233 893000000000000000 ABIISSROSB 29 #abi BREAKING : More Cities CAVING and Removing Confederate Statues! https://t.co/hV2zfpG8b2 #ABISS https://t.co/dovEx6MvIO United States 2 English 1 2017-08-17T09:59:00 2017-08-17T10:00:00 1959 846 713   0 0
17244 893000000000000000 ABIISSROSB 29 #abi NEW POLL : America Agrees With Trump on Confederate Statues https://t.co/UvFVbb6u0t #ABISS https://t.co/46JUx2RcGT United States 2 English 1 2017-08-18T17:04:00 2017-08-18T17:04:00 1957 896 773   0 0
17253 893000000000000000 ABIISSROSB 29 #abi Chelsea Compares Confederate Statues to Lucifer, INSTANTLY Backfires! https://t.co/dOVX6I3zwI #ABISS https://t.co/NPcxk01vep United States 2 English 1 2017-08-18T17:20:00 2017-08-18T17:20:00 1957 896 782   0 0
17288 893000000000000000 ABIISSROSB 29 #abi CNN Commentator DEMANDS Founding Father Statues COME DOWN https://t.co/9XgcX7X4lt #ABISS https://t.co/yGDjQFLJo4 United States 2 English 1 2017-08-18T06:29:00 2017-08-18T06:29:00 1959 888 759   0 0
18817 895000000000000000 ACAPARELLA 37 #acapa Watch Liberals Cheer as they STOMP on Confederate Statues https://t.co/WYECrMWfoX https://t.co/pIqdzgwekr Unknown 1 English 1 2017-08-15T17:10:00 2017-08-15T17:10:00 39 7 406   0 0
18847 895000000000000000 ACAPARELLA 37 #acapa Dems Make Bold Move to Destroy MORE Confederate Statues https://t.co/wBHyOU5Ihm https://t.co/DG3OBYsVDO Unknown 1 English 1 2017-08-16T14:11:00 2017-08-16T14:11:00 39 4 442   0 0
18850 895000000000000000 ACAPARELLA 37 #acapa Baltimore SURRENDERS to Antifa, Removes Confederate Statues Overnight https://t.co/Lx8ykThf8w https://t.co/sZ5RHecd6P Unknown 1 English 1 2017-08-16T14:16:00 2017-08-16T14:16:00 39 4 447   0 0
18941 895000000000000000 ACAPARELLA 37 #acapa BREAKING : More Cities CAVING and Removing Confederate Statues! https://t.co/pWvQpxrkz8 https://t.co/PtK9BXl9gi Unknown 1 English 1 2017-08-17T09:51:00 2017-08-17T09:52:00 1026 21 491   0 0
18947 895000000000000000 ACAPARELLA 37 #acapa NEW POLL : America Agrees With Trump on Confederate Statues https://t.co/44AaPqfwpR https://t.co/zwpvceVpyM Unknown 1 English 1 2017-08-18T17:01:00 2017-08-18T17:02:00 1000 103 551   0 0
18951 895000000000000000 ACAPARELLA 37 #acapa Chelsea Compares Confederate Statues to Lucifer, INSTANTLY Backfires! https://t.co/Fjpwj2X8OI https://t.co/THIh5I1tAK Unknown 1 English 1 2017-08-18T17:17:00 2017-08-18T17:17:00 1000 103 560   0 0
18991 895000000000000000 ACAPARELLA 37 #acapa CNN Commentator DEMANDS Founding Father Statues COME DOWN https://t.co/z4ycV1ETVA https://t.co/wZwWzzAxe8 Unknown 1 English 1 2017-08-18T06:51:00 2017-08-18T06:51:00 1008 71 537   0 0
31122 893000000000000000 ADNNELSTR 53 #adsnn Watch Liberals Cheer as they STOMP on Confederate Statues https://t.co/IlCf92leQL #adns https://t.co/Dsy5W8AK82 United States 2 English 1 2017-08-15T17:12:00 2017-08-15T17:12:00 1946 170 3511   0 0
31924 893000000000000000 ADNNELSTR 53 #adsnn Dems Make Bold Move to Destroy MORE Confederate Statues https://t.co/MVkcYU5v0y #adns https://t.co/8RtjBIFTX3 United States 2 English 1 2017-08-16T14:11:00 2017-08-16T14:11:00 1943 243 4237   0 0
31929 893000000000000000 ADNNELSTR 53 #adsnn Baltimore SURRENDERS to Antifa, Removes Confederate Statues Overnight https://t.co/9C1UIuZ9IV #adns https://t.co/ZAnvTvzwCW United States 2 English 1 2017-08-16T14:16:00 2017-08-16T14:16:00 1943 246 4244   0 0
32753 893000000000000000 ADNNELSTR 53 #adsnn BREAKING : More Cities CAVING and Removing Confederate Statues! https://t.co/aJ5szNU3f3 #adns https://t.co/y5M5aIhhFC United States 2 English 1 2017-08-17T10:36:00 2017-08-17T10:36:00 1939 332 4876   0 0
33751 893000000000000000 ADNNELSTR 53 #adsnn NEW POLL : America Agrees With Trump on Confederate Statues https://t.co/rgvu3pyA04 #adns https://t.co/jAkRLH8QfF United States 2 English 1 2017-08-18T17:01:00 2017-08-18T17:02:00 1937 395 5888   0 0
33783 893000000000000000 ADNNELSTR 53 #adsnn Chelsea Compares Confederate Statues to Lucifer, INSTANTLY Backfires! https://t.co/DKhllXfeDB #adns https://t.co/spAGFW3Hqc United States 2 English 1 2017-08-18T17:21:00 2017-08-18T17:21:00 1937 395 5921   0 0
34257 893000000000000000 ADNNELSTR 53 #adsnn CNN Commentator DEMANDS Founding Father Statues COME DOWN https://t.co/NTFAzpEMCV #adns https://t.co/IwXQQebUvc United States 2 English 1 2017-08-18T06:36:00 2017-08-18T06:36:00 1939 389 5621   0 0
40622 891000000000000000 AFEELIUTR 60 #ade Watch Liberals Cheer as they STOMP on Confederate Statues https://t.co/T6VAgmBIMQ #aded https://t.co/9wm2Zqp5kA United States 2 English 1 2017-08-15T17:05:00 2017-08-15T17:05:00 2957 1066 1267   0 0
40653 891000000000000000 AFEELIUTR 60 #ade Dems Make Bold Move to Destroy MORE Confederate Statues https://t.co/1tqBrKadMe #aded https://t.co/kfeGA7E1Ia United States 2 English 1 2017-08-16T14:15:00 2017-08-16T14:15:00 3922 1152 1303   0 0
40657 891000000000000000 AFEELIUTR 60 #ade Baltimore SURRENDERS to Antifa, Removes Confederate Statues Overnight https://t.co/T9KMH6LJ1z #aded https://t.co/7RaNhrL2Ox United States 2 English 1 2017-08-16T14:15:00 2017-08-16T14:16:00 3922 1152 1308   0 0
40755 891000000000000000 AFEELIUTR 60 #ade BREAKING : More Cities CAVING and Removing Confederate Statues! https://t.co/QWKEWzYgM3 #aded https://t.co/XMfgdtaZ6y United States 2 English 1 2017-08-17T09:50:00 2017-08-17T09:51:00 3923 1218 1352   0 0
40759 891000000000000000 AFEELIUTR 60 #ade NEW POLL : America Agrees With Trump on Confederate Statues https://t.co/90DVYcTKFw #aded https://t.co/EYJDH7LuoD United States 2 English 1 2017-08-18T17:04:00 2017-08-18T17:04:00 3918 1365 1412   0 0
40770 891000000000000000 AFEELIUTR 60 #ade Chelsea Compares Confederate Statues to Lucifer, INSTANTLY Backfires! https://t.co/UatJkqx5gf #aded https://t.co/x3tTAgpNr5 United States 2 English 1 2017-08-18T17:19:00 2017-08-18T17:19:00 3918 1365 1421   0 0
40791 891000000000000000 AFEELIUTR 60 #ade CNN Commentator DEMANDS Founding Father Statues COME DOWN https://t.co/1DJrFf24gC #aded https://t.co/vkbswOImYU United States 2 English 1 2017-08-18T06:19:00 2017-08-18T06:20:00 3919 1340 1398   0 0
50990 893000000000000000 ALAXXATR 84 #aleex Watch Liberals Cheer as they STOMP on Confederate Statues https://t.co/SRCva18WdZ #alexx https://t.co/H7YgDqF8PU Unknown 1 English 1 2017-08-15T17:11:00 2017-08-15T17:11:00 28 2 564   0 0
51015 893000000000000000 ALAXXATR 84 #BothSides Sad day in America erasing history be it good, bad or ugly. Magnificant bronze equestarian statues are … https://t.co/SgyNDPy7Xi Unknown 1 English 1 2017-08-15T23:04:00 2017-08-15T23:04:00 28 2 585   0 0
51016 893000000000000000 ALAXXATR 84 #BothSides Sad day in America erasing history be it good, bad or ugly. Magnificant bronze equestarian statues are … https://t.co/SgyNDPy7Xi Unknown 1 English 1 2017-08-15T23:04:00 2017-08-15T23:04:00 28 2 585   0 0
51026 893000000000000000 ALAXXATR 84 #WednesdayWisdom realDonaldTrump Since We're Tearing Down Offensive Statues When Are Lenin Statues Being Torn Down? https://t.co/rO9FuAL2LH Unknown 1 English 1 2017-08-16T13:19:00 2017-08-16T13:19:00 28 2 599   0 0
51038 893000000000000000 ALAXXATR 84 #aleex Dems Make Bold Move to Destroy MORE Confederate Statues https://t.co/hMnJmenXVw #alexx https://t.co/Sq6xmG0gag Unknown 1 English 1 2017-08-16T14:10:00 2017-08-16T14:10:00 28 2 613   0 0
51045 893000000000000000 ALAXXATR 84 #aleex Baltimore SURRENDERS to Antifa, Removes Confederate Statues Overnight https://t.co/eHxFZ24VNL #alexx https://t.co/iGf1uhyoqK Unknown 1 English 1 2017-08-16T14:15:00 2017-08-16T14:15:00 28 2 618   0 0
51106 893000000000000000 ALAXXATR 84 Appalling statues torn down by mob rule. Removing the Confederate flag a knee jerk reaction to Church shooting led… https://t.co/8gIokH1WSF Unknown 1 English 1 2017-08-17T00:19:00 2017-08-17T00:20:00 28 1 652   0 0
51149 893000000000000000 ALAXXATR 84 RT realDonaldTrump: Sad to see the history and culture of our great country being ripped apart with the removal of our beautiful statues an… Unknown 1 English 1 2017-08-17T18:54:00 2017-08-17T18:54:00 28 2 721   0 0
51152 893000000000000000 ALAXXATR 84 realDonaldTrump We need to follow suit! Why North Carolina's Confederate Monuments, Statues Can't be Removed https://t.co/7UlgWT4O6B 🇺🇸🌹🇺🇸 Unknown 1 English 1 2017-08-17T20:09:00 2017-08-17T20:09:00 28 2 725   0 0
51166 893000000000000000 ALAXXATR 84 RT TheresaMechele: #WednesdayWisdom realDonaldTrump Since We're Tearing Down Offensive Statues When Are Lenin Stat… https://t.co/rO9FuAL2LH Unknown 1 English 1 2017-08-17T04:54:00 2017-08-17T04:54:00 28 2 680   0 0
51174 893000000000000000 ALAXXATR 84 #aleex BREAKING : More Cities CAVING and Removing Confederate Statues! https://t.co/BEaqkIXOEm #alexx https://t.co/zUYE0asDNR Unknown 1 English 1 2017-08-17T09:55:00 2017-08-17T09:55:00 28 2 690   0 0
51195 893000000000000000 ALAXXATR 84 #aleex NEW POLL : America Agrees With Trump on Confederate Statues https://t.co/5FOWWAG9p2 #alexx https://t.co/WsSOCBDony Unknown 1 English 1 2017-08-18T17:06:00 2017-08-18T17:06:00 28 6 793   0 0
51204 893000000000000000 ALAXXATR 84 #aleex Chelsea Compares Confederate Statues to Lucifer, INSTANTLY Backfires! https://t.co/FIeeDdW7h7 #alexx https://t.co/VLFF4BPaFW Unknown 1 English 1 2017-08-18T17:20:00 2017-08-18T17:20:00 28 6 802   0 0
51221 893000000000000000 ALAXXATR 84 RT TheresaMechele: #WednesdayWisdom realDonaldTrump Since We're Tearing Down Offensive Statues When Are Lenin Stat… https://t.co/rO9FuAtrn7 Unknown 1 English 1 2017-08-18T18:54:00 2017-08-18T18:54:00 28 6 817   0 0
51237 893000000000000000 ALAXXATR 84 RT TheresaMechele: Appalling statues torn down by mob rule. Removing the Confederate flag a knee jerk reaction to … https://t.co/8gIokGKlu5 Unknown 1 English 1 2017-08-18T20:09:00 2017-08-18T20:09:00 28 7 828   0 0
51283 893000000000000000 ALAXXATR 84 #aleex CNN Commentator DEMANDS Founding Father Statues COME DOWN https://t.co/sWNQR2V9tI #alexx https://t.co/G4DE6AFvlS Unknown 1 English 1 2017-08-18T06:20:00 2017-08-18T06:21:00 28 5 750   0 0
51305 893000000000000000 ALAXXATR 84 RT bbusa617: NAACP Leader: I Disapprove Of Pulling Down Those Confederate Statues https://t.co/Mqi5pXfJKq The Evil Left Won't Listen To T… Unknown 1 English 1 2017-08-18T09:39:00 2017-08-18T09:39:00 28 6 769   0 0
57636 3083086600 ALDRICH420 90 Why Are Noses Missing from so Many Egyptian Statues? https://t.co/89Wv7d2Ssu https://t.co/hEUJgnVhak United States 2 English 1 2017-02-07T01:43:00 2017-02-07T01:43:00 1642 1528 2292 RETWEET 1 0 1
59913 1652987412 ALECMOOOOODY 91 The Giant Olmec Statues Are The Proof Africans & Native Americans Co Existed In The West Long Before #ColumbusDay #IndigenousPeoplesDay https://t.co/rF8SYqtl98 United States 2 English 1 2016-10-11T03:34:00 2016-10-11T03:34:00 529 919 2975 RETWEET 1 0 1
73542 893000000000000000 ALEXXDRTRR 107 RT ScottAdamsSays: Should President Trump simply disavow white nationalists or go further and say he prefers statues of generals who won? Unknown 1 English 1 2017-08-13T20:15:00 2017-08-13T20:16:00 34 7 671   0 0
73682 893000000000000000 ALEXXDRTRR 107 RT Tonyg04456745: DarLovesAmerica MayorLandrieu Those statues didn't bother the man of peace MLK didn't bother man… https://t.co/EUTfeNkCYh Unknown 1 English 1 2017-08-14T13:22:00 2017-08-14T13:22:00 34 6 864   0 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 425.159ms · Data source: fivethirtyeight/russian-troll-tweets