musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums", musiccaps_author = 6 and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- acoustic drums · 3 ✖
- e-bass 3
- e-guitar 2
- acoustic piano 1
- amateur recording 1
- clapping and cheering 1
- classical-rock 1
- congas 1
- e-guitars 1
- gospel/blues 1
- hiphop 1
- low to higher register 1
- male voice sample 1
- male voice talking 1
- male voices singing 1
- medium tempo 1
- scratching 1
- slow tempo 1
- uptempo 1
musiccaps_names (array) 9 ✖
- Music 3
- Speech · 3 ✖
- Electronic music 1
- Gospel music 1
- Grunge 1
- Inside, large room or hall 1
- Rhythm and blues 1
- Rock music 1
- Scratch 1
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 | |
Nirvana - The Man Who Sold The World Subtitulado Español Ingles | This song contains acoustic drums playing a simple rock groove after coming in with some fill-ins on the toms. An e-bass is playing along. An e-guitar is playing a simple repeating melody then another e-guitar comes in strumming chords in the background. You can hear clapping and the crowd screaming and cheering. This song may be playing at a live concert. | 2012-08-09T21:59:59Z | diamante183 | "The Man Who Sold the World" es una canción compuesta por el músico británico David Bowie. La canción está incluida en el álbum del mismo nombre, lanzado en 1970. la banda estadounidense de grunge, Nirvana, lanzado en noviembre de 1994. El álbum muestra el concierto acústico que la banda hizo en los estudios Sony Music en Nueva York el 18 de noviembre de 1993. El álbum ganó un premio Grammy por Mejor Álbum de Música Alternativa en 1996. Una versión en DVD fue lanzada en 2007. fue aclamado por los críticos como prueba de que la banda podía trascender del sonido grunge a los que estaban comúnmente asociados, y también hizo una "radiografía" del diverso gusto de la banda en música. Los críticos resaltaron especialmente en los "íntimos" y "menos ruidosos" arreglos, como el acompañamiento de cuerdas en varias canciones así como la batería de Dave Grohl más suave en comparación con su usual forma de tocar, que permitieron que las excelentes habilidades para escribir canciones de Kurt brillaran en todo el concierto. El álbum abrió su primera semana en el número 1 del Billboard 200. | ["Music", "Rock music", "Speech", "Grunge"] | ["classical-rock", "e-guitars", "e-bass", "acoustic drums", "amateur recording", "clapping and cheering", "medium tempo"] | 6 | SKQbQXPjmvE | 2758 | |
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 |
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;