musiccaps_details (view)
1 row where musiccaps_aspects contains "aggressive mood", musiccaps_aspects contains "male voices", musiccaps_names contains "Angry music" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
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 |
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;