musiccaps_details (view)
1 row where musiccaps_aspects contains "indian mystical music", musiccaps_aspects contains "santoor" and musiccaps_names contains "Outside, rural or natural"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Kerala Backwaters, India [Amazing Places 4K] | This Indian instrumental song features the main melody being played on a bowed instrument called the dilruba. This starts off by going to a higher note and then playing a descending lick. This is accompanied by a santoor playing an ascending lick. There is no percussion in this song. There are no voices in this song. This song can be played in a meditation session. | 2016-04-16T17:14:03Z | Amazing Places on Our Planet | The Kerala Backwaters are unique set of interconnected rivers, lakes and channels (natural and manmade) with total lenght of thousand miles. They are the main tourist attraction in Kerala state, and are usually explored by houseboats or tour boats. In the video - one full day/night cruise with houseboat from Kollam to Ashtamudi Lake, and one day boat trip from Kollam to Alleppey (Alappuzha). Recorded February 2016 in 4K (Ultra HD) with Sony AX100. Music: Gopal - Mystic Journey - 06 - Life Flows On Licensed via ilicensemusic.com -------------------------------------- Immerse yourself in Amazing Places on Our Planet without the distraction of words. New 4K video every Friday or every second Friday. Filmed and Edited by Milosh Kitchovitch (business inquiries: https://www.milosh9k.com/contact). YouTube: https://youtube.com/milosh9k Website: https://milosh9k.com Facebook: https://facebook.com/milosh9k Instagram: https://instagram.com/milosh9k Twitter: https://twitter.com/milosh9k More Amazing Places in 4K: https://www.youtube.com/playlist?list=PLwJH-XOKXh0g2FJ-6J5JuAowQd7R9M1lP | ["Music", "Theremin", "Outside, rural or natural"] | ["indian mystical music", "meditative music", "slow tempo", "dilruba instrument", "santoor", "indian instruments", "instrumental", "no voice", "no percussion"] | 0 | EwDiNj_5PEg | 1600 |
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;