musiccaps_details (view)
7 rows where musiccaps_aspects contains "e-guitar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 2007 - DJ Miya Jima (Japan) - DMC World DJ Final | This song contains someone scratching over a Hip-Hop track. The track contains acoustic drums with a rim-shot as snare and congas playing along. The e-bass and an e-guitar are playing the same lines in the lower register. This song may be playing live at a scratching contest. | 2013-11-18T10:27:09Z | DMC World Championships | DJ Miya Jima (Japan) DMC World DJ Finals 2007 Indig02, The 02, London. www.dmcworld.com www.dmcdjchamps.com www.facebook.com/dmcdjchamps www.twitter.com/dmc_dj_champs | ["Electronic music", "Music", "Scratch", "Speech", "Inside, large room or hall"] | ["hiphop", "scratching", "e-guitar", "acoustic drums", "congas", "e-bass", "male voice sample", "slow tempo"] | 6 | 8oTTgXIO0-I | 946 | |
| Rig Rundown - Robert Randolph | A male voice is speaking while someone is playing an e-guitar with a lot of reverb and a little delay running down the strings. This is an amateur recording. This may be playing while demonstrating someone your guitar. | 2011-12-27T18:07:26Z | Premier Guitar | http://www.premierguitar.com PG's Jason Shadrick is On Location in Iowa City, IA, at the Englert Theatre where he catches up with pedal steel guitarist Robert Randolph who walks us through his current touring rig consisting of Fender amps, Fender guitars, Fuchs amplifiers, Electro-Harmonix effects, and various other products. For more Rig Rundown videos or to watch one of Premier Guitar's 1500 other videos online for free, be sure to visit http://www.premierguitar.com/video | ["Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Speech", "Plucked string instrument"] | ["amateur recording", "male voice speaking", "e-guitar"] | 6 | EPjfqS5NvCY | 1552 | |
| Simone e Simaria - Ela namora hum - Lovina João Pessoa | This song contains an acoustic drum playing along with a bass and an accordion melody creating a cheerful atmosphere. The crowd is so loud. Cheering, screaming and laughing. This song may be playing at a local event. | 2014-01-18T17:11:01Z | Anne Michelle | Show realizado no dia 17/01/2014 | ["Crowd", "Music", "Speech", "Music of Latin America"] | ["amateur recording", "popmusic", "e-bass", "e-guitar", "accordion", "female voice singing", "acoustic drums", "background cheering", "screaming", "shouting", "medium tempo", "cheerful atmosphere"] | 6 | HvOSaS8sXQM | 1848 | |
| Beginners, VERY EASY Country Lead Guitar Lesson With Scott Grove | This recording contains a male voice talking and then playing a blues riff on a clean e-guitar. This song may be playing as part of a video tutorial. | 2013-05-03T11:45:35Z | Groovy Music Lessons | Donations Via Paypal: mrmrswoodworker@aol.com Merchandise: https://www.doctorgroovymerch.com/ http://www.groovymusiclessons.com You can purchase the 200 plus hours of lessons for only $25. The deal of the century! NONE of my YouTube videos are in these 200 hours. Merchandise: https://www.doctorgroovymerch.com/ Donations Via Paypal: mrmrswoodworker@aol.com | ["Country", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument", "Bluegrass"] | ["blues", "amateur recording", "male voice talkin", "e-guitar", "medium tempo"] | 6 | JDWPJ1AiDKc | 1981 | |
| King Krule - Out Getting Ribs live (Hyères) 2011 | This audio contains someone strumming one only chord on a e-guitar then a male voice starts speaking in the midrange. In the background you can hear people talking. | 2011-10-15T23:37:15Z | lamiresonique | King Krule playing Out Getting Ribs at Midi Festival 2011 in Hyères | ["Echo", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Outside, urban or manmade"] | ["amateur recording", "e-guitar", "male voice speaking", "background voices"] | 6 | TObYoD2pGb0 | 2834 | |
| The Gospel Music of the Statler Brothers | This song contains someone playing a blues melody on the acoustic piano along with an e-guitar and an e-bass. The acoustic drums are playing a constant rhythm while male deep voice is backed by higher sounding male voices singing harmonies along with him. Then a male voice starts talking that seems not to be part of the musical composition. This song may be playing in a cafe. | 2010-03-05T16:11:23Z | Gaither Music TV | Gaither Studios teamed up with the Statler Brothers to bring gospel music lovers a new, must-have DVD collection! Bill Gaither recently sat down with the Statler Brothers to talk about life, music, faith and of course, gospel music. The 2-DVD & CD collection will be out in stores May 18, 2010. You won't want to miss this special DVD event. Check out Gaither.com for more details! | ["Gospel music", "Music", "Rhythm and blues", "Speech"] | ["gospel/blues", "male voices singing", "low to higher register", "male voice talking", "acoustic piano", "e-bass", "acoustic drums", "e-guitar", "uptempo"] | 6 | imIFtW4O5S0 | 4218 | |
| GAITA CORTA/ EL ARMADILLO/ LEHELVILL E VILORIA GARCÍA CEL 3003618759 | This song contains someone playing a melody with a flute in a higher register. The flute sounds offkey. An e-guitar is fingerpicking two chords. In the background you can hear percussive instruments and an e-bass. A male voice is talking/shouting sounding as if he wants to motivate the listener. This song may be playing live in a big bar or during an event in a latin.american country. | 2009-09-18T02:02:47Z | LEHELVILL E. VILORIA GARCÍA | Presentamos en este grupo LA BANDA DE NAYO, en un concierto realizado en la ciudad de NEIVA, el tema es EL ARMADILLO, del cual tenemos un video pero en típico, aquí está reunida la BANDA completa y se siente la buena presión de esta espectacular música, más aun si la persona que la dirige NAYIB FEREZ, hace un solo de GAITA CORTA que de verdad deja con la Boca en aguas a los amante de este ritmo, La verdad no conocía a ningún interprete que en una presentación hiciera un solo de GAITA CORTA con dos (2) GAITAS a la vez, como dice su cantante en la presentación es un maestro de la música lleva en el espacio que demora el espectáculo la métrica fina que exige la altura del los tonos, porque por lo general está precisamente en la mitad del tema. En sus recorridos por Colombia y en las presentaciones que ha hecho por diferentes ciudades de Colombia, la intención es aplaudida y el público se detiene a grabar en sus mentes esos momentos especiales, para recordarlos y después transmitirlos a las personas ya que el rumor positivo crece vertiginosamente, además santigua a la gente que va a sus espectáculos. De este excelente músico se espera en este campo todo, el palmarés en la música le ha dado la oportunidad de ganar en los años 2.004,2005 y 2007 el FESTIVAL NACIONAL DE GAITAS FRANCISCO LLIRENE en la categoría de GAITA CORTA en OVEJAS (Sucre) y aunque sus rivales son excelentes digadores de LA GAITA CORTA, este músico ha marcado la diferencia ganando siempre con amplio margen, el SABOR del canto es de otro de nuestro mejores cantantes con que cuenta el folclor y nuestra música caribeña en el momento es de ANGEL LEON y también en esta oportunidad, le acompaña en los coros el excelente músico ELBER MANUEL ALVAREZ, de amplia tradición en nuestra música GAITERA. La oportunidad esta para deleitar este video con el tema EL ARMADILLO, de su propia autoría y que mantiene la propia esencia de nuestro folclor, cabe anotar que lo bueno de este músico y de LA BANDA DE NAYO es la forma de interpretar su música, es la única … | ["Music", "Musical instrument", "Rattle (instrument)", "Speech", "Music of Latin America"] | ["latinmusic", "amateur recording", "flute", "cuica", "percussion", "e-guitar", "e-bass", "male voice talking/shouting", "uptempo"] | 6 | vykrv5BaW-s | 5224 |
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;