musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "rock", musiccaps_author = 6 and musiccaps_names contains "Angry music" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- acoustic drums 5
- rock · 5 ✖
- e-bass 4
- e-guitar 4
- male voice singing 2
- uptempo 2
- aggressive energy 1
- e-guitars 1
- extatic energy 1
- female voice singing 1
- higher key 1
- keys 1
- male deeper voice singing 1
- male deeper voice singing/screaming 1
- medium tempo 1
- synth pad 1
- upbeat 1
- uplifting energy 1
- wild 1
- wild energy 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
GTA III and GTA lC (MOD) | This song contains an acoustic drum playing a simple rock groove with an e-bass playing a bassline along with the e-guitar strumming chords on the same notes as the bass. A deep male voice is singing, almost streaming sounding wild and loud. Then a synth pad comes in playing a melody panned to the left side of the speaker. This song may be playing at a rock festival. | 2008-05-28T14:56:03Z | cobra8811 | well the title says it.and dont ask YOU CANT HAVE THIS FOR PS 2 OR 3 or XBOX 360 | ["Music", "Angry music"] | ["rock", "e-guitar", "e-bass", "acoustic drums", "synth pad", "male deeper voice singing", "wild energy"] | 6 | AHmcuClSTL4 | 1098 | |
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 | |
(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 | |
The Prodigy - Hot ride | The acoustic drums are playing a groove with crash hits and a bass that sounds distorted while a female voice is singing. Then a male singer with an effect on his voice is almost screaming while an e-guitar is playing a melody. This song may be playing in a rock&roll bar. | 2012-05-29T15:19:17Z | Vegeta | The Prodigy: Hot ride | ["Music", "Angry music"] | ["rock", "e-guitar", "e-bass", "acoustic drums", "female voice singing", "male voice singing", "upbeat"] | 6 | hSK405L-DlQ | 4105 | |
TACTICAL PANANTUKAN - Alexander Plaksin ( R A P T ) Kali-Silat | This song contains loud acoustic drums with a groove on the ride. An e-bass and e-guitar are playing along in the lower register. A deeper male voice is singing/screaming with a delay on his voice. his voice is doubled. This song may be playing for an action packed youtube video. | 2012-10-28T05:57:23Z | Alexander Plaksin | Master Alexander Plaksin, Head Instructor Andrey Baklanov - SPINDLE PANANTUKAN TACTICAL ( MOSCOW CLUB 8 905 7779991 ) | ["Music", "Angry music"] | ["rock", "acoustic drums", "e-bass", "e-guitar", "male deeper voice singing/screaming", "aggressive energy", "medium tempo"] | 6 | Le4aGNS8e0c | 2210 |
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;