musiccaps_details (view)

1 row where musiccaps_aspects contains "guitar", musiccaps_aspects contains "moderate tempo", musiccaps_aspects contains "romantic mood" and musiccaps_names contains "Music of Asia"

✎ 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 Best Of Bollywood At The Royal Stag Mirchi Music Awards | Radio Mirchi This bollywood song features a female voice singing the main melody. This is accompanied by a tabla and other percussion playing a staccato beat. A guitar strums chords in staccato following the percussion in the breaks. Another guitar plays arpeggiated chords. A piano plays in the background. The bass walks down playing a descending bassline. The mood of this song is romantic. This song can be played in a romantic movie. 2016-03-13T15:25:38Z Mirchi Plus Watch the rockstars sing the super duper hits at The Royal Stag Mirchi Music Awards. Just wow! Drop in your feedback in the comment box below. For more details, 'Like' us on Facebook: https://www.facebook.com/mirchi983fm 'Follow' us on Twitter: http://twitter.com/mirchi983fm 'Subscribe' to the New Exclusive Murga Channel: http://bit.ly/148F8xe Add us to your circle on Google+: https://plus.google.com/+Mirchi983Fm ["Music of Asia", "Music"] ["bollywood song", "female voice", "guitar", "tabla", "bass", "piano", "romantic mood", "moderate tempo"] 0 n_boIyhZqWc 4557

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;