musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "double bass", musiccaps_aspects contains "male voice" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 24 ✖
- double bass · 4 ✖
- male voice · 4 ✖
- moderate tempo 3
- drums 2
- guitar 2
- no percussion 2
- acoustic guitar 1
- announcement 1
- banjo 1
- bluegrass 1
- country song 1
- electric guitar 1
- happy mood 1
- live recording 1
- low audio recording quality 1
- low quality music 1
- mandolin 1
- no vocal melody 1
- reverb effect 1
- romantic mood 1
- romantic theme 1
- slow rock 1
- violin 1
- vocal harmony 1
musiccaps_names (array) 14 ✖
- Music · 4 ✖
- Banjo 1
- Bluegrass 1
- Blues 1
- Bowed string instrument 1
- Country 1
- Electric guitar 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Rock and roll 1
- Singing 1
- Speech 1
- Tick 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Stray Cat Strut by The Nosey Joe Band | The music features a male voice singing a descending melody that repeats. The instrumental consists of a drum kit that's playing a light rhythm, a double bass that's playing a repeating descending melody and an electric guitar that's strumming chords once per beat. The quality of the audio recording is not so good which leads me to believe this is an amateur recording and not something professional. | 2008-05-28T02:57:13Z | pookyfmr | This is our version of the song made famous by the Stray Cats. | ["Blues", "Singing", "Music", "Rock and roll"] | ["male voice", "reverb effect", "electric guitar", "double bass", "drums", "low audio recording quality"] | 2 | FvQgVl5IBHw | 1676 | |
Deer Tick 10-18-2007 Ashamed 1/10 | This song is a low quality live recording of a performance. This features a male voice singing the main melody. At the end of the song, other voices sing with the main voice in harmony. This is accompanied by an electric guitar plucking chords. The double bass plays the root notes of the chords. The percussion plays the cymbal, increasing volume slowly, giving it a swell feel. The mood of the song seems romantic. | 2007-10-22T00:17:05Z | vincenz7 | Live @ Cakeshop. CMJ's. Unfortunately it got cut 1 1/2 minutes into the song. But check out the rest of the show! | ["Electric guitar", "Guitar", "Music", "Tick"] | ["live recording", "male voice", "slow rock", "guitar", "double bass", "drums", "low quality music", "romantic theme", "vocal harmony", "moderate tempo"] | 0 | P90rFZQFqWk | 2510 | |
Never Live Life (Like This) Country Music Video | This country song features a male voice singing in a Southern accent. The main melody is a typical country melody. This is accompanied by a violin playing backing notes. The guitar strums chords. The double bass plays the root note and lower fifth of the chords. This song has a happy mood. At the end, there are multiple male voices singing one word together. This song can be played in a happy Country Western movie. | 2013-08-03T02:08:03Z | Papa Darwell | Darwell and The RiskTaker Band Filmed at Darwells Cafe Our Tribute to the Great Earnest Tubb | ["Country", "Music", "Bluegrass"] | ["country song", "violin", "double bass", "male voice", "acoustic guitar", "moderate tempo", "happy mood", "no percussion"] | 0 | colnyHv9CAA | 3744 | |
We'll Meet Again Sweet Heart- Japanese bluegrass Band in Korea.wmv | This bluegrass song starts off with a male voice making an announcement. The music starts to play. The banjo plays an introductory bluegrass lick. This is accompanied by an acoustic guitar strumming chords. The double bass plays the root note and the fifth of the chord. The mandolin plays the rhythm section in the song. There is no vocal melody in this song. There is no percussion in this song. This song can be played in a movie with a Western theme. | 2010-11-25T14:46:00Z | sun shin | ["Banjo", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Bowed string instrument"] | ["bluegrass", "male voice", "announcement", "no percussion", "no vocal melody", "mandolin", "guitar", "banjo", "double bass", "moderate tempo", "romantic mood"] | 0 | oyAAhjGTNvQ | 4671 |
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;