musiccaps_details (view)
4 rows where musiccaps_aspects contains "fruity male vocal" and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Treorchy Male Choir & Tom Jones singing Amazing Grace | The low quality recording features a live performance of a harmonizing mixed choir, introduced by a fruity male vocal. There is a footstep and crowd clapping sound right after introduction. The recording is a bit noisy, in mono and it sounds passionate, emotional and soulful. | 2009-11-27T01:22:15Z | Llantrisant | Tom Jones and the Treorchy Male Choir performing "Amazing Grace" on his Christmas TV Show, 1969. Visit www.treorchymalechoir.com | ["Singing", "Music", "Opera", "/m/05zppz", "Speech", "Choir", "/t/dd00003"] | ["low quality", "noisy", "mono", "footstep sound", "fruity male vocal", "crowd clapping", "mixed harmonizing choir", "emotional", "passionate", "soulful", "live performance"] | 4 | V5HMIxuAtv8 | 2973 | |
| Sexy Sound Served on a Plate | The low quality recording features a classical song that consists of passionate male opera vocal singing over wide strings melody, wide brass melody and woodwinds melody, over which there is a fruity male vocal talking. It sounds passionate, epic and powerful - like something for commercial. | 2013-12-20T09:02:07Z | LG TV | Slim, stylish, considerate of your needs, full-bodied... we're not talking about your ideal woman; we're talking about LG's latest product, SoundPlate (LAP340). We are proud to introduce you to the LG SoundPlate, a slim base-type speaker system that enhances the TV viewing experience with immersive audio. For more product information, please visit our websites! LG.com: http://www.lg.com/uk/speakers-sound-systems/lg-LAP340 Blog: http://whylgtv.lge.com/archives/6183 | ["Music", "Opera", "Orchestra", "Speech", "Classical music"] | ["low quality", "classical", "fruity male vocal", "passionate male opera vocal", "wide strings melody", "wide brass melody", "woodwinds melody", "passionate", "epic", "powerful", "commercial"] | 4 | YK1AEw1kf28 | 3275 | |
| Psychobilly guitar tutorial - psychobilly blues/boogie | The low quality recording features a tutorial where a fruity male vocalist is talking in-between electric guitar chords. There is a very buzzy guitar amp in the background and the recording is very noisy. | 2012-07-16T14:01:01Z | Adrian Whyte | Tabs Available for a few dollars here: Support, Get Access to the tabs for the intro and heaps of other things! https://www.patreon.com/Adrianwhyte Checkout my original psychobilly band 'the Vaudevilains' (now defunct but stuff is on itunes) and see my solo album 'Death Rides a Harley" A run through of psychobilly styled chord progression based on the blues, with some theoretical insight towards the end of the video on the tones that give psychobilly that kooky sound! Skype lessons now available - just pm me! Thanks!! Adrian | ["Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument"] | ["tutorial", "fruity male vocal", "speaking", "electric guitar chords", "low quality", "buzzy guitar amp", "noisy"] | 4 | _KaRkSyELy4 | 3465 | |
| Webisode 8: The Sound Of Music | The low quality recording features a compilation of rock songs in-between which there is a flat male vocal talking. At the very beginning there is a short snippet of a groovy piano melody and fruity male vocal singing over it. After that, there is an even shorter snippet of a song that consists of acoustic rhythm guitar and a male vocalist singing over it. And at the end of the loop, there is a fade in into a flat male vocal singing with background vocals over punchy kick, punchy snare, shimmering cymbals, distorted bass guitar and electric guitar melody. Overall it sounds weird and chaotic, due to the arrangement of the sounds, but it is also energetic. | 2008-08-05T09:05:06Z | weezer | The Sound Of Music Tour Dates after the jump (since the press release is live): Sep 23 Boston, MA Tsongas Arena Sep 24 New York, NY Madison Square Garden Sep 26 Atlantic City, NJ Borgata Casino Sep 27 Philadelphia, PA Susquehanna Center Sep 29 Detroit, MI The Palace of Auburn Hills Sep 30 Toronto, ON Air Canada Center Oct 2 Chicago, IL All State Arena Oct 3 St. Paul, MN Xcel Arena Oct 5 Denver, CO Broomfield Oct 7 Salt Lake City, UT E Center Oct 9 Portland OR Memorial Coliseum Oct 10 Vancouver, BC GM Place Oct 11 Seattle, WA Key Arena Oct 13 San Jose, CA Events Center Oct 14 Los Angeles, CA The Forum Oct 17 San Diego, CA Cox Arena Oct 18 Phoenix, AZ Arizona State Fair Oct 20 Austin, TX Frank Erwin Center Oct 21 Dallas, TX Nokia Theater Oct 23 Houston, TX Reliant Arena Oct 25 Atlanta, GA Gwinnett Arena | ["Music", "Speech", "Exciting music"] | ["compilation", "fade in", "rock", "groovy piano melody", "fruity male vocal", "flat male vocals", "low quality", "punchy snare", "punchy kick", "shimmering cymbals", "background vocals", "electric guitar chords", "acoustic rhythm guitar", "distorted bass guitar", "chaotic", "energetic", "weird"] | 4 | hwe6y-jSqdQ | 4152 |
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;