musiccaps_details (view)
2 rows where musiccaps_aspects contains "mellow" and musiccaps_aspects contains "warm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- mellow · 2 ✖
- warm · 2 ✖
- acoustic guitar 1
- buttons tapping 1
- charming 1
- colourful 1
- cover 1
- dreamy 1
- emotional 1
- female vocalisation 1
- instrumental 1
- keyboard accompaniment 1
- poignant 1
- romantic 1
- saxophone melody 1
- sentimental 1
- slow tempo 1
- soft 1
- tutorial 1
- violin harmony 1
- vocalisation 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Alto Sax - How to Play ROAR (Katy Perry) | The recording features a tutorial for a cover of a pop song and it consists of a saxophone melody alongside some buttons tapping noises. It sounds warm and mellow. | 2014-03-06T17:46:07Z | Dr. Selfridge Music | Welcome to the Dr. Selfridge Music channel! Here's a lesson on how to play the song "ROAR" by Katy Perry. To skip to the full performance of the song, go to 7:02 Hope you find this tutorial helpful! Many more available here at the Dr. Selfridge Music channel - please subscribe and visit our website: https://www.drselfridgemusic.com/ || FOLLOW DR. SELFRIDGE || INSTAGRAM: https://www.instagram.com/dr.selfridge/ Subscribe to Dr Selfridge Music: https://www.youtube.com/channel/UCqipAeDrpKzXr7wR3yl6vVw?sub_confirmation=1 Facebook: https://www.facebook.com/DrSelfridge/ Twitter: https://twitter.com/drselfridge Help Dr. Selfridge create more great content: https://www.patreon.com/DrSelfridge NOTES Part 1 D D B B A A G G DDD B B A A G G G G A B D B G G A B D B (repeat) Part 2 D E D B D E D E DD BB D E D D E D B D E D E D BB A GG D E D B D E D E DD BB D E D D E D B D E D Part 3 DDDD E GG (high) E G E GG E D G E G E G E D G A B A E D G----- Part 4 D E G G G G G ED D E G G G G G ED G A B A E D G------- | ["Brass instrument", "Saxophone", "Wind instrument, woodwind instrument"] | ["tutorial", "buttons tapping", "saxophone melody", "cover", "mellow", "warm"] | 4 | C6ws4MxOH2Y | 1332 | |
MAYA AND SIR CHIEF'S LOVE STORY PART 2 August 2012 Episodes | This music is instrumental. The tempo is slow with an emphatic violin harmony, keyboard accompaniment and rhythmic acoustic guitar with female vocalisation. The song is romantic, sentimental, emotional, nostalgic, poignant, charming, dreamy and soft. | 2012-12-16T04:10:01Z | yean Sagala | ["Music", "Sad music"] | ["instrumental", "slow tempo", "vocalisation", "female vocalisation", "charming", "dreamy", "poignant", "colourful", "warm", "keyboard accompaniment", "violin harmony", "acoustic guitar", "mellow", "soft", "romantic", "emotional", "sentimental"] | 7 | WNmAlKrAPjQ | 3089 |
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;