home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

41 rows where region = 27

View and edit SQL

Suggested facets: following, followers

region

author

account_category

Link rowid external_author_id author content region language publish_date harvested_date following followers updates post_type new_june_2018 retweet
1331576 4271904983 ITSTIMETOSECEDE 1199 '@TexasGovernor1 Hey! Hope you're doing fine! Would you like to participate in our #texit statewide rally scheduled for Nov. 5? https://t.co/09p1shh5wc' Mexico 27 English 1 2016-10-27T00:51:00 2016-10-27T00:52:00 6034 5522 893   0 0
1331577 4271904983 ITSTIMETOSECEDE 1199 '@girl_chef1 Hey! Hope you're doing fine! Would you like to participate in our #texit statewide rally scheduled for Nov. 5? https://t.co/DHYX41KM07' Mexico 27 English 1 2016-10-27T00:51:00 2016-10-27T00:51:00 6033 5522 892   0 0
1331578 4271904983 ITSTIMETOSECEDE 1199 '@OpenCarryTexas Hey! Hope you're doing fine! Would you like to participate in our #texit statewide rally scheduled for Nov. 5? https://t.co/2qEno3SpF1' Mexico 27 English 1 2016-10-27T00:53:00 2016-10-27T00:54:00 6036 5522 894   0 0
1331579 4271904983 ITSTIMETOSECEDE 1199 '@carolcentral65 Hey, Carol! Hope you're doing fine! Would you like to participate in our #texit statewide rally scheduled for Nov. 5? https://t.co/N70hmnLoHN' Mexico 27 English 1 2016-10-27T00:56:00 2016-10-27T00:56:00 6044 5522 895   0 0
1331580 4271904983 ITSTIMETOSECEDE 1199 '@Blacktalon7 Hey! Hope you're doing fine! Would you like to participate in our #texit statewide rally scheduled for Nov. 5? https://t.co/epkQlGMIpr' Mexico 27 English 1 2016-10-27T00:57:00 2016-10-27T00:57:00 6047 5522 896   0 0
1331581 4271904983 ITSTIMETOSECEDE 1199 '@PinksMachines Hey, Mike! Hope you're doing fine! Would you like to participate in our #texit statewide rally scheduled for Nov. 5? https://t.co/POqQ6639bU' Mexico 27 English 1 2016-10-27T00:57:00 2016-10-27T00:58:00 6048 5522 897   0 0
1331582 4271904983 ITSTIMETOSECEDE 1199 '@Ixthos Hey, Daniel! Hope you're doing fine! Would you like to participate in our #texit statewide rally scheduled for Nov. 5? https://t.co/hqZIqdhJVA' Mexico 27 English 1 2016-10-27T00:58:00 2016-10-27T00:58:00 6049 5522 898   0 0
1331592 4271904983 ITSTIMETOSECEDE 1199 '@TXNativePatriot Hey! Hope you're doing fine! Would you like to participate in our #texit statewide rally scheduled for Nov. 5? https://t.co/LObzHoQTgp' Mexico 27 English 1 2016-10-27T01:02:00 2016-10-27T01:02:00 6050 5522 899   0 0
1331593 4271904983 ITSTIMETOSECEDE 1199 I don't want to be lectured about my gun rights by anyone. Especially someone who has armed security #Texas #texit https://t.co/UMiq7c8vCW Mexico 27 English 1 2016-10-27T01:43:00 2016-10-27T01:43:00 6051 5526 900   0 0
1331595 4271904983 ITSTIMETOSECEDE 1199 '@TexansAtWar89 We're gonna act in Houston, Austin, San Antonio, DFW - everywhere we can!' Mexico 27 English 1 2016-10-27T02:25:00 2016-10-27T02:25:00 6085 5533 901   0 0
1331603 4271904983 ITSTIMETOSECEDE 1199 '@HilaryCable Howdy! Would you like to participate in our #texit statewide rally scheduled for Nov. 5?' Mexico 27 English 1 2016-10-28T02:40:00 2016-10-28T02:40:00 5971 5624 913   0 0
1331604 4271904983 ITSTIMETOSECEDE 1199 '@RCC_JDGIV Howdy! Would you like to participate in our #texit statewide rally scheduled for Nov. 5?' Mexico 27 English 1 2016-10-28T02:41:00 2016-10-28T02:42:00 5972 5625 914   0 0
1331605 4271904983 ITSTIMETOSECEDE 1199 '@DaveT0076 Howdy, Dave! Would you like to participate in our #Texit statewide rally scheduled for Nov. 5? https://t.co/aus9e1Fj7l' Mexico 27 English 1 2016-10-28T02:50:00 2016-10-28T02:50:00 5974 5626 915   0 0
1331606 4271904983 ITSTIMETOSECEDE 1199 '@AmyLaneVaron Howdy, Amy! Would you like to participate in our #texit statewide rally scheduled for Nov. 5? https://t.co/B1cS1rEip5' Mexico 27 English 1 2016-10-28T02:51:00 2016-10-28T02:51:00 5975 5627 916   0 0
1331634 4271904983 ITSTIMETOSECEDE 1199 I'm 100% sure that very soon our dear Lone Star State will become independent! https://t.co/yAUrAxWx2M Mexico 27 English 1 2016-11-01T18:16:00 2016-11-01T18:16:00 6260 5700 958   0 0
1331642 4271904983 ITSTIMETOSECEDE 1199 '@reltxrodeoqueen Thank you! We're gathering on Saturday at 1 PM outside local City Halls in each of the following locations https://t.co/qt0NSQZfq8' Mexico 27 English 1 2016-11-02T03:01:00 2016-11-02T03:02:00 6259 5698 959   0 0
1331692 4271904983 ITSTIMETOSECEDE 1199 We need self-defense: rifles, handguns, and ammo. BAN DEMOCRATS! NOT GUNS! https://t.co/sfl6628xz3 Mexico 27 English 1 2016-11-03T02:59:00 2016-11-03T03:00:00 6272 5707 960   0 0
1331700 4271904983 ITSTIMETOSECEDE 1199 '@Stormy_Peace @NSAGov @DHSgov well we're all under surveillance' Mexico 27 English 1 2016-11-04T21:55:00 2016-11-04T21:55:00 6277 5718 973   0 0
1331701 4271904983 ITSTIMETOSECEDE 1199 '@TravisRandal meet ya there at 1 PM today!' Mexico 27 English 1 2016-11-05T16:41:00 2016-11-05T16:41:00 6291 5719 994   0 0
1331702 4271904983 ITSTIMETOSECEDE 1199 The #Texit rallies start in two hours. Join us in Ft. Worth, San Antonio, Lubbock, Houston, Dallas, Corpus Christi at the city hall at 1 PM https://t.co/MbIUVaJv1e Mexico 27 English 1 2016-11-05T16:44:00 2016-11-05T16:45:00 6291 5719 995   0 0
1331703 4271904983 ITSTIMETOSECEDE 1199 '@elizabeth__pace Hey, Elizabeth! Could you please follow us back so we can send ya a DM?' Mexico 27 English 1 2016-11-05T19:18:00 2016-11-05T19:18:00 6292 5720 996   0 0
1331704 4271904983 ITSTIMETOSECEDE 1199 Join the #TEXIT rally tomorrow at 1 PM outside your local City hall! See y'all there! Show everyone we ARE ready to SECEDE https://t.co/kcx1ZrJjxr Mexico 27 English 1 2016-11-05T01:12:00 2016-11-05T01:13:00 6283 5719 974   0 0
1331705 4271904983 ITSTIMETOSECEDE 1199 '@toddhammy Howdy, Todd! We're holding a statewide #Texit rally tomorrow in Dallas. Would you like to participate? https://t.co/oY7FKTDzjP' Mexico 27 English 1 2016-11-05T02:43:00 2016-11-05T02:43:00 6288 5719 976   0 0
1331706 4271904983 ITSTIMETOSECEDE 1199 '@wboyd5 Howdy Wes! We're holding a statewide #Texit rally tomorrow in Dallas. Would you like to participate? https://t.co/Zx7JnWR7IC' Mexico 27 English 1 2016-11-05T02:43:00 2016-11-05T02:43:00 6287 5719 975   0 0
1331707 4271904983 ITSTIMETOSECEDE 1199 '@pollypeej Howdy, Paula! We're holding a statewide #Texit rally tomorrow in Dallas. Would you like to participate? https://t.co/FPZuUikQFJ' Mexico 27 English 1 2016-11-05T02:43:00 2016-11-05T02:44:00 6289 5719 977   0 0
1331708 4271904983 ITSTIMETOSECEDE 1199 '@docgary1776 Hey, Gary! We're holding a statewide #Texit rally tomorrow in Dallas. Would you like to participate? https://t.co/Datfn3JZGU' Mexico 27 English 1 2016-11-05T02:44:00 2016-11-05T02:44:00 6290 5719 978   0 0
1331709 4271904983 ITSTIMETOSECEDE 1199 '@hisMUSE4ever Howdy, Nikki! We're holding a statewide #Texit rally tomorrow in Dallas. Would you like to participate? https://t.co/LCybp90pKW' Mexico 27 English 1 2016-11-05T02:45:00 2016-11-05T02:45:00 6291 5719 979   0 0
1331710 4271904983 ITSTIMETOSECEDE 1199 '@Texastweetybird Hey! We're holding a statewide #Texit rally tomorrow in Dallas. Would you like to participate? https://t.co/QeJqRTYkFM' Mexico 27 English 1 2016-11-05T02:46:00 2016-11-05T02:46:00 6291 5719 980   0 0
1331711 4271904983 ITSTIMETOSECEDE 1199 '@TravisRandal Howdy, Travis! We're holding a statewide #Texit rally tomorrow in Dallas. Would you like to participate? https://t.co/IMyxJWSuzF' Mexico 27 English 1 2016-11-05T02:46:00 2016-11-05T02:47:00 6291 5719 981   0 0
1331712 4271904983 ITSTIMETOSECEDE 1199 '@ShamMcGuinness Hey, Sham! We're holding a statewide #Texit rally tomorrow in Dallas. Would you like to participate? https://t.co/y5z0S0Iyd0' Mexico 27 English 1 2016-11-05T02:47:00 2016-11-05T02:47:00 6291 5719 982   0 0
1331713 4271904983 ITSTIMETOSECEDE 1199 '@txdad Hey! We're holding a statewide #Texit rally tomorrow in Dallas. Would you like to participate? https://t.co/ZFQCN7Ske2' Mexico 27 English 1 2016-11-05T02:47:00 2016-11-05T02:47:00 6291 5719 983   0 0
1331714 4271904983 ITSTIMETOSECEDE 1199 '@libgrim Howdy! We're holding a statewide #Texit rally tomorrow in Dallas. Would you like to participate? https://t.co/gWhpQiPEQy' Mexico 27 English 1 2016-11-05T02:48:00 2016-11-05T02:48:00 6291 5719 984   0 0
1331715 4271904983 ITSTIMETOSECEDE 1199 '@TexaStarDallas Howdy! We're holding a statewide #Texit rally tomorrow in Dallas. Would you like to participate? https://t.co/YMrqZSCs5Z' Mexico 27 English 1 2016-11-05T02:50:00 2016-11-05T02:50:00 6291 5719 985   0 0
1331716 4271904983 ITSTIMETOSECEDE 1199 '@nolanwebb1976 Hey, Nolan ! We're holding a statewide #Texit rally tomorrow in Dallas. Would you like to participate? https://t.co/Uy22Pa1NjD' Mexico 27 English 1 2016-11-05T02:50:00 2016-11-05T02:51:00 6291 5719 986   0 0
1331717 4271904983 ITSTIMETOSECEDE 1199 '@acls9_9 Howdy! We're holding a statewide #Texit rally tomorrow at the Texas State Capitol, Austin . Would you like to participate? https://t.co/W0oMIMqbML' Mexico 27 English 1 2016-11-05T02:55:00 2016-11-05T02:56:00 6291 5719 987   0 0
1331718 4271904983 ITSTIMETOSECEDE 1199 '@hughw Howdy, Hugh! We're holding a statewide #Texit rally tomorrow at the Texas State Capitol, Austin . Would you like to participate? https://t.co/LcoA3532ZP' Mexico 27 English 1 2016-11-05T02:56:00 2016-11-05T02:56:00 6291 5719 988   0 0
1331719 4271904983 ITSTIMETOSECEDE 1199 '@matthewcopher Hey, Matthew! We're holding a statewide #Texit rally tomorrow at Texas State Capitol, Austin . Would you like to take part? https://t.co/c0Xi6wZZWK' Mexico 27 English 1 2016-11-05T02:57:00 2016-11-05T02:57:00 6291 5719 989   0 0
1331720 4271904983 ITSTIMETOSECEDE 1199 '@Barbara09145120 Hey, Barbara! We're holding a statewide #Texit rally tomorrow at the Texas State Capitol, Austin. Are you in? https://t.co/ekb8lYFuE0' Mexico 27 English 1 2016-11-05T02:59:00 2016-11-05T02:59:00 6291 5719 990   0 0
1331721 4271904983 ITSTIMETOSECEDE 1199 '@ddstewart9 Hey, David! We're holding a statewide #Texit rally tomorrow at the Texas State Capitol, Austin . Would you like to participate? https://t.co/sWNln6NMOV' Mexico 27 English 1 2016-11-05T03:00:00 2016-11-05T03:00:00 6291 5719 991   0 0
1331722 4271904983 ITSTIMETOSECEDE 1199 '@davegoodin Howdy, Dave! We're holding a statewide #Texit rally tomorrow at the Texas State Capitol, Austin . Would you like to participate? https://t.co/PTwsRH4Qh0' Mexico 27 English 1 2016-11-05T03:01:00 2016-11-05T03:01:00 6291 5719 992   0 0
1331723 4271904983 ITSTIMETOSECEDE 1199 '@Dennis065 Hey, Dennis! We're holding a statewide #Texit rally tomorrow at the Texas State Capitol, Austin . Would you like to participate? https://t.co/MZ4nnibv26' Mexico 27 English 1 2016-11-05T03:04:00 2016-11-05T03:05:00 6291 5719 993   0 0

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 15.749ms · Data source: fivethirtyeight/russian-troll-tweets