Dataset: Farmers Protest Tweets Dataset (CSV)

About this Dataset

Farmers Protest Tweets Dataset (CSV)

Context

The 2020–2021 Indian farmers' protest is an ongoing protest against three farm acts which were passed by the Parliament of India in September 2020. Farmer unions and their representatives have demanded that the laws be repealed and have stated that they will not accept a compromise.

In the light of this protest, social media users have been very active in voicing their opinion about the matter. "#FarmersProtest" is very prevalent on Twitter, with thousands of users tweeting thousands of tweets with the hashtag.

Content

The dataset consists of 2 CSV files, one containing data about the tweets that have the hashtag "#FarmersProtest" (tweeted since November 1, 2020) and the second having data about users who tweeted with the hashtag.

The latest version (updated 21-11-2021) contains ~1,000,000 tweets tweeted since November 1, 2020 until November 21, 2021, by ~170,000 Twitter users.

Acknowledgements

A big thank you to Martin Beck for this easy-to-follow tutorial on how to use snscrape to scrape tweets using the Twitter API.

Tables

Tweets

@kaggle.prathamsharma123_farmers_protest_tweets_dataset_csv.tweets

404.44 MB
1084452 rows
14 columns


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
);

Users

@kaggle.prathamsharma123_farmers_protest_tweets_dataset_csv.users

41.29 MB
235660 rows
19 columns


CREATE TABLE users (
  "username" VARCHAR,
  "displayname" VARCHAR,
  "userid" DOUBLE,
  "rawdescription" VARCHAR,
  "descriptionurls" VARCHAR,
  "verified" BOOLEAN,
  "created" VARCHAR,
  "followerscount" BIGINT,
  "friendscount" BIGINT,
  "statusescount" BIGINT,
  "favouritescount" BIGINT,
  "listedcount" BIGINT,
  "mediacount" BIGINT,
  "location" VARCHAR,
  "protected" BOOLEAN,
  "linkurl" VARCHAR,
  "profileimageurl" VARCHAR,
  "profilebannerurl" VARCHAR,
  "profileurl" VARCHAR
);