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