musiccaps_details (view)
1 row where musiccaps_aspects contains "drum track", musiccaps_aspects contains "exciting", musiccaps_aspects contains "passionate" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;