# | 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. |