musiccaps_details (view)
2 rows where musiccaps_aspects contains "cymbal ride" and musiccaps_aspects contains "vocalisation" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- cymbal ride · 2 ✖
- vocalisation · 2 ✖
- animated singing 1
- background music 1
- backup vocal harmony 1
- blues 1
- classic rock and rock 1
- dangerous 1
- dark night 1
- documentary 1
- electric guitar 1
- electronic music 1
- enigmatic 1
- enthusiastic drumming 1
- ethereal 1
- gentle breeze 1
- grim 1
- groovy bass lines 1
- hit songs 1
- instrumental 1
- intense 1
- male vocalist 1
- medium fast tempo 1
- metal swiping 1
- monologue 1
- muffled 1
- mysterious 1
- narration 1
- narrator 1
- retro 1
- rock and rock 1
- rock hits 1
- sinister 1
- slow tempo 1
- sound of whirring engine 1
- suspenseful 1
- swiping sound 1
- synthesiser articulation 1
- tense 1
- thrilling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
Keith Richards Talks About the Blues in Britain | A male voice narrates a monologue to the rhythm of a song in the background. The song is fast tempo with enthusiastic drumming, groovy bass lines,cymbal ride, keyboard accompaniment ,electric guitar and animated vocals. The song plays softly in the background as the narrator speaks and burgeons when he stops. The song is a classic Rock and Roll and the narration is a Documentary. | 2009-05-03T12:26:11Z | Rollingtimesorg | Segments of Keith Richards talking about how the Blues kicked off in Britain, along with the Rolling Stones themselves. Taken from a BBC4 show, "Can Blue Men Play The Whites", as part of Blues Britannia. Also features Bill Wyman and Paul Jones. | ["Blues", "Music", "Yell"] | ["male vocalist", "medium fast tempo", "monologue", "background music", "hit songs", "retro", "narrator", "narration", "documentary", "animated singing", "enthusiastic drumming", "cymbal ride", "electric guitar", "groovy bass lines", "rock and rock", "classic rock and rock", "muffled", "blues", "rock hits", "vocalisation"] | 7 | -7B9tPuIP-w | 17 | |
HMV Destroyed | This music clip is an instrumental. The tempo is slow with a steady keyboard harmony, ethereal male vocal harmony, cymbals, electronic sounds, sound of metal swiping,an engine whirring,and breeze. It is mysterious, suspenseful, enigmatic, grim and intense. | 2008-04-28T01:59:13Z | distroyer3000 | SONGS: 0:15 ~ Boulevard of Broken Dreams by green day 0:40 ~ Peanut butter jelly time 0:56 ~ I'm gonna be by proclaimers 1:11 ~ Disco Inferno by The Trammps 1:20 ~ Stronger by Kanye West 1:26 ~ DOOM Theme 1:35 ~ Raining Men by The Weather Girls 1:44 ~ Why cant we be friends by Smash Mouth (Original by WAR) 1:56 ~ Jaws Theme 2:15 ~ Mario Theme 2:28 ~ You Give Love A Bad Name by Bon Jovi 2:37 ~ Kung Fu Fighting by Carl Douglas 2:45 ~ Baby got back by Sir Mix A Lot 2:56 ~ I like to move it by Reel 2 Real 3:05 ~ Highway to hell by ACDC 3:14 ~ Popcorn by Hot Butter 3:22 ~ Reunited by Peaches & Herb 3:42 ~ All by myself by Celine Dion 3:59 ~ Oompa looompa song 4:19 ~ What a wonderful world by Louis Armstrong 4:44 ~ Grandma got runover by a raindeer 4:59 ~ Zelda Theme 5:19 ~ Blow me away by Breaking Benjamin 5:23 ~ Hide and seek by Imogen Heap 5:46 ~ Mr Roboto by Styx 5:53 ~ You Can't Touch This by MC Hammer 6:01 ~ Chariots of Fire by Vangelis 6:28 ~ Thriller by Michael Jackson 6:54 ~ James bond theme 7:03 ~ I got the power by Snap 7:12 ~ Celebration by Kool & The Gang 7:22 ~ Barny Theme song 7:37 ~ Banana phone by Raffi 7:53 ~ One Is The Loneliest Number by Three Dog Night 8:15 ~ We are the champions by Queen 8:29 ~ Sugar Tunes by Dan Balan | ["Music", "Rumble"] | ["instrumental", "slow tempo", "vocalisation", "metal swiping", "gentle breeze", "dark night", "intense", "mysterious", "ethereal", "thrilling", "suspenseful", "backup vocal harmony", "electronic music", "synthesiser articulation", "tense", "sinister", "grim", "dangerous", "enigmatic", "swiping sound", "sound of whirring engine", "cymbal ride"] | 7 | YyHmz1vcob8 | 3327 |
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;