This project aims to build a graph of subreddit links based on how they reference each other.
The database dumps in (csv format) can be found HERE!.
name (str): name of the subreddit.- between 2 and 21 characters (lowercase letters, digits and underscores).
type (str): type of the subreddit.- public: standard type, nothing special.
- banned: banned by reddit admins, e.g. /r/fatpeoplehate.
- restricted: has restrictions on who can post, e.g. /r/reddit.
- private: requires an invitation to join, e.g. /r/ravenclaw.
- archived: archived by its owners, e.g. /r/thebutton.
- premium: requires reddit premium to join, e.g. /r/lounge.
- user: personal subreddit of a user, e.g. /r/u_fedecalendino.
- employees: only for reddit employees, e.g. /r/product.
title (str): title of the subredditdescription (str): short description of the subreddit.subscribers (int?): amount of subscribers at the moment.nsfw (bool?): indicator if its flaged as not safe for work 🔞.quarantined (bool?): indicator if it has been quarantined 😷.color (str): key color of the subreddit.img_banner (str?): url of the image used as the banner.img_icon (str?): url of the image used as the icon (snoo).created_at (datetime): utc timestamp of when the subreddit was created.updated_at (datetime): utc timestamp of when the information of the subreddit was last updated.
note: the '?' indicates that the value can be null under certain conditions.
| TYPE | AMOUNT |
|---|---|
| TOTAL | 149559 |
| public | 66742 |
| banned | 41630 |
| restricted | 20579 |
| public [nsfw] | 9815 |
| private | 8291 |
| restricted [nsfw] | 2405 |
| restricted [quarantined] | 24 |
| archived | 20 |
| public [quarantined] | 19 |
| user [nsfw] | 8 |
| public [nsfw] [quarantined] | 8 |
| premium | 8 |
| user | 5 |
| employees | 2 |
| archived [nsfw] | 1 |
| restricted [nsfw] [quarantined] | 1 |
| error | 1 |
source (str): name of the subreddit where the link was found.target (str): name of the linked subreddit.type (str): place where the reference from source to target was found.- description: the reference was found in the description (see subreddit.description).
- e.g.: /r/hbo -> /r/hbomax (under "About Community").
- sidebar: the reference was found in the sidebar (this include both sidebars from old and new reddit styles).
- e.g.: /r/hearthstone -> /r/bobstavern (under "Related Subreddits").
- topbar: the reference was found in the links on the topbar.
- e.g.: /r/rocketleague > /r/rocketleagueesports (under "Esports/Subreddit").
- wiki: the reference was found in any of the pages of a subreddits's wiki
- e.g.: /r/zelda > /r/breath_of_the_wild (under "For specific games").
- description: the reference was found in the description (see subreddit.description).
updated_at (datetime): utc timestamp of when the information the link was last updated.
| TYPE | AMOUNT |
|---|---|
| TOTAL | 603224 |
| sidebar | 333041 |
| wiki | 252886 |
| topbar | 9912 |
| description | 7385 |