home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

2,973,371 rows sorted by account_type

View and edit SQL

Link rowid external_author_id author content region language publish_date harvested_date following followers updates post_type new_june_2018 retweet
1421491 2882331822 JENNATRAVELLER 1263 '@Bidenshairplugs then what about 9 years old boys raped in catholicism that Biden and most of us worship??' United States 2 English 1 2015-01-10T07:39:00 2015-01-10T07:39:00 535 345 376   0 0
1421492 2882331822 JENNATRAVELLER 1263 '@Bidenshairplugs but these priests have the authority and power in religion and undermine the central figure`s authority!' United States 2 English 1 2015-01-10T07:50:00 2015-01-10T07:51:00 536 346 377   0 0
1421493 2882331822 JENNATRAVELLER 1263 '@Bidenshairplugs i mean don`t call all muslims terrorists because of group of cruel assholes' United States 2 English 1 2015-01-10T07:52:00 2015-01-10T07:54:00 536 346 378   0 0
1421494 2882331822 JENNATRAVELLER 1263 '@Suzloveslife @Bidenshairplugs well i hope these priests will also burn in hell' United States 2 English 1 2015-01-10T08:03:00 2015-01-10T08:04:00 536 346 379   0 0
1421495 2882331822 JENNATRAVELLER 1263 Insomnia and endless bad news from the most romantic city in the world Make love... #Paris #politics #CharlieHebdo http://t.co/i4UGX92Xd9 United States 2 English 1 2015-01-10T08:17:00 2015-01-10T08:17:00 536 346 380   0 0
1421496 2882331822 JENNATRAVELLER 1263 '@BBCtrending @BBCWorld a group of cruel assholes undermines all musslims` authority...' United States 2 English 1 2015-01-10T08:40:00 2015-01-10T08:40:00 539 347 381   0 0
1421497 2882331822 JENNATRAVELLER 1263 '@BBCtrending @BBCWorld but i won`t be surprised if the hashtag is promoted by rasist jounalists and goverment' United States 2 English 1 2015-01-10T08:42:00 2015-01-10T08:42:00 539 347 382   0 0
1421498 2882331822 JENNATRAVELLER 1263 Rand Paul at Heritage says it's important to make distinction between “civilized Islam” and “barbaric Islam.” United States 2 English 1 2015-01-13T17:04:00 2015-01-13T17:04:00 542 347 331 RETWEET 1 0 1
1421499 2882331822 JENNATRAVELLER 1263 '@McFaul @carlbildt I don`t care about Russia and Ukraine but i think it`s better to unite with Putin to defeat ISIS. it`s more important' United States 2 English 1 2015-01-13T07:51:00 2015-01-13T07:51:00 539 343 329   0 0
1421500 2882331822 JENNATRAVELLER 1263 They want o bedient workers. United States 2 English 1 2015-01-14T16:38:00 2015-01-14T16:39:00 546 348 336   0 0
1421501 2882331822 JENNATRAVELLER 1263 The real owners of this country don`t want a population of citizens capable of critical thinking #politics http://t.co/j68Y9gXpQC United States 2 English 1 2015-01-14T16:38:00 2015-01-14T16:38:00 546 348 334   0 0
1421502 2882331822 JENNATRAVELLER 1263 They want obedient workers United States 2 English 1 2015-01-14T16:39:00 2015-01-14T16:39:00 546 348 336   0 0
1421503 2882331822 JENNATRAVELLER 1263 '@DrDigiPol Hypocrisy and lie! Thousands of people died in Iraq, Ukraine, Afghanistan, Egypt, Nigeria etc.but no one posted tweets about it!' United States 2 English 1 2015-01-14T17:26:00 2015-01-14T17:26:00 546 348 337   0 0
1421504 2882331822 JENNATRAVELLER 1263 '@DrDigiPol Then why mass media didn`t choose attacks in Ukraine or Iraq or Afghanistan to shine light on all? thousands vs. twelve' United States 2 English 1 2015-01-14T17:40:00 2015-01-14T17:40:00 545 349 339   0 0
1421505 2882331822 JENNATRAVELLER 1263 '@DrDigiPol that`s unfair...or the world's most powerful leaders really don`t care about it and it`s all just a game' United States 2 English 1 2015-01-14T17:43:00 2015-01-14T17:43:00 545 349 340   0 0
1421506 2882331822 JENNATRAVELLER 1263 '@DrDigiPol http://t.co/keLz2VAYDl well ... that never happened in other attacked countries' United States 2 English 1 2015-01-14T17:52:00 2015-01-14T17:52:00 546 351 341   0 0
1421507 2882331822 JENNATRAVELLER 1263 '@RT_com @PaulCraigRobert If u want to defeat the ISIS, stop bying their oil! They get their dirty money from oil export!' United States 2 English 1 2015-01-14T07:16:00 2015-01-14T07:16:00 544 347 332   0 0
1421508 2882331822 JENNATRAVELLER 1263 '@NYMag Big brother`s watching us!' United States 2 English 1 2015-01-14T07:28:00 2015-01-14T07:28:00 545 347 332   0 0
1421509 2882331822 JENNATRAVELLER 1263 First monday sucks ... every monday sucks! United States 2 English 1 2015-01-05T15:59:00 2015-01-05T15:59:00 431 327 358   0 0
1421510 2882331822 JENNATRAVELLER 1263 Make Love not war Politics sucks! #politics #graffiti http://t.co/w3JYCBKEdC United States 2 English 1 2015-01-05T16:07:00 2015-01-05T16:08:00 434 327 359   0 0
1421511 2882331822 JENNATRAVELLER 1263 '@McFaul @luckywanderboy well would Obama free someone who has killed the US soldiers?' United States 2 English 1 2015-01-05T07:20:00 2015-01-05T07:20:00 430 327 356   0 0
1421512 2882331822 JENNATRAVELLER 1263 #politics #banksy http://t.co/l06PUuN4J8 United States 2 English 1 2015-01-05T07:29:00 2015-01-05T07:30:00 430 327 357   0 0
1421513 2882331822 JENNATRAVELLER 1263 '@HistoryInPics it`s funny to death' United States 2 English 1 2015-01-05T07:40:00 2015-01-05T07:40:00 431 327 358   0 0
1421514 2882331822 JENNATRAVELLER 1263 Madagascar-pone tiramisu #EdibleGeography United States 2 Farsi (Persian) 21 2015-01-06T12:12:00 2015-01-06T12:13:00 448 330 361   0 0
1421515 2882331822 JENNATRAVELLER 1263 '@_youhadonejob it`s worse when parents call their child Dick ... DICK!!!' United States 2 English 1 2015-01-06T12:23:00 2015-01-06T12:23:00 449 330 361   0 0
1421516 2882331822 JENNATRAVELLER 1263 LOVE. That's all we have in this life http://t.co/KLAOxVhevx United States 2 English 1 2015-01-06T12:34:00 2015-01-06T12:34:00 449 330 362   0 0
1421517 2882331822 JENNATRAVELLER 1263 Love. That`s all we have in this life. #love #graffiti #banksy #politics http://t.co/TKo6P3bIk7 United States 2 English 1 2015-01-06T12:36:00 2015-01-06T12:36:00 449 330 362   0 0
1421518 2882331822 JENNATRAVELLER 1263 '@StevenErtelt @Chris_1791 I`m no fan of Kid Rock but I like him anyway' United States 2 English 1 2015-01-06T16:45:00 2015-01-06T16:45:00 453 348 363   0 0
1421519 2882331822 JENNATRAVELLER 1263 '@FoxNews That`s it. The end of Obama`s term' United States 2 English 1 2015-01-06T17:04:00 2015-01-06T17:04:00 532 331 364   0 0
1421520 2882331822 JENNATRAVELLER 1263 '@attndotcom @donnatella_moss one thing we need to know is that the president doesn't have a power anymore' United States 2 English 1 2015-01-06T17:08:00 2015-01-06T17:08:00 532 331 365   0 0
1421521 2882331822 JENNATRAVELLER 1263 '@moorehn @PoliticaILine The whole world is in panic not only Venezuela! American oil is unprofitable with 55$ per barrel' United States 2 English 1 2015-01-06T17:49:00 2015-01-06T17:49:00 532 332 366   0 0
1421522 2882331822 JENNATRAVELLER 1263 '@washingtonpost hexogen - fueled �' United States 2 English 1 2015-01-06T07:23:00 2015-01-06T08:42:00 439 331 361   0 0
1421523 2882331822 JENNATRAVELLER 1263 '@foxandfriends that means that Europe is afraid! It`s time to unite' United States 2 English 1 2015-01-09T10:00:00 2015-01-09T10:01:00 534 344 370   0 0
1421524 2882331822 JENNATRAVELLER 1263 '@EWErickson That was expected... Unfortunately a groop of cruel assholes from ISIS undermines all muslims` authority!' United States 2 English 1 2015-01-09T16:58:00 2015-01-09T16:59:00 534 343 372   0 0
1421525 2882331822 JENNATRAVELLER 1263 '@juliaioffe @IChotiner That was expected... Unfortunately a groop of cruel assholes from ISIS undermines all muslims` authority!' United States 2 English 1 2015-01-09T16:58:00 2015-01-09T16:58:00 534 343 371   0 0
1421526 2882331822 JENNATRAVELLER 1263 '@EWErickson and that`s not about racism that`s about terrorists who killed people!' United States 2 English 1 2015-01-09T16:59:00 2015-01-09T16:59:00 534 343 373   0 0
1421527 2882331822 JENNATRAVELLER 1263 '@Reuters @charlescwcooke Europe has never been so unsafe in the face of terrorism...' United States 2 English 1 2015-01-09T17:02:00 2015-01-09T17:02:00 534 343 374   0 0
1421528 2882331822 JENNATRAVELLER 1263 #CharlieHebdo #JeSuisCharlie http://t.co/dSFBTP5R07 United States 2 English 1 2015-01-09T07:24:00 2015-01-09T07:25:00 534 339 367   0 0
1421529 2882331822 JENNATRAVELLER 1263 #ParisShooting shows us unprecedented weakness of our society in the face of this new wave of terrorism. It`s time to unite! United States 2 English 1 2015-01-09T07:41:00 2015-01-09T07:41:00 534 341 368   0 0
1421530 2882331822 JENNATRAVELLER 1263 '@foxandfriends Europe has never been so weak in the face of terrorism' United States 2 English 1 2015-01-09T09:56:00 2015-01-09T09:56:00 534 344 368   0 0
1421531 2882331822 JENNATRAVELLER 1263 Hello Twitter! #myfirstTweet United States 2 LANGUAGE UNDEFINED 23 2014-10-29T16:59:00 2014-10-29T16:59:00 0 0 1   0 0
1421532 2882331822 JENNATRAVELLER 1263 #elephant #travel #love http://t.co/P9rYpSqlE4 United States 2 LANGUAGE UNDEFINED 23 2014-10-29T17:00:00 2014-10-29T17:01:00 0 0 2   0 0
1421533 2882331822 JENNATRAVELLER 1263 #summer http://t.co/Kg2dUe8nED United States 2 LANGUAGE UNDEFINED 23 2014-10-29T17:02:00 2014-10-29T17:03:00 0 0 4   0 0
1421534 2882331822 JENNATRAVELLER 1263 On for tonight #USA #imho United States 2 English 1 2014-10-30T07:55:00 2014-10-30T07:55:00 46 3 9   0 0
1421535 2882331822 JENNATRAVELLER 1263 Do not anticipate trouble, or worry about what may never happen. Keep in the sunlight United States 2 English 1 2014-10-30T07:57:00 2014-10-30T07:58:00 46 3 11   0 0
1421536 2882331822 JENNATRAVELLER 1263 No matter how many breaths that you took you still couldn't breathe United States 2 English 1 2014-10-30T07:57:00 2014-11-22T12:11:00 46 3 10   0 0
1421537 2882331822 JENNATRAVELLER 1263 feeling like a paper cup #happy United States 2 English 1 2014-10-30T08:00:00 2014-10-30T08:00:00 46 3 14   0 0
1421538 2882331822 JENNATRAVELLER 1263 "Success usually comes to those who are too busy to be looking for it United States 2 English 1 2014-10-30T08:02:00 2014-10-30T08:03:00 46 3 15   0 0
1421539 2882331822 JENNATRAVELLER 1263 Wear the old coat and buy a new book United States 2 English 1 2014-10-30T08:04:00 2014-10-30T08:04:00 46 3 16   0 0
1421540 2882331822 JENNATRAVELLER 1263 I feel is it real, as the lynch mob doubles. #RAP United States 2 English 1 2014-10-30T08:12:00 2014-10-30T08:12:00 46 3 22   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 431.022ms · Data source: fivethirtyeight/russian-troll-tweets