musiccaps_details (view)
3 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "e-guitars" and musiccaps_aspects contains "male voice singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- amateur recording · 3 ✖
- e-guitars · 3 ✖
- male voice singing · 3 ✖
- acoustic drums 2
- e-bass 2
- uptempo 2
- acoustic/digital drums 1
- alternative7rock 1
- background cheering 1
- hammond organ 1
- hands clapping 1
- indirock 1
- medium tempo 1
- rock 1
musiccaps_names (array) 12 ✖
- Music 3
- Exciting music 1
- Guitar 1
- Progressive rock 1
- Punk rock 1
- Rock and roll 1
- Rock music 1
- Roll 1
- Singing 1
- Ska 1
- Song 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Slash not happy with guitar tech Camp Freddy 12- | An acoustic drum and a bass are repeating the same pattern along with two e-guitars playing along with the melody while a male voice sings slightly soulful and loud. In the background a crowd is sheering. The recording is of very poor audio quality. This song may be playing at a live concert. | 2013-12-24T22:43:09Z | jwalker1200 | Camp Freddy at The Roxy Hollywood,ca. Slash comes out to perform "Schools Out" discovers that his guitar is out of tune! | ["Singing", "Guitar", "Music", "Roll", "Rock and roll"] | ["alternative7rock", "e-guitars", "e-bass", "acoustic drums", "background cheering", "male voice singing", "amateur recording", "uptempo"] | 6 | 1MwaXCfUvX8 | 263 | |
The Haunted - Pourquoi (60's Garage Punk) | A e-guitar takes the lead melody along with the hammond organ. The drums and the bass are providing a rock groove in the background. Another e-guitar is playing along with the bass on the lower notes, it's highly distorted and has some overdrive on it. The male singer streams and sings. His voice is full of reverb and delay. The whole recording is of poor quality. This song may be playing at an old bar. | 2010-10-05T23:32:54Z | heavenlyblueorange | The Haunted - Pourquoi (cover of Music Machine's Talk Talk in French) Montreal, Canada | ["Swing music", "Music", "Punk rock", "Ska", "Song"] | ["indirock", "hammond organ", "e-guitars", "male voice singing", "acoustic drums", "amateur recording", "medium tempo"] | 6 | CRDDdjDinYc | 1364 | |
Friends - Dragon Sound from Miami Connection - Live Music at Fantastic Fest 2012 | This song contains a digital/acoustic drum holding a simple groove with an e-bass while two distorted e-guitars are playing a melody with one being the lead. A male voice is singing in a higher register while you can hear hand clapping to the rhythm. This is an amateur recording and in poor audio-quality. This song may be playing at a live concert. | 2012-09-25T22:59:59Z | Angus Swantee | Dragon Sound, from the movie "Miami Connection" blew the roof off at the Highball bar during Fantastic Fest 2012. Enjoy getting your mind blown! Friends forever! Band members: Y.K. Kim as Mark - rhythm guitarist of Dragon Sound Joseph Diamond as Jack - drummer of Dragon Sound Maurice Smith as Jim - keyboardist of Dragon Sound Angelo Janotti as Tom - lead guitarist/vocalist of Dragon Sound Vincent Hirsch as John - bass guitarist of Dragon Sound | ["Music", "Rock music", "Progressive rock", "Exciting music"] | ["rock", "amateur recording", "e-guitars", "e-bass", "acoustic/digital drums", "hands clapping", "male voice singing", "uptempo"] | 6 | XjrVSk0_4vc | 3218 |
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;