musiccaps_details (view)
3 rows where musiccaps_aspects contains "backup singers" and musiccaps_aspects contains "rapping vocals" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 47 ✖
- backup singers · 3 ✖
- rapping vocals · 3 ✖
- energetic 2
- groovy drumming rhythm 2
- male singer 2
- percussive bass line 2
- piano accompaniment 2
- youthful 2
- aisi an pop 1
- asian pop hits 1
- bleeding crowd noise 1
- brass band 1
- dance rhythm 1
- emotional 1
- enthusiastic 1
- exciting 1
- fast drumming rhythm 1
- fast tempo 1
- gangs 1
- groovy 1
- groovy rhythm 1
- grunge string section harmony 1
- guitar rhythm 1
- hip hop dance hits 1
- hip hop hits 1
- hip hop music 1
- hood 1
- inspirational 1
- latin dance rhythm 1
- latin dancers 1
- latin percussions 1
- love performance 1
- male latin singer 1
- memdium tehsil po 1
- motivational 1
- passionate 1
- people talking ambient sounds 1
- poor audio quality 1
- pop hits 1
- romantic 1
- screaming vocals 1
- steady rhythm 1
- story telling 1
- street music 1
- strong bass line 1
- trumpets blaring 1
- vocal harmony 1
musiccaps_names (array) 8 ✖
- Music 3
- Blues 1
- Disco 1
- Maraca 1
- Rhythm and blues 1
- Salsa music 1
- Song 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jones Cup 2012 - Smart Gilas Sige Lang Music Video HD | A male singer sings this cool melody with backup singers in vocal harmony. The tempo is medium with a groovy drumming rhythm, guitar accompaniment, piano accompaniment, percussive bass line and ambient crowd noises. The song is a modern Asian pop song. | 2012-08-30T00:39:31Z | Sound Check Music | Induk Videography Music: Sige lang By Quest | ["Blues", "Disco", "Music", "Speech"] | ["male singer", "backup singers", "asian pop hits", "bleeding crowd noise", "rapping vocals", "vocal harmony", "exciting", "enthusiastic", "groovy drumming rhythm", "percussive bass line", "piano accompaniment", "guitar rhythm", "people talking ambient sounds", "energetic", "youthful", "pop hits", "aisi an pop"] | 1 | AtJ2RXQ98kY | 1179 | |
Chamillionaire Wont Hear A Sound Freestyle (NEW 3/27/2012) | A male singer sings this hip hop melody with backup singers in vocal harmony. The song is medium tempo with a groovy drum rhythm, steady bass line and a grunge keyboard harmony. The song is exciting and energetic. The song has average audio quality. | 2012-03-27T03:07:58Z | TechnicalPrecision | This is Chamillionaires Wont hear a sound freestyle! Subscribe for quality music! | ["Music", "Rhythm and blues"] | ["male singer", "hip hop music", "backup singers", "rapping vocals", "memdium tehsil po", "groovy drumming rhythm", "strong bass line", "grunge string section harmony", "story telling", "groovy rhythm", "dance rhythm", "steady rhythm", "emotional", "gangs", "hood", "motivational", "inspirational", "hip hop hits", "hip hop dance hits"] | 1 | 67S7s_jFXhc | 726 | |
La Maraca | A male Latin singer sings this energetic vocal with male backup singers in vocal harmony. The song is fast tempo with quick Latin percussions, groovy bass line, keyboard accompaniment and trumpets blaring. The song is energetic and passionate. The song has poor audio quality. | 2008-04-10T19:01:41Z | adonismasgozadera | AdonisGozadera.com | ["Music", "Song", "Salsa music", "Maraca"] | ["male latin singer", "backup singers", "screaming vocals", "rapping vocals", "street music", "fast tempo", "poor audio quality", "piano accompaniment", "latin percussions", "percussive bass line", "fast drumming rhythm", "energetic", "youthful", "romantic", "love performance", "brass band", "trumpets blaring", "groovy", "passionate", "latin dancers", "latin dance rhythm"] | 1 | zNSV9GkpRfM | 5468 |
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;