musiccaps_details (view)
3 rows where musiccaps_aspects contains "no voices", musiccaps_author = 0, musiccaps_names contains "Bass guitar" and musiccaps_names contains "Plucked string instrument"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Koch Twintone II Head + 1x12 Cabinet Tokai ES130 | This song features an electric guitar. The guitar plays a blues progression by first descending three chords and then ending the song on a higher register. The guitar tone has a lot of added reverb. There are no other instruments in this audio. This is an instrumental song with no voices. | 2012-07-07T18:05:45Z | overlahe | Backtrack: Thrill is gone Guitar: Tokai ES130, Gibson Classic 57 Neck Pickup, Seymour Duncan Pearly Gates Bridge Pickup. Koch Amplifier Footswitch, no further Pedals. | ["Bass guitar", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["guitar music", "no percussion", "no other instruments", "reverb effect", "no voices"] | 0 | 31O2j4aAgYU | 433 | |
Rickenbacker 4003 Bass | Reverb Demo | This song features a bass guitar being played. At first, a single note is ringing. After a brief pause, an ascending lick is played in common time. The first note is played eight times. The second note is played four times, the third and fourth, two times each. The fifth note is played eight times. The sixth and seventh notes are played four times each. The last note is played once as a double stop with the open string above it and a fretted note on the higher register. This song is an instrumental and can be played in an instructional audio. | 2014-07-21T22:34:45Z | Reverb | Find a Rickenbacker 4003 bass on Reverb.com (http://goo.gl/y0aYLk) The iconic Rickenbacker 4003 continues a bass legacy dating back to the '60s that includes players like Geddy Lee, Paul McCartney and Lemmy Kilmister. Like the original 4001 bass, the 4003 features solid neck-thru construction with a pair of fat pickups to deliver a huge dose of fat bass tone. The distinct Rickenbacker body style and finishes gives the 4003 a unmistakable look to match their sound. | ["Bass guitar", "Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | ["bass song", "no other instruments", "no voices", "instructional song"] | 0 | RDW_kz4SXo0 | 2680 | |
Richard Bona's new Bass: De Gier BeBop, part 1 | This song features a bass guitar playing a groovy lick at a high pitch. This is followed by a rock and roll pattern. This starts off on a high sequence. This is played for two bars followed by a sequence on a lower part of the bass. This song can be played in an instructional video for bass. There are no voices in this song. There are no other instruments in this song. | 2010-10-28T10:02:17Z | degierguitarsbasses | http://www.degierguitars.com Watch Richard Bona playing his new De Gier BeBop. Check the other Bona-BeBop video's too! For more info on the bass, visit our website. Subscribe to our channel, more video's coming up. If you like this video, give us a good rating. Thanks. | ["Bass guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["bass guitar", "no voices", "instrumental", "no other instruments", "instructional song"] | 0 | xVab_CbwecE | 5335 |
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;