musiccaps_details (view)
3 rows where musiccaps_aspects contains "intense drumming", musiccaps_aspects contains "punchy" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 60 ✖
- fast tempo 3
- intense drumming · 3 ✖
- punchy · 3 ✖
- buoyant 2
- energetic 2
- enthusiastic 2
- upbeat 2
- acoustic guitar 1
- auxiliary percussions 1
- bass drum 1
- boomy bass line 1
- bright 1
- club musc 1
- club music 1
- cymbal rides 1
- dance groove 1
- dance hits 1
- dance music 1
- dance pop 1
- digital drum 1
- dj 1
- drum solo 1
- electrifying 1
- electronic music 1
- excessive reverb 1
- excishakers 1
- fervent 1
- floor tom 1
- groovy 1
- groovy bass 1
- high-spirited 1
- inferior audio quality 1
- instrumental 1
- keyboard harmony 1
- latin dance hits 1
- latin dance music 1
- latin music 1
- latin pop 1
- latin song 1
- latin urbano 1
- lively 1
- lively vocal backup 1
- male vocalist 1
- mallets 1
- muddled song 1
- muddled vocals 1
- peppy 1
- percussion 1
- percussion solo 1
- perky 1
- pop rock 1
- pulsating 1
- rock 1
- shakers 1
- snare drum 1
- synthesiser arrangement 1
- synthesiser arrangements 1
- tom-toms 1
- world music 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
[100105 HQ]Rainbow レインボー ''Gossip Girl'' Dance Practice for Kim Jung Eun's Chocolate | This is a fast tempo song. The audio quality is inferior so the vocals are muddled making it difficult to comprehend if the vocalist is a male or female. The music is incoherent too but it is possible to identify synth arrangements, intense drumming, boomy bass lines,and keyboard harmony with spirited vocals. The song is upbeat and has a dance groove. It is a pop rock/ synth rock. | 2010-01-05T12:43:13Z | KoreanRainbow | [100105 HQ]Rainbow ''Gossip Girl'' Dance Practice for Kim Jung Eun's Chocolate | ["Music", "Tambourine"] | ["fast tempo", "energetic", "buoyant", "peppy", "punchy", "dance hits", "club music", "dance groove", "dj", "upbeat", "synthesiser arrangement", "electronic music", "boomy bass line", "intense drumming", "inferior audio quality", "excessive reverb", "youthful", "rock", "pop rock", "dance music", "muddled vocals", "muddled song"] | 7 | 5DDg2CzAmgE | 644 | |
Bill Bruford Drum Solo | This music is a percussion solo. The tempo is fast with the drummer playing an energetic solo. The beat is vigorous, enthusiastic, spirited, infectious and punchy with a flourish of cymbals. | 2007-06-01T01:14:42Z | metalmasher | Bruford does a solo during a performance with his jazz group, Earthworks | ["Drum", "Drum kit", "Jazz", "Music"] | ["instrumental", "percussion", "percussion solo", "fast tempo", "enthusiastic", "bass drum", "tom-toms", "bass drum", "snare drum", "floor tom", "mallets", "auxiliary percussions", "intense drumming", "drum solo", "cymbal rides", "bright", "energetic", "punchy", "lively"] | 7 | oD0Xp--xxjE | 4611 | |
Danza Kuduro Don Omar Ft, Lucenzo, Daddy Yankee, Akon & Pitbull (DJ Ebo Remix) | A male vocalist sings this upbeat Latin pop song. The tempo is fast with infectious drumming, groovy bass line,electric guitar, keyboard harmony, acoustic guitar, shakers,synthesiser arrangement and digital drumming. The song is youthful , energetic,enthusiastic, animated,fervent, pulsating, electrifying ,exciting,and buoyant. This song is a Latin Urbano. | 2014-12-15T01:48:50Z | DJ EBO | Follow ► https://www.facebook.com/BailaReggaetonUK Follow ► https://www.instagram.com/official.djebo ♫ Follow ► https://soundcloud.com/djeboo ♩ | ["Reggae"] | ["male vocalist", "fast tempo", "latin music", "shakers", "latin pop", "pulsating", "electrifying", "buoyant", "fervent", "enthusiastic", "excishakers", "acoustic guitar", "latin song", "latin urbano", "high-spirited", "buoyant", "upbeat", "groovy", "intense drumming", "groovy bass", "synthesiser arrangements", "keyboard harmony", "digital drum", "lively vocal backup", "latin dance music", "dance pop", "club musc", "latin dance hits", "world music", "punchy", "perky"] | 7 | wj4ukZFNEgs | 5285 |
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;