musiccaps_details (view)
2 rows where musiccaps_aspects contains "electric guitar melody", musiccaps_aspects contains "soft kick hits" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- electric guitar melody · 2 ✖
- groovy bass 2
- low quality 2
- rock 2
- shimmering hi hats 2
- soft kick hits · 2 ✖
- addictive 1
- dissonant female vocal 1
- groovy 1
- groovy piano melody 1
- harmonizing male vocals 1
- hollow snare 1
- noisy 1
- punchy snare 1
- sloppy 1
- snare roll 1
- unbalanced stereo 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
grace slick & the great society-white rabbit | The low quality recording features a rock song where dissonant female vocals are singing over electric guitar melody, groovy bass guitar, hollow snare, shimmering hi hats and soft kick hits. It sounds sloppy and the recording is noisy. | 2008-01-07T17:16:48Z | Francesco Giuliobello | An early live version of this song. White rabbit(1965). The images are taken from the movie:Woodstock 3 days of peace & music | ["Singing", "Ska"] | ["low quality", "rock", "unbalanced stereo", "noisy", "electric guitar melody", "dissonant female vocal", "shimmering hi hats", "groovy bass", "hollow snare", "soft kick hits", "sloppy"] | 4 | YddV91xnUz4 | 3302 | |
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;