musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "low quality", musiccaps_aspects contains "shimmering hi hats" and musiccaps_aspects contains "unbalanced stereo"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 26 ✖
- low quality · 3 ✖
- shimmering hi hats · 3 ✖
- unbalanced stereo · 3 ✖
- arpeggiated electric guitar melody 1
- dissonant female vocal 1
- easygoing 1
- electric guitar melody 1
- electric guitar solo melody 1
- emotional 1
- emotional electric guitar melody 1
- groovy bass 1
- groovy piano chords 1
- hollow snare 1
- jazzy 1
- mellow kick hits 1
- noisy 1
- passionate 1
- percussive 1
- repetitive cowbell 1
- rock 1
- short brass stabs 1
- sloppy 1
- smooth bass 1
- snappy rimshots 1
- soft kick hits 1
- soft snare hits 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Electro Harmonix Neo Clone | The low quality recording features an emotional electric guitar melody, shimmering hi hats, soft kick hits and punchy snare in the left channel and arpeggiated electric guitar melody and simple bass guitar in the right channel of the stereo image. Due to this unconventional panning, the stereo image sounds a bit unbalanced. It is still emotional and passionate. | 2011-04-11T21:28:19Z | Mike Hermans | The Neo Clone is a clone of the Small Clone..... Lush Chorus! | ["Bass guitar", "Music", "Steel guitar, slide guitar", "Chorus effect"] | ["low quality", "emotional electric guitar melody", "arpeggiated electric guitar melody", "mellow kick hits", "soft snare hits", "shimmering hi hats", "unbalanced stereo", "emotional", "passionate"] | 4 | 2T1P9ovsl4A | 368 | |
Crash Sampler | The low quality recording features a jazzy song that consists of shimmering hi hats, repetitive cowbell, snappy rimshots and smooth bass in the right channel, short brass stabs and groovy piano chords in the left channel of the stereo image and electric guitar solo melody in the middle. The stereo image of the song is a bit unbalanced, due to the spreadness of low frequency sounds throughout the stereo image. It sounds easygoing and percussive. | 2006-05-18T07:30:39Z | Ninja Pat | group of friends crashing!!! | ["Swing music", "Music", "Musical instrument", "Music of Latin America"] | ["low quality", "jazzy", "unbalanced stereo", "shimmering hi hats", "repetitive cowbell", "short brass stabs", "electric guitar solo melody", "groovy piano chords", "smooth bass", "easygoing", "percussive", "snappy rimshots"] | 4 | JRfU_hF1wdM | 2005 | |
grace slick & the great society-white rabbit | The low quality recording features a rock song where dissonant female vocals are singing over electric guitar melody, groovy bass guitar, hollow snare, shimmering hi hats and soft kick hits. It sounds sloppy and the recording is noisy. | 2008-01-07T17:16:48Z | Francesco Giuliobello | An early live version of this song. White rabbit(1965). The images are taken from the movie:Woodstock 3 days of peace & music | ["Singing", "Ska"] | ["low quality", "rock", "unbalanced stereo", "noisy", "electric guitar melody", "dissonant female vocal", "shimmering hi hats", "groovy bass", "hollow snare", "soft kick hits", "sloppy"] | 4 | YddV91xnUz4 | 3302 |
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;