musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "playback" and musiccaps_aspects contains "shimmering hi hats" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- low quality 3
- playback · 3 ✖
- shimmering hi hats · 3 ✖
- groovy bass guitar 2
- mono 2
- noisy 2
- snappy rimshots 2
- arpeggiated guitar melody 1
- clapping 1
- crowd cheering 1
- crowd whistling 1
- easygoing 1
- electric guitar melody 1
- emotional 1
- exciting 1
- french horn melody 1
- fruity male vocal 1
- funky electric guitar chords 1
- live performance 1
- passionate 1
- passionate male vocal 1
- punchy kick 1
- punchy snare 1
- reggae 1
- rock 1
- shoe tapping 1
musiccaps_names (array) 8 ✖
- Music 2
- Brass instrument 1
- Country 1
- French horn 1
- Maraca 1
- Music of Latin America 1
- Rumble 1
- Tap 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
What a wonderful world Bb Horn | The low quality recording features a french horn melody played over playback that consists of snappy rimshots, shimmering hi hats and arpeggiated guitar melody. It sounds emotional and passionate, even though the recording is in mono and noisy. | 2009-01-31T21:52:21Z | KamilToni | Playing what a wonderful world on a Berkeley Bb piccolo/ mini french horn with a strawberries and creme mouthpieces MDC from kelly mouthpieces. i wasn't feeling good and i just wanted to post something up with this instrument.. | ["Brass instrument", "French horn"] | ["low quality", "mono", "noisy", "playback", "arpeggiated guitar melody", "snappy rimshots", "shimmering hi hats", "french horn melody", "emotional", "passionate"] | 4 | MNlzpCwdh4g | 2261 | |
Downbeat sound at Irish and chin vintage rumble 2016 amazura | The low quality recording features a live performance of a reggae song and it consists of a fruity male vocal preparing to sing over shimmering hi hats, snappy rimshots, funky electric guitar chords and groovy bass. As it is a live performance, there are some crowd whistling and cheering noises in the background. It sounds easygoing and exciting. | 2016-04-16T14:14:11Z | Kerryannbrown music promotions | Downbeat sound at vintage rumble 2016 Irish and chin sound clash | ["Music", "Rumble", "Music of Latin America", "Maraca"] | ["low quality", "reggae", "crowd whistling", "fruity male vocal", "crowd cheering", "live performance", "playback", "shimmering hi hats", "snappy rimshots", "funky electric guitar chords", "groovy bass guitar", "easygoing", "exciting"] | 4 | zXxJymYt8Z4 | 5487 | |
"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 |
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;