musiccaps_details (view)
3 rows where musiccaps_aspects contains "echoing passionate male vocal" and musiccaps_author = 4 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- echoing passionate male vocal · 3 ✖
- low quality 3
- folk 2
- passionate 2
- acoustic guitar melody 1
- build up 1
- crowd cheering 1
- electro pop 1
- emotional 1
- energetic 1
- exciting 1
- groovy synth keys chord progression 1
- joyful 1
- live performance 1
- mellow organ keys chords 1
- mono 1
- punchy snare 1
- reversed crash riser 1
- sitar melody 1
- snare roll 1
- sustained strings melody 1
- whistling 1
- wide laser synth 1
musiccaps_names (array) 5 ✖
- Music 3
- Disco 1
- Middle Eastern music 1
- Music of Asia 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Toshi - Piya Re (UKU) | The low quality recording features a live performance of a folk song that consists of an echoing passionate male vocal singing over sustained strings melody, acoustic guitar melody and some crowd cheering and whistling sounds in the background. It sounds joyful, passionate and emotional overall. | 2009-04-12T19:01:17Z | MariumSaeed | ["Singing", "Music of Asia", "Music"] | ["low quality", "folk", "live performance", "echoing passionate male vocal", "sustained strings melody", "acoustic guitar melody", "crowd cheering", "whistling", "joyful", "passionate", "emotional"] | 4 | e1PG31QlQmc | 3836 | ||
haider hasan nizami qawwal kalam nagpur ki hu jan baba tajuddin | The low quality recording features a folk song sung by passionate echoing male vocals over mellow organ keys, chords and sitar melody. It sounds narrow, because it was recorded with a mono microphone setup, but it is also very passionate, regardless. | 2012-04-25T12:50:36Z | asim imran | haider hasan nizami kalam nagpur ki hu jan baba tajuddin | ["Music", "Middle Eastern music"] | ["folk", "echoing passionate male vocal", "sitar melody", "mellow organ keys chords", "low quality", "passionate", "mono"] | 4 | kbquMoJrhC0 | 4335 | |
Maroon 5 - Sugar (Karboncopy Remix) [Premiere] | The low quality recording features an electro pop song that consists of an echoing passionate male vocal singing over groovy synth keys chord progression, punchy snare hits, followed by snare roll, wide laser synths and reversed crash riser. It sounds exciting and energetic - like a build up section of the song. | 2015-04-22T16:00:01Z | Proximity | •Proximity - Your favorite music you haven't heard yet. » Facebook: http://bit.ly/FBProximity » Twitter: http://bit.ly/ProximityTwitter I love the original track. Vocals are super catchy and Adam Levine is a great singer. When Karboncopy approached me with this remix remix I instantly fell in love with it. Hope you guys enjoy this one as always! :) •Maroon 5: http://www.maroon5.com/v-tour https://www.facebook.com/maroon5 https://twitter.com/maroon5 •Karboncopy: https://soundcloud.com/karboncopy https://www.facebook.com/karboncopyofficial https://twitter.com/!/KarbonCopy Picture by: https://www.behance.net/boksysocks If you'd like to submit a picture, you can send it here: http://pandoric.com/contact Use the new template if you would like to submit a picture! :) http://goo.gl/yoEGNg | ["Disco", "Music"] | ["low quality", "electro pop", "punchy snare", "wide laser synth", "snare roll", "echoing passionate male vocal", "groovy synth keys chord progression", "reversed crash riser", "exciting", "energetic", "build up"] | 4 | 0q-80dzp6PU | 212 |
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;