1. Home
  2. Data
  3. What Do The Tweet Columns Mean?

What Do The Tweet Columns Mean?

# Column Description
1 Id The unique identifier for this Tweet.
2 Text The actual text of the Tweet.
3 Source Utility (e.g., iPhone, Android, Web client) used to post the Tweet.
4 Lang Language identifier corresponding to the machine-detected language of the Tweet text.
5 CreatedAt UTC time when the Tweet was created.
6 FavoriteCount The approximate number of times this Tweet has been liked by Twitter users.
7 IsRetweet Indicates whether this Tweet has been retweeted by the authenticating user.
8 RetweetCount The number of times this Tweet has been retweeted.
9 InReplyToStatusId If the represented Tweet is a reply, this will contain the original Tweet’s ID.
10 InReplyToScreenName If the represented Tweet is a reply, this will contain the screen name of the original Tweet’s author.
11 InReplyToUserId If the represented Tweet is a reply, this will contain the original Tweet’s author ID.
12 UserId The Tweet’s author ID.
13 UserName The name of the user. Not necessarily a person’s name.
14 UserScreenName The screen name or alias that this user identifies themselves with. Screen names are unique.
15 UserDescription Description of the Twitter account.
16 UserCreatedAt The UTC date and time that the user account was created on Twitter.
17 UserTweets The number of Tweets and retweets issued by the user.
18 UserFavoritesCount The number of Tweets this user has liked in the account’s lifetime.
19 UserFollowersCount The number of followers this account currently has.
20 UserFollowingCount The number of users this account is following.
21 UserListedCount The number of public lists that this user is a member of.
22 UserLocation The user-defined location for this account’s profile.
23 UserLang The language code for the user’s self-declared user interface language.
24 UserTimeZone The time zone this user declares themselves within.
25 UserUtsOffset The offset from GMT/UTC in seconds.
26 UserURL A URL provided by the user in association with their profile.
27 UserProfileImageURL A HTTP-based URL pointing to the user’s profile image.
28 UserOriginalProfileImageURLHttps A HTTPS-based URL pointing to the user’s profile image.
29 UserDefaultProfileImage When true, indicates that the user has not uploaded their own profile image and a default image is used instead.
30 CurrentUserRetweetId Details the Tweet ID of the user’s own retweet (if existent) of this Tweet.
31 GeolocationLatitude The latitude of the Tweet’s location.
32 GeoLocationLongitude The longitude of the Tweet’s location.
33 PlaceName Short human-readable representation of the place’s name this Tweet is associated with but not necessarily originating from.
34 PlaceFullName Full human-readable representation of the place’s name.
35 PlaceType The type of location represented by this place.
36 PlaceStreetAddress Street address of the place.
37 PlaceCountryCode The shortened country code representing the country containing this place.
38 PlaceCountry Name of the country containing this place.
39 PlaceBoundingBoxType The type of data encoded in the coordinates property.
40 PlaceBoundingBoxCoordinates A series of latitude and longitude points, defining a box which will contain the place entity this bounding box is related to.
41 UserMentionEntities Other Twitter users mentioned in the text of the Tweet.
42 HashtagEntities Hashtags which have been parsed out of the Tweet text.
43 URLEntities URLs included in the text of a Tweet or within textual fields of a user object.
44 MediaEntities Media elements uploaded with the Tweet.
45 Favorited Indicates whether this Tweet has been liked by the authenticating user.
46 Retweeted Indicates whether this Tweet has been retweeted by the authenticating user.
47 PossiblySensitive Indicates that the URL contained in the Tweet may contain content or media identified as sensitive content.
48 Truncated Indicates whether the text of the Tweet was truncated.
49 RetweetedStatusId The unique identifier for the original Tweet if this is a retweet, otherwise it is null.
50 RetweetedStatusText The actual text of the original Tweet if this is a retweet.
51 RetweetedStatusSource Utility used to post the original Tweet.
52 RetweetedStatusLang Language identifier of the original Tweet.
53 RetweetedStatusCreatedAt UTC time when the original Tweet was created.
54 RetweetedStatusUserId Unique identifier of the original Tweet’s author.
55 RetweetedStatusUserName Name of the original Tweet’s author. Not necessarily a person’s name.
56 RetweetedStatusScreenName Screen name or alias of the original Tweet’s author.
57 RetweetedStatusUserTweets The number of Tweets issued by the original Tweet’s author
58 RetweetedStatusUserFavoritesCount Approximate number of times the original Tweet has been liked by Twitter users.
59 RetweetedStatusUserFollowersCount The number of followers the original Tweet’s author has.
60 RetweetedStatusUserFollowingCount The number of users the original Tweet’s author is following.
61 RetweetedStatusUserListedCount The number of public lists that the original Tweet’s author is a member of.
62 Keyword The keyword or phrase used in the search.
63 UserFollowingFollowerRatio The ratio between the user’s Following and the user’s Followers.
64 UserTweetFollowingRatio The ratio between the user’s Tweets and the user’s Following.
65 UserFavoriteFollowingRatio The ratio between the user’s Favorite Count and the user’s Following.
66 UserTweetFavoriteRatio The ratio between the user’s Tweets and Favorite Count.
67 Words Words found in the Tweet and retweet.
68 URL A URL provided by the user in association with their profile.
69 InfluenceScore Score based on retweets and favorite count.

Was this article helpful?

Related Articles