musiccaps_details (view)
10 rows where musiccaps_aspects contains "rock song"
This data as json, CSV (advanced)
| 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 | |
| Replacement Tooth Brush Head | The low quality recording features a buzzy vibrating sound while a rock song on a radio, or some other device that can reproduce music, in the background is playing. The recording is very noisy and it sounds like it was recorded with a phone. | 2012-07-06T12:17:29Z | mark07794 | ["Electric toothbrush", "Music"] | ["low quality", "buzzy vibrating sound", "rock song", "radio", "noisy"] | 4 | L3ZtE3rD2nc | 2147 | ||
| Classical Gas by Roy Clark Band Banjo Pickin' 1987 Live | This amateur recording features a rock song. The main melody is played on violins. This is accompanied by percussion playing with breaks matching the breaks in the violin parts. At the end, the violins play a sustained note and a banjo starts to play a melody. A tambourine is played on the first count of the second bar after the banjo starts to play. This is an uptempo song and has a happy feel. This instrumental song can be played in a coffee shop. | 2007-06-12T06:30:56Z | NelnetDude | Enjoy! | ["Banjo", "Music", "Musical instrument", "Bowed string instrument"] | ["amateur recording", "rock song", "instrumental", "no voices", "violins", "banjo", "tambourine", "simple percussion", "happy mood", "moderate tempo"] | 0 | MpWGx5odhh8 | 2301 | |
| 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 | |
| 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 | |
| I Love Rock and Roll LIVE in HD Up Close - Miley Cyrus Portland Wonder World 2009 Tour HQ | The song is a modern pop song performed live performance. A female sings this melody with a strong drumming rhythm. The song is highly distorted with high noise levels and distortion. The song is a rock classic and performed live in front of a noisy audience. | 2009-09-22T03:01:44Z | Chris B | Miley Cyrus performing I Love Rock and Roll live in Portland. Filmed from 2nd Row with DSC-HX1 in HD quality. From her Wonder World 2009 concert LIVE in Portland. Opening Night! | ["Music", "Roll", "Rock and roll"] | ["poor audio quality", "distorted audio", "hissing noises", "low frequency deficiency", "rock concert", "live performance", "female pop star", "medium tempo", "rock song", "treble overload", "crowds cheering", "strong drumming rhythm", "a sense of low frequencies", "amateur home video", "people singing along"] | 1 | qXgSlhWbWLU | 4796 | |
| Drops Of Jupiter | This is a low quality recording of a rock song. The main lead melody is sung by a male voice. Other male voices sing vocables in the background in between lines. A string ensemble plays fills in the background with an ascending lick in between lines. The percussion plays a simple rock beat in common time with snare strokes on every alternate count. The bass plays the root notes of the chords. The mood of this song is motivational. Other instruments cannot be identified due to the low audio quality. This song can be played at the end credits of a superhero movie. | 2007-04-30T05:54:49Z | PunkPinkPower | A Tribute to Power Rangers Ninja Storm in its entirety. That I am abnormally proud of. An epic season deserved an epic song, so I chose Drops of Jupiter by Train. And Always Remember: A happy ending is nothing more than a new beginning! | ["Independent music"] | ["low quality recording", "rock song", "male voice", "strings", "percussion", "bass", "vocables", "bass", "moderate tempo", "motivational"] | 0 | rnOIXOGfSUE | 4901 | |
| 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;