Retweets
Query a list of retweets of the authenticated user.
View Specific Information
Select
Tweets from the authenticated user that have been retweeted by other users will appear in Retweets by default.
The Min_Id and Max_Id pseudo columns may be used to narrow down a range of retweets to return, or to return only recent retweets. Ids are created in increasing numerical order on Twitter. Specifying a Min_Id will return only results with a greater Id or tweets that were created more recently than the specified one. Setting a Max_Id will return only tweets that are older than the creation date of the specified Id. Note that while these values must be valid, non-negative numbers, they do not have to be Ids that exist.
Columns
| Name | Type | Description |
| ID [KEY] | String | The Id of the status update or tweet. |
| IDLong | Long | The long type Id of the status update or tweet. |
| Created_At | Datetime | When the tweet was made. |
| Text | String | The text of the tweet. |
| Lang | String | Language code the tweet was made in. |
| Source | String | Source of the tweet. |
| Favorited | Boolean | Boolean indicating if this tweet has been favorited. |
| Favorite_Count | Integer | The approximate number of times this tweet has been favorited. |
| Retweeted | Boolean | Boolean indicating if this tweet has been retweeted. |
| Retweet_Count | Integer | The number of times the tweet has been retweeted. |
| Retweeted_Status_Id | String | Id of the tweet which was retweeted by this one. Empty if the current tweet is not a retweet. |
| Truncated | Boolean | Boolean indicating if this tweet has been truncated. |
| Filter_Level | String | Indicates the maximum value that may be used and still stream this tweet. |
| Possibly_Sensitive | String | This field is available only when a tweet contains a link. The meaning of the field does not pertain to the tweet content itself, but instead it is an indicator that the URL contained in the tweet may contain content or media identified as sensitive content. |
| Withheld_Copyright | Boolean | When present and set to true, it indicates that this piece of content has been withheld due to a DMCA complaint. |
| Withheld_Scope | String | When present, this column indicates whether the content being withheld is the status or a user. |
| Withheld_In_Countries | String | A list of uppercase, two-letter country codes of the countries this content is withheld from. |
| Contributors | String | An XML collection of user objects (usually only one) indicating users who contributed to the authorship of the tweet, on behalf of the official tweet author. |
| Coordinates_Coordinates | String | The geographic coordinates of this tweet (longitude first, then latitude). |
| Coordinates_Type | String | The type of coordinate, if applicable. |
| Place_Full_Name | String | The full name of the location of this tweet (city and state). |
| Place_Country | String | The country of origin of this tweet. |
| Current_User_Retweet_Id | String | Details the tweet Id of the authenticated user's own retweet (if it exists) of this tweet. |
| Scopes | String | A set of key-value pairs indicating the intended contextual delivery of the containing tweet. Currently used by Twitter's promoted products. |
| In_Reply_To_Status_Id | String | Represents the Id of the original status if this tweet is in reply to another. |
| User_Id | String | Id of the user who made the tweet. Use this in the WHERE clause to get retweets for a specific user other than the authenticated user. |
| User_Name | String | Name of the user who made the tweet. |
| User_Screen_Name | String | Screen name of the user who made the tweet. |
| User_Location | String | Location of the user who made the tweet. |
| User_Profile_URL | String | URL to the user who made the tweet. |
| User_Profile_Image_Url | String | URL to the profile image for the user who made the tweet. |
| User_Mentions | String | Mentions of other users in the tweet, returned as an XML aggregate. |
| URLs | String | URLs in the tweet, returned as an XML aggregate. |
| Hashtags | String | Hashtags in the tweet, returned as an XML aggregate. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| NextPageToken | String | An identifier to retrieve the next page of results. Specify only if an error occurs during the original request. Make sure any criteria specified in the original request are still specified when using the NextPageToken. |
| Min_ID | String | Specifies the lowest Id to return results for. Ids are stored in increasing numerical order, so specifying this value means that only retweets that are equal to or newer than the creation date of the specified Id will be returned. The Min_Id must be a valid number but does not need to be a valid retweet Id. |
| Max_ID | String | Specifies the highest Id to return results for. Ids are stored in increasing numerical order, so specifying this value means that only retweets that are equal to or older than the creation date of the specified Id will be returned. The Max_Id must be a valid number but does not need to be a valid retweet Id. |
| Include_Entities | Boolean | Boolean indicating whether or not to include entities such as URLs, hashtags, and user mentions in the response.
The default value is false. |