musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "clapping", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "mono"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- clapping · 2 ✖
- low quality · 2 ✖
- mono · 2 ✖
- noisy 2
- punchy kick 2
- bagpipe melody 1
- crowd talking 1
- electric guitar lick 1
- electric guitar melody 1
- exciting 1
- groovy bass guitar 1
- passionate male vocal 1
- playback 1
- punchy snare 1
- rock 1
- shimmering hi hats 1
- shoe tapping 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Watermelon Crawl" Line Dance | The low quality recording features clapping and shoe tapping sounds over rock songs played on playback. The song consists of a passionate male vocal that sings over punchy kick and snare hits, shimmering hi hats, electric guitar melody and groovy bass guitar. The recording is in mono and a bit noisy, as it was probably recorded with a phone. | 2010-03-27T06:09:42Z | Linda Turner | Nashville West, Ceres, California Country Line Lessons March 25. 2010. NO COPYRIGHT INFRINGEMENT INTENDED. I do not own anything. All rights reserved to the respective music labels. This is only used as a teaching guide or tool to the line dance world. "Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use." | ["Country", "Music", "Tap"] | ["low quality", "clapping", "shoe tapping", "mono", "noisy", "rock", "playback", "passionate male vocal", "electric guitar melody", "punchy snare", "shimmering hi hats", "groovy bass guitar", "punchy kick"] | 4 | 1_YHHL_t2GI | 289 | |
The PowerPipes | The low quality recording features a bagpipe melody, layered with an electric guitar lick and followed by punchy kick hits. In the background there are some crowd talking noises and claps. It sounds exciting and the recording is noisy and in mono. | 2009-08-26T10:25:54Z | fVZD | TPP featuring at pan ulica fest špancirfest :D | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["low quality", "bagpipe melody", "clapping", "punchy kick", "crowd talking", "mono", "noisy", "electric guitar lick", "exciting"] | 4 | yAvqiPL-ssU | 5390 |
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;