MTV¶
One ident, bumper, promo or similar piece of MTV's own broadcast.
| Field | Type | Required | Allowed values or link | Definition | Purpose | MP4 tag | MP3 tag |
|---|---|---|---|---|---|---|---|
Title |
Text | The name of the thing the row describes, in plain ASCII, with no edition labels. On a song it is the track title as it appears on the audio file. | The name used in file names and tags. | None | None | ||
Year_Label |
Text | An MTV item's year as written: a year (1998), a decade (1990s) or a range (1987-1988). Every kept row has one. | Part of the MTV file name, and gives the decade. | None | None | ||
Category |
One value from a list | Ident, Bumper, Promo, Top Of The Hour, Broadcast Excerpt, Outro | What kind of MTV item it is: Ident, Bumper, Promo, Top Of The Hour, Broadcast Excerpt or Outro. | Part of the MTV file name: MTV - Year - Category - Title. | None | None | |
Decade |
Derived text | Derived from other fields | The decade of an MTV item, calculated from its year label. | Grouping and browsing. | None | None | |
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. | 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. | None | None | |
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. | None | None | ||
YouTube_Duration_Seconds |
Whole number | YouTube's length of the video in seconds. | Verifies a download. Never compared with the audio. | None | None | ||
Video_Path |
Text | 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 | ||
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. | 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. | None | None |
This page is generated from the data dictionary. Change the dictionary, not this page.