musiccaps_details (view)
2 rows where musiccaps_aspects contains "percussion" and musiccaps_author = 2
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- instrumental 2
- no voice 2
- percussion · 2 ✖
- atmospheric 1
- bell-like sound 1
- brass 1
- clarinet 1
- double bass 1
- flutes 1
- reverb effect 1
- strings 1
musiccaps_names (array) 3 ✖
- Music 2
- Ambient music 1
- Thunk 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
幾可亂真的超強手繪 ! 神人 | The instrumental music features an ensemble that resembles the orchestra. The melody is being played by a brass section while strings provide harmonic accompaniment. At the end of the music excerpt one can hear a double bass playing a long note and then a percussive noise. | 2016-04-10T21:25:56Z | AbNoRmALiTy | 他只是在手掌上 畫了個圓後再上一些色彩, 就讓人驚呆了好幾秒, 太錯亂了! 一起來看看超強的手繪立體作品吧! | ["Music", "Thunk"] | ["brass", "double bass", "strings", "instrumental", "no voice", "percussion"] | 2 | -5FoeegAgvU | 11 | |
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;