Skip to main content

Table 8 Twitter data dictionary

From: Analyzing sentiments and themes on cannabis in Canada using 2018 to 2020 Twitter data

Field

Type

Description

text

String

The actual UTF-8 text of the tweet

id

String

The string representation of the unique identifier for this Tweet.

retweet_count

Int

Number of times this Tweet has been retweeted

favorite_count

Int

Nullable. Indicates approximately how many times this Tweet has been liked by Twitter users.

created_at

String

UTC time when this Tweet was created

hashtags

String

Hashtags

user_id

String

The string representation of the unique identifier for this user

user_screen_name

String

user_screen_name

user_location

String

user_location

user_followers_count

int

Number of the user’s followers

user_friends_count

int

Number of the user’s friends

user_created_at

String

UTC time when this user was created

user_geo_enabled

boolean

user_geo_enabled

coordinates

coordinates

Nullable. Represents the geographic location of this Tweet as reported by the user or client application

place

place

Nullable When present, indicates that the tweet is associated (but not necessarily originating from) a Place

in_reply_to_status_id

String

Nullable. If the represented Tweet is a reply, this field will contain the string representation of the original Tweet’s ID

in_reply_to_user_id

String

Nullable. If the represented Tweet is a reply, this field will contain the string representation of the original Tweet’s author ID. This will not necessarily always be the user directly mentioned in the Tweet.

quoted_status

Tweet

This field only surfaces when the Tweet is a quote Tweet. This attribute contains the Tweet object of the original Tweet that was quoted.

retweeted_status

Tweet

This attribute contains a representation of the original Tweet that was retweeted. Note that retweets of retweets do not show representations of the intermediary retweet, but only the original Tweet.

reply_count

int

Number of times this Tweet has been replied to