musiccaps_details (view)
2 rows where musiccaps_aspects contains "percussion" and musiccaps_names contains "Thunk" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- percussion · 2 ✖
- acoustic guitars 1
- brass 1
- double bass 1
- e-bass 1
- folklore/country 1
- foreground-noises 1
- instrumental 1
- latin/spanisch 1
- medium tempo 1
- mood elevating 1
- no voice 1
- strings 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Manejo Racional de Bovinos de Corte | This song contains three guitars playing chords, and two melodies while one of the guitars stands out to be playing the main melody. The guitars are panned to the left and the right side of the speakers. An e-bass is playing a walking line that repeats itself. Different percussive instruments are panned to the left and right side of the speakers. There are some noises of doors opening and closing that I think do not belong to the musical composition and they sound in the foreground. This song may be playing in a house in the countryside. | 2014-02-20T18:54:49Z | Adriana Albuquerque | ["Music", "Thunk"] | ["latin/spanisch", "folklore/country", "acoustic guitars", "percussion", "foreground-noises", "e-bass", "mood elevating", "medium tempo"] | 6 | HYjSrwSm0T4 | 1814 | ||
幾可亂真的超強手繪 ! 神人 | 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 |
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;