musiccaps_details (view)
4 rows where musiccaps_aspects contains "uptempo" and musiccaps_names contains "Angry music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- acoustic drums 4
- uptempo · 4 ✖
- e-guitar 3
- e-bass 2
- rock 2
- background noises 1
- chaotic 1
- double-bass 1
- e-guitars 1
- epic 1
- extatic energy 1
- hardrock 1
- higher key 1
- keys 1
- male voice singing 1
- progressive rock 1
- synth hits 1
- synth-strings 1
- uplifting energy 1
- voices 1
- wild 1
musiccaps_names (array) 3 ✖
- Angry music · 4 ✖
- Music 4
- Heavy metal 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Arctic Monkeys - Dangerous Animals with lyrics | This song contains acoustic drums playing a kick on every half-beat along with an e-bass playing a repeating bassline along with an e-guitar. Another e-guitar is playing long notes with a lot of reverb in a higher register. Another guitar is playing a counter melody in an even higher key. A male voice is singing in a higher key while being backed by another male voice singing a harmony in an even higher key. This song may be playing live at a festival. | 2009-09-01T14:08:21Z | 0oBlackCato0 | Hello everybody! that's my first video with lyrics. This is a new song of Arctic Monkeys, from the album Humbug. I hope you like it :3 P.D: If you want more songs of Arctic like this, tell mee! | ["Music", "Angry music"] | ["rock", "e-guitars", "e-bass", "male voice singing", "higher key", "acoustic drums", "wild", "extatic energy", "uptempo"] | 6 | KbDLu4VozGg | 2099 | |
Musica de Fondo Naruto- Pelea De Gaara | The drums are playing a complex groove full of tom hits and fill-ins. On every big hit a synth is playing a sound while e-guitars and another instrument are playing a countermelody. The song sounds like someone being chased by something fast and dangerous. This song may be playing in a game of a tv-show. | 2008-05-01T14:52:37Z | Diego Pérez | Vacana | ["Music", "Angry music"] | ["progressive rock", "acoustic drums", "e-guitar", "synth hits", "uptempo", "chaotic"] | 6 | RTQJe028VdU | 2704 | |
Cradle Of Filth - Mannequin (OFFICIAL MUSIC VIDEO) | Someone is playing an acoustic drumset with an open hi-hat and fast aggressive fill-ins. An e-bass is playing a simple bassline along. In the background you can hear strings playing a melody while an e-guitar is playing an arpeggio melody on top. In the background you can hear people cheering and singer/singers at the end of a phrase. This song may be playing in a live concert. | 2008-02-11T21:40:56Z | Cradle Of Filth | Official music video for Cradle Of Filth "Mannequin" from Damnation And A Day SUBSCRIBE to Cradle of Filth on YouTube: http://bit.ly/subs-cof-yt SUBSCRIBE to Nuclear Blast YouTube: http://bit.ly/subs-nb-yt | ["Heavy metal", "Music", "Angry music"] | ["hardrock", "acoustic drums", "double-bass", "e-guitar", "synth-strings", "background noises", "voices", "e-bass", "uptempo", "epic"] | 6 | oVhhEku6ECA | 4637 | |
(PSX) Captain Tsubasa J: Get in the Tomorrow - All Star Team Shoot / Twin Shoot | This audio contains a drum playing with a lot of toms. A distorted e-guitar is playing a solo melody. In the background panned to the right side of the speakers you can hear a keyboard playing minor chords in the higher mid-range. This song may be playing while sitting in your room dancing for yourself. | 2010-07-24T09:05:41Z | DerroChannel | In this video I used the All Star Team to make some shoot ;) In the next video if you want i can make a tutorial where i show you how to make the shoots and the twin shoots. If you want this write it in the comment ;) | ["Music", "Angry music"] | ["rock", "e-guitar", "acoustic drums", "keys", "uptempo", "uplifting energy"] | 6 | vDmUlgsDOP4 | 5163 |
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;