musiccaps_details (view)

1 row where musiccaps_aspects contains "cool", musiccaps_author = 4 and musiccaps_names contains "Chorus effect"

✎ View and edit SQL

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
Visual Sound GarageTone Oil Can Phaser The low quality recording features an arpeggiated electric guitar melody being played with and without phaser pedal effect. It sounds cool and the recording is noisy and in mono. 2010-07-02T17:20:19Z Enzo Bardoul www.tonefactor.com - The new GarageTone Oil Can Phaser from Visual Sound is a classic sounding analog phaser. With both Speed and Depth knobs, the Oil Can Phaser has a wide variety of warm analog tones, from swooshing to pulsating. Placed before distortion or overdrive, the Oil Can is perfect for classic or modern rock, ska, punk, and more. On its own, the GarageTone Oil Can Phaser gives warmth and movement to textured rhythm parts. ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion"] ["low quality", "noisy", "arpeggiated electric guitar", "phaser pedal effect", "cool", "mono"] 4 zSSIGv82318 5478

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;