musiccaps_details (view)
2 rows where musiccaps_aspects contains "common sounding" and musiccaps_aspects contains "tutorial"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- common sounding · 2 ✖
- tutorial · 2 ✖
- acoustic drums 1
- electric guitar 1
- electronic drums 1
- electronic music 1
- generic 1
- instructive 1
- loud 1
- male voice 1
- pitch shifting 1
- rock music 1
- snare drum 1
- sound effects 1
- synth 1
- teaching 1
- underwater 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Water Wolf Camera Tutorial | This is a rock music piece playing in the background of a tutorial video. There is an electric guitar playing a simple tune as the lead while another provides a rhythmic backing by playing the same note repeatedly in rapid procession. There is an acoustic drum beat playing. There are water sound effects related to the video. The piece has a generic feeling. It does not evoke much excitement. It could be used as a jingle for an advertisement or in the background of an instructive video. | 2014-06-27T08:50:52Z | Savage Gear | ["Music", "Gurgling"] | ["rock music", "tutorial", "electric guitar", "acoustic drums", "sound effects", "underwater", "loud", "generic", "common sounding"] | 9 | -taO6N-rxv4 | 96 | ||
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 |
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;