musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "enthusiastic", musiccaps_aspects contains "inferior audio quality" and musiccaps_aspects contains "male vocalist"
This data as json, CSV (advanced)
musiccaps_aspects (array) 50 ✖
- enthusiastic · 3 ✖
- inferior audio quality · 3 ✖
- male vocalist · 3 ✖
- energetic 2
- fast tempo 2
- groovy bass line 2
- live performance 2
- loud 2
- people talking 2
- pop rock 2
- youthful 2
- acoustic pop rock 1
- amateur recording 1
- boomy 1
- boomy bass 1
- bright 1
- classic pop 1
- concert 1
- coughing 1
- dance music 1
- electric guitar riff 1
- engaging 1
- female vocal backup 1
- gig 1
- incoherent music 1
- insistent 1
- intense drumming 1
- intense electric guitar 1
- jarring 1
- keyboard accompaniment 1
- keyboard harmony 1
- lively electric guitar 1
- medium tempo 1
- muddled sounds 1
- muffled audio 1
- people cheering 1
- pop 1
- popnrock 1
- punchy drumming 1
- recurring vocal riff 1
- rhythmic acoustic guitar 1
- rock 1
- rock and roll 1
- rustling 1
- static 1
- steady drumming 1
- synthesiser harmony 1
- vibrant 1
- vigorous vivacious 1
- vocal backup 1
musiccaps_names (array) 12 ✖
- Music 3
- Blues 1
- Country 1
- Inside, large room or hall 1
- Jazz 1
- Music of Latin America 1
- Musical instrument 1
- Rock and roll 1
- Rock music 1
- Roll 1
- Singing 1
- Vibration 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rock 'n' Roll Girls -- John Fogerty | A male vocalist sings this spirited rock and rock song. The tempo is fast with bright drumming, intense electric guitar feedback, keyboard harmony and rhythmic acoustic guitar with vocal backup. The song is upbeat, spirited, enthusiastic, vibrant, vivacious, buoyant and youthful with a dance groove. The sound quality is inferior making it difficult to understand the lyrics or the finer elements of this Rock and Roll song. | 2008-09-03T02:10:47Z | zanzkantdance | John Fogerty performs "Rock and Roll Girls" from Centerfield live in Oakland in 1986, set to various background videos. | ["Singing", "Music", "Musical instrument", "Rock music", "Roll", "Inside, large room or hall"] | ["male vocalist", "fast tempo", "intense electric guitar", "punchy drumming", "keyboard harmony", "vocal backup", "rhythmic acoustic guitar", "groovy bass line", "loud", "jarring", "inferior audio quality", "people cheering", "people talking", "energetic", "enthusiastic", "vigorous vivacious", "bright", "enthusiastic", "dance music", "pop", "pop rock", "rock", "rock and roll"] | 7 | 1ZaxqZMs21M | 287 | |
Josh Rouse - Love vibration (live in Madrid 2007) | A male vocalist sings this lively pop rock. The tempo is medium with an intense electric guitar harmony, punchy drumming, groovy bass lines and keyboard harmony. The song is muffled as the audio quality is inferior but it sounds enthusiastic, youthful, passionate and vibrant. This could be a live performance as there are background sounds of people talking, coughing, rustling. This song is Pop Rock. | 2007-11-23T05:28:53Z | ruben garrido | Josh Rouse en directo en Madrid - 22 noviembre 2007 (live in Madrid) Mi cronica del concierto pinchando aqui: http://40formasdeintimidad.wordpress.com/2007/11/23/en-joy-josh-rouse/ | ["Blues", "Country", "Jazz", "Music"] | ["male vocalist", "medium tempo", "popnrock", "live performance", "gig", "acoustic pop rock", "pop rock", "youthful", "energetic", "vibrant", "enthusiastic", "people talking", "coughing", "rustling", "lively electric guitar", "intense drumming", "synthesiser harmony", "groovy bass line", "muffled audio", "inferior audio quality", "static", "boomy", "loud"] | 7 | SwaqANBpZGY | 2797 | |
Ziggy Marley - Positive Vibration ( thx guys! :] ) | A male vocalist sings this energetic song. The tempo is fast with boomy bass lines, steady drumming, keyboard harmony and enthusiastic electric guitar riff with vocal backup. The audio quality is very bad and the song is muffled and muddy. This song is a live performance with ambient sounds of people clapping and cheering. | 2007-06-01T05:36:28Z | FSUSeaAngel | Ziggy Marley in West Palm Beach, FL | ["Vibration", "Music", "Rock and roll", "Music of Latin America"] | ["male vocalist", "fast tempo", "boomy bass", "enthusiastic", "insistent", "recurring vocal riff", "youthful", "engaging", "enthusiastic", "classic pop", "electric guitar riff", "female vocal backup", "steady drumming", "incoherent music", "inferior audio quality", "muddled sounds", "live performance", "concert", "amateur recording", "keyboard accompaniment"] | 7 | kZBFQAQI7Pg | 4328 |
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;