Cleaned Reddit Pushshift Posts and Submissions for Analytics

A cleaned and structured version of the raw Reddit Pushshift dump, transformed into columnar Parquet files. The dataset includes both Reddit submissions and comments, prepared by the author 'anhchanghoangsg'. It was last updated on March 23, 2026.

Use Cases

• Train large language models based on the cleaned text from Reddit posts and comments.
• Perform big data analytics on social media discussions using the optimized Parquet format.
• Conduct SQL-based analysis of online forum content via tools like DuckDB.
• Analyze trends and topics within Reddit communities using structured submission data.

Strengths

• Data is described as meticulously cleaned and structured from raw JSON dumps.
• Files are stored in the efficient Parquet format, which is optimized for columnar querying.

Limitations

• Column-level documentation is absent; field semantics must be inferred after download.
• Row count is unknown, which may limit suitability assessment.
• Last updated 2026-03-23 07:18:39; freshness should be verified.

Provenance

Source

Reddit Pushshift dump.

Collection Method

Transformed from raw .zst compressed JSON files into Parquet format.

Freshness

Last updated 2026-03-23 07:18:39.