home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

21 rows where language = 48

View and edit SQL

Suggested facets: external_author_id, author, region, following, followers, post_type, account_type, new_june_2018, retweet, account_category

Link rowid external_author_id author content region language publish_date harvested_date following followers updates post_type new_june_2018 retweet
116419 1679279490 AMELIEBALDWIN 146 WH破産申請、中国の原発計画への影響限定的=国家電力投資集団 https://t.co/i1svX3Kdcd https://t.co/zHfFb7pwmv United States 2 Simplified Chinese 48 2017-03-30T08:12:00 2017-03-30T08:12:00 2301 2763 34491 RETWEET 1 0 1
211485 2582643409 ARKADII_TROFIM 264 '@tov_sobakin я знаю! я знаю! ЮАР, да? 🤣' Azerbaijan 7 Simplified Chinese 48 2017-04-30T08:27:00 2017-04-30T08:28:00 260 1888 3927 RETWEET 1 0 1
701352 1651693646 CYNTHIAMHUNTER 616 Buttercoin首席执行官战略性失误,导致公司关闭 #bitcoin #crypto #cryptocurrency http://t.co/655nEJoFmx http://t.co/HbcZWRKGNP United States 2 Simplified Chinese 48 2015-04-18T23:13:00 2015-04-18T23:13:00 434 157 348 RETWEET 1 0 1
1039352 3272640600 EXQUOTE 890 .@__JJ07 J @Yan_PetA_Sia0 这是可以吃的吗? @wilkiali Ali @Miiithy Melissa @MonkElfrieda MonkElfrieda @ServiceRepair23 Service http://t.co/9cllIe8o0r United States 2 Simplified Chinese 48 2015-08-16T11:17:00 2015-08-16T11:17:00 2 418 36511   1 0
1040742 3272640600 EXQUOTE 890 .@___grind___ Olympian @Yisell24_ AYG❣ @bitch_hai laura @JorgieOrozco 王他媽的男孩 @NRaven94 RÂV @factzmanifest Facts http://t.co/XS93mv3Ryv United States 2 Simplified Chinese 48 2015-08-16T06:05:00 2015-08-16T06:05:00 2 414 36236   1 0
1048596 3272640600 EXQUOTE 890 .@TheKalamazooGay 平和, @r_gestaalt R @IvyVegas Ivy @Charebubu Chare @plum_paradise ??? @HaifJordan Haif http://t.co/4L2I2BE1CD United States 2 Simplified Chinese 48 2015-08-20T06:25:00 2015-08-20T06:25:00 2 571 43599   1 0
1051502 3272640600 EXQUOTE 890 .@damiandowner little @hellohayleyy h @jinzhongrewn 世界 @BrandonfrmNJ Brandon @xShortyAffectx Quasha??? http://t.co/HceQayEsGC United States 2 Simplified Chinese 48 2015-08-24T00:42:00 2015-08-24T00:42:00 2 686 50191   1 0
1055680 3272640600 EXQUOTE 890 .@IZ400HBANG Izzy @51Takaya 中川 @KennedyDancers Kennedy @_stump michaelstump @ashnihindocha Ashni @samereputation old http://t.co/U8QozdvlVT United States 2 Simplified Chinese 48 2015-08-27T14:13:00 2015-08-27T14:14:00 2 773 57044   1 0
1056751 3272640600 EXQUOTE 890 .@_richcardo_ 反社会的人間 @erroskey ro$e @theDarrenRitch Darren @SamanthaSiddiqi samantha @pentaVIP blake http://t.co/k4IvPFDDU7 United States 2 Simplified Chinese 48 2015-08-27T03:42:00 2015-08-27T03:42:00 2 758 56274   1 0
1056754 3272640600 EXQUOTE 890 .@SamStevenson47 Natural @BlueRaveFinn Lisa @ZutraaixniHN ???? @_richcardo_ 反社会的人間 @ferguson_reilly Reilly http://t.co/UvBe3UMICe United States 2 Simplified Chinese 48 2015-08-27T03:44:00 2015-08-27T03:44:00 2 758 56277   1 0
1057845 3272640600 EXQUOTE 890 .@ohheygreat Leah @slvmp 不安少年 @McS_86 Marc_s @miss_rizz Marissa @Zython86 Zython @thepoliticalcat thepoliticalcat http://t.co/BVlKsEOX2D United States 2 Simplified Chinese 48 2015-08-28T18:24:00 2015-08-28T18:24:00 2 794 59172   1 0
1059838 3272640600 EXQUOTE 890 .@rasheedxyahya Fasho @IamIoser Loser @isaiah_sevahn 思想開明的 @_Zerbeeee Christopher @michellethepimp Michelle http://t.co/AGznAvxSe4 United States 2 Simplified Chinese 48 2015-08-29T01:24:00 2015-08-29T01:24:00 2 804 59769   1 0
1063327 3272640600 EXQUOTE 890 .@Turbo_Marketers Turbo @JuliaSense Facts @DJGUESSWHO_iSo Fat @AutumnArashi 認知的不協知 @J_Nicolee12 ∞ http://t.co/BL3pY716AZ United States 2 Simplified Chinese 48 2015-08-30T07:34:00 2015-08-30T07:34:00 2 840 61734   1 0
1094525 3254273689 FINDDIET 914 世界最好的郑容和 @yongyongjii Joyce @pizzuhforjoyce Erin @Erinmclaughlinx Daniel @danielinraleigh http://t.co/ivCOdP6mm5 https://t.co/dASVOeZMoM United States 2 Simplified Chinese 48 2015-08-11T12:24:00 2015-08-11T12:24:00 3 291 28686 QUOTE_TWEET 2 1 1
1094956 3254273689 FINDDIET 914 Hyde @IzzySqueeeze Chester @thousandcrosses melissa @AdoreKidrauhlll 他是个 @stuckonchanbaek http://t.co/0TBTHG5GDv https://t.co/HUk9Yj7ZiO United States 2 Simplified Chinese 48 2015-08-11T04:05:00 2015-08-11T04:05:00 3 273 28179 QUOTE_TWEET 2 1 1
1095354 3254273689 FINDDIET 914 Sarah @acid_intimacy 再爱我一次 @anbokr prettyinpoc @violettesnav ♡ @radxponies_ http://t.co/gHUbhaeEjT https://t.co/dvgpnxUCMS United States 2 Simplified Chinese 48 2015-08-11T09:38:00 2015-08-11T09:38:00 3 288 28580 QUOTE_TWEET 2 1 1
2365848 2578422308 RUSSIANALLIES 2295 山姆大叔戏弄中国龙 https://t.co/f6bDOftWqe #ВСРФ United Arab Emirates 4 Simplified Chinese 48 2015-10-28T14:25:00 2015-10-28T14:25:00 1585 1350 1987   0 0
2366017 2578422308 RUSSIANALLIES 2295 俄罗斯改美元为中国元 https://t.co/gdPKJxOQEH #ВСРФ United Arab Emirates 4 Simplified Chinese 48 2015-11-12T09:39:00 2015-11-12T09:39:00 1231 11339 2701   0 0
2366737 2578422308 RUSSIANALLIES 2295 什么不是“中国梦” https://t.co/3XlMONvYNN #ВСРФ United Arab Emirates 4 Simplified Chinese 48 2015-12-30T23:35:00 2015-12-30T23:35:00 4019 13279 4933   0 0
2366828 2578422308 RUSSIANALLIES 2295 宋鸿兵的《中国梦》 https://t.co/jAj7ZKhBW5 #ВСРФ United Arab Emirates 4 Simplified Chinese 48 2015-12-09T07:54:00 2015-12-09T07:54:00 4001 12588 3908   0 0
2789991 2419886435 VALEYINA_DM 2640 据法新社消息,中国国家主席习近平对古巴革命运动领袖菲德尔•卡斯特罗逝世表示沉痛哀悼。 https://t.co/bzATlEmmHl https://t.co/HIaaOyy5Ch Azerbaijan 7 Simplified Chinese 48 2016-11-26T20:00:00 2016-11-26T20:00:00 805 2391 3324 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 17.311ms · Data source: fivethirtyeight/russian-troll-tweets