musiccaps_details (view)

2 rows where musiccaps_aspects contains "jazz", musiccaps_aspects contains "shimmering hi hats" and musiccaps_aspects contains "smooth double bass"

✎ 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
Lullaby of Birdland - Shearing & Weiss - Nasiya Alzhanova The low quality recording features a live performance of a jazz song and it features a passionate female vocal singing over shimmering hi hats, groovy piano chords and smooth double bass. The recording has some audio crackles and that would be the only reason for it to go under the "low quality" category. It sounds emotional, passionate and groovy. 2014-07-17T20:13:49Z accademiadelsuono Nasiya Alzhanova is a Modern Music Singing Course student. Nasiya studies Singing with Leyla Tommasi. Nasiya Alzhanova è iscritta al Corso di Canto Moderno. Nasiya studia canto con Leyla Tommasi. ["Music", "Lullaby"] ["low quality", "jazz", "passionate female vocal", "groovy piano chords", "smooth double bass", "shimmering hi hats", "audio crackles", "live performance", "emotional", "passionate", "groovy"] 4 ETl0hYRlVmg 1562
BOBBY HACKETT THE GREATEST CORNETIST The low quality recording features a jazz song that consists of a passionate trumpet melody in the left channel of the stereo image and mellow piano chords in the right channel, followed by smooth double bass and shimmering hi hats. It sounds soft, mellow, passionate and relaxing. The recording is a bit noisy. 2009-02-20T18:31:54Z TheMurphyFamily Bobby Hackett, the cornetist whose mellow tone and graceful style made him a favorite of both jazz and pop music audiences. Whitney Balliett described Bobby Hackett in The New Yorker as "a unique and extremely successful alloy of Beiderbecke and Armstrong." "His tone." Mr. Balliett wrote "which is quiet and shining, resembles Beiderbecke's and so does his three-steps-up, two steps down method of improvising. But his sustained notes and way of playing just behind the beat and of occasionally slipping into double time are straight out of Louis Armstrong." Born in Providence, R.I. Bobby Hackett began his music career by studying the violin but switched to the trumpet and later to the cornet. He began playing professionally while in his teens and was soon appearing with some of the best known names of the "Big Band Era." Bobby Hackett appeared with Benny Goodman, Louis Armstrong, Glenn Miller and Paul Whiteman among others. "Music should be pretty," he said. "You should hear and recognize the melody. And real greatness is in the simplicity. Simple things are the hardest to play and the easiest to listen to." ["Brass instrument", "Saxophone"] ["low quality", "noisy", "jazz", "passionate trumpet melody", "shimmering hi hats", "mellow piano chords", "smooth double bass", "soft", "mellow", "passionate", "relaxing"] 4 TIAj-fi_R7c 2828

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;