Newsletter Posts Dataset

Version: 4 (current) | Updated: 11/12/2025, 7:40:02 PM

Added description

Description

Newsletter Posts Dataset

Overview

The Newsletter Posts Dataset is a structured collection of metadata about email newsletter posts. It is stored as a dataset (type: Dataset) created on 4 June 2023 and is available in English. The dataset is hosted by the institution test and originates from the source system PINAX. A placeholder URL is provided for access, and no explicit rights statement is included.

Background

The dataset was assembled to support analysis and management of newsletter content within an email‑marketing workflow. It was produced by the test institution, likely as part of an internal content‑management initiative. The dataset’s creation date indicates it reflects newsletter activity up to early June 2023. The absence of a place field suggests the data were generated in a virtual or unspecified location.

Contents

The primary component is a CSV file named posts.csv. This file contains rows of individual newsletter posts, each identified by a unique post ID. Key columns include:
  • Post ID – unique identifier for each newsletter.
  • Date – publication or scheduled date of the newsletter.
  • Publication Status – indicates whether the post is drafted, scheduled, or published.
  • Audience Details – demographic or segment information for the intended recipients.

The dataset’s metadata (in the JSON description) lists the subjects newsletters, email marketing, and content management, underscoring its relevance to those fields. No additional files or supplementary documentation are included in the archived item.

Scope

The dataset covers newsletter posts recorded up to 4 June 2023. Geographic coverage is unspecified, implying a global or internal audience. Topics are limited to the operational aspects of newsletter creation and distribution—specifically post identifiers, dates, status, and audience segmentation. The dataset does not include the actual newsletter content, subject lines, or engagement metrics. It is intended for use by content managers, marketers, and analysts who require a structured view of newsletter publication workflows.

Entities

(loading...)

Entity Relationships

(loading...)

Raw Cheimarros Data

@file_pinax -> documents -> @newsletter_posts_dataset:document {description: "Dataset containing information about newsletter posts, including post IDs, dates, publication status, and audience details.", created: @date_2023_06_04, institution: "test", language: "en", subjects: ["newsletters","email marketing","content management"]}

@file_posts_csv -> contains -> @posts_csv:file {filename: "posts.csv", format: "CSV"}

@newsletter_posts_dataset -> includes -> @post_125962878:document {post_id: "125962878.coming-soon", post_date: "2023-06-04T16:30:56.552Z", is_published: true, email_sent_at: "2023-06-04T16:30:56.552Z", inbox_sent_at: "2023-06-04T16:30:56.552Z", type: "newsletter", audience: "everyone", title: "Coming soon", subtitle: "", podcast_url: ""}

@newsletter_posts_dataset -> includes -> @post_133047701:document {post_id: "133047701.modern-indulgence", is_published: false, type: "newsletter", audience: "everyone", title: "", subtitle: "", podcast_url: ""}

@newsletter_posts_dataset -> includes -> @post_132220171:document {post_id: "132220171.7fb", is_published: false, type: "newsletter", audience: "everyone", title: "", subtitle: "", podcast_url: ""}

@newsletter_posts_dataset -> includes -> @post_125962877:document {post_id: "125962877.how-to-use-the-substack-editor", is_published: false, type: "newsletter", audience: "everyone", title: "", subtitle: "", podcast_url: ""}

@date_2023_06_04 # auto‑created date entity for 4 June 2023 (used for dataset creation date)

Metadata

Title
Newsletter Posts Dataset
Type
Dataset
Institution
test
Created
2023-06-04
Language
en
Subjects
newsletters, email marketing, content management
Source
PINAX

Version History (4 versions)

  • ✓ v4 (current) · 11/12/2025, 7:40:02 PM
    "Added description"
  • v3 · 11/12/2025, 7:38:50 PM · View this version
    "Added knowledge graph extraction"
  • v2 · 11/12/2025, 7:37:13 PM · View this version
    "Added PINAX metadata"
  • v1 · 11/12/2025, 7:36:59 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

↑ 01K9WS41KD6YN5X5AD2FMSJCY9

No children (leaf entity)