home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

5 rows where author = 39

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
25449 844000000000000000 ACHSAHORKHAN 39 wish people who take selfies or make amateur porn would clean up their room first. Unknown 1 English 1 2017-04-01T15:18:00 2017-04-01T15:18:00 1 0 8   0 0
25450 844000000000000000 ACHSAHORKHAN 39 your app can send me push notifications. Just give me your home number so I can call you to let you know I got them. Unknown 1 English 1 2017-04-01T15:18:00 2017-04-01T15:18:00 1 0 7   0 0
25451 844000000000000000 ACHSAHORKHAN 39 An animated sitcom where the characters age and change clothes. Unknown 1 English 1 2017-04-01T15:18:00 2017-04-01T15:18:00 1 0 5   0 0
25452 844000000000000000 ACHSAHORKHAN 39 man, I hate when pornos try to have a story. Don't act all surprised dude, just do her. Unknown 1 English 1 2017-04-01T15:18:00 2017-04-01T15:18:00 1 0 4   0 0
25453 844000000000000000 ACHSAHORKHAN 39 A female can be your best friend and worst enemy Unknown 1 English 1 2017-04-01T15:18:00 2017-04-01T15:18:00 1 0 3   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 10.351ms · Data source: fivethirtyeight/russian-troll-tweets