musiccaps_details (view)
2 rows where musiccaps_names contains "Bass guitar", musiccaps_names contains "Effects unit", musiccaps_names contains "Music" and musiccaps_names contains "Tapping (guitar technique)"
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 |
---|---|---|---|---|---|---|---|---|---|---|
DiMarzio Crunch Lab and LiquiFire Drive Sound Test (check up with an Ibanez S570B) | This music is an electric guitar instrumental Rock. The tempo is medium with an electric guitar lead. The music is loud and boomy with an intense riff. The audio quality is inferior so the sound is muffled and muddy. The music however is energetic, youthful, spirited and enthusiastic. | 2010-12-17T12:36:42Z | darkcashyz | ["Bass guitar", "Tapping (guitar technique)", "Effects unit", "Electric guitar", "Heavy metal", "Music", "Distortion"] | ["instrumental", "amplified guitar", "youthful", "spirited", "sonic power", "enthusiastic", "muddy", "muffled sound", "medium tempo", "loud electric guitar feedback", "vigorous", "poor audio quality", "boomy", "electric guitar lead", "string instrument", "rock", "metal", "hard rock", "youthful", "enthusiastic", "muddled audio", "home recording"] | 7 | 6ayVxYbKBe0 | 769 | ||
WOJTEK PILICHOWSKI - BASS CHORUS | The low quality recording features a groovy bass guitar playing with guitar pedal chorus effect. In the first half of the loop, there is a modulated chorus effect, while in the second part, there is a classic chorus effect on. | 2015-12-14T11:00:02Z | BassTheWorld.com | Wojtek Pilichowski gives the new Taurus Vechoor Mark II bass chorus a test drive. Find out more about this pedal: http://www.taurus-amp.pl/guitar/effects/white-line/vechoor.html Taurus on Facebook: https://www.facebook.com/TaurusAmplification Thanks for watching! :) Gregor Fris - BassTheWorld.com http://www.facebook.com/basstheworldcom http://www.youtube.com/user/basstheworldbyvideo http://instagram.com/basstheworld http://twitter.com/basstheworldcom | ["Bass guitar", "Tapping (guitar technique)", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "noisy", "groovy bass guitar", "guitar pedal chorus effect"] | 4 | hUcuXIvDN2E | 4111 |
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;