musiccaps_details (view)
21 rows where musiccaps_aspects contains "complex"
This data as json
musiccaps_aspects (array) 116 ✖
- complex · 21 ✖
- instrumental 13
- no singer 8
- electric guitar 5
- acoustic drums 4
- bass guitar 4
- guitar solo 4
- live performance 4
- amateur recording 3
- fast tempo 3
- improvisation 3
- jazz 3
- male vocal 3
- piano 3
- solo 3
- acoustic jazz drums 2
- carnatic classical 2
- carnatic violin 2
- cover 2
- e-bass 2
- energetic 2
- groovy 2
- harpsichord 2
- jam 2
- organ 2
- playful 2
- poor quality 2
- progressive rock 2
- shredding 2
- tabla 2
- tapping 2
- upright bass 2
- uptempo 2
- versatile singing 2
- vibrant 2
- western classical 2
- acoustic drum 1
- acoustic guitars 1
- acoustic sounding drums 1
- aggressive 1
- art music 1
- backing track 1
- baroque music 1
- bebop jazz 1
- carnatic music 1
- chamber music 1
- charming 1
- cheerful 1
- cinematic 1
- classical 1
- classical music 1
- clavicembalo 1
- concert 1
- digital acoustic drums 1
- digital strings 1
- distorted electric guitar 1
- dreamy 1
- drum solo 1
- eccentric 1
- electronic percussion 1
- enchanting 1
- engaging 1
- english dance 1
- enthralling 1
- enthusiastic harpsichord 1
- experimental 1
- female vocal 1
- finger play 1
- french composer 1
- french composition 1
- funk 1
- gibberish singing 1
- heavy metal 1
- indo-european fusion 1
- italian composer 1
- jazz fusion 1
- lively 1
- marimba 1
- masterpiece 1
- math rock 1
- medium tempo 1
- medium-to-high pitch singing 1
- melodic 1
- melodious 1
- opera 1
- orchestra 1
- outer space feel 1
- passionate 1
- percussion 1
- piano sample 1
- pitch shift 1
- progressive metal 1
- progressive synth-rock 1
- psychedelic 1
- rapid 1
- rapid playing 1
- restless 1
- rhythmic 1
- rich 1
- saxophone solo 1
- single instrument 1
- slap technique 1
- sonatas 1
- speed metal 1
- spirited 1
- string section 1
- synth lead 1
- tranquil 1
- trippy 1
- trumpet solo 1
- unique 1
- upbeat 1
- vibraphone 1
- video game theme 1
- violent 1
- virtual sounding brass 1
musiccaps_names (array) 49 ✖
- Music 12
- Guitar 5
- Musical instrument 5
- Percussion 5
- Drum 4
- Keyboard (musical) 4
- Plucked string instrument 4
- Bass drum 3
- Drum kit 3
- Harpsichord 3
- Snare drum 3
- Brass instrument 2
- Carnatic music 2
- Cymbal 2
- Electric guitar 2
- Hi-hat 2
- Rimshot 2
- Tabla 2
- Tapping (guitar technique) 2
- Background music 1
- Bass guitar 1
- Classical music 1
- Distortion 1
- Drum and bass 1
- Drum roll 1
- Echo 1
- Effects unit 1
- Electric piano 1
- Electronic music 1
- Hammond organ 1
- Heavy metal 1
- Inside, small room 1
- Marimba, xylophone 1
- Music of Bollywood 1
- New-age music 1
- Organ 1
- Piano 1
- Reverberation 1
- Rock music 1
- Roll 1
- Saxophone 1
- Singing 1
- Song 1
- Soul music 1
- Steel guitar, slide guitar 1
- Tender music 1
- Theme music 1
- Trumpet 1
- Vibraphone 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;