musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy bass guitar" and youtube_description contains "No copyright infringement intended"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- groovy bass guitar · 2 ✖
- calm 1
- clapping 1
- easygoing 1
- electric guitar melody 1
- emotional 1
- low quality 1
- mono 1
- noisy 1
- passionate female vocal 1
- passionate male vocal 1
- playback 1
- pop 1
- punchy kick 1
- punchy snare 1
- rock 1
- shimmering hi hats 1
- shimmering shakers 1
- shoe tapping 1
- sustained synth strings chords 1
- synth keys melody 1
- tinny percussive elements 1
- uplifting 1
musiccaps_names (array) 4 ✖
- Music 2
- Country 1
- Tap 1
- Tender music 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 | |
You've Made Me Stronger - Regine Velasquez | The Pop song features a passionate female vocal singing over synth keys melody, sustained synth strings chords, groovy bass guitar, shimmering shakers and tinny percussive elements. The second section has only vocals, synth keys, shimmering shakers and some tinny percussion, as it is a way calmer section. It sounds uplifting, emotional and easygoing. | 2008-08-31T06:51:06Z | Beauty et Madness | No copyright infringement intended for the damn who broke not just his promises but also my heart, here's for you.. thanks for all the pain and the tears.. if not because of those, I won't realize something.. YOU'VE MADE ME STRONGER.. Follow me on twitter: https://twitter.com/#!/LHollyCynthL Visit me at http://lamadrid006.webs.com | ["Music", "Tender music"] | ["shimmering shakers", "tinny percussive elements", "passionate female vocal", "groovy bass guitar", "synth keys melody", "sustained synth strings chords", "pop", "uplifting", "easygoing", "emotional", "calm"] | 4 | eSesh6vnek8 | 3863 |
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;