musiccaps_details (view)
3 rows where musiccaps_aspects contains "mellow", musiccaps_author = 4 and musiccaps_names contains "Wind instrument, woodwind instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- mellow · 3 ✖
- buttons tapping 1
- cover 1
- echoing breathy flute melody 1
- groovy bass 1
- intense 1
- jazz 1
- low quality 1
- mono 1
- noisy 1
- passionate 1
- relaxing 1
- saxophone melody 1
- saxophone solo melody 1
- shimmering bells melody 1
- shimmering hi hats 1
- soft 1
- soulful 1
- suspenseful synth pad 1
- tutorial 1
- warm 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 | |
صوت البوق اليهودي "الشوفار" يذكر العالم ان شاليط ما زال في ا | The low quality recording features a suspenseful synth pad playing in the background and echoing breathy flute melody playing over it. It sounds intense, mellow and relaxing. | 2008-10-07T14:13:17Z | infolivetvarabic | شلومو غرونيخ الموسيقي الاسرائيلي اطلق امس مقطع موسيقي من البوق اليهودي "الشوفار" خلال اجتماع حاشد في ميدان رابين بتل ابيب حيث احتشد الالاف لطلب المغفرة جلعاد شاليط. انفولايف تيفي يعرض لكم مقاطع من الشوفار والتي نجحت في كسر الصمت القاتل ، وتوصيل الرسالة بان جلعاد شاليط ما زال أسيرا في غزة | ["Wind instrument, woodwind instrument", "Shofar"] | ["low quality", "mono", "noisy", "suspenseful synth pad", "echoing breathy flute melody", "intense", "mellow", "relaxing"] | 4 | FI_Dl0Cmd38 | 1634 | |
Blessed Relief - Frank Zappa | The Jazz song features a saxophone solo melody playing over shimmering hi hats, groovy bass and shimmering bells melody. It sounds passionate, soft, mellow and soulful. | 2007-09-16T15:33:59Z | zemoraes000 | A Tribute to Frank Zappa - Blessed Relief, one of the best songs composed by him. I took the video from "trance fusion - Chunga's Revenge" (author unknown). Awsome!!! see also: http://br.youtube.com/watch?v=smSfnpCZMeI hehehe | ["Harmonica", "Wind instrument, woodwind instrument"] | ["jazz", "groovy bass", "shimmering bells melody", "saxophone solo melody", "shimmering hi hats", "mellow", "soft", "passionate", "soulful"] | 4 | sSavMIH-e-w | 4951 |
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;