musiccaps_details (view)
1 row where musiccaps_aspects contains "e-bass", musiccaps_names contains "Bass guitar", musiccaps_names contains "Distortion" 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 |
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;