musiccaps_details (view)
3 rows where musiccaps_aspects contains "experimental" and musiccaps_aspects contains "spirited"
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- experimental · 3 ✖
- instrumental music 3
- spirited · 3 ✖
- exciting 2
- medium tempo 2
- aggressive 1
- amateur production 1
- amplifier 1
- bass master class 1
- beeping tones 1
- bell tones 1
- cymbals crashing 1
- distorted guitar 1
- distorted tones 1
- drum track 1
- electric guitar lead 1
- explosions 1
- funk rock 1
- game soundtrack 1
- gamers 1
- goofing around 1
- guitar demo 1
- guitar effects pedal 1
- guitar overtones 1
- guitar practice routine 1
- guns shooting rhythmically 1
- hard metal 1
- improvisational 1
- jarring tones 1
- no 1
- no other instrumentation 1
- no percussion instrumentation 1
- passionate 1
- percussion instruments 1
- percussive blasts 1
- playing alone 1
- playing rhythmically 1
- poor audio quality 1
- projectile explosions 1
- quick slap bass inquest 1
- rebellious 1
- rock music 1
- slap bass 1
- technique video 1
- theme song 1
- unconventional instrumentation 1
- video game 1
- war game 1
- youtube music video 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Counter-Strike Gun Sounds 2 | The song is an instrumental. The song is medium tempo with various explosive sounds played percussively, along with counter beeps. The song is exciting and very novel. The song is probably the theme song of a modern video game. | 2007-07-07T15:05:14Z | djct1213cs | Counter-Strike Gun Sounds 2 CS1.6 Non-Steam: Cool CS Music Weapons | ["Music", "Tap"] | ["video game", "beeping tones", "medium tempo", "experimental", "spirited", "gamers", "percussive blasts", "theme song", "explosions", "guns shooting rhythmically", "poor audio quality", "amateur production", "projectile explosions", "game soundtrack", "instrumental music", "unconventional instrumentation", "war game"] | 1 | 70pyoqX0U9Y | 802 | |
Experimental Funk Rock Slap Bass | The song is an instrumental. The tempo is medium with a bass guitar using innovative improvisation skills along with a drum track with heavy cymbal crashes. The song is energetic and passionate. | 2011-12-02T00:42:41Z | Remco's Groove Lab | Jam-based freefunk with an EBS bass iq, multidrive and octabass. I also used a digitech whammy pedal to bend the harmonic. Thanks for watching! Get this track on iTunes: https://music.apple.com/album/groove-a-holic-vol-2/1505339451 Bandcamp: http://remcohendriks.bandcamp.com/album/groove-a-holic-vol-2 Spotify: https://open.spotify.com/album/0CHNzopWXpDPskk3VUldxm?si=ammyhHEXRqKXiDvMSX20eQ Facebook: https://www.facebook.com/Gr00veLab Instagram: https://www.instagram.com/groove_a_holic Cheers! On request, here's the tab for the slap part on the first riff: h= hammer-on x= muted slap G ----------4--2--------2----44- D ----------------2h4x---xx----- A ---0h2x--x--------------------- | ["Bass guitar", "Guitar", "Music", "Musical instrument", "Rock music", "Plucked string instrument"] | ["funk rock", "slap bass", "instrumental music", "youtube music video", "experimental", "improvisational", "drum track", "cymbals crashing", "guitar effects pedal", "amplifier", "distorted guitar", "exciting", "passionate", "spirited", "quick slap bass inquest", "guitar demo", "technique video", "bass master class"] | 1 | T8U3ihbHh9A | 2815 | |
Kirby's Epic Yarn: Fanmade boss battle music (intro) | The song is an instrumental. The song is medium tempo with an overdriven guitar playing a jarring lead in rhythmic fashion and guitar over tones that sound like bell tones. The song is aggressive and experimental. The song is a modern rock intro. | 2010-06-20T16:06:40Z | joinmebowser9000 | the title says it all. maybe its to heavy for this kirby game xD | ["Electric guitar", "Music", "Distortion", "Sad music"] | ["electric guitar lead", "distorted tones", "experimental", "playing alone", "guitar practice routine", "no percussion instrumentation", "goofing around", "instrumental music", "playing rhythmically", "guitar overtones", "no", "percussion instruments", "jarring tones", "bell tones", "rock music", "exciting", "spirited", "rebellious", "aggressive", "no other instrumentation", "medium tempo", "hard metal"] | 1 | rfah0bhmYkc | 4893 |
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;