Videos¶
One YouTube video. The key of the table is the YouTube video ID, so every row is a real video.
| Field | Type | Required | Allowed values or link | Definition | Purpose | MP4 tag | MP3 tag |
|---|---|---|---|---|---|---|---|
YouTube_Video_ID |
Text | Yes | The 11-character YouTube video ID. The key of the table: one row per video. | Identifies the video exactly and pairs a video with its audio. | ----:com.apple.iTunes:YOUTUBE_ID | TXXX:YOUTUBE_ID | |
Song |
Link to one row | Row of Songs | A link to the Songs row this video shows or plays. | Ties every video of a song to one set of facts. | None | None | |
Collection |
Link to one row | Row of Collections | A link to the Collections row (film, show or game); blank for ordinary music. | Files movie, television and video game songs under the film, show or game. | None | None | |
Role |
One value from a list | Primary, Alternate | Primary or Alternate. | Every song has exactly one Primary video. | None | None | |
Origin |
One value from a list | Original, Cover | Original or Cover. | Says whether the performer made the original song. | None | None | |
Performance |
One value from a list | Studio, Live | Studio or Live. | Says whether the recording is a live performance. | None | None | |
Version |
One value from a list | Original, Remix, Edit, Instrumental, Acoustic, Remastered, Orchestral | Which version of the track it is: Original, Remix, Edit, Instrumental, Acoustic, Remastered or Orchestral. | Marks a different version of the song. | None | None | |
Video_Type |
One value from a list | Music Video, Lyric, Visualizer, Live Footage, Montage, Documentary | What the video is, by its form only: Music Video, Lyric, Visualizer, Live Footage, Montage or Documentary. | Describes the video itself, never who made it. | None | None | |
Content |
One value from a list | Clean, Explicit, None | Clean, Explicit or None (no clean or explicit version exists). | Marks edited versions. | None | None | |
Uploader |
One value from a list | Artist Or Label, Broadcaster, Auto-Generated, Fan | Who uploaded it: Artist Or Label, Broadcaster, Auto-Generated or Fan. | Separates an official upload from a fan's re-upload. | None | None | |
Disambiguation |
Text | Words from the YouTube title or description that tell this video apart from others of the same song (Live at Wembley, 1984). Stored without brackets. | Becomes the [bracket] in a non-Primary file name. | ----:com.apple.iTunes:DISAMBIGUATION | TXXX:DISAMBIGUATION | ||
YouTube_Title |
Text | The video's title exactly as YouTube returns it. | Raw evidence for the parsing. | None | None | ||
YouTube_Description |
Text | The video's description exactly as YouTube returns it. | Raw evidence (for example the record label's 'Music video by' line). | None | None | ||
YouTube_Channel_Name |
Text | The name of the YouTube channel that uploaded the video. | Helps decide the uploader and whether the video is official. | None | None | ||
YouTube_Channel_ID |
Text | The uploading channel's ID (UC and 22 characters). | Matches an official channel, and is the strongest evidence for obscure artists. | None | None | ||
YouTube_Published_Date |
Date | The date the video was published on YouTube. | Evidence, and the last-resort year. | None | None | ||
YouTube_View_Count |
Decimal number | YouTube's view count for the video. | Breaks ties when choosing the Primary. | ----:com.apple.iTunes:VIEW_COUNT | TXXX:VIEW_COUNT | ||
YouTube_Duration_Seconds |
Whole number | YouTube's length of the video in seconds. | Verifies a download. Never compared with the audio. | None | None | ||
YouTube_Video_URL |
Derived text | Derived from other fields | The video's YouTube address, built from the video ID. Calculated, never typed. | A link to open the video, and the YouTube tag in the file. | ----:com.apple.iTunes:YOUTUBE_URL | TXXX:YOUTUBE_URL | |
IMVDb_Video_ID |
Text | IMVDb's ID for the video. | Identity for IMVDb, used to find the official video. | None | None | ||
Comment |
Text | Free text written to the file's comment tag, for example 'Primary pending' or 'not in MusicBrainz'. | Notes and flags that belong with the file. | ©cmt | COMM | ||
Is_Verified |
Yes or no | Yes only when the artist, recording and album have verified IDs (or are confirmed as not in MusicBrainz), album, year, disc and track are present, the Primary is decided and the check shows no problems. On an audio file: the fingerprint and length checks passed. | Only verified videos are downloaded and synced. | None | None | ||
Album_Artist |
Derived text | Derived from other fields | The album credit as filed. For a film, show or game soundtrack it is the title of the film, show or game. | The first part of a file name and the library sort. | None | None | |
Video_Path |
Derived text | Derived from other fields | The full path of the video file in Tracks or Tracks2, calculated from Files. Blank means the owner does not have it. | Shows what has been downloaded. | None | None | |
Audio_Path |
Derived text | Derived from other fields | The full path of the audio file, calculated from Files. Only a Primary has one. | Shows which Primaries still need audio. | None | None | |
Expected_Name |
Derived text | Derived from other fields | The file name this row should have, without the extension. Calculated. | The name used when a file is made, and a check against what is on disk. | None | None | |
Updated_Date |
Date | The date the row was last changed. It stamps itself. | Shows what changed recently. On a video it is also written to the file's tag. | ----:com.apple.iTunes:LAST_UPDATED | TXXX:LAST_UPDATED | ||
YouTube_Channel_URL |
Derived text | Derived from other fields | The YouTube link, built from YouTube_Channel_ID and its Vendors row. Calculated, never typed. | A link to open the page. It cannot disagree with the stored identifier. | None | None |
This page is generated from the data dictionary. Change the dictionary, not this page.