musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "low quality audio recording" and musiccaps_aspects contains "rock genre" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 11 ✖
- distortion effect 2
- low quality audio recording · 2 ✖
- rock genre · 2 ✖
- bass guitar 1
- drums 1
- electric guitar 1
- electric guitars 1
- improvisation 1
- live recording 1
- screaming male voice 1
- string noise 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
jodee frawlee melodic shredding in A harmonic minor/ Aminor | The excerpt features an electric guitar with a distortion effect on playing what sounds to be an improvised passage. The style comes closest to the rock genre. The lower quality of the audio recording coupled with string noises makes me think this is an amateur recording, most probably recorded with a phone. | 2010-11-11T00:32:32Z | jodee Frawlee | Just some shredding w/ an idea I have for a future song | ["Tapping (guitar technique)", "Effects unit", "Electric guitar", "Guitar", "Music", "Harmonic", "Distortion"] | ["electric guitar", "distortion effect", "improvisation", "rock genre", "string noise", "low quality audio recording"] | 2 | XrjkzI6TVwc | 3229 | |
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 |
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;