musiccaps_details (view)
1 row where musiccaps_aspects contains "groovy", musiccaps_aspects contains "harmonizing male vocals", musiccaps_aspects contains "snare roll" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kansas - Point of Know Return (Official Video) | The low quality recording features a rock song that consists of harmonizing male vocals singing over groovy piano melody, groovy bass guitar, electric guitar melody, punchy snare, soft kick hits and shimmering hi-hats. There is a short snare roll that serves as a transition into a new section. It sounds groovy and addictive. | 2013-01-17T11:25:12Z | kansasVEVO | Official music video for “Point of Know Return” by Kansas Listen to Kansas: https://Kansas.lnk.to/listenYD Watch more videos by Kansas: https://Kansas.lnk.to/listenYD/youtube Subscribe to the official Kansas YouTube channel: https://Kansas.lnk.to/subscribeYD Follow Kansas Facebook: https://Kansas.lnk.to/followYD/facebook Instagram: https://Kansas.lnk.to/followYD/instagram Twitter: https://Kansas.lnk.to/followYD/twitter Website: https://Kansas.lnk.to/followYD/websitegeneral Spotify: https://Kansas.lnk.to/followYD/spotify Lyrics: Your father, he said he needs you Your mother, she says she loves you Your brothers, they echo your words: "How far to the point of know return?" "Well, how long?" #Kansas #PointofKnowReturn #Rock | ["Singing", "Country"] | ["low quality", "rock", "harmonizing male vocals", "groovy piano melody", "groovy bass", "electric guitar melody", "punchy snare", "snare roll", "soft kick hits", "shimmering hi hats", "groovy", "addictive"] | 4 | iFWtsT5zRKo | 4174 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;