musiccaps_details (view)
2 rows where search matches "guitar" and musiccaps_aspects contains "male narrator"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- male narrator · 2 ✖
- acoustic drums 1
- bass 1
- bass guitar 1
- drum roll 1
- electric guitar 1
- groovy 1
- guitar 1
- high pitch singing 1
- male vocal 1
- marching beat 1
- movie song 1
- organ 1
- r&b music 1
- sit-com soundtrack 1
- slow blues 1
- slow tempo 1
- urban 1
musiccaps_names (array) 9 ✖
- Bass drum 1
- Drum 1
- Drum roll 1
- Music 1
- Percussion 1
- Rimshot 1
- Ska 1
- Snare drum 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Everybody Hates Chris | This is an R&B music piece from a sit-com soundtrack. Initially, there is a male voice narrating what is going on in the episode. Then the piece starts playing with a high pitched male vocal at the forefront. The melody is being played by the electric guitar and the bass guitar while the rhythmic background consists of an acoustic drum beat. The atmosphere is urban. | 2007-02-10T13:09:18Z | tigerzrule | My Personal Fav Bits OF EHC | ["Music", "Ska", "Speech"] | ["sit-com soundtrack", "male narrator", "r&b music", "male vocal", "high pitch singing", "electric guitar", "bass guitar", "acoustic drums", "groovy", "urban"] | 9 | T78nMdsJMmk | 2810 | |
Charles Bradley: Soul of America OFFICIAL FILM TRAILER | This song features a male voice narrating a story in the beginning. This is followed by a drum roll in a marching beat style. A bass note is played which is the root note of the chord. An organ strikes a chord and plays it staccato style. A guitar also strikes a chord. There are no other instruments in this song. This song can be played in a movie trailer. | 2012-02-01T09:55:11Z | CBSoulOfAmerica | This is the OFFICIAL TRAILER for the documentary feature Charles Bradley: Soul of America, which is now available on iTunes (http://georiot.co/2ULl), on Amazon (http://amzn.to/15B0i3k) and in theaters via TUGG.com. The 74 minute feature documentary premiered at SXSW 2012 and played 39 festivals around the world including IDFA, Silverdocs and Hot Docs and won Best Documentary at the 2013 Annapolis Film Festival. Charles Bradley: Soul of America captures the incredible late in life rise of 62 year old aspiring soul singer Charles Bradley, whose unprecedented debut album rocketed him from a hard life in the projects to Rolling Stone magazine's top 50 albums of 2011. Trailer Credits: Director Poull Brien. EP/Producer: Alexander Brough. DP: Stuart McCardle. Editor: Poull Brien. Titles: Robert S. Dunbar. Music by Charles Bradley and Menahan Street Band. For more information on the film, updates, screenings, giveaways, credits and more, please visit www.charlesbradleyfilm.com | ["Drum", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["movie song", "drum roll", "marching beat", "guitar", "organ", "male narrator", "bass", "slow blues", "slow tempo"] | 0 | uegzZWp6Y4w | 5131 |
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;