musiccaps_details (view)
3 rows where musiccaps_aspects contains "compelling" and musiccaps_aspects contains "synthesiser arrangements" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- compelling · 3 ✖
- engaging 3
- synthesiser arrangements · 3 ✖
- disco rap 2
- hip-hop 2
- hip-hop hits 2
- passionate 2
- persuasive 2
- rap 2
- vocal backup 2
- youthful 2
- amplified guitar 1
- atmospheric synthesiser 1
- bongos 1
- chanting 1
- coke studio 1
- congas 1
- contemporary indian pop 1
- cymbal ride 1
- dense layers 1
- digital drum 1
- drum machine 1
- electric guitar solo 1
- electronic music 1
- emotional 1
- funky bass lines 1
- indian music 1
- instrumental 1
- intense 1
- intense drumming 1
- layers building gradually 1
- lively 1
- male singer 1
- male vocalist 1
- medium tempo 1
- oud 1
- oud riff 1
- percusssion 1
- pop rap 1
- pulsating 1
- rap hits 1
- recurring beat 1
- rhythmic patter 1
- rhythmic speech 1
- rich 1
- rising tempo 1
- slangy lyrics 1
- slow tempo 1
- sonic delight 1
- story telling 1
- street rapper 1
- street vernacular 1
musiccaps_names (array) 4 ✖
- Music 3
- Jazz 1
- Rhythm and blues 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lately (Official Music Video) | A male vocalist sings this mellow rap. The tempo is medium with a groovy bass line, keyboard harmony , slick drumming and vocal backup. The song is youthful, story telling, passionate, impactful, compelling and engaging. This song is contemporary Hip-Hop/Rap. | 2016-04-16T18:42:59Z | Official Lobo | Song: Lately Artist: Lobo Directed/Produced/Edited by: Lobo Shot by: CHRIS Kai Bordenave Lobo | ["Music", "Tender music"] | ["male singer", "slow tempo", "funky bass lines", "intense drumming", "synthesiser arrangements", "vocal backup", "hip-hop", "rap", "pop rap", "hip-hop hits", "disco rap", "rhythmic speech", "story telling", "passionate", "emotional", "persuasive", "compelling", "engaging", "persuasive", "youthful"] | 7 | 0Ubu4BqSWmU | 174 | |
Moray Naina | Zara Madani | Season 6 | Coke Studio Pakistan | This music is an electric guitar solo. The tempo is medium fast with rhythmic bongo , atmospheric synthesiser, soft drumming with Cymbal rides, oud riff and keyboard harmony. The music is densely layered. It is soothing, engaging, compelling, mesmerising and building up gradually. This music is Contemporary Indian Pop. | 2014-01-04T18:56:21Z | Rohail Hyatt | Produced by Rohail Hyatt https://www.facebook.com/rohail.hyatt.public | ["Jazz", "Music"] | ["instrumental", "electric guitar solo", "oud riff", "indian music", "contemporary indian pop", "coke studio", "oud", "congas", "bongos", "cymbal ride", "synthesiser arrangements", "atmospheric synthesiser", "pulsating", "rising tempo", "layers building gradually", "intense", "dense layers", "rich", "sonic delight", "percusssion", "lively", "engaging", "compelling"] | 7 | OjEG808MfF4 | 2462 | |
Pete Kolo Feat Chop Chop - "Help Wanted" | A male vocalist sings this spirited rap. The tempo is medium with keyboard accompaniment, digital drums,electric guitar riff and synthesiser arrangements with vocal backup. The song is passionate, compelling, strong telling, chanting, persuasive and youthful. This song is Contemporary Rap-Hip-Hop. | 2012-09-11T19:47:40Z | 2beyond1 | #Theanbm Pete Kolo releases single "Help wanted" ft. Chop Chop #SOB Anbm.inc@gmail.com @Theanbm @PeteGotBeats @ChopChop_SOB Director: @Stedy4dog , 2DCProductions | ["Music", "Rhythm and blues"] | ["male vocalist", "medium tempo", "rap", "rap hits", "digital drum", "youthful", "street rapper", "disco rap", "hip-hop", "hip-hop hits", "rhythmic patter", "electronic music", "drum machine", "synthesiser arrangements", "vocal backup", "passionate", "engaging", "compelling", "persuasive", "street vernacular", "slangy lyrics", "chanting", "recurring beat", "amplified guitar"] | 7 | SxYnb9_qDtk | 2800 |
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;