home / russian-troll-tweets

tweets

Data source: fivethirtyeight/russian-troll-tweets

599,294 rows where account_category = 7

View and edit SQL

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
52728 802673000000000000 ALBUQUERQUEON 89 Albuquerque men arrested for trying to sell stolen gun parts https://t.co/EFexDXO1ZW https://t.co/FR5BS6tgcA Unknown 1 English 1 2017-01-01T00:21:00 2017-01-01T00:21:00 60 10 822   1 0
52729 802673000000000000 ALBUQUERQUEON 89 Albuquerque Pokemon Go players here to stay and give back https://t.co/0p2IG7WxcP https://t.co/sojx09ynE7 Unknown 1 English 1 2017-01-01T14:51:00 2017-01-01T14:51:00 60 10 830   1 0
52730 802673000000000000 ALBUQUERQUEON 89 Queen Elizabeth II misses church due to 'heavy cold' https://t.co/iZK1Ut3aIb https://t.co/sqGMF5l7p2 Unknown 1 English 1 2017-01-01T14:53:00 2017-01-01T14:53:00 60 10 831   1 0
52731 802673000000000000 ALBUQUERQUEON 89 New UN chief urges New Year's resolution: 'Put Peace First' https://t.co/fPrxNCBEo2 https://t.co/BB0jlvVW9d Unknown 1 English 1 2017-01-01T15:23:00 2017-01-01T15:23:00 60 10 832   1 0
52732 802673000000000000 ALBUQUERQUEON 89 China says it will shut down ivory trade by end of 2017 https://t.co/F6AODNBSmj https://t.co/SfoTo206EX Unknown 1 English 1 2017-01-01T15:53:00 2017-01-01T15:53:00 60 10 833   1 0
52733 802673000000000000 ALBUQUERQUEON 89 Rural New Mexico exports mentoring model for physicians https://t.co/1Da4kSy8sR https://t.co/c1MuWKqgjn Unknown 1 English 1 2017-01-01T16:23:00 2017-01-01T16:23:00 60 10 834   1 0
52734 802673000000000000 ALBUQUERQUEON 89 County enters last weekend of Tavern Taxi program https://t.co/WEHIPNCHwl https://t.co/27EpTPIKna Unknown 1 English 1 2017-01-01T01:53:00 2017-01-01T01:53:00 60 10 823   1 0
52735 802673000000000000 ALBUQUERQUEON 89 Eye on New Mexico: Water in New Mexico https://t.co/HClZsAI8Y5 https://t.co/M9McTVs5h1 Unknown 1 English 1 2017-01-01T22:23:00 2017-01-01T22:23:00 60 10 835   1 0
52736 802673000000000000 ALBUQUERQUEON 89 Family searching for missing woman from Cubero https://t.co/V53LABsMdR https://t.co/SCao9QsZI3 Unknown 1 English 1 2017-01-01T02:23:00 2017-01-01T02:23:00 60 10 824   1 0
52737 802673000000000000 ALBUQUERQUEON 89 New Year’s Eve weather forecast https://t.co/96LLWHTvVX https://t.co/n23Zyj4alO Unknown 1 English 1 2017-01-01T02:53:00 2017-01-01T02:53:00 60 10 825   1 0
52738 802673000000000000 ALBUQUERQUEON 89 Repeat offender attempting to steal a truck injures two ABQ firefighters https://t.co/zvyW5E3zPR https://t.co/JapBHTrj6C Unknown 1 English 1 2017-01-01T04:23:00 2017-01-01T04:23:00 60 10 826   1 0
52739 802673000000000000 ALBUQUERQUEON 89 Rain dampens world record Menorah attempt https://t.co/AqkVFxGf36 https://t.co/313uDCIUWw Unknown 1 English 1 2017-01-01T05:23:00 2017-01-01T05:23:00 60 10 827   1 0
52740 802673000000000000 ALBUQUERQUEON 89 City celebrates NYE in Civic Plaza https://t.co/Fi93MF1h81 https://t.co/711n17Az8z Unknown 1 English 1 2017-01-01T05:53:00 2017-01-01T05:53:00 60 10 828   1 0
52741 802673000000000000 ALBUQUERQUEON 89 State police crack down on drunk drivers during the holidays https://t.co/7fUyUveVVQ https://t.co/10gtjVisAd Unknown 1 English 1 2017-01-01T07:21:00 2017-01-01T07:21:00 60 10 829   1 0
52742 802673000000000000 ALBUQUERQUEON 89 Albuquerque mayor revives Commission on Indian Affairs https://t.co/cP8xMiCU8q https://t.co/hgy5iviSq0 Unknown 1 English 1 2017-01-10T00:17:00 2017-01-10T00:17:00 60 10 1051   1 0
52743 802673000000000000 ALBUQUERQUEON 89 Energy boss: Nuke-leak progress but work ahead https://t.co/Z3XTCHMrLY https://t.co/YBuudG5uHm Unknown 1 English 1 2017-01-10T00:31:00 2017-01-10T00:31:00 60 10 1052   1 0
52744 802673000000000000 ALBUQUERQUEON 89 Woman steals purses at 2 Albuquerque churches during holiday season https://t.co/l1qj0WdqQa https://t.co/kpoh958yeE Unknown 1 English 1 2017-01-10T00:47:00 2017-01-10T00:47:00 60 10 1053   1 0
52745 802673000000000000 ALBUQUERQUEON 89 Reports: gunfire heard near police station in Turkey https://t.co/7bnXRA8fmF https://t.co/cIY5ugdAUR Unknown 1 English 1 2017-01-10T12:47:00 2017-01-10T12:47:00 60 10 1062   1 0
52746 802673000000000000 ALBUQUERQUEON 89 Company to add 70 manufacturing jobs in Roswell https://t.co/MlpS9XM6xp https://t.co/L5s3TIxsSA Unknown 1 English 1 2017-01-10T14:01:00 2017-01-10T14:01:00 60 10 1063   1 0
52747 802673000000000000 ALBUQUERQUEON 89 New Mexico Democrats to watch Obama's 'farewell' speech https://t.co/CUtldj2Ggw https://t.co/I9F9zdB5Ot Unknown 1 English 1 2017-01-10T15:31:00 2017-01-10T15:31:00 60 10 1064   1 0
52748 802673000000000000 ALBUQUERQUEON 89 Tuesday morning weather forecast https://t.co/y9j2N1EViY https://t.co/t8mHxisNH6 Unknown 1 English 1 2017-01-10T16:01:00 2017-01-10T16:01:00 60 10 1065   1 0
52749 802673000000000000 ALBUQUERQUEON 89 OMI releases autopsy report of slain Albuquerque girl https://t.co/u2oeyl0t6C https://t.co/6LDXgRvoEp Unknown 1 English 1 2017-01-10T16:31:00 2017-01-10T16:31:00 60 10 1066   1 0
52750 802673000000000000 ALBUQUERQUEON 89 Woman’s remains spark questions among Santa Ana Pueblo residents https://t.co/UfsUV6RSaR https://t.co/iQoRESoNVy Unknown 1 English 1 2017-01-10T17:01:00 2017-01-10T17:01:00 60 10 1067   1 0
52751 802673000000000000 ALBUQUERQUEON 89 New Mexico Highlands University has named a new provost https://t.co/tbDxE79cPg https://t.co/FP3RSCBG7p Unknown 1 English 1 2017-01-10T17:17:00 2017-01-10T17:17:00 60 10 1068   1 0
52752 802673000000000000 ALBUQUERQUEON 89 Fired workers point to retaliation, sue New Mexico AG Balderas https://t.co/cQkE7Sp87z https://t.co/IzlOmlnK8I Unknown 1 English 1 2017-01-10T18:31:00 2017-01-10T18:31:00 60 10 1069   1 0
52753 802673000000000000 ALBUQUERQUEON 89 US Supreme Court rules in 2011 New Mexico police shooting https://t.co/W0Oo0jCWoc https://t.co/quvuMBGfB5 Unknown 1 English 1 2017-01-10T19:01:00 2017-01-10T19:01:00 60 10 1070   1 0
52754 802673000000000000 ALBUQUERQUEON 89 US Supreme Court rules in 2011 New Mexico police shooting https://t.co/SIjgyJac4W https://t.co/1hDjlJd9h1 Unknown 1 English 1 2017-01-10T19:17:00 2017-01-10T19:17:00 60 10 1071   1 0
52755 802673000000000000 ALBUQUERQUEON 89 How much sugar is in your kids' breakfast? https://t.co/anwow1bYEo https://t.co/K337fjEtcV Unknown 1 English 1 2017-01-10T19:31:00 2017-01-10T19:31:00 60 10 1072   1 0
52756 802673000000000000 ALBUQUERQUEON 89 Monday evening weather forecast https://t.co/xf7SLhPfAk https://t.co/uvZ4qtRakw Unknown 1 English 1 2017-01-10T01:01:00 2017-01-10T01:01:00 60 10 1054   1 0
52757 802673000000000000 ALBUQUERQUEON 89 Police: Shoplifter used daughter in escape attempt https://t.co/un6O2TMXfy https://t.co/4UttQhyzpC Unknown 1 English 1 2017-01-10T01:31:00 2017-01-10T01:31:00 60 10 1055   1 0
52758 802673000000000000 ALBUQUERQUEON 89 Police seek suspect in Albuquerque bank robbery https://t.co/yb26dabE62 https://t.co/IVZN8GIvdJ Unknown 1 English 1 2017-01-10T20:17:00 2017-01-10T20:17:00 60 10 1073   1 0
52759 802673000000000000 ALBUQUERQUEON 89 Shot fired at car owner after attempted heist at CNM https://t.co/btCakeoEwP https://t.co/TRR25ygZz6 Unknown 1 English 1 2017-01-10T20:31:00 2017-01-10T20:31:00 60 10 1074   1 0
52760 802673000000000000 ALBUQUERQUEON 89 Christmas goes to the goats https://t.co/NGSGgkvQiG https://t.co/QyxdhD11eP Unknown 1 English 1 2017-01-10T21:01:00 2017-01-10T21:01:00 60 10 1075   1 0
52761 802673000000000000 ALBUQUERQUEON 89 Outgoing DA slammed Albuquerque police in letter https://t.co/z8I34LMy4P https://t.co/hOskYNIIh8 Unknown 1 English 1 2017-01-10T22:51:00 2017-01-10T22:51:00 60 10 1076   1 0
52762 802673000000000000 ALBUQUERQUEON 89 New Mexico governor outlines state budget proposal https://t.co/MRYfpcEsWy https://t.co/K9UJ0CpdN0 Unknown 1 English 1 2017-01-10T23:17:00 2017-01-10T23:18:00 60 10 1077   1 0
52763 802673000000000000 ALBUQUERQUEON 89 Suspected Albuquerque getaway driver faces judge https://t.co/x7XfdTX8Yj https://t.co/2SVOi0KUOQ Unknown 1 English 1 2017-01-10T23:47:00 2017-01-10T23:49:00 60 10 1078   1 0
52764 802673000000000000 ALBUQUERQUEON 89 Officers on leave after weekend shooting; robbery suspect killed https://t.co/8lJct1gNoP https://t.co/r9gUPk5ZRo Unknown 1 English 1 2017-01-10T02:01:00 2017-01-10T02:01:00 60 10 1056   1 0
52765 802673000000000000 ALBUQUERQUEON 89 Manhunt underway for suspect in killing of Orlando officer https://t.co/Ggm1vWTom0 https://t.co/JzZ64bWz3i Unknown 1 English 1 2017-01-10T03:01:00 2017-01-10T03:01:00 60 10 1057   1 0
52766 802673000000000000 ALBUQUERQUEON 89 Cold stuns sea turtles along Texas coast https://t.co/48ivAsYw15 https://t.co/3wAeAxNe7v Unknown 1 English 1 2017-01-10T04:01:00 2017-01-10T04:01:00 60 10 1058   1 0
52767 802673000000000000 ALBUQUERQUEON 89 Power restored in Raton after outage https://t.co/ymkmFcbYaJ https://t.co/l2RICKGssX Unknown 1 English 1 2017-01-10T04:31:00 2017-01-10T04:31:00 60 10 1059   1 0
52768 802673000000000000 ALBUQUERQUEON 89 Court records: Investigators find more images in child porn case against doctor https://t.co/UeaSi8yuAG https://t.co/lRxc7tKiiD Unknown 1 English 1 2017-01-10T05:31:00 2017-01-10T05:31:00 60 10 1060   1 0
52769 802673000000000000 ALBUQUERQUEON 89 City could spend millions to buy 2 Albuquerque motels https://t.co/7nlcvh9nT9 https://t.co/Fexcu1UNYy Unknown 1 English 1 2017-01-10T05:47:00 2017-01-10T05:47:00 60 10 1061   1 0
52770 802673000000000000 ALBUQUERQUEON 89 Albuquerque police searching for suspect in attempted car theft https://t.co/raeelgfwi6 https://t.co/V6Wy27LyOH Unknown 1 English 1 2017-01-11T00:17:00 2017-01-11T00:17:00 60 10 1079   1 0
52771 802673000000000000 ALBUQUERQUEON 89 Video shows Albuquerque business owners fight off thief https://t.co/ySLiYUGq23 https://t.co/jRzfkYwsD4 Unknown 1 English 1 2017-01-11T00:47:00 2017-01-11T00:47:00 60 10 1080   1 0
52772 802673000000000000 ALBUQUERQUEON 89 Board to discuss fired Albuquerque officer’s job again https://t.co/7jDdLlv2qU https://t.co/4sWYJEBoxm Unknown 1 English 1 2017-01-11T13:17:00 2017-01-11T13:17:00 60 10 1087   1 0
52773 802673000000000000 ALBUQUERQUEON 89 New Mexico governor has plan for budget shortfall https://t.co/TPq9L91sWb https://t.co/Dk5LaVMVTl Unknown 1 English 1 2017-01-11T14:01:00 2017-01-11T14:01:00 60 10 1088   1 0
52774 802673000000000000 ALBUQUERQUEON 89 Scams reported in Chaves County, Bernalillo County https://t.co/VGRwb4HVjd https://t.co/QfGGwzLpZj Unknown 1 English 1 2017-01-11T14:31:00 2017-01-11T14:31:00 60 10 1089   1 0
52775 802673000000000000 ALBUQUERQUEON 89 Martinez avoids criticizing Trump over no Hispanic picks https://t.co/wH1u8uQTVy https://t.co/1O9F6lwpH9 Unknown 1 English 1 2017-01-11T15:01:00 2017-01-11T15:01:00 60 10 1090   1 0
52776 802673000000000000 ALBUQUERQUEON 89 Police investigate suspicious death in SE Albuquerque https://t.co/knCMDSd4EO https://t.co/RXH00vwtin Unknown 1 English 1 2017-01-11T15:31:00 2017-01-11T15:31:00 60 10 1091   1 0
52777 802673000000000000 ALBUQUERQUEON 89 Fire at Farmington apartment complex displaces dozens https://t.co/mEHFRZHz1x https://t.co/Dybr02Ayra Unknown 1 English 1 2017-01-11T16:01:00 2017-01-11T16:01:00 60 10 1092   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 1739.488ms · Data source: fivethirtyeight/russian-troll-tweets