Canonical URL of the Reddit post

Reddit post ID (base36 identifier)

Title of the Reddit post

Text body of the post (for text posts)

Type of post: text, image, link, video, etc.

Upvote score of the post

Number of comments on the post

Number of awards received by the post

Username of the post author

Reddit ID of the post author

Name of the subreddit

Subreddit name with r/ prefix

Reddit ID of the subreddit

Post flair label (if any)

Domain of the post content (self.xxx for text posts, or external domain for link posts)

Detected language of the post

UTC timestamp when the post was created

Row type: 'post' for the post itself, 'comment' for a comment, 'user' for a user profile, 'subreddit' for subreddit metadata

Reddit comment ID (base36). Null for post rows.

Parent comment ID for nested replies. Null for top-level comments and post rows.

Comment nesting depth (0 = top-level). Null for post rows.

Total karma of the user. Populated for type='user' rows only.

Post karma of the user. Populated for type='user' rows only.

Comment karma of the user. Populated for type='user' rows only.

Number of contributions by the user. Populated for type='user' rows only.

JSON array of trophy names earned by the user. Populated for type='user' rows only.

[
  "Five-Year Club"
]

JSON array of subreddits the user is active in (prefixed, e.g. 'r/Bitcoin'). Populated for type='user' rows only.

[
  "r/Bitcoin",
  "r/PostCardExchange"
]

JSON array of subreddits the user moderates (prefixed, e.g. 'r/belikeme'). Populated for type='user' rows only.

[
  "r/belikeme"
]

Description of the subreddit. Populated for type='subreddit' rows only.

Number of weekly active users in the subreddit. Populated for type='subreddit' rows only.

Number of weekly contributions (posts + comments) in the subreddit. Populated for type='subreddit' rows only.

JSON array of subreddit rules, each with 'number', 'title', and 'description'. Populated for type='subreddit' rows only.

[
  {
    "number": "1",
    "title": "Be civil",
    "description": "..."
  }
]

JSON array of community resource links, each with 'text' and 'url'. Populated for type='subreddit' rows only.

[
  {
    "text": "Wiki",
    "url": "https://www.reddit.com/r/example/wiki/…
  }
]

Ratio of upvotes to total votes (0.0–1.0). Populated for post rows.

Whether the post has been locked by moderators (no new comments allowed).

Whether the post is archived (older than 6 months, no new votes or comments).

Whether the post is stickied (pinned) by a moderator.

Whether the post is marked as NSFW (Not Safe For Work / 18+).

Whether the post is marked as a spoiler.

Whether the post is a native Reddit video.

Whether the post contains a gallery of images.

Direct URL of the post's media (video or external image). Null for text and self-link posts.

Preview thumbnail URL for image and video posts. Null for text posts.

HTML-rendered body of the post. Populated only for direct post URL scrapes (type='post'). Null for posts found in subreddit or search feeds.

Character count of the plain-text post body. 0 for posts with no body (image, video, link posts).

HTML-rendered body of the comment. Null for comments with no body.

Age of the post in hours at the time of scraping. Derived from created_at. Null for posts without a creation timestamp.

Post score divided by age in hours. Measures engagement velocity. Null for posts without a creation timestamp.

comment_count divided by max(score, 1). High values indicate discussion-heavy posts relative to their upvote count.

True if the post has high engagement: score_per_hour > 50 or comment_to_score_ratio > 0.5. Convenience flag for filtering trending or discussion-heavy posts.

Indicates if the post was made with special authority. Possible values: 'moderator' (posted by a mod with mod badge), 'admin' (posted by a Reddit admin). Null for regular posts.

True if the post is a paid advertisement (sponsored/promoted post). These appear in feeds mixed with organic content.

True if the post is a text/self post (no external link). False for link posts, image posts, video posts, etc.

Reddit short URL for the post (https://redd.it/{post_id}). Compact shareable link.

True if the post or comment has been edited after original submission.

ISO timestamp of when the post was last edited. Null if never edited.

Number of times this post has been crossposted to other subreddits.

The post author's flair text in the subreddit at the time of posting. Set by the user or moderators.

True if the post or comment author has Reddit Premium.

Number of times this post has been gilded (awarded Reddit Gold).

True if the post was marked as Original Content (OC) by the author.

Number of subscribers in the subreddit at the time of scraping.

The post_id of the original post if this is a crosspost. Null if not a crosspost.

The sort order suggested by the subreddit moderators for this post's comments. E.g. 'top', 'new', 'confidence'. Null if not set.