home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

581 rows where language = 35

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
16197 2534421182 ABIGAILSSILK 28 Hello Kitty Woman #UnpopularSuperheroes http://t.co/fjv82b4Nnj United States 2 Finnish 35 2015-04-27T09:48:00 2015-04-27T09:48:00 239 208 914 RETWEET 1 0 1
19197 1652138929 ACEJINEV 38 Petty goals https://t.co/1Eib2XjmxD United States 2 Finnish 35 2017-01-01T19:04:00 2017-01-01T19:04:00 792 902 3266 RETWEET 1 0 1
22287 1652138929 ACEJINEV 38 demon kitty https://t.co/Wx4vCTONTt Unknown 1 Finnish 35 2015-02-08T16:57:00 2015-02-08T16:57:00 266 86 171   0 0
25411 1652138929 ACEJINEV 38 Nope. Nope. Nope. https://t.co/g02dWGrkTh United States 2 Finnish 35 2016-09-01T14:19:00 2016-09-01T14:19:00 1021 857 1284 QUOTE_TWEET 2 0 1
37110 1657833811 ADRIENNE_GG 57 Bad kitty. � #bts #catwoman #meow https://t.co/8fT11E7uCr United States 2 Finnish 35 2016-10-19T19:03:00 2016-10-19T19:03:00 2051 1818 2027 RETWEET 1 0 1
38435 1657833811 ADRIENNE_GG 57 Oh sweet kitty https://t.co/7awmXwUGz1 United States 2 Finnish 35 2015-03-16T14:42:00 2015-03-16T14:44:00 150 142 680   0 0
46930 2570250275 AIDEN7757 81 Bad kitty. � #bts #catwoman #meow https://t.co/8fT11E7uCr United States 2 Finnish 35 2016-10-19T18:31:00 2016-10-19T18:31:00 2029 1766 2232 RETWEET 1 0 1
47511 2570250275 AIDEN7757 81 Cute kitty gifs #ThingsYouCantIgnore https://t.co/2LjCi4qq8M United States 2 Finnish 35 2016-12-19T15:15:00 2016-12-19T15:15:00 2617 2557 3056 RETWEET 1 0 1
69952 2586506586 ALEXHARRITONOV 100 Simpsonit on aika pelottavan todenmukainen sarja. Eikös tässä jaksossa ns. Trump tuhonnut USA:n? #usavaalit https://t.co/3acIvVHZfy Azerbaijan 7 Finnish 35 2016-11-12T07:29:00 2016-11-12T07:29:00 136 2205 2181 RETWEET 1 0 1
75456 893000000000000000 ALEXXDRTRR 107 Hallelujah 🇺🇸 https://t.co/JU8eijgQpO Unknown 1 Finnish 35 2017-08-17T03:20:00 2017-08-17T03:20:00 34 2 2331 QUOTE_TWEET 2 0 1
75674 893000000000000000 ALEXXDRTRR 107 Hallelujah https://t.co/5bZm5bbveD Unknown 1 Finnish 35 2017-08-18T00:40:00 2017-08-18T00:40:00 34 6 2805 QUOTE_TWEET 2 0 1
85764 1677511772 ALYSSABEDOLLA 134 #ThingsNotToDoAtTheZoo Be a gorilla @WorldOfHashtags https://t.co/9f6482ytZu United States 2 Finnish 35 2016-06-03T16:48:00 2016-06-03T16:54:00 1290 776 1017 RETWEET 1 0 1
87437 2616344667 AMANDAVGREEN 138 Cute kitty gifs #ThingsYouCantIgnore https://t.co/2LjCi4qq8M United States 2 Finnish 35 2016-12-19T15:08:00 2016-12-19T15:08:00 3545 4644 5389 RETWEET 1 0 1
88347 2616344667 AMANDAVGREEN 138 #JapanAMovie Batman Vs Hello Kitty @midnight United States 2 Finnish 35 2017-03-30T10:07:00 2017-03-30T10:07:00 5506 6928 6583   0 0
89352 2616344667 AMANDAVGREEN 138 Kitty Woman #catsongs United States 2 Finnish 35 2016-08-10T11:09:00 2016-08-10T11:09:00 2286 2049 2815 RETWEET 1 0 1
90812 890000000000000000 AMBERLINETR 142 RT 17thCard: WittaTwitta MarkDiStef #auspol https://t.co/eRWrF4w0Rr #amb United States 2 Finnish 35 2017-07-28T07:23:00 2017-07-28T07:25:00 1953 9 216   0 0
128594 1679279490 AMELIEBALDWIN 146 #StandUpWithEvan #Independent #Conservative #ReligiousFreedom Evan McMullin #ProLife #Pro2A https://t.co/qs845lzzn2 https://t.co/z7q39mADwi United States 2 Finnish 35 2016-09-19T21:08:00 2016-09-19T21:09:00 1479 2311 9933 RETWEET 1 0 1
130435 1679279490 AMELIEBALDWIN 146 Flüchtlingskriminalität \| #merkel #cdu #bunteVielfalt #asylchaos #gutmensch https://t.co/5XjXdwdlAj https://t.co/XUOXwdVZe2 United States 2 Finnish 35 2016-09-09T14:48:00 2016-09-09T14:48:00 1482 1940 2793 RETWEET 1 0 1
132908 1664838877 AMIYAHSAMUELS 153 I blame my mailman. http://t.co/na28iQn8rx United States 2 Finnish 35 2015-05-13T00:54:00 2015-05-13T00:54:00 526 148 689 RETWEET 1 0 1
146862 2612066397 ANDYDREWDANIELS 186 Bad kitty. � #bts #catwoman #meow https://t.co/8fT11E7uCr United States 2 Finnish 35 2016-10-19T19:59:00 2016-10-19T19:59:00 1394 1019 1250 RETWEET 1 1 1
147365 2612066397 ANDYDREWDANIELS 186 #ThingsYouCantIgnore Hellno Kitty @WorldOfHashtags https://t.co/MujlSSYlGx United States 2 Finnish 35 2016-12-19T14:57:00 2016-12-19T14:57:00 2098 1939 2025   1 0
147462 2612066397 ANDYDREWDANIELS 186 #SecondhandGifts toilet paper United States 2 Finnish 35 2016-12-21T16:29:00 2016-12-21T16:29:00 1727 1996 2126   1 0
153822 2878166306 ANDYHASHTAGGER 187 #PresentsTrumpGot toilet paper https://t.co/Ga084HbxPR United States 2 Finnish 35 2016-06-15T14:19:00 2016-06-15T14:21:00 19121 22419 10385 RETWEET 1 1 1
154022 2878166306 ANDYHASHTAGGER 187 #PresentsTrumpGot toilet paper https://t.co/WPjzIS3TZa United States 2 Finnish 35 2016-06-15T15:17:00 2016-06-15T15:17:00 19121 22414 10627 RETWEET 1 1 1
159836 753000000000000000 ANGELABACH991 196 #JugendmitMerkel #TagderJugend Jugend stärken! #WorldElephantDay https://t.co/FL7vZ9D0jq Germany 13 Finnish 35 2016-08-12T13:56:00 2016-08-12T13:56:00 90 13 152   0 0
177972 2500690416 ANNIEPOSHES 224 Cute kitty gifs #ThingsYouCantIgnore https://t.co/2LjCi4qq8M United States 2 Finnish 35 2016-12-19T16:45:00 2016-12-19T16:45:00 3251 3551 4447 RETWEET 1 1 1
191946 1652262638 ANTONHAYHAY 237 Listen: @elvisfReShley - "Petty" f. @2Chainz + @50Cent https://t.co/7ieX8gr1Kc https://t.co/O8y8tl6mKJ United States 2 Finnish 35 2017-04-15T02:12:00 2017-04-15T02:12:00 303 748 9548 RETWEET 1 0 1
198314 87588938 ANZGRI 246 #nowplaying Gilla - Johnny United States 2 Finnish 35 2015-11-26T00:11:00 2015-11-26T00:12:00 35 1280 56324   0 0
198523 87588938 ANZGRI 246 #NowPlaying Gilla - Help! Help! United States 2 Finnish 35 2015-12-04T10:21:00 2015-12-04T10:21:00 35 1280 56580   0 0
200000 1672104320 AN_N_GASTON 248 https://t.co/gYUZ2Ch32O sad kitty � United States 2 Finnish 35 2015-07-03T14:23:00 2015-07-03T14:23:00 185 80 385   0 0
200029 1672104320 AN_N_GASTON 248 HALLELUIAH! https://t.co/2YAT58lDcp United States 2 Finnish 35 2015-07-03T14:53:00 2015-07-03T14:53:00 185 80 429   0 0
220806 1671936266 ARM_2_ALAN 269 #news #Chicago Emma: Teuvo Teravainen A Rising Star United States 2 Finnish 35 2015-06-08T01:31:00 2015-06-08T01:31:00 68 150 5246 RETWEET 1 0 1
232987 1650709597 ASHLEECOLLINSS 287 demon kitty https://t.co/1H7aoiAhbV United States 2 Finnish 35 2015-05-25T09:26:00 2015-05-25T09:26:00 57 63 396   0 0
250694 2532835560 BABYJANNYMEOW 313 Cute kitty gifs #ThingsYouCantIgnore https://t.co/2LjCi4qq8M United States 2 Finnish 35 2016-12-19T16:34:00 2016-12-19T16:34:00 3847 4185 5328 RETWEET 1 1 1
252331 2532835560 BABYJANNYMEOW 313 #munchamovie Pitta Pan United States 2 Finnish 35 2016-09-19T09:10:00 2016-09-19T09:11:00 1883 2379 3623 RETWEET 1 1 1
271558 1658420976 BAOBAEHAM 326 Nope. Nope. Nope. https://t.co/g02dWGrkTh United States 2 Finnish 35 2016-09-01T14:27:00 2016-09-01T14:27:00 1149 989 1555 QUOTE_TWEET 2 0 1
289572 892000000000000000 BEEATRWL 349 RT elijah_josef: Amen!!! https://t.co/sAU80QC4Sg Unknown 1 Finnish 35 2017-08-15T22:52:00 2017-08-15T22:52:00 2859 981 1953 QUOTE_TWEET 2 0 1
299521 715000000000000000 BERKHOFF85 371 #BVB Wir alle sind sehr enttäuscht https://t.co/IO5LtfNnWo via @faznet Germany 13 Finnish 35 2016-04-29T15:29:00 2016-04-29T15:29:00 702 223 74   0 0
300505 715000000000000000 BERKHOFF85 371 Ich bin tief enttäuscht!!! Unglaublich was man #Erdogan alles ungestraft durchgehen lässt. #Merkel #Türkei https://t.co/eGUbE1zVUL Unknown 1 Finnish 35 2017-07-17T14:58:00 2017-07-17T14:59:00 2277 2395 2603   0 0
301384 715000000000000000 BERKHOFF85 371 Was kann man da sagen? Schade und enttäuschend. #Seehofer #Bayern #CSU #Obergrenze https://t.co/okhyoIlBuI Unknown 1 Finnish 35 2017-08-20T13:32:00 2017-08-20T13:32:00 2648 2611 3028   0 0
302141 715000000000000000 BERKHOFF85 371 Palästinenser erschießt drei Israelis - Attentäter tot #Israel https://t.co/cVZv09VHMI Unknown 1 Finnish 35 2017-09-26T07:51:00 2017-09-26T07:52:00 3429 2857 3390   0 0
302590 725000000000000000 BERLINBOTE 372 Mieten-Aktivisten sind enttäuscht von Koalition https://t.co/VnWK7OMO21 https://t.co/w94QUeENBH Unknown 1 Finnish 35 2017-01-16T16:55:00 2017-01-16T16:55:00 496 61 10675   0 0
303657 725000000000000000 BERLINBOTE 372 Gewalttätiger Wilmersdorfer greift mehrfach Polizisten an https://t.co/gCK19yF93z https://t.co/ODuk1ovS1m Unknown 1 Finnish 35 2017-10-01T17:39:00 2017-10-01T17:39:00 2218 1822 24080   0 0
304847 725000000000000000 BERLINBOTE 372 Soziales: Senat will Armut in der Hauptstadt stärker bekämpfen https://t.co/9l69w06oRR https://t.co/MZiF965TND Unknown 1 Finnish 35 2017-02-25T11:20:00 2017-02-25T11:20:00 4115 575 13259   0 0
306220 725000000000000000 BERLINBOTE 372 Spandauer Wasserballer souverän https://t.co/pFwQL3x2PK https://t.co/EZDIMEILFC Unknown 1 Finnish 35 2017-03-26T10:52:00 2017-03-26T10:52:00 3482 949 14560   0 0
306561 725000000000000000 BERLINBOTE 372 Autopsie: Attentäter Amri konsumierte regelmäßig Drogen https://t.co/vpcOaYkEZ5 https://t.co/GorLeNR5Bj Unknown 1 Finnish 35 2017-03-04T11:51:00 2017-03-04T11:51:00 3567 659 13608   0 0
306562 725000000000000000 BERLINBOTE 372 Berlin-Attentäter Anis Amri konsumierte regelmäßig Drogen https://t.co/LeCqVv3SuM https://t.co/xKBAM2g5pg Unknown 1 Finnish 35 2017-03-04T12:28:00 2017-03-04T12:28:00 3567 661 13609   0 0
306563 725000000000000000 BERLINBOTE 372 Terrorismus: Autopsie: Attentäter Amri konsumierte regelmäßig Drogen https://t.co/2vyv81hn9B https://t.co/H42DDy10G7 Unknown 1 Finnish 35 2017-03-04T12:31:00 2017-03-04T12:31:00 3567 661 13610   0 0
306852 725000000000000000 BERLINBOTE 372 Hertha-Kapitän Ibisevic tritt gegen Schiedsrichter nach https://t.co/lpg16FbC6v https://t.co/j13fb1cMJZ Unknown 1 Finnish 35 2017-04-01T10:56:00 2017-04-01T10:56:00 1884 957 14853   0 0
308369 725000000000000000 BERLINBOTE 372 Urteil: "Costa Concordia"-Tragödie – Bleibt Kapitän Schettino frei? https://t.co/Sqq6JDSlBd https://t.co/3ayhROT2di Unknown 1 Finnish 35 2017-05-12T05:15:00 2017-05-12T05:15:00 1353 1272 16758   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 47.181ms · Data source: fivethirtyeight/russian-troll-tweets