musiccaps_details (view)
3 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "guitar" and musiccaps_aspects contains "slow tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- bass · 3 ✖
- guitar · 3 ✖
- slow tempo · 3 ✖
- amateur recording 1
- drum roll 1
- female voice 1
- male narrator 1
- marching beat 1
- melancholic mood 1
- movie song 1
- no other instruments 1
- no voice 1
- organ 1
- percussion 1
- repetitive phrase 1
- rock 1
- romantic mood 1
- simple percussion 1
- slow blues 1
- slow pop song 1
musiccaps_names (array) 13 ✖
- Bass drum 1
- Christian music 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Guitar 1
- Music 1
- Musical instrument 1
- Percussion 1
- Pulse 1
- Rimshot 1
- Rock music 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 |
---|---|---|---|---|---|---|---|---|---|---|
The Tea Party - Lullaby Live In Montreal - July 7, 2011 | This amateur recording features a rock song. A repetitive phrase is played on the guitar. The first bar consists of only the guitar sound. The bass and percussion start playing after one bar. The bass plays one note in groups of twos. The percussion plays a groovy rock beat. The hi-hat is played in a group of four strokes on the closed hi-hat followed by one stroke on the open hi-hat. There are no voices in this song. The mood of this song is melancholic. | 2011-07-10T12:36:07Z | Luc Beaulieu | Live at Le Métropolis, Montreal, Québec, Canada | ["Drum kit", "Guitar", "Music", "Musical instrument", "Rock music", "Pulse"] | ["amateur recording", "rock", "guitar", "repetitive phrase", "percussion", "bass", "no voice", "no other instruments", "slow tempo", "melancholic mood"] | 0 | GcYeBWujhjw | 1741 | |
Brooke Fraser - Faithful | This pop song features a female voice singing the main melody. At the highest pitch, her voice goes into falsetto. This is accompanied by percussion playing a simple beat in common time. An electric guitar plays a repetitive two note phrase in the background. Another guitar player fills in the background. The bass plays the root notes of the chords. This song can be played in a romantic movie. | 2010-11-06T06:18:07Z | Jenx Fernandez | I do not own this song. All credits belongs to the owner | ["Christian music"] | ["slow pop song", "romantic mood", "female voice", "guitar", "bass", "simple percussion", "slow tempo"] | 0 | UDS6PrY9ZIM | 2896 | |
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;