Skip to content

Latest commit

 

History

History
90 lines (70 loc) · 3.58 KB

README.md

File metadata and controls

90 lines (70 loc) · 3.58 KB

REDDIT-GRAPH v2024.07.17.130528

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!.

SUBREDDITS

PROPERTIES

  • name (str): name of the subreddit.
    • between 2 and 21 characters (lowercase letters, digits and underscores).
  • type (str): type of the subreddit.
  • title (str): title of the subreddit
  • description (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.

STATS

TYPE AMOUNT
TOTAL 151664
public 67383
banned 42234
restricted 21402
public [nsfw] 9849
private 8396
restricted [nsfw] 2304
restricted [quarantined] 24
archived 20
public [quarantined] 19
premium 8
public [nsfw] [quarantined] 8
user [nsfw] 7
user 5
employees 2
restricted [nsfw] [quarantined] 1
error 1
archived 1

LINKS

PROPERTIES

  • 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.
  • updated_at (datetime): utc timestamp of when the information the link was last updated.

STATS

TYPE AMOUNT
TOTAL 616116
sidebar 343731
wiki 254844
topbar 10091
description 7450