musiccaps_details (view)
2 rows where musiccaps_aspects contains "r&b", musiccaps_names contains "Music of Asia" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- r&b · 2 ✖
- accompanying 1
- autotune 1
- bass guitar 1
- electric guitar 1
- electronic drums 1
- emotional 1
- female choir 1
- female vocal 1
- girl band 1
- grandiose 1
- groovy 1
- heavy vocal processing 1
- hip-hop 1
- live performance 1
- male vocal 1
- melisma 1
- melodic singing 1
- multiple female singers 1
- pop 1
- soul 1
- vocal hocketing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Puff Daddy Ill Be Missing You | This is an R&B/soul music piece. There is a female vocal singing at a high pitch joined by a male vocal singing at a medium pitch and a female choir backing. The beat has a repeating electric guitar tune. There is a groovy bass line. The rhythm is provided by an electronic drum beat. The atmosphere is emotional and grandiose. This piece could be playing in the background at a memorial event. | 2009-03-24T09:22:59Z | Noti1986 | ["Singing", "Music of Asia", "Crowd", "Music"] | ["r&b", "soul", "hip-hop", "live performance", "female vocal", "male vocal", "female choir", "melodic singing", "electric guitar", "bass guitar", "electronic drums", "groovy", "emotional", "grandiose"] | 9 | vxIF3B4YqW8 | 5221 | ||
"Best Love Song" by T-Pain, feat Chris Brown - cover by CIMORELLI! | Heavily processed girl band with multiple female singers in a pop or R&B style, using autotune, vocal hocketing, and melisma with multiple synthesizers accompanying. | 2011-05-22T14:30:21Z | Cimorelli | We answer our messages on Patreon! Join the family and get close with us 😁❤️ https://www.patreon.com/Cimorelli Our original song "Million Bucks" is currently playing on SiriusXM's channel 20 on 20!!! Request it HERE: www.bit.ly/SiriusXMVote Thanks!!!!!!!!!! Our EP reached #6 on the US iTunes pop charts!!! Thank you guys so much! :D Purchase HERE: http://itunes.apple.com/us/album/cimfam-ep/id482598948 http://facebook.com/cimorelliband We LOVE this song! Hope you like our arrangement of it! LINKS: http://twitter.com/cimorelliband http://facebook.com/cimorelliband http://cimorellimusic.com http://youtube.com/xxooxxoo8993 MERCH: http://cimorellimusic.com/store We have individual twitters as well (@ChristinaCim @KathCim @LisaCim @AmyCim @LaurenCimorelli @Danicim :) Honors for this video (39) #28 - Most Discussed (Today) #1 - Most Discussed (Today) - Music #32 - Most Discussed (This Week) - Music #37 - Most Viewed (Today) - Germany #124 - Most Viewed (Today) - United Kingdom #75 - Most Viewed (Today) #183 - Most Viewed (Today) - Spain #192 - Most Viewed (Today) - France #116 - Most Viewed (Today) - Netherlands #191 - Most Viewed (Today) - Sweden #131 - Most Viewed (Today) - Australia #31 - Most Viewed (Today) - Canada #171 - Most Viewed (Today) - Ireland #138 - Most Viewed (Today) - Israel #77 - Most Viewed (Today) - New Zealand #197 - Most Viewed (Today) - Music - Egypt #64 - Most Viewed (Today) - Music - Czech Republic #4 - Most Viewed (Today) - Music - Germany #20 - Most Viewed (Today) - Music - United Kingdom #19 - Most Viewed (Today) - Music #35 - Most Viewed (Today) - Music - Spain #69 - Most Viewed (Today) - Music - Mexico #45 - Most Viewed (Today) - Music - France #35 - Most Viewed (Today) - Music - Italy #17 - Most Viewed (Today) - Music - Netherlands #56 - Most Viewed (Today) - Music - Poland #63 - Most Viewed (Today) - Music - Brazil #28 - Most Viewed (Today) - Music - Sweden #158 - Most Viewed (Today) - Music - Jordan #76 - Most Viewed (Today) - Music - Saudi Arabia #25 - Most Viewed (Today) - M… | ["Singing", "Music of Asia"] | ["multiple female singers", "autotune", "vocal hocketing", "pop", "r&b", "accompanying", "melisma", "heavy vocal processing", "girl band"] | 8 | xydcedfPePM | 5373 |
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;