Models Annotations · Querying PostHog Data · PostHog/skills · Skills Docs

Models Annotations · Querying PostHog Data · PostHog/skills · Skills Docs

Column	Type	Nullable	Description
`id`	Integer	NOT NULL	Annotation id.
`team_id`	Integer	NOT NULL
`content`	String	NULL	Annotation text.
`scope`	String	NOT NULL	Where the annotation applies: ‘project’, ‘organization’, ‘dashboard’, ‘dashboard_item’ (insight), or ‘recording’.
`creation_type`	String	NOT NULL	How the annotation was created, e.g. user-created vs GitHub.
`date_marker`	DateTime	NULL	The point in time the annotation marks on a chart.
`deleted`	Integer	NOT NULL	1 if the annotation has been deleted, 0 otherwise.
`dashboard_item_id`	Integer	NULL	Insight this annotation is scoped to; joins to insights.id.
`dashboard_id`	Integer	NULL	Dashboard this annotation is scoped to; joins to dashboards.id.
`created_by_id`	Integer	NULL	User who created the annotation.
`created_at`	DateTime	NULL	When the annotation was created.
`updated_at`	DateTime	NOT NULL	When the annotation was last updated.

SELECT id, content, scope, date_marker
FROM system.annotations
WHERE NOT deleted
  AND date_marker >= toDateTime('2026-03-01 00:00:00')
  AND date_marker < toDateTime('2026-03-08 00:00:00')
ORDER BY date_marker ASC