musiccaps_details (view)
2 rows where musiccaps_aspects contains "hard-hitting", musiccaps_aspects contains "male vocals" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- bass guitar 2
- hard-hitting · 2 ✖
- male vocals · 2 ✖
- acoustic drums 1
- acoustic guitar 1
- aggressive 1
- clean electric guitar 1
- crunchy 1
- distorted electric guitar 1
- electric guitar 1
- gothic rock 1
- grunt-like singing 1
- melodic singing 1
- pop punk 1
- punk rock 1
- rebellious 1
- rising pattern 1
musiccaps_names (array) 10 ✖
- Bass drum 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Exciting music 1
- Independent music 1
- Music 1
- Percussion 1
- Rimshot 1
- Snare drum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Damned - Smash It Up Parts 1 & 2 (Official Audio) | This is a punk rock music piece. There are male vocals singing in a grunt-like manner. The melody is being played by an electric guitar while a bass guitar plays in the background. The rhythm consists of a slightly fast-paced rock acoustic drum beat. The piece has an aggressive atmosphere. It could be used in the soundtrack of an action-filled video game. | 2014-08-19T09:24:23Z | Ace Records | Official audio for Smash It Up Parts 1 & 2 by The Damned, released on Ace Records. Subscribe to the official Ace channel for more classics, lost gems, playlists, and more: http://www.youtube.com/AceRecordsBroadcast http://acerecords.co.uk/machine-gun-etiquette | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["punk rock", "gothic rock", "male vocals", "grunt-like singing", "electric guitar", "bass guitar", "acoustic guitar", "hard-hitting", "aggressive"] | 9 | -FFx68qSAuY | 31 | |
Patent Pending: Douchebag (Official Music Video) | This is a pop punk music piece. The male vocals are singing melodically. Initially, there is a clean sounding electric guitar playing the main melody. Then, a rising pattern starts to play and the distorted electric guitar takes the place of the clean electric guitar. The bass guitar is playing in the background. The rhythm is provided by an upbeat acoustic drum beat. The atmosphere is hard-hitting. This piece can be used in the soundtrack of a teenage drama as the opening theme. | 2011-12-06T21:45:34Z | Patent Pending TV | "Douchebag" Patent Pending's Official Music Video Directed by Built By Ninjas! http://itunes.apple.com/us/album/douchebag/id455707825?i=455707833&ign-mpt=uo%3D4 New album 'Riot Hearts Rebellion' AVAILABLE NOW! Digital: http://smarturl.it/RHRDigital Physical: http://smarturl.it/RHRPhysical Catch Patent Pending supporting Simple Plan this summer in The United States: August 18 - The Intersection - Grand Rapids, MI August 19 - Bogarts - Cincinnati, Oh August 20 - Egyptian Room at Old National Centre - Indianapolis, IN August 22 - First Avenue - Minneapolis, MN August 24 - House Of Blues - Dallas, TX August 25 - House Of Blues - Houston, TX August 26 - Emo’s East - Austin, TX August 29 - Brooklyn Bowl - Las Vegas, NV August 28 - Orpheum - Flagstaff, AZ August 30 - Ace OF Spades - Sacramento, CA September 1 - Crystal Ballroom - Portland, OR September 2 - Neptune Theater - Seattle, WA September 3 - Neptune Theater - Seattle, WA | ["Music", "Independent music", "Exciting music"] | ["pop punk", "male vocals", "melodic singing", "clean electric guitar", "rising pattern", "distorted electric guitar", "bass guitar", "acoustic drums", "crunchy", "hard-hitting", "rebellious"] | 9 | 6XHdybfV5Cw | 764 |
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;