musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "distorted electric guitar", musiccaps_aspects contains "melodic singing" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 18 ✖
- bass guitar 2
- distorted electric guitar · 2 ✖
- melodic singing · 2 ✖
- acoustic drums 1
- clean electric guitar 1
- crunchy 1
- fast-paced acoustic drums 1
- happy 1
- hard-hitting 1
- high tempo 1
- japanese pop-punk 1
- male vocals 1
- playful 1
- pop punk 1
- rebellious 1
- rising pattern 1
- teenage female vocal 1
- uplifting 1
musiccaps_names (array) 4 ✖
- Music · 2 ✖
- Exciting music 1
- Independent music 1
- Jazz 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Dizzy Sunfist "SULLEY" Official Music Video | This is a Japanese pop-punk music piece. There is a teen female vocalist singing merrily and melodically in the English language. There is a distorted electric guitar playing the main tune with a bass guitar. The rhythmic background consists of a fast-paced punk beat being played on the acoustic drums. The atmosphere is uplifting. This piece could be used in the soundtrack of a teenage/young adult feelgood movie/TV show. It could also take place in the soundtrack of an animation movie or an anime. | 2014-06-25T07:52:11Z | CAFFEINE BOMB OFFICIAL | Dizzy Sunfist 2nd Mini Album"SUPER DELICIOUS"より2本目MV!! Official Web Site http://dizzy-sunfist.com/ facebook https://www.facebook.com/dizzysunfist2006/ Twitter https://twitter.com/_Dizzy_Sunfist_ Instagram https://www.instagram.com/dizzysunfist_official | ["Jazz", "Music"] | ["japanese pop-punk", "teenage female vocal", "melodic singing", "distorted electric guitar", "bass guitar", "fast-paced acoustic drums", "happy", "playful", "uplifting", "high tempo"] | 9 | BEEknOFrVdU | 1219 |
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;