musiccaps_details (view)

1 row where musiccaps_aspects contains "echoing male vocal", musiccaps_aspects contains "smooth" and musiccaps_names contains "Swing music"

✎ 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
Robbie Williams ft. Rufus Wainwright | Swing Both Ways (Official Audio) The Swing song features an echoing male vocal singing over smooth double bass, offbeat soft piano chords and widely spread sustained strings melody. It sounds easygoing, relaxing, smooth, warm and euphoric as it reminds of Christmas. 2013-11-18T09:21:38Z Robbie Williams Connect with Robbie Williams: Website – https://RobbieWilliams.com Newsletter – https://RobbieWilliams.lnk.to/signupID Official Robbie Williams App – https://RobbieWilliams.lnk.to/appID Apple Music – https://RobbieWilliams.lnk.to/AppleMusicID Spotify – https://RobbieWilliams.lnk.to/SpotifyID Facebook – https://www.facebook.com/robbiewilliams Instagram – https://www.instagram.com/robbiewilliams Twitter – https://twitter.com/robbiewilliams ["Swing music", "Music"] ["swing", "smooth double bass", "offbeat sot piano chords", "wide sustained string melody", "echoing male vocal", "easygoing", "relaxing", "smooth", "euphoric", "warm"] 4 L1s7KZgWXGc 2145

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;