musiccaps_details (view)
1 row where musiccaps_author = 0 and youtube_description = "http://www.frankperry.co.uk. Second part of a short introductory improvisation upon antique Tibetan Singing Bowls with exotic sounds of Water Bowls by Frank Perry at Aberdeen Spiritualist Church 10th October 1995 immediately prior to evening workshop"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tibetan Singing Bowls Meditation Music Part 2 | This audio clip features the sound produced at a particular frequency by a Tibetan singing bowl. This produces a continuous ringing sound. Toward the end of the clip, some other animal sounds can be heard. There are no other instruments in this song. This song can be played at a meditation center. | 2007-12-30T01:50:26Z | Frank Perry | http://www.frankperry.co.uk. Second part of a short introductory improvisation upon antique Tibetan Singing Bowls with exotic sounds of Water Bowls by Frank Perry at Aberdeen Spiritualist Church 10th October 1995 immediately prior to evening workshop | ["Singing bowl"] | ["low quality audio", "tibetan singing bowl", "animal sounds", "no other instruments", "no voices", "instrumental", "meditation music"] | 0 | -JVWfFPBl84 | 35 |
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;