musiccaps_details (view)
3 rows where musiccaps_aspects contains "electric guitar" and musiccaps_aspects contains "enthusiastic drumming"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- electric guitar · 3 ✖
- enthusiastic drumming · 3 ✖
- male vocalist 2
- retro 2
- rock and rock 2
- animated singing 1
- arabic 1
- arabic dance music 1
- arabic pop 1
- background music 1
- blues 1
- clapping 1
- classic rock and rock 1
- cymbal ride 1
- dance groove 1
- documentary 1
- energetic 1
- enthusiastic 1
- fast tempo 1
- funky bass line 1
- groovy bass lines 1
- hit songs 1
- jive 1
- keyboard arrangements 1
- lively piano 1
- male singer 1
- medium fast tempo 1
- medium tempo 1
- monologue 1
- muffled 1
- narration 1
- narrator 1
- oud accompaniment 1
- oud harmony 1
- popular music 1
- rhythmic acoustic guitar 1
- rock and roll 1
- rock hits 1
- tambourine beats 1
- violin harmony 1
- vocal backup 1
- vocalisation 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 | |
OUJRIH émission Tamazight TV4 pour la présentation de son nouvel album 2012 (THILELLI) | A male vocalist sings this upbeat Arabic pop. The tempo is fast and enthusiastic with intense bass lines, keyboard arrangement , vigorous drumming, violin symphony, oud accompaniment with vocal backup and sound of clapping and tambourine beats. The song is energetic, vivacious, enthusiastic, engaging and compelling with a high energy dance vibe. This song is contemporary Pop. | 2012-03-01T11:56:52Z | bananeverte600 | OUJRIH émission tamazight tv4 le 29.02.2012 | ["Music", "Music of Bollywood"] | ["male vocalist", "fast tempo", "keyboard arrangements", "clapping", "arabic", "oud accompaniment", "arabic pop", "vocal backup", "enthusiastic", "energetic", "electric guitar", "funky bass line", "oud harmony", "violin harmony", "enthusiastic drumming", "clapping", "tambourine beats", "arabic dance music"] | 7 | 6nWWTNVRDjw | 787 | |
She's So Fine-Flash Cadillac-original song-1972 | A male vocalist sings this upbeat retro song. The tempo is medium with an infectious electronic guitar, hard hitting drums, rhythmic acoustic guitar and funky bass. The song is rhythmic, groovy, upbeat, catchy, and energetic. This song is Retro Rock and Roll. | 2008-03-18T21:01:55Z | AK47bandit | original song, oldie. | ["Country", "Music"] | ["male singer", "medium tempo", "rock and roll", "rhythmic acoustic guitar", "popular music", "retro", "dance groove", "jive", "enthusiastic drumming", "lively piano", "rock and rock", "electric guitar"] | 7 | d20qTsF6ll8 | 3758 |
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;