musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "groovy bass lines" and musiccaps_aspects contains "medium fast tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 53 ✖
- groovy bass lines · 3 ✖
- male vocalist 3
- medium fast tempo · 3 ✖
- amplified instruments 2
- energetic 2
- infectious drumming 2
- retro 2
- youthful 2
- animated electric guitar harmony 1
- animated singing 1
- anthem 1
- ardent 1
- background music 1
- blues 1
- bright electric guitar lead 1
- cheer chant 1
- classic rock and rock 1
- concert 1
- cymbal ride 1
- documentary 1
- electric guitar 1
- electric guitar lead 1
- energetic vocal backup 1
- enthusiastic 1
- enthusiastic drumming 1
- excited vocals 1
- fans 1
- fervent 1
- gig 1
- hard rock 1
- heavy metal 1
- hit songs 1
- insistent 1
- keyboard accompaniment 1
- keyboard harmony 1
- live performance 1
- metal 1
- monologue 1
- muffled 1
- narration 1
- narrator 1
- punchy drumming 1
- recurring 1
- retro rock 1
- rhythmic chant 1
- rock 1
- rock and rock 1
- rock hits 1
- sonic power 1
- spirited 1
- sports 1
- sports team 1
- vocalisation 1
musiccaps_names (array) 8 ✖
- Music 3
- Angry music 1
- Blues 1
- Burst, pop 1
- Psychedelic rock 1
- Punk rock 1
- Rock music 1
- Yell 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 | |
Cold Metal - Iggy Pop.mp4 | A male vocalist sings this energetic Rock song. The tempo is medium fast with an animated electric guitar harmony and lead, groovy bass lines,infectious drumming and keyboard harmony. The song is electric,pulsating, youthful, energetic, enthusiastic, passionate and powerful with emphatic vocals. This song is Heavy Metal. | 2010-01-13T20:14:33Z | wotsitooyou | Iggy Pop live does Cold Metal | ["Music", "Punk rock", "Psychedelic rock", "Rock music", "Burst, pop"] | ["male vocalist", "medium fast tempo", "live performance", "gig", "concert", "retro", "retro rock", "keyboard harmony", "infectious drumming", "animated electric guitar harmony", "groovy bass lines", "punchy drumming", "electric guitar lead", "retro", "rock", "heavy metal", "hard rock", "metal", "sonic power", "amplified instruments", "excited vocals", "youthful", "spirited", "enthusiastic", "energetic"] | 7 | NxdQtpceXaI | 2381 | |
San Diego Chargers Theme Song!! | A male vocalist sings this energetic song. The tempo is medium fast with enthusiastic vocal backup, bright electric guitar lead and harmony, infectious drumming, keyboard accompaniment and groovy bass lines. The backup is a spirited recurring vocal riff. The song sounds like an anthem or cheer chant to show support for a team.it is passionate, enthusiastic, energetic, spirited, youthful and fervent. | 2009-04-01T01:48:11Z | justin gilliland | Chargers Theme Song BY P.O.D!!!!!!! | ["Music", "Angry music"] | ["male vocalist", "medium fast tempo", "cheer chant", "fervent", "ardent", "groovy bass lines", "sports team", "sports", "fans", "energetic vocal backup", "anthem", "infectious drumming", "bright electric guitar lead", "amplified instruments", "keyboard accompaniment", "rhythmic chant", "energetic", "youthful", "insistent", "recurring"] | 7 | QFhmzRkUx0I | 2606 |
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;