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