musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "noisy", musiccaps_aspects contains "passionate male vocal" and musiccaps_aspects contains "rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- low quality 3
- noisy · 3 ✖
- passionate male vocal · 3 ✖
- rock · 3 ✖
- emotional 2
- groovy bass guitar 2
- live performance 2
- punchy kick 2
- punchy snare 2
- addictive 1
- arpeggiated electric guitar melody 1
- boomy bass guitar 1
- clapping 1
- crowd noises 1
- electric guitar melody 1
- electric guitar solo melody 1
- energetic 1
- energetic cymbals 1
- groovy 1
- harmonizing male vocals 1
- messy 1
- mono 1
- muffled kick hits 1
- muffled snare hits 1
- playback 1
- shimmering hi hats 1
- shimmering open hats 1
- shoe tapping 1
musiccaps_names (array) 8 ✖
- Music 3
- Bass guitar 1
- Country 1
- Punk rock 1
- Rock and roll 1
- Roll 1
- Singing 1
- Tap 1
youtube_published (date) 3 ✖
- 2006-04-19 1
- 2010-03-27 1
- 2014-08-25 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 | |
SPYAIR - Samurai Heart (live) ENG subs | The low quality recording features a live performance of a rock song that consists of passionate male vocal singing over electric guitar solo melody, energetic cymbals, muffled snare and kick hits and groovy bass guitar. There are also some crowd noises, singing along. It sounds energetic, emotional and addictive, thanks to that cadence. | 2014-08-25T16:54:22Z | Rrhae Reyes | Video not mine credit to the owner But the subs are mine xD IKE is so handsome here This is a gintama perf so you can see the anime dubbers here | ["Singing", "Music", "Roll"] | ["low quality", "crowd noises", "noisy", "rock", "live performance", "electric guitar solo melody", "energetic cymbals", "muffled snare hits", "muffled kick hits", "passionate male vocal", "groovy bass guitar", "energetic", "emotional", "addictive"] | 4 | P3ZPbGjHFXE | 2499 | |
"11 O'Clock Tick Tock" - Belfast , January 1981 | The low quality recording features a live performance of a rock song and it features passionate male vocals, alongside harmonizing male vocals, singing over arpeggiated electric guitar melody, boomy bass guitar, punchy kick and snare hits and shimmering open hats. It sounds noisy and messy, as the frequencies are clashing with each other, but it is still groovy and emotional regardless. | 2006-04-19T19:19:34Z | u2log | The audience reaction is great in this clip. | ["Bass guitar", "Music", "Punk rock", "Rock and roll"] | ["low quality", "rock", "live performance", "arpeggiated electric guitar melody", "passionate male vocal", "harmonizing male vocals", "boomy bass guitar", "shimmering open hats", "punchy kick", "punchy snare", "messy", "noisy", "groovy", "emotional"] | 4 | zWJC_qr2610 | 5486 |
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;