musiccaps_details (view)

2 rows where musiccaps_aspects contains "ambient", musiccaps_aspects contains "improvisation", musiccaps_aspects contains "medium tempo" and musiccaps_author = 7

✎ 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
Mimi Jones Band Live @ Smalls: Fast Lane This music is a Jazz instrumental. The tempo is medium with a groovy bass one, smooth harmony on acoustic guitar and rim shots.The music is smooth, lively, informal, chill, ambient and atmospheric with the sound of musicians talking to each other. 2010-10-01T16:24:53Z Mimi Jones Mimi Jones, bass; Sean Harkness, guitar; Miki Hayama, piano; Chris Eddleton, drums; Sam Newsome, soprano sax ["Wood block", "Percussion"] ["instrumental", "medium tempo", "jazz", "contemporary jazz", "call and response", "irregular beats", "solos", "rim shot", "complex harmony", "syncopation", "groovy bass line", "amplified guitar harmony", "polyrhythms", "ambient", "atmospheric", "improvisation", "lively", "energetic", "spirited", "active", "informal", "smooth", "polished", "empahtic"] 7 WK-gdfCurCg 3085
Robert Glasper Experiment - Gonna Be Alright (F.T.B.) [feat. Ledisi] A male vocalist sings this Jazz melody. The tempo is medium with a jazz style piano and drumming, groovy bass line, tambourine beats and vocal backup. The harmony is syncopated and complex. It is ambient, atmospheric, punchy, emphatic and enjoyable. 2012-02-28T08:08:40Z meandoughgreen Album: Black Radio (2012). ["Soul music"] ["male vocalist", "medium tempo", "jazz", "jazz piano", "jazz drumming", "groovy bass line", "vocal backup", "syncopated harmony", "complex chords", "improvisation", "deliberate dissonance", "tambourine beats", "blue notes", "polyrhythms", "ambient", "atmospheric", "emphatic"] 7 nlWXsfjHeA8 4574

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;