musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "compelling" and musiccaps_aspects contains "engaging" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 59 ✖
- compelling · 3 ✖
- engaging · 3 ✖
- instrumental 2
- synthesiser arrangements 2
- amplified guitar 1
- atmospheric synthesiser 1
- bongos 1
- chanting 1
- coke studio 1
- complex chords 1
- complex harmony 1
- congas 1
- contemporary indian pop 1
- cymbal ride 1
- dense layers 1
- digital drum 1
- disco rap 1
- drum machine 1
- electric guitar solo 1
- electronic music 1
- emphatic 1
- fast tempo 1
- funky electric guitar 1
- groovy drum rhythm 1
- hip-hop 1
- hip-hop hits 1
- hissing sound 1
- improvisations 1
- indian music 1
- intense 1
- jazz music 1
- keyboard accompaniment 1
- layers building gradually 1
- lively 1
- male vocalist 1
- medium tempo 1
- oud 1
- oud riff 1
- passionate 1
- percusssion 1
- persuasive 1
- polyrhymic 1
- pulsating 1
- punchy bass lines 1
- rap 1
- rap hits 1
- recurring beat 1
- rhythmic patter 1
- rich 1
- rising tempo 1
- shape shifting music 1
- slangy lyrics 1
- sonic delight 1
- street rapper 1
- street vernacular 1
- swing and blue 1
- syncopated music 1
- vocal backup 1
- youthful 1
musiccaps_names (array) 4 ✖
- Music 3
- Jazz 1
- Rhythm and blues 1
- Spray 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Raail Performance Coatings. Removable Automotive Paint. Liquid Wraps new solutions. Displaying spray | This music is a jazz instrumental.The tempo is fast with an animated electric guitar harmony, funky drumming, groovy bass line and keyboard accompaniment. The music is complex, engaging,emphatic, groovy and syncopated with a hissing sound in the background. | 2013-10-06T23:15:37Z | Raail Coatings | via YouTube Capture | ["Music", "Spray"] | ["instrumental", "fast tempo", "jazz music", "punchy bass lines", "funky electric guitar", "keyboard accompaniment", "hissing sound", "groovy drum rhythm", "swing and blue", "improvisations", "complex chords", "polyrhymic", "syncopated music", "shape shifting music", "complex harmony", "emphatic", "engaging", "compelling"] | 7 | pYXx0xXZiXk | 4719 | |
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 |
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;