Data Dictionaries for CSV/Excel Exports

Social Feed Manager captures a variety of data from each platform. These data dictionaries give explanations for each selected and processed field in exports.

Note that these are subsets of the data that are collected for each post. The full data is available for export by selecting “Full JSON” as the export format or by exporting from the commandline. See Command-line exporting/processing.

Twitter Dictionary

For more info about source tweet data, see the Twitter API documentation, including Tweet data dictionaries.

Documentation about older archived tweets is archived by the Wayback Machine for the Twitter API, Tweets, and Entities.

Field Description Example
created_at Date and time the tweet was created, in ISO 8601 format and UTC time zone. 2016-12-21T19:30:03+00:00
twitter_id Twitter identifier for the tweet. 114749583439036416
screen_name The unique screen name of the account that authored the tweet, at the time the tweet was posted. Note that an account’s screen name may change over time. NASA
location The user’s self-described location. San Francisco, California
followers_count Number of followers this account had at the time the tweet was harvested. 235
friends_count Number of users this account was following at the time the tweet was harvested. 114
favorite_count/ like_count Number of times this tweet had been favorited/liked by other users at the time the tweet was harvested. 12
retweet_count Number of times this tweet had been retweeted at the time the tweet was harvested. 25
hashtags Hashtags from the tweet text, as a comma-separated list. Mars, askNASA
mentions Other Twitter accounts mentioned in the text of the tweet, separated by comma and space. NASA_Airborne, NASA_Ice
in_reply_to_screen_name If the tweet is a reply, the screen name of the original tweet’s author. wiredscience
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
text The text of the tweet. Newline characters are stripped out. Observing Hurricane Raymond Lashing Western Mexico: Low pressure System 96E developed quickly over the... http://t.co/YpffdKVrgm
is_retweet Yes if tweet is a retweet of another tweet, according to the tweet’s metadata; otherwise No. Yes
is_quote Yes if tweet is a quote of another tweet, according to the tweet’s metadata; otherwise No. No
coordinates The geographic coordinates of the tweet. This is only enabled if geotagging is enabled on the account. The value, if present, is of the form [longitude, latitude] [-0.22012208, 51.59248806]
url1 First URL in text of tweet, as shortened by Twitter. http://t.co/WGJ9VmoKME
url1_expanded Expanded version of url1; URL entered by user and displayed in Twitter. Note that the user-entered URL may itself be a shortened URL, e.g. from bit.ly. http://instagram.com/p/gA_zQ5IaCz/
url2 Second URL in text of tweet, as shortened Twitter. https://t.co/ZTUQZcikJa
url2_expanded Expanded version of url2; URL entered by user and displayed in Twitter. Note that the user-entered URL may itself be a shortened URL, e.g. from bit.ly. http://instagram.com/p/gA_zQ5IaCz/
media_url URL of the media embedded in the tweet. If the media embedded in the tweet is a video, this is the URL of the video’s thumbnail image http://pbs.twimg.com/media/Cyir15CVIAAfAWd.jpg

Tumblr Dictionary

For more info about source tweet data, see the Tumblr API documentation, particularly Posts.

Documentation about older archived posts is archived by the Wayback Machine for the original Tumblr API and the newer Tumblr API.

Field Description Example
created_at Date and time the tweet was created, in ISO 8601 format and UTC time zone. 2016-12-21 19:30:03+00:00
tumblr_id Tumblr identifier for the blog post 154774150409
blog_name The short name used to uniquely identify a blog. This is the first part of the blog url, like <nasa.tumblr.com>. nasa
post_type The type of post, such as one of the following: text, quote, link, answer, video, audio, photo, or chat. text
post_slug Text summary of the post, taken from the final portion of the url. 10-questions-for-our-chief-scientist
post_summary Text summary of the post, taken from the title of the post. 10 Questions for Our Chief Scientist
post_text Body of the post text, using html markup. See https://notepad.pw/w8133kzj
tags Hashtags from the post as a comma-separated list. nasa, space, solarsystem, chiefscientist, scientist
tumblr_url Full url location of the post. http://nasa.tumblr.com/post/154774150409/ 10-questions-for-our-chief-scientist
tumblr_short_url Short url of the post. https://tmblr.co/Zz_Uqj2G9GXq9

Flickr Dictionary

For more info about source tweet data, see the Flickr API documentation, particularly People and Photos.

Documentation about older archived posts is archived by the Wayback Machine here.

Field Description Example
photo_id Unique Flickr identifier of the photo. 11211844604
date_posted Date and time that the post was uploaded to Flickr, in ISO 8601 format and UTC time zone. 2013-12-04 21:39:40+00:00
date_taken Date and time that media was captured, either extracted from EXIF or from the date posted, in mm/dd/yyyy hh:mm format. 6/7/2014 13:35
license

Licensing allowed for media, given as a numeral according to the following key:

  • 0 = All Rights Reserved
  • 1 = Attribution-NonCommercial-Sharealike License
  • 2 = Attribution-NonCommercial License
  • 3 = Attribution-NonCommercial NoDerivs License
  • 4 = Attribution License
  • 5 = Attribution-ShareAlike License
  • 6 = Attribution-NoDerivs License
  • 7 = No known copyright restrictions
  • 8 = United States Government work
  • More information at creativecommons.org/licenses
4 (Attribution license)
safety_level

Appropriateness of post, given as a numeral according to the following key:

  • 0 = Safe - Content suitable for everyone
  • 1 = Moderate - Approximately PG-13 content
  • 2 = Restricted - Approximately R rated content
0 (Safe level)
original_format File format of uploaded media. jpg
owner_nsid Unique Flickr identifier of the owner account. 28399705@N04
owner_username Unique plaintext username of the owner account. GW Museum and Textile Museum
title Title of the post. Original Museum entrance
description Short description of the post. Historic photo courtesy of The Textile Museum Archives.
media Media type of the post. photo
photopage Location url of the post. https://www.flickr.com/photos/textilemuseum/ 11211844604/

Weibo Dictionary

For more info about source tweet data, see the Sina Weibo API friends_timeline documentation.

Documentation about older archived tweets is archived by the Wayback Machine here.

Note that for privacy purposes, Weibo dictionary examples are not consistent.

Field Description Example
created_at Date and time the tweet was created, in ISO 8601 format and UTC time zone. 2016-12-21T19:30:03+00:00
weibo_id Sina Weibo identifier for the tweet. 4060309792585658
screen_name The unique screen name of the account that authored the weibo, at the time the weibo was posted. 下厨房
followers_count Number of followers this account had at the time the weibo was harvested. 3655329
friends_count Number of users this account was following at the time the weibo was harvested. 2691
reposts_count Number of times this weibo had been reposted at the time the weibo was harvested. 68
topics Topics (similar to hashtags) from the weibo text as a comma-separated list. 魅族三分时刻
in_reply_to_screen_name If the weibo is a reply, the screen name of the original weibo’s author. (This is not yet supported by Sina Weibo.) 下厨房
weibo_url URL of the weibo. If the tweet is a retweet made http://m.weibo.cn/1618051664/4060300716095462
text The text of the weibo. 马住!
url1 First URL in text of weibo, as shortened by Sina Weibo. http://t.cn/RM2xyx6
url2 Second URL in text of weibo, as shortened by Sina Weibo. http://t.cn/Rc52gDY
retweeted_text Text of original weibo when the collected weibo is a repost. 马住!
retweeted_url1 First URL in text of original weibo, as shortened by Sina Weibo. http://t.cn/RVR4cAQ
retweeted_url2 Second URL in text of original weibo, as shortened by Sina Weibo. http://t.cn/RMAJISP