musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "shouting" and musiccaps_names contains "Music" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 26 ✖
- shouting · 3 ✖
- acoustic drums 2
- bass guitar 2
- electric guitar 2
- aggressive 1
- chainsaw 1
- chaotic 1
- christian church 1
- crisp synth 1
- crowd chanting 1
- hard rock 1
- hard-hitting 1
- latin dance 1
- latin percussion 1
- live performance 1
- loud 1
- male vocal 1
- male vocals 1
- male voice 1
- pantomime 1
- piano 1
- preaching 1
- religious 1
- salsa 1
- screaming 1
- sensual 1
musiccaps_names (array) 10 ✖
- Music · 3 ✖
- Chainsaw 1
- Drum 1
- Guitar 1
- Heavy metal 1
- Music of Latin America 1
- Musical instrument 1
- Rock music 1
- Salsa music 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
PANTOMIMA "SUENA TU ARPA" - FOSFORITO (LIVE) ANGELES | This is the recording of a preaching session at a Christian church. The preacher is shouting and screaming while the crowd is chanting in accordance. There is an electric guitar and acoustic drums in the backing track that can be barely heard from all the noise. The atmosphere is loud and chaotic. Parts of this piece could be sampled for use in beat-making. | 2009-02-14T03:59:02Z | Noel D | iglesia de dios de kissimmee. live pantomima. song: "angeles" by Fosforito. *angels would come from around the church little by little, so some you can't see in the video. *live music played by youth. *women, youth, and children involved in pantomima. *my dad recorded. *the one in black is my mom =] *i was also an angel, but on the other side. so you can't see me, hahaa... **watch in HIGH QUALITY if you can! =] (much better viewing) | ["Music", "Yell"] | ["pantomime", "preaching", "christian church", "male voice", "shouting", "screaming", "crowd chanting", "electric guitar", "acoustic drums", "religious", "loud", "chaotic"] | 9 | 8hO1S9VIfPY | 935 | |
SALSA NUEVA . "ELLA NO BAILA SOLA" LA ZONA FT EL SANTI RIMANTE | This is a latin dance music piece in the style of salsa. There are male vocals shouting in the lead. There is a crisp synth sound playing the melody with the backing of a piano and a bass guitar. The rhythm is played by the latin percussive elements. There is a sensual atmosphere to this piece. It could be playing in the background at a latin nightclub. | 2013-10-12T16:46:06Z | ADOLFO CT. | SALSA NUEVA 2016 LO MAS NUEVO SALSA SHOKE 2016 LO MAS NUEVO SALSA URBANA 2016 LO MAS NUEVO GRAVADO EN ESTUDIOS INDIRECORDS CALI COLOMBIA. DIRECTOR: GUSTAVO CARDONA SALSATON 2016 LO MAS NUEVO | ["Music", "Music of Latin America", "Salsa music"] | ["latin dance", "salsa", "male vocals", "shouting", "crisp synth", "piano", "bass guitar", "latin percussion", "sensual"] | 9 | K55v5p5DEPE | 2055 | |
Front row! Jackyl 'The Lumberjack Song' live in concert in California! Enjoy! NAMM | This is the live performance of a hard rock piece. There is a male vocal who is shouting at the crowd while revving up a chainsaw. The electric guitar is playing the melody while the bass guitar is playing in the background. The acoustic drums are playing a simple blues rock beat. The atmosphere is aggressive. | 2012-01-23T22:46:42Z | pasha28dio | Filmed at the 'Grove in Anaheim' during NAMM 2012 at the 3rd Annual Dean Guitars Namm Jamm. You just have to love any song that has a chainsaw solo. :-) Testament and Static X also played. Great night of jams. | ["Chainsaw", "Drum", "Guitar", "Heavy metal", "Music", "Musical instrument", "Rock music"] | ["hard rock", "live performance", "male vocal", "shouting", "electric guitar", "bass guitar", "acoustic drums", "chainsaw", "hard-hitting", "aggressive"] | 9 | MQ1Q7xydJPU | 2265 |
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;