musiccaps_details (view)
4 rows where musiccaps_aspects contains "groovy", musiccaps_aspects contains "r&b" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 80 ✖
- groovy · 4 ✖
- r&b · 4 ✖
- buoyant 2
- happy 2
- instrumental 2
- male singer 2
- medium tempo 2
- punchy 2
- vocal backup 2
- african music 1
- animated 1
- bass guitar accompaniment 1
- blues 1
- blues lessons 1
- brass band 1
- bright trumpets 1
- carrie an music 1
- catchy 1
- charming 1
- clapping cheering 1
- classic rock 1
- concert 1
- dance groove 1
- dance music 1
- dance pop 1
- digital drum beats 1
- dissonant harmony 1
- drum machine 1
- edm 1
- elctro pop 1
- electric guitar 1
- electric guitar lead 1
- electric guitar lesson 1
- electronic music 1
- electronic xylophone melody 1
- emotional 1
- engaging 1
- enthusiastic 1
- fast tempo 1
- funk 1
- funky 1
- groovy bass lines 1
- hypnotic 1
- infectious drumming 1
- jazz 1
- jive music 1
- keyboard accompaniment 1
- live performance 1
- lively animated 1
- lively cello 1
- melancholic 1
- nostalgia 1
- pleasant 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
- soul 1
- spirited 1
- stage performance 1
- steady drumming 1
- synth pop 1
- synthesiser arrangements 1
- the lord’s prayer 1
- trumpets 1
- upbeat 1
- vibrant 1
- vivacious 1
- wistful 1
- world music 1
musiccaps_names (array) 12 ✖
- Music 3
- Blues 1
- Brass instrument 1
- Guitar 1
- Hip hop music 1
- Marimba, xylophone 1
- Musical instrument 1
- Plucked string instrument 1
- Reggae 1
- Ska 1
- Trombone 1
- Vibraphone 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 | |
Mr. Rogers' Neighborhood - So Good in My Hood (Tribute Beat) - Raisi K. | This music is an Electronic music instrumental. The tempo is medium with synthesiser arrangements , electronic xylophone harmony and digital drum beats. The music is soothing, punchy, groovy, hypnotic and engaging. This music is Synth Pop. | 2012-03-24T20:53:58Z | RaisiM1222 | Originally inspired by NegroSaki and 01103's renditions of the theme, I decided to make a tribute myself. RIP to a legend, Mr. Fred Rogers. Enjoy! - Raisi K. | ["Music", "Marimba, xylophone", "Vibraphone", "Hip hop music"] | ["instrumental", "medium tempo", "r&b", "soul", "electronic music", "engaging", "hypnotic", "synth pop", "dance pop", "elctro pop", "synthesiser arrangements", "electronic xylophone melody", "drum machine", "digital drum beats", "punchy", "groovy", "enthusiastic", "buoyant", "dance groove", "edm", "dance music"] | 7 | oRHKVmQ138Q | 4627 | |
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;