musiccaps_details (view)
6 rows where musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "male vocalist" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 106 ✖
- electric guitar · 6 ✖
- male vocalist · 6 ✖
- medium fast tempo 4
- acoustic guitar 2
- blues 2
- energetic 2
- enthusiastic 2
- enthusiastic drumming 2
- funky bass line 2
- keyboard harmony 2
- mellow 2
- sentimental 2
- soft rock 2
- acoustic guitar harmony 1
- affecting 1
- animated singing 1
- arabic 1
- arabic dance music 1
- arabic pop 1
- artist 1
- background music 1
- bass drum 1
- buoyant 1
- cello 1
- cheering clapping 1
- christian gospel music 1
- christian music 1
- christian pop 1
- christian praise and worship 1
- christian rock 1
- christian song 1
- christian worship song 1
- church 1
- clapping 1
- classic rock and rock 1
- closing riff 1
- concert 1
- contemporary 1
- cymbal ride 1
- cymbals 1
- documentary 1
- emotional 1
- ending song 1
- fast tempo 1
- female vocal backup 1
- first love 1
- funky 1
- gig 1
- gospel music 1
- gratitude 1
- groovy 1
- groovy bass lines 1
- hit songs 1
- humility 1
- infectious drumming 1
- insightful 1
- jazz 1
- keyboard accompaniment 1
- keyboard arrangements 1
- light 1
- live audience 1
- live performance 1
- love song 1
- medium 1
- melodic 1
- monologue 1
- muffled 1
- narration 1
- narrator 1
- organ 1
- ost 1
- oud accompaniment 1
- oud harmony 1
- pensive 1
- performer 1
- pipe organ 1
- playful 1
- poignant 1
- pop 1
- reflective 1
- reggae 1
- repentance 1
- retro 1
- reverence 1
- rock 1
- rock and rock 1
- rock hits 1
- romantic 1
- slick drumming 1
- soft 1
- song end 1
- southern rock 1
- stage performance 1
- steady bass lines 1
- steady drumming 1
- subtle bass 1
- tambourine beats 1
- tempo 1
- tender 1
- violin harmony 1
- violin harmony soft 1
- vocal backup 1
- vocalisation 1
- worship 1
- youthful 1
- you’ve got mail 1
musiccaps_names (array) 18 ✖
- Music 5
- Rock music 2
- Bass guitar 1
- Blues 1
- Christmas music 1
- Funk 1
- Guitar 1
- Jazz 1
- Jingle (music) 1
- Music of Bollywood 1
- Musical instrument 1
- Plucked string instrument 1
- Psychedelic rock 1
- Rhythm and blues 1
- Singing 1
- Song 1
- Soul 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 | |
You've got mail ending - Music: Forever J | A male vocalist sings this romantic song. The tempo is medium fast with keyboard harmony, infectious drumming, steady bass lines and electronic guitar. The song is simple, mellow, tender, sentimental, emotional and mellow. This is a Romantic Soft Rock. | 2007-02-17T09:45:14Z | john kouk | Sweet movie, sweet actors, sweet song... | ["Jazz", "Music", "Rhythm and blues"] | ["male vocalist", "medium fast tempo", "infectious drumming", "sentimental", "mellow", "tender", "love song", "first love", "pop", "ost", "you’ve got mail", "ending song", "keyboard harmony", "steady bass lines", "violin harmony soft", "mellow", "romantic", "soft rock", "electric guitar"] | 7 | 6PWiDlWmPs0 | 751 | |
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 | |
Three Little Birds -Bob Marley- with lyrics HD | A male vocalist sings this light melody. The tempo is medium with a funky bass line, keyboards accompaniment; slick drumming, groovy electric guitar and acoustic guitar riff with female vocal backup. The song is light, punchy, buoyant, groovy, funky,insightful, reflective and melodic. This song is a spirited Reggae song. | 2013-08-27T16:58:35Z | musicaprayer | Bob Marley & The Wailers Three Little Birds with a original animation. If you like this video, give it a thumbs up! Contact me on Facebook! https://www.facebook.com/shohei.yamatsu | ["Funk"] | ["male vocalist", "medium fast tempo", "reflective", "melodic", "keyboard harmony", "groovy", "funky", "youthful", "buoyant", "reflective", "organ", "electric guitar", "acoustic guitar", "steady drumming", "funky bass line", "bass drum", "pipe organ", "light", "playful", "affecting", "insightful", "cymbals", "female vocal backup", "reggae", "jazz"] | 7 | HCCGZh-TxK0 | 1779 | |
God Must be Loved / Rich Moore - Praise Song / Lyrics | A male vocalist sings this emotional Christian Worship Song. The tempo is medium with energetic drumming,harmonious electric guitar , acoustic Guiana keyboard accompaniment and subtle bass. The song is a soft, mellow, emotional, pensive, devotional, Christian music. | 2014-01-15T17:06:38Z | Christian Sermons and Audio Books | God Must be Loved / Rich Moore - Praise Song / Lyrics My original Christian music facebook page: https://www.facebook.com/richmoorechristianmusic I am a singer, guitarist, and songwriter. This is a new original contemporary Christian song I recently wrote and recorded. May those who listen find it a great blessing, to the glory of the Lord Jesus Christ...praise God. (Music and video owned and copyrighted by stack45ny) My Original Contemporary Christian Songs (playlist): http://www.youtube.com/playlist?list=PLzOwqed_gET0JkRfjd1-xm_BGrCYaJqVR Christian Praise and Worship Songs playlist: https://www.youtube.com/playlist?list=PL4D0533BC00E40EA4 Matthew 10:34 "Do not think that I came to bring peace on earth. I did not come to bring peace but a sword. 35 For I have come to 'set a man against his father, a daughter against her mother, and a daughter-in-law against her mother-in-law'; 36 and 'a man's enemies will be those of his own household.' 37 He who loves father or mother more than Me is not worthy of Me. And he who loves son or daughter more than Me is not worthy of Me. 38 And he who does not take his cross and follow after Me is not worthy of Me. -~-~~-~~~-~~-~- Please watch: "A Call to Separation - A. W. Pink Christian Audio Books / Don't be Unequally Yoked / Be Ye Separate" https://www.youtube.com/watch?v=CBDg7u21cKY -~-~~-~~~-~~-~- | ["Christmas music", "Jingle (music)", "Music", "Psychedelic rock", "Rock music", "Song", "Soul music"] | ["male vocalist", "medium", "emotional", "sentimental", "soft", "subtle bass", "mellow", "pensive", "poignant", "repentance", "gratitude", "worship", "reverence", "church", "humility", "tempo", "slick drumming", "acoustic guitar harmony", "keyboard accompaniment", "christian song", "christian gospel music", "christian praise and worship", "christian worship song", "gospel music", "christian pop", "christian rock", "electric guitar", "christian music"] | 7 | RceCfg1FQq4 | 2713 | |
Curtis Stigers-This Life | A male vocalist sings this spirited song. The tempo is medium fast with an acoustic and electric guitar flourish with a bass cello. This bit is the end of the song as the musician plays a closing riff and the sound of clapping and cheering can be heard. This song is an enthusiastic live performance of an energetic Soft Rock. | 2012-04-19T22:49:45Z | Roxxboise | Sons of Anarchy theme song from Curtis Stigers in-studio at KRVB, "The River," Boise, Idaho. | ["Singing", "Bass guitar", "Guitar", "Music", "Musical instrument", "Rock music", "Plucked string instrument"] | ["male vocalist", "medium fast tempo", "song end", "closing riff", "live performance", "concert", "live audience", "gig", "stage performance", "cheering clapping", "acoustic guitar", "electric guitar", "cello", "southern rock", "blues", "rock", "contemporary", "soft rock", "enthusiastic", "energetic", "performer", "artist"] | 7 | kkOGbgGJLF4 | 4352 |
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;