musiccaps_details (view)
4 rows where musiccaps_aspects contains "live recording" and musiccaps_aspects contains "rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- live recording · 4 ✖
- rock · 4 ✖
- alternative rock 3
- live performance 3
- electric guitar 2
- indie rock 2
- arpeggio 1
- blues rock 1
- calm emo male singer 1
- car sound 1
- cheering fans 1
- crunchy electric guitar chords 1
- dark 1
- electric bass guitar 1
- electric guitar lick 1
- enigmatic male vocalist 1
- intricate electric guitar playing 1
- low quality recording 1
- mysterious 1
- poor audio quality 1
- raspy male rock vocal 1
- rock band 1
- soft electric guitar 1
- tambourine 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ghost Riders in the Sky: Guitar Cover, The Outlaws, Full Song | Here we have a guitarist playing an intricate rock motif on the electric guitar. We hear some rapid plucking of a melody that sounds dark and mysterious. This is a live recording. | 2009-08-25T03:53:36Z | Sam August | Instagram: @samwaugust Follow for more guitar content Venmo: @Sam-August-1 for tips. Thank you! I lost all my gigs due to the Coronavirus outbreak, so this is much appreciated. Feel free to request songs. "Ghost Riders in the Sky" by the Outlaws. This song is absolutely awesome. Been getting a few requests for this one, and it's been too long since I've put up yet another Outlaws song. Originally written by Stan Jones in 1948, it's been covered by many including Johnny Cash, but no other version comes close to this legendary take on the song by the Florida guitar army. There aren't any tabs out there on this version, certainly the solos at least, so of course I did this all by ear, and it's not exactly right in some spots. Yippee-aye-ooo. Enjoy. | ["Tapping (guitar technique)", "Guitar", "Musical instrument", "Plucked string instrument"] | ["live recording", "electric guitar", "intricate electric guitar playing", "rock", "arpeggio", "dark", "mysterious"] | 3 | DV5mynb77JM | 1484 | |
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 | |
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 | |
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;