musiccaps_details (view)
7 rows where search matches "guitar", musiccaps_aspects contains "energetic", musiccaps_aspects contains "rock" and musiccaps_names contains "Rock and roll"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- energetic · 7 ✖
- rock · 7 ✖
- low quality 5
- passionate male vocal 4
- punchy snare 4
- groovy bass guitar 3
- live performance 3
- shimmering hi hats 3
- energetic crash 2
- exciting 2
- mono 2
- punchy kick 2
- addictive 1
- boomy kick 1
- bouncy 1
- charged up 1
- choir 1
- echoing energetic male vocal 1
- electric guitar melody 1
- electric rhythm guitar chords 1
- energetic crash cymbals 1
- energetic drums 1
- energetic emo vocalist 1
- flat female vocal 1
- funky 1
- funky bass guitar 1
- gritty 1
- groovy 1
- groovy bass 1
- groovy electric guitar chords progression 1
- …
musiccaps_names (array) 9 ✖
- Music 7
- Rock and roll · 7 ✖
- Roll 4
- Rock music 2
- Singing 2
- Heavy metal 1
- Progressive rock 1
- Song 1
- Yell 1
youtube_published (date) 7 ✖
- 2006-10-11 1
- 2007-11-12 1
- 2010-06-21 1
- 2010-12-07 1
- 2011-10-08 1
- 2012-11-15 1
- 2012-12-27 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ずっと好きだった | The low quality recording features a live performance of a rock song and it consists of a passionate male vocal singing over groovy bass guitar, wide electric guitar melody, shimmering hi hats, punchy kick and snare hits. It sounds energetic and exciting. | 2011-10-08T06:45:59Z | Sheik | ["Singing", "Music", "Rock music", "Rock and roll"] | ["low quality", "rock", "live performance", "passionate male vocal", "wide electric guitar melody", "groovy bass guitar", "shimmering hi hats", "punchy kick", "punchy snare", "energetic", "exciting"] | 4 | InfQUMh935c | 1941 | ||
Yellowcard - Breathing (Live) | This is a punk rock song with an energetic, youthful feel that is still grungy and gritty. The guitar is dark and powerful in the low tones, contrasted by another electric guitar that's bright and warm on the off beats. The drummer plays a high octane drum beat with drum fills between each line of the lyrics. | 2006-10-11T05:14:12Z | Oscar Jara | $$$~Yellowcard~$$$ | ["Heavy metal", "Music", "Rock and roll", "Progressive rock"] | ["punk rock", "rock", "punk", "energetic", "charged up", "bouncy", "gritty", "grungy", "youthful", "heavy grungy electric guitar strumming", "energetic emo vocalist"] | 3 | NzVg-cFQJbE | 2386 | |
Foo Fighters - Rock and Roll - Kennedy Center Honors - Led Zeppelin | The low quality recording features a live performance of a rock song that consists of echoing, energetic male vocals that are singing over wide electric guitar chord progression, energetic crash cymbals, punchy snare, boomy kick and groovy bass guitar. It sounds energetic and exciting. | 2012-12-27T03:55:00Z | saveyouckufer | Foo Fighters - Rock and Roll - Kennedy Center Honors - Led Zeppelin Celebration Day http://amzn.to/TFuvtc | ["Music", "Roll", "Rock and roll"] | ["low quality", "echoing energetic male vocal", "wide electric guitar chord progression", "energetic crash cymbals", "punchy snare", "boomy kick", "groovy bass guitar", "rock", "live performance", "energetic", "exciting"] | 4 | Q8f6y2IcVg0 | 2600 | |
Solomon Burke performs Rock and Roll Hall of Fame Inductions 2001 | The low quality recording features a live performance of a rock song and it consists of passionate male vocal singing over energetic drums, funky bass guitar, electric guitar melody and solo brass melody. At the end of the loop, there is a short snippet of choir singing in harmony. Overall it sounds funky, energetic, soulful and passionate - as a live performance should sound. | 2010-12-07T18:15:11Z | Rock & Roll Hall of Fame | Solomon Burke performs Rock and Roll Hall of Fame Inductions 2001 Visit us! http://rockhall.com/ Subscribe to RockHall : http://www.youtube.com/subscription_center?add_user=rockhall Facebook: http://www.facebook.com/rockandrollhalloffame Twitter: http://twitter.com/rock_hall Google +: http://plus.google.com/u/0/115412030406922618012 Check out all the inductees: http://rockhall.com/inductees/ Upcoming events: http://rockhall.com/events/ | ["Singing", "Music", "Rock music", "Song", "Rock and roll", "Yell"] | ["rock", "low quality", "live performance", "passionate male vocal", "choir", "solo brass melody", "funky bass guitar", "energetic drums", "electric guitar melody", "energetic", "soulful", "passionate", "funky"] | 4 | VfARCp38XtA | 3018 | |
The Connells - Scotty's Lament | The Rock song features a passionate male vocal, layered with harmonizing background male vocals, singing over electric rhythm guitar chords spread widely in the stereo image, thin snare, energetic crash, groovy bass, shimmering hi hats and punchy kick hits. The drums are very reverberant, which is probably the reason why they sound softer. It sounds addictive, thanks to those harmonizing vocals, and energetic overall. | 2007-11-12T22:30:12Z | streetsintherain | The video for "Scotty's Lament", made in 1987. | ["Music", "Roll", "Rock and roll"] | ["rock", "passionate male vocal", "harmonizing background male vocal", "electric rhythm guitar chords", "groovy bass", "thin snare", "energetic crash", "shimmering hi hats", "punchy kick hits", "reverberant", "addictive", "energetic"] | 4 | hKSg3zFB2dE | 4095 | |
Rock and Roll Dance in Radio Planeta 2 | The low quality recording features an uptempo rock song that consists of suspenseful electric guitar melody, punchy snare, simple kick pattern, groovy bass guitar, tinny percussive elements and passionate male vocal singing over it. The recording is in mono and it sounds energetic, groovy and like something you would dance to with your friends. | 2012-11-15T13:07:30Z | Bertjuh Chevy | ["Music", "Roll", "Rock and roll"] | ["rock", "suspenseful electric guitar melody", "punchy snare", "simple kick pattern", "groovy bass guitar", "passionate male vocal", "mono", "low quality", "energetic", "uptempo", "tinny percussive elements"] | 4 | lHlOSsnP48c | 4388 | ||
Iron Eagle - Old Enough to Rock and Roll.flv | The low quality recording features a rock song that consists of groovy electric guitar chord progression, smooth bass guitar, punchy snare and kick hits, shimmering hi hats and flat female vocals singing over it. At the end of the first half of the loop, there is a short snare roll alongside glissando organ keys melody, sliding perfectly into the next section, which begins with the energetic crash hit. It sounds energetic, groovy, and kind of vintage and warm, since it really sounds old - especially because the song is in mono. | 2010-06-21T07:13:17Z | 2kgt | ["Music", "Roll", "Rock and roll"] | ["low quality", "mono", "groovy electric guitar chords progression", "smooth bass guitar", "punchy snare", "punchy kick", "short snare roll", "flat female vocal", "rock", "shimmering hi hats", "organ keys glissando", "energetic", "groovy", "energetic crash", "vintage", "warm"] | 4 | lOIzOWKd47E | 4393 |
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;