musiccaps_details (view)
2 rows where musiccaps_aspects contains "engaging", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "oud"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- engaging · 2 ✖
- instrumental · 2 ✖
- oud · 2 ✖
- atmospheric synthesiser 1
- bongos 1
- coke studio 1
- compelling 1
- congas 1
- contemporary indian pop 1
- cymbal ride 1
- dense layers 1
- electric guitar solo 1
- hindustani music 1
- indian classical 1
- indian classical instruments 1
- indian music 1
- intense 1
- layers building gradually 1
- lively 1
- lute 1
- medium tempo 1
- mesmerising 1
- oud riff 1
- pakistani music 1
- percusssion 1
- pulsating 1
- raga 1
- rich 1
- rising tempo 1
- sarod harmony 1
- skilful musicians 1
- sliding pitches 1
- sonic delight 1
- stringed instrument 1
- sympathetic strings 1
- synthesiser arrangements 1
musiccaps_names (array) 7 ✖
- Music 2
- Guitar 1
- Jazz 1
- Musical instrument 1
- Percussion 1
- Tabla 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Daud Khan Sadozai - live - 2013 | This music is a mellifluous Indian classical instrumental. The tempo is fast with a harmonic sarod and rhythmic Oud accompaniment. The music is mesmerising, spirited, engaging, captivating and skilfully rendered Ragas. This instrumental is an Indian/Pakistani classical music. | 2013-02-10T17:18:05Z | soon4ward | Daud Khan live 26-01-2013 in Hagen, Germany. Daud Khan Sadozai - Robab, Sarod Efren Lopez - Robab, Oud Yma Karin / Shekab Wadwa- Tabla | ["Tabla", "Traditional music", "Guitar", "Music", "Musical instrument", "Percussion"] | ["instrumental", "medium tempo", "sarod harmony", "oud", "hindustani music", "indian classical", "stringed instrument", "lute", "pakistani music", "mesmerising", "engaging", "skilful musicians", "raga", "sympathetic strings", "sliding pitches", "indian classical instruments"] | 7 | ALU-1AILj1c | 1107 | |
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;