musiccaps_details (view)
3 rows where musiccaps_aspects contains "exciting", musiccaps_aspects contains "spirited" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- exciting · 3 ✖
- spirited · 3 ✖
- energetic 2
- instrumental music 2
- passionate 2
- acoustic guitars strumming 1
- amplifier 1
- bad audio quality 1
- bass master class 1
- carnatic music 1
- carnatic vocals 1
- country music 1
- cymbals crashing 1
- dance rhythm 1
- distorted guitar 1
- drum track 1
- emotional 1
- experimental 1
- funk rock 1
- groovy bas slime 1
- groovy bass line 1
- guitar band 1
- guitar demo 1
- guitar effects pedal 1
- home music video 1
- improvisational 1
- indian classical music 1
- live audience 1
- live performance 1
- male vocalist 1
- medium fast tempo 1
- medium tempo 1
- mridangam percussion 1
- music jam 1
- poor audio quality 1
- quick slap bass inquest 1
- slap bass 1
- tabla 1
- technique video 1
- ukulele playing 1
- youthful 1
- youtube music video 1
- youtube songs 1
musiccaps_names (array) 14 ✖
- Music 3
- Musical instrument · 3 ✖
- Plucked string instrument 2
- Banjo 1
- Bass guitar 1
- Carnatic music 1
- Classical music 1
- Country 1
- Guitar 1
- Mandolin 1
- Percussion 1
- Rock music 1
- Singing 1
- Steel guitar, slide guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Gypsy - Tyler May & The Kentucky School of Bluegrass and Traditional Music Ensemble | The song is an instrumental. The song is medium fast tempo with a groovy bass line, acoustic guitars strumming rhythm, and a ukulele playing lead. The song is spirited and exciting. The song is an instrumental with country music influences. | 2011-04-23T00:46:35Z | Stewart Tyler May | Gypsy © 2011 by Stewart Tyler May Guitar - Josh Reimen Guitar - Leslie Strong Banjo - Jeremy Moses Mandolin - Isaac May Bass - Tina May Fiddle/Clawhammer Banjo - Tyler May | ["Banjo", "Country", "Music", "Mandolin", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["ukulele playing", "acoustic guitars strumming", "groovy bass line", "dance rhythm", "home music video", "youtube songs", "music jam", "spirited", "poor audio quality", "guitar band", "country music", "groovy bas slime", "energetic", "youthful", "exciting", "emotional", "dance rhythm", "instrumental music", "medium fast tempo"] | 1 | CudxWnS7ukw | 1413 | |
DR.M.BALAMURALIKRISHNA - THILLANA | A male vocalist sings this traditional Carnatic vocals. The song is medium tempo with a violin accompaniment, tabla and mridangam playing percussion. The song is energetic and passionate and highlights the traditional Carnatic music art form. The audio quality is bad. | 2007-04-17T07:21:47Z | Musique4ever | Dr.M.Balamuralikrishna sings a thillana in Ahir Bhairav. | ["Singing", "Carnatic music", "Music", "Musical instrument", "Classical music", "Percussion"] | ["carnatic music", "male vocalist", "medium tempo", "tabla", "energetic", "passionate", "indian classical music", "bad audio quality", "live performance", "live audience", "passionate", "spirited", "exciting", "mridangam percussion", "carnatic vocals"] | 1 | Emc18GpAeRY | 1588 | |
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 |
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;