- query
- The search phrase this row came from, repeated on every row it produced. The only thing separating results when you submit several searches at once.
- video_id
- YouTube's id for the video, always eleven characters. Unique within a run here, so no de-duplication is needed - worth noting, because that is not true of the video scraper.
- title
- The video title. It can carry trailing whitespace, so trim before matching or grouping on it.
- channel
- The channel's display name - and only the name. There is no channel id in this export, so grouping by channel is grouping by a label that two channels can share and one channel can change. It also carries trailing whitespace.
- views
- The view count, written out in full with comma grouping -
49,498 views, 18,226,447 views. Never abbreviated, and there is no separate numeric column, so strip the commas and the trailing word yourself. It is not always a view count: a single view reads 1 view, and a live stream reads <n> watching or arrives empty. - duration
- The running time as
m:ss, or h:mm:ss once a video runs past the hour. Not present on a live stream. - published
- How long before the run the video went up, as a relative phrase -
1 day ago, 5 months ago, 9 years ago. Never an absolute date, and not present on a live stream. See the note below about anchoring it. - url
- A link to the video, always the
/watch?v=<id> form. The id is always in it. Note that no column tells you whether a result is a short or a regular video. - thumbnail
- A link to the preview image, carrying its own query string. The filename varies -
hq720, hqdefault and custom variants - so read the column rather than building the URL yourself. The video id is always in it.