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. |
|
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. |
|
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. |
|
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. |
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. |
|
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. |
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 |
|
text |
The text of the weibo. |
马住! |
url1 |
First URL in text of weibo, as shortened by Sina Weibo. |
|
url2 |
Second URL in text of weibo, as shortened by Sina Weibo. |
|
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. |
|
retweeted_url2 |
Second URL in text of original weibo, as shortened by Sina Weibo. |