musiccaps_details (view)
3 rows where musiccaps_author = 0, musiccaps_names contains "Psychedelic rock" and musiccaps_names contains "Punk rock"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 24 ✖
- moderate tempo 2
- acoustic song 1
- amateur band 1
- amateur recording 1
- bass 1
- blues guitar 1
- distortion guitars 1
- guitar fills 1
- heavy metal 1
- instrumental song 1
- keyboards 1
- live recording 1
- low quality recording 1
- minimal instruments 1
- no voice 1
- no voices 1
- palm muted arpeggios 1
- percussion 1
- piano 1
- powerful percussion 1
- quirky sounds from the crowd 1
- rock and roll 1
- suspenseful mood 1
- tambourine backing 1
musiccaps_names (array) 9 ✖
- Music 3
- Psychedelic rock · 3 ✖
- Punk rock · 3 ✖
- Rock music 3
- Heavy metal 2
- Progressive rock 2
- Bluegrass 1
- Grunge 1
- Rock and roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rock-Jerry & The Sounds 2014 Taarasti | This rock and roll song is a live recording of low quality. This features a male voice singing the main melody. This is accompanied by percussion playing a simple melody in common time. The bass plays a rock and roll bassline. The keyboard plays chords and fills using a piano tone. An acoustic guitar plays chords. A voice from the crowd sings a quirky sound at the beginning of the second bar. This song can be used in a retro movie in a music festival or carnival scene. | 2014-10-21T16:53:27Z | seti kolj | Kunnianosoitus Suomalaisen rockin pioneerille | ["Music", "Punk rock", "Psychedelic rock", "Rock music", "Rock and roll", "Bluegrass"] | ["rock and roll", "live recording", "low quality recording", "amateur band", "acoustic song", "bass", "quirky sounds from the crowd", "piano", "percussion", "moderate tempo"] | 0 | b8okzVltB5Q | 3604 | |
Kettlespider - The Kettle Spider - Australian Prog Metal - Triple J | This heavy metal song features distortion guitars. One guitar plays power chords. Another guitar is playing a repetitive riff using palm muted arpeggiated notes. The keyboard plays chords in the background. The bass plays the root notes of the chords. The percussion plays a simple beat in common time. It starts off playing the kick and crash followed by three beats on the kick and ride. After four bars, a rock drum roll is played. This song can be played in a superhero movie. | 2011-10-10T02:31:19Z | Kettlespider | Nice solid prog ala Dream Theater style! Lots of promise here so keep an eye out! Hornz! Haugy \m/ Andrew Haug, triple j 'Avadante', the debut album from Kettlespider, is available on iTunes: http://itunes.apple.com/au/album/avadante/id524530770 Also, check out our CD if you like the music! http://kettlespider.bandcamp.com www.facebook.com/kettlespider | ["Heavy metal", "Music", "Punk rock", "Psychedelic rock", "Rock music", "Progressive rock"] | ["heavy metal", "no voices", "distortion guitars", "palm muted arpeggios", "powerful percussion", "keyboards"] | 0 | dO3VsX4rKNc | 3782 | |
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;