musiccaps_details (view)
1 row where musiccaps_aspects contains "low quality", musiccaps_names contains "Singing bowl" and "youtube_published" is on date 2015-08-12
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 |
---|---|---|---|---|---|---|---|---|---|---|
Udu drum sound, koshi chimes & tibetan sound bowls relaxation asmr music 27min | Calm | The low quality recording features an ambient song that consists of a wide echoing female vocal talking over resonating bowl tone and mellow percussion. It sounds passionate, percussive and hypnotic. | 2015-08-12T15:14:54Z | Calm Whale | Calm singing bowls asmr ASMR music relaxation and meditation with tibetan singing bowls, rain stick, and udu drum. enjoy the sound, peace. Headphones or good stereo is crucial for You to fully feel the asrm vibrations and space. No talking. Koshi bells at 24:15. For dedicated koshi recording check https://youtu.be/wPg3x4Bg8IA Download HQ version : (wav/flac/mp3): http://bit.ly/1NjPq29 Subscribe: https://goo.gl/xvZCV9 Created by Calm Whale Copyright ⓒ 2015 by Calm Whale. All Rights Reserved. | ["Singing bowl"] | ["low quality", "ambient", "wide echoing female vocal", "resonating bowl tone", "mellow percussions", "calming", "percussive", "hypnotic"] | 4 | BVt8RgNrwbQ | 1247 |
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;