musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "medium tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- acoustic drums · 5 ✖
- amateur recording · 5 ✖
- medium tempo · 5 ✖
- e-bass 4
- e-guitar 2
- e-guitars 2
- acoustic snare 1
- clapping and cheering 1
- classical-rock 1
- comedic 1
- crowd laughing 1
- digital soundeffects 1
- ecstatic 1
- hammond organ 1
- indirock 1
- laid back energy 1
- male voice singing 1
- piano 1
- reggae 1
- relaxing 1
- zitar 1
musiccaps_names (array) 16 ✖
- Music 5
- Musical instrument 2
- Plucked string instrument 2
- Acoustic guitar 1
- Blues 1
- Country 1
- Grunge 1
- Guitar 1
- Punk rock 1
- Reggae 1
- Rock music 1
- Sitar 1
- Ska 1
- Song 1
- Speech 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kong Solo Guitar Blues Rock | This audio contains someone playing a distorted e-guitar solo in a higher register along with acoustic drums with cymbal hits and a half open hit. An e-bass is underlining the rhythm. There are digital comedic noises and laughter that seem not to be part of the musical composition. This song may be playing in a comedic tv-show. | 2012-02-13T13:30:54Z | nut3128 | ["Blues", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["amateur recording", "comedic", "crowd laughing", "digital soundeffects", "e-guitar", "acoustic drums", "e-bass", "medium tempo", "ecstatic"] | 6 | 3jLef5eHgzU | 494 | ||
The Haunted - Pourquoi (60's Garage Punk) | A e-guitar takes the lead melody along with the hammond organ. The drums and the bass are providing a rock groove in the background. Another e-guitar is playing along with the bass on the lower notes, it's highly distorted and has some overdrive on it. The male singer streams and sings. His voice is full of reverb and delay. The whole recording is of poor quality. This song may be playing at an old bar. | 2010-10-05T23:32:54Z | heavenlyblueorange | The Haunted - Pourquoi (cover of Music Machine's Talk Talk in French) Montreal, Canada | ["Swing music", "Music", "Punk rock", "Ska", "Song"] | ["indirock", "hammond organ", "e-guitars", "male voice singing", "acoustic drums", "amateur recording", "medium tempo"] | 6 | CRDDdjDinYc | 1364 | |
Freddie McGregor and the Big Ship band 'intro' @ Reggae Geel festival,03-08-2013 | Someone is playing an acoustic drum groove with a snare that uses reverb. An e-bass is playing a sub bassline. An e-guitar is strumming short rhythmic chords on the backbeat giving this music its reggae vibe. A keyboard is playing a sound in the mid range and another keyboard responds with a countermelody playing a melody using a brass sound. In the background you can hear people talking. This song may be playing live at a festival. | 2013-08-04T13:37:08Z | Cultivizion | Freddie McGregor and the Big Ship band 'intro' @ Reggae Geel festival,03-08-2013,Belgium | ["Music", "Reggae"] | ["amateur recording", "reggae", "acoustic drums", "e-guitar", "e-bass", "piano", "medium tempo", "laid back energy"] | 6 | JFGNmPzPXeA | 1984 | |
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 | |
Sitar Beatles Medley | Someone is playing a snare with brushes along to zitars playing a repeating melody. In the background you can hear an e-bass and an acoustic guitar strumming chords. This song may be playing in a live concert. | 2008-04-02T14:33:47Z | The Biryani Boys | Prasanna Leads this group in a medley of Beatles covers. FULL VERSION. www.newyorksitar.com. Produced By: Flicker Filmworks. www.flickerfilmworks.com | ["Country", "Music", "Musical instrument", "Plucked string instrument", "Sitar"] | ["zitar", "acoustic snare", "acoustic drums", "e-bass", "amateur recording", "medium tempo", "relaxing"] | 6 | yreWOyWr6Uk | 5444 |
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;