musiccaps_details (view)
2 rows where musiccaps_aspects contains "laughing" and musiccaps_names contains "Vocal music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- laughing · 2 ✖
- low quality 2
- noisy 2
- acoustic rhythm guitar 1
- crowd chattering 1
- emotional 1
- flat male vocal 1
- fun 1
- harmonizing male vocals 1
- indie 1
- live performance 1
- passionate 1
- passionate male vocal 1
- playback 1
- sad 1
- soft double bass 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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;