musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "buzzy bass guitar" and musiccaps_names contains "Guitar" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_names (array) 9 ✖
- Electric guitar 2
- Guitar · 2 ✖
- Music 2
- Plucked string instrument 2
- Bass guitar 1
- Blues 1
- Effects unit 1
- Electronic tuner 1
- Musical instrument 1
musiccaps_aspects (array) 8 ✖
- buzzy bass guitar · 2 ✖
- low quality 2
- noisy 2
- chill electric guitar licks 1
- passionate 1
- playback 1
- wide acoustic guitar melody 1
- wooden percussive elements 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
No Destination, no ETA - acoustic and slide guitar self-duet. | The low quality recording features a passionate acoustic guitar melody in the right channel, chill electric guitar licks in the left channel of the stereo image and buzzy bass guitar in the middle. There is a wooden percussive playback playing in the background. The recording is very noisy. | 2009-06-09T08:02:12Z | Kirk Lorange | A little thing I put together with my new bass. The keyboard and percussion is a midi file I made in GuitarPro, the bass is my new bass and I then overdubbed and filmed the nylon string and slide guitars. The tune is one of mine, an old chord progression I dredged from the recesses of my mind and revived for this. | ["Blues", "Effects unit", "Electric guitar", "Guitar", "Music", "Plucked string instrument"] | ["low quality", "wide acoustic guitar melody", "playback", "wooden percussive elements", "buzzy bass guitar", "chill electric guitar licks", "noisy"] | 4 | SNhfvhWPXNc | 2764 | |
Sadowsky & DNA Amps 1350 Bass Groove at Bass Club Chicago by Shaun Gotti | The low quality recording features a buzzy bass guitar playing. It sounds passionate, even though the recording is very noisy. | 2014-01-25T02:16:37Z | Bass Club Chicago | http://www.bassclubchicago.com I was in the process of shooting a demo on the DNA Amps 1350 Bass head and Lawrence Calloway (AKA Shaun Gotti) came into the store. I was able to capture him trying out a few different Sadowsky Basses. Shaun is a MONSTER player and I was lucky enough to capture some of his madness. The Basses he played are listed below. DNA 1350 bass demo will soon follow. Youre hearing a 50/50 split of DI & Mic. At certain points in the demo, the mic was a few feet away from the cab, I wasnt prepared to start shooting when he got there. I basically plugged him in and capture him groovin on the fly. Sadowsky RV5 : https://www.bassclubchicago.com/ProductDetails.asp?ProductCode=SADMETRORV5BLACK Sadowsky M5-24 : https://www.bassclubchicago.com/ProductDetails.asp?ProductCode=SadowskyModernW DNA 1350 Head: https://www.bassclubchicago.com/ProductDetails.asp?ProductCode=DNA1350 DNA 210 Cab: https://www.bassclubchicago.com/ProductDetails.asp?ProductCode=DNADNS210 Contact us at: (773) 561-3521 if you have any questions. Be sure to check out our website at: http://www.bassclubchicago.com Video Shot & Edited by http://www.JodyMichaelMiller.com Friend us on Facebook! http://www.facebook.com/bassclubchicago Follow us on Twitter http://www.twitter.com/bassclubchicago Follow us on Instagram http://www.instagram.com/bassclubchicago | ["Bass guitar", "Electric guitar", "Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument"] | ["low quality", "noisy", "buzzy bass guitar", "passionate"] | 4 | iePMcLYozYY | 4212 |
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;