number
required
Stable Dealroom note ID. Example:
9876543.string | null
required
Canonical URL of the note on its publisher’s site. Null for in-house editorial notes, which have no external source. Example:
"https://techcrunch.com/2024/06/15/example-startup-raises-50m".string
required
URL-safe note slug, unique per note; canonical routing key for /notes/:slug. Example:
"example-startup-raises-50m-series-b-2024".string | null
required
Note headline. Example:
"Example Startup raises $50M Series B led by Sequoia".string | null
required
Short note summary (1-2 sentences). Example:
"Example Startup announced a $50M Series B round…".string | null
required
Short preview/teaser text distinct from
summary. Example: "Example Startup announced…".string | null
required
Hero image URL for the note, if available. Example:
"https://images.example.com/notes/note-9876543.jpg".string | null
required
Attribution/source of the hero image, if available. Example:
"Unsplash".string
required
Publisher / source identifier. Always
dealroom — every note is in-house. Example: "dealroom".string | null
required
Note type. Common values:
vc_round, ipo, acquisition, insight, event, partnership. Example: "vc_round".string | null
required
Display category: the
article_type label, else the first industry of the entity the note is about, else sector. Null when none applies. Example: "Funding rounds".object[]
required
Full list of BigQuery news-type tags for this note.
article_type is a single whitelisted value derived from this array for backward compatibility; this is the complete, uncrushed list. Example: [{"id":3,"name":"Funding rounds"},{"id":9,"name":"Fintech"}].boolean
required
Whether this note is editorially selected as a news article. The
/data/news lens filters on this flag; /data/notes does not. Example: true.string
required
Note type classification.
public today; the pitch types are reserved. Example: "public".string
required
Note publication status.
published, or expired for a few legacy news notes. Example: "published".string | null
required
When the note was published (RFC 3339). Format: date-time. Example:
"2024-06-15T09:30:00.000Z".number | null
required
Deal amount in the active currency, for
vc_round/acquisition notes, as a whole-unit integer. Example: 50000000.string | null
required
Round type for VC-round notes (matches Transactions). Example:
"SERIES_B".string | null
required
Day the deal closed (may differ from
published_at). Format: date. Example: "2024-06-14".string | null
required
Sector classification, when known. Example:
"Fintech".string | null
required
HQ country of the primary mentioned company. Example:
"United States".string | null
required
Reserved: always null.
notes has no enriched_summary column (the legacy column was always null in production too).number | null
required
Editorial ranking score — higher is more prominent. Null when unscored. Example:
87.5.boolean
required
Whether this is the single most prominent (pinned) story. At most one note is pinned at a time. Example:
false.string[]
required
Full list of external source links, when known. Example:
["https://techcrunch.com/2024/06/15/example-startup-raises-50m"].string[]
required
Additional reference URLs cited by the note. Example:
[].string[]
required
Embedded/linked video URLs, when available. Example:
[].string[]
required
Linked pitch deck URLs, when available. Example:
[].number | null
required
Numeric ID of the authoring entity, when known.
string | null
required
Author classification (e.g.
editorial, contributor), when known.string | null
required
ISO 8601 timestamp the note itself was created (source system). Format: date-time. Example:
"2024-06-15T10:30:00.000Z".string | null
required
ISO 8601 timestamp the note was last updated (source system). Format: date-time. Example:
"2024-06-15T10:30:00.000Z".object[]
required
Dealroom entities (companies, investors) referenced in the note, the primary one first, each as its reference.