Open Channel Stats

The open data

Take the data home.

Every public channel on Open Channel Stats publishes its full record as a single SQLite file, refreshed daily. It is the same data the dashboards read, with no parts held back, and it travels with AI-ready prompts for a conversation over the numbers.

What it is

  1. One file per channel

    A public channel's whole catalog downloads as a single SQLite file — daily reads, video states, traffic patterns, and every raw row, from the channel's first tracked day to its latest. It opens in any SQLite client, runs in an in-browser SQL playground, or uploads to an AI model that accepts file attachments.

  2. A database that describes itself

    The file carries its own documentation. A handful of catalog tables — its overview, its table and column catalogs, its query examples, and a set of utility views — let a reader, or an AI, learn the shape of the file from inside the file. No external schema sheet to find first.

  3. Built the same way the site is

    The file keeps the same posture as the site: observations, not advice; forecasts recorded beside their own track record; the conditions each number was drawn under written down rather than smoothed away. An analyst-mode sibling file strips the stored conclusions, so a model loading it reasons from the raw rows instead of repeating a verdict.

What AI-ready looks like

Paste one prompt, get a plain read.

Attach a channel’s file to an AI model and paste a prompt like this one. It names the tables to begin from and asks for observations, not advice.

Start with the daily read

A generic prompt to attach with any channel's file.

I've uploaded a YouTube analytics SQLite database from a real channel. Start with the app_dashboard_briefing_daily table, then draw evidence from summary_video, video_daily, and traffic_daily. Summarize the five most useful observations in plain English — what changed, what carried the channel, what stayed quiet, and what is still too small to read. Avoid advice and don't claim causes.

Where to start

The download lives on each channel.

There is no single file for the whole network — each public channel carries its own. The directory and the daily spotlight are the way in; a channel that has not connected yet can join.