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 Commandline exporting/processing.
Twitter Dictionary¶
For more info about source tweet data, see the Twitter API documentation, including Tweets and Entities.
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:
|
4 (Attribution license) |
safety_level | Appropriateness of post, given as a numeral according to the following key:
|
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 |