Skip to content

Data Dictionary for CSV export

Laura Wrubel edited this page Feb 12, 2014 · 3 revisions
Field Description Example
sfm_id SFM internal identifier for tweet 6114
created_at UTC time when the tweet was created 2013-10-28T17:52:53Z
created_at_date date in Excel-friendly format, MM/DD/YYYY 10/28/2013
twitter_id Twitter identifier for the tweet 114749583439036416
screen_name The screen name, handle, or alias that this user identifies themselves with. Screen_names are unique but subject to change. NASA
followers_count Number of followers this account had at the time the tweet was harvested 5158956
friends_count Number of users this account is following at the time the tweet was harvested 202
retweet_count Number of times the tweet has been retweeted at the time the tweet was harvested. If the tweet is a retweet AND the retweet was done using the Twitter retweet feature (i.e. is_reweet_strict = TRUE) the retweet_count reflects the retweet count for the original tweet. If the retweet was done by typing RT at the beginning (is_retweet_strict = FALSE) the retweet_count reflects retweets of the retweet. 185
hashtags Hashtags which have been parsed out of the tweet text, separated by a comma and space Mars, askNASA
in_reply_to_screen_name If the tweet is a reply, the screen name of the original tweet's author wiredscience
mentions Other Twitter users mentioned in the text of the tweet, separated by comma and space. @NASA_Airborne, @NASA_Ice
twitter_url URL of the tweet. If the tweet is a retweet made using the Twitter retweet feature, the URL will redirect to the original tweet http://twitter.com/NASA/status/394883921303056384 retweet redirecting to original tweet-- http://twitter.com/NASA/status/394875351894994944
is_retweet_strict Tweet is a retweet of another tweet, using Twitter's retweet function. FALSE
is_retweet SFM's best guess at whether tweet is a retweet of another tweet; includes retweets accomplished using old-style method of placing RT in front of tweet TRUE
text The UTF-8 text of the tweet. Observing Hurricane Raymond Lashing Western Mexico: Low pressure System 96E developed quickly over the... http://t.co/YpffdKVrgm
url1 First URL in text of tweet, as shortened by Twitter http://t.co/WGJ9VmoKME
url1_expanded Expanded version of URL; URL entered by user and displayed in Twitter. May itself be a user-shortened URL, e.g. from bit.ly. Further expansion available in sfm web interface, not in csv export. http://instagram.com/p/gA_zQ5IaCz/
url2 Second URL in text of tweet, as shortened by Twitter.
url2_expanded Expanded version of URL; URL entered by user and displayed in Twitter. May itself be a user-shortened URL, e.g. from bit.ly. Further expansion available in SFM web interface, not in csv export.

For more info about source tweet data, see Twitter API documentation, including: Tweets and Entities.

Clone this wiki locally