musiccaps_details (view)

1 row where musiccaps_aspects contains "nostalgic", musiccaps_aspects contains "piano chords progression", musiccaps_aspects contains "tinny percussive elements" and musiccaps_aspects contains "tom rolls"

✎ 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
James Last - Happy Music The low quality recording features a big band song that consists of wide reverberant brass section melody, shimmering shakers and cymbals, bells melody, piano chord progression, smooth bass and soft kick hits. There are some tom rolls that represent a transition into the next section. It sounds happy and fun, but it also gives off euphoric and nostalgic vibes, as it sounds vintage. 2009-10-19T14:24:00Z anggip lesmana JAMES LAST didn't burst forth on the popular music scene with a fanfare of trumpets and explosions of fire-work. He just sort of emerged in a quiet cloak of talent. For three years running LAST was voted best bass player in a German jazz poll. But the minute he found out that having an orchestra and being able to experiment with hit songs was much more satisfying and rewarding, JAMES LAST was on the way to becoming a true giant in the world of today popular music. The remarkable abilities as a bass player are only part of his musical talent. He also is an accomplished songwriter, arranger and bandleader. ["Swing music", "Music"] ["low quality", "big band", "wide reverberant brass section melody", "shimmering cymbals", "shimmering shakers", "tinny percussive elements", "tom rolls", "bells melody", "piano chords progression", "smooth bass", "soft kick", "happy", "fun", "nostalgic", "euphoric", "vintage"] 4 VnJeG9RGUVM 3031

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;