- query
- The query this row came from, repeated on every row it produced. Worth keeping: it is the only thing separating results when you submit more than one query at a time.
- video_id
- YouTube's id for the video, always eleven characters. The column to key on - and to de-duplicate on, because the same video can appear more than once in a run.
- title
- The video title. It can carry trailing whitespace, so trim before matching or grouping on it.
- url
- A link to the video. The shape follows
video_type: /watch?v=<id> for a regular video and /shorts/<id> for a short. The id is always in there. - channel_title
- The channel's display name. Also carries trailing whitespace, and it can be blank on results that came from a keyword search.
- channel_id
- The channel's id, always beginning
UC. The stable way to group by channel - a channel can rename itself, and this will not change. It too can be blank on keyword results. - views
- The view count as YouTube prints it - a rounded, abbreviated string like
5.6K views. It is not always a view count: a single view reads 1 view, and a live stream reads <n> watching, which is concurrent viewers rather than lifetime plays. - views_parsed
- The number. Despite the name this is the exact count, not the display string parsed - a video showing
4.1M views came back as 4099999. This is the column to sum, sort and compare on; views is for showing a human. - published
- How long before the run the video went up, as a relative phrase -
9 days ago, 2 weeks ago, 3 months ago. Never an absolute date, and never present on a short. See the note below about anchoring it. - length
- The running time as
m:ss or h:mm:ss. Not present on a short, and not present on a live stream. - video_type
- Either
short or video, matching the Video Type you chose for the run. A run returns one or the other, so this column is constant within a file - it is there to tell two files apart after the fact. - thumbnail
- A link to the preview image. The filename varies -
frame0.jpg on shorts, and hqdefault, hq720 and custom variants elsewhere - so read the column rather than building the URL yourself. The video id is always in it.