home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

445 rows where language = 22

View and edit SQL

Suggested facets: region, 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
7549 4036537452 4MYSQUAD 10 K for KARMA bitch! https://t.co/8iwFxNRjqI #Flint #FlintWaterCrisis https://t.co/CpMTk9SrEu United States 2 Turkish 22 2016-03-29T01:15:00 2016-03-29T01:15:00 4401 3661 1217   0 0
18290 2253746724 ABUNUWASA 34 Amerika her zaman aptallığını gösteriyor! Böyle şeyler nasıl yapabilirler? https://t.co/knDuE7HkSP @erdalgokhan Israel 6 Turkish 22 2015-12-10T13:33:00 2015-12-10T13:33:00 7 469 4441   1 0
19844 1652138929 ACEJINEV 38 Maç Sonucu \| Fenerbahçe 86-79 EA7 Milano #FNBEA7 https://t.co/520TqlgZo5 United States 2 Turkish 22 2017-01-06T20:01:00 2017-01-06T20:01:00 791 908 3408 RETWEET 1 0 1
36090 1660186831 ADRGREERR 54 BLOODBATH ISTANBUL AIRPORT... https://t.co/Ka7opLsSZL United States 2 Turkish 22 2016-06-29T14:25:00 2016-06-29T14:25:00 683 524 1282 RETWEET 1 0 1
56976 3083086600 ALDRICH420 90 #RejectedChristmasDecorations Baby Hitler United States 2 Turkish 22 2015-12-07T15:23:00 2015-12-07T15:23:00 936 528 427 RETWEET 1 0 1
71591 4438808536 ALEXMMYER 103 #stopptterror Teröre boyun eğmeyeceğiz. Başımız sağolsun. #Ankara #Istanbul #PrayForPeace https://t.co/3FhuUPmlMo Germany 13 Turkish 22 2016-06-09T10:23:00 2016-06-09T10:23:00 198 10 23 RETWEET 1 0 1
71598 4438808536 ALEXMMYER 103 #stopptterror Terör burada..orada..her yerde! #prayforiraq #Istanbul #Baghdad https://t.co/hjKI5686gN Germany 13 Turkish 22 2016-06-09T10:29:00 2016-06-09T10:29:00 198 10 28 RETWEET 1 0 1
80003 2243468839 ALINALINKI_ 117 .@ProstoMilochka Istanbul @kancv @intlspectator https://t.co/KmTFmtQK2U Unknown 1 Turkish 22 2015-11-24T11:03:00 2015-11-24T11:03:00 180 257 2427 RETWEET 1 1 1
86323 2616344667 AMANDAVGREEN 138 Drillbit Trailer #RedneckAMovie @midnight United States 2 Turkish 22 2017-01-25T11:54:00 2017-01-25T11:54:00 4711 5410 5968   0 0
86548 2616344667 AMANDAVGREEN 138 #famouscreatures Barack OLama https://t.co/zO6RCR2BqB United States 2 Turkish 22 2016-10-10T09:05:00 2016-10-10T09:05:00 2817 3263 3986 RETWEET 1 0 1
89181 2616344667 AMANDAVGREEN 138 Bank Girl @midnight #RichMovies United States 2 Turkish 22 2017-07-13T08:14:00 2017-07-13T08:15:00 5496 7118 6752   0 0
91216 890000000000000000 AMBERLINETR 142 RT RitaPanahi: Straya! 🇦🇺🇦🇺🇦🇺 https://t.co/7BhFoc4VfH #amb United States 2 Turkish 22 2017-08-01T23:39:00 2017-08-01T23:40:00 2955 188 712   0 0
117768 1679279490 AMELIEBALDWIN 146 #İstanbul'da 🌷 zamanı... 12. #İstanbul 🌷Festivali, 1-30 Nisan 2017 🇹🇷 @istanbulbld https://t.co/rGwRBg3J21 United States 2 Turkish 22 2017-04-12T03:36:00 2017-04-12T03:36:00 2295 2788 36447 RETWEET 1 0 1
119977 1679279490 AMELIEBALDWIN 146 Mehmet Şimşek: Hukukun iyi işlediği ülkelerde iş yapmak kolay ama kar marjı düşük https://t.co/8G5DjwSg7o https://t.co/6MKaeidslK United States 2 Turkish 22 2017-04-27T18:42:00 2017-04-27T18:42:00 2287 2854 38829 RETWEET 1 0 1
121709 1679279490 AMELIEBALDWIN 146 #Biyokütle enerjisi nedir? https://t.co/JyJy2js83o #yenilenebilirenerji #renewableenergy https://t.co/YLRaFCRjBJ United States 2 Turkish 22 2017-05-02T17:08:00 2017-05-02T17:09:00 2284 2858 39540   0 0
121899 1679279490 AMELIEBALDWIN 146 Patient zero olcekti, düzeltir özür dilerim https://t.co/dBTQWkWhi1 United States 2 Turkish 22 2017-05-03T20:27:00 2017-05-03T20:27:00 2284 2856 39727   0 0
127442 1679279490 AMELIEBALDWIN 146 20 fotoğrafla muhteşem yemek sanatı https://t.co/928TYombnM United States 2 Turkish 22 2016-09-18T06:10:00 2016-09-18T06:10:00 1479 2194 7708 RETWEET 1 0 1
148693 2878166306 ANDYHASHTAGGER 187 #InappropriateHoneymoonLocations Kim Davis bedroom https://t.co/ABMxVkRj3i United States 2 Turkish 22 2016-01-03T13:15:00 2016-01-03T13:15:00 17236 17695 5055   1 0
150056 2878166306 ANDYHASHTAGGER 187 #RejectedChristmasDecorations Baby Hitler United States 2 Turkish 22 2015-12-07T15:16:00 2015-12-07T15:18:00 16305 17262 4509 RETWEET 1 1 1
154726 2878166306 ANDYHASHTAGGER 187 #ObamaNextJob NRA spokesman United States 2 Turkish 22 2016-06-21T14:54:00 2016-06-21T14:54:00 19802 22520 11464 RETWEET 1 1 1
197283 1712506765 ANWARGAFUR 243 hiç kutsallık Amerika'da kaldı https://t.co/ks5fiiz7LT @SinaAfra Israel 6 Turkish 22 2015-12-10T13:34:00 2015-12-10T13:34:00 12 199 27   1 0
198444 87588938 ANZGRI 246 1829’daki bir diplomatik kriz sırasında elçiliği basan bir grup öfkeli İranlı, Rus büyükelçiyi öldürmüştü. United States 2 Turkish 22 2016-12-19T23:27:00 2016-12-19T23:27:00 32 1263 64736   0 0
198459 87588938 ANZGRI 246 '@AlabedBana (Bana) ve ailesi #CumhurbaşkanıErdoğan ve Sayın #EmineErdoğan tarafından #Külliye 'de ağırlandı :) https://t.co/ivf5XGAwyP' United States 2 Turkish 22 2016-12-21T13:24:00 2016-12-21T13:24:00 32 1262 64764 RETWEET 1 0 1
207059 4440342138 ARGENTINACATLE1 256 Böyle zor bir dönemde Türkiye’nin güvenliği için MİT Teşkilatının büyük bir özveriyle çalıştığını unutmayalım. United States 2 Turkish 22 2016-03-21T10:33:00 2016-03-21T10:33:00 0 77 36 RETWEET 1 1 1
207454 4440342138 ARGENTINACATLE1 256 Serhat, Türk Bayrağını @Eurovision Sahnesine Taşıdı #Eurovision @serhathpo https://t.co/aOqwYJrlui https://t.co/ynCp9jESD0 United States 2 Turkish 22 2016-05-08T13:41:00 2016-05-08T13:41:00 213 20 217 RETWEET 1 1 1
207457 4440342138 ARGENTINACATLE1 256 Eurovision 'da Türk şarkıcı Serhat için oylar #SanMarino 'ya... 10 Mayıs 'ta yarı final ve 8.sıra #eurovision https://t.co/3S401Xx8Hp United States 2 Turkish 22 2016-05-08T13:41:00 2016-05-08T13:41:00 213 20 220 RETWEET 1 1 1
207502 4440342138 ARGENTINACATLE1 256 Türkiye Finans Yeni İnternet Şubesi harika hediyeler kazandırıyor, siz de kullanın, kazanın! https://t.co/Zb3S2GLfM5 https://t.co/4TKuVj1Gmr United States 2 Turkish 22 2016-06-12T02:13:00 2016-06-12T02:13:00 360 22 787 RETWEET 1 1 1
207503 4440342138 ARGENTINACATLE1 256 Dünya tarihinde yeni bir çağı açan kahramanlarımızı saygıyla anıyoruz. İstanbul’un Fethi’nin 563. yılı kutlu olsun! https://t.co/bilgry6SYZ United States 2 Turkish 22 2016-06-12T02:13:00 2016-06-12T02:13:00 360 22 783 RETWEET 1 1 1
207504 4440342138 ARGENTINACATLE1 256 Yeni internet şubemizin açıldığı hafta Erenköy Şubesi çalışanlarımıza küçük bir şaka yaptık. :) https://t.co/9dLC9772Lk United States 2 Turkish 22 2016-06-12T02:13:00 2016-06-12T02:13:00 360 22 785 RETWEET 1 1 1
207505 4440342138 ARGENTINACATLE1 256 Huzurlarınızda Türkiye Finans Yeni İnternet Şubesi! https://t.co/CN2MPPUbhD https://t.co/yM4BGRsdCi United States 2 Turkish 22 2016-06-12T02:13:00 2016-06-12T02:13:00 360 22 786 RETWEET 1 1 1
207506 4440342138 ARGENTINACATLE1 256 Türkiye Finans Yeni İnternet Şubesi’nde Nissan Juke kazanma fırsatı! https://t.co/u97OR6iItR https://t.co/Or6FIjnBMo United States 2 Turkish 22 2016-06-12T02:13:00 2016-06-12T02:13:00 360 22 784 RETWEET 1 1 1
207507 4440342138 ARGENTINACATLE1 256 Türkiye Finans Yeni İnternet Şubesi’ni denemenin tam zamanı! https://t.co/u97OR6Ajlp https://t.co/TUR0ScRR37 United States 2 Turkish 22 2016-06-12T02:14:00 2016-06-12T02:14:00 360 22 788 RETWEET 1 1 1
211159 2582643409 ARKADII_TROFIM 264 Rusya, Halep'e bir tabur askeri polis gönderdi ! (+VİDEO) https://t.co/tjic5uLDsn https://t.co/zWWoHxJGJJ Azerbaijan 7 Turkish 22 2016-12-23T18:54:00 2016-12-23T18:55:00 261 2033 2632 RETWEET 1 0 1
213966 1671936266 ARM_2_ALAN 269 PRO WRESTLER! https://t.co/HU1rxsuo4b United States 2 Turkish 22 2015-06-11T19:33:00 2015-06-11T19:34:00 67 165 8598 RETWEET 1 0 1
235654 4724544963 ATIF_SHAIKH_ME 294 Hail Kitler. https://t.co/YBwUI0uNcE United States 2 Turkish 22 2016-02-07T02:24:00 2016-02-07T02:25:00 1112 68 68 RETWEET 1 1 1
267635 1658420976 BAOBAEHAM 326 ılıll\|̲̅̅●̲̅̅\|̲̅̅=̲̅̅\|̲̅̅●̲̅̅\|llılı♫♪*#IndieMusic sounds looks good on https://t.co/SYUKq4TRAq¨*•.¸¸❤¸¸.•*¨*•♫♪•.¸¸❤¸¸ #PVPR United States 2 Turkish 22 2016-12-31T16:57:00 2016-12-31T16:57:00 820 1064 3541 RETWEET 1 0 1
268292 1658420976 BAOBAEHAM 326 Abe Lincoln was a hustler???? https://t.co/91ZF0o1Fob #mlmtips #residualincome #homebiz #mlm #onlineincome United States 2 Turkish 22 2017-02-28T08:42:00 2017-02-28T08:42:00 814 1093 4861 RETWEET 1 0 1
291938 895000000000000000 BEEBCLAPTT 350 Engin sarıaslan Retweet RT RT_America to #MAGA! https://t.co/Da9iAx59oN 11236 https://t.co/Da9iAx59oN https://t.co/n0lj14PwS2 Unknown 1 Turkish 22 2017-08-11T06:22:00 2017-08-11T06:22:00 0 3 298   0 0
292092 895000000000000000 BEEBCLAPTT 350 Halil Apaydın Retweet RT RT_America to #MAGA! https://t.co/R0CmcwkzLp 233308 https://t.co/R0CmcwkzLp https://t.co/21NL6lOLwz Unknown 1 Turkish 22 2017-08-12T19:50:00 2017-08-12T19:50:00 0 1 566   0 0
292117 895000000000000000 BEEBCLAPTT 350 O'bir Adanalı Retweet RT RT_America to #MAGA! https://t.co/fNZW9AjFO9 2280 https://t.co/fNZW9AjFO9 https://t.co/TmsvLVEDHi Unknown 1 Turkish 22 2017-08-12T21:58:00 2017-08-12T21:58:00 0 1 589   0 0
292708 895000000000000000 BEEBCLAPTT 350 Alim Yılmaz Retweet RT RT_America to #MAGA! https://t.co/Xe8ULzCNQm 145422 https://t.co/Xe8ULzCNQm https://t.co/bndFiiltHg Unknown 1 Turkish 22 2017-08-15T17:54:00 2017-08-15T17:54:00 0 1 1231   0 0
292819 895000000000000000 BEEBCLAPTT 350 Anıl Kansu Retweet RT RT_America to #MAGA! https://t.co/eFhz7yFjlr 17813 https://t.co/eFhz7yFjlr https://t.co/CrVNfadl3z Unknown 1 Turkish 22 2017-08-15T09:08:00 2017-08-15T09:08:00 0 1 1111   0 0
292999 895000000000000000 BEEBCLAPTT 350 aşkın Retweet RT RT_America to #MAGA! https://t.co/HngyoWkaNK 2717 https://t.co/HngyoWkaNK https://t.co/qhiOrBmbKI Unknown 1 Turkish 22 2017-08-16T06:38:00 2017-08-16T06:38:00 0 1 1323   0 0
293384 895000000000000000 BEEBCLAPTT 350 Serap Kayıkçı Retweet RT RT_America to #MAGA! https://t.co/tRTOfiznfv 4624 https://t.co/tRTOfiznfv https://t.co/0HLowziqdv Unknown 1 Turkish 22 2017-08-21T18:26:00 2017-08-21T18:26:00 998 200 1864   0 0
296994 3293457257 BELINDA_BOURG 360 #Inked #Tattoo Sunday Sunday � #inked #rig #fit #model #sleeve http://t.co/5t890ywInN http://t.co/LvYbb1kiU7 United States 2 Turkish 22 2015-06-20T23:22:00 2015-06-20T23:22:00 971 140 95 RETWEET 1 1 1
300486 715000000000000000 BERKHOFF85 371 Tja, sie ist halt gerne Kanzlerin... #Merkel #CDU #G20 #Scholz https://t.co/LO5gupZmOD Unknown 1 Turkish 22 2017-07-16T16:52:00 2017-07-16T16:52:00 2278 2396 2596   0 0
300498 715000000000000000 BERKHOFF85 371 Türkischer #Polizist rettet einen türkischen Soldaten davor, gelyncht zu werden #Türkei #Turkey #Volk #Erdogan https://t.co/8WsWQ9Zpol Germany 13 Turkish 22 2016-07-17T07:46:00 2016-07-17T07:46:00 1514 1215 719 RETWEET 1 0 1
300500 715000000000000000 BERKHOFF85 371 Das ist die "türkische Demokratie"�� https://t.co/oDflBy8hCk Germany 13 Turkish 22 2016-07-17T09:22:00 2016-07-17T09:22:00 1514 1216 721 QUOTE_TWEET 2 0 1
300501 715000000000000000 BERKHOFF85 371 Das ist die "türkische #Demokratie" �� #Putschisten #Türkei #Turkey #Erdogan #Volk https://t.co/oDflBy8hCk Germany 13 Turkish 22 2016-07-17T09:24:00 2016-07-17T09:24:00 1514 1216 721 QUOTE_TWEET 2 0 1
301409 715000000000000000 BERKHOFF85 371 #Erdogan´s„Stasi“ bedroht Türken in Deutschland #Türkei #fernsehgarten #presseclub #Gaziantep #Merkel #Gülen https://t.co/N3CFDddNCq Germany 13 Turkish 22 2016-08-21T09:50:00 2016-08-21T09:51:00 4414 1962 1239   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 67.61ms · Data source: fivethirtyeight/russian-troll-tweets