musiccaps_details (view)
3 rows where musiccaps_aspects contains "amateur recording" and musiccaps_names contains "Progressive rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- amateur recording · 3 ✖
- e-bass 2
- acoustic drums 1
- acoustic/digital drums 1
- blues guitar 1
- e-guitars 1
- e-piano 1
- funkrock 1
- guitar fills 1
- hands clapping 1
- instrumental song 1
- male voice singing 1
- medium to uptempo 1
- minimal instruments 1
- moderate tempo 1
- no voice 1
- rock 1
- suspenseful mood 1
- tambourine backing 1
- uptempo 1
musiccaps_names (array) 9 ✖
- Music 3
- Progressive rock · 3 ✖
- Rock music 3
- Exciting music 1
- Grunge 1
- Heavy metal 1
- Psychedelic rock 1
- Punk rock 1
- Ska 1
youtube_published (date) 3 ✖
- 2008-11-18 1
- 2011-08-28 1
- 2012-09-25 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
70's psycho jazz funk prog rock power trio | An acoustic drum is playing a funky groove with a crash hit while an e-bass with an effect on it is playing a melody along with an e-piano playing the same. Both are playing in the mid -range. This song may be playing practice for a concert with your band. | 2011-08-28T16:18:15Z | Vegan Man | Tune is called "Thru The Zig Zag Gate" from the band, "Backdoor". This cut is from their 4th record called, "Activate". Members are: Colin Hodgkinson, bassist and frontman Ron Aspery (deceased) - sax Adrian Tilbrook - drums I have not been able to find this on CD. | ["Music", "Rock music", "Ska", "Progressive rock"] | ["funkrock", "e-bass", "e-piano", "acoustic drums", "medium to uptempo", "amateur recording"] | 6 | OII3VJoE0WA | 2425 | |
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 | |
Two Pin Din - Screaming Blue Murder live - Nov 15th, 2008 | This amateur recording features two guitars being played. One guitar is playing a blues rhythm. The other guitar is strumming the main chord once and then playing fills on the higher register. This is accompanied by a tambourine as the percussion. There are no voices in this song. This is an instrumental blues rock song. The mood of this song is suspenseful. This song can be used in a detective movie. | 2008-11-18T20:01:48Z | twopindin | When in doubt, follow the advice of Nick Lowe. Namely, "bash it out then tart it up later". Where's Deja Voodoo when you need them? Yet another song offered up off of Two Pin Din's oh-so-fab-you-just-don't-know-it-yet album "In Case Of Fire Break Glass". | ["Heavy metal", "Music", "Punk rock", "Psychedelic rock", "Rock music", "Progressive rock", "Grunge"] | ["amateur recording", "blues guitar", "guitar fills", "tambourine backing", "minimal instruments", "no voice", "instrumental song", "suspenseful mood", "moderate tempo"] | 0 | gp7j9o2x9co | 4055 |
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;