musiccaps_details (view)
6 rows where musiccaps_aspects contains "alternative rock" and musiccaps_aspects contains "live performance"
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- alternative rock · 6 ✖
- live performance · 6 ✖
- rock 5
- live recording 3
- electric guitar 2
- indie rock 2
- slow tempo 2
- acoustic drums 1
- acoustic guitar accompaniment 1
- alternative metal 1
- ambient sounds 1
- auditorium acoustics 1
- bass guitar 1
- blues rock 1
- calm emo male singer 1
- car sound 1
- cheering fans 1
- chilled song 1
- crunchy electric guitar chords 1
- drowsy singing 1
- echo vocals 1
- electric bass guitar 1
- electric guitar lick 1
- electric guitar sustain 1
- emotional 1
- enigmatic male vocalist 1
- indie 1
- keyboard 1
- love song 1
- low quality recording 1
- male vocal 1
- male vocalist 1
- medium tempo 1
- melancholic 1
- minimalist 1
- organ sound 1
- passionate 1
- poor audio quality 1
- raspy male rock vocal 1
- repeated theme 1
- reverb 1
- rock band 1
- romantic 1
- sentimental 1
- simple rock drumming 1
- soft electric guitar 1
- tambourine 1
- warm magnetic male vocal 1
musiccaps_names (array) 11 ✖
- Music 6
- Psychedelic rock 4
- Rock music 4
- Punk rock 2
- Blues 1
- Drum kit 1
- Grunge 1
- Musical instrument 1
- Rock and roll 1
- Shout 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Breaking Benjamin Burnley GIVE ME A SIGN House of Blues Atlantic City, NJ 7/10/10 | A male vocalist sings this passionate song. The tempo is slow with emphatic vocals and an acoustic guitar accompaniment. The song is melodic, emotional,sentimental, passionate,pensive, reflective and deep. This song is Alternative Rock. | 2010-07-11T17:28:56Z | Christopher Kline | Ben Burnley of Breaking Benjamin performed a solo acoustic show at The House of Blues in Atlantic City, NJ on July 10th. Joining him onstage playing guitar and providing backup vocals was Aaron Bruch of Ourafter. | ["Blues", "Music"] | ["male vocalist", "medium tempo", "rock", "alternative rock", "alternative metal", "acoustic guitar accompaniment", "minimalist", "live performance", "ambient sounds", "auditorium acoustics", "romantic", "love song", "passionate", "emotional", "sentimental"] | 7 | 9ogEGxsJcSY | 1043 | |
Pink Noise : Beverley Westwood | This is a quintessential indie garage rock band. The singer is calm and sings with a sort of haunting demeanor typical of this style. It's a live recording and the audio is of low quality. The singer goes off-pitch at one point. | 2006-05-29T09:55:00Z | Nick Clay | Recorded live at the famous Adelphi in Hull. http://www.nickclay.karoo.net/pinknoise.htm | ["Music", "Punk rock", "Psychedelic rock", "Rock music", "Grunge"] | ["rock", "alternative rock", "indie rock", "live recording", "low quality recording", "live performance", "rock band", "electric guitar", "electric bass guitar", "calm emo male singer"] | 3 | ORt8LSgn-uA | 2441 | |
Black Rebel Motorcycle Club - Howl | This is a live performance of an alternative rock music piece. There is a male vocalist singing in a drowsy manner in the lead. The main tune is being played by a keyboard with an organ sound meanwhile the electric guitar and the bass guitar are supporting it in the background. The rhythm is being provided by a slow tempo acoustic drum beat. The atmosphere is melancholic. This piece can be used in the soundtrack of a drama TV series, especially during the scenes where a character feels like they are depressed. | 2007-06-12T18:16:10Z | Pinkertonoise | "Howl" live in Portland, for MSN Music | ["Music", "Psychedelic rock", "Rock music"] | ["live performance", "alternative rock", "indie", "male vocal", "drowsy singing", "keyboard", "organ sound", "electric guitar", "bass guitar", "acoustic drums", "melancholic", "repeated theme", "slow tempo"] | 9 | PdgswSjYhMw | 2550 | |
Dr. Rockzo. "I'm a Rock n Roll Clown" | This is a recording of a live show performance by a rock band. We hear some cheering fans and then the song starts with an electric guitar lick and a bass guitar, and a kick on the drums. The audio quality is muffled and poor. | 2009-04-11T20:25:15Z | starz7007 | Brenden Small and the School of Rock all stars at the Starland Ballroom. 4-4-09. Dr. Rockzo. "I'm a Rock n Roll Clown" from metalocalypse | ["Drum kit", "Music", "Musical instrument", "Rock music", "Shout", "Rock and roll", "Speech"] | ["live recording", "cheering fans", "live performance", "rock", "poor audio quality", "electric guitar lick", "alternative rock", "blues rock"] | 3 | XHczpbtBhk4 | 3171 | |
The Gaslight Anthem - Even Cowgirls Get the Blues - Live on Fearless Music | This song has a cool vibe to it. The singer has a warm and suave tone to his voice and vocal delivery. This is an alternative rock song, with a slow tempo. It gives off a cool and aloof vibe. There's reverb and echo on the singer's vocal. | 2009-01-21T18:11:12Z | fearlessmusicshow | The Gaslight Anthem performs "Even Cowgirls Get the Blues" live on Fearless Music in NYC. http://www.fearlessmusic.com http://twitter.com/FearlessMusicTV Watch in HD here: http://www.youtube.com/watch?v=RB9wLbvXRlo | ["Music", "Psychedelic rock", "Rock music"] | ["alternative rock", "rock", "live performance", "reverb", "echo vocals", "warm magnetic male vocal", "electric guitar sustain", "simple rock drumming", "slow tempo", "chilled song"] | 3 | dw4YwJppiec | 3827 | |
Black Cab Sessions Binocular by The Family Rain | The recording is done live, in a moving vehicle. The vehicle sound is heard. There is a tambourine for percussion, a crunchy electric guitar being played as the melodic instrument, and the singer has an enigmatic and charming style. The song is an alternative rock song that feels positive and magnetic. | 2013-08-24T23:34:38Z | ChocolateCerebral | ["Music", "Punk rock", "Psychedelic rock"] | ["live performance", "car sound", "tambourine", "raspy male rock vocal", "rock", "alternative rock", "indie rock", "live recording", "soft electric guitar", "crunchy electric guitar chords", "enigmatic male vocalist"] | 3 | uPGasFKZSBo | 5110 |
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;