Trump's Legacy
Help us set the record straight with 56,572 tweets
@kaggle.zusmani_trumps_legacy
Trumps Legcy
@kaggle.zusmani_trumps_legacy.trumps_legcy
- 5.71 MB
- 56571 rows
- 6 columns
idId | textText | deviceDevice | favoritesFavorites | retweetsRetweets | dateDate |
|---|---|---|---|---|---|
| 98455000000000000 | Republicans and Democrats have both created our economic problems. | TweetDeck | 49 | 255 | Tue Aug 02 2011 18:07:00 GMT+0000 (Coordinated Universal Time) |
| 1234650000000000000 | I was thrilled to be back in the Great city of Charlotte, North Carolina with thousands of hardworking American Patriots who love our Country, cherish our values, respect our laws, and always put AMERICA FIRST! Thank you for a wonderful evening!! #KAG2020 https://t.co/dNJZfRsl9y | Twitter for iPhone | 73748 | 17404 | Tue Mar 03 2020 01:34:00 GMT+0000 (Coordinated Universal Time) |
| 1218010000000000000 | RT @CBS_Herridge: READ: Letter to surveillance court obtained by CBS News questions where there will be further disciplinary action and cho… | Twitter for iPhone | 7396 | Fri Jan 17 2020 03:22:00 GMT+0000 (Coordinated Universal Time) | |
| 1304880000000000000 | The Unsolicited Mail In Ballot Scam is a major threat to our Democracy, & the Democrats know it. Almost all recent elections using this system, even though much smaller & with far fewer Ballots to count, have ended up being a disaster. Large numbers of missing Ballots & Fraud! | Twitter for iPhone | 80527 | 23502 | Sat Sep 12 2020 20:10:00 GMT+0000 (Coordinated Universal Time) |
| 1218160000000000000 | RT @MZHemingway: Very friendly telling of events here about Comey's apparent leaking to compliant media. If you read those articles and tho… | Twitter for iPhone | 9081 | Fri Jan 17 2020 13:13:00 GMT+0000 (Coordinated Universal Time) | |
| 1217960000000000000 | RT @WhiteHouse: President @realDonaldTrump announced historic steps to protect the Constitutional right to pray in public schools! https://… | Twitter for iPhone | 25048 | Fri Jan 17 2020 00:11:00 GMT+0000 (Coordinated Universal Time) | |
| 1223640000000000000 | Getting a little exercise this morning! https://t.co/fyAAcbhbgk | Twitter for iPhone | 285863 | 30209 | Sat Feb 01 2020 16:14:00 GMT+0000 (Coordinated Universal Time) |
| 1319500000000000000 | https://t.co/4qwCKQOiOw | Twitter for iPhone | 130822 | 19127 | Fri Oct 23 2020 04:52:00 GMT+0000 (Coordinated Universal Time) |
| 1319500000000000000 | https://t.co/VlEu8yyovv | Twitter for iPhone | 153446 | 20275 | Fri Oct 23 2020 04:46:00 GMT+0000 (Coordinated Universal Time) |
| 1319500000000000000 | https://t.co/z5CRqHO8vg | Twitter for iPhone | 102150 | 14815 | Fri Oct 23 2020 04:46:00 GMT+0000 (Coordinated Universal Time) |
CREATE TABLE trumps_legcy (
"id" BIGINT,
"text" VARCHAR,
"device" VARCHAR,
"favorites" BIGINT,
"retweets" BIGINT,
"date" TIMESTAMP
);