musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "bassline" and musiccaps_aspects contains "moderate tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- bassline · 2 ✖
- distortion guitar 2
- moderate tempo · 2 ✖
- aggressive mood 1
- aggressive voice 1
- heavy metal 1
- low quality recording 1
- male voice 1
- male voices 1
- metal song 1
- multiple guitars 1
- out of time guitar 1
- power drumming 1
- simple percussion 1
musiccaps_names (array) 6 ✖
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 | |
Guitar Hero | This clip features 2 distortion guitars playing a metal song. A high pitched male voice sings the main melody. This is accompanied by percussion playing a simple rock beat in common time. A bass guitar plays a bassline with a descending run. The distortion guitars play power chords followed by a guitar lick. One of the guitars plays one chord a little after the other guitar making it sound dissonant. This song can be played in an action movie. | 2006-04-25T16:32:40Z | Kim Burkart | Two Dudes Playing Guitar Hero | ["Guitar", "Music", "Musical instrument", "Roll", "Plucked string instrument"] | ["low quality recording", "metal song", "distortion guitar", "multiple guitars", "bassline", "power drumming", "male voice", "out of time guitar", "moderate tempo"] | 0 | dVUgd8ot6BE | 3794 |
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;