musiccaps_details (view)

1 row where musiccaps_aspects contains "background cheering", musiccaps_aspects contains "progrock" and musiccaps_names contains "Whoop"

✎ 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
Black Veil Brides- Andy calls out/fights a guy in the crowd 2013 The file contains acoustic drums playing with a lot of crash hits, an e-guitar playing a melody along with male voice singing the same melody. The crowd is cheering and screaming in the background. This is an amateur recording with poor sound-quality. This song may be playing at a live concert. 2013-01-21T02:46:41Z Amanda Norris This guy in the crowd starting fighting a kid who was just trying to mosh, and another person told him to be careful, but the guy just pushed him. Andy saw what was going on and, being known for standing up for himself and his fans, called him out and fought with him while the song(Nobody's Hero) was playing. Andy told the guy to come to the front, and when he goes off stage, he fights with him. I believe they punched each other and Andy hit him with his mic. Odessa, TX at Dos Amigos on January 9, 2013, Church of the wild ones tour. The guy was about Andy's height, if not taller, and a senior in high school, age 18 assumedly. So no, he was not fighting a "little kid." ["Singing", "Music", "Whoop", "Inside, large room or hall", "Inside, public space"] ["progrock", "e-guitar", "male voices singing", "acoustic drums", "background cheering", "slow to medium tempo"] 6 YSrTtw6ku2E 3286

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;