musiccaps_details (view)
1 row where musiccaps_aspects contains "atmospheric", musiccaps_aspects contains "clarinet" and musiccaps_aspects contains "no voice"
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 |
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;