musiccaps_details (view)
3 rows where musiccaps_aspects contains "alternative rock" and musiccaps_aspects contains "reverb"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- alternative rock · 3 ✖
- reverb · 3 ✖
- bass rumbling 1
- chilled song 1
- clean sound 1
- cover 1
- distorted audio 1
- dreamy 1
- echo vocals 1
- electric guitar 1
- electric guitar sustain 1
- fuzzy audio 1
- gentle playing 1
- hazy 1
- indie male vocalist 1
- indie rock 1
- live performance 1
- live recording 1
- low quality audio 1
- rock 1
- simple rock drumming 1
- slow tempo 1
- upbeat 1
- warm magnetic male vocal 1
musiccaps_names (array) 11 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Peter, Bjorn & John - "Young Folks" @ Laneway Festival 2007 | This is a recording of a live indie rock performance. The recording is distorted and of a low quality. There are two male singers singing in an indie style with a lot of reverb applied to their vocals. The bass is rumbling and low and constant. | 2007-03-04T14:57:51Z | onelinergirl | With special guest - Traceyanne Campbell of Camera Obscura - 2nd annual Laneway Festival, Circular Quay, Sydney, Sunday March 4, 2007 | ["Singing", "Music", "Rock music", "Roll", "Rock and roll"] | ["live recording", "indie rock", "alternative rock", "upbeat", "low quality audio", "fuzzy audio", "distorted audio", "indie male vocalist", "reverb", "bass rumbling"] | 3 | 9JlifkCmUOk | 993 | |
Supper Moment - 幸福之歌 guitar 結他 cover by Eric Lo | This is a cover of an alternative rock music piece. There is an electric guitar with a clean sound and a lot of reverb playing a gentle arpeggio. The atmosphere is dreamy and hazy. This piece could be used in the background of a tutorial video. | 2015-06-07T07:58:15Z | Eric Lo Guitar | My tabs : https://www.mymusicsheet.com/ericmusic1437/23233 Buy all my other tabs :https://www.mymusicsheet.com/ericmusic1437/ Guitar lesson / Buy my tabs / tab arrangement request : https://ericmusic1437.wixsite.com/guitar Homepage: https://ericmusic1437.wixsite.com/guitar My Tabs : https://www.mymusicsheet.com/ericmusic1437 Facebook Fanspage : https://www.facebook.com/ericlomusic Personal Facebook: http://www.facebook.com/ericmusic1437 Youtube: http://www.youtube.com/user/ericmusic1437 Ig: https://www.instagram.com/ericmusic1437/ E-mail: ericmusic1437@gmail.com Wtsapp : 852-98633697 Contact details : Mobile : 852-98633697 ( welcome whatsapp ) E-mail : ericmusic1437@gmail.com | ["Guitar", "Music", "Musical instrument", "Harmonic", "Plucked string instrument", "Inside, small room"] | ["cover", "alternative rock", "electric guitar", "clean sound", "reverb", "gentle playing", "dreamy", "hazy"] | 9 | MS8VU468rKk | 2268 | |
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 |
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;