musiccaps_details (view)
2 rows where musiccaps_aspects contains "no voices", musiccaps_aspects contains "simple percussion" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- instrumental 2
- no voices · 2 ✖
- simple percussion · 2 ✖
- 12 bar blues 1
- amateur recording 1
- banjo 1
- bass 1
- guitar solo 1
- happy mood 1
- moderate tempo 1
- piano 1
- rock song 1
- slow blues song 1
- slow tempo 1
- tambourine 1
- violins 1
musiccaps_names (array) 7 ✖
- Music 2
- Musical instrument · 2 ✖
- Banjo 1
- Bowed string instrument 1
- Guitar 1
- Jazz 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Classical Gas by Roy Clark Band Banjo Pickin' 1987 Live | This amateur recording features a rock song. The main melody is played on violins. This is accompanied by percussion playing with breaks matching the breaks in the violin parts. At the end, the violins play a sustained note and a banjo starts to play a melody. A tambourine is played on the first count of the second bar after the banjo starts to play. This is an uptempo song and has a happy feel. This instrumental song can be played in a coffee shop. | 2007-06-12T06:30:56Z | NelnetDude | Enjoy! | ["Banjo", "Music", "Musical instrument", "Bowed string instrument"] | ["amateur recording", "rock song", "instrumental", "no voices", "violins", "banjo", "tambourine", "simple percussion", "happy mood", "moderate tempo"] | 0 | MpWGx5odhh8 | 2301 | |
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;