musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "moderate tempo" and musiccaps_names contains "Heavy metal" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- moderate tempo · 4 ✖
- bass 3
- male voice 3
- distortion guitar 2
- percussion 2
- aggressive percussion 1
- alternative rock 1
- amateur recording 1
- blues guitar 1
- distortion guitars 1
- gothic rock 1
- guitar fills 1
- instrumental song 1
- male backing voice 1
- minimal instruments 1
- no voice 1
- punk rock 1
- simple percussion 1
- suspenseful mood 1
- suspenseful song 1
- synth 1
- tambourine backing 1
- upbeat song 1
musiccaps_names (array) 10 ✖
- Heavy metal · 4 ✖
- Music 4
- Punk rock 3
- Grunge 2
- Progressive rock 2
- Psychedelic rock 2
- Rock music 2
- Singing 1
- Ska 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
tribute to Oi, ska & Punk | This punk rock song features a male voice singing the main melody at a comfortable pitch. This is accompanied by percussion playing a simple rock beat. A distortion guitar plays power chords using downstrokes. The bass plays the root notes of the chords. This song is played at a moderate tempo. This song can be played at the end credits of an action movie. | 2009-04-29T02:58:40Z | skinbash69 | This is the tribute to all of my friends in the Oi, Ska & Punk Scene in the asian countries such as Singapore, Malaysia, Indonesia, Philippines & Brunei. Keep the scene alive...CHEER. | ["Heavy metal", "Music", "Punk rock", "Ska", "Progressive rock"] | ["punk rock", "male voice", "distortion guitar", "percussion", "bass", "moderate tempo", "upbeat song"] | 0 | PP3kNqPM434 | 2532 | |
Top 10 songs Gothic Rock, Industrial Metal, EBM, NDH and Futurepop | This gothic rock song features a male voice singing the main melody. The melody is repetitive for each line. This is accompanied by percussion playing a simple rock beat in common time. A distortion guitar plays power chords. A synth plays a high pitched repetitive melody. This song has a suspenseful feel. This song can be played in a horror movie. | 2009-08-13T22:53:50Z | Dyhg | Top 10 de musica oscura Gothic Rock, Industrial Metal, EBM, NDH and Futurepop | ["Singing", "Heavy metal", "Music", "Psychedelic rock", "Rock music", "Song"] | ["gothic rock", "male voice", "distortion guitar", "simple percussion", "bass", "synth", "suspenseful song", "moderate tempo"] | 0 | WRZGYDh7qRo | 3094 | |
Mayday Parade - "Black Cat" Live at the Alley | This alternative rock song features a male voice singing the main melody at a high pitch. Other male voices sing in harmony after the main voice pauses. This is accompanied by powerful percussion playing a rock beat in common time. Distortion guitars play power chords. One of the guitars plays the same melody as the backing voices on the lead guitar. The bass plays the root notes of the chords. This song is played at a moderate tempo. The mood of this song is upbeat. This song can be played in a Transformers style movie. | 2007-08-06T21:59:06Z | Fearless Records | This is a live video of Mayday Parade performing their track "Black Cat" off their album 'A Lesson in Romantics'. Filmed by DJay Brawner at the Alley in Fullerton 2007. Get Mayday Parade's first full length album 'A Lesson In Romantics' today on iTunes: http://bitly.com/TIu6FH Stay connected to Mayday Parade: http://www.maydayparade.com/ http://www.facebook.com/maydayparade http://twitter.com/maydayparade See what's new at Fearless Records: http://www.youtube.com/fearlessrecords Distributed by WMG | ["Heavy metal", "Music", "Punk rock", "Grunge"] | ["alternative rock", "male voice", "distortion guitars", "male backing voice", "bass", "percussion", "moderate tempo", "aggressive percussion"] | 0 | fQiSoVDFRjo | 3946 | |
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;