musiccaps_details (view)

2 rows where musiccaps_aspects contains "big band", musiccaps_author = 2 and musiccaps_names contains "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
Goodbye - Benny Goodman 1980 The jazz music features a clarinet playing a melody that's ending a song. A big band that incorporates a jazz acoustic guitar accompanies the clarinet. The tempo is slow and the style is ballad. The medium quality audio recording leads me to believe this is an older recording. 2008-08-01T22:23:11Z SwingCla "Benny Goodman in Japan 1980" Playlist = http://bit.ly/2wGtUzi / "Aurex Jazz Festival", Sep.3,1980 at Budokan(Tokyo,Japan) / cl:Benny Goodman, p:Teddy Wilson, tp:Tony Terran, tb:Dick Nash, g:Eddie Duran, b:Al Obidinski, dr:John Markham ["Music", "Theremin"] ["clarinet", "strings", "acoustic guitar", "big band", "jazz genre", "slow tempo", "ballad", "ending", "medium quality audio recording"] 2 8GKbDSu9Xd0 908
Tap Fabulous Feet Dance Cincytap The music excerpt features a big band playing. The trumpets play a repeating melody, and thus, stand out the most. Throughout this passage one can hear sounds made by the shoes of tap dancers. The quality of the audio recording is not so good and this leads me to believe it was recorded at a live tap dancing show. 2008-07-17T13:50:54Z Cincy Tap CincyTap.com ["Music", "Tap"] ["tap dancing", "trumpets", "big band", "amateur live recording"] 2 LByEH80c6Eg 2161

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;