musiccaps_details (view)
4 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "bass" and musiccaps_aspects contains "male voice"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- amateur recording · 4 ✖
- bass · 4 ✖
- male voice · 4 ✖
- percussion 3
- distortion guitar 2
- low quality audio 2
- moderate tempo 2
- alternative rock 1
- background song 1
- dj song 1
- emotive voice 1
- guitar scratching 1
- keyboard fills 1
- programmed percussion 1
- psychedelic feel 1
- rock song 1
- shaker 1
- slow tempo 1
- synth sounds 1
- tambourine 1
- tap dance 1
- vinyl scratching 1
musiccaps_names (array) 12 ✖
- Music 4
- Electronic music 1
- Grunge 1
- House music 1
- Mouse 1
- Pulse 1
- Radio 1
- Rock music 1
- Scratching (performance technique) 1
- Singing 1
- Song 1
- Tap 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ableton Live 5.2 turntable set. 2 | This amateur recording features a vinyl scratch being played on a DJ console. This is accompanied by programmed percussion playing a simple beat at a fast tempo. The hi-hat is struck in eighth notes. The snare and kick are played in a unique pattern. A synth plays a two-note lick at different intervals. Other instruments are not audible as the audio quality is low. | 2006-07-26T17:44:13Z | Lamont Stigler | Here's an uptempo set. I'm triggering drumkits within Ableton Live 5 with the M-Audio Trigger Finger, I recorded the drums into an empty clip slot and then added layers of sound on top of the drums. I also use the crossfader within Live which is assigned to a number of tracks ...very cool feature. | ["Scratching (performance technique)", "Electronic music", "House music", "Music"] | ["amateur recording", "vinyl scratching", "programmed percussion", "bass", "synth sounds", "moderate tempo", "male voice", "dj song"] | 0 | -m5ZlWziIeA | 81 | |
Margot & the Nuclear So & So's: Quiet As A Mouse 10-16-08 | This alternative rock song features a male voice singing the main melody. This is accompanied by percussion playing a simple beat. A shaker is played on every count. At the beginning, a scratch slide is played on the distortion guitar. The bass plays notes in groups of three on the first and second counts of each bar. A keyboard plays repetitive fills in between lines. The voice is emotive and the feel of this song is psychedelic. The audio quality is low. This song can be played in a night driving scene in a movie. | 2008-10-18T18:49:52Z | Keith Robbins | Margot & the Nuclear So & So's: 10-16-08 - Quiet As A Mouse 930 Listening Room Louisville, KY Recorded and edited by Keith Robbins keith@keithrobbbins.net | ["Singing", "Music", "Mouse", "Song"] | ["amateur recording", "alternative rock", "low quality audio", "distortion guitar", "bass", "percussion", "tambourine", "slow tempo", "psychedelic feel", "guitar scratching", "emotive voice", "male voice", "shaker", "keyboard fills"] | 0 | Wr5sFgqxLzQ | 3141 | |
"New Shoes" - Tap Dance! | This amateur recording features low quality audio. The main sound heard is that of tap dancing to a song. The song features a male voice singing the main melody. The rest of the instruments are not clearly audible. A bass plays the root notes of the chords. The percussion plays a simple beat. Other instruments are not audible. | 2011-01-22T17:32:26Z | amjkitty | This is an older video and I decided to upload it. This is not my music! SUBSCRBE!!!! :) :) | ["Music", "Radio", "Tap"] | ["amateur recording", "tap dance", "background song", "male voice", "bass", "percussion", "low quality audio"] | 0 | cLIump75aC0 | 3700 | |
Alice in Chains Sea of Sorrow and Bleed the Freak ( Alice Unchained ) Tribute Band | This low quality recording features a male voice singing the main melody. This is accompanied by percussion playing a simple beat. After two bars, the percussion plays only the ride cymbal. A distortion guitar plays power chords and after two bars, lets the last chord ring. The bass plays the root notes of the chords. This song can be played in a Transformers style movie. | 2007-11-28T08:19:12Z | Audiocircle | Alice Unchained Performs Sea of Sorrow and Bleed the Freak Live in San Diego | ["Music", "Rock music", "Pulse", "Grunge"] | ["amateur recording", "male voice", "rock song", "distortion guitar", "bass", "percussion", "moderate tempo"] | 0 | pWHkmo9Kn8g | 4715 |
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;