musiccaps_details (view)
3 rows where musiccaps_names contains "Inside, large room or hall" and musiccaps_names contains "Whoop" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- acoustic drums 1
- acoustic guitar 1
- adventurous 1
- ambient crowd noises 1
- background cheering 1
- bad audio quality 1
- diva 1
- e-guitar 1
- electric rhythm guitar playing 1
- exciting 1
- female backing voice 1
- female guitarist 1
- guitar solo 1
- hard rock 1
- home video 1
- instrumental music 1
- live concert video 1
- live performance 1
- loud cheering and clapping 1
- male voice rapping 1
- male voices singing 1
- medium fast tempo 1
- medium fats tempo 1
- people cheering 1
- people screaming 1
- percussive bass line 1
- poor audio recording 1
- positive vibe 1
- progrock 1
- rock band 1
- rock drumming 1
- rock guitar solo 1
- singer-songwriter/rap 1
- slow to medium tempo 1
- testosterone driven 1
- uptempo 1
- youthful 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 | |
Orianthi - Guitar Solo [singfest 3/8/10] | The song is an instrumental. The tempo is medium fast with a strong guitar lead, rock drumming rhythm, percussive bass line and an electric guitar strumming rhythm. The song is high on adrenaline and exciting. The audio quality is very bad with ambient crowd screaming noises. | 2010-08-05T15:37:54Z | Zahara Sulaiman | Orianthi performance during singfest in Singapore. | ["Guitar", "Music", "Pop music", "Whoop", "Yell", "Inside, large room or hall"] | ["live performance", "ambient crowd noises", "medium fast tempo", "live concert video", "home video", "poor audio recording", "testosterone driven", "female guitarist", "exciting", "youthful", "diva", "rock guitar solo", "adventurous", "people screaming", "guitar solo", "rock band", "instrumental music", "people cheering", "bad audio quality", "hard rock", "rock band", "medium fats tempo", "rock drumming", "percussive bass line", "electric rhythm guitar playing"] | 1 | G8iTuTi8ywU | 1694 | |
Room39 - Mixed Song @ FAT Fest 10 | An acoustic guitar is strumming chords along with a male voice rapping that gets backing vocals from a female voice for a moment. A lot of people are clapping and cheering. This song may be playing at a live concert. | 2010-11-07T17:27:20Z | KaitoGallery | from iPhone upload by http://www.entertainstation.com | ["Singing", "Music", "Whoop", "Yell", "Inside, large room or hall"] | ["singer-songwriter/rap", "acoustic guitar", "male voice rapping", "loud cheering and clapping", "female backing voice", "uptempo", "positive vibe"] | 6 | sOSU7p9pLjs | 4946 |
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;