musiccaps_details (view)
5 rows where musiccaps_aspects contains "piano accompaniment", musiccaps_aspects contains "poor audio quality" and musiccaps_aspects contains "romantic"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- piano accompaniment · 5 ✖
- poor audio quality · 5 ✖
- romantic · 5 ✖
- medium tempo 4
- emotional 3
- passionate 3
- backup singers 2
- keyboard accompaniment 2
- latin percussions 2
- male latin singer 2
- male singer 2
- percussive bass line 2
- screaming vocals 2
- youthful 2
- acoustic love song 1
- bad audio quality 1
- brass band 1
- clapping percussion 1
- club 1
- courtship song 1
- dance groove 1
- dance rhythm 1
- distorted vocals 1
- energetic 1
- entertaining 1
- fast drumming rhythm 1
- fast tempo 1
- female singer 1
- groovy 1
- groovy rhythm 1
- …
musiccaps_names (array) 10 ✖
- Music 5
- Bell 1
- Exciting music 1
- Humming 1
- Maraca 1
- Music of Africa 1
- Salsa music 1
- Singing 1
- Ska 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
el grillo enamorado | A male singer sings this passionate melody. The song is medium tempo with Latin percussion, guiro percussions, guitar rhythm, piano accompaniment and guitar rhythm. The song is romantic and spirited. The song is a Latin dance song with poor audio quality. | 2008-09-05T17:39:10Z | Piko | el grillo enamorado con imagenes de grillos | ["Music of Africa", "Music", "Ska"] | ["male latin singer", "poor audio quality", "latin percussions", "people dancing", "latin dance band", "dance groove", "emotional", "soaring vocals", "latin folk singer", "walking bass line", "piano accompaniment", "dance rhythm", "entertaining", "romantic", "story telling", "passionate", "spirited", "guiro percussions", "medium tempo", "guitar rhythm"] | 1 | 2cxvYC9QZac | 391 | |
Please Don't Go - Joel Adams - 6 Minute Humming Repeat | A male singer sings this humming vocal. The song is medium tempo with a strong drumming rhythm, groovy bass slime, keyboard accompaniment, piano accompaniment and tambourine accompaniment . The song is emotional and romantic. The song is a modern pop love song with poor audio quality. | 2016-01-24T20:44:40Z | That’s Not Me | I've noticed plenty of you enjoy his humming so I created this repeated version! *Includes a few pictures of Joel* Hope you like it! :-) I found this guy in an ad at the beginning of a video I watched. AMAZING! I'm the sorry that towards the end, a little extra humming loop cut in for about a minute. This is my first video xD I triedddd! I also uploaded a longer 30 minute video! Created by Faith. All Right Reserved to the ORIGINAL by Joel Adams. Check out the full music video here! https://www.youtube.com/watch?v=S2oxFIsENgM Purchase it on iTunes! | ["Humming", "Music"] | ["male singer", "humming vocals", "thumping bass line", "keyboard accompaniment", "guitar playing lead", "lyrical singing", "modern pop hits", "romantic", "emotional", "youthful", "young love", "piano accompaniment", "poor audio quality", "hissing sounds", "tambourine accompaniment", "medium tempo", "strong drumming rhythm"] | 1 | 8CY7G2NrlxY | 902 | |
OPM Love Songs Medley by Kai Brosas | A female singer sings this beautiful melody. The tempo is medium with a piano or keyboard accompaniment and no other instrumentation. The song is emotional and passionate like a love song. The audio quality is very poor with a lot of hissing noise and distortion. | 2010-10-25T09:07:45Z | chelrada713 | ["Singing", "Bell", "Music"] | ["female singer", "poor audio quality", "hissing noise", "distorted vocals", "pop songs", "pop cover", "song covers", "piano accompaniment", "acoustic love song", "live performance", "club", "romantic", "emotional", "sad song", "passionate", "melancholic", "with you forever", "missing you", "passionate", "bad audio quality", "medium tempo"] | 1 | N8Fg3L1Cc5E | 2323 | ||
KEL MITCHELL OFFICIAL "SAME CURL" VIDEO | A male singer sings this cool hip hop melody with backup singers in vocal harmony and screaming vocals. The song is medium tempo with a piano accompaniment, percussive bass line, steady drumming rhythm, clapping percussions, and keyboard accompaniment. The song is passionate like a courtship song. The song has bad audio quality. | 2007-09-06T23:27:32Z | Kel Mitchell | SUBSCRIBE HERE: http://tinyurl.com/kj7kuzo Kel Mitchell stand up previews: http://tinyurl.com/npxffcg R&B Kicked-Outz episodes: http://www.tinyurl.com/m4gvham Hotness or Hotmess: http://tinyurl.com/kbpysg5 Comedy tour dates: http://tinyurl.com/p6bdvos KEL MITCHELL LINKS TWITTER: http://tinyurl.com/l74krrx INSTAGRAM: http://tinyurl.com/oeoqq5j FACEBOOK: http://tinyurl.com/lc9zh8l WEBSITE: http://www.kelmitchell.net GOOGLE PLUS: http://tinyurl.com/qb4vza6 Booking for Kel Mitchell: http://tinyurl.com/le2w9xs Spoof Videos: http://tinyurl.com/n7rynk5 Kel Mitchell is an actor, comedian, dancer, musician, screenwriter, director and producer. GOD BLESS "Jesus will hold it together until you get it together" stay focused! Actor Kel Mitchell's OFFICIAL and very popular music video spoof "Same Curl" based on R. Kelly and Usher's "Same Girl" video. For more info on Kel Please Visit: http://www.KelMitchell.net And for all the haters....you can hate if you want to but you ain't stoppin' NOTHING! | ["Music", "Exciting music"] | ["male singer", "backup singers", "hip hop dance music", "vocal harmony", "screaming vocals", "steady drumming rhythm", "clapping percussion", "keyboard accompaniment", "piano accompaniment", "groovy rhythm", "various percussion hits", "hip hop love songs", "slow dance", "romantic", "courtship song", "madly in love", "infatuation", "love at first sight", "poor audio quality", "retro hip hop hits", "percussive bass line", "medium tempo"] | 1 | Q1pjymZOm6Q | 2590 | |
La Maraca | A male Latin singer sings this energetic vocal with male backup singers in vocal harmony. The song is fast tempo with quick Latin percussions, groovy bass line, keyboard accompaniment and trumpets blaring. The song is energetic and passionate. The song has poor audio quality. | 2008-04-10T19:01:41Z | adonismasgozadera | AdonisGozadera.com | ["Music", "Song", "Salsa music", "Maraca"] | ["male latin singer", "backup singers", "screaming vocals", "rapping vocals", "street music", "fast tempo", "poor audio quality", "piano accompaniment", "latin percussions", "percussive bass line", "fast drumming rhythm", "energetic", "youthful", "romantic", "love performance", "brass band", "trumpets blaring", "groovy", "passionate", "latin dancers", "latin dance rhythm"] | 1 | zNSV9GkpRfM | 5468 |
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;