home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

106 rows where language = 42

View and edit SQL

Suggested facets: external_author_id, author, region, following, 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
60459 1652987412 ALECMOOOOODY 91 [CAP] 161030 CBX #시우민 https://t.co/jvwHGDHUED https://t.co/CEUKs41mSt United States 2 Korean 42 2016-10-30T14:51:00 2016-10-30T14:52:00 530 908 3629 RETWEET 1 0 1
103400 1679279490 AMELIEBALDWIN 146 미국의 희망 트럼프! (Trump, He will make America Great Again) https://t.co/W4LCxcIB5w United States 2 Korean 42 2016-11-13T12:02:00 2016-11-13T12:02:00 2385 2548 17773 RETWEET 1 0 1
295829 3085147697 BEINGSWARTZ 355 THX.jpg #행복합니다 https://t.co/CNZHdz0IZ7 United States 2 Korean 42 2015-12-09T02:41:00 2015-12-09T02:42:00 118 94 16 RETWEET 1 0 1
399940 1718000594 BOOTH_PRINCE 431 강남야구장 파티파티� #강남풀싸롱01021543560 #강남야구장01021543560 강남매직미러01021453560 강남풀싸롱 #강남야구장 #강남풀싸롱 #IStartCryingWhen United States 2 Korean 42 2016-08-08T13:41:00 2016-08-08T13:41:00 3548 3113 6543 RETWEET 1 1 1
400154 1718000594 BOOTH_PRINCE 431 #강남풀싸롱01021543560 #강남풀싸롱 #강남풀살롱01021543560 #강남풀살롱 #강남풀사롱01021543560 #강남풀사롱 #강남매직미러 〰 강남야구장 〰선릉야구장 〰 #ToFeelBetterI United States 2 Korean 42 2016-09-12T13:44:00 2016-09-12T13:44:00 4701 3469 8680 RETWEET 1 1 1
556212 1877492857 CHESPLAYSCHESS 547 만나면 좋은 뉴스 MBC 김세의 최대현 기자 응원집회 엄마부대 출동 MFN 생중계 2월 22일 https://t.co/V5wenq6nOE United States 2 Korean 42 2017-02-22T09:02:00 2017-02-22T09:02:00 1029 1464 18082 RETWEET 1 0 1
558107 1877492857 CHESPLAYSCHESS 547 10:30 KST 1 WINNER - REALLY REA 2 아이유 - 밤편지 3 하이라이 - 얼굴 찌푸 4 에일리 - 첫눈처럼 5 WINNER - FOOL https://t.co/RIeFYYURlj United States 2 Korean 42 2017-04-06T05:23:00 2017-04-06T05:23:00 1019 1482 19086 RETWEET 1 0 1
798224 2882037326 DANAGEEZUS 634 Why #다른남자말고너 is trending in the USA? United States 2 Korean 42 2015-04-09T10:04:00 2015-04-09T10:04:00 648 828 442   0 0
819820 892000000000000000 DARCYYSTR 652 RT issuestorage: YouTube 동영상 https://t.co/RjHDdT2wP7 세계최고 해병의장대 시범!!ROK Marines Higher quality,military drill show에 United States 2 Korean 42 2017-08-12T03:46:00 2017-08-12T03:46:00 1500 460 1346   0 0
972368 1676481360 EMILEEWAREN 830 [WINNER​ - FAN SIGNING EVENT in HANAM] More Photos @ https://t.co/0tsmXV0D8m #WINNER #위너 #FATENUMBERFOR #REALLYREALLY #릴리릴리 #FOOL #YG https://t.co/GUDwVc4hxd United States 2 Korean 42 2017-04-21T06:18:00 2017-04-21T06:18:00 1834 2080 5819 RETWEET 1 0 1
972436 1676481360 EMILEEWAREN 830 [HAPPY BIRTHDAY DAESUNG] originally posted by https://t.co/XZQ3IOI9MY #DAESUNG #대성 #BIGBANG #빅뱅 #HappyDaesungDay #YG https://t.co/GFijGUuqS7 United States 2 Korean 42 2017-04-25T16:20:00 2017-04-25T16:20:00 1833 2082 5918 RETWEET 1 0 1
979537 723000000000000000 ERDOLLUM 841 #방탄소년단 #erdollum #erdogan #Merkel #Türkei #Deutschland #Germany #Fridaythe13th Freitag der 13 https://t.co/1i9Y6aqzGV Unknown 1 Korean 42 2016-05-13T09:07:00 2016-05-13T09:07:00 2987 991 239   0 0
1036906 3272640600 EXQUOTE 890 .@jones_flossie Flossie @Natsumae026 아야 찬 @nikologicz Neha @LeviWalter2 LeviWalter @LiddellBond LiddellBond http://t.co/4XNB3X7nb5 United States 2 Korean 42 2015-08-14T17:32:00 2015-08-14T17:32:00 2 367 33490   1 0
1037205 3272640600 EXQUOTE 890 .@dpalm30 Dani @bowiezoso Jim @Stroggo BROGGO @ThatGirlAmandaC Amanda @GrumpiGramp GrumpiGramp @SoHighOnOxygen 박민지 http://t.co/kz2We1ATWK United States 2 Korean 42 2015-08-14T20:50:00 2015-08-14T20:50:00 2 369 33790   1 0
1037566 3272640600 EXQUOTE 890 .@Sammie_Snickers Sammie @qoutes_girls fatehahnormah @ylrsto 채야 @BigPayDays tsu @MyGangOrDie_ T @Eviltwin__96 Young http://t.co/CSGPX3Hl2V United States 2 Korean 42 2015-08-15T10:04:00 2015-08-15T10:04:00 2 381 34736   1 0
1037852 3272640600 EXQUOTE 890 .@MarkAJHolcomb Mark @GameLifter Antonio @lejongbae 순딩이♡ @libbylou_x 'IYA @rachael_156 Rachael @Swansslake Natalie http://t.co/oOXdlvxDgN United States 2 Korean 42 2015-08-15T14:16:00 2015-08-15T14:16:00 2 388 35022   1 0
1037853 3272640600 EXQUOTE 890 .@lejongbae 순딩이♡ @MarkAJHolcomb Mark @ChelsTransfer ChelsTransfer @claudialuciee claudia✨ @sehunftpark yixings http://t.co/Kv0Eexy0rk United States 2 Korean 42 2015-08-15T14:16:00 2015-08-15T14:17:00 2 388 35023   1 0
1037980 3272640600 EXQUOTE 890 .@BrionVaughn BrionVaughn @LemonCandy_Love 이-푸-남 @HarrietWinnifre HarrietWinnifred @cookiegigan Cookie http://t.co/RBpmvVdnfi United States 2 Korean 42 2015-08-15T15:49:00 2015-08-15T15:49:00 2 388 35150   1 0
1038182 3272640600 EXQUOTE 890 .@l0lSh4nn shann @gary_1980in Garima @pepper_not meredith @yugcoups 이라 @Azure_v Aaron @MohsinTanveer10 Mohsin http://t.co/d7VdikoKoQ United States 2 Korean 42 2015-08-15T18:02:00 2015-08-15T18:02:00 2 392 35352   1 0
1039152 3272640600 EXQUOTE 890 .@_decyrable 사이라 @25stockhofff Wellcome @talk_NERDII2ME TIFF_EERRSS @juresevenzke Jurese @JamesSierra4 JamesSierra http://t.co/CdV8PkEWzI United States 2 Korean 42 2015-08-15T08:28:00 2015-08-15T08:28:00 2 378 34644   1 0
1039306 3272640600 EXQUOTE 890 .@hamadalkhudhur Hamadoo @firefox3831 alan @nyeonggi 그냥 @AdrianTheGeat Ręmÿ @Wisaniirvin Wisani @porcelaintrees dimi http://t.co/Yqmm4AEs4P United States 2 Korean 42 2015-08-16T10:29:00 2015-08-16T10:29:00 2 416 36465   1 0
1039323 3272640600 EXQUOTE 890 .@RosieJaneSmith1 Rosalie @jaysmyweakness ellen @itshysterie 백혀니가 @sarahx27x Sarah @daniel_tyler18 Daniel http://t.co/C8S9bs5qmU United States 2 Korean 42 2015-08-16T10:50:00 2015-08-16T10:50:00 2 418 36482   1 0
1040920 3272640600 EXQUOTE 890 .@SciPhiKat Katie @dwilt55 David @parkjxysy 박수영 @paoulaw Pao @james_ebo James @bobbyvats bobby http://t.co/l4fv81mZEx United States 2 Korean 42 2015-08-16T09:29:00 2015-08-16T09:29:00 2 417 36415   1 0
1040928 3272640600 EXQUOTE 890 .@eightaenine sansan @TheNeonChaos Neon @msPEACHY_ 녕이만딱좋아하는SbRn❤ @MasterNappi NAPPI @mynameis_cANDIE Andie http://t.co/7B4sLXqUpQ United States 2 Korean 42 2015-08-16T09:38:00 2015-08-16T09:38:00 2 417 36423   1 0
1040936 3272640600 EXQUOTE 890 .@501fahrenheit 리얼 @BelgianKeeper Aaminah @Leatgm Lea @bigfilljewell Phillip @shaexdrew Shanae @lovelyjojo LovelyJoJo http://t.co/zXLrjMk58z United States 2 Korean 42 2015-08-16T09:49:00 2015-08-16T09:49:00 2 417 36431   1 0
1040938 3272640600 EXQUOTE 890 .@tqft9999 tqft @onceuponadonut Emmalyn❀❀ @AnonDesi Anon @amyriutta Amy @NickOsbaldiston Nick @501fahrenheit 리얼 http://t.co/W8ArY2mLN3 United States 2 Korean 42 2015-08-16T09:52:00 2015-08-16T09:52:00 2 417 36433   1 0
1064648 3272640600 EXQUOTE 890 '@_kimshitjongin 이지해 @emlurs13 Emily Curtis @hyunhanier_ εїз @Nicola_Curran Nico @cosxtte effie @AlyySo_Pretty ❤️ http://t.co/q4Z1RVRQR1' United States 2 Korean 42 2015-08-04T11:55:00 2015-08-04T11:55:00 2 352 29893   1 0
1064790 3272640600 EXQUOTE 890 '@ElishaPhoebe 엑소라이 @Shannon_Piel Shannon_Piel @KleeMargaret Lacy ✌️Laplante @TooDieFour Martin Luh Da Kang http://t.co/eK09yikyY5' United States 2 Korean 42 2015-08-04T14:07:00 2015-08-04T14:07:00 2 352 30035   1 0
1064906 3272640600 EXQUOTE 890 '@360LayupLord SCXBEY KLVN @natBAROramji BARO 병철입니다. @ZandraStarks pepe's lil minion @KissesfromMaria KissesfromMaria http://t.co/EBs5ESN8xm' United States 2 Korean 42 2015-08-04T15:46:00 2015-08-04T15:46:00 2 353 30152   1 0
1065105 3272640600 EXQUOTE 890 '@haylda ×해일다× @annachainknee Anna Cheney @samanthaannn24 Sam Clements @salimchaudhry Sammy ch @livMarshment Lïv http://t.co/2uYiQ8qQWD' United States 2 Korean 42 2015-08-04T18:39:00 2015-08-04T18:39:00 2 355 30351   1 0
1065388 3272640600 EXQUOTE 890 '@riklepine Rik Lepine @grumpyctc Grumpy Cat @OfficeSceneSA OfficeScene @hanhyuns 에리들생일축하합니다 @voightm Mike Voight http://t.co/vkTost7O1S' United States 2 Korean 42 2015-08-04T22:03:00 2015-08-04T22:03:00 2 358 30600   1 0
1065504 3272640600 EXQUOTE 890 '@AustinTodd11 AustinTodd @YPKLLNEM 옛히에 Yeshie 벤아 Peña @whatupsash ♡♡ @NVelasquez Nicolas Velasquez @h_sawadi hsawadi http://t.co/ZZIjeicEIn' United States 2 Korean 42 2015-08-04T23:53:00 2015-08-04T23:53:00 2 358 30717   1 0
1065734 3272640600 EXQUOTE 890 '@JefferyDelMinaj J Seals @Ajay_Gadellu Ajay Gadellu @SusanEacock Susan Eacock @aujula Emi Sarangae 에미 사랑해 http://t.co/GlJn5yTSlP' United States 2 Korean 42 2015-08-04T06:37:00 2015-08-04T06:38:00 2 350 29766   1 0
1065835 3272640600 EXQUOTE 890 '@hemantRworld Hemant ♛ Rawat @seokjinxjams 대박!!! @vampslays ⠀⠀⠀ ⠀⠀⠀⠀⠀⠀ ⠀⠀şerife @TheWaterside1 Aylesbury Waterside http://t.co/V2NmI9ykul' United States 2 Korean 42 2015-08-04T08:52:00 2015-08-04T08:52:00 2 351 29866   1 0
1066439 3272640600 EXQUOTE 890 '@LUCKYH0NGCHUL 무한도전 @scottrgordon Scott Gordon @gelicareidaxx Gel @ackiriakides Arlena Kiriakides @big7x7 Tracy I http://t.co/1gDVNhcP7g' United States 2 Korean 42 2015-08-05T01:48:00 2015-08-05T01:48:00 2 359 30832   1 0
1067121 3272640600 EXQUOTE 890 The @TheHammerOfFact 침침찌민이둘리박뿡♡ @Jiminority Jessie @jessie_paul 550 @550KTRS Dr @DrCarsonLiu http://t.co/5MURoF1AKN https://t.co/qk2n6g5aDc United States 2 Korean 42 2015-08-06T13:47:00 2015-08-06T13:47:00 2 354 32498   1 0
1067181 3272640600 EXQUOTE 890 CynTinny @CynTinny Rie @SuPreeemoo 아레이 @TBVHVMIN GOdogs @GOdogsProject Adam @Shiningboy http://t.co/SVKN4y9PCW https://t.co/BGZMWc0YHk United States 2 Korean 42 2015-08-06T14:45:00 2015-08-06T14:45:00 2 354 32560   1 0
1067482 3272640600 EXQUOTE 890 slam @SAMe_damntime Rissa_Christine @Rissa_Christine 리자 @callmerizza Spencer @spencerrascoff http://t.co/QI6Wkpiu5a https://t.co/PX9KLYxcx2 United States 2 Korean 42 2015-08-06T19:38:00 2015-08-06T19:39:00 2 357 32862   1 0
1093215 3254273689 FINDDIET 914 NexisHexus @FC_WitchParty 아일라 @ailaling1017 kiree✨❤ @KireeKee ӤԐĪƇ♡ @neicosupreme http://t.co/ArAhtl23YP https://t.co/rUHVoM2Qff United States 2 Korean 42 2015-08-10T11:52:00 2015-08-10T11:52:00 3 258 27090 QUOTE_TWEET 2 1 1
1093402 3254273689 FINDDIET 914 Myra @MyraPopplestone PACK-member @wardy_san briajuana @briajuana 방탄의 @IceCreamKookiee http://t.co/tzxO0xgAvL https://t.co/TafIBxLlNG United States 2 Korean 42 2015-08-10T15:09:00 2015-08-10T15:09:00 3 258 27278 QUOTE_TWEET 2 1 1
1093463 3254273689 FINDDIET 914 Kathy @vintageweave 소녀시대 @fazlianarahim 420 @justmaryjuona Devin @SynthReBorn http://t.co/EoKfPSvUpm https://t.co/ULeCJI4K2y United States 2 Korean 42 2015-08-10T15:55:00 2015-08-10T15:55:00 3 258 27339 QUOTE_TWEET 2 1 1
1093755 3254273689 FINDDIET 914 sydney @SydneyWolf0317 마마무 @ohnoyoongi DingDongBobo'sGone @HSAddict Sharon @jaynie_sj http://t.co/7AZJHAZxI4 https://t.co/Gl1RKijNYM United States 2 Korean 42 2015-08-10T19:54:00 2015-08-10T19:54:00 3 265 27632 QUOTE_TWEET 2 1 1
1093992 3254273689 FINDDIET 914 laura @Laura_Kane1 Kelsey @Kellsey_K l @_laurenoconnor 사랑 @curtisboiling Emily @emilyharvey9 http://t.co/cNnHVuO2uR https://t.co/KxrsfcjkUF United States 2 Korean 42 2015-08-10T22:12:00 2015-08-10T22:12:00 3 267 27799 QUOTE_TWEET 2 1 1
1094031 3254273689 FINDDIET 914 Ashley @a_zigga Melanie @arts_hound pissy @atcmango Rayra @brightldr 김매진 @Kimaee_ United States 2 Korean 42 2015-08-10T22:45:00 2015-08-10T22:45:00 3 267 27839   1 0
1094049 3254273689 FINDDIET 914 Karrie @karrieann2299 Breeee @BreannaLeng #비에이피힘내 @daetaebak Anahera @AnaheraOrmon http://t.co/uUiMkUUEId https://t.co/HocPpzDf64 United States 2 Korean 42 2015-08-10T23:00:00 2015-08-10T23:01:00 3 267 27857 QUOTE_TWEET 2 1 1
1094666 3254273689 FINDDIET 914 자스민 @Juicyeapplemint ShangJun @ShangJun21 Jed-Luke @zDoonger Jennifer @JenSunshine http://t.co/ZluM5BjspE https://t.co/d1tth6kBDS United States 2 Korean 42 2015-08-11T13:58:00 2015-08-11T13:58:00 3 294 28827 QUOTE_TWEET 2 1 1
1094987 3254273689 FINDDIET 914 Darkeese @LadiiMelodii Aimee @aimee_maree Michael @MAS1244 Jose @JoseAlvRi 개자식 @t0uche_am0re http://t.co/vBonxX8TIG https://t.co/dk6G83KCrZ United States 2 Korean 42 2015-08-11T04:26:00 2015-08-11T04:26:00 3 273 28210 QUOTE_TWEET 2 1 1
1095016 3254273689 FINDDIET 914 '@peaceminusji Atoosa @iwrite4u2 Yojimbo @kageyojimbo 하쿠나마타타 @Daewhore_ Anitys @Anitys_ http://t.co/YHPGWGUzxN https://t.co/3MHInp2BRQ' United States 2 Korean 42 2015-08-11T04:52:00 2015-08-11T04:52:00 3 274 28239 QUOTE_TWEET 2 1 1
1095637 3254273689 FINDDIET 914 http://t.co/wbJsTb4NnN Oluwatose @OluwatoseGT 쳅에 @hoseokmafia Stacy @StacyStacy93 brooke @br00keaguirre https://t.co/h8VXa0tu41 United States 2 Korean 42 2015-08-12T13:57:00 2015-08-12T13:59:00 3 316 29805 QUOTE_TWEET 2 1 1
1095824 3254273689 FINDDIET 914 http://t.co/KwdrJOCTeG Mark @gorveatte YUVIA @SHUTUPYUVIA Anita @AnitaHBachmann august @sivad___ 애나벨리 @HoseoksHope https://t.co/WOyde1H30J United States 2 Korean 42 2015-08-12T16:13:00 2015-08-12T16:13:00 3 317 29991 QUOTE_TWEET 2 1 1

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