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
id Twitter identifier for the tweet. 114749583439036416
tweet_url URL of the tweet on Twitter’s website. If the tweet is a retweet, the URL will be redirected to the original tweet. https://twitter.com/NASA/ status/394883921303056384
created_at Date and time the tweet was created, in Twitter’s default format. Fri Sep 16 17:16:47 +0000 2011
parsed_created_at Date and time the tweet was created, in ISO 8601 format and UTC time zone. 2016-12-21T19:30:03+00:00
user_screen_name The unique screen name of the account that authored the tweet, at the time the tweet was posted. Screen names are generally displayed with a @ prefixed. Note that an account’s screen name may change over time. NASA
text The text of the tweet. Newline characters are replaced with a space. Observing Hurricane Raymond Lashing Western Mexico: Low pressure System 96E developed quickly over the… http://t.co/YpffdKVrgm
tweet_type original, reply, quote, or retweet retweet
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]
hashtags Hashtags from the tweet text, as a comma-separated list. Hashtags are generally displayed with a # prefixed. Mars, askNASA
media URLs of media objects (photos, videos, GIFs) that are attached to the tweet. https://twitter.com/NASA_Orion/status/ 394866827857100800/photo/1
urls URLs entered by user as part of tweet. Note that URL may be a shortened URL, e.g. from bit.ly. http://instagram.com/p/gA_zQ5IaCz/
favorite_count Number of times this tweet had been favorited/liked by other users at the time the tweet was collected. 12
in_reply_to_screen_name If tweet is a reply, the screen name of the author of the tweet that is being replied to. NASA
in_reply_to_status_id If tweet is a reply, the Twitter identifier of the tweet that is being replied to. 114749583439036416
in_reply_to_user_id If tweet is a reply, the Twitter identifier of the author of the tweet that is being replied to. 481186914
lang Language of the tweet text, as determined by Twitter. en
place The user or application-provided geographic location from which a tweet was posted. Washington, DC
possibly_sensitive Indicates that URL contained in the tweet may reference sensitive content. true
retweet_count Number of times the tweet had been retweeted at the time the tweet was collected. 25
retweet_or_quote_id If tweet is a retweet or quote tweet, the Twitter identifier of the source tweet. 114749583439036416
retweet_or_quote_screen_name If tweet is a retweet or quote tweet, the screen name of the author of the source tweet. NASA
retweet_or_quote_user_id If tweet is a retweet or quote tweet, the Twitter identifier of the author or the source tweet. 481186914
source The application from which the tweet was posted. <a href=”http://twitter.com/download/ iphone” rel=”nofollow”>Twitter for iPhone</a>
user_id Twitter identifier for the author of the tweet. 481186914
user_created_at Date and time the tweet was created, in Twitter’s default format. Wed Mar 18 13:46:38 +0000 2009
user_default_profile_image URL of the user’s profile image. https://pbs.twimg.com/profile_images/ 942858479592554497/BbazLO9L_normal.jpg
user_description The user-provided account description. Newline characters are replaced with a space. The safest spacecraft designed by NASA, Orion will carry humans to the moon and beyond.
user_favourites_count Number of tweets that have been favorited/liked by the user. 19
user_followers_count Number of followers this account had at the time the tweet was collected. 235
user_friends_count Number of users this account was following at the time the tweet was collected. 114
user_listed_count Number of public lists that this user is a member of. 3
user_location The user’s self-described location. Not necessarily an actual place. San Francisco, California
user_name The user’s self-provided name. Orion Spacecraft
user_statuses_count Number of tweets that the user has posted. 2375
user_time_zone The user-provided time zone. Currently deprecated. Eastern Time (US & Canada)
user_urls URLs entered by user as part of user’s description. http://www.Instagram.com/realDonaldTrump
user_verified Indicates that the user’s account is verified. true

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