musiccaps_details (view)
3 rows where musiccaps_aspects contains "distorted guitar rhythm", musiccaps_author = 1 and musiccaps_names contains "Angry music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- distorted guitar rhythm · 3 ✖
- adrenaline rush 2
- fast tempo 2
- instrumental music 2
- keyboard accompaniment 2
- passionate 2
- percussive bass line 2
- amplified guitar harmony 1
- anime show 1
- bad audio quality 1
- bad sound quality 1
- collectors choice 1
- cymbals crashing 1
- death metal music 1
- energetic 1
- enlightening 1
- exciting 1
- fast cars 1
- fast metal drumming 1
- female chanting sounds 1
- female vocals 1
- game soundtrack 1
- groovy drumming rhythm 1
- groovy guitar rhythm 1
- groovy rhythm 1
- groovy sluice 1
- grunge keyboard tones 1
- guitar lead 1
- hard rock music 1
- heavy metal music 1
- new age 1
- nirvana 1
- pristine audio quality 1
- rebellious 1
- rich and famous 1
- song ending 1
- song fade 1
- sophisticated 1
- spirited 1
- steady marching rhythm 1
- strong bass drum hits 1
- strong bass line 1
- supercar documentary soundtrack 1
- techno dance rhythm 1
- youthful 1
musiccaps_names (array) 4 ✖
- Angry music · 3 ✖
- Music 3
- Heavy metal 1
- Rock music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Code Geass - Mindfreak | A female singer sings and chants with Emily. The tempo is fast with a quick drumming rhythm, percussive bass line, strong drumming rhythm and keyboard accompaniment. The song is exciting and energetic. The song is an anime show soundtrack. | 2009-01-06T20:11:40Z | SakuraLanee | I finally got off my butt and made another AMV....sadly, I can't get away from Code Geass. ^_^; So, for all my dedicated fans, I've made this new AMV that is actually a step away from all my humor ones. If you want to know the songs used, just wait for the credits. Leave some feedback! I love to hear from you guys. Disclaimer: I do not own Code Geass or any thing affiliated with it. I've simply used a good series for my AMV I also do not own the song, "Mindfreak" - Criss Angel has those rights and I encourage you to look into his CD; it's pretty good. Other than that, enjoy! | ["Music", "Angry music"] | ["female vocals", "death metal music", "bad sound quality", "female chanting sounds", "fast tempo", "groovy drumming rhythm", "distorted guitar rhythm", "percussive bass line", "groovy guitar rhythm", "keyboard accompaniment", "new age", "enlightening", "nirvana", "game soundtrack", "anime show", "exciting", "energetic", "passionate", "techno dance rhythm"] | 1 | 0298WjE3_tk | 112 | |
C7 Callaway Corvette Z06 Standing Mile Run at the NASA Runway | The song is an instrumental. The tempo is medium with a strong marching drum rhythm, with cymbal crashes and bass drum kicks, percussive bass line and amplified guitar playing rhythm. The audio quality is pristine and the soundtrack is high on adrenaline. | 2016-03-31T21:27:36Z | xxtamgxx | 2015 C7 Callaway Corvette Z06 Blasts Off at NASA Runway | ["Music", "Angry music"] | ["hard rock music", "strong bass drum hits", "rich and famous", "collectors choice", "sophisticated", "pristine audio quality", "instrumental music", "distorted guitar rhythm", "strong bass line", "groovy sluice", "steady marching rhythm", "amplified guitar harmony", "adrenaline rush", "supercar documentary soundtrack", "fast cars", "grunge keyboard tones"] | 1 | LMGpKPavV4Q | 2181 | |
W.A.S.P. - My Tortured Eyes LYRICS | The song is an instrumental. The tempo is fast with a fast metal drumming rhythm, complete with cymbal crashes, distorted guitar lead, guitar playing rhythm, and percussive bass line. The song is a death metal song ending with a bad audio quality. | 2011-08-19T16:13:10Z | nagito11 | ["Heavy metal", "Music", "Rock music", "Angry music"] | ["heavy metal music", "instrumental music", "fast metal drumming", "distorted guitar rhythm", "keyboard accompaniment", "instrumental music", "fast tempo", "groovy rhythm", "cymbals crashing", "song fade", "song ending", "passionate", "adrenaline rush", "spirited", "youthful", "rebellious", "bad audio quality", "guitar lead", "percussive bass line"] | 1 | nbb8vmfjHJs | 4563 |
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;