home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

91 rows where language = 38

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
20621 1652138929 ACEJINEV 38 Gift uh Gab - _Orange Skyline_ https://t.co/8bMdm8namv #nowplaying #dagr8fm United States 2 Danish 38 2016-11-16T10:05:00 2016-11-16T10:05:00 799 900 2221 RETWEET 1 0 1
22789 1652138929 ACEJINEV 38 Lil bruh nem... United States 2 Danish 38 2017-03-19T02:23:00 2017-03-19T02:23:00 785 918 5131 RETWEET 1 0 1
25658 1670762347 ADAMCHAPMANJR 42 Gift uh Gab - _Orange Skyline_ https://t.co/8bMdm8ELL5 #nowplaying #dagr8fm United States 2 Danish 38 2016-10-06T18:31:00 2016-10-06T18:31:00 582 932 1590 RETWEET 1 0 1
88219 2616344667 AMANDAVGREEN 138 #ValentinesDayIn3Words I'm single af :( United States 2 Danish 38 2017-02-08T16:38:00 2017-02-09T14:56:00 4775 5827 6249   0 0
118721 1679279490 AMELIEBALDWIN 146 Finanssektoren er hackernes hovedmål nu: Sådan angriber de virksomhederne @computerworlddk #finansdk #hacked #dktech https://t.co/QzVeGqgJgv United States 2 Danish 38 2017-04-19T12:51:00 2017-04-19T12:51:00 2291 2816 37621 RETWEET 1 0 1
147954 2612066397 ANDYDREWDANIELS 186 Peter Parker United States 2 Danish 38 2017-03-03T09:51:00 2017-03-03T09:51:00 3145 3595 2842   1 0
149000 2878166306 ANDYHASHTAGGER 187 Blind dating #ModernDeadlySins United States 2 Danish 38 2015-10-25T16:55:00 2015-10-25T16:55:00 13283 15850 3558   1 0
153967 2878166306 ANDYHASHTAGGER 187 #PresentsTrumpGot wig holder https://t.co/vioAr9oyjd United States 2 Danish 38 2016-06-15T14:57:00 2016-06-15T15:09:00 19121 22414 10562 RETWEET 1 1 1
219896 1671936266 ARM_2_ALAN 269 Gender Bender #LiberalRaceHorses United States 2 Danish 38 2015-06-07T15:54:00 2015-06-07T15:54:00 68 142 4967 RETWEET 1 0 1
237223 2944766250 ATLANTA_ONLINE 295 Vigil for murder Villa Rica man https://t.co/yyUPRET5DI https://t.co/tab24cSM6H United States 2 Danish 38 2016-12-10T06:05:00 2016-12-10T06:05:00 6064 17323 6266   0 0
269450 1658420976 BAOBAEHAM 326 Mansion Elan lit af rn 2:01 am 🔥🔥 United States 2 Danish 38 2017-04-15T08:27:00 2017-04-15T08:27:00 811 1109 6043 RETWEET 1 0 1
321400 725000000000000000 BERLINBOTE 372 „Ein Höhepunkt der Konkurrenz“ https://t.co/JLo2z5gpfn Unknown 1 Danish 38 2017-09-04T20:47:00 2017-09-04T20:47:00 2159 1768 21962   0 0
326544 2732675512 BGARNER2107 384 B.o.B. Saget #DadRappers @midnight United States 2 Danish 38 2015-05-29T12:57:00 2015-05-29T12:57:00 169 173 1387 RETWEET 1 0 1
360449 4840551713 BLACKTOLIVE 406 Kid woke af https://t.co/On2KIM6jjM United States 2 Danish 38 2016-10-21T17:30:00 2016-10-21T18:12:00 6325 9829 2324   0 0
365103 4840551713 BLACKTOLIVE 406 Smooth af ����� https://t.co/OR2WExqIL7 United States 2 Danish 38 2016-08-26T20:00:00 2016-08-26T20:00:00 4147 5495 1300   0 0
374619 1687183549 BLEEPTHEPOLICE 415 Trully af https://t.co/WwOmRqiVUz United States 2 Danish 38 2016-07-11T15:25:00 2016-07-11T15:25:00 4274 9372 11630 QUOTE_TWEET 2 0 1
381209 1685173321 BLMSOLDIER 418 #Boxing LIVE in #Shoreditch - #AnthonyJoshua vs #Klitschko + Af #Party Sat 29th Apr - https://t.co/N9crEEfxey #London, #UnitedKingdom United States 2 Danish 38 2017-04-15T10:50:00 2017-04-15T10:50:00 692 721 5814 RETWEET 1 0 1
383212 2574927682 BOBSDYER 420 #ThingsIPrettyMuchSuckAt Finding Nemo United States 2 Danish 38 2015-10-08T13:41:00 2015-10-08T13:41:00 994 513 942 RETWEET 1 1 1
394647 1718000594 BOOTH_PRINCE 431 #WhenIWasYoung I stayed woke af https://t.co/736VMIyfuO United States 2 Danish 38 2016-06-01T14:15:00 2016-06-01T14:15:00 2445 1956 2933   1 0
395316 1718000594 BOOTH_PRINCE 431 #PresentsTrumpGot wig holder https://t.co/vioAr9oyjd United States 2 Danish 38 2016-06-15T14:57:00 2016-06-15T14:57:00 2803 2126 3997 RETWEET 1 1 1
398749 1718000594 BOOTH_PRINCE 431 #SextingWentWrongWhen pics hot af https://t.co/l7zgym0o3g United States 2 Danish 38 2016-08-29T13:48:00 2016-08-29T13:48:00 4089 3414 7815   1 0
399080 1718000594 BOOTH_PRINCE 431 #MyOlympicSportWouldBe Dance roller skating https://t.co/zwuFRmoRQw United States 2 Danish 38 2016-08-03T15:27:00 2016-08-03T15:27:00 3214 2968 5976 RETWEET 1 1 1
422171 1675280893 BRIANTHELIFTER 448 Relevant af (via @busboysandpoets menu) https://t.co/XtHi0LNFl7 United States 2 Danish 38 2017-02-11T14:46:00 2017-02-11T14:47:00 521 835 3412 RETWEET 1 0 1
422325 1675280893 BRIANTHELIFTER 448 Copenhagen, Denmark �� https://t.co/vEaf45IaVK United States 2 Danish 38 2017-02-19T07:26:00 2017-02-19T07:27:00 519 830 3565 RETWEET 1 0 1
443565 2532597577 BRUCIEDUBLIN 464 #ThingsIPrettyMuchSuckAt Finding Nemo United States 2 Danish 38 2015-10-08T13:32:00 2015-10-08T13:32:00 1092 506 813 RETWEET 1 0 1
458845 2535353390 CALEBPAAR 481 #ThingsIPrettyMuchSuckAt Finding Nemo United States 2 Danish 38 2015-10-08T14:04:00 2015-10-08T14:04:00 1291 463 1897 RETWEET 1 0 1
505262 2589353987 CASSIEWELTCH 511 Goodlucky365 Sacs à Lavage Filet à Linge Lingerie.. #confortable #sensuelle #My4WordNewYearsResolution https://t.co/vzN6J2NFri United States 2 Danish 38 2016-12-21T14:57:00 2016-12-21T14:57:00 2374 2751 3307   0 0
541387 1532863891 CHARLESJHARPER 533 #ThingsIPrettyMuchSuckAt Finding Nemo United States 2 Danish 38 2015-10-08T13:34:00 2015-10-08T13:34:00 939 466 1039 RETWEET 1 0 1
614358 2882350436 CHRIXMORGAN 571 #ThingsNotTaughtAtSchool Gambling United States 2 Danish 38 2016-10-12T14:58:00 2016-10-12T14:59:00 10433 17897 9409 RETWEET 1 0 1
615573 2882350436 CHRIXMORGAN 571 Finding Nemo #SantasOtherJobs https://t.co/K86563xrN0 United States 2 Danish 38 2016-10-30T08:15:00 2016-10-30T08:15:00 8794 18097 10568 RETWEET 1 0 1
618690 2882350436 CHRIXMORGAN 571 #SecondhandGifts lingerie United States 2 Danish 38 2016-12-21T15:34:00 2016-12-21T15:34:00 10072 19857 14135 RETWEET 1 0 1
622690 2882350436 CHRIXMORGAN 571 Give Rioters a Pepsi #MakeTodayBetterIn4Words United States 2 Danish 38 2017-04-28T12:55:00 2017-04-28T12:56:00 9782 21608 18732 RETWEET 1 0 1
623021 2882350436 CHRIXMORGAN 571 #AddPotInAMovie Goldbud Finger United States 2 Danish 38 2016-05-11T14:55:00 2016-05-11T14:56:00 9538 15117 4801 RETWEET 1 0 1
654284 1710804738 COOKNCOOKS 598 Helen Keller .- #quote #image Via https://t.co/5jBLFCAe9J https://t.co/NeTxkWX9b2 United States 2 Danish 38 2017-03-23T08:15:00 2017-03-23T08:15:00 1867 1649 4747 RETWEET 1 0 1
797214 2882037326 DANAGEEZUS 634 I’m transgender #HillaryPickUpLines United States 2 Danish 38 2016-04-18T13:49:00 2016-04-18T13:49:00 10905 16666 5510 RETWEET 1 0 1
800338 2882037326 DANAGEEZUS 634 #PresentsTrumpGot wig holder https://t.co/vioAr9oyjd United States 2 Danish 38 2016-06-15T14:55:00 2016-06-15T15:07:00 14883 18361 8269   0 0
827899 1684524144 DATWISENIGGA 663 And spicy af smh https://t.co/41B8jk2jY1 United States 2 Danish 38 2016-12-19T19:00:00 2016-12-19T19:00:00 805 900 3172 RETWEET 1 0 1
890477 2573225349 DOMINICVALENT 734 #EroticBroadway $3xy lingerie http://t.co/HRU3vUFsBK United States 2 Danish 38 2015-06-03T11:54:00 2015-06-03T11:56:00 170 149 913 RETWEET 1 0 1
981303 723000000000000000 ERDOLLUM 841 DreamTeam!=) #olympiaserien #Olympics2016 #Olympics Medaille #Rio2016 #Erdogan #Merkel #Obama #Fernsehgarten https://t.co/mgEBWC44CO Germany 13 Danish 38 2016-08-07T12:08:00 2016-08-07T12:08:00 5429 6074 1457   0 0
1044977 3272640600 EXQUOTE 890 .@DeBrezzzyyy16 YaBoyyyDE! @MrJamieElleray ??m?? @BestAmazingFact Best @FJackson76 Fred @laevantine Back http://t.co/WCpSNDTR15 United States 2 Danish 38 2015-08-19T15:51:00 2015-08-19T15:51:00 2 539 42296   1 0
1047619 3272640600 EXQUOTE 890 .@ziall505 agnes @jordywardy717 Jordan @Bammer301 Kelli @kelszey Kelsey @LizzyWright22 Elizabeth @9poundergritz Weird http://t.co/8OMLccdiC3 United States 2 Danish 38 2015-08-20T18:20:00 2015-08-20T18:20:00 2 580 44579   1 0
1056420 3272640600 EXQUOTE 890 .@anestalado Alexander @stairstoavon kelsey @rdelylucuss Roger @DarrenHouse_ Darren @t36campbell Hercules http://t.co/zUsgXcpBz1 United States 2 Danish 38 2015-08-27T21:53:00 2015-08-27T21:53:00 2 777 57700   1 0
1061851 3272640600 EXQUOTE 890 .@Belle_Belinda_ Belinda @_LLexington Lavender @vincenaval Vincent @emma_veber Veeeeeeeebbbbeeessss @JaayyBaayy Nea http://t.co/4TPr4HM8VD United States 2 Danish 38 2015-08-30T12:20:00 2015-08-30T12:20:00 2 846 61996   1 0
1066819 3272640600 EXQUOTE 890 '@DarcySteffens Darcy Steffens @efflourage still larry af @yosiiieeee Yosie @TGOD_Zeek Ezequiel @rcveeder Ryan Veeder http://t.co/1DTg5TQlYG' United States 2 Danish 38 2015-08-05T04:04:00 2015-08-05T04:04:00 2 359 30963   1 0
1094332 3254273689 FINDDIET 914 Kimberly @kimberlyyevanss af @aidanhaley Angela @_ambbae Ariel @arielmarquez702 http://t.co/PN6cEaPSvI https://t.co/x9JuWoZAOX United States 2 Danish 38 2015-08-10T05:22:00 2015-08-10T05:22:00 3 263 26953 QUOTE_TWEET 2 1 1
1097397 3254273689 FINDDIET 914 http://t.co/EG3FTpXoJn JordanMalfort @MallerDan Jake @JakePoblocki V @V_Coleman55 ☯ @SophisTKed Herts @HertsSV https://t.co/zIHP2wesVs United States 2 Danish 38 2015-08-13T10:00:00 2015-08-13T10:00:00 3 357 31508 QUOTE_TWEET 2 1 1
1097849 3254273689 FINDDIET 914 http://t.co/YvsvWSxT8S lil' @dretotheRESCUE DiiizzzyyyDeee @dizzydee012 K-T! @krmorin1 Live @Iive_fitness https://t.co/KMfqeMJzbS United States 2 Danish 38 2015-08-13T17:16:00 2015-08-13T17:16:00 4 365 31960 QUOTE_TWEET 2 1 1
1099054 3254273689 FINDDIET 914 http://t.co/bAVJTEAYuL skeeter @electrafart69 A @SheldonDeVane Tan777 @Tanr79 jakee @jakkee_gee Mark @_MarkNewell_ https://t.co/srwPACepey United States 2 Danish 38 2015-08-14T16:51:00 2015-08-14T16:51:00 4 380 32475 QUOTE_TWEET 2 1 1
1099612 3254273689 FINDDIET 914 .@NicolePadilla4 bait @alattar99 Mohammed @FlorenceGifteb Florence @SamRedlich Sam @chloeoates_ ❁ @PaigieLeeann Paige http://t.co/05FvY3OZwI United States 2 Danish 38 2015-08-15T00:12:00 2015-08-15T00:12:00 4 387 33034   1 0
1101843 3254273689 FINDDIET 914 '@SGMilne Stuart Milne @Munkey_Pants Louise Forshaw @KelseyLafferty Kelsey Lafferty @CortenEditorial Lindsay Corten http://t.co/yFcsb7MHhV' United States 2 Danish 38 2015-08-04T18:38:00 2015-08-04T18:38:00 3 188 20859   1 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 24.962ms · Data source: fivethirtyeight/russian-troll-tweets