musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "rock", musiccaps_aspects contains "shimmering hi hats" and musiccaps_names contains "Rock and roll"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- rock · 5 ✖
- shimmering hi hats · 5 ✖
- punchy snare 4
- energetic 3
- low quality 3
- punchy kick 3
- energetic crash 2
- groovy 2
- groovy bass 2
- live performance 2
- passionate male vocal 2
- smooth bass guitar 2
- wide electric guitar melody 2
- acoustic rhythm guitar 1
- addictive 1
- easygoing 1
- electric guitar melodies 1
- electric rhythm guitar chords 1
- exciting 1
- flat female vocal 1
- flat male vocal 1
- funky 1
- groovy bass guitar 1
- groovy electric guitar chords progression 1
- groovy keys chords 1
- harmonizing background male vocal 1
- mellow kick hits 1
- mono 1
- noisy 1
- organ keys glissando 1
- …
musiccaps_names (array) 8 ✖
- Music 5
- Rock and roll · 5 ✖
- Rock music 2
- Roll 2
- Country 1
- Psychedelic rock 1
- Singing 1
- Ska 1
youtube_published (date) 5 ✖
- 2007-11-12 1
- 2008-12-15 1
- 2009-09-30 1
- 2010-06-21 1
- 2011-10-08 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 | ||
Duane Eddy - Because They`re Young | The Rock song features a sustained strings melody, groovy bass, electric guitar melodies, punchy snare, shimmering hi hats, mellow kick hits and acoustic rhythm guitar. It sounds soulful and like something you would hear during the 70s. The recording is a bit noisy. | 2008-12-15T22:20:12Z | 45RPMbyMikeEvans | Duane Eddy`s UK chart hit singles - 1958 Rebel Rouser #19 1959 Cannonball #22 1959 Peter Gunn # 6 1959 Yep! #17 1959 40 Miles of Bad Road #11 1959 Some Kind-A-Earthquake #12 1960 Bonnie Came Back #12 1960 Shazam #4 1960 Becuase They`re Young #2 1960 Kommotion #13 1961 Pepe #2 1961 Theme From Dixie #7 1961 Ring Of Fire #17 1961 Drivin` Home #30 1961 Caravan #42 1962 Deep In The Heart Of Texas #19 1962 Ballad Of Paladin #10 1962 ( Dance With The ) Guitar Man # 4 1963 Boss guitar # 27 1963 Lonely Boy Lonely Guitar #35 1963 Your Baby`s Gone Surfin` #49 1975 Play Me Like You Play Your Guitar #9 1986 Peter Gunn #8 ( with Art of Noise ) | ["Music", "Psychedelic rock", "Rock music", "Rock and roll"] | ["rock", "sustained strings melody", "groovy bass", "electric guitar melodies", "punchy snare", "shimmering hi hats", "mellow kick hits", "acoustic rhythm guitar", "soulful", "noisy"] | 4 | bKm2_67xtVs | 3617 | |
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 | |
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 | ||
Shake Rattle n' Roll demo video 1 | The low quality recording features a live performance of a rock song that consists of flat male vocal singing over a wide electric guitar melody, groovy keys chords, located in the right channel of the stereo image, smooth bass guitar, shimmering open hats and hi hats and punchy kick and snare hits. It sounds groovy, funky and easygoing - like something you could lightly dance to. | 2009-09-30T03:58:48Z | Bill Crane | Demo video recorded 9/28/09. | ["Country", "Music", "Ska", "Rock and roll"] | ["low quality", "rock", "live performance", "flat male vocal", "wide electric guitar melody", "groovy keys chords", "smooth bass guitar", "shimmering hi hats", "punchy snare", "punchy kick", "shimmering open hats", "groovy", "funky", "easygoing"] | 4 | rmKh9uaikTU | 4900 |
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;