home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

59 rows where language = 44

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
77877 3083923623 ALFREDBENBEN 111 #GOPDebate be like #GOPStop https://t.co/GbQHO9DhO2 United States 2 Urdu 44 2015-11-11T05:17:00 2015-11-11T05:17:00 80 83 433   0 0
85424 1694331349 ALVA_MC_GHEE 131 HEY MICHELE, SHUT UP..... JUST SHUT UP! http://t.co/9IWo3vDRcO United States 2 Urdu 44 2015-05-29T23:26:00 2015-05-29T23:26:00 218 111 516 RETWEET 1 0 1
96341 1679279490 AMELIEBALDWIN 146 Ye bhi ek baat hai adaavat ki / Roza rakkha hai jo humne daawat ki. #AmirMinai @lohanaprem @Nilz_97 @VishalSatra1 @avd_kvp @SaptakSnehal United States 2 Urdu 44 2017-01-19T05:32:00 2017-01-19T05:32:00 2345 2725 25975 RETWEET 1 0 1
109590 1679279490 AMELIEBALDWIN 146 "پیپلزپارٹی 2018 تک ریوائیو کیا سروائیو بھی کر جائے تو یہ بہت بڑی بات ہوگی۔ ظفرعلی شاہ https://t.co/7NTvTFGyRI https://t.co/qQ0ht1HQcV United States 2 Urdu 44 2016-12-05T12:07:00 2016-12-05T12:07:00 2365 2607 20487 RETWEET 1 0 1
126552 1679279490 AMELIEBALDWIN 146 کچھ لوگ اتنے مذہبی ! ہوتے ہیں کہ�� جوتا �پسند کرنے کےلیے بھی مسجد� کا رخ �کرتے ہیں �� (مشتاق احمد یوسفی) #حفظہ_مظہر United States 2 Urdu 44 2016-09-18T13:01:00 2016-09-18T13:03:00 1479 2211 8321 RETWEET 1 0 1
149260 2878166306 ANDYHASHTAGGER 187 '@David_in_Dallas hot hot hot!' United States 2 Urdu 44 2015-11-01T16:56:00 2015-11-01T16:57:00 14782 16465 3855   1 0
293241 895000000000000000 BEEBCLAPTT 350 نوائےجوہر Retweet RT RT_America to #MAGA! https://t.co/t7bdeJRp1G 53781 https://t.co/t7bdeJRp1G https://t.co/K1oKNFPB1b Unknown 1 Urdu 44 2017-08-19T17:33:00 2017-08-19T17:33:00 998 138 1708   0 0
472564 2613808780 CANDEYCHANEY 496 Pata nahi tareef kar rahe ho ya mazak udha rahe ho � #PappuQuotes https://t.co/rjiWuPa39n United States 2 Urdu 44 2016-01-17T08:58:00 2016-01-17T08:58:00 1102 1531 1223 RETWEET 1 0 1
483818 1627699074 CANNONSHER 498 9 most unhealthy chain restaurant meals http://t.co/zYGjtHxpPc #life #news United States 2 Urdu 44 2015-06-04T17:53:00 2015-06-04T17:53:00 0 115 2642 RETWEET 1 0 1
484348 1627699074 CANNONSHER 498 #ComplimentYourselfIn4Words I won't shut up http://t.co/69CIAogRTV United States 2 Urdu 44 2015-06-04T05:33:00 2015-06-04T05:34:00 0 108 2256 RETWEET 1 0 1
510661 1629828379 CASSISHERE 512 Shut down DHS and TSA! #SurveillanceDay United States 2 Urdu 44 2015-06-02T18:51:00 2015-06-02T18:51:00 114 268 882   0 0
531071 892000000000000000 CHAASNTR 526 Oh shut up. https://t.co/y1tvl7ptwi Unknown 1 Urdu 44 2017-08-02T16:21:00 2017-08-02T16:21:00 1958 692 906 QUOTE_TWEET 2 0 1
563414 1877492857 CHESPLAYSCHESS 547 #MonsterABand Drac Sabbath United States 2 Urdu 44 2015-06-04T14:52:00 2015-06-04T14:52:00 74 152 2313 RETWEET 1 0 1
655434 1710804738 COOKNCOOKS 598 HEY MICHELE, SHUT UP..... JUST SHUT UP! http://t.co/9IWo3vDRcO United States 2 Urdu 44 2015-05-29T22:28:00 2015-05-29T22:30:00 29 110 696 RETWEET 1 0 1
693552 1668307436 CURTISBIGMAN 611 Pata nahi tareef kar rahe ho ya mazak udha rahe ho � #PappuQuotes https://t.co/rjiWuPa39n United States 2 Urdu 44 2016-01-17T09:05:00 2016-01-17T09:05:00 1747 1502 1777 RETWEET 1 0 1
887712 2573225349 DOMINICVALENT 734 #FUKUSHIMA2015 #NUKRAINE POOR UKRANIANS… United States 2 Urdu 44 2015-01-04T10:55:00 2015-01-04T10:56:00 377 33 245   0 0
897486 1720117201 DONNABRIVERA 741 '@SanjayAzadSln @ArvindKejriwal @aSoulRebellion Hawala kaand main sab AAP involved aur delhi ka paissa aiyaashi main' United States 2 Urdu 44 2017-01-06T02:18:00 2017-01-06T02:18:00 1995 1736 4071 RETWEET 1 0 1
897489 1720117201 DONNABRIVERA 741 '@SanjayAzadSln @ArvindKejriwal @aSoulRebellion Hawala kaand main sab AAP involved aur delhi ka paissa aiyaashi main' United States 2 Urdu 44 2017-01-06T02:18:00 2017-01-06T02:18:00 1995 1736 4071 RETWEET 1 0 1
907158 1833223908 DOROTHIEBELL 748 Good job ��� lene ke dene pad Gaye ! https://t.co/pYAm963RgF United States 2 Urdu 44 2016-09-14T12:07:00 2016-09-14T12:07:00 1070 1472 2005 RETWEET 1 0 1
999327 2533653547 EVAGREEN69 870 '@Humoritarian poor piggies' United States 2 Urdu 44 2015-06-09T18:11:00 2015-06-09T18:11:00 327 156 767   0 0
1011794 1964340318 EXQUOTE 890 http://t.co/BZRbA7G68N Hum bhi karte hai roza khol k workout @strssdout @Worth_dls @newlostitall @peachbits @MilfsToDate @SwimSSCRoyals United States 2 Urdu 44 2015-07-11T23:28:00 2015-07-11T23:28:00 2 149 5479   1 0
1012653 1964340318 EXQUOTE 890 http://t.co/cEWazBXPoT Hassan AB exercise bhi kre? @GerardApril1 @Roontkk23 @menndddi @ValBradshaw @PaulFulford @tgrid62 @championchap United States 2 Urdu 44 2015-07-12T12:43:00 2015-07-12T12:43:00 2 163 6407   1 0
1023741 1964340318 EXQUOTE 890 http://t.co/HKpPEYY4K2 Raatbhar workout karne ke baad subha gym jaake sonaa hi hoga ; @RonySaleh @Bryanrq16 @HitManQuan_8 @getyoua_lani United States 2 Urdu 44 2015-07-19T23:34:00 2015-07-19T23:34:00 2 258 16318   1 0
1034633 3272640600 EXQUOTE 890 http://t.co/ozaudgbi9T Atleast we run Chalo exercise bhi ho gaya @BallyshonogFarm @Bwonwen @SaekoKiller @gbemy01 @madee_2lean @MaKupsy United States 2 Urdu 44 2015-07-31T06:20:00 2015-07-31T06:21:00 2 350 26502   1 0
1036958 3272640600 EXQUOTE 890 .@PierceBarnes2 PierceBarnes @JacobsMadeline1 JacobsMadeline @TomStyles92 Tom @StreetTeamAC ಠ_ಠ @mahamnasirr پاکستان http://t.co/jdxZmuwQcz United States 2 Urdu 44 2015-08-14T18:06:00 2015-08-14T18:06:00 2 369 33542   1 0
1038622 3272640600 EXQUOTE 890 .@Rick0424 Ricky @greedygriz Griz @TeritaTweets Yogi @_Pardis_ پردیس @Beth_Veitch Beth @diazmarymonster Mary http://t.co/uzi78PrTZh United States 2 Urdu 44 2015-08-15T22:06:00 2015-08-15T22:06:00 2 403 35711   1 0
1081771 3254273689 FINDDIET 914 http://t.co/pNnvSqmtxT Yaar ye log sir films k liye exercise shuru kartay hain or phir chor detay hain. @SoDope_Rail @_whoiskitty @JadeGray United States 2 Urdu 44 2015-07-20T06:39:00 2015-07-20T06:39:00 3 81 7726   1 0
1096992 3254273689 FINDDIET 914 Mykahla @MykahlaW پریا @pariapeyda Tabi @Tabiii_Fae ginger @toricheyanne ©hase @Fav_White_Boy http://t.co/X6YT9lrcdc https://t.co/FtT2JPJ7wD United States 2 Urdu 44 2015-08-12T05:49:00 2015-08-12T05:50:00 3 301 29298 QUOTE_TWEET 2 1 1
1097112 3254273689 FINDDIET 914 lyd @lyddallas_ Waldo @SiirWaldo صور @pao3356   @YangAfizie Allergy @foodallergyuk ✨ @TGV___ http://t.co/qjMg0kcuxv https://t.co/mcbeZ8eA7x United States 2 Urdu 44 2015-08-12T07:21:00 2015-08-12T07:21:00 3 302 29418   1 0
1099948 3254273689 FINDDIET 914 .@IAmDaBaller Booster @colletemily Emily @nabilaaris NZ @rinaaizm ☁️RINA☁️ @karim98_ کریم @PrincessDomi_15 DomK http://t.co/bbcXIrhMUa United States 2 Urdu 44 2015-08-15T05:15:00 2015-08-15T05:15:00 4 397 33368   1 0
1102654 3254273689 FINDDIET 914 . @Sc5pe sarah✨ @sarah_t15 JIAJIACHEN @jiajiachen59 SurAbhi!!! @7surabhiverma http://t.co/CejvOIlb1E https://t.co/hP2aYabb37 United States 2 Urdu 44 2015-08-05T13:31:00 2015-08-05T13:31:00 3 196 21720   1 0
1104364 3254273689 FINDDIET 914 ریال @royalmontgomery Taylor @taylordammann10 Tanner @tanner_lyn Queen @bringmenoodles http://t.co/PzVIeBXClV https://t.co/vNK1q2nxY0 United States 2 Urdu 44 2015-08-06T02:11:00 2015-08-06T02:12:00 3 205 22492   1 0
1105241 3254273689 FINDDIET 914 DerosaKirk @DerosaKirk جاسم @simplyjassim__ Netalie @netaliek Michael @DreamerDavis12 http://t.co/6Dl1KysJpu https://t.co/2etBJ74Zlp United States 2 Urdu 44 2015-08-07T17:49:00 2015-08-07T17:52:00 3 227 24033   1 0
1107740 3254273689 FINDDIET 914 Smith @_SmithFit_ RICHARD @4NEWTON Harry @harry_ppotter K @KMWeiland زوہیب_ @Peer_SaaEn http://t.co/93Iu4VGIG2 https://t.co/puNuuT4Phg United States 2 Urdu 44 2015-08-09T22:23:00 2015-08-09T22:23:00 3 259 26510 QUOTE_TWEET 2 1 1
1122761 3241517419 FREEDISCUSS 934 To @kirtisaxena999 AAP ki kuda politics, Same as Modi's swacch bharat abhiyan. @Stylish_Arya http://t.co/fBBLvGjRee United States 2 Urdu 44 2015-06-14T10:33:00 2015-06-14T10:34:00 3 14 1091   0 0
1131399 3252787160 FUNDDIET 943 http://t.co/w9Zp0STXog Workout bhi karna padega @CNASTIER @Rileighhhhhhhhh @MissMartecia3 @paizon63 @JGangwisch13 @leenabeana_12 @Mimiekkins United States 2 Urdu 44 2015-07-14T14:11:00 2015-07-14T14:11:00 5 431 17488   1 0
1144598 1674083671 GAB1ALDANA 947 Pata nahi tareef kar rahe ho ya mazak udha rahe ho � #PappuQuotes https://t.co/rjiWuPa39n United States 2 Urdu 44 2016-01-17T09:33:00 2016-01-17T09:33:00 1296 1252 899 RETWEET 1 0 1
1209015 1650310652 HELLIEEDWARDS 1075 Pata nahi tareef kar rahe ho ya mazak udha rahe ho � #PappuQuotes https://t.co/rjiWuPa39n United States 2 Urdu 44 2016-01-17T09:21:00 2016-01-17T09:21:00 811 1329 1134 RETWEET 1 0 1
1368670 1716228906 JANI_S_JAC 1235 poor baaaby https://t.co/ScjnoMSThK United States 2 Urdu 44 2015-01-12T07:37:00 2015-01-12T07:37:00 271 82 33   0 0
1380826 2533001646 JASPER_FLY 1242 '@MissNuggett She's hot!' United States 2 Urdu 44 2015-03-18T07:43:00 2015-03-18T07:43:00 97 86 1080   0 0
1405073 1656685598 JEANNEMCCARTHY0 1254 '@mikerzer @SarCatStyX @Mr_Landshark @JadedByPolitics @lupash7 @GeraldYak420 @KCarslin @ShariRomine @jwsnyder00_john Oh shut up' United States 2 Urdu 44 2016-12-10T20:20:00 2016-12-10T20:20:00 3395 3274 2079 RETWEET 1 0 1
1434684 2882331822 JENN_ABRAMS 1266 '@nytimes let's see...' United States 2 Urdu 44 2015-05-12T09:53:00 2015-05-12T09:53:00 3467 24311 2335   0 0
1436546 2882331822 JENN_ABRAMS 1266 '@NOLAnews poor shark!' United States 2 Urdu 44 2015-06-11T07:27:00 2015-06-11T07:27:00 4252 24993 3223   0 0
1440155 2882331822 JENN_ABRAMS 1266 '@HillaryClinton oh shut up' United States 2 Urdu 44 2015-07-31T15:46:00 2015-07-31T15:46:00 8417 28841 5337   0 0
1546576 1695830984 KELVIN_CHAMBERS 1384 '@shanu_sab bhai DP achhi si lagale yahi bomb fodega kya �� @rishirai666' United States 2 Urdu 44 2017-03-10T20:12:00 2017-03-10T20:12:00 1678 1685 2325 RETWEET 1 0 1
1575700 2503202888 KRISTYANANN 1460 poor baaaby https://t.co/xLUnW6H7k5 United States 2 Urdu 44 2015-03-13T10:08:00 2015-03-13T10:08:00 380 151 1332   0 0
1612944 1682412506 LELANDGRAVES_ 1522 oh shut up! https://t.co/hyHpoGIryv United States 2 Urdu 44 2015-04-03T12:59:00 2015-04-03T12:59:00 58 58 361   0 0
1737723 1654347974 MAYMAYMYY 1739 poor baaaby https://t.co/5Isi51pFml United States 2 Urdu 44 2015-02-08T17:01:00 2015-02-08T17:03:00 284 106 176   0 0
1767221 1690487623 MICHELLEARRY 1763 '@pbhushan1 @YouTube Aur aapne jyo samay choona usse lagta hai ki aapki Niyaat saanf nahi hai .' United States 2 Urdu 44 2017-03-12T12:21:00 2017-03-12T12:21:00 3201 3223 3322 RETWEET 1 0 1
2112190 2671070290 PATRIOTBLAKE 2072 ایسا کوئی انسان نہیں جس پر رحمت کے دروازے بند ھوں اگر دنیا کے تمام دروازے آپ پر بند ھوجائیں تو یاد رکھنا حضرت یوسفؓ اور آپ کا خدا ایک ھے https://t.co/zLq7GzllcY United States 2 Urdu 44 2016-12-10T07:42:00 2016-12-10T07:42:00 2713 2166 4624 RETWEET 1 0 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 18.779ms · Data source: fivethirtyeight/russian-troll-tweets