musiccaps_details (view)

2 rows where musiccaps_aspects contains "soft snare hits", musiccaps_author = 4 and musiccaps_names contains "Singing"

✎ 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
The Music City Soul Brothers - let our love go on (Music City) The low quality recording features harmonizing mixed vocals singing over groovy bass, shimmering cymbals, soft snare hits, funky guitar melody and bright brass melody. The recording is very noisy, in mono, with some crackles in it and it sounds funky and addictive - thanks to those vocals. Sounds like something you would hear in clubs during the 60s and 70s. 2014-01-27T18:37:44Z Alex Rural Soul this song remind me the impressions Hit "it's allright"..i love this style of mid tempo soul ... for first time on youtube!!!! ["Singing", "Swing music", "Music", "Psychedelic rock", "Rock and roll"] ["funk/soul", "low quality", "harmonizing mixed vocals", "groovy bass", "shimmering cymbals", "soft snare hits", "bright brass melody", "funky guitar melody", "funky", "noisy", "crackles", "addictive", "mono"] 4 ZsmfIMEzrQs 3422
Famous paintings of wedding and marriage (Music: I dream of you/Sha la la love song) The ballad song features a mellow female vocal singing over a mellow organ keys melody, groovy hi hats, soft snare and kick hits and smooth bass. It sounds emotional, heartfelt and romantic - like something you would hear at a wedding. 2011-05-05T16:33:05Z isisip Famous paintings of wedding and marriage in the history of art. Artists include: John Henry Frederick Bacon, Tuxen Laurits, Pierre-Auguste Renoir, Firs Sergeevich Zhuravlev, Edmund Blair Leighton, Harrison Fisher. If you are interested in knowing the titles of the paintings, please visit http://weddingdressmarriage.blogspot.com/ Song: I dream of you Words and Music by: Isisip Performed by :Isisip (C) 2008-2011 Isisip MP3 available at http://www.pianomusicdownload.blogspot.com See also: Sad beauty piano solo in 3 keys https://www.youtube.com/watch?v=IE95p3edfIg Top 10 piano songs https://www.youtube.com/watch?v=fKxmSe5s9_s Piano music playlist https://www.youtube.com/watch?v=K0mXJ-QYIRw The unfinished story piano performance https://www.youtube.com/watch?v=N06aA_vjZPA Moonlight piano performance https://www.youtube.com/watch?v=NFcPR5WgeQA Sad beauty piano performance https://www.youtube.com/watch?v=DgbdWyTtWco Ask the sky without words piano performance https://www.youtube.com/watch?v=EnJSIOaPxp0 Please buy the music or make a donation: http://pianodiscography.blogspot.com Sheet music: http://isisippianosheetmusic.blogspot.com ["Singing", "Music of Asia", "Music", "Wedding music", "Song", "Classical music"] ["ballad", "mellow organ keys melody", "groovy hi hats", "soft kick hits", "soft snare hits", "smooth bass", "mellow female vocal", "emotional", "heartfelt", "romantic"] 4 g0scnRzoo9M 4003

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;