musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "distortion guitar" and musiccaps_aspects contains "heavy metal" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- distortion guitar · 2 ✖
- heavy metal · 2 ✖
- moderate tempo 2
- aggressive mood 1
- aggressive voice 1
- bassline 1
- instructional audio 1
- male voice 1
- male voices 1
- no other instruments 1
- no percussion 1
- no vocal melody 1
- octaves 1
- simple percussion 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
How to Play Trust by Megadeth Guitar Lesson (w/ Tabs!!) | This song features a distortion guitar. This is an instructional video. The song features an open note followed by the octave. Then a descending pattern is played on the distortion guitar. The voice gives instructions on how to play the pattern. There is no percussion in this song. There are no other instruments in this song. There is no vocal melody in this song. | 2009-03-15T04:06:25Z | m169marroquin | http://www.ObeyYourMATTster.com | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["distortion guitar", "heavy metal", "male voice", "instructional audio", "octaves", "no other instruments", "no percussion", "no vocal melody", "moderate tempo"] | 0 | 52odOK7G2kg | 628 | |
T.REX Tribute | This heavy metal song features a male voice singing at a distance in the background. Distortion guitars play a riff and end with a power chord. This is accompanied by percussion playing an aggressive metal beat. The bass follows the rhythm guitar for the beginning of the song and later plays licks while the notes of the distortion guitars are sustained. The mood of this song is aggressive. This song can be played on the entrance of a WWE star into the arena. | 2007-09-10T18:17:52Z | TheDeadLand | why cant i have a go and see what u think first try at a tribute hope u like it for more information go to www.thedeadlandseries.piczo.com music: Three days grace pictures: google and ollirockon well one a gd idea about making a tribute is make it about something, mine is about how t.rex is misunderstood and how no one will ever know what he was really like. | ["Music", "Angry music"] | ["heavy metal", "male voices", "distortion guitar", "bassline", "simple percussion", "aggressive voice", "aggressive mood", "moderate tempo"] | 0 | JxwRvkjNJQ0 | 2047 |
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;