musiccaps_details (view)
3 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "e-bass", musiccaps_names contains "Bass guitar" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Brimstone Audio Crossover Distortion (electric bass demo) | Someone is playing a bass melody through a distortion effect. This song may be playing bass at home. | 2013-09-01T07:32:26Z | Brimstone Audio | The Crossover Distortion is a multi-band distortion pedal with a variable crossover, two independent cascaded mosfet overdrive circuits, and a mixer. Low and high frequencies are split by the crossover and sent their own dedicated overdrive circuit. Low and high frequencies do not interfere with each other, and can be dialed in independently. Multi-band distortion is a breakthrough for bass guitar players who want to achieve high levels of gain and distortion, while still retaining a robust low end. All the goodness of bi-amping, built in to a stompbox. The Crossover Distortion retails for $299. To find authorized dealers, please visit www.brimstoneaudio.com Video by David Beers from Brimstone Audio. | ["Bass guitar", "Effects unit", "Music", "Distortion"] | ["amateur recording", "e-bass", "medium tempo", "melodic"] | 6 | 6pHo6fPdPvM | 791 | |
Victor Wooten bass solo & Amazing Grace - Budapest 2007 | This audio contains someone playing a bass solo melody. In the background you can hear something that almost sounds like a dog barking. This song may be playing while listening to a live concert. | 2007-01-26T11:22:22Z | nmhu77 | Budapest A38 Béla Fleck and the Flecktones 22 January 2007 (2nd show) | ["Bass guitar", "Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Bowed string instrument"] | ["amateur recording", "e-bass", "background noises", "funky"] | 6 | LHTA8VZGoMs | 2173 | |
Bass Trip Vol. 1.1 - Wounded Paw Attack Goat, Boss BF-3 Flanger, EHX Nano Holy Grail. | Someone is playing an e-bass with different effects on. Using a finger-tapping technique to play a melody/riff. This song may be playing bass at home. | 2009-11-11T18:27:55Z | Enzo Bardoul | www.ToneFactor.com - This is a demo featuring a little unconventional effect use on bass. The pedals we're using are the Wounded Paw Attack Goat Bass Fuzz, the Boss BF-3 Flanger, and the Electro-Harmonix Nano Holy Grail. For more information on any of these you can visit our site or give us a call @ 1-866-612-TONE . Thanks for watching!! | ["Bass guitar", "Guitar", "Music", "Musical instrument", "Electronica"] | ["amateur recording", "e-bass", "effect-pedals", "melody finger-tapping", "uptempo"] | 6 | zCrpaLEq1VQ | 5463 |
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;