musiccaps_details (view)
4 rows where musiccaps_aspects contains "percussive bass line" and musiccaps_aspects contains "screaming vocals" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 62 ✖
- percussive bass line · 4 ✖
- poor audio quality 4
- screaming vocals · 4 ✖
- backup singers 2
- energetic 2
- live performance 2
- male singer 2
- medium tempo 2
- passionate 2
- piano accompaniment 2
- rebellious 2
- romantic 2
- steady drumming rhythm 2
- adrenaline rush 1
- ambient room noise 1
- brass band 1
- clapping percussion 1
- courtship song 1
- death metal 1
- deteriorated audio 1
- deteriorated audio quality 1
- distorted guitar rhythm 1
- emotional 1
- fast drumming rhythm 1
- fast metal drumming 1
- fast tempo 1
- female singer 1
- groovy 1
- groovy rhythm 1
- guitar rhythm 1
- hard metal music 1
- haunting 1
- head banging 1
- hip hop dance music 1
- hip hop love songs 1
- infatuation 1
- keyboard accompaniment 1
- latin dance rhythm 1
- latin dancers 1
- latin percussions 1
- live audience 1
- love at first sight 1
- love performance 1
- madly in love 1
- male latin singer 1
- metal band 1
- mosh pit 1
- noisy crowd 1
- rapping vocals 1
- retro death metal hits 1
- retro hip hop hits 1
- retro metal hits 1
- screaming 1
- slow dance 1
- spirited 1
- street music 1
- teenage age angst 1
- trumpets blaring 1
- various percussion hits 1
- vintage metal 1
- vocal harmony 1
- youthful 1
musiccaps_names (array) 10 ✖
- Music 4
- Exciting music 1
- Grunge 1
- Maraca 1
- Rock music 1
- Salsa music 1
- Singing 1
- Song 1
- Whoop 1
- Yell 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hole - Dicknail (live) | A female singer sings this screaming metal melody. The song is medium tempo with a steady metal drumming rhythm, steady bass line and a distorted guitar playing rhythm. The song is rebellious and passionate. The audio quality is very poor. | 2006-11-03T22:44:40Z | distillersdemon | Just a video of Hole performing Dicknail... | ["Singing", "Music", "Rock music", "Yell", "Grunge"] | ["poor audio quality", "death metal", "retro death metal hits", "female singer", "screaming vocals", "haunting", "rebellious", "poor audio quality", "live audience", "live performance", "teenage age angst", "rebellious", "passionate", "emotional", "poor audio quality", "deteriorated audio", "steady drumming rhythm", "distorted guitar rhythm", "percussive bass line", "ambient room noise", "medium tempo"] | 1 | Cwbtn_h6TP8 | 1416 | |
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 | |
김경호 shout 초반 샤우팅 연도별 모음 | A male singer sings this screaming metal melody. The song is medium fast tempo with a fast metal drumming rhythm, percussive bass line and guitars playing accompaniment. The song is rebellious and highly spirited. The audio quality is very poor and vintage. | 2016-03-01T09:07:30Z | 갓경호 | 김경호 shout 초반 샤우팅 연도별 모음1998/1999/2000/2001/2002/2003/2004/2005/2009/2010/2011/2014 | ["Music", "Whoop"] | ["hard metal music", "male singer", "screaming vocals", "vintage metal", "metal band", "deteriorated audio quality", "head banging", "mosh pit", "retro metal hits", "screaming", "noisy crowd", "live performance", "fast metal drumming", "guitar rhythm", "percussive bass line", "energetic", "adrenaline rush", "poor audio quality", "spirited", "rebellious"] | 1 | g75kz9ffcg0 | 4007 |
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;