musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "guitar rhythm" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 46 ✖
- energetic · 3 ✖
- guitar rhythm · 3 ✖
- youthful · 3 ✖
- male singer 2
- medium tempo 2
- passionate 2
- percussive bass line 2
- aisi an pop 1
- amateur recording 1
- amplification 1
- asian pop hits 1
- audio units 1
- backup singers 1
- bleeding crowd noise 1
- classic rock band 1
- cymbals crashing 1
- demo video 1
- effects pedal demonstration 1
- emotional 1
- enthusiastic 1
- exciting 1
- groovy drumming rhythm 1
- groovy music 1
- grunge tones 1
- guitar distortion 1
- guitar effects pedal 1
- guitar playing 1
- home studio 1
- instrumental music 1
- keyboard accompaniment 1
- love song 1
- people talking ambient sounds 1
- piano accompaniment 1
- poor audio quality 1
- pop hits 1
- rapping vocals 1
- retro pop hits 1
- rock band 1
- rock music 1
- romantic 1
- solo 1
- soloist 1
- spirited 1
- steady drumming rhythm 1
- tech gear demos 1
- vocal harmony 1
musiccaps_names (array) 10 ✖
- Music 3
- Blues 1
- Chorus effect 1
- Disco 1
- Distortion 1
- Effects unit 1
- Guitar 1
- Independent music 1
- Plucked string instrument 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jones Cup 2012 - Smart Gilas Sige Lang Music Video HD | A male singer sings this cool melody with backup singers in vocal harmony. The tempo is medium with a groovy drumming rhythm, guitar accompaniment, piano accompaniment, percussive bass line and ambient crowd noises. The song is a modern Asian pop song. | 2012-08-30T00:39:31Z | Sound Check Music | Induk Videography Music: Sige lang By Quest | ["Blues", "Disco", "Music", "Speech"] | ["male singer", "backup singers", "asian pop hits", "bleeding crowd noise", "rapping vocals", "vocal harmony", "exciting", "enthusiastic", "groovy drumming rhythm", "percussive bass line", "piano accompaniment", "guitar rhythm", "people talking ambient sounds", "energetic", "youthful", "pop hits", "aisi an pop"] | 1 | AtJ2RXQ98kY | 1179 | |
Missing from YouTube | A male singer sings this rock melody. The tempo is medium with a groovy bass line, guitar rhythm , keyboard accompaniment, and heavy rock drumming with cymbals crashing. The song is energetic and passionate. The song is a retro pop-rock song. | ["Music", "Independent music"] | ["male singer", "classic rock band", "cymbals crashing", "rock band", "emotional", "steady drumming rhythm", "medium tempo", "guitar rhythm", "keyboard accompaniment", "romantic", "emotional", "love song", "energetic", "youthful", "passionate", "retro pop hits", "percussive bass line"] | 1 | 4437 | |||||
MXR Black Label Chorus | The song is an instrumental. The tempo is medium fast with a guitar playing lead with a guitar effects pedal producing a distorted grunge tone. The song is energetic and passionate with no other instrumentation. The song audio quality is very poor. | 2010-02-24T00:53:01Z | ProGuitarShopDemos | Buy Now: https://goo.gl/ez26hw The MXR Black Label Chorus is not your typical chorus pedal, because it is crafted and modeled after Zakk Wyldes own tone and style. This is Zakks secret weapon a stereo chorus that thickens up solos and adds some lush texture to the cleans, without taking away from his monstrous tone. This is a true bypass analog chorus pedal that is completely vintage in its tone, but thoroughly modern in its abilities. The tone shaping abilities of the MXR Black Label Chorus are amazing, with separate high and low tone cut controls. Add to the Level, Depth, and Rate knobs, and you can get some astounding chorus tones. From lush analog chorus effects to Leslie styled sounds, the MXR Black Label Chorus provides an amazing array of chorus effects. The tone cuts can really shape your tone, and with some creative knob tweaking, you can muster some utterly original and startling chorus effects. This wouldnt mean a whole lot unless the sound was pristine. This is a vintage sounding chorus pedal with high quality analog circuitry that delivers astounding chorus effects. Add this chorus effect to some thundering solos, and you have unlocked the secret of rich and thick solo tones. - http://proguitarshop.com/store/chorus-pedals-c-70/mxr-black-label-chorus-p-1580 | ["Effects unit", "Guitar", "Music", "Chorus effect", "Plucked string instrument", "Distortion"] | ["instrumental music", "guitar playing", "audio units", "tech gear demos", "demo video", "rock music", "amateur recording", "poor audio quality", "guitar effects pedal", "amplification", "guitar distortion", "guitar rhythm", "groovy music", "grunge tones", "poor audio quality", "effects pedal demonstration", "energetic", "youthful", "passionate", "spirited", "solo", "soloist", "home studio", "amateur recording", "rock music", "medium tempo"] | 1 | merGvga39Yo | 4484 |
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;