musiccaps_details (view)
3 rows where musiccaps_aspects contains "delicate", musiccaps_author = 7 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- delicate · 3 ✖
- celestial 2
- ethereal 2
- slow tempo 2
- beautiful melody 1
- call response 1
- calming 1
- celtic folk music 1
- celtic new age 1
- chant 1
- dainty 1
- downtempo 1
- electronic 1
- emphatic 1
- enchanting 1
- enigmatic 1
- exquisite 1
- female singer 1
- foreign language 1
- harmonious singing 1
- haunting 1
- instrumental 1
- male duet 1
- meditative 1
- melancholic 1
- melancholy 1
- mellifluous 1
- mellow 1
- melodic 1
- melodious 1
- modern classical 1
- mysterious 1
- new age 1
- opera 1
- organ accompaniment 1
- percussion instrument 1
- powerful vocals 1
- ritual 1
- soft 1
- soothing 1
- sublime 1
- two part harmony 1
- vibraphone 1
- vibraphone symphony 1
musiccaps_names (array) 8 ✖
- Music · 3 ✖
- Classical music 1
- Marimba, xylophone 1
- Musical instrument 1
- New-age music 1
- Percussion 1
- Vibraphone 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Voces De Argentina for vibraphone & mallet ensemble | This music is a celestial instrumental. The tempo is slow with a symphonic harmony of the Vibraphones. The music is soft, gentle, and mellifluous with an ethereal, delicate, exquisite, elegant and beautiful sound. | 2007-07-19T21:02:00Z | TomPulse | Performed by the Mol Percussion Orchestra. Soloist:Leo Ouderits Performers: -Rudy Van der Veken -Frans Tielemans -Luc Goos -Walter Mertens -Tim Ouderits -Jean-Marie Vanbroeckhoven http://www.percussieprojecten.be http://www.myspace.com/molpercussionorchestra | ["Music", "Musical instrument", "Marimba, xylophone", "Vibraphone", "Classical music", "Percussion"] | ["instrumental", "slow tempo", "melodious", "celestial", "ethereal", "calming", "vibraphone symphony", "delicate", "exquisite", "calming", "melancholy", "dainty", "vibraphone", "percussion instrument"] | 7 | QlaW568SeDc | 2639 | |
Enya - Evening Falls | A female vocalist sings this delicate harmony. The tempo is slow with an organ accompaniment. It is soft, mellow, meditative, enigmatic, mysterious, melancholic and haunting. This song is a Modern Classical. | 2006-11-01T15:54:46Z | Servet Tonga | Evening Falls video clip | ["New-age music", "Music"] | ["female singer", "opera", "organ accompaniment", "enigmatic", "mysterious", "soft", "mellow", "ethereal", "celestial", "new age", "meditative", "modern classical", "downtempo", "electronic", "melancholic", "celtic new age", "celtic folk music", "delicate", "haunting", "sublime", "soft", "mellow", "delicate"] | 7 | _nrz_BawPMY | 3492 | |
Блаженны - Знаменный распев с исоном. | This song is a duet sung in a two part harmony in a foreign language. The tempo is slow with a male voice chanting a call to which the response is this melodious harmony. The song is soothing, calming, delicate, charming and melodic. This could possibly be a religious ritual. | 2014-01-22T17:17:01Z | Иеродиакон Герман | Московское подворье Валаамского монастыря. Божественная литургия. 22 января 2014. | ["Music", "Vocal music"] | ["male duet", "slow tempo", "two part harmony", "emphatic", "powerful vocals", "ritual", "mellifluous", "beautiful melody", "delicate", "chant", "call response", "soothing", "harmonious singing", "melodic", "enchanting", "foreign language"] | 7 | ppAT0f2YCyM | 4738 |
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;