musiccaps_details (view)
2 rows where musiccaps_aspects contains "amateur recording", musiccaps_author = 6 and musiccaps_names contains "Punk rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- acoustic drums 2
- amateur recording · 2 ✖
- e-bass 1
- e-guitar 1
- e-guitars 1
- hammond organ 1
- indirock 1
- male voice singing 1
- medium tempo 1
- rock 1
- uptempo 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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;