Dataset: Pulwama Killing Twitter Data

About this Dataset

Pulwama Killing Twitter Data

This file contains 9213 tweets that are reaction to the incident of 11 killings at Pulwama, Jammu and Kashmir. This data can be used to varying sentiment analysis from each region to another with respect to time.
In the context of India-Pak relations, this data may give a good indicator of how the sentiments are different across regions and over time.

Tables

Kashmir

@kaggle.umarhabib_pulwama_killing_twitter_data.kashmir

3.36 MB
9213 rows
89 columns


CREATE TABLE kashmir (
  "user_id" VARCHAR,
  "status_id" VARCHAR,
  "created_at" VARCHAR,
  "screen_name" VARCHAR,
  "text" VARCHAR,
  "source" VARCHAR,
  "display_text_width" BIGINT,
  "reply_to_status_id" VARCHAR,
  "reply_to_user_id" VARCHAR,
  "reply_to_screen_name" VARCHAR,
  "is_quote" BOOLEAN,
  "is_retweet" BOOLEAN,
  "favorite_count" BIGINT,
  "retweet_count" BIGINT,
  "hashtags" VARCHAR,
  "symbols" VARCHAR,
  "urls_url" VARCHAR,
  "urls_t_co" VARCHAR,
  "urls_expanded_url" VARCHAR,
  "media_url" VARCHAR,
  "media_t_co" VARCHAR,
  "media_expanded_url" VARCHAR,
  "media_type" VARCHAR,
  "ext_media_url" VARCHAR,
  "ext_media_t_co" VARCHAR,
  "ext_media_expanded_url" VARCHAR,
  "ext_media_type" VARCHAR,
  "mentions_user_id" VARCHAR,
  "mentions_screen_name" VARCHAR,
  "lang" VARCHAR,
  "quoted_status_id" VARCHAR,
  "quoted_text" VARCHAR,
  "quoted_created_at" VARCHAR,
  "quoted_source" VARCHAR,
  "quoted_favorite_count" DOUBLE,
  "quoted_retweet_count" DOUBLE,
  "quoted_user_id" VARCHAR,
  "quoted_screen_name" VARCHAR,
  "quoted_name" VARCHAR,
  "quoted_followers_count" DOUBLE,
  "quoted_friends_count" DOUBLE,
  "quoted_statuses_count" DOUBLE,
  "quoted_location" VARCHAR,
  "quoted_description" VARCHAR,
  "quoted_verified" VARCHAR,
  "retweet_status_id" VARCHAR,
  "retweet_text" VARCHAR,
  "retweet_created_at" VARCHAR,
  "retweet_source" VARCHAR,
  "retweet_favorite_count" VARCHAR,
  "retweet_retweet_count" VARCHAR,
  "retweet_user_id" VARCHAR,
  "retweet_screen_name" VARCHAR,
  "retweet_name" VARCHAR,
  "retweet_followers_count" VARCHAR,
  "retweet_friends_count" VARCHAR,
  "retweet_statuses_count" VARCHAR,
  "retweet_location" VARCHAR,
  "retweet_description" VARCHAR,
  "retweet_verified" VARCHAR,
  "place_url" VARCHAR,
  "place_name" VARCHAR,
  "place_full_name" VARCHAR,
  "place_type" VARCHAR,
  "country" VARCHAR,
  "country_code" VARCHAR,
  "geo_coords" VARCHAR,
  "coords_coords" VARCHAR,
  "bbox_coords" VARCHAR,
  "status_url" VARCHAR,
  "name" VARCHAR,
  "location" VARCHAR,
  "description" VARCHAR,
  "url" VARCHAR,
  "protected" BOOLEAN,
  "followers_count" BIGINT,
  "friends_count" BIGINT,
  "listed_count" BIGINT,
  "statuses_count" BIGINT,
  "favourites_count" BIGINT,
  "account_created_at" VARCHAR,
  "verified" BOOLEAN,
  "profile_url" VARCHAR,
  "profile_expanded_url" VARCHAR,
  "account_lang" VARCHAR,
  "profile_banner_url" VARCHAR,
  "profile_background_url" VARCHAR,
  "profile_image_url" VARCHAR,
  "country_name" VARCHAR
);