musiccaps_details (view)
2 rows where musiccaps_aspects contains "melancholic" and musiccaps_names contains "Middle Eastern music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- melancholic · 2 ✖
- slow tempo 2
- arabic 1
- arabic music 1
- classical music 1
- emotional 1
- instrumental 1
- jordanian folk music 1
- lonely 1
- male vocal 1
- middle eastern music 1
- minimalist 1
- nostalgic 1
- oud melody 1
- rabab 1
- regional music 1
- sentimental 1
- solemn 1
- stringed instrument 1
- strings 1
- wistful 1
musiccaps_names (array) 4 ✖
- Middle Eastern music · 2 ✖
- Music 2
- Carnatic music 1
- Classical music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ربابه رائعه سموه سموه كلمات/ رعد الشلال اداء جمال خليف و متعب الصقار | This is a Jordanian folk music piece. There is a male vocalist singing in the Arabic language in a melancholic manner. The melody is being played at a medium range by the rabab. There is a string section backing holding a single note. The atmosphere is solemn. This piece could be playing during a mourning scene in a drama movie that takes place in the Arab world. | 2014-06-25T15:52:47Z | ahmed Nasr | ربابه رائعه سموه سموه كلمات/ رعد الشلال اداء جمال خليف و متعب الصقار | ["Carnatic music", "Music", "Middle Eastern music", "Classical music"] | ["jordanian folk music", "male vocal", "arabic", "rabab", "strings", "melancholic", "solemn", "slow tempo"] | 9 | DW7Qe-50X_A | 1487 | |
Very sad rabab music رباب by gulnoor parachinar | This music is instrumental. The tempo is slow with an Oud solo. The music is minimalist, simple, melancholic, nostalgic, emotional, wistful, pensive; poignant and intense. This is Middle Eastern classical music. | 2014-09-29T13:20:28Z | Gulfam Hussain Noor | Gulfam Hussain Noor Zeran Lalmay Parachinar Gulfam_12345@yahoo.com | ["Music", "Middle Eastern music"] | ["instrumental", "slow tempo", "oud melody", "classical music", "regional music", "arabic music", "middle eastern music", "stringed instrument", "melancholic", "lonely", "nostalgic", "sentimental", "emotional", "wistful", "minimalist"] | 7 | dSyue3RJllA | 3788 |
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;