musiccaps_details (view)
3 rows where musiccaps_aspects contains "snare drum", musiccaps_author = 9 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- snare drum · 3 ✖
- acapella 1
- backing track 1
- bass guitar 1
- boing 1
- brass 1
- brush 1
- cartoon 1
- cheerful 1
- common sounding 1
- conversation 1
- eerie 1
- electronic drums 1
- electronic music 1
- female synth vocal 1
- finger click 1
- flute 1
- generic 1
- harmony singing 1
- instructive 1
- korean language 1
- male child voices 1
- male voice 1
- pitch shifting 1
- sound effects 1
- spring sound 1
- swing jazz 1
- synth 1
- teaching 1
- trumpet 1
- tutorial 1
- upbeat 1
- vocaloid 1
musiccaps_names (array) 10 ✖
- Music · 3 ✖
- A capella 1
- Boing 1
- Child speech, kid speaking 1
- Drum machine 1
- Drum roll 1
- Happy music 1
- Music for children 1
- Speech 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Logic Pro X Tutorial: PITCH SHIFT DRUM ROLL | This is a music production tutorial video. There is a male voice teaching a sound design technique. There is an electronic snare drum beat speeding up with a shifting pitch. A simple synth tune is playing in the background. The sounds used in the video are very common, so it would not be worth the hassle to sample these sounds. Instead, parts of the track could be used in advertisement jingles. | 2014-06-17T06:21:56Z | Recording Connection Audio Institute | http://www.recordingconnection.com Learn how to do a pitch shift drum roll in Logic Pro X in just about 5 minutes with this easy to follow, informative tutorial. | ["Drum roll", "Music", "Drum machine"] | ["tutorial", "instructive", "electronic music", "male voice", "teaching", "electronic drums", "snare drum", "pitch shifting", "synth", "common sounding"] | 9 | bpaq5wQKOkU | 3654 | |
딸한테 아카펠라를 시켰다 | This is an acapella version of a swing jazz music piece that was performed with various layers of a vocal synth software called vocaloid. Three different harmonies can be heard from this vocal synth. There is a bass guitar playing a walking bass line in the background. The rhythmic background consists of finger clicks and a swing jazz beat performed with brushes on a snare drum. The atmosphere is cheerful but eerie. This piece could be used in the soundtrack of an arcade/analog type video game. It could also work well in the soundtrack of an anime. | 2015-09-25T14:24:08Z | Rain Silver | http://tvple.com/350077 http://www.nicovideo.jp/watch/sm25083117 | ["Music", "Vocal music", "A capella", "Happy music"] | ["acapella", "vocaloid", "swing jazz", "female synth vocal", "harmony singing", "bass guitar", "finger click", "snare drum", "brush", "eerie", "cheerful", "upbeat"] | 9 | nYO8n62Piys | 4550 | |
MBC 똑똑 키즈스쿨, 64회 음식을 골고루 먹어요 (애니메이션) | These are sounds coming from a cartoon. Two boys are having a conversation in the Korean language. There is a spring sound effect that can be heard repeatedly. In the background, a generic orchestra piece is playing. The trumpet and the flute take turns in playing the main melody while other brass instruments and a snare drum accompanies them. | 2014-04-18T03:31:01Z | okman | '엄지맨과 함께하는 놀이 체육' 엄지맨과 함께하는 몸과 마음이 튼튼해지는 체육 시간. 몸이 튼튼해지려면 어떻게 해야 할까? 엄지맨과 함께 과일과 채소를 나르는 운동을 하면서 편식하지 않고 골고루 먹는 습관을 배워요 | ["Music", "Music for children", "Speech", "Child speech, kid speaking", "Boing"] | ["cartoon", "male child voices", "conversation", "korean language", "sound effects", "spring sound", "boing", "backing track", "generic", "brass", "trumpet", "flute", "snare drum"] | 9 | yhbpAGdv_d8 | 5431 |
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;