TweetStream
Query public data flowing through Twitter.
View Specific Information
TweetStream is a stream that continuously reads public Tweets until the operation is killed. When querying the TweetStream view, you only receive tweets that match against the available rules. To manage the rules use the StreamRules table.
Select
Below is the field you can use to filter the results.
| BackfillCount | By passing this parameter, you can recover up to five minutes worth of data that you might have missed during a disconnection. The backfilled Tweets automatically flow through a reconnected stream, with older Tweets generally being delivered before any newly matching Tweets. You must include a whole number between 1 and 5 as the value to this parameter. To use this, please make sure your system is tolerant of duplicate data. |
The following is an example of a query that recovers one minute's worth of data:
SELECT Id, Tweet FROM TweetStream WHERE BackfillMinutes = 1
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier of the Tweet. |
| RuleId [KEY] | String | ID of the filter rule that matched against the Tweet delivered. |
| AuthorId | String | Unique identifier of the author. |
| ContextAnnotations | String | Contains context annotations for the Tweet. |
| ConversationId | String | The Tweet ID of the original Tweet of the conversation (which includes direct replies, replies of replies). |
| CreatedAt | Datetime | Creation time of the Tweet. |
| Entities | String | Contains details about text that has a special meaning in a Tweet. |
| InReplyToUserId | String | If this Tweet is a Reply, indicates the user ID of the parent Tweet's author. |
| Lang | String | Language of the Tweet, if detected by Twitter. Returned as a BCP47 language tag. |
| PossiblySensitive | Bool | Indicates if this Tweet contains URLs marked as sensitive, for example content suitable for mature audiences. |
| ReferencedTweets | String | A list of Tweets this Tweet refers to. |
| ReplySettings | String | Shows who can reply to this Tweet. Fields returned are everyone, mentionedUsers, and following. |
| Source | String | The name of the app the user Tweeted from. |
| Text | String | The content of the Tweet. |
| EditHistoryTweetIds | String | Unique identifiers indicating all versions of an edited Tweet. For Tweets with no edits, there will be one ID. For Tweets with an edit history, there will be multiple IDs. |
| GeoCoordinates | String | A pair of decimal values representing the precise location of the user (latitude, longitude). This value be null unless the user explicitly shared their precise location. |
| GeoCoordinatesType | String | Describes the type of coordinate. |
| GeoPlaceId | String | The unique identifier of the place, if this is a point of interest tagged in the Tweet. |
| AttachmentsMediaKeys | String | List of unique identifiers of media attached to this Tweet. |
| AttachmentsPollIds | String | List of unique identifiers of polls present in the Tweets returned. |
| EditsRemaining | Int | Indicates the number of remaining edits for the tweet. |
| IsEditEligible | Bool | Indicates if a Tweet is eligible for edit. |
| EditableUntil | Datetime | Indicates how long the tweet is editable for. |
| RetweetCount | Int | Number of times this Tweet has been Retweeted. |
| ReplyCount | Int | Number of Replies of this Tweet. |
| LikeCount | Int | Number of Likes of this Tweet. |
| QuoteCount | Int | Number of times this Tweet has been Retweeted with a comment (also known as Quote). |
| ImpressionCount | Int | Number of times this Tweet has been viewed. |
| WithheldCopyRight | String | Indicates if the content is being withheld for on the basis of copyright infringement. |
| WithheldCountryCodes | String | Provides a list of countries where this content is not available. |
| WithheldScope | String | Indicates whether the content being withheld is a Tweet or a user. |
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 |
| BackfillMinutes | Int | By passing this parameter, you can recover up to five minutes worth of data that you might have missed during a disconnection. The backfilled Tweets will automatically flow through a reconnected stream, with older Tweets generally being delivered before any newly matching Tweets. You must include a whole number between 1 and 5 as the value to this parameter. To use this, please make sure your system is tolerant of duplicate data. |