musiccaps_details (view)
4 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "medium fast tempo" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 78 ✖
- live performance · 4 ✖
- medium fast tempo · 4 ✖
- youthful · 4 ✖
- energetic 2
- hard rock 2
- instrumental music 2
- live audience 2
- people cheering 2
- spirited 2
- adrenaline junkies 1
- adventurous 1
- ambient crowd noises 1
- ambient sounds 1
- amplified instruments 1
- animated electric guitar harmony 1
- bad audio quality 1
- booming 1
- boomy 1
- club music 1
- concert 1
- dance rhythm 1
- diva 1
- dj 1
- dj mixer 1
- electric guitar lead 1
- electric rhythm guitar playing 1
- electro music 1
- energetic drumming rhythm 1
- entertaining 1
- enthusiastic 1
- excited vocals 1
- exciting 1
- female guitarist 1
- gig 1
- groovy bass line 1
- groovy bass lines 1
- guitar solo 1
- heavy metal 1
- hip-hop 1
- home video 1
- infectious drumming 1
- instrumental 1
- keyboard harmony 1
- live concert video 1
- male vocalist 1
- medium fats tempo 1
- metal 1
- new age music 1
- people screaming 1
- percussive bass line 1
- percussive sounds 1
- percussive tap dancing 1
- poor audio recording 1
- positive 1
- pulsating 1
- punchy drumming 1
- rap 1
- resonating 1
- retro 1
- retro rock 1
- reverb 1
- rhythmic 1
- robotic sounds 1
- rock 1
- rock band 1
- rock drumming 1
- rock guitar solo 1
- scratching 1
- snares riding fast 1
- sonic power 1
- tap dancers 1
- techno music 1
- testosterone driven 1
- turn table 1
- turntablist 1
- various percussion hits 1
- vibrations 1
- vinyl record scratching 1
musiccaps_names (array) 14 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Orianthi - Guitar Solo [singfest 3/8/10] | The song is an instrumental. The tempo is medium fast with a strong guitar lead, rock drumming rhythm, percussive bass line and an electric guitar strumming rhythm. The song is high on adrenaline and exciting. The audio quality is very bad with ambient crowd screaming noises. | 2010-08-05T15:37:54Z | Zahara Sulaiman | Orianthi performance during singfest in Singapore. | ["Guitar", "Music", "Pop music", "Whoop", "Yell", "Inside, large room or hall"] | ["live performance", "ambient crowd noises", "medium fast tempo", "live concert video", "home video", "poor audio recording", "testosterone driven", "female guitarist", "exciting", "youthful", "diva", "rock guitar solo", "adventurous", "people screaming", "guitar solo", "rock band", "instrumental music", "people cheering", "bad audio quality", "hard rock", "rock band", "medium fats tempo", "rock drumming", "percussive bass line", "electric rhythm guitar playing"] | 1 | G8iTuTi8ywU | 1694 | |
Cold Metal - Iggy Pop.mp4 | A male vocalist sings this energetic Rock song. The tempo is medium fast with an animated electric guitar harmony and lead, groovy bass lines,infectious drumming and keyboard harmony. The song is electric,pulsating, youthful, energetic, enthusiastic, passionate and powerful with emphatic vocals. This song is Heavy Metal. | 2010-01-13T20:14:33Z | wotsitooyou | Iggy Pop live does Cold Metal | ["Music", "Punk rock", "Psychedelic rock", "Rock music", "Burst, pop"] | ["male vocalist", "medium fast tempo", "live performance", "gig", "concert", "retro", "retro rock", "keyboard harmony", "infectious drumming", "animated electric guitar harmony", "groovy bass lines", "punchy drumming", "electric guitar lead", "retro", "rock", "heavy metal", "hard rock", "metal", "sonic power", "amplified instruments", "excited vocals", "youthful", "spirited", "enthusiastic", "energetic"] | 7 | NxdQtpceXaI | 2381 | |
DJ Q-Bert "Method Man" scratch 2009 | This music is instrumental. The tempo is medium fast with boomy bass, turntable scratching and digitally arranged music. The music is muffled as the audio quality is inferior but the beats are punchy, buoyant, bouncy, youthful, groovy and energetic. This music is a turntable scratching technique. | 2009-09-16T00:20:26Z | Trikpah | DJ Q-Bert live 2009 | ["Scratching (performance technique)", "Music", "Musical instrument", "Hip hop music"] | ["instrumental", "medium fast tempo", "boomy", "live performance", "live audience", "ambient sounds", "reverb", "resonating", "robotic sounds", "turn table", "scratching", "dj", "dj mixer", "club music", "pulsating", "vibrations", "booming", "vinyl record scratching", "youthful", "new age music", "techno music", "electro music", "percussive sounds", "rhythmic", "turntablist", "hip-hop", "rap"] | 7 | YJKZVSvz1Bk | 3274 | |
Tap Dogs I Beams | The song is an instrumental. The song is medium fast tempo with a groovy bass line, energetic drumming, and tap dancers in a percussive groove. The song is entertaining and energetic. | 2009-07-26T17:06:46Z | Tap Dogs Official | ["Music", "Tap"] | ["tap dancers", "percussive tap dancing", "adrenaline junkies", "live audience", "live performance", "instrumental music", "groovy bass line", "people cheering", "energetic drumming rhythm", "medium fast tempo", "various percussion hits", "snares riding fast", "entertaining", "energetic", "positive", "spirited", "youthful", "dance rhythm"] | 1 | oRUdvu3Qo-E | 4628 |
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;