musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "groovy", musiccaps_aspects contains "r&b" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 65 ✖
- groovy · 3 ✖
- r&b · 3 ✖
- happy 2
- male singer 2
- vocal backup 2
- african music 1
- animated 1
- bass guitar accompaniment 1
- blues 1
- blues lessons 1
- brass band 1
- bright trumpets 1
- buoyant 1
- carrie an music 1
- catchy 1
- charming 1
- clapping cheering 1
- classic rock 1
- concert 1
- dissonant harmony 1
- electric guitar 1
- electric guitar lead 1
- electric guitar lesson 1
- emotional 1
- fast tempo 1
- funk 1
- funky 1
- groovy bass lines 1
- infectious drumming 1
- instrumental 1
- jazz 1
- jive music 1
- keyboard accompaniment 1
- live performance 1
- lively animated 1
- lively cello 1
- medium tempo 1
- melancholic 1
- nostalgia 1
- pleasant 1
- punchy 1
- reggae 1
- reggae tones 1
- retro 1
- rhythmic acousitc guitar 1
- rock and rock 1
- rock pop 1
- romantic 1
- sad 1
- sentimental 1
- shakers 1
- simple 1
- simple melody 1
- slow tempo 1
- somber 1
- spirited 1
- stage performance 1
- steady drumming 1
- the lord’s prayer 1
- trumpets 1
- upbeat 1
- vibrant 1
- vivacious 1
- wistful 1
- world music 1
musiccaps_names (array) 9 ✖
- Music 2
- Blues 1
- Brass instrument 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Reggae 1
- Ska 1
- Trombone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Blues Guitar Lesson Larry Carlton @ Videoguitarlessons.com | This music is instrumental , the tempo is slow with an electric guitar lead and a strong bass guitar accompaniment. The music is assertive and emphatic but sounds sad, melancholic,nostalgic, romantic , wistful and sentimental. This music is Blues Harmony. | 2008-03-20T18:05:26Z | eikohtiek | This is a blues jam that Larry did for my favorite website. A little taste of what kinds of things you can learn from his course. Larry is a master of Blues, Jazz, and fusion. He's played on some of your favorite Rock and Roll tracks too such as Steely Dan's, "Kid Charlemagne," He has shared studios and stages with the like of The Crusaders, Joni Mitchell, Sammy Davis Jr., Quincy Jones, John Lennon, Jerry Garcia, Michael Jackson, Stanley Clark, Billy Cobham, Bobby Bland, and many more. He also plays in the group Fouplay with Nathan East, Bob James, and Harvey Macon. I have taken these lessons and they really show you how to phrase well and make every note count. | ["Blues", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental", "slow tempo", "electric guitar lead", "melancholic", "nostalgia", "sad", "wistful", "romantic", "sentimental", "emotional", "bass guitar accompaniment", "groovy", "blues", "r&b", "jazz", "dissonant harmony", "melancholic", "somber", "blues lessons", "electric guitar lesson", "simple melody"] | 7 | NlUf1ppoSG4 | 2359 | |
Israel Vibration African Unification | A male vocalist sings the Lord’s Prayer. The tempo is medium with Keyboard harmony, steady drumming, groovy basslines, rhythmic guitar,beat of shakers, vocal backup and a trumpet flourish. The music is simple, rhythmic, pleasant, catchy, soulful and punchy Reggae. There are sounds of people clapping and cheering in the background indicating that this is a live performance. | 2007-02-25T01:52:21Z | David Ruiz | Israel Vibration African Unification | ["Music", "Reggae", "Ska"] | ["male singer", "medium tempo", "reggae", "live performance", "stage performance", "concert", "rhythmic acousitc guitar", "clapping cheering", "vocal backup", "shakers", "pleasant", "punchy", "groovy", "happy", "simple", "pleasant", "reggae tones", "groovy bass lines", "trumpets", "brass band", "shakers", "steady drumming", "keyboard accompaniment", "the lord’s prayer", "carrie an music", "african music", "r&b", "world music", "catchy"] | 7 | blsYgo-B1k8 | 3650 | |
She's So Fine - Jackie Wilson | A male vocalist sings this lively Rock song. The tempo is fast with bright trumpet harmony, groovy bass, infectious drumming , electric guitar and vocal backup. The music is upbeat, groovy, funky, high-spirited, vibrant and enthusiastic. This song is Retro Rock and Roll. | 2012-09-22T18:49:33Z | Mike Swindle | Hard to find music. | ["Brass instrument", "Trombone"] | ["male singer", "fast tempo", "lively cello", "bright trumpets", "vibrant", "classic rock", "animated", "buoyant", "groovy", "funky", "vibrant", "vivacious", "happy", "charming", "vocal backup", "spirited", "retro", "jive music", "upbeat", "spirited", "infectious drumming", "electric guitar", "lively animated", "rock and rock", "rock pop", "funk", "r&b"] | 7 | r4nPBNL3D0E | 4849 |
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;