musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "heavy metal", musiccaps_author = 0 and musiccaps_names contains "Angry music" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- heavy metal · 2 ✖
- aggressive mood 1
- aggressive voice 1
- amateur recording 1
- bassline 1
- descending chords 1
- distortion guitar 1
- distortion guitars 1
- eerie 1
- goth metal 1
- heavy percussion 1
- male voice 1
- male voices 1
- moderate tempo 1
- simple percussion 1
- synth backing 1
musiccaps_names (array) 4 ✖
- Angry music · 2 ✖
- Music 2
- Heavy metal 1
- Rock music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
WWF Forceable Entry:The Beautiful People(Smackdown old theme) | This goth metal song features a male voice singing the main melody. The voice is deep. Toward the end, there are other male voices singing vocables. This is accompanied by heavy percussion using a five-beat common time pattern played on floor toms with a shuffle note each note creating a triplet feel. The distortion guitars play heavy descending chord riffs using palm muting technique. The bass guitar plays the root notes of the chords. At the background, there is an high pitched sound played on a synth that gives this song an eerie feel. This song can be played at the end credits of a horror movie. | 2009-07-06T22:15:51Z | cactuar64 | Song:"The Beautiful People" Song By:Marilyn Manson | ["Heavy metal", "Music", "Rock music", "Angry music"] | ["heavy metal", "goth metal", "male voice", "amateur recording", "distortion guitars", "heavy percussion", "descending chords", "synth backing", "eerie"] | 0 | vy2gUzgmBzQ | 5222 |
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;