|
Column Name
|
Column Type
|
Length
|
Description
|
|---|---|---|---|
|
author
|
Character
|
128
|
The author’s
screen name.
|
|
authordescription
|
Character
|
1024
|
The author’s
description.
|
|
authorfavouritecount
|
Numeric
|
8
|
The number of tweets the author has indicated as a “favorite”.
|
|
authorfollowercount
|
Numeric
|
8
|
The number of followers the author had when the tweet was imported from Twitter.
|
|
authorfriendcount
|
Numeric
|
8
|
The number of users the author was following when the tweet was imported from Twitter.
|
|
authorid
|
Numeric
|
8
|
Twitter’s unique
ID for the author.
|
|
authorimageurl
|
Character
|
1024
|
A link to the author’s
profile image.
|
|
authorlang
|
Character
|
2
|
The BCP 47 code for the author’s self-declared user interface language.
|
|
authorlocation
|
Character
|
128
|
The author’s
self-declared location.
|
|
authorname
|
Character
|
128
|
The author’s
self-declared name in the author’s profile.
|
|
authortimezone
|
Character
|
256
|
The author’s
self-declared time zone.
|
|
authorurl
|
Character
|
1024
|
A URL provided by the
author in the author’s profile.
|
|
body
|
Character
|
1024
|
The body of the tweet.
|
|
deviceinfo
|
Character
|
1024
|
The utility that was used to post the tweet. It is represented as an HTML-formatted
string.
|
|
docid
|
Numeric
|
8
|
Twitter’s unique ID for the tweet. You can specify this variable as a unique row identifier when working with text analysis and word cloud visualizations.
|
|
doclatitude
|
Numeric
|
8
|
The latitude value of the tweet’s coordinates (if available). If it is not available,
then a missing value is populated.
|
|
doclongitude
|
Numeric
|
8
|
The longitude value of the tweet’s coordinates (if available). If it is not available,
then a missing value is populated.
|
|
isretweet
|
Numeric
|
8
|
A value of 1 indicates that the tweet is a retweet. Otherwise, the value is 0.
|
|
referenceauthor
|
Character
|
128
|
Screen name of the user to whom this tweet was a reply. If the tweet is not a reply,
then this field is empty.
|
|
referenceauthorid
|
Numeric
|
8
|
User ID of the user to whom this tweet was a reply. If the tweet is not a reply, then
the value for this field is set to
-1.
|
|
publisheddatetime
|
Numeric
|
8
|
The tweet’s published date and time as a SAS datetime value (based on the number of seconds since January 1, 1960 at midnight).
|
|
publisheddatetimestr
|
Character
|
34
|
The tweet’s published date and time in string format. Example: October
24, 2013 6:56:25 PM GMT.
|
|
tags
|
Character
|
150
|
A semi-colon separated list of hash tags that are mentioned within the tweet.
|
|
listoflinks
|
Character
|
1024
|
A semi-colon separated list of URLs that are included in the body of the tweet. Expanded
links are used where available.
|
|
mentionedusernames
|
Character
|
256
|
A semi-colon separated list of names of twitter users mentioned within the tweet.
|
|
mentionedusers
|
Character
|
256
|
A semi-colon separated list of screen names of twitter users mentioned within the
tweet.
|
|
retweetcount
|
Numeric
|
8
|
The number of times this tweet has been retweeted when the tweet was imported from
Twitter.
|