musiccaps_details (view)
4 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "mono" and musiccaps_aspects contains "passionate male vocal"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- live performance · 4 ✖
- low quality 4
- mono · 4 ✖
- noisy 4
- passionate male vocal · 4 ✖
- soulful 3
- emotional 2
- passionate 2
- traditional 2
- acoustic guitar melody 1
- alternative/indie 1
- distorted 1
- electric guitar melody 1
- groovy bass 1
- harmonizing male vocals 1
- heartfelt 1
- hopeful 1
- joyful 1
- mystical 1
- passionate background male vocal 1
- playback instrumental 1
- punchy snare 1
- shimmering tambourine 1
- soft kick hits 1
- soul 1
- suspenseful 1
- sustained accordion melody 1
- sustained suspenseful strings melody 1
- tinny percussive elements 1
- toms roll 1
- wooden percussive elements 1
musiccaps_names (array) 10 ✖
- Music 3
- /t/dd00003 1
- Carnatic music 1
- Guitar 1
- Musical instrument 1
- Percussion 1
- Plucked string instrument 1
- Singing 1
- Tabla 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Thom Yorke -Radiohead- Reckoner at The Age Of STuPid premiere 2009-09-21 | The low quality recording features a live performance of an alternative/indie song, sung by passionate male vocalists over an acoustic guitar melody. It sounds passionate, emotional and heartfelt. The recording is noisy and in mono. | 2009-09-22T04:02:18Z | allbearsrule | enjoy everyone.... I tried the best I could with the opportunities provided... :-) watch in HQ! And PLEASE try to find and watch a movie. It is a must-see. | ["Singing", "Guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["low quality", "alternative/indie", "live performance", "passionate male vocal", "acoustic guitar melody", "noisy", "mono", "emotional", "passionate", "heartfelt"] | 4 | TLMEsc_42Gw | 2832 | |
New York Subway's Danny Small aka Singing Dragon | The low quality recording features a live performance of a soul song and it consists of passionate male vocal singing over playback instrumentals. The instrumental consists of a shimmering tambourine layered with punchy snare hits, soft kick hits, some toms rolls, groovy bass, electric guitar melody and harmonizing male vocals. It sounds emotional, soulful, hopeful and joyful. | 2010-03-07T21:11:15Z | BayardStudios | He calls himself the "Singing Dragon", his name is Mitchell Hughes aka Danny Small of Gheechee Records LLC aka the Singing Dragon and he was performing at the 14th St/6th Ave station. Originally from South Carolina, there is logic to the moniker Singing Dragon, he was born the same year as Bruce Lee in the Chinese calendar year of the Dragon, of Puerto Rican, Dominican, Cuban, Brazilian, Mexican and Guyanese and even Chinese descent. A marvel amongst subway performers, what a wonderful way to end a walkabout. Shot with a Canon 5D Mark II, Canon 16-35mm f/2.8L, recorded with the in-camera mic and moderately mixed in Final Cut Pro 6. | ["Music", "/t/dd00003"] | ["low quality", "live performance", "noisy", "mono", "passionate male vocal", "soul", "playback instrumental", "shimmering tambourine", "punchy snare", "groovy bass", "electric guitar melody", "soft kick hits", "toms roll", "harmonizing male vocals", "emotional", "hopeful", "joyful", "soulful"] | 4 | l1coM570kVw | 4370 | |
Satypal Maharaj Kirtan | सत्यपाल महाराज कीर्तन | Zee Marathi Awards 2010 | Zee Marathi | The low quality recording features a live performance of a traditional song and it consists of passionate male vocal, alongside passionate background male vocal singing over sustained accordion melody and some tinny percussive elements. Even though it is a bit distorted, mono and noisy, it still sounds soulful. | 2010-11-01T13:24:25Z | Zee Marathi | Satypal Maharaj Kirtan | सत्यपाल महाराज कीर्तन | Zee Marathi Awards 2010 | Zee Marathi Free Subscription click here : http://bit.ly/SubscribeZeeMarathi Get notified about our Latest update by Clicking the Bell Icon 🔔 Award Shows Paid Subscription #Zee5 click here: https://bit.ly/32gxIJ4 To #Free #Download ZEE5 #Mobile app click the link below Playstore: http://bit.ly/Zee5PlayStore iTunes: http://bit.ly/Zee5ITunes Connect with Zee Marathi on Social Media Facebook - http://bit.ly/ZeeMarathiFb Instagram - http://bit.ly/ZeeMarathiInsta Twitter - http://bit.ly/ZeeMarathiTwitter Connect with Zee5 on Social Media Facebook : http://bit.ly/Zee5MarathiFB Instagram : http://bit.ly/Zee5MarathiInsta Twitter : http://bit.ly/Zee5MarathiTwitter | ["Carnatic music", "Music"] | ["traditional", "live performance", "passionate male vocal", "sustained accordion melody", "low quality", "tinny percussive elements", "passionate background male vocal", "noisy", "mono", "distorted", "soulful"] | 4 | pzm90xLX9HM | 4747 | |
Great Ghazal Singer Ahmad Wali with Siar Hashimi on Tabla | The low quality recording features a live performance of a traditional song that consists of wooden percussive elements, sustained suspenseful strings melody and passionate male vocal singing over it. It sounds passionate, mystical, soulful and suspenseful, even though the recording is a bit noisy and in mono. | 2009-03-05T15:38:49Z | TaalPanchamSawari | Ghazal Tabla: Siar Hashimi Taal: Kehrwa | ["Tabla", "Percussion"] | ["mono", "noisy", "low quality", "traditional", "live performance", "wooden percussive elements", "sustained suspenseful strings melody", "passionate male vocal", "soulful", "passionate", "mystical", "suspenseful"] | 4 | yx7BZ_djE-U | 5449 |
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;