musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "amateur recording", musiccaps_names contains "Musical instrument" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- amateur recording · 4 ✖
- acoustic drums 2
- aggressive 2
- e-guitar 2
- bass 1
- bass guitar 1
- cover 1
- dangerous 1
- distorted electric guitar 1
- e-bass 1
- grunge rock 1
- grunt-like singing 1
- guitar 1
- heavy metal 1
- male vocal 1
- medium to fast tempo 1
- melancholic mood 1
- no other instruments 1
- no voice 1
- noisy 1
- percussion 1
- poor quality 1
- rebellious 1
- repetitive phrase 1
- rock 1
- screaming voice sample 1
- slow tempo 1
- tremolo effect 1
musiccaps_names (array) 13 ✖
- Music 4
- Musical instrument · 4 ✖
- Rock music · 4 ✖
- Pulse 3
- Drum kit 2
- Guitar 2
- Cymbal 1
- Distortion 1
- Drum 1
- Effects unit 1
- Harmonic 1
- Heavy metal 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Tea Party - Lullaby Live In Montreal - July 7, 2011 | This amateur recording features a rock song. A repetitive phrase is played on the guitar. The first bar consists of only the guitar sound. The bass and percussion start playing after one bar. The bass plays one note in groups of twos. The percussion plays a groovy rock beat. The hi-hat is played in a group of four strokes on the closed hi-hat followed by one stroke on the open hi-hat. There are no voices in this song. The mood of this song is melancholic. | 2011-07-10T12:36:07Z | Luc Beaulieu | Live at Le Métropolis, Montreal, Québec, Canada | ["Drum kit", "Guitar", "Music", "Musical instrument", "Rock music", "Pulse"] | ["amateur recording", "rock", "guitar", "repetitive phrase", "percussion", "bass", "no voice", "no other instruments", "slow tempo", "melancholic mood"] | 0 | GcYeBWujhjw | 1741 | |
Modtone Harmonic Tremor Tremolo pedal guitar demo | This audio contains a e-guitar running through a tremolo effect that gets into faster modulation speed. This is an amateur recording and may be used for educational purposes. | 2008-12-04T04:31:00Z | gearmanndude | check out http://www.guitar-emporium.com for all the cool boutique pedals I use and demo...IN STOCK! The Mod Tone MT-HT is a top quality, low budget Tremolo Vibrato pedal. Very versatile and solid. Gibson Les Paul Historic into an Orange Tiny Terror amplifier. Enjoy! | ["Effects unit", "Guitar", "Music", "Musical instrument", "Rock music", "Harmonic", "Plucked string instrument", "Distortion"] | ["amateur recording", "e-guitar", "tremolo effect", "medium to fast tempo"] | 6 | KSFND-AdqZs | 2083 | |
Dark Sermon - Intro / In Tongues Live Drum Cam - Bryson St. Angelo | Someone is playing acoustic drums with a lot of loud cymbal hits along with a screaming male vocal. A distorted e-guitar is playing long low notes. The atmosphere sounds dangerous and aggressive. This song may be playing in the band room practicing drumming. | 2013-05-23T16:42:07Z | DarkSermonTV | Dark Sermon live at The 7 Venue in Douglasville, GA. | ["Cymbal", "Drum", "Drum kit", "Heavy metal", "Music", "Musical instrument", "Rock music", "Pulse"] | ["heavy metal", "amateur recording", "screaming voice sample", "acoustic drums", "e-guitar", "e-bass", "dangerous", "aggressive"] | 6 | bkQrvXXIRng | 3644 | |
Banda - Floyd The Barber (Nirvana) | This is an amateur cover of a grunge rock music piece. Both the recording and the playing are of poor quality. There is a male vocalist singing in a grunt-like manner as the lead. A crunchy riff is being played by the distorted electric guitar and the bass guitar while the acoustic drums are playing a simple rock beat. The atmosphere is rebellious and noisy. | 2006-12-04T17:57:48Z | drugstoremarc | Marco e Roberto unem-se a Joao Cassio e Benedito em sua banda para tocar "Floyd The Barber", do Nirvana. Marco and Roberto unite with Joao Cassio and Benedito on their band to play "Floyd The Barber", of Nirvana. | ["Music", "Musical instrument", "Rock music", "Pulse"] | ["cover", "amateur recording", "poor quality", "grunge rock", "male vocal", "grunt-like singing", "distorted electric guitar", "bass guitar", "acoustic drums", "rebellious", "aggressive", "noisy"] | 9 | oPiyXhxRGe4 | 4626 |
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;