musiccaps_details (view)
5 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "passionate male vocal" and musiccaps_aspects contains "rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- live performance · 5 ✖
- low quality 5
- passionate male vocal · 5 ✖
- rock · 5 ✖
- energetic 4
- groovy bass guitar 3
- electric guitar melody 2
- emotional 2
- noisy 2
- punchy kick 2
- punchy snare 2
- addictive 1
- arpeggiated electric guitar melody 1
- boomy bass guitar 1
- choir 1
- crowd noises 1
- distant 1
- electric guitar solo melody 1
- energetic cymbals 1
- energetic drums 1
- exciting 1
- funky 1
- funky bass guitar 1
- groovy 1
- harmonizing male vocals 1
- mellow kick hits 1
- mellow snare 1
- messy 1
- muffled kick hits 1
- muffled snare hits 1
- passionate 1
- passionate female vocal 1
- reverberant 1
- shimmering cymbals 1
- shimmering hi hats 1
- shimmering open hats 1
- solo brass melody 1
- soulful 1
- wide electric guitar melody 1
musiccaps_names (array) 9 ✖
- Music 4
- Rock and roll 3
- Rock music 3
- Singing 3
- Punk rock 2
- Bass guitar 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 | ||
SPYAIR - Samurai Heart (live) ENG subs | The low quality recording features a live performance of a rock song that consists of passionate male vocal singing over electric guitar solo melody, energetic cymbals, muffled snare and kick hits and groovy bass guitar. There are also some crowd noises, singing along. It sounds energetic, emotional and addictive, thanks to that cadence. | 2014-08-25T16:54:22Z | Rrhae Reyes | Video not mine credit to the owner But the subs are mine xD IKE is so handsome here This is a gintama perf so you can see the anime dubbers here | ["Singing", "Music", "Roll"] | ["low quality", "crowd noises", "noisy", "rock", "live performance", "electric guitar solo melody", "energetic cymbals", "muffled snare hits", "muffled kick hits", "passionate male vocal", "groovy bass guitar", "energetic", "emotional", "addictive"] | 4 | P3ZPbGjHFXE | 2499 | |
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 | |
Don't Stop Believin' Karaoke | The low quality recording features a live performance of a rock song that consists of a passionate male vocal, followed by passionate female vocal singing over shimmering cymbals, mellow snare and kick hits, electric guitar melody and groovy bass guitar. It sounds distant, reverberant, but also energetic. | 2008-11-26T18:49:47Z | camelllamamoose | This is a very rough version of a karaoke version of Don't Stop Believin' by Journey If you listen carefully you can hear the vocals in the background | ["Punk rock", "Rock music"] | ["low quality", "rock", "live performance", "passionate male vocal", "passionate female vocal", "shimmering cymbals", "mellow snare", "electric guitar melody", "groovy bass guitar", "mellow kick hits", "reverberant", "distant", "energetic"] | 4 | s5kz8qg4B2Y | 4923 | |
"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;