musiccaps_details (view)
2 rows where musiccaps_aspects contains "atmospheric" and musiccaps_aspects contains "percussion"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Abandoned trains. Old abandoned steam engine trains in USA. Abandoned steam locomotives | The music is purely instrumental and it features an atmospheric vibe. In the beginning two or more flutes are playing melodies which are overlapping because of an added reverb effect. I believe a clarinet can be heard in one instance. Percussion drums are also present and a bell-like sound can be heard in the second half of the music excerpt. I believe the purpose of this music is to create floating vibes. | 2015-09-29T20:31:08Z | Abandoned places | I will show you awesome compilation of old abandoned steam engine trains and locomotives in USA, abandoned on old train trucks. Many of them are dying in the woods. You will see amazing train pictures. | ["Music", "Ambient music"] | ["flutes", "reverb effect", "clarinet", "percussion", "bell-like sound", "atmospheric", "instrumental", "no voice"] | 2 | BKQYrrJVg6g | 1228 | |
Sur Sudha - Bada Dashain Mangal Dhun.flv | This is a Nepali music piece. There is a string instrument and a local flute playing the melody. The rhythmic background is provided by percussion. It has a vibrant, dreamy feeling to it. This piece could be used in a dream sequence of a movie or TV show taking place in South Asian countries. | 2012-10-21T06:46:51Z | letsmoveahead | Mangal Dhun Created by Sur Sudha for great festivel Bijaya Dashami. | ["Music", "Sitar"] | ["nepali", "folk", "percussion", "flute", "strings", "eastern", "atmospheric", "dream sequence"] | 9 | h0-6U948u7Y | 4074 |
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;