home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

2 rows where search matches "MH17 " and language = 16 sorted by rowid

View and edit SQL

language

Link rowid ▼ external_author_id author content region language publish_date harvested_date following followers updates post_type new_june_2018 retweet
552481 2527537955 CHERNENKONIKOLA 544 Detail @tomvennink. Heb @GrahamWP_UK zeker ontmoet in DNR. Met bezoek aan het gebied van MH17 was hij niet mee, dagen erop ook niet gezien https://t.co/Pa8NvnSp9t Unknown 1 Dutch 16 2017-01-10T22:32:00 2017-01-10T22:32:00 242 2019 4150 RETWEET 1 0 1
1165654 2575046530 GLEBNIKON 991 Detail @tomvennink. Heb @GrahamWP_UK zeker ontmoet in DNR. Met bezoek aan het gebied van MH17 was hij niet mee, dagen erop ook niet gezien https://t.co/Pa8NvnSp9t Unknown 1 Dutch 16 2017-01-11T00:07:00 2017-01-11T00:07:00 165 2330 2298 RETWEET 1 0 1

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