musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "low quality", musiccaps_aspects contains "passionate male vocal" and musiccaps_names contains "Rock and roll"
This data as json, CSV (advanced)
Suggested facets: youtube_description
musiccaps_aspects (array) 32 ✖
- low quality · 4 ✖
- passionate male vocal · 4 ✖
- rock 4
- energetic 3
- live performance 3
- punchy snare 3
- groovy bass guitar 2
- punchy kick 2
- arpeggiated electric guitar melody 1
- boomy bass guitar 1
- choir 1
- electric guitar melody 1
- emotional 1
- energetic drums 1
- exciting 1
- funky 1
- funky bass guitar 1
- groovy 1
- harmonizing male vocals 1
- messy 1
- mono 1
- noisy 1
- passionate 1
- shimmering hi hats 1
- shimmering open hats 1
- simple kick pattern 1
- solo brass melody 1
- soulful 1
- suspenseful electric guitar melody 1
- tinny percussive elements 1
- uptempo 1
- wide electric guitar melody 1
musiccaps_names (array) 9 ✖
- Music 4
- Rock and roll · 4 ✖
- Rock music 2
- Singing 2
- Bass guitar 1
- Punk rock 1
- Roll 1
- Song 1
- Yell 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 | ||
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 | |
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 | ||
"11 O'Clock Tick Tock" - Belfast , January 1981 | The low quality recording features a live performance of a rock song and it features passionate male vocals, alongside harmonizing male vocals, singing over arpeggiated electric guitar melody, boomy bass guitar, punchy kick and snare hits and shimmering open hats. It sounds noisy and messy, as the frequencies are clashing with each other, but it is still groovy and emotional regardless. | 2006-04-19T19:19:34Z | u2log | The audience reaction is great in this clip. | ["Bass guitar", "Music", "Punk rock", "Rock and roll"] | ["low quality", "rock", "live performance", "arpeggiated electric guitar melody", "passionate male vocal", "harmonizing male vocals", "boomy bass guitar", "shimmering open hats", "punchy kick", "punchy snare", "messy", "noisy", "groovy", "emotional"] | 4 | zWJC_qr2610 | 5486 |
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;