musiccaps_details (view)

1 row where musiccaps_aspects contains "energetic drums", musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "indie rock" and musiccaps_aspects contains "uplifting"

✎ 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
"Nashville Indie Music Rocks" [Nokia - Sundance London Film Festival Entry by Russb] The low quality recording features an indie rock song that consists of passionate female vocal singing over energetic drums, electric guitar solo melody and groovy bass, over which there is a flat, nasal and muffled male vocal narrating. The song sounds energetic and uplifting. 2013-03-21T09:15:50Z Joy Collins Music DOWNLOAD Great Indie Music @ http://bit.ly/iTunesJoyCollins Visit http://countrymusicsongs.co Go TO http://bit.ly/NashvilleIndieMusicDocumentary AND Click The "SUPPORT RUSS" Button for the http://facebook.com/NokiaMusic #NokiaXSundanceLDN #Lumia920 Music Contest. Our documentary is about the extremely talented, diverse, Nashville Independent Music Scene. Please share this with all of your friends and help us take our documentary to the upcoming Sundance Film Festival in London. Stop by http://twitter.com/NokiaMusic and let them know that you support The Indie Music Scene in Nashville and would like to see our city chosen as a participant! Thanks and PLEASE SHARE and COMMENT!! Nashville Independent Music Rocks! For collaborations and business inquiries, please contact via Channel Pages: http://ChannelPages.com/CountryMusicSongs4u ["Music", "Independent music", "Speech"] ["low quality", "flat male vocal", "indie rock", "passionate female vocal", "energetic drums", "electric guitar solo melody", "groovy bass guitar", "energetic", "uplifting", "muffled", "nasal"] 4 CKO35LsM0XI 1352

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;