musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "uptempo" and musiccaps_names contains "Angry music" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- acoustic drums 3
- uptempo · 3 ✖
- e-bass 2
- e-guitar 2
- rock 2
- background noises 1
- double-bass 1
- e-guitars 1
- epic 1
- extatic energy 1
- hardrock 1
- higher key 1
- keys 1
- male voice singing 1
- synth-strings 1
- uplifting energy 1
- voices 1
- wild 1
musiccaps_names (array) 3 ✖
- Angry music · 3 ✖
- Music 3
- 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 | |
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;