musiccaps_details (view)
5 rows where musiccaps_aspects contains "mono", musiccaps_aspects contains "passionate" and musiccaps_names contains "Middle Eastern music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- low quality 5
- mono · 5 ✖
- passionate · 5 ✖
- noisy 4
- soulful 3
- traditional 3
- emotional 2
- passionate female vocal 2
- wooden percussive elements 2
- accordion melody 1
- acoustic rhythm guitar 1
- echoing passionate male vocal 1
- flute melody 1
- folk 1
- groovy bass 1
- harmonizing male vocals 1
- harmonizing mixed vocals 1
- joyful 1
- live performance 1
- mellow organ keys chords 1
- passionate male vocal 1
- plucked strings melody 1
- shimmering shakers 1
- sitar melody 1
- strings melody 1
- sustained strings melody 1
- vintage 1
- wobble bass 1
- wooden percussions 1
musiccaps_names (array) 7 ✖
- Middle Eastern music · 5 ✖
- Music 5
- Singing 2
- Carnatic music 1
- Mantra 1
- Music of Bollywood 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
أغدا ألقاك.. أم كلثوم | The low quality recording features a traditional song that consists of passionate female vocal singing over wooden percussive elements, strings and flute melody. It sounds passionate, emotional and soulful and the recording is noisy and in mono. | 2016-04-10T21:37:36Z | shaifize | أغدا ألقاك ؟.. Om Kalthoum Song فارحم القلب الذى يصبو إليك فغداً تملكه بين يديك !! وغداً تأتلق الجنة أنهارا وظلا وغدا ننسى فلا نأسى على ماضٍ تولى وغداً نسموا فلا نعرف للغيب محلا وغداً للحاضر الزاهر نحيا ليس إلا قد يكون الغيب حلوا إنما الحاضر أحلى هكذا أحتمل العمر نعيماً وعذابا مهجة حرى وقلباً مسه الشوق فذابَ | ["Mantra", "Music", "Middle Eastern music"] | ["low quality", "traditional", "mono", "noisy", "passionate female vocal", "wooden percussive elements", "flute melody", "strings melody", "passionate", "emotional", "soulful"] | 4 | 2dyEnOo3yJ8 | 392 | |
VERY POPULAR OLD PAKISTANI PUNJABI SONG SINGER MADAM NOOR JAHAN YouTube | The low quality recording features a traditional song that consists of passionate female vocal singing over sustained string melody, wobble bass, wooden percussive elements and shimmering shakers. It is a bit noisy, in mono and it sounds vintage, passionate, emotional and soulful. | 2013-06-19T20:26:26Z | KHALIQ Husson | ["Singing", "Carnatic music", "Music", "Middle Eastern music", "Song", "Music of Bollywood"] | ["wobble bass", "wooden percussive elements", "shimmering shakers", "passionate female vocal", "sustained strings melody", "traditional", "vintage", "noisy", "low quality", "passionate", "emotional", "soulful", "mono"] | 4 | 7_Sr2zv1sQc | 862 | ||
`` Da Hujrey Mijlas `` | The low quality recording features a live performance of a traditional song that consists of harmonizing male vocals singing over plucked strings melody and wooden percussion. It sounds passionate and soulful, but the recording is very noisy and in mono. | 2009-12-19T20:50:04Z | alijk81 | `` Da Hujrey Mijlas `` | ["Music", "Middle Eastern music"] | ["low quality", "live performance", "traditional", "mono", "noisy", "wooden percussions", "plucked strings melody", "harmonizing male vocals", "passionate", "soulful"] | 4 | 8ZK1ajW598M | 930 | |
loretta lynn "when the roll is called" | The low quality recording features a passionate male vocal, alongside harmonizing mixed vocals, singing over acoustic rhythm guitar, accordion melody and groovy bass. It sounds passionate and joyful. The recording is noisy and in mono - the sound is coming from the right channel only. | 2007-07-17T06:19:50Z | lorettafan1 | with teddy and doyle and the willis brothers | ["Singing", "Music", "Middle Eastern music"] | ["low quality", "noisy", "mono", "harmonizing mixed vocals", "passionate male vocal", "accordion melody", "acoustic rhythm guitar", "groovy bass", "passionate", "joyful"] | 4 | _2P_EJsnBls | 3437 | |
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 |
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;