musiccaps_details (view)
3 rows where musiccaps_aspects contains "male voice singing" and musiccaps_aspects contains "tambourine"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- male voice singing · 3 ✖
- tambourine · 3 ✖
- acoustic drums 1
- acoustic guitar 1
- acoustic piano 1
- bongos 1
- brass section 1
- cajon 1
- e-bass 1
- e-guitar 1
- hindi 1
- horn 1
- medium to uptempo 1
- piano 1
- pop 1
- r&b/soul 1
- slow tempo 1
- string instruments 1
- tablas 1
- uptempo 1
musiccaps_names (array) 10 ✖
- Music 2
- Brass instrument 1
- Carnatic music 1
- French horn 1
- Music of Bollywood 1
- Musical instrument 1
- Reggae 1
- Sitar 1
- Song 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Coldplay - Hurts like Heaven (cover) | This audio contains someone playing an acoustic piano along with an acoustic guitar strumming chords. Someone is playing a cajon with a fast paced groove and a tambourine. A horn takes the main melody in the midrange along with a male voice singing in a higher key. This song may be playing on the streets performed by buskers. | 2012-02-10T14:22:31Z | Retalianist | Here's our latest cover, this time it's Hurts like Heaven by Coldplay and we brought the brass! It was rehearsed and shot in a couple of hours. Singing is too low but... enjoy anyway! Sheet Music : http://on.fb.me/13Y9f2G Shot and directed by Charlotte Audureau http://www.shuud.book.fr/ With Romain Olivieri, Nicolas Molac, Edward Vizard, Clément Charpentier-Leroy, Gautier Demollière and Pierre Lesmarie http://www.weareelessar.com http://www.myspace.com/astrazz | ["Brass instrument", "French horn"] | ["pop", "acoustic piano", "cajon", "horn", "acoustic guitar", "male voice singing", "tambourine", "uptempo"] | 6 | QDTCAxyXt80 | 2605 | |
Ghungroo Toot Gaye گھنگرو ٹوٹ گئے | Someone is playing tablas and a tambourine along with string instruments playing a melody in the background. The male higher register voice is singing the same melody as the string instruments. This song may be playing in an old hindi movie-scene. | 2011-10-13T09:44:00Z | Shahid Riaz | Poet: Qateel Shifai - شاعر: قتیل شفائی Singer: Ustad Raees Khan - گلوکار: استاد رئیس خان موہے آئی نہ جگ سے لاج میں اتنی زور سے ناچی آج کہ گھنگرو ٹوٹ گئے کچھ مجھ پہ نیا جوبن بھی تھا کچھ پیار کا پاگل پن بھی تھا اک پلک پلک بنی تیر مری اک زلف بنی زنجیر مری لیا دل ساجن کا جیت وہ چھیڑے پالیا نے گیت کہ گھنگرو ٹوٹ گئے میں بسی تھی جس کے سپنوں میں وہ گنے گا اب مجھے اپنوں میں کہتی ہے مری ہر انگڑائی میں پیا کی نیند چرا لائی میں بن کے گئی تھی چور کہ میری پائل تھی کمزور کہ گھنگرو ٹوٹ گئے دھرتی پہ نہ میرے پیر لگیں بن پیا مجھے سب غیر لگیں مجھے انگ ملے پروانوں کے مجھے پنکھ ملے ارمانوں کے جب ملا پیا کا گاؤں تو ایسا لچکا میرا پاؤں کہ گھنگرو ٹوٹ گئے | ["Carnatic music", "Music", "Music of Bollywood", "Sitar"] | ["hindi", "tablas", "tambourine", "male voice singing", "string instruments", "slow tempo"] | 6 | doX8FjlNPf8 | 3814 | |
ARCHIE BELL & THE DRELLS - DANCING TO YOUR MUSIC (GLADES) | This song contains acoustic drums playing a groove along with an e-bass and a tambourine. A brass section is playing along with the drum fills and the bongos. A piano is playing a melody together with a guitar strumming chords in the mid range. The male singer sounds loud and soulful. This song may be playing in a rollerblade disco. | 2011-09-16T12:58:50Z | EddiesSoulSounds | More early 70's brilliance. This one from Texas giants Archie and the Drells who released this cracking mid-tempo dancer on the Miami based Gllades label from 1972. Great stuff! | ["Swing music", "Music", "Musical instrument", "Reggae", "Song"] | ["r&b/soul", "e-bass", "brass section", "e-guitar", "bongos", "acoustic drums", "male voice singing", "tambourine", "piano", "medium to uptempo"] | 6 | vx5iuWuE2Ng | 5220 |
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;