musiccaps_details (view)
1 row where musiccaps_aspects contains "calming", musiccaps_aspects contains "german" and "youtube_published" is on date 2007-09-21
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 |
---|---|---|---|---|---|---|---|---|---|---|
Klangschalen: Reibestäbe & Schlegel | This is an educational recording. There is a male voice speaking in an instructive manner regarding numerous singing bowls in different shapes and sizes. The player hits each singing bowl while describing their feelings. The sound of the bowls could be isolated from the voice for meditation music. | 2007-09-21T18:10:42Z | billyhelga | http://www.buddhafiguren.de Klangschalen, werden mit Reibestab und Schlegel angrieben oder angeschlagen | ["Singing bowl"] | ["educational recording", "male voice", "instructive speaking", "german", "instrumental", "various singing bowls", "meditation", "calming"] | 9 | F7Y1T-rQ2JU | 1616 |
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;