musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "piano", musiccaps_aspects contains "simple percussion" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- bass 2
- piano · 2 ✖
- simple percussion · 2 ✖
- 12 bar blues 1
- falsetto voice 1
- guitar 1
- guitar solo 1
- instrumental 1
- male voices 1
- moderate tempo 1
- motown feel 1
- no voices 1
- r&b song 1
- romantic mood 1
- slow blues song 1
- slow tempo 1
- vocal harmony 1
musiccaps_names (array) 6 ✖
- Music · 2 ✖
- Guitar 1
- Jazz 1
- Musical instrument 1
- Plucked string instrument 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Temptations "The Girl's Alright With Me" My Extended Version! | This R&B song features a male voice singing the main melody in falsetto. There are other male voices singing backing vocals in harmony with the main voice. This is accompanied by percussion playing a simple beat. The bass plays the root notes of the chords without any flourishes or embellishments. A piano plays an arpeggiated pattern that changes with the chords of the song. A guitar strums chords using upstrokes. The mood of this song is romantic. The melody has a motown feel. This song can be played at the end credits of a romantic movie. | 2012-04-20T20:56:50Z | mosogotam | No copyright infringement intended. One of my favorite Tempts tunes....extended just a smidge. | ["Music", "Soul music"] | ["r&b song", "male voices", "vocal harmony", "falsetto voice", "guitar", "simple percussion", "bass", "piano", "motown feel", "moderate tempo", "romantic mood"] | 0 | LGi38MqlPFA | 2170 | |
Jazzed Blues Solo | This slow blues song features a solo played on a guitar. The tempo of this song is slow. This is accompanied by percussion playing a simple beat. The bass follows the 12 bar blues pattern. The piano plays chords in the background. The mood of this song is romantic and the pattern played on the guitar is similar to a call-response theme. This song can be played in a bar. | 2006-07-17T14:30:15Z | looptruefire | My favorite solo from TrueFire's Jazz ed Blues course with Mark Stefani. | ["Guitar", "Jazz", "Music", "Musical instrument", "Plucked string instrument"] | ["slow blues song", "instrumental", "guitar solo", "bass", "simple percussion", "12 bar blues", "piano", "slow tempo", "no voices"] | 0 | qAgZ__fk9LY | 4760 |
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;