musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "sophisticated" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- instrumental music 2
- sophisticated · 2 ✖
- adrenaline rush 1
- amplified guitar harmony 1
- blues giants 1
- blues guitar lessons 1
- blues guitar licks 1
- blues guitar tutorial 1
- blues hits 1
- blues legends 1
- collectors choice 1
- distorted guitar rhythm 1
- electric guitar blues 1
- energetic 1
- excellent audio quality 1
- fast cars 1
- groovy 1
- groovy sluice 1
- grunge keyboard tones 1
- hard rock music 1
- legendary licks 1
- massive drum roll 1
- medium tempo 1
- new orleans blues 1
- passionate 1
- pristine audio quality 1
- relaxing music 1
- rich and famous 1
- romantic 1
- solid intro 1
- steady marching rhythm 1
- strong bass drum hits 1
- strong bass line 1
- supercar documentary soundtrack 1
- the blues 1
- the lush life 1
musiccaps_names (array) 7 ✖
- Music · 2 ✖
- Angry music 1
- Blues 1
- Electric guitar 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
youtube_published (date) 2 ✖
- 2011-05-20 1
- 2016-03-31 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
4 Albert King Style Blues Licks (Slow Blues Guitar Lesson) | The song is an instrumental. The tempo is medium with a slick drumming rhythm starting with a solid drum introduction, strong bass line and a blues guitar solo. The song is energetic and passionate. The audio quality is excellent. | 2011-05-20T21:29:49Z | Texas Blues Alley | * Join The TXBA Locals: https://texasbluesalley.com/locals * TXBA Email List: https://texasbluesalley.com/email * Lesson page: https://texasbluesalley.com/woodshed/free/4-albert-king-style-licks * Insta: https://instagram.com/texasbluesalley * Twitter: https://twitter.com/texasbluesalley In this free lesson, you'll learn 4 licks from the Albert's Influence course. If you like this video, you'll love the course. Join the TXBA Locals today for unlimited access to our huge library of Texas Blues guitar courses. | ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["electric guitar blues", "instrumental music", "blues guitar lessons", "legendary licks", "excellent audio quality", "the blues", "blues guitar tutorial", "romantic", "the lush life", "blues legends", "sophisticated", "blues guitar licks", "new orleans blues", "blues hits", "relaxing music", "energetic", "passionate", "groovy", "solid intro", "blues giants", "romantic", "massive drum roll", "medium tempo"] | 1 | JLYb7DwCaQU | 1994 | |
C7 Callaway Corvette Z06 Standing Mile Run at the NASA Runway | The song is an instrumental. The tempo is medium with a strong marching drum rhythm, with cymbal crashes and bass drum kicks, percussive bass line and amplified guitar playing rhythm. The audio quality is pristine and the soundtrack is high on adrenaline. | 2016-03-31T21:27:36Z | xxtamgxx | 2015 C7 Callaway Corvette Z06 Blasts Off at NASA Runway | ["Music", "Angry music"] | ["hard rock music", "strong bass drum hits", "rich and famous", "collectors choice", "sophisticated", "pristine audio quality", "instrumental music", "distorted guitar rhythm", "strong bass line", "groovy sluice", "steady marching rhythm", "amplified guitar harmony", "adrenaline rush", "supercar documentary soundtrack", "fast cars", "grunge keyboard tones"] | 1 | LMGpKPavV4Q | 2181 |
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;