musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic", musiccaps_aspects contains "mellow female vocal", musiccaps_aspects contains "wide synth pad chords" and musiccaps_names contains "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 |
---|---|---|---|---|---|---|---|---|---|---|
Mantra for Compassion and Healing - Guru Ram Das Chant by Mirabai Ceiba | The Acoustic song features an arpeggiated acoustic melody, wide synth pad chords, soft bass guitar, mellow synth keys melody, soft percussive drums loop and mellow female vocal singing on top. It sounds very relaxing and calming - almost like you can do yoga to it. | 2012-10-09T18:43:25Z | Mirabai Ceiba | This mantra relates directly to healing and protective energy of the heart chakra. It is a mantra of humility, relaxation and self healing. It projects the mind to infinity, and opens the space to be guided from the heart and compassion. Find out more about Mirabai Ceiba: https://www.mirabaiceiba.com TOUR DATES: https://www.mirabaiceiba.com/events/concerts-workshops/ | ["Mantra", "Chant", "Music"] | ["acoustic", "arpeggiated acoustic guitar melody", "wide synth pad chords", "soft bass guitar", "soft percussive drums loop", "mellow female vocal", "calming", "relaxing", "mellow synth keys"] | 4 | LbQ4zHxhoSI | 2207 |
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;