musiccaps_details (view)
2 rows where musiccaps_aspects contains "easygoing", musiccaps_aspects contains "noisy", musiccaps_names contains "Bass guitar" and musiccaps_names contains "Electric guitar"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Maxon BD10 Hybrid Bass Driver Demo by Mike Hermans | The low quality recording features a distorted electric guitar melody with an overdrive pedal on. It sounds cool and easygoing, even though the recording is a bit noisy. | 2015-03-31T20:00:00Z | GodlykeInc | Although the Maxon BD10 is designed specifically for Bass, Mike Hermans really takes it through the paces on both Guitar AND Bass! The BD10 features: -Overdrive designed specifically for Bass Guitar -Designed in cooperation with famous Japanese Bassist Masaki -Symmetrical clipping circuit yields heavy yet articulate distortion -Dedicated Clean Level knob with +6 dB max Boost -Dedicated Drive Level knob with +14 dB max Boost -Dedicated Drive knob to control amount of Distortion -Individual Bass and Treble knobs for precise tonal control -Buffered Bypass Switching For more information check out Maxonfx.com | ["Bass guitar", "Effects unit", "Electric guitar", "Music", "Mandolin", "Distortion"] | ["low quality", "distorted electric guitar melody", "rock playback instrumental", "noisy", "overdrive pedal", "cool", "easygoing"] | 4 | BWVovghBe2c | 1250 | |
Round Midnight - Guitar and acoustic bass guitar | The low quality recording features a smooth buzzy bass guitar and chill, electric guitar melody playing. It is noisy and the stereo image is unbalanced, as the bass guitar is leaning toward the left channel. It sounds easygoing, chill and relaxing. | 2015-03-24T20:19:36Z | Matt Otten | I bought this bass guitar about 2 weeks ago; this is my first recording with it :) starting with a slow tune to get used to the fretless playing, it's a challenge! I have played bass guitar for quite some time, but acoustic and fretless is another thing. | ["Bass guitar", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "smooth buzzy bass guitar", "chill electric guitar melody", "noisy", "unbalanced stereo", "chill", "easygoing", "relaxing"] | 4 | ZmgkpmzvL6c | 3412 |
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;