musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "bass guitar" and musiccaps_aspects contains "rock genre" sorted by youtube_published
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 14 ✖
- bass guitar · 4 ✖
- drums 4
- rock genre · 4 ✖
- distortion effect 3
- electric guitar 2
- electric guitars 1
- fast tempo 1
- female voice 1
- live recording 1
- low quality audio recording 1
- low quality recording 1
- male backing vocals 1
- male voice 1
- screaming male voice 1
musiccaps_names (array) 11 ✖
- Music 4
- Chorus effect 1
- Dubstep 1
- Independent music 1
- Inside, large room or hall 1
- Pop music 1
- Progressive rock 1
- Rock and roll 1
- Techno 1
- Whir 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Whir - Daria's Theme (Live at Circus Bar - 2001) | The rock music features a male voice singing a repeating melody and being backed by other male vocals. The electric guitar plays fast chords with a distortion effect on and the bass guitar follows with the same speed. The drums play a fast repeating rhythm. The quality of the audio is really low and so this leads me to believe this is an amateur recording. | 2007-12-16T16:36:07Z | Rety Matos | É isso aí: Show do Whir - Torto, mal gravado, com erros, muitos amigos e foda. Bem, pelo menos pra mim era muito foda... :) Sétima música do show: 7) Daria's Theme (Splendora Cover) Ah, show gravado no Circus Bar em 2001, dia do meu aniversário \o/ Abertura do Fuss. | ["Music", "Whir", "Rock and roll"] | ["low quality recording", "male voice", "male backing vocals", "electric guitar", "distortion effect", "drums", "bass guitar", "rock genre", "fast tempo"] | 2 | 3sIlpn9nvKU | 510 | |
Guns N' Roses - Rocket Queen (Steven Adler Drum Solo) (Live in Australia 1988) | The rock music features a screaming male voice singing a melody. One of the electric guitars accompanies the singer with strummed chords while the other, for the second part of the music excerpt, plays a melody. Both guitars have a distortion effect on. The drums play a well grounded rhythm and together with the bass guitar drive the pulse of the music. The quality of the audio recording is not that good, most probably this is an old live recording. | 2009-02-27T12:49:06Z | Christo Toupa | Guns N' Roses - Rocket Queen (Steven Adler Drum Solo) (Live in Australia 1988). | ["Music", "Yell", "Inside, large room or hall"] | ["low quality audio recording", "rock genre", "screaming male voice", "electric guitars", "distortion effect", "drums", "bass guitar", "live recording"] | 2 | qie2k2gZ7wA | 4809 | |
ZVEX Mastotron with bass (G&L L-1000) | The rock music features a bass guitar playing a repeating melody with a distortion effect in the really-low pitch register. A set of drums is accompanying the bassist with a well-rooted and repeating rhythm. | 2012-04-29T12:57:25Z | ou7shined | I just bought this fantastic fuzz pedal. I found a setting I liked and recorded a couple of mean riffs in my DAW. Bass and midi drums only. | ["Music", "Techno", "Chorus effect", "Dubstep"] | ["drums", "bass guitar", "distortion effect", "rock genre"] | 2 | oJ0rdNlghn4 | 4615 | |
ruido rosa- persona en vivo | The rock music features a female voice singing a melody. The band that accompanies her consists of drums, bass guitar and electric guitar. The drums play a repetitive rhythm, the bass guitar also incorporates slides into its playing and the electric guitar plays a simple melody that's composed of repetitive notes. | 2013-11-18T01:49:39Z | PIC AZO | ["Music", "Independent music", "Pop music", "Progressive rock"] | ["female voice", "bass guitar", "drums", "electric guitar", "rock genre"] | 2 | RIpfb9LSFe8 | 2691 |
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;