musiccaps_details (view)
4 rows where musiccaps_aspects contains "female vocal", musiccaps_author = 9 and musiccaps_names contains "/t/dd00004"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- female vocal · 4 ✖
- acoustic guitar 2
- bass guitar 2
- electronic drums 2
- acoustic 1
- alternative 1
- back vocals 1
- chipmunk effect 1
- clicks 1
- comedic 1
- dance 1
- dramatic 1
- drums 1
- emotional 1
- folk dance 1
- folk music 1
- keyboard 1
- latin pop 1
- live performance 1
- male vocal 1
- medium-to-high pitch 1
- melodic singing 1
- pamiri 1
- percussion 1
- piano 1
- playful 1
- pop music 1
- sentimental 1
- simple tune 1
- slow tempo 1
- soprano 1
- vocal performance 1
musiccaps_names (array) 5 ✖
- /t/dd00004 · 4 ✖
- Music 4
- Singing 2
- /t/dd00003 1
- Child singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
World most beautiful girl singing pamiri song 2013 best song ever | This is a Pamiri folk song. The female vocalist is singing melodically accompanied by a choir of both male and female back vocals. A keyboard is playing the main tune while a mixture of loud electronic drums and percussion provide the rhythmic background. This piece has a playful atmosphere. It could be used in a dancing course that involves folk dances of the region. | 2013-07-23T15:56:42Z | Muhammad Ammar Saleem | Caution.!! Only 18+ can watch otherwise you will fall in love..!!! | ["Music", "/t/dd00004"] | ["pamiri", "folk music", "female vocal", "back vocals", "keyboard", "electronic drums", "percussion", "playful", "folk dance"] | 9 | 5qVc9y3TNnY | 697 | |
Me singing the voice within | This is a vocal performance recording of a pop music piece. It is an amateur recording. The female vocalist is singing in a rising-and-falling manner in medium-to-high pitch. The backing track consists of a simple piano tune, a groovy bass line provided by a bass guitar and a 4/4 signature slow tempo drum beat with clicks on every fourth beat. The atmosphere is sentimental and heart-touching. | 2007-08-29T23:39:26Z | jessalovexox | Me singing the Voice within by christina aguilera.. my first youtube video so please be nice, lol. | ["Singing", "Music", "/t/dd00004"] | ["vocal performance", "pop music", "female vocal", "medium-to-high pitch", "piano", "bass guitar", "drums", "clicks", "slow tempo", "dramatic", "sentimental"] | 9 | 8DHtPopFvII | 903 | |
Hayley Williams & Josh Farro - You Ain't Woman Enough (Loretta Lynn cover) - Paramore | This is an acoustic live performance of an alternative music piece. There is a female vocalist singing melodically at a soprano range. In the melodic background, there is an acoustic guitar playing a simple tune. The piece has an emotion-filled atmosphere. It could be used in the soundtrack of a drama movie or a TV show. | 2009-11-02T07:39:48Z | planecrashdream | This is the original, first, and only UNPLUGGED performance! This is my video. The other copies of this around youtube are fakes. This was on November 1st, 2009. Ryman Auditorium, Nashville, Tennessee. It was so incredible. PLEASE no comments about the yelling, or comments bashing Jenna or about Hayley and Josh being together. They aren't together and their significant others don't deserve hate. | ["Singing", "Music", "/t/dd00004"] | ["alternative", "acoustic", "live performance", "female vocal", "soprano", "melodic singing", "acoustic guitar", "simple tune", "emotional"] | 9 | eWGGj4duzIo | 3869 | |
......... | This is a latin pop song with a chipmunk effect. There is a female and a male vocal singing melodically but at a higher pitch than the original. An acoustic guitar and a bass guitar play in the melodic background while a latin electronic drum beat is in the rhythmic background. The piece is very danceable. The piece could be used at a children's dancing course as an accompaniment. It could also be used in the background of funny social media content. | 2016-09-23T19:33:32Z | Vamos Perú Oficial | SUSCRIBIRSE A MI CANAL PARA VER MAS DE PEPPA PIG. GRACIAS POR VER QUERIDOS AMIGUITOS. | ["Music", "/t/dd00003", "/t/dd00004", "Child singing"] | ["latin pop", "female vocal", "male vocal", "chipmunk effect", "acoustic guitar", "bass guitar", "electronic drums", "dance", "comedic"] | 9 | mLaon9oK1OA | 4461 |
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;