musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "atmospheric synthesiser", musiccaps_author = 7 and musiccaps_names contains "Jazz"
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- atmospheric synthesiser · 2 ✖
- auto tune 1
- bongos 1
- boomy bass drops 1
- bouncy 1
- buoyant 1
- club music 1
- coke studio 1
- compelling 1
- congas 1
- contemporary indian pop 1
- cymbal ride 1
- dance groove 1
- dance hits 1
- dance music 1
- dense layers 1
- digital drumming 1
- dj 1
- electric guitar solo 1
- engaging 1
- fast tempo 1
- female singer 1
- groovy acoustic guitar accompaniment 1
- heavy reverb 1
- indian music 1
- instrumental 1
- intense 1
- layers building gradually 1
- lively 1
- oud 1
- oud riff 1
- percusssion 1
- pulsating 1
- punchy 1
- rich 1
- rising tempo 1
- slick drumming 1
- sonic delight 1
- spirited 1
- synthesised vocals 1
- synthesiser arrangements 1
- vocal backup 1
- youthful 1
musiccaps_names (array) 3 ✖
- Jazz · 2 ✖
- Music 2
- Dance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sandra Lyng - Electric City (Official Music Video) | A female vocalist sings this spirited pop. The tempo is fast with a spirited, upbeat acoustic guitar accompaniment, synthesiser arrangements, slick drumming, digital drum rhythm, boomy bass drop , added reverb and auto tune for better effects.The song is young, fresh, upbeat, bouncy, punchy, and has a dance groove.this song is a synth pop. | 2014-08-15T16:57:07Z | Sandra Lyng | Offisiell musikkvideo til "Electric City", den nye singelen til Sandra Lyng. Electric City er tilgjengelig på alle digitale plattformer, last ned og stream singelen her: - iTunes: https://itunes.apple.com/no/album/electric-city-single/id893197707?l=nb - Spotify: http://open.spotify.com/album/27Axz7vCZGIw1w1bQgqtIP - Wimp: http://wimp.no/album/31787918 - SoundCloud: https://soundcloud.com/sandra-lyng/sandra-lyng-electric-city | ["Jazz", "Music", "Dance music"] | ["female singer", "fast tempo", "auto tune", "boomy bass drops", "slick drumming", "digital drumming", "dj", "dance hits", "dance music", "club music", "dance groove", "groovy acoustic guitar accompaniment", "atmospheric synthesiser", "synthesised vocals", "vocal backup", "heavy reverb", "punchy", "bouncy", "youthful", "buoyant", "boomy bass drops", "spirited"] | 7 | 33dCbb1MyYU | 439 | |
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;