musiccaps_details (view)
3 rows where musiccaps_aspects contains "flat male vocal" and musiccaps_aspects contains "playback"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- flat male vocal · 3 ✖
- low quality 3
- playback · 3 ✖
- noisy 2
- "4 on the floor" kick pattern 1
- accordion chords 1
- accordion melody 1
- distorted 1
- emotiona 1
- fun 1
- groovy 1
- groovy bass 1
- groovy didgeridoo 1
- harmonizing male vocals 1
- laughing 1
- live performance 1
- loud 1
- mono 1
- passionate 1
- regional mexican 1
- shimmering hi hats 1
- snappy rimshots 1
musiccaps_names (array) 6 ✖
- Music 2
- Accordion 1
- Didgeridoo 1
- Musical instrument 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 |
---|---|---|---|---|---|---|---|---|---|---|
Julio Chaidez Hombre de Negocios | The low quality recording features an accordion melody played over regional Mexican playback that consists of accordion chords, groovy bass and flat male vocal singing over it. The recording is in mono, noisy and it sounds emotional and passionate. | 2009-05-27T05:57:03Z | jgg171990 | Tono de Sib | ["Accordion"] | ["regional mexican", "low quality", "mono", "noisy", "playback", "groovy bass", "accordion chords", "flat male vocal", "accordion melody", "passionate", "emotiona"] | 4 | FLJPxFCPeDY | 1638 | |
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 | |
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;