musiccaps_details (view)
1 row where musiccaps_aspects contains "lullaby music", musiccaps_author = 3 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 |
---|---|---|---|---|---|---|---|---|---|---|
"Christmas Music 2014": BABY SONGS, lullabies for children to go to sleep on xmas holidays | The song feels relaxing, soothing and gentle. It feels like the kind of music that you would play if you wanted to fall asleep. It features a gentle and dainty electric piano with a flanger, as well as a sustained synth pad. | 2013-12-19T01:00:00Z | Relax River - Relaxation Flows in You | ► please sub http://www.youtube.com/subscription_center?add_user=relaxriverofficial What is the best time to enjoy family and be together? The Christmas holidays, which can be enlivened with the best music for holidays. We wish you a merry (and relaxing) Christmas. ...more great relaxing music to come! Relaxriver provides you music for relaxation, study and meditation. We are a collective of musicians who compose calming music for passion, everyday. We hope that what we like is exactly what you like: using music to free our minds, reach a state of peaceful joy and soothingness. With our relaxing music you can afford mental and physical relief, motivate yourself, sleep better, chill, free yourself from fears and anxiety, and restore selfconfidence. Relaxriver: your daily stream of wellness. Are you feeling comfy now? You can find us also on twitter: http://twitter.com/relax_river | ["New-age music", "Music", "Ambient music"] | ["soothing", "calming", "gentle", "meditation music", "sleeping music", "relaxing music", "lullaby music", "atmospheric angelic synth", "high pitched wobbly synth", "flanger"] | 3 | YlV45uBUVBc | 3309 |
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;