musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "male vocal", musiccaps_aspects contains "pop" and musiccaps_names contains "Funk"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 21 ✖
- danceable 2
- male vocal · 2 ✖
- pop · 2 ✖
- acoustic drums 1
- bass guitar 1
- chill 1
- easygoing 1
- electric guitar 1
- electric guitar sample 1
- electronic 1
- electronic drums 1
- energetic 1
- female vocal 1
- hip-hop 1
- keyboard 1
- medium-to-high pitch singing 1
- melodic pad 1
- melodic singing 1
- rock 1
- strong bass 1
- urban 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Flo Rida ROOTS Feat. Akon - Guarantee - New Music HQ | This is a pop music piece. There is a male vocalist singing at a medium-to-high pitch in the lead. There is a melodic pad and an electric guitar sound providing the melody. A strong bass sound can be heard playing. The rhythm consists of a simple electronic drum beat. The atmosphere is energetic and danceable. This piece can be played at nightclubs and dance clubs. It could also be used during club scenes in movies. | 2008-12-31T01:29:58Z | FloRidaROOTS | Download This Mp3 Free http://downloadfreemusicnow.blogspot.com Flo Rida ROOTS Feat. Akon - Guarantee - New Music HQ r&b | ["Funk", "Music"] | ["pop", "hip-hop", "electronic", "male vocal", "medium-to-high pitch singing", "electric guitar sample", "melodic pad", "strong bass", "electronic drums", "energetic", "danceable", "urban"] | 9 | AT_076RUWPs | 1118 | |
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 |
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;