musiccaps_details (view)
26 rows where search matches "guitar" and musiccaps_aspects contains "jazz" sorted by youtube_published
This data as json
musiccaps_aspects (array) 227 ✖
- jazz · 26 ✖
- electric guitar 10
- groovy 9
- instrumental 9
- acoustic drums 6
- bass guitar 6
- blues 6
- groovy bass 5
- electric guitar lead 4
- low quality 4
- male vocalist 4
- passionate 4
- reggae 4
- rock 4
- smooth 4
- electric guitar lesson 3
- fast tempo 3
- funky 3
- intense 3
- live performance 3
- medium tempo 3
- noisy 3
- saxophone 3
- shimmering hi hats 3
- steady drumming 3
- swing 3
- acoustic jazz drums 2
- amplified guitar 2
- chill 2
- demonstration 2
- dense 2
- electric guitar melody 2
- electric guitar solo 2
- empahtic 2
- energetic 2
- external amplification 2
- funky bass line 2
- heavy metal 2
- jam 2
- keyboard harmony 2
- loud 2
- loud feed back 2
- melancholic 2
- no singer 2
- piano 2
- playful 2
- powerful 2
- punchy kick 2
- relaxing 2
- simple melody 2
- soft 2
- sonic power 2
- string instrument 2
- stringed instrument 2
- tutorial 2
- upright bass 2
- youthful 2
- acoustic guitar 1
- acoustic rhythm guitar chords 1
- active 1
- acustic guitar 1
- affecting 1
- ambient 1
- amplified 1
- amplified guitar 1
- amplified guitar harmony 1
- applause 1
- atmospheric 1
- b3 1
- backing track 1
- bass drum 1
- bass guitar accompaniment 1
- blues lessons 1
- boomy 1
- bossa nova 1
- buoyant 1
- call and response 1
- calm 1
- calming 1
- camera shuttering sound effect 1
- catchy riff 1
- chaotic 1
- cheerful 1
- chewing 1
- clarinet 1
- clear 1
- complex 1
- complex harmony 1
- concert 1
- confusing 1
- contemporary jazz 1
- cool saxophone solo melody 1
- country 1
- crisp 1
- cymbals 1
- dissonant harmony 1
- dissonant strings 1
- dreamy 1
- drum breaks 1
- dub 1
- e-guitars 1
- easygoing 1
- easygoing electric guitar chords 1
- edgy 1
- electric guitar demo 1
- electric guitar riff 1
- electric guitars 1
- elegant 1
- emotional 1
- energetic drums 1
- enthusiastic 1
- explosions 1
- fast bass playing 1
- fast paced electric guitar arpeggios 1
- female vocal backup 1
- flugelhorn 1
- funk 1
- funky electric guitar melody 1
- galloping beat 1
- gibberish singing 1
- groovy bass line 1
- groovy bass lines 1
- groovy piano chords 1
- groovy rhodes keys melody 1
- guitar solo 1
- hammond organ 1
- happy mood 1
- hard rock 1
- heavy reverb 1
- improvisation 1
- informal 1
- insightful 1
- instructional 1
- intricate electric guitar licks 1
- irregular beats 1
- jazz electric guitar 1
- jazz guitar 1
- jazzy 1
- jovial 1
- keyboard 1
- lead instrument 1
- learning electric 1
- light 1
- light-hearted 1
- lively 1
- lively drumming 1
- male vocal 1
- male voice speaking 1
- mediocre audio recording 1
- medium fast tempo 1
- medium to uptempo 1
- mellow 1
- mellow keys chords 1
- melodic 1
- melodious 1
- metal 1
- minimal instrumentation 1
- minimalist 1
- moderate tempo 1
- mono 1
- no voices 1
- nostalgia 1
- organ 1
- organ trio 1
- passionate solo acoustic guitar melody 1
- percussion 1
- piano accompaniment 1
- piano chords 1
- pipe organ 1
- polished 1
- polyrhythms 1
- pop 1
- punchy snare 1
- r&b 1
- reflective 1
- resonating 1
- reverb 1
- reverberant 1
- review 1
- rhythmic acoustic guitar 1
- rich 1
- rim shot 1
- romantic 1
- sad 1
- sensual 1
- sentimental 1
- simple double bass 1
- simple jazzy drum beat 1
- skilful 1
- skillful 1
- slightly off key vocals 1
- slow tempo 1
- smooth bass guitar 1
- snappy snare 1
- soft electric guitar arpeggiated melody 1
- soft kick hits 1
- soft rimshot hits 1
- solos 1
- somber 1
- sophisticated 1
- sound effects 1
- speaking man 1
- spirited 1
- squeaking 1
- steady ride pattern 1
- superimposed syncopated strings 1
- syncopated music 1
- syncopation 1
- synth pad 1
- tranquil 1
- trippy 1
- tropical 1
- trumpet 1
- tuba 1
- two tracks playing 1
- ukele 1
- unrelated tracks 1
- upbeat jazzy music 1
- vibraphone 1
- vibration 1
- vibrations 1
- video game theme 1
- warm 1
- wide brass section 1
- wide passionate harmonizing male vocals 1
- wistful 1
- xylophone 1
musiccaps_names (array) 43 ✖
- Music 18
- Guitar 10
- Plucked string instrument 8
- Musical instrument 7
- Jazz 6
- Distortion 5
- Effects unit 4
- Brass instrument 3
- Electric guitar 3
- Saxophone 3
- Acoustic guitar 2
- Blues 2
- Chorus effect 2
- Funk 2
- Singing 2
- Swing music 2
- Banjo 1
- Bluegrass 1
- Electric piano 1
- Electronic organ 1
- Foghorn 1
- Harmonic 1
- Inside, large room or hall 1
- Keyboard (musical) 1
- Mandolin 1
- Oink 1
- Organ 1
- Percussion 1
- Piano 1
- Pop music 1
- Reggae 1
- Reverberation 1
- Roll 1
- Ska 1
- Song 1
- Soul music 1
- Speech 1
- Strum 1
- Trombone 1
- Trumpet 1
- Ukulele 1
- Wind instrument, woodwind instrument 1
- Wood block 1
0 records
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;