musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "distortion guitar" and musiccaps_aspects contains "rock song" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- distortion guitar · 4 ✖
- rock song · 4 ✖
- bass 3
- moderate tempo 3
- percussion 3
- amateur recording 2
- guitar solo 2
- instrumental 2
- breakup song 1
- crowd whistles 1
- female voice 1
- guitar harmonics 1
- harmonics 1
- low quality audio 1
- male voice 1
- no voice 1
- no voices 1
- power percussion 1
- scratch harmonics 1
- speed metal 1
- string bending 1
- upbeat melody 1
- whammy bar dive bomb 1
musiccaps_names (array) 13 ✖
- Music 4
- Pulse 2
- Bowed string instrument 1
- Cacophony 1
- Electric guitar 1
- Grunge 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Pop music 1
- Rock music 1
- Singing 1
- Yell 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 | |
Joan Jett----I Hate Myself For Loving You | This song is an amateur recording of a live performance. This features a female voice singing the main melody. This is accompanied by a distortion guitar playing power chords. The percussion plays a simple rock beat. The sound of crowd whistles are heard in this clip. Other instruments are not audible as the quality of the audio is low. This song can be played in a romantic comedy movie. | 2007-05-13T16:08:35Z | rro003 | Joan Jett concert May 2007 | ["Singing", "Music", "Pop music", "Yell"] | ["amateur recording", "female voice", "crowd whistles", "distortion guitar", "percussion", "rock song", "breakup song", "upbeat melody"] | 0 | naZE-MvNpaI | 4558 | |
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 |
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;