musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "e-guitar", musiccaps_aspects contains "male voices singing" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- acoustic drums 2
- e-guitar · 2 ✖
- male voices singing · 2 ✖
- amateur recording 1
- background cheering 1
- e-bass 1
- electric piano 1
- fast tempo 1
- progrock 1
- skarock 1
- slow to medium tempo 1
- uplifting mood 1
musiccaps_names (array) 6 ✖
- Music 2
- Singing · 2 ✖
- Inside, large room or hall 1
- Inside, public space 1
- Ska 1
- Whoop 1
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 | |
Tokyo Ska Paradise Orchestra Live - Ska Me Crazy | An e-bass is playing a bluesy bassline along with acoustic drums with a slightly open hihat. An electric piano/organ is playing one short chord as a rhythmic element adding reggae vibes along with a e-guitar strumming fast chords on the offbeat. The guitar is running through a chorus effect. The male voices are singing a simple melody. This song may be playing at a live concert before a sports-event. | 2007-01-16T11:24:03Z | SkaRebel | SKA SKA SKA!!! | ["Singing", "Music", "Ska"] | ["skarock", "acoustic drums", "e-bass", "electric piano", "e-guitar", "male voices singing", "amateur recording", "fast tempo", "uplifting mood"] | 6 | rJZgUpzqAyY | 4864 |
Advanced export
JSON shape: default, array, newline-delimited
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;