musiccaps_details (view)

1 row where musiccaps_aspects contains "noisy", musiccaps_aspects contains "shimmering bells melody" and "youtube_published" is on date 2010-08-01

✎ 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
Avenged Sevenfold - Nightmare, Drum Cover, 5 Year Old Drummer, Jonah Rocks The low quality recording features a shimmering bell melody that sounds haunting. There is a metallic impact. The recording sounds very noisy as it was probably recorded with a bad quality microphone. 2010-08-01T22:46:53Z Jonah Rocks For A7X info visit: www.avengedsevenfold.com. Jonah Rocks Avenged Sevenfold - Nightmare. A7X is one of Jonah's fave bands.Click http://www.thrillershop.com/store/product.php?cat_id=22&sub_id=0&pro_id=61 For Jonah Rocks T-Shirts! Jonah would like to Thank these companies for all of their help: Vic Firth Drumsticks- http://www.vicfirth.com/artists/profile/profile.php?id=2756 SJC Custom Drums- http://sjcdrums.com/ Zildjian Cymbals- http://www.zildjian.com/en-US/news/newsDetail.ad2?newsID=1901 DW Pedals, Stands, and Hardware- http://www.dwdrums.com/ Evans Drum Heads - http://www.evansdrumheads.com/ Stoked Custom Thrones - http://www.myspace.com/stokedcustomthrones ALL COPYRIGHTED MATERIAL IS USED UNDER THE GUIDELINES OF "FAIR USE" IN TITLE 17 & 107 OF THE UNITED STATES CODE, AND UNDER ARTICLES 29 & 29.1 OF THE CANADIAN COPYRIGHT ACT. SUCH MATERIAL REMAINS THE PROPERTY OF THE ORIGINAL OWNER OF THE COPYRIGHT, AND IS USED HERE FOR THE PURPOSES OF EDUCATION, COMPARISON, AND CRITICISM ONLY. ["Bell", "Music"] ["low quality", "shimmering bells melody", "metallic impact", "noisy", "haunting"] 4 rLtXML8Y5wo 4869

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;