Introduction

Datasources and destinations

Fields listing for X / Twitter Public Data

Account Id
Unique identifier of this user. This is returned as a string in order to avoid complications with languages and tools that cannot handle large integers.
Field IDaccount/id
TypeTEXT
Data Typedimension
Account Name
The friendly name of this user, as shown on their profile.
Field IDaccount/name
TypeTEXT
Data Typedimension
Account Username
The Twitter handle (screen name) of this user.
Field IDaccount/username
TypeTEXT
Data Typedimension
Account Created At
Field IDaccount/created_at
TypeYEAR_MONTH_DAY
Data Typedimension
Account Most Recent Tweet Id
The ID of the User's most recent Tweet
Field IDaccount/most_recent_tweet_id
TypeTEXT
Data Typedimension
Account Protected
Indicates if this user has chosen to protect their Tweets (in other words, if this user's Tweets are private).
Field IDaccount/protected
TypeBOOLEAN
Data Typedimension
Account Country Codes
Provides a list of countries where this user is not available.
Field IDaccount/withheld.country_codes
TypeTEXT
Data Typedimension
Account Scope
Indicates whether the content being withheld is a Tweet or a user (this API will return user).
Field IDaccount/withheld.scope
TypeTEXT
Data Typedimension
Account Location
The location specified in the user's profile, if the user provided one. As this is a freeform value, it may not indicate a valid location, but it may be fuzzily evaluated when performing searches with location queries.
Field IDaccount/location
TypeTEXT
Data Typedimension
Account URL
The URL specified in the user's profile, if present.
Field IDaccount/url
TypeTEXT
Data Typedimension
Account Description
The text of this user's profile description (also known as bio), if the user provided one.
Field IDaccount/description
TypeTEXT
Data Typedimension
Account Verified
Indicate if this user is a verified Twitter user.
Field IDaccount/verified
TypeBOOLEAN
Data Typedimension
Account Verified Type
Indicates the type of verification for the Twitter account.
Field IDaccount/verified_type
TypeTEXT
Data Typedimension
Account Profile Image Url
The URL to the profile image for this user, as shown on the user's profile.
Field IDaccount/profile_image_url
TypeTEXT
Data Typedimension
Account Pinned Tweet Id
Unique identifier of this user's pinned Tweet.
Field IDaccount/pinned_tweet_id
TypeTEXT
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
TypeHOUR
Data Typedimension
Followers Count
Number of users who follow this user.
Field IDpublic_metrics.followers_count
TypeNUMBER
Data Typemetric
Following Count
Number of users this user is following.
Field IDpublic_metrics.following_count
TypeNUMBER
Data Typemetric
Tweet Count
Number of Tweets (including Retweets) posted by this user.
Field IDpublic_metrics.tweet_count
TypeNUMBER
Data Typemetric
Listed Count
Number of lists that include this user.
Field IDpublic_metrics.listed_count
TypeNUMBER
Data Typemetric
Like Count
Number of likes.
Field IDpublic_metrics.like_count
TypeNUMBER
Data Typemetric
Tweet Id
Field IDtweet/id
TypeTEXT
Data Typedimension
Tweet Text
Field IDtweet/text
TypeTEXT
Data Typedimension
Tweet Created At
Field IDtweet/created_at
TypeYEAR_MONTH_DAY
Data Typedimension
Tweet Author Id
Field IDtweet/author_id
TypeTEXT
Data Typedimension
Tweet Conversation Id
Field IDtweet/conversation_id
TypeTEXT
Data Typedimension
Tweet Reply To User Id
Field IDtweet/in_reply_to_user_id
TypeTEXT
Data Typedimension
Tweet Copyright
Field IDtweet/withheld.copyright
TypeTEXT
Data Typedimension
Tweet Country Codes
Field IDtweet/withheld.country_codes
TypeTEXT
Data Typedimension
Tweet Scope
Field IDtweet/withheld.scope
TypeTEXT
Data Typedimension
Tweet Possibly Sensitive
Field IDtweet/possibly_sensitive
TypeBOOLEAN
Data Typedimension
Tweet Language
Field IDtweet/lang
TypeTEXT
Data Typedimension
Tweet Reply Settings
Field IDtweet/reply_settings
TypeTEXT
Data Typedimension
Tweet Source
Field IDtweet/source
TypeTEXT
Data Typedimension
Retweet Count
Field IDpublic_metrics.retweet_count
TypeNUMBER
Data Typemetric
Reply Count
Field IDpublic_metrics.reply_count
TypeNUMBER
Data Typemetric
Quote Count
Field IDpublic_metrics.quote_count
TypeNUMBER
Data Typemetric
Bookmark Count
Field IDpublic_metrics.bookmark_count
TypeNUMBER
Data Typemetric
Impression Count
Field IDpublic_metrics.impression_count
TypeNUMBER
Data Typemetric
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension