musiccaps_details (view)
1 row where musiccaps_aspects contains "celestial", musiccaps_aspects contains "mellifluous dulcet", musiccaps_author = 7 and musiccaps_names contains "Wedding music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
arabic traditional music very soothing RUM | A female vocalist sings this ethereal melody. The tempo is slow with a beautiful flute harmony, melodious piano accompaniment, Arabic guitar and groovy bass lines. The song has no lyrics with ethereal vocalisation. It is soft, mellifluous, calming, pleasant,enigmatic, celestial and ethereal with a middle eastern feel. | 2009-04-07T18:06:11Z | detroitjeeper | song: ya mahla el fussha performed by Tarik ElNasser and RUM BAND RUM Band is a Jordanian band led by Tarik ElNasser who is a composer and a vocalist in some of his work, Rum Band might not be that famous but their work is very well known among Arabs for being the amazing soundtracks for so many big hit soap operas and TV series. | ["Music", "Wedding music"] | ["female singer", "slow tempo", "vocalisation", "middle eastern music", "pleasant", "celestial", "mellifluous dulcet", "enigmatic", "mystical", "middle eastern stringed instrument", "harp", "flute harmony", "melodic piano accompaniment", "steady bass line"] | 7 | mvZLlJpyDyc | 4501 |
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;