musiccaps_details (view)
2 rows where musiccaps_aspects contains "mystical", musiccaps_aspects contains "slow tempo" and musiccaps_aspects contains "vocalisation"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- celestial 2
- enigmatic 2
- mystical · 2 ✖
- slow tempo · 2 ✖
- vocalisation · 2 ✖
- angelic 1
- choral symphony 1
- classical music 1
- dreamy 1
- emotional 1
- enchanting 1
- ethereal 1
- female singer 1
- flute harmony 1
- harmony 1
- harp 1
- heavenly 1
- instrumental 1
- magical 1
- magicalvocalisation 1
- melancholic 1
- mellifluous dulcet 1
- mellow 1
- melodic piano accompaniment 1
- middle eastern music 1
- middle eastern stringed instrument 1
- ost 1
- pensive 1
- pleasant 1
- sentimental 1
- soft 1
- soft piano 1
- soothing 1
- soundtrack 1
- steady bass line 1
- vocal harmony 1
- western classical 1
- wistful 1
musiccaps_names (array) 3 ✖
- Music 2
- New-age music 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tokyo Ghoul - Soundtrack [OST] Battle Theme (Symphony) | This song is an operatic harmony. The tempo is slow with a soft piano accompaniment and choral vocal harmony. The song is soft, melodic, enigmatic, ethereal, mystical, magical, dreamy and enchanting. This music is a Choral Symphony. | 2014-08-27T04:06:05Z | DarkVul | ["New-age music", "Music"] | ["instrumental", "slow tempo", "choral symphony", "soft piano", "vocalisation", "magical", "enchanting", "dreamy", "magicalvocalisation", "vocal harmony", "classical music", "western classical", "ethereal", "enigmatic", "celestial", "angelic", "heavenly", "mystical", "mellow", "soft", "soothing", "harmony", "soundtrack", "ost", "melancholic", "emotional", "sentimental", "pensive", "wistful"] | 7 | 63jbksEqycQ | 720 | ||
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;