musiccaps_details (view)
4 rows where musiccaps_aspects contains "snappy rimshots" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- low quality 4
- shimmering hi hats 4
- snappy rimshots · 4 ✖
- live performance 3
- emotional 2
- flat male vocal 2
- punchy kick 2
- "4 on the floor" kick pattern 1
- addictive 1
- arpeggiated electric guitar melody 1
- crowd cheering 1
- crowd singing 1
- distorted 1
- easygoing 1
- electric guitar solo melody 1
- groovy 1
- groovy bass 1
- groovy bass guitar 1
- groovy didgeridoo 1
- groovy piano chords 1
- jazz 1
- jazzy 1
- loud 1
- mellow piano chords 1
- passionate 1
- percussive 1
- playback 1
- repetitive cowbell 1
- rock 1
- short brass stabs 1
- smooth bass 1
- soulful 1
- sustained strings 1
- tenor sax solo melody 1
- unbalanced stereo 1
musiccaps_names (array) 11 ✖
- Music 4
- Musical instrument · 4 ✖
- Blues 1
- Brass instrument 1
- Didgeridoo 1
- Jazz 1
- Music of Latin America 1
- Saxophone 1
- Singing 1
- Swing music 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Aboriginal DIDGERIDOO Playing Live in Sydney | The low quality recording features a groovy didgeridoo playing over playback that consists of a "4 on the floor" kick pattern and shimmering hi hats, followed by snappy rimshots. There is a flat male vocal talking at one point. The recording is loud, distorted and it sounds groovy overall. | 2007-09-13T09:57:48Z | Andy Lloyd | What is says lol | ["Didgeridoo", "Music", "Musical instrument"] | ["low quality", "live performance", "groovy didgeridoo", "shimmering hi hats", "snappy rimshots", "\"4 on the floor\" kick pattern", "playback", "flat male vocal", "loud", "distorted", "groovy"] | 4 | VgwsGjRk61M | 3021 | |
Compact - Fata din vis | The low quality recording features a live performance of a rock song and it consists of flat male vocal singing over arpeggiated electric guitar melody, groovy bass guitar, shimmering hi hats, snappy rimshots and punchy kicks. In the background, there are some crowd singing and crowd cheering noises. It sounds emotional and a bit addictive. | 2008-04-19T14:23:33Z | Horia D | nice love song | ["Blues", "Singing", "Music", "Musical instrument"] | ["low quality", "live performance", "rock", "crowd cheering", "crowd singing", "flat male vocal", "punchy kick", "snappy rimshots", "shimmering hi hats", "arpeggiated electric guitar melody", "groovy bass guitar", "emotional", "addictive"] | 4 | cTJqIkSuf6s | 3710 | |
Tony on Tenor Sax | The low quality recording features a live performance of a jazz song that consists of a tenor sax solo melody playing over mellow piano chords, sustained strings, groovy bass, snappy rimshots, shimmering hi hats and punchy kicks. It sounds emotional, passionate and soulful. | 2008-01-24T22:22:32Z | Tony Bolivar | Because of Who You Are | ["Brass instrument", "Jazz", "Music", "Musical instrument", "Wedding music", "Saxophone"] | ["low quality", "live performance", "jazz", "tenor sax solo melody", "groovy bass", "mellow piano chords", "shimmering hi hats", "punchy kick", "snappy rimshots", "sustained strings", "passionate", "emotional", "soulful"] | 4 | tuoBmxts5Xo | 5075 |
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;