musiccaps_details (view)

4 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "jazz" and musiccaps_aspects contains "soulful"

✎ 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
Fender Rhodes Mark VII The low quality recording features a live performance of a jazz song and it consists of a saxophone solo melody played over mellow keys chords, groovy bass, punchy snare and kick hits and shimmering hi hats. It sounds passionate and soulful. 2007-01-29T02:12:06Z alex.rodrigues Namm Show report on New Rhodes MK 7 http://www.rhodespiano.com/namm_info.htm ["Jazz", "Music", "Keyboard (musical)", "Piano"] ["low quality", "jazz", "live performance", "saxophone solo melody", "shimmering hi hats", "punchy kick", "punchy snare", "mellow keys chords", "groovy bass", "passionate", "soulful"] 4 Oe_xSG_ic-c 2455
Shirley King - Let The Good Times Roll The low quality recording features a live performance of a jazz song and it consists of a passionate female vocalist singing over groovy piano melody, saxophone melody, groovy bass, shimmering hi hats, punchy snare and soft kick hits. It sounds passionate, soulful and the recording is noisy and in mono. 2008-11-26T05:14:33Z Bob .Hampton Daughter of the Blues Shirley King on B.B King's "Let The Good Times Roll". Performed at the VFW in Berwyn, IL at a benefit for Big Time Sarah's church ["Blues", "Singing", "Jazz", "Music", "Harmonic"] ["low quality", "live performance", "passionate female vocal", "groovy piano melody", "saxophone melody", "groovy bass", "shimmering hi hats", "punchy snare", "soft kick hits", "jazz", "passionate", "soulful", "noisy", "mono"] 4 mFcHGbnNtSQ 4456
Blessed Relief - Frank Zappa The Jazz song features a saxophone solo melody playing over shimmering hi hats, groovy bass and shimmering bells melody. It sounds passionate, soft, mellow and soulful. 2007-09-16T15:33:59Z zemoraes000 A Tribute to Frank Zappa - Blessed Relief, one of the best songs composed by him. I took the video from "trance fusion - Chunga's Revenge" (author unknown). Awsome!!! see also: http://br.youtube.com/watch?v=smSfnpCZMeI hehehe ["Harmonica", "Wind instrument, woodwind instrument"] ["jazz", "groovy bass", "shimmering bells melody", "saxophone solo melody", "shimmering hi hats", "mellow", "soft", "passionate", "soulful"] 4 sSavMIH-e-w 4951
Tony on Tenor Sax The low quality recording features a live performance of a jazz song that consists of a tenor sax solo melody playing over mellow piano chords, sustained strings, groovy bass, snappy rimshots, shimmering hi hats and punchy kicks. It sounds emotional, passionate and soulful. 2008-01-24T22:22:32Z Tony Bolivar Because of Who You Are ["Brass instrument", "Jazz", "Music", "Musical instrument", "Wedding music", "Saxophone"] ["low quality", "live performance", "jazz", "tenor sax solo melody", "groovy bass", "mellow piano chords", "shimmering hi hats", "punchy kick", "snappy rimshots", "sustained strings", "passionate", "emotional", "soulful"] 4 tuoBmxts5Xo 5075

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;