musiccaps_details (view)
6 rows where musiccaps_aspects contains "moderate tempo" and musiccaps_aspects contains "rock song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- moderate tempo · 6 ✖
- rock song · 6 ✖
- bass 5
- percussion 4
- distortion guitar 3
- instrumental 3
- male voice 3
- amateur recording 2
- guitar solo 2
- happy mood 2
- low quality audio 2
- no voices 2
- banjo 1
- blues song 1
- guitar harmonics 1
- harmonics 1
- low quality recording 1
- motivational 1
- no voice 1
- overdriven guitar 1
- power percussion 1
- scratch harmonics 1
- simple percussion 1
- speed metal 1
- string bending 1
- strings 1
- tambourine 1
- violins 1
- vocables 1
- whammy bar dive bomb 1
musiccaps_names (array) 13 ✖
- Music 5
- Bowed string instrument 2
- Musical instrument 2
- Pulse 2
- Banjo 1
- Cacophony 1
- Electric guitar 1
- Grunge 1
- Guitar 1
- Independent music 1
- Plucked string instrument 1
- Rock music 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 | |
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 | |
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 | |
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 |
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;