musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "bass" and musiccaps_aspects contains "rock song" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 25 ✖
- bass · 5 ✖
- rock song · 5 ✖
- moderate tempo 4
- percussion 4
- distortion guitar 3
- guitar solo 2
- instrumental 2
- low quality audio 2
- male voice 2
- overdriven guitar 2
- amateur recording 1
- blues song 1
- female voice 1
- guitar harmonics 1
- happy mood 1
- harmonics 1
- no voice 1
- no voices 1
- power percussion 1
- romantic mood 1
- scratch harmonics 1
- slow tempo 1
- speed metal 1
- string bending 1
- whammy bar dive bomb 1
musiccaps_names (array) 13 ✖
- Music 5
- Pulse 2
- Rock music 2
- Bowed string instrument 1
- Cacophony 1
- Electric guitar 1
- Grunge 1
- Guitar 1
- Heavy metal 1
- Musical instrument 1
- Plucked string instrument 1
- Progressive rock 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tomáš Valášek - www.kytarova-skola.com, www.kytara-online.cz | This rock song features a guitar solo being played on a distortion guitar. This starts off with a string bend followed by a descending lick. A harmonic string scratch technique is played to produce a screeching sound. This is followed by a fast ascending scale run. This is accompanied by percussion playing a simple rock beat. The bass plays the root notes of the chords. There are no voices in this song. This is an instrumental. Due to the low audio quality, the instruments are not clearly heard. | 2010-04-24T08:39:01Z | kytarovaskola | www.kytara-online.cz, www.kytarova-skola.com. | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Pulse", "Plucked string instrument", "Bowed string instrument"] | ["rock song", "low quality audio", "no voices", "instrumental", "distortion guitar", "guitar solo", "percussion", "bass", "harmonics", "moderate tempo", "string bending"] | 0 | CM7jMnBXw2Y | 1356 | |
Dio - Time to Burn | This rock song features a guitar solo played on a guitar with heavy distortion. The solo starts off with high pitch notes being played. This is followed by a dive bomb using the whammy bar. The guitar then plays a descending lick followed by scratch harmonics and another descending run. This is accompanied by percussion playing a powerful rock beat in common time. The bass plays the root notes of the chords. Another distortion guitar plays power chords to back the lead guitar. There are no voices in this song. This song can be used in a car chase sequence in a movie. | 2007-03-20T01:01:01Z | Pablo A. | Dio - Time To Burn Sacred Heart: The Video 86' | ["Music", "Cacophony"] | ["rock song", "guitar solo", "distortion guitar", "moderate tempo", "guitar harmonics", "scratch harmonics", "whammy bar dive bomb", "speed metal", "no voice", "instrumental", "power percussion", "bass"] | 0 | PQ7cX2Cnusg | 2533 | |
Sesame Street - ZZ Blues | This blues song features a male voice singing the main melody at a comfortable pitch. This is accompanied by percussion playing a simple rock beat in common time. An overdriven guitar plays a blues riff. After one bar, the guitar and bass pause while the percussion and voice continues. The bass plays the root notes of the chords. The mood of this song is happy. This song can be played in a bar scene in a movie. | 2008-04-25T05:25:53Z | mstatz | A group that looks much like ZZ Top sings about the letter Z in ZZ Blues! A bluesy kind of song and another great lesson for kids. Big Bird makes an appearance before the video begins here. | ["Music", "Ska"] | ["rock song", "blues song", "male voice", "low quality audio", "overdriven guitar", "percussion", "bass", "happy mood", "moderate tempo"] | 0 | aLnBwjLUZao | 3530 | |
Alice in Chains Sea of Sorrow and Bleed the Freak ( Alice Unchained ) Tribute Band | This low quality recording features a male voice singing the main melody. This is accompanied by percussion playing a simple beat. After two bars, the percussion plays only the ride cymbal. A distortion guitar plays power chords and after two bars, lets the last chord ring. The bass plays the root notes of the chords. This song can be played in a Transformers style movie. | 2007-11-28T08:19:12Z | Audiocircle | Alice Unchained Performs Sea of Sorrow and Bleed the Freak Live in San Diego | ["Music", "Rock music", "Pulse", "Grunge"] | ["amateur recording", "male voice", "rock song", "distortion guitar", "bass", "percussion", "moderate tempo"] | 0 | pWHkmo9Kn8g | 4715 | |
Jingle - เก้าอี้ไม้ | This rock song features a female voice singing at a comfortable pitch. The song starts off with the voice singing vocables. This is accompanied by the overdriven guitar playing one chord three times followed by a second chord three times which is higher in pitch than the first chord. The percussion plays a role at that time. The voice continues to sing a phrase. One guitar harmonic note keeps ringing during this part. The overdriven guitar plays a descending chord pattern. The bass plays the root notes of the guitar. The percussion plays a simple beat in common time. This song can be played in a detective movie. | 2011-07-29T21:36:51Z | TuelieTwins | เก้าอี้ไม้ตัวนี้ Limited Edition !! ถึงละนะ... :D Yothiburana School | ["Heavy metal", "Music", "Rock music", "Progressive rock"] | ["rock song", "overdriven guitar", "female voice", "bass", "percussion", "slow tempo", "romantic mood"] | 0 | y_TnstfXeBQ | 5420 |
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;