home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

62 rows where language = 30

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
11814 2534875924 6DRUZ 14 ❤️ #girls #latergram @xenia_sobchak anna_zaytseva17 yanaraskovalova https://t.co/oipa6f9EGC Unknown 1 Slovenian 30 2016-10-31T11:08:00 2016-10-31T11:08:00 11 72 1677 RETWEET 1 0 1
72248 2559217373 ALEXSVLADIMIROV 104 La giornata di un opričnik @ Bookmate https://t.co/R3IAWMJYdU Unknown 1 Slovenian 30 2017-03-10T22:39:00 2017-03-10T22:39:00 70 1990 1681 RETWEET 1 0 1
99152 1679279490 AMELIEBALDWIN 146 Tu se jasno vidi, KAJ v resnici slavijo člani ZZB na številnih proslavah NOB po Primorski. Izražajo srečo, da jim je uspelo uničiti arhive. https://t.co/6Ycw819gJm United States 2 Slovenian 30 2016-10-15T10:28:00 2016-10-15T10:28:00 1938 2462 14410 RETWEET 1 0 1
103262 1679279490 AMELIEBALDWIN 146 '@MarkoSket @StrankaSMC Grozdi, socialno podjetništvo, krožno gospodarstvo, po slovensko - SMC. #SamoMiCuzamo' United States 2 Slovenian 30 2016-11-12T15:14:00 2016-11-12T15:14:00 2387 2540 17664 RETWEET 1 0 1
104253 1679279490 AMELIEBALDWIN 146 Prvovrstna smrdljiva levičarska drhal, bi v imenu njihove sprevržene ideologije, rada vzgajala tudi naše otroke. https://t.co/5QhOSB46lj United States 2 Slovenian 30 2016-11-02T08:53:00 2016-11-02T08:53:00 1932 2464 16369 RETWEET 1 0 1
111017 1679279490 AMELIEBALDWIN 146 Nekdanji minister Andrej Vizjak o TEŠ 6: Pokrivali bomo zablode vplivnežev iz Šaleške doline #VrednoBranja https://t.co/mg8JfX2auZ United States 2 Slovenian 30 2017-02-15T10:53:00 2017-02-15T11:07:00 2329 2741 29141 RETWEET 1 0 1
114152 1679279490 AMELIEBALDWIN 146 Z denarjem, ki ga je vlada RS odobrila ZZB, bi lahko financirali pribl. 200 znanstvenih publikacij: https://t.co/XpthNtOZZr United States 2 Slovenian 30 2017-03-13T07:05:00 2017-03-13T07:05:00 2309 2747 32353 RETWEET 1 0 1
264546 2537243471 BANTTANANTTA 325 ❤️ #girls #latergram @xenia_sobchak anna_zaytseva17 yanaraskovalova https://t.co/oipa6f9EGC Azerbaijan 7 Slovenian 30 2016-10-31T11:15:00 2016-10-31T11:17:00 278 111 875 RETWEET 1 0 1
405317 2482076083 BRATUHA_BORCUHA 442 ❤️ #girls #latergram @xenia_sobchak anna_zaytseva17 yanaraskovalova https://t.co/oipa6f9EGC Unknown 1 Slovenian 30 2016-10-31T11:58:00 2016-10-31T11:58:00 226 90 836 RETWEET 1 0 1
409873 1873206768 BRENTMCCLURE275 444 '@JLo WOW! #ShadesOfBlue crazy episode!!!!' United States 2 Slovenian 30 2017-03-13T05:16:00 2017-03-13T05:16:00 734 779 5350 RETWEET 1 0 1
459710 2535353390 CALEBPAAR 481 won’t stop United States 2 Slovenian 30 2014-12-01T13:46:00 2014-12-01T13:46:00 281 72 878   0 0
504542 2589353987 CASSIEWELTCH 511 Boston Red Cox #SexySports @midnight United States 2 Slovenian 30 2017-01-24T08:36:00 2017-01-24T08:36:00 2848 3225 3428   0 0
554364 1877492857 CHESPLAYSCHESS 547 .@EvaIrglL za jutri sklicala sejo komisije o nameščanju migrantov na različne lokacije po Sloveniji. Več na: https://t.co/1sEjKEX6UL https://t.co/Uez2EUnfdi United States 2 Slovenian 30 2017-01-19T17:05:00 2017-01-19T17:05:00 1034 1465 17283 RETWEET 1 0 1
555934 1877492857 CHESPLAYSCHESS 547 Pričevalci so se hvala Bogu oglasili. Delite naprej! #RTV #Cenzura : https://t.co/3UB4DyWPI4 United States 2 Slovenian 30 2017-02-18T08:39:00 2017-02-18T08:39:00 1030 1459 17954 RETWEET 1 0 1
557402 1877492857 CHESPLAYSCHESS 547 Od 3 prispevkov, ki jih plačujemo s.p. ji, sta se letos (marec je!) dva povišala že drugič, tretji prvič. Za spodbujanje podjetništva gre. United States 2 Slovenian 30 2017-03-09T10:13:00 2017-03-09T10:13:00 1025 1465 18389 RETWEET 1 0 1
607971 733000000000000000 CHRISUPORT_PORT 566 '@schumales Danke, MagdaLena=) https://t.co/P1KqEzpcXo' Germany 13 Slovenian 30 2016-08-28T09:47:00 2016-08-28T09:48:00 4304 4163 1328   0 0
639627 1723226778 COLLEEN_FRN 592 I love owls ❤ https://t.co/qL27PnLONM United States 2 Slovenian 30 2015-05-25T13:24:00 2015-05-25T13:25:00 59 47 408   0 0
652147 1710804738 COOKNCOOKS 598 Od danes naprej, bom levico naslavljal z njihovimi naravnimi imeni. LEVIČARSKI FAŠISTI IN RASISTI. Ja levičarji, točno to ste! Nestrpni drek United States 2 Slovenian 30 2016-11-17T09:39:00 2016-11-17T09:39:00 1921 1625 2735 RETWEET 1 0 1
653046 1710804738 COOKNCOOKS 598 Če bi imel Obama še kakšen mesec časa, bi zakuhal še kaj hujšega. https://t.co/ZjmBEohesu United States 2 Slovenian 30 2016-12-30T09:08:00 2016-12-30T09:08:00 1900 1639 3456 RETWEET 1 0 1
857173 2577152109 DENN_NIKITIN 690 Dr. Navalny https://t.co/SzldtU0SCA Unknown 1 Slovenian 30 2017-03-20T09:41:00 2017-03-20T09:41:00 68 96 5460 RETWEET 1 0 1
857701 2577152109 DENN_NIKITIN 690 Vsem salam, ya znayu kazahskiy yazyk! Unknown 1 Slovenian 30 2017-04-14T06:26:00 2017-04-14T06:26:00 68 111 6226 RETWEET 1 0 1
898274 1720117201 DONNABRIVERA 741 '@MarkoSket @Miran7777 @jozesket68 Merkel, Holland, Sarkozy...pravijo da tud Druncker' United States 2 Slovenian 30 2016-11-12T10:27:00 2016-11-12T10:27:00 2027 1691 2829 RETWEET 1 0 1
904748 1833223908 DOROTHIEBELL 748 Še enkrat info o mojih kipih na sejmu umetnosti v Sofiji (v organizaciji moje galeristke- Viva Art Gallery iz Dunaja) https://t.co/mJmHOBrOEY United States 2 Slovenian 30 2016-10-24T10:11:00 2016-10-24T10:11:00 2314 1891 3085 RETWEET 1 0 1
943813 892000000000000000 ELINSSTR 814 RT JohnPer60804035: Get em' Stevie... https://t.co/Hx8pQ2gFzU Unknown 1 Slovenian 30 2017-08-02T20:25:00 2017-08-02T20:27:00 999 620 485 QUOTE_TWEET 2 0 1
969585 1676481360 EMILEEWAREN 830 '@NeMaramButlov Zidar Klemenčičeva rada kupuje žrebce. :)' United States 2 Slovenian 30 2016-11-23T21:10:00 2016-11-23T21:10:00 1894 2084 2849 RETWEET 1 0 1
969592 1676481360 EMILEEWAREN 830 Trump bo v prvih 100 dnevih vladanja dal pregledati vse vizume migrantov. Kako pa kaj pri nas s tem, Cerar? United States 2 Slovenian 30 2016-11-23T09:05:00 2016-11-23T09:05:00 1895 2086 2839 RETWEET 1 0 1
970091 1676481360 EMILEEWAREN 830 Ko me kdo vpraša kaj ima ta skupnega Trump in liberalizem mu/ji pokažem množico suspendiranih TW računov. Imata vsaj 1 istega nasprotnika. United States 2 Slovenian 30 2016-12-15T13:45:00 2016-12-15T13:45:00 1881 2074 3338 RETWEET 1 0 1
971412 1676481360 EMILEEWAREN 830 Jutri praznujemo zmago Resnice nad Zlom. Hren pa nas bo spominjal na trpljenje preštevilnih nedolžnih žrtev boja. http://t.co/uR0yrd8K2e United States 2 Slovenian 30 2017-03-10T09:06:00 2017-03-10T09:06:00 1848 2082 4976 RETWEET 1 0 1
972504 1676481360 EMILEEWAREN 830 Dan upora proti okupatorju. Lepo praznujte. https://t.co/VUz2PusQIY https://t.co/7MY0MCr9Uy United States 2 Slovenian 30 2017-04-27T13:01:00 2017-04-27T13:01:00 1833 2078 5982 RETWEET 1 0 1
982836 2540611879 ERICARUTTER 846 Cock Stroke #SexySports Unknown 1 Slovenian 30 2017-01-24T11:36:00 2017-01-24T11:36:00 1767 2068 1843   0 0
995394 2534200842 ESTERBRIANG 863 I LOVE DOGS! https://t.co/S5hS7eCIKA United States 2 Slovenian 30 2015-05-25T10:20:00 2015-05-25T10:20:00 139 58 327   0 0
997034 2533653547 EVAGREEN69 870 Evo za Milenka Jovanova i slične poltrone https://t.co/jXk5Lnpha4 United States 2 Slovenian 30 2017-01-05T08:15:00 2017-01-05T08:15:00 2810 2717 2170 RETWEET 1 0 1
1063844 3272640600 EXQUOTE 890 .@ellasntg_ q @Churut_Darkkey Rudi @lovemytrout Jo @FrenchDopeee Kana @JaniceKayePhD Janice @DonisLasley_ Bishop http://t.co/P81AwmpbGQ United States 2 Slovenian 30 2015-08-31T15:16:00 2015-08-31T15:16:00 2 850 64146   1 0
1077814 2785702231 FILATOVALECHOSL 911 '@marina_al_22889 Molodec chuvak, vse pravil’no rapsisal. Respekt ot pacanov tebe :)' Unknown 1 Slovenian 30 2015-07-19T19:19:00 2015-07-19T19:19:00 197 196 6239   0 0
1104182 3254273689 FINDDIET 914 Sanjana @AShettyLife LJ @BlondCorporateL Del @UJustWalkItOff Rere♡ @Reanna_Raylene http://t.co/mE0in1y732 https://t.co/mGDuODlxnr United States 2 Slovenian 30 2015-08-06T01:18:00 2015-08-06T01:18:00 3 205 22439   1 0
1107718 3254273689 FINDDIET 914 Wade @cuffyochickenn Jennie @jennie_f Gina @BaconBit27 Love @FitLifeGuruu Elijah @lij__ http://t.co/CdFZzmnnua https://t.co/3HQmyyrWS7 United States 2 Slovenian 30 2015-08-09T22:03:00 2015-08-09T22:03:00 3 259 26488   1 0
1256154 1671234620 HYDDROX 1116 Smog Nazis https://t.co/zJ2bflP1xM United States 2 Slovenian 30 2016-11-02T15:39:00 2016-11-02T15:39:00 2158 2217 10826 RETWEET 1 0 1
1298305 1656024374 IMISSOBAMA 1150 Diplomacy! https://t.co/W04isl1vNf United States 2 Slovenian 30 2017-01-28T13:43:00 2017-01-28T13:43:00 472 761 5206 RETWEET 1 0 1
1342302 1685718216 J0HNLARSEN 1215 #Ferguson Wars Episode V #MakeAMovieRude http://t.co/g2Zl4Vd06I United States 2 Slovenian 30 2015-03-27T16:26:00 2015-03-27T16:27:00 234 117 402   0 0
1373485 1716228906 JANI_S_JAC 1235 Stevie. Jazmine. https://t.co/cRHgV14eur United States 2 Slovenian 30 2017-04-23T13:13:00 2017-04-23T13:13:00 560 867 5747 RETWEET 1 0 1
1568871 2787396793 KOMAROVAGUIPOLN 1436 '@Baranovasuppsti Molodec chuvak, vse pravil’no rapsisal. Respekt ot pacanov tebe :)' Unknown 1 Slovenian 30 2015-05-27T11:15:00 2015-05-27T11:17:00 199 196 5593   0 0
1576571 2579368386 KRUSTYPS 1462 ❤️ #girls #latergram @xenia_sobchak anna_zaytseva17 yanaraskovalova https://t.co/oipa6f9EGC Unknown 1 Slovenian 30 2016-10-31T11:34:00 2016-10-31T11:34:00 323 203 865 RETWEET 1 0 1
1585585 1510488662 LAGONEHOE 1485 Episode 10, let's go!!! #DearCaucasity #DWP United States 2 Slovenian 30 2017-05-01T00:38:00 2017-05-01T00:38:00 2313 3003 4713   0 0
1610863 1615093999 LEACH_4U 1515 I LOVE DOGS! https://t.co/1CZST3Sus6 United States 2 Slovenian 30 2015-05-25T10:13:00 2015-05-25T10:13:00 66 58 381   0 0
1737418 1654347974 MAYMAYMYY 1739 Podcast: #RudeTalkPodcast w/ @CamBellsPVD (Episode 26) https://t.co/Rb1pPzwPgz https://t.co/4ZxJtP2Dk4 United States 2 Slovenian 30 2017-02-23T01:28:00 2017-02-23T01:28:00 820 983 4210 RETWEET 1 0 1
1742821 2563075183 MED_HARLEY 1745 ❤️ #girls #latergram @xenia_sobchak anna_zaytseva17 yanaraskovalova https://t.co/oipa6f9EGC Azerbaijan 7 Slovenian 30 2016-10-31T11:54:00 2016-10-31T11:54:00 518 92 1016 RETWEET 1 0 1
1828747 2519246716 MRSERVELAT 1825 ❤️ #girls #latergram @xenia_sobchak anna_zaytseva17 yanaraskovalova https://t.co/oipa6f9EGC Unknown 1 Slovenian 30 2016-10-31T11:02:00 2016-10-31T11:03:00 241 97 1137 RETWEET 1 0 1
2109975 2671070290 PATRIOTBLAKE 2072 '@MarkoSket @Domovina_je Nekaj je narobe z ženskami & migracijami!? Kot da bi fantazirale o še boljšem decu izza gora.https://t.co/OAVLC1JVuB' United States 2 Slovenian 30 2017-01-28T10:28:00 2017-01-28T10:28:00 2692 2157 5838 RETWEET 1 0 1
2113337 2671070290 PATRIOTBLAKE 2072 Kako je nekdanji Janšev zaupnik promoviral Kučanovega zgodovinarja https://t.co/AW9eWVZ2P8 United States 2 Slovenian 30 2017-02-17T09:39:00 2017-02-17T09:39:00 2684 2177 6309 RETWEET 1 0 1
2169784 2912754262 PIGEONTODAY 2116 '@justinbieber @AlecBaldwin Oh no...Alec...' United States 2 Slovenian 30 2015-08-27T21:11:00 2015-08-27T21:11:00 10442 17454 5687   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 25.455ms · Data source: fivethirtyeight/russian-troll-tweets