musiccaps_details (view)
3 rows where musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "laughing" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- flat male vocal · 3 ✖
- laughing · 3 ✖
- low quality 2
- noisy 2
- addictive 1
- addictive synth lead melody 1
- boomy kick 1
- claps 1
- energetic 1
- exciting 1
- filtered male vocal 1
- fun 1
- groovy 1
- harmonizing male vocals 1
- laser synth riser 1
- low female vocal 1
- playback 1
- pop 1
- rehearse 1
- shoe squeaking sound 1
- sustained french horn tones 1
- woodwind melody 1
musiccaps_names (array) 7 ✖
- Music 2
- Brass instrument 1
- Dance music 1
- French horn 1
- Hip hop music 1
- Speech 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
Pok'Chop - What You Bout (ft. Solo, Sly) (NEW BAY ORDER!! 2011) | The Pop song features a filtered male vocal, alongside flat male vocal, singing over some claps, boomy kick hits, laser synth riser and addictive synth lead melody. There are also some male laughing sounds. It sounds addictive, groovy and exciting - like something you would hear in clubs. | 2011-11-04T04:27:10Z | WeLovePokChop | Free Download: http://hulkshare.com/yjvnoy3zwhl2 | ["Music", "Dance music", "Hip hop music"] | ["pop", "addictive synth lead melody", "filtered male vocal", "flat male vocal", "claps", "boomy kick", "laser synth riser", "energetic", "laughing", "addictive", "groovy", "exciting"] | 4 | on18CWdmxn8 | 4657 |
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;