musiccaps_details (view)
2 rows where musiccaps_aspects contains "compelling", musiccaps_aspects contains "engaging" and musiccaps_aspects contains "intense"
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- compelling · 2 ✖
- engaging · 2 ✖
- instrumental 2
- intense · 2 ✖
- rich 2
- atmospheric synthesiser 1
- bongos 1
- brass band 1
- cello 1
- classical 1
- coke studio 1
- concert 1
- conductor 1
- congas 1
- contemporary indian pop 1
- cymbal ride 1
- dense layers 1
- electric guitar solo 1
- elegant 1
- exquisite 1
- fast tempo 1
- flute 1
- french horn 1
- full bodied 1
- indian music 1
- layers building gradually 1
- live audience 1
- live performance 1
- lively 1
- lively trumpets 1
- orchestra 1
- oud 1
- oud riff 1
- percusssion 1
- pulsating 1
- rising tempo 1
- smooth 1
- sonic delight 1
- synthesiser arrangements 1
- trombone 1
- vigorous 1
- vigorous clarinet solo 1
- violins 1
- western classical 1
- wind instrument 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 | |
Claude Debussy Premiere Rhapsodie performed by Hakan Rosengren | This music is a Western Classical Instrumental. The music is fast tempo with a plethora of instrumentation. From a vigorous clarinet solo, flute, intense trumpets , violin symphony, cello, viola and French horns, this music is a treat to the ears. It is smooth, rich, full bodied, exquisite and elegant with an urgent and sombre vibe. | 2011-04-05T02:40:59Z | MyFullertonAccount | Hakan Rosengren in a live performance with Minas Gerais Symphony conducted by Marcelo Ramos | ["Brass instrument", "Clarinet", "Trombone"] | ["instrumental", "fast tempo", "orchestra", "live performance", "concert", "live audience", "full bodied", "exquisite", "rich", "smooth", "elegant", "vigorous clarinet solo", "wind instrument", "violins", "lively trumpets", "brass band", "french horn", "conductor", "trombone", "flute", "cello", "classical", "western classical", "intense", "vigorous", "engaging", "compelling"] | 7 | aPAa2sfhS7k | 3535 |
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;