musiccaps_details (view)
5 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "e-guitars"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- acoustic drums · 5 ✖
- amateur recording · 5 ✖
- e-guitars · 5 ✖
- e-bass 4
- male voice singing 2
- medium tempo 2
- agressive 1
- alternative7rock 1
- background cheering 1
- clapping and cheering 1
- classical-rock 1
- energetic 1
- fast tempo 1
- female voice singing 1
- hammond organ 1
- hardrock/punkrock 1
- indirock 1
- laughing 1
- male voice screaming 1
- progressive rock 1
- upbeat 1
- uptempo 1
musiccaps_names (array) 14 ✖
- Music 5
- Angry music 1
- Giggle 1
- Grunge 1
- Guitar 1
- Punk rock 1
- Rock and roll 1
- Rock music 1
- Roll 1
- Singing 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 |
---|---|---|---|---|---|---|---|---|---|---|
Slash not happy with guitar tech Camp Freddy 12- | An acoustic drum and a bass are repeating the same pattern along with two e-guitars playing along with the melody while a male voice sings slightly soulful and loud. In the background a crowd is sheering. The recording is of very poor audio quality. This song may be playing at a live concert. | 2013-12-24T22:43:09Z | jwalker1200 | Camp Freddy at The Roxy Hollywood,ca. Slash comes out to perform "Schools Out" discovers that his guitar is out of tune! | ["Singing", "Guitar", "Music", "Roll", "Rock and roll"] | ["alternative7rock", "e-guitars", "e-bass", "acoustic drums", "background cheering", "male voice singing", "amateur recording", "uptempo"] | 6 | 1MwaXCfUvX8 | 263 | |
Lamborghini vs. Ferrari | An acoustic drum is playing a fast and complex drum groove with a lot of crash hits and double bass drum. Distorted e-guitars strumming wild chords along with an e-bass holding the melody while a male voice is screaming/singing loud and aggressively. In-between the song high and awkward laughing can be heard. This is an amateur recording. This song may be playing at a hard rock tattoo studio. | 2008-04-07T06:27:38Z | imoldgregggggggg | Fuck Lambos, a cool video made by me. edit-Okay, if you guys keep posting these worthless, false comments, that have untrue statements, I'm just going to disable comments. Either make sure your argument has facts to back it up, or just post a comment saying something other than "lambos rule". It's not going to change my opinion; especially when everything you say is FALSE. edit-HEY FUCKERS, I KNOW THE MUSIC SUCKS; THATS WHY I PUT IT THERE FOR THE LAMBOS. one more edit: FUCKERS; I KNOW ONE OF THE CARS IS AN AUDI. I PUT IT IN THERE BECAUSE AUDI OWNS LAMBO. IT WAS A JOKE. OKAY? AND I DON'T LISTEN TO THAT GAY FUCKING MUSIC. IT WAS ALSO A JOKE. | ["Music", "Giggle"] | ["hardrock/punkrock", "acoustic drums", "e-guitars", "e-bass", "laughing", "male voice screaming", "fast tempo", "amateur recording", "agressive"] | 6 | 8ynjAtF5VnA | 963 | |
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 | |
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 | |
Mother May I -EATMEWHILEIMHOT! lyrics [: | Someone is playing a loud acoustic drums full of kick and low tom hits sounding wild and psychedelic along with sliding e-guitars building up tension before breaking into the next part of the song with a lot of crash hits and the guitars strumming distorted chords: The e-bass is playing along one note to create tension before breaking into a bassline that gives the song more power. The instruments are panned to the left and right side of the speakers. The female voice is singing loud and in the mid-range. This song may be playing at a festival where everybody is dancing. | 2009-12-18T08:53:15Z | SceneGirl09x | :D | ["Music", "Angry music"] | ["progressive rock", "acoustic drums", "e-guitars", "e-bass", "female voice singing", "amateur recording", "upbeat", "energetic"] | 6 | pR87Ts3a0e8 | 4709 |
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;