Newsletter Posts Dataset

Version: 4 (current) | Updated: 11/12/2025, 7:26:00 PM

Added description

Description

Newsletter Posts Dataset

Overview

The Newsletter Posts Dataset is a structured collection of metadata records for individual newsletter posts. It is presented in JSON format and was created on 4 June 2023. The dataset is cataloged as a “Dataset” type and is available in English. It is associated with the institution “test” and originates from the source system PINAX. The dataset’s access URL is currently a placeholder, indicating that the file is stored within an internal archival repository.

Background

The dataset was assembled to support research and management of digital newsletter communications. No specific creator is listed, suggesting that it was generated automatically by the PINAX content‑management system. The dataset is part of a broader effort to archive content‑management artifacts for institutional memory and scholarly use. The inclusion of a “test” institution tag implies that the dataset may have been produced during a pilot or development phase of the archival workflow.

Contents

Each record in the dataset represents a single newsletter post and contains key attributes such as:
  • post_id (e.g., “133047701.modern‑indulgence”)
  • type (a reference to a predefined category)
  • status (e.g., draft, published)
  • audience (target readership)
  • publication details (date, platform, distribution channel)

The dataset includes a header entity (`newsletterpostsdataset`) that describes the overall collection, followed by individual post entities (`post_133047701`, etc.). The JSON structure uses entity references for dates and types, allowing for consistent cross‑referencing within the archive. While the source excerpt shows only one example post, the dataset is designed to accommodate many such records.

Scope

The dataset covers newsletter posts created or archived in 2023, specifically on 4 June 2023. Geographically, it is institution‑centric, focusing on the “test” organization, and does not specify external locations. Thematic coverage includes newsletters, digital communication, and content management. The dataset is limited to metadata; it does not contain the full text of the newsletters themselves. It is intended for use by researchers, archivists, and content managers interested in the lifecycle and distribution of digital newsletters.

Entities

(loading...)

Entity Relationships

(loading...)

Raw Cheimarros Data

@file_pinax -> documents -> @newsletter_posts_dataset:document {description: "A dataset containing information about various newsletter posts, including their status, type, audience, and publication details.", created: @date_2023_06_04, language: "en", subjects: ["newsletters","digital communication","content management"]}

@file_posts_csv -> contains -> @post_133047701:document {post_id: "133047701.modern-indulgence", type: @newsletter, audience: "everyone"}  
@file_posts_csv -> contains -> @post_132220171:document {post_id: "132220171.7fb", type: @newsletter, audience: "everyone"}  
@file_posts_csv -> contains -> @post_125962878:document {post_id: "125962878.coming-soon", date: @date_2023_06_04, is_published: true, email_sent_at: @date_2023_06_04, inbox_sent_at: @date_2023_06_04, type: @newsletter, audience: "everyone", title: "Coming soon"}  
@file_posts_csv -> contains -> @post_125962877:document {post_id: "125962877.how-to-use-the-substack-editor", type: @newsletter, audience: "everyone"}

Metadata

Version History (4 versions)

  • ✓ v4 (current) · 11/12/2025, 7:26:00 PM
    "Added description"
  • v3 · 11/12/2025, 7:24:30 PM · View this version
    "Added knowledge graph extraction"
  • v2 · 11/12/2025, 7:22:36 PM · View this version
    "Added PINAX metadata"
  • v1 · 11/12/2025, 7:22:21 PM · View this version
    "Reorganization group: newsletter_posts"

Additional Components

posts.csv
post_id,post_date,is_published,email_sent_at,inbox_sent_at,type,audience,title,subtitle,podcast_url
133047701.modern-indulgence,,false,,,newsletter,everyone,,,
132220171.7fb,,false,,,newsletter,everyone,,,
125962878.coming-soon,2023-06-04T16:30:56.552Z,true,2023-06-04T16:30:56.552Z,2023-06-04T16:30:56.552Z,newsletter,everyone,Coming soon,,
125962877.how-to-use-the-substack-editor,,false,,,newsletter,everyone,,,

Parent

01K9WR90G7YYHCC29A17FC4DZ2

No children (leaf entity)