musiccaps_details (view)
9 rows where musiccaps_aspects contains "laughing", musiccaps_aspects contains "low quality" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 59 ✖
- laughing · 9 ✖
- low quality · 9 ✖
- noisy 7
- fun 4
- live performance 3
- crowd chattering 2
- emotional 2
- flat male vocal 2
- happy 2
- mono 2
- passionate 2
- 4 on the floor kick 1
- accordion melody 1
- acoustic rhythm guitar 1
- bagpipe melody 1
- bouncy snare 1
- car engine sound effects 1
- chaotic 1
- crowd clapping 1
- drum roll solo 1
- electric guitar melody 1
- emotional female vocal 1
- energetic 1
- groovy bass 1
- guitar melodies 1
- harmonized children vocals 1
- harmonizing male vocals 1
- high pitched tire screech 1
- indie 1
- karaoke 1
- leg tapping 1
- low female vocal 1
- muffled pop song 1
- passionate male vocal 1
- people chattering 1
- playback 1
- punchy kick 1
- quiet 1
- rehearse 1
- repetitive buzzy synth 1
- repetitive flat male vocal 1
- rock-ish drums 1
- sad 1
- saxophone solo melody 1
- shimmering open hat 1
- shoe squeaking sound 1
- soca 1
- soft double bass 1
- static tv sound effect 1
- sustained french horn tones 1
- syncopated snare 1
- thin 1
- tinny glass impacts 1
- traditional 1
- trombone melody 1
- uptempo 1
- wide male grunts 1
- wooden percussions 1
- woodwind melody 1
musiccaps_names (array) 18 ✖
- Music 5
- Vocal music 2
- /t/dd00004 1
- Accordion 1
- Bagpipes 1
- Bluegrass 1
- Brass instrument 1
- Country 1
- Drum 1
- Drum roll 1
- Flamenco 1
- French horn 1
- Music of Africa 1
- Percussion 1
- Rattle (instrument) 1
- Snare drum 1
- Speech 1
- Wind instrument, woodwind instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Geminoid F singing a Japanese song @ Robots in motion @ Cityplaza, Hong Kong 2012.4.1 | The low quality recording features a, what it seems like, karaoke cover of a muffled pop song that consists of some guitar melodies and rock-ish drums, over which an emotional female vocal is singing. There are some laughing and chattering crowd sound effects in the background too. It sounds fun and emotional, but also noisy and kind of chaotic. | 2012-04-01T15:16:35Z | Amanda Lam | 太古城中心全互動機械人大博覽 2012.4.1 Robots in motion @ Cityplaza, Hong Kong 2012.4.1 | ["Music", "/t/dd00004"] | ["low quality", "muffled pop song", "noisy", "laughing", "people chattering", "live performance", "karaoke", "emotional", "fun", "rock-ish drums", "guitar melodies", "emotional female vocal", "chaotic"] | 4 | 16TsDMjHzYU | 238 | |
Sarah Willis of the Berlin Philharmonic: Second Horn Tricks | The low quality recording features sustained french horn tones played, while there is a low female vocal and flat male vocal talking, followed by some laughs, shoe squeaking and woodwind melody played in the background. The recording is a bit noisy and it sounds like the musicians are rehearsing. | 2011-03-19T00:12:25Z | Nina Perlove | Nina Perlove observes Sarah Willis coaching members of the YouTUbe Symphony Orchestra at the Sydney Opera House. | ["Brass instrument", "French horn"] | ["low quality", "noisy", "sustained french horn tones", "low female vocal", "flat male vocal", "laughing", "shoe squeaking sound", "woodwind melody", "rehearse"] | 4 | 4tH9knHaTd0 | 613 | |
Travis Barker- Snare Drum | The low quality recording features a drum roll solo, followed by laughter. The recording is noisy and in mono. | 2008-03-26T20:49:37Z | Edmond Polk | Travis Barker performing some amazing snare drum tricks. | ["Drum", "Drum roll", "Snare drum", "Percussion"] | ["low quality", "laughing", "noisy", "mono", "drum roll solo"] | 4 | 7NtM1MM76s0 | 841 | |
Blind Pilot "Three Rounds and a Sound" (3 of 4) Indie Pop from Portland, OR | The low quality recording features a live performance of an indie song and it features a passionate male vocal singing over acoustic rhythm guitar and soft double bass, There are laughing and crowd chattering noises in the background. It sounds emotional and sad, even though the recording is a bit noisy. | 2010-03-17T20:59:05Z | One Night Music | One Night Music recorded Blind Pilot at Muddy Waters Cafe in Santa Barbara, CA on August 1, 2009. Find all 4 videos and a story at: http://www.onenightmusic.com/blog/post/love-at-muddy-waters-rey-villalobos-and-blind-pilot/ Filmed and edited by Megan Sullivan Audio editing by Ryan Andersen Filmed with VADO HD, audio with Zoom H2. Follow us: http://www.twitter.com/onenightmusic http://www.facebook.com/onenightmusic http://www.onenightmusic.com One Night Music is a San Francisco based collective of volunteers creating high quality video and audio recordings of live performances by quality independent music artists. Learn how to record with us or how to volunteer with us at http://www.OneNightMusic.com/about | ["Country", "Flamenco", "Music", "Bluegrass", "Vocal music"] | ["low quality", "indie", "live performance", "noisy", "passionate male vocal", "acoustic rhythm guitar", "soft double bass", "crowd chattering", "laughing", "passionate", "emotional", "sad"] | 4 | QtjMlA_7dds | 2647 | |
Denis Novato | The low quality recording features an accordion melody, electric guitar melody and trombone melody, after which there is a crowd clapping, laughing and chattering sounds. There are also tinny glass impacts in the background. It gives off fun and happy vibes. | 2008-07-13T14:34:40Z | buttonbox | Denis plays at Slovenefest XXVII | ["Accordion"] | ["low quality", "accordion melody", "electric guitar melody", "trombone melody", "crowd clapping", "laughing", "crowd chattering", "fun", "happy", "tinny glass impacts"] | 4 | TWnrcjA6VTk | 2842 | |
Machel Montano - Congo Man - Trinidad Soca Music | The low quality recording features a Soca song that features repetitive flat male vocal singing over wide male background grunts, repetitive buzzy synth, punchy kick, syncopated snare and wooden percussion. It sounds energetic and uptempo. | 2008-02-11T04:33:47Z | rasadam | Download this MP3: https://amzn.to/2XJFxUy Artist: Machel Montano Title: Congo Man Album: Flame On Year: 2008 Genre: Soca Origin: Trinidad and Tobago | ["Music of Africa", "Music"] | ["low quality", "soca", "wooden percussions", "wide male grunts", "repetitive flat male vocal", "laughing", "repetitive buzzy synth", "punchy kick", "syncopated snare", "uptempo", "energetic"] | 4 | _GjHL0FkYoY | 3456 | |
THE WARP ZONE BLOOPERS 2013 | The low quality recording features harmonizing male vocals singing over a song played on playback, followed by a flat male vocal talking. At the end of the recording, there is a male laughter. It sounds fun and the recording is noisy. | 2014-01-01T18:00:04Z | The Warp Zone | We cap off 2013 with some funny bloopers from this year's videos! SUBSCRIBE! http://bit.ly/Sub2TWZ FB: http://www.fb.com/thewarpzone Edited by Michael Adams Davis Shot by Mike Schmidt Trent Turner Sharif Matar Michael Schroeder Brian Fisher Ryan Tellez - The Warp Zone - Videos 5 Days a Week! http://youtube.com/TheWarpZone Like us on Facebook! http://facebook.com/TheWarpZone Follow us on Twitter! http://twitter.com/WarpZoneTweets Follow us on Instagram! http://instagr.am/WarpZoneGrams | ["Music", "Speech", "Vocal music"] | ["low quality", "noisy", "harmonizing male vocals", "flat male vocal", "laughing", "playback", "fun"] | 4 | hM88FG1_D5Q | 4098 | |
WAKE, RATTLE & ROLL Episode 2 part 1 | The low quality recording features a song that consists of harmonized children vocals singing over bouncy snare, saxophone solo melody, groovy bass, shimmering open hats and "4 on the floor" kick pattern. There are some laughing, high pitched tire screeches and car engine sound effects in the background. The recording is very noisy and the song is quiet and thin, as it lacks bass frequencies, but it still sounds fun and happy - like something you would hear in TV shows for kids. | 2008-10-08T19:05:34Z | Jack Box | A new episode! | ["Music", "Rattle (instrument)"] | ["low quality", "quiet", "noisy", "fun", "happy", "harmonized children vocals", "bouncy snare", "thin", "laughing", "car engine sound effects", "static tv sound effect", "high pitched tire screech", "saxophone solo melody", "groovy bass", "shimmering open hat", "4 on the floor kick"] | 4 | mQM3Fd3eN9E | 4470 | |
Fred Morrison and Stuart Liddell jam session | The low quality recording features a live performance of a traditional song that consists of leg tapping sounds, giving a rhythm to a bagpipe melody. There are some laughing sounds in the background. It sounds passionate and the recording is in mono and noisy. | 2010-02-09T19:04:09Z | Doug Henkle | Discussion on music composition turns into a mini concert. Recorded on February 8, 2010 using a Flip Video camcorder. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["low quality", "noisy", "mono", "leg tapping", "laughing", "bagpipe melody", "passionate", "traditional", "live performance"] | 4 | xrbIZTswt3c | 5355 |
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;