musiccaps_details (view)
2 rows where musiccaps_aspects contains "marching beat" and musiccaps_aspects contains "slow tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- marching beat · 2 ✖
- slow tempo · 2 ✖
- bass 1
- drum roll 1
- guitar 1
- male narrator 1
- male voice 1
- melancholic mood 1
- movie song 1
- organ 1
- programmed percussion 1
- repetitive melody 1
- slow blues 1
- slow rock song 1
- synth sounds 1
musiccaps_names (array) 8 ✖
- Bass drum 1
- Clatter 1
- Drum 1
- Drum roll 1
- Music 1
- Percussion 1
- Rimshot 1
- Snare drum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chameleon Circuit - The Sound of Drums | This slow rock song starts off with a male voice that pauses after one word. This is accompanied by percussion playing a marching beat. Synth strings play chords in the background. Bass notes follow the root notes of the chords. After the voice pauses, a repetitive melody is played on the synth and the chords change on the other instruments. The percussion continues to play the marching beat. This song can be played in a war scene in a movie. | 2011-07-22T13:45:15Z | Brittany Covington | if you wanna hear a song, let me know and i will try my best (: (which means it will happen very very very very quickly because i am very impatient and i have nothing better to do) So suggestions will help entertain me, and you'll know it will happen If i keep getting song suggestions i think i will try to do a song a day and this isn't to MAKE you subscibe but please subscibe if you're interested (: | ["Music", "Clatter"] | ["slow rock song", "male voice", "synth sounds", "marching beat", "programmed percussion", "slow tempo", "melancholic mood", "repetitive melody"] | 0 | gjJWbtCShqo | 4049 | |
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;