Farmers Protest Tweets Dataset (CSV)
CSV data for English tweets with the hashtag #FarmersProtest.
@kaggle.prathamsharma123_farmers_protest_tweets_dataset_csv
Tweets
@kaggle.prathamsharma123_farmers_protest_tweets_dataset_csv.tweets
- 404.44 MB
- 1084452 rows
- 14 columns
tweeturlTweetUrl | dateDate | renderedcontentRenderedContent | tweetidTweetId | useridUserId | replycountReplyCount | retweetcountRetweetCount | likecountLikeCount | quotecountQuoteCount | sourceSource | mediaMedia | retweetedtweetRetweetedTweet | quotedtweetQuotedTweet | mentionedusersMentionedUsers |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| https://twitter.com/ShashiRajbhar6/status/1376739399593910273 | 2021-03-30 03:33:46+00:00 | Support š #FarmersProtest | 1376739399593910300 | 1015969769760096400 | <a href="http://twitter.com/download/android" rel="nofollow">Twitter for Android</a> | nan | nan | nan | |||||
| https://twitter.com/kaursuk06272818/status/1376739306287427584 | 2021-03-30 03:33:23+00:00 | Supporting farmers means supporting our country #StopHateAgainstFarmers #FarmersProtest https://t.co/iWPatTK6NV | 1376739306287427600 | 1332937272581263400 | <a href="http://twitter.com/download/android" rel="nofollow">Twitter for Android</a> | [{'previewUrl': 'https://pbs.twimg.com/media/ExspGifU8AI27LX?format=jpg&name=small', 'fullUrl': 'https://pbs.twimg.com/media/ExspGifU8AI27LX?format=jpg&name=large', 'type': 'photo'}] | nan | nan | |||||
| https://twitter.com/kaursuk06272818/status/1376738704128020488 | 2021-03-30 03:31:00+00:00 | Support farmers if you are related to food #StopHateAgainstFarmers #FarmersProtest https://t.co/TcoZx4ZmyU | 1376738704128020500 | 1332937272581263400 | <a href="http://twitter.com/download/android" rel="nofollow">Twitter for Android</a> | [{'previewUrl': 'https://pbs.twimg.com/media/Exsoje8U4AQbpik?format=jpg&name=small', 'fullUrl': 'https://pbs.twimg.com/media/Exsoje8U4AQbpik?format=jpg&name=large', 'type': 'photo'}] | nan | nan | |||||
| https://twitter.com/SukhdevSingh_/status/1376738640542400518 | 2021-03-30 03:30:45+00:00 | #StopHateAgainstFarmers support #FarmersProtest by pressurising got. to accept farmer's genuine demand. | 1376738640542400500 | 1308356658582618000 | 1 | 3 | <a href="http://twitter.com/download/android" rel="nofollow">Twitter for Android</a> | nan | nan | nan | |||
| https://twitter.com/Davidmu66668113/status/1376738579171344386 | 2021-03-30 03:30:30+00:00 | You hate farmers I hate you, if you love them I love you! ;) #StopHateAgainstFarmers #FarmersProtest | 1376738579171344400 | 1357311756532650000 | 1 | <a href="http://twitter.com/download/android" rel="nofollow">Twitter for Android</a> | nan | nan | nan | ||||
| https://twitter.com/Abhimanyu_1987/status/1376738436099399686 | 2021-03-30 03:29:56+00:00 | They can't be farmers. Looks like Gundas are having good time. They seem to be violence thirsty goons. #FarmersProtest twitter.com/IndiaToday/staā¦ | 1376738436099399700 | 2918610912 | <a href="http://twitter.com/download/android" rel="nofollow">Twitter for Android</a> | nan | {'url': 'https://twitter.com/IndiaToday/status/1376730134237999105', 'date': '2021-03-30T02:56:57+00:00', 'content': "This comes a day after a party MLA was allegedly assaulted by a group of farmers protesting against the Centre's farm laws.\n#Punjab \nhttps://t.co/DHdHMhticH", 'renderedContent': "Tā¦ | nan | |||||
| https://twitter.com/singhwhotweets/status/1376738161800306690 | 2021-03-30 03:28:50+00:00 | Lets not forget that our Farmers are STILL out there protesting. Please pray for them. #FarmersProtest https://t.co/BP95cPmftD | 1376738161800306700 | 1237420463581728800 | 2 | 3 | <a href="http://twitter.com/download/android" rel="nofollow">Twitter for Android</a> | [{'previewUrl': 'https://pbs.twimg.com/media/ExsoDKlVEAMCcPF?format=jpg&name=small', 'fullUrl': 'https://pbs.twimg.com/media/ExsoDKlVEAMCcPF?format=jpg&name=large', 'type': 'photo'}, {'previewUrl': 'https://pbs.twimg.com/media/ExsoDZhVcAQ3-aK?format=jpg&name=small', 'fullUrl': 'https://pbs.twimg.comā¦ | nan | nan | |||
| https://twitter.com/J_cheeselover/status/1376738155110395904 | 2021-03-30 03:28:49+00:00 | @Troll48611422 @Doabapunjab1 @Terminator00096 @HarjasK1 @_theshivatribe_ @Arshdee00485709 @tamankaur_ @sukhisukhii @WalterW28442171 @amaanbali thats your best comeback ?š lol so the only word you could understand was āyoā oh my my nd who the eef r u to tell me which language i should be talk in? uā¦ | 1376738155110396000 | 1361422240223350800 | 1 | <a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a> | [{'thumbnailUrl': 'https://pbs.twimg.com/tweet_video_thumb/ExsoDZmVoAUWLh2.jpg', 'variants': [{'contentType': 'video/mp4', 'url': 'https://video.twimg.com/tweet_video/ExsoDZmVoAUWLh2.mp4', 'bitrate': None}], 'type': 'gif'}] | nan | [{'username': 'Troll48611422', 'displayname': 'Crime Master Gogo', 'id': 1357649482196766723, 'description': None, 'rawDescription': None, 'descriptionUrls': None, 'verified': None, 'created': None, 'followersCount': None, 'friendsCount': None, 'statusesCount': None, 'favouritesCount': None, 'listedā¦ | ||||
| https://twitter.com/DigitalKisanBot/status/1376737987791323142 | 2021-03-30 03:28:09+00:00 | Neutrality helps the oppressor, never the victim. Silence encourages the tormentor, never the tormented Speak up for FARMERS #FarmersProtest 03:28:09 | 1376737987791323100 | 1309302936317636600 | nan | nan | nan | nan | |||||
| https://twitter.com/rajriarhughes/status/1376737966530338819 | 2021-03-30 03:28:04+00:00 | Why You Should Visit the F.A.R.M.E.R. at Tikri Border at Least Once #StopHateAgainstFarmers #FarmersProtest thewire.in/rights/tikri-bā¦ via @thewire_in | 1376737966530338800 | 858383035137273900 | <a href="https://mobile.twitter.com" rel="nofollow">Twitter Web App</a> | nan | nan | [{'username': 'thewire_in', 'displayname': 'The Wire', 'id': 3150940290, 'description': None, 'rawDescription': None, 'descriptionUrls': None, 'verified': None, 'created': None, 'followersCount': None, 'friendsCount': None, 'statusesCount': None, 'favouritesCount': None, 'listedCount': None, 'mediaCā¦ |
CREATE TABLE tweets (
"tweeturl" VARCHAR,
"date" VARCHAR,
"renderedcontent" VARCHAR,
"tweetid" DOUBLE,
"userid" DOUBLE,
"replycount" BIGINT,
"retweetcount" BIGINT,
"likecount" BIGINT,
"quotecount" BIGINT,
"source" VARCHAR,
"media" VARCHAR,
"retweetedtweet" VARCHAR,
"quotedtweet" VARCHAR,
"mentionedusers" VARCHAR
);