musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "amateur recording" and musiccaps_names contains "Punk rock" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 19 ✖
- amateur recording · 3 ✖
- acoustic drums 2
- blues guitar 1
- e-bass 1
- e-guitar 1
- e-guitars 1
- guitar fills 1
- hammond organ 1
- indirock 1
- instrumental song 1
- male voice singing 1
- medium tempo 1
- minimal instruments 1
- moderate tempo 1
- no voice 1
- rock 1
- suspenseful mood 1
- tambourine backing 1
- uptempo 1
musiccaps_names (array) 10 ✖
- Music 3
- Punk rock · 3 ✖
- Grunge 1
- Heavy metal 1
- Progressive rock 1
- Psychedelic rock 1
- Rock music 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 |
---|---|---|---|---|---|---|---|---|---|---|
Crushing Day (Live) - Joe Satriani | An acoustic drumset plays a rock groove along with a bassline building the foundation of the song. Someone is playing a solo melody on an e-guitar. This recording is of poor quality. This song may be playing at a live concert. | 2007-05-19T20:38:22Z | lemoners | Footage of Joe playing Crushing Day live. He actually played it during this 2002 Strange Beautiful Music tour webcast. Joe never plays Crushing Day live because it's "cursed". He says that every time he plays it live, someting goes wrong, like the rhythm speeding up, or him messing up on the difficult solo. Also, it's his only composed solo. Most others are improvised, which allows him to have more flexibility in his live performance. His band members usually don't like playing the song either because the rhythm section is quite boring for them. Enjoy this rare footage, sorry about the quality. | ["Music", "Punk rock"] | ["rock", "e-guitar", "e-bass", "acoustic drums", "uptempo", "amateur recording"] | 6 | I6wri5XQQbU | 1876 | |
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 | |
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;