musiccaps_details (view)
2 rows where musiccaps_aspects contains "engaging", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "synthesiser arrangements"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- engaging · 2 ✖
- instrumental · 2 ✖
- synthesiser arrangements · 2 ✖
- atmospheric synthesiser 1
- bongos 1
- buoyant 1
- coke studio 1
- compelling 1
- congas 1
- contemporary indian pop 1
- cymbal ride 1
- dance groove 1
- dance music 1
- dance pop 1
- dense layers 1
- digital drum beats 1
- drum machine 1
- edm 1
- elctro pop 1
- electric guitar solo 1
- electronic music 1
- electronic xylophone melody 1
- enthusiastic 1
- groovy 1
- hypnotic 1
- indian music 1
- intense 1
- layers building gradually 1
- lively 1
- medium tempo 1
- oud 1
- oud riff 1
- percusssion 1
- pulsating 1
- punchy 1
- r&b 1
- rich 1
- rising tempo 1
- sonic delight 1
- soul 1
- synth pop 1
musiccaps_names (array) 5 ✖
- Music 2
- Hip hop music 1
- Jazz 1
- Marimba, xylophone 1
- Vibraphone 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 | |
Mr. Rogers' Neighborhood - So Good in My Hood (Tribute Beat) - Raisi K. | This music is an Electronic music instrumental. The tempo is medium with synthesiser arrangements , electronic xylophone harmony and digital drum beats. The music is soothing, punchy, groovy, hypnotic and engaging. This music is Synth Pop. | 2012-03-24T20:53:58Z | RaisiM1222 | Originally inspired by NegroSaki and 01103's renditions of the theme, I decided to make a tribute myself. RIP to a legend, Mr. Fred Rogers. Enjoy! - Raisi K. | ["Music", "Marimba, xylophone", "Vibraphone", "Hip hop music"] | ["instrumental", "medium tempo", "r&b", "soul", "electronic music", "engaging", "hypnotic", "synth pop", "dance pop", "elctro pop", "synthesiser arrangements", "electronic xylophone melody", "drum machine", "digital drum beats", "punchy", "groovy", "enthusiastic", "buoyant", "dance groove", "edm", "dance music"] | 7 | oRHKVmQ138Q | 4627 |
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;