musiccaps_details (view)

2 rows where musiccaps_aspects contains "slow tempo", musiccaps_author = 9 and musiccaps_names contains "Soul music"

✎ 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
Whitney Houston- You'll never stand alone This is an R&B/soul music piece. There is a female vocalist singing melodically while another female vocalist is singing the backing melody. The keyboard is playing the main tune. There is a bass guitar playing in the background. The rhythm is provided by a ballad-type slow tempo acoustic drum beat. The atmosphere is sentimental. This piece could be used in the soundtrack of a drama movie, especially during the scenes of a reunion or a homecoming after a long period of separation. 2008-06-02T10:06:16Z MichaelowkaMJJ Whitney Houston- You'll never stand alone with Bobbi Krisstina. Her daughter. My video. And I forget soft in 2:16. Sorry. ["Singing", "Soul music"] ["r&b", "soul", "female vocal", "melodic singing", "female back vocal", "keyboard", "bass guitar", "acoustic drums", "slow tempo", "sentimental"] 9 Bd9TjPP31U0 1267
Bob Marley - Stir It Up subtitulado This is a rocksteady/proto-reggae music piece. There is a male vocalist singing in a relaxed manner. The electric guitar and the bass guitar is playing a groovy melody while occasional synth sounds from the keyboard can be heard. The rhythmic background consists of a slow tempo reggae acoustic drum beat. The atmosphere is chill. This piece could be used in the soundtrack of a summertime movie taking place on a tropical island. 2012-03-02T22:47:34Z Sebas cuba Bob Marley - Stir It Up subtitulado ["Music", "Soul music"] ["rocksteady", "proto-reggae", "male vocal", "relaxed singing", "jamaican", "electric guitar", "bass guitar", "keyboard", "acoustic drums", "chill", "trippy", "groovy", "tropical", "slow tempo"] 9 pSt8NwXyDlg 4711

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;