musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "energetic", musiccaps_aspects contains "loud" and musiccaps_aspects contains "vibrant"
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- energetic · 3 ✖
- loud · 3 ✖
- vibrant · 3 ✖
- enthusiastic 2
- groovy bass line 2
- male vocalist 2
- accordeon 1
- acoustic pop rock 1
- amplified keyboard 1
- assertive 1
- bass guitar 1
- boomy 1
- concert performance 1
- coughing 1
- dominating vocals 1
- double neck guitar 1
- electronic drums 1
- fast tempo 1
- forceful 1
- gig 1
- hard hitting drumming 1
- heavy metal 1
- high pitch 1
- inferior audio quality 1
- intense 1
- intense drumming 1
- intense electric guitar harmony 1
- latin dance 1
- live performance 1
- lively electric guitar 1
- male vocal 1
- medium tempo 1
- muffled audio 1
- passionate 1
- people shouting 1
- people talking 1
- pop rock 1
- popnrock 1
- powerful 1
- rising pattern 1
- rock and roll 1
- rustling 1
- static 1
- synthesiser harmony 1
- vehement 1
- vigorous 1
- vivacious 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Extreme/Paul Gilbert - Rock and Roll | A male vocalist sings this energetic Rock and Roll song. The song is fast tempo with enthusiastic electric guitar, hard hitting drums, groovy bass lines and keyboard harmony. The song is vibrant, high energy, powerfully,passionate, emphatic, vehement, intense and youthful. This song is classic rock. | 2010-04-19T23:22:03Z | fuzzionrestorock | Extreme/Paul Gilbert Fuzzion RestoRock | ["Music", "Roll", "Rock and roll"] | ["male vocalist", "fast tempo", "intense electric guitar harmony", "vehement", "energetic", "vigorous", "vivacious", "assertive", "intense", "forceful", "passionate", "amplified keyboard", "heavy metal", "double neck guitar", "loud", "powerful", "enthusiastic", "energetic", "groovy bass line", "dominating vocals", "high pitch", "rock and roll", "vibrant", "concert performance", "hard hitting drumming"] | 7 | cHGziT0hrZU | 3695 | |
siguen la maraca en orlando car wash | This is the recording of a latin dance music piece. It has a male vocalist singing the same word repeatedly at a medium-to-high pitch. There is an accordion playing the melody and a bass guitar in the background. The electronic drums play a latin beat for the rhythm. There is a constant rising and accelerating pattern in the piece. The sound of people shouting can be heard in the recording. The atmosphere is very loud and vibrant. | 2008-02-09T03:27:15Z | DREVENTOS COM | ALANTE ALANTE | ["Music", "Maraca"] | ["latin dance", "male vocal", "rising pattern", "accordeon", "bass guitar", "electronic drums", "people shouting", "energetic", "vibrant", "loud"] | 9 | woyCm7d2UIM | 5287 |
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;