musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "melodic singing" and musiccaps_aspects contains "pop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- bass guitar 2
- easygoing 2
- electric guitar · 2 ✖
- female vocal 2
- keyboard 2
- melodic singing · 2 ✖
- pop · 2 ✖
- acoustic drums 1
- chill 1
- danceable 1
- electronic drums 1
- generic 1
- male vocal 1
- r&b 1
- rock 1
musiccaps_names (array) 3 ✖
- Music 2
- Funk 1
- Rhythm and blues 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Junior Senior - "Can I Get Get Get" Crunchy Frog/Rykodisc | This is a pop music piece with an early 2000s feel. There is one male and one female vocalist singing melodically. The melody is being played by the electric guitar and the keyboard guitar with the bass guitar in the background. The rhythm is provided by the acoustic drums with occasional clap sounds. The atmosphere is easygoing and danceable. This piece could be used in the soundtrack of a sit-com movie or a TV show. | 2007-08-17T04:41:59Z | BlankTV | Like this video? Come see thousands more at the Net's biggest, uncensored, completely d.i.y. punk, hardcore, indie and alternative music video site, BlankTV.com! We've got News, Games, Contests and the stuff that we can't show on YouTube! Free! Uncensored! Triggered! BlankTV.com! Director: Jeppe Laursen & Humberto Flores http://www.itunes.com/juniorsenior | ["Funk", "Music"] | ["pop", "rock", "male vocal", "female vocal", "melodic singing", "electric guitar", "keyboard", "bass guitar", "acoustic drums", "chill", "easygoing", "danceable"] | 9 | YB_PzRgHOeo | 3263 | |
NewChristianArtist.com Sell Your Christian Music! | This is an R&B/pop music piece. There is a female vocalist singing melodically in the lead. The melody is being played on the electric guitar. The bass guitar is playing in the background. The rhythmic background consists of an electronic drum beat. The atmosphere is easygoing and generic. This piece could work well as an advertisement jingle. | 2008-05-06T02:48:37Z | Jordan Biel | Promo Video for NewChristianArtist.com Create your page! Connect with fans! Share your bio, calendar, photos, and more! Beginning JUNE 15th, 2008!!!!! | ["Music", "Rhythm and blues"] | ["r&b", "pop", "female vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "electronic drums", "easygoing", "generic"] | 9 | gVMoI2ukbtc | 4033 |
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;