musiccaps_details (view)
1 row where musiccaps_aspects contains "drum roll", musiccaps_aspects contains "guitar", musiccaps_aspects contains "slow tempo" and musiccaps_names contains "Snare drum"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;