home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

16 rows where search matches "Kyiv"

View and edit SQL

Suggested facets: external_author_id, content, language, publish_date, harvested_date, following, followers, updates, account_type, new_june_2018, retweet

author

region

account_category

Link rowid external_author_id author content region language publish_date harvested_date following followers updates post_type new_june_2018 retweet
71252 2586506586 ALEXHARRITONOV 100 Well done Dynamo Kyiv, one giant leap backwards. Waiting for certain journos to address this..... https://t.co/flppQ2dLjW Azerbaijan 7 English 1 2017-04-23T16:12:00 2017-04-23T16:12:00 148 2068 5900 RETWEET 1 0 1
72294 2559217373 ALEXSVLADIMIROV 104 #Lithuania has decided: "Rain of Revolution" by "Fusedmarc" to represent the country at #Eurovision2017 in revolutionary #Kyiv, #Ukraine https://t.co/NIoL64eff9 Unknown 1 English 1 2017-03-12T04:52:00 2017-03-12T04:52:00 70 1991 1737 RETWEET 1 0 1
139150 2252046530 ANASTASSIAZZ 162 Петр Порошенко назвал убийство Вороненкова «актом терроризма со стороны России» https://t.co/kiKcFQHdGA Видео: Kyiv Operativ https://t.co/LvV1D6n0iH United States 2 Russian 2 2017-03-23T12:36:00 2017-03-23T12:38:00 765 224 463 RETWEET 1 0 1
211438 2582643409 ARKADII_TROFIM 264 Welcome to #Eurovision2017 in #Kyiv - the capital of #Ukraine ! https://t.co/y5Ce3Y8RCZ Azerbaijan 7 English 1 2017-04-02T14:19:00 2017-04-02T14:19:00 261 1906 3680 RETWEET 1 0 1
553732 2527537955 CHERNENKONIKOLA 544 Иномарка снесла памятник героям Небесной сотни в центре Киева https://t.co/50jHjbyWxv Фото: Kyiv Operativ / YouTube #дтп https://t.co/YvxPIzFgVz Unknown 1 Russian 2 2016-12-12T05:44:00 2016-12-12T05:44:00 241 2106 3010 RETWEET 1 0 1
1260850 1671234620 HYDDROX 1116 Neither Kyiv prosecutor's office, which is leading Voronenkov assassination case, nor interior ministry confirm or deny to me ID of killer. https://t.co/wJNEqefKXj United States 2 English 1 2017-03-24T09:56:00 2017-03-24T09:56:00 2554 2250 17863 RETWEET 1 0 1
1467088 751000000000000000 JOHANNBERGBERG 1290 🎥Now live: #EUUkraine Summit press conference w/ Presidents @JunckerEU @eucopresident & @poroshenko https://t.co/cAWAOVeEpe #Kyiv #Ukraine https://t.co/Xvdq7V6NYq Unknown 1 English 1 2017-07-13T10:26:00 2017-07-13T10:26:00 126 104 480 RETWEET 1 0 1
1574744 3993926693 KRISTINA_ALES 1458 Luxury cars arrive every day at the Ukrainian Security Service (SBU) in Kyiv. https://t.co/Ap0rczde1X Unknown 1 English 1 2017-08-10T12:06:00 2017-08-10T12:07:00 537 162 327 RETWEET 1 0 1
1722361 3197151086 MATEVIDENCE 1723 #Kyiv to demand at working subgroups' meetings in Minsk that Donbas elections be called off http://t.co/J9PE7uE93I United States 2 English 1 2015-09-22T15:14:00 2015-09-22T15:14:00 1966 1365 1604   0 0
2033240 2805472723 OLD_NEW_POLICY 2019 Vice President #Biden Arrives to #Kyiv https://t.co/RaT61CwwDU с помощью @YouTube Unknown 1 Russian 2 2015-12-07T11:22:00 2015-12-07T11:22:00 396 259 7730   0 0
2033244 2805472723 OLD_NEW_POLICY 2019 Vice President #Biden Arrives to #Kyiv https://t.co/PSu10HS7ai с помощью @YouTube Unknown 1 Russian 2 2015-12-07T11:22:00 2015-12-07T11:22:00 396 259 7731   0 0
2309662 2443010631 RITA_ONE_LOVE 2238 Организаторы Kyiv Comic Con готовят новый фестиваль #кино Russian Federation 10 Russian 2 2015-08-01T10:13:00 2015-08-01T10:13:00 1582 2647 10276   1 0
2319269 2542876557 ROGOVILIA 2255 #Eurovision2017 (#Official #Kyiv #Promo) Альтернативный ролик «Добро пожаловать в #Киев — дом #Евровидения2017!» https://t.co/f0cStwj1HP Unknown 1 Russian 2 2017-04-03T15:07:00 2017-04-03T15:07:00 53 1943 1760 RETWEET 1 0 1
2319271 2542876557 ROGOVILIA 2255 #Eurovision2017 (#Official #Kyiv #Promo) Альтернативный ролик «Добро пожаловать в #Киев — дом #Евровидения2017!» https://t.co/f0cStwj1HP Unknown 1 Russian 2 2017-04-03T15:07:00 2017-04-03T15:07:00 53 1943 1760 RETWEET 1 0 1
2373079 763000000000000000 RUS_IN_USA 2300 Explosion hit U.S. Embassy In Kyiv, no damage reported https://t.co/gz1SlL8Gpd United States 2 English 1 2017-06-08T17:07:00 2017-06-08T17:07:00 1407 1301 451   0 0
2948470 2589513234 ZUBOVNIK 2820 На форуме высоких технологий Kyiv SMART City украинские учёные представили свои новейшие многомиллионные разработки https://t.co/Ky0QX2pruO Unknown 1 Russian 2 2015-10-24T12:23:00 2015-10-24T12:23:00 3184 21942 14228   0 0

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 40.987ms · Data source: fivethirtyeight/russian-troll-tweets