musiccaps_details (view)

2 rows where musiccaps_aspects contains "female backing vocals" and musiccaps_author = 2

✎ 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
[NEW] All SNSD Music Videos 2007-2014 (OFFICIAL) The pop music features a female voice singing and being accompanied by other female voices. The drums and bass guitar play a simple and repetitive groove and drive the pulsation of the music. An electric guitar is playing a funky accompaniment. A group of strings play a repetitive melody that ascends in pitch with each repetition. 2014-12-07T18:59:58Z soshistars This is all the Music Videos SNSD has made from 2007 to 2014! Lets hope they make more in the future! Thanks for watching please like, comment, share & SUBSCRIBE! (if you havent already!) New Videos Every week of Kpop girl groups (especially SNSD) and SM boy groups! ["Music", "Dance music", "Happy music"] ["female voice", "female backing vocals", "drums", "bass guitar", "strings", "electric guitar", "pop genreș"] 2 32C6w8V7TX8 435
Say it Again - Don Williams The country music features a male voice singing while being backed by female vocals. The drums play a simple and repeating rhythm and together with the bass guitar drive the pulse of the music. An electric guitar plays short repeating musical phrases that incorporate the slide technique. In the background a group of strings fills the harmony and also provides a melody in the higher register. 2009-12-26T16:37:25Z WhatchaNeed23 Say it Again Don Williams Harmony 1976 ABC Records ["Swing music", "Music"] ["male voice", "female backing vocals", "electric guitar", "drums", "bass guitar", "strings", "slide technique", "country genre"] 2 VJ-dpTx_3Cg 2989

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;