musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "congas" and musiccaps_aspects contains "lively"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 51 ✖
- congas · 3 ✖
- lively · 3 ✖
- bongos 2
- instrumental 2
- muddled audio 2
- spirited 2
- acordion melody 1
- acoustic guitar accompaniment 1
- atmospheric synthesiser 1
- cajun 1
- celebratory 1
- chatter of people 1
- cheerful 1
- classic latin songs 1
- coke studio 1
- compelling 1
- contemporary indian pop 1
- cymbal ride 1
- dance music 1
- dense layers 1
- distorted audio 1
- drums 1
- electric guitar harmony 1
- electric guitar solo 1
- engaging 1
- female singer 1
- foreign language 1
- guiro 1
- happy 1
- indian music 1
- intense 1
- keyboard accompaniment 1
- latin folk songs 1
- latin music 1
- latin percussions 1
- layers building gradually 1
- male backup 1
- medium tempo 1
- oud 1
- oud riff 1
- percusssion 1
- pulsating 1
- rich 1
- rising tempo 1
- simple 1
- sonic delight 1
- spanish music 1
- steady bass line 1
- synthesiser arrangements 1
- wind instrument harmony 1
- world music 1
musiccaps_names (array) 6 ✖
- Music 3
- Christian music 1
- Christmas music 1
- Jazz 1
- Rattle (instrument) 1
- Steelpan 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
demo kisanola | This song is an instrumental. The tempo is medium fast with enthusiastic drumming, congas and canon rhythm,electronic guitar harmony, keyboard accompaniment and a wind instrument playing a melodious harmony. There is the sound of chattering in the background. The audio is of inferior quality and muddled. The song is energetic, spirited and melodic with a catchy dance groove. | 2007-11-17T14:44:37Z | llawal41 | african men dancing like men, not women | ["Music", "Steelpan"] | ["instrumental", "distorted audio", "drums", "dance music", "wind instrument harmony", "congas", "electric guitar harmony", "keyboard accompaniment", "cajun", "lively", "spirited", "dance music", "muddled audio", "chatter of people"] | 7 | rTBQmP6Vt0g | 4878 | |
LLEGO DICIEMBRE CON SU ALEGRIA | A female vocalist sings this classic Spanish song. The tempo is medium with a lively accordion harmony, guiro , congas and bongos rhythm, steady bass line, and acoustic guitar accompaniment. The music is simple, light, happy, joyful, cheerful, celebratory and spirited with vocal backup.There are sounds of people cheering in the background. This is a Classic Latin Folk Song. | 2012-12-02T02:33:13Z | max pardo | LLEGO DICIEMBRE | ["Christmas music", "Christian music", "Music", "Rattle (instrument)"] | ["female singer", "medium tempo", "cheerful", "happy", "spirited", "celebratory", "simple", "classic latin songs", "lively", "latin folk songs", "latin percussions", "latin music", "spanish music", "guiro", "acordion melody", "foreign language", "world music", "congas", "bongos", "acoustic guitar accompaniment", "steady bass line", "male backup", "muddled audio"] | 7 | wQN7fRaPl2A | 5264 |
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;