musiccaps_details (view)
9 rows where musiccaps_aspects contains "male voice", musiccaps_author = 0 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Kraft Music - Yamaha APX and CPX Series Demo with Jake Blake | This clip features a male voice narrating about guitars. In the background, an acoustic guitar is strumming chords and picking notes used as fills. The mood of the song is happy and uptempo. There are no other instruments in this song. This song can be played in a romantic mood. This audio can be used in a guitar promotional video. | 2013-02-13T19:14:08Z | Kraft Music | Find exclusive Yamaha guitar packages at Kraft Music. Our guitar bundles ship with all the accessories you need to go along with your new instrument: http://www.kraftmusic.com/brands/yamaha/guitars/acoustic-electric/?utm_source=youtube&utm_medium=video&utm_content=vid&utm_campaign=yam-apx-cpx-blowout Kraft Music team member Jake Blake demonstrates the Yamaha APX700II, CPX700II, APX1000, and CPX1000 acoustic electric guitars. | ["Music", "Speech", "Happy music"] | ["acoustic gutiar", "male voice", "narration", "moderate tempo", "no percusion", "no other instruments"] | 0 | 1O4LpU7HggY | 264 | |
| Yellow Ledbetter Tab How to Play Pearl Jam guitar Lesson - Eddie Vedder | This clip features a guitar chord being strummed in the beginning. This is followed by a male voice narrating a song. There are no other instruments in this song. There is no vocal melody in this clip. | 2009-12-18T08:33:21Z | GuitarJamz | click here to request your song http://www.guitarjamz.com/new_requests/ Great Lessons at http://www.guitarjamz.com/shop/ | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["electric guitar", "male voice", "narration", "no other instruments", "no vocal melody"] | 0 | 1o7iTDLNTFk | 312 | |
| 5 Amazing Guitar Chords You Must Learn! - Creating Your Own Collection Of Favourite Chords | This guitar instruction audio features an acoustic guitar. This starts off with a male voice giving instructions on how to play the guitar. The bass note is played on the open string and the chord is strummed once. This is the Hendrix chord being played on the acoustic guitar. There are no other instruments in this song. There is no vocal melody in this song. This audio can be used in a guitar instruction video. | 2013-10-12T00:11:40Z | Nail Guitar Skills | https://nailguitar.com/ld2 ◄ Download a free PDF of the 5 amazing chords. https://nailguitar.com/tools/ ◄ You can also get a blank chord sheet to build your own list of favorite chords. Examples of these chords in songs: Cm11 - Cool #9 by Joe Satriani https://youtu.be/FlbUUKN4KR0?t=256 Em11 - Little Wing as covered by The Corrs https://www.youtube.com/watch?v=HhsacepElvA Em9 - Little Wing as covered by The Corrs https://www.youtube.com/watch?v=HhsacepElvA E7#9 - Loads of Hendrix songs Note he sometimes used a version of this chord lower down the neck. https://www.youtube.com/results?search_query=jimi+hendrix+live G13 - No references for this one sorry... I learnt it at uni while studying under great jazz guitarist, so check out some jazz :) Instagram - http://www.twitter.com/Andymuzic Facebook - http://www.facebook.com/NailGuitar Twitter - http://www.twitter.com/NailGuitar Check out my youtube channels: http://www.youtube.com/NailGuitar - Song Lessons http://www.youtube.com/NailGuitarSkills - Guitar Skills http://www.youtube.com/NailGuitarLicks - Lead Guitar Licks http://www.youtube.com/NailDrums - Drum Lessons http://www.youtube.com/NailPiano - Piano Lessons Details on guitar gear I use: http://www.nailguitar.com/links.html Cheers, Andy Looking for a complete step-by-step guitar learning system? Check out this awesome affordable guitar course http://beginnergtrcourse.nailguitar.com 5 Amazing Guitar Chords You Must Learn! - Creating Your Own Collection Of Favourite Chords | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["guitar instruction", "acoustic guitar", "male voice", "single strum", "7th chord", "no other instruments", "no vocal melody"] | 0 | 3OLeJZF4oI0 | 460 | |
| How to Play Trust by Megadeth Guitar Lesson (w/ Tabs!!) | This song features a distortion guitar. This is an instructional video. The song features an open note followed by the octave. Then a descending pattern is played on the distortion guitar. The voice gives instructions on how to play the pattern. There is no percussion in this song. There are no other instruments in this song. There is no vocal melody in this song. | 2009-03-15T04:06:25Z | m169marroquin | http://www.ObeyYourMATTster.com | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["distortion guitar", "heavy metal", "male voice", "instructional audio", "octaves", "no other instruments", "no percussion", "no vocal melody", "moderate tempo"] | 0 | 52odOK7G2kg | 628 | |
| A Magia do Natal (Remix 2009) - Eu Sou Papai Noel | This techno song features a male voice narrating a line. The song starts off with programmed percussion playing the kick and sleigh bells on alternate counts of the bar. A sliding sound is heard in the background like a sleigh on snow. The volume of the sliding sound increases in volume toward the end. A vinyl scratch is played two times. Toward the end, the instruments pause and a male voice narrates a line. This song can be played in a promotional video about a Christmas DJ party. | 2009-12-19T19:40:17Z | luhaus | A Magia do Natal Remix - Dance Mix Download: http://www.4shared.com/mp3/BAu2VOmf/A_Magia_Do_Natal_versao_remix.html | ["Christmas music", "Christian music", "Music", "Speech"] | ["techno song", "male voice", "programmed percussion", "sleigh bells", "sliding sound", "vinyl scratching", "no voices instrumental"] | 0 | B9IAl-ygE2k | 1211 | |
| Bootsy Collins - What's A Telephone Bill | This funk song features a male voice singing the main melody. Female voices sing backing vocals. This is accompanied by percussion playing a simple beat. The bass plays a funky bassline using the root notes of the chords. A wah or tron effect is added on the bass. The sound of bells is heard in the background. This song has a flirty mood. This song can be played as a slow dance song in a club. | 2012-03-04T23:56:45Z | AuntieSoul34 | Love Bootsy Collins!! 1977.. :p | ["Music", "Speech", "Exciting music"] | ["funk song", "male voice", "female backing voices", "simple percussion", "funky bassline", "bells", "slow tempo", "flirting mood"] | 0 | HIDXdH6R6T8 | 1789 | |
| Pendulum - Blood Sugar + Lyrics [HQ] | This techno song starts off with a synth playing a melody followed by another synth playing a burst of two chords. The two chord bursts are accompanied by percussion playing an outro roll. The instruments pause and a male voice starts to narrate a few lines. After two lines, the pitch of the voice is lowered in pitch to reach a bass pitch. This voice fades away to silence. This song can be played in a movie featuring a robot. | 2010-01-08T17:57:19Z | Ascendic | Thanks for 500.000 views, you guys rock! They have returned! https://www.facebook.com/pendulum/photos/a.498356746152.287685.24979476152/10153868789116153/?type=3&theater Lyrics: Ladies and Gentlemen we understand that you have come tonight to bear witness to the sound of drum... and... bass We regret to announce that this is not the case as instead, we come tonight to bring you, the sonic recreation of the end of the World Ladies and Gentlemen prepare to Hold Your Colour! Okay, fuck it, I lied it's drum and bass ... what you gonna do!? | ["Drum and bass", "Electronic music", "Music", "Independent music", "Speech"] | ["techno song", "dj song", "synth bursts", "male voice", "vocal effect", "explicit lyrics", "programmed percussion", "moderate tempo"] | 0 | XPGtOugQ69U | 3182 | |
| We'll Meet Again Sweet Heart- Japanese bluegrass Band in Korea.wmv | This bluegrass song starts off with a male voice making an announcement. The music starts to play. The banjo plays an introductory bluegrass lick. This is accompanied by an acoustic guitar strumming chords. The double bass plays the root note and the fifth of the chord. The mandolin plays the rhythm section in the song. There is no vocal melody in this song. There is no percussion in this song. This song can be played in a movie with a Western theme. | 2010-11-25T14:46:00Z | sun shin | ["Banjo", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Bowed string instrument"] | ["bluegrass", "male voice", "announcement", "no percussion", "no vocal melody", "mandolin", "guitar", "banjo", "double bass", "moderate tempo", "romantic mood"] | 0 | oyAAhjGTNvQ | 4671 | ||
| PRS 30th Anniversary Custom 24 electric guitar review demo | This clip features a guitar song. An overdriven guitar is struck at the beginning. This is followed by an electric guitar strumming two chords once each. The chords are strummed with a light overdrive sound. There are no other instruments in this song. A male voice talks in a narrative tone at the end of the segment. | 2015-02-19T14:56:55Z | Guitarist | Reviewed in Guitarist issue 391 Gear demos playlist: http://goo.gl/30cAf Subscribe for more from Guitarist: http://goo.gl/2PRXE Buy Guitarist magazine in print and digital forms: http://www.myfavouritemagazines.co.uk/content/lp/digitalbundles/mm-guitarist/ Visit our website: http://www.guitarist.co.uk Facebook: http://www.facebook.com/guitaristmagazine Twitter: http://www.twitter.com/Guitarist_Mag | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["guitar song", "overdriven guitar", "male voice", "narration", "electric guitar", "instructional clip", "no percussion", "no other instrument"] | 0 | vOiDwXo-SuM | 5180 |
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;