musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "low quality recording" and musiccaps_names contains "Musical instrument" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- low quality recording · 3 ✖
- bass guitar 1
- bass hammer on 1
- bassline 1
- distortion guitar 1
- female voice 1
- foreign language 1
- harmonics 1
- home recording 1
- live recording 1
- male voice 1
- metal song 1
- moderate tempo 1
- multiple guitars 1
- no percussion 1
- out of time guitar 1
- power drumming 1
- stringed instrument 1
- tenor guitar 1
- video camera recording 1
musiccaps_names (array) 8 ✖
- Music 3
- Musical instrument · 3 ✖
- Guitar 1
- Harmonic 1
- Mandolin 1
- Plucked string instrument 1
- Rattle (instrument) 1
- Roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Remigio Fuentes_Joropo y Estribillo con Mónico Márquez | This song is a low quality live recording. This features an older female voice singing the main melody. This is accompanied by a tenor guitar playing two chords in a repeated rhythm. A male voice sings a fill after a line by the female voice. There is no percussion in this song. There are no other instruments. This is a celebration song sung in a foreign language. | 2009-05-25T20:10:09Z | Escucha Joropo | Joropo Tradicional del Oriente Venezolano. Remigio Fuentes popularmente conocido como "Morocho Fuentes" es extraordinario en la ejecución de La Mandolina con un alto dominio en la interpretación del Joropo con Estribillo. Músico del estado Sucre. Posee la gran jocosidad que caracteriza al oriental. Disfruta con mucha humildad de su música y de la compañía de sus coterráneos. Celebramos su amistad | ["Music", "Mandolin", "Musical instrument", "Rattle (instrument)"] | ["live recording", "low quality recording", "foreign language", "female voice", "stringed instrument", "tenor guitar", "no percussion"] | 0 | nb_7c2xPKYA | 4562 | |
Harmonic chords, hammer ons, fast popping and slapping | This clip features a home recording of a musical piece using low quality gear. The clip is of a bass guitar and the sound is captured on the video capturing device and not through a mixer. The bass is playing hammer ons and harmonic notes. The notes are played on a particular scale. No percussion is played and no other instruments are featured in this song. | 2009-03-18T03:04:59Z | Randall Martinez | This is a video of me at Russo's Guitar Center in Omaha Nebraska. I've been playing in a band for 3 years and this will be my 9th year of bass. I was on spring break and just needed to swing in to a shop to get my fix since i didn't bring my bass. I'm playing a music man bass and an ampeg svt classic head and speaker cab. | ["Music", "Musical instrument", "Harmonic"] | ["low quality recording", "home recording", "video camera recording", "bass guitar", "harmonics", "bass hammer on"] | 0 | 6TSluKI0X54 | 760 | |
Guitar Hero | This clip features 2 distortion guitars playing a metal song. A high pitched male voice sings the main melody. This is accompanied by percussion playing a simple rock beat in common time. A bass guitar plays a bassline with a descending run. The distortion guitars play power chords followed by a guitar lick. One of the guitars plays one chord a little after the other guitar making it sound dissonant. This song can be played in an action movie. | 2006-04-25T16:32:40Z | Kim Burkart | Two Dudes Playing Guitar Hero | ["Guitar", "Music", "Musical instrument", "Roll", "Plucked string instrument"] | ["low quality recording", "metal song", "distortion guitar", "multiple guitars", "bassline", "power drumming", "male voice", "out of time guitar", "moderate tempo"] | 0 | dVUgd8ot6BE | 3794 |
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;