musiccaps_details (view)
4 rows where musiccaps_aspects contains "applause" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- applause · 4 ✖
- low quality 4
- noisy 2
- reverberant 2
- shimmering hi hats 2
- "4 on the floor" kick pattern 1
- chaotic 1
- classical 1
- compilation 1
- cover 1
- crowd cheering 1
- electric guitar melody 1
- exotic 1
- fun 1
- glass shattering sound effect 1
- groovy bass 1
- groovy piano chords 1
- groovy piano melody 1
- happy 1
- jazz 1
- loud static sound effect 1
- male grunts sound effect 1
- male screaming 1
- manic 1
- metal hits 1
- mono 1
- mumbling vocal 1
- passionate 1
- reverberant impact 1
- saxophone melody 1
- snappy snare 1
- steel pans melody 1
- syncopated snare 1
- tv 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Amazing Grace" on the steel pans by the Dover High School Steel Drum Band | The low quality recording features a steel pans melody, shimmering hi hats, syncopated snare and "4 on the floor" kick pattern. It is a bit reverberant as it was played in a concert hall. There are some crowd cheering and applause sounds. It sounds exotic, fun and happy. | 2011-10-15T22:04:45Z | Ann Swinderman | Under the direction of Joan Wenzel, the Dover Steel Drum Band performs this favorite in the Performing Arts Center Kent State University Tuscarawas lobby. | ["Music", "Musical instrument", "Orchestra", "Percussion", "Steelpan"] | ["low quality", "steel pans melody", "reverberant", "shimmering hi hats", "syncopated snare", "\"4 on the floor\" kick pattern", "groovy bass", "crowd cheering", "applause", "exotic", "fun", "happy"] | 4 | 6J3X0whM_-4 | 742 | |
Ana Maria Tarantus Sandu | The low quality recording features a cover of a classical song and it consists of a saxophone solo melody playing over a groovy piano melody. At the very end of the loop, there is an applause. It sounds easygoing, passionate and the recording is noisy and in mono. | 2010-11-27T18:22:17Z | Emanoil Tarantus | Hora Lautareasca si Piesa de Concert | ["Brass instrument", "Saxophone", "Wind instrument, woodwind instrument"] | ["low quality", "mono", "noisy", "applause", "saxophone melody", "groovy piano melody", "classical", "cover"] | 4 | LaeRCg-NdeY | 2204 | |
Stick Men on Crack Vids 1,2 & 3 (Original) | The low quality recording features a compilation of mumbling male vocal, screaming male sound effect, glass shattering sound effects alongside metallic hits, male grunts and reverberant impact. The recording ends with the applause. In-between every single sound there is a loud static sound - which makes it sound like the channels are changing on a TV. It sounds chaotic and manic. | 2007-08-05T22:40:23Z | Jason Sieraski | I HAD NOTHING TO DO WITH THE MAKING OF THIS VIDEO! | ["Music", "Breaking"] | ["low quality", "loud static sound effect", "mumbling vocal", "male screaming", "compilation", "glass shattering sound effect", "metal hits", "tv", "applause", "reverberant impact", "male grunts sound effect", "manic", "chaotic"] | 4 | ba3QPheW8mI | 3637 | |
Otis Rush - Sweet Little Angel - Berlin 1966 - one of his best performances | The low quality recording features a jazz song that consists of electric guitar melody, shimmering hi hats, snappy snare, groovy piano melody and some applause at the very beginning of the loop. The recording is noisy and it sounds passionate and reverberant. | 2009-06-20T04:10:47Z | gollincho | Otis Rush ;V/g , Little Brother Montgomery ; p , Jack Myers ; b , Fred Below ; d , Berlin ,16 Oct 1966 | ["Guitar", "Jazz", "Music", "Plucked string instrument"] | ["low quality", "applause", "noisy", "jazz", "electric guitar melody", "shimmering hi hats", "snappy snare", "groovy piano chords", "passionate", "reverberant"] | 4 | tMMjurLqYJQ | 5030 |
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;