musiccaps_details (view)
88 rows where musiccaps_aspects contains "mono" and musiccaps_aspects contains "passionate"
This data as json
musiccaps_aspects (array) 213 ✖
- low quality 88
- mono · 88 ✖
- passionate · 88 ✖
- noisy 87
- emotional 37
- live performance 25
- soulful 21
- traditional 16
- cover 11
- passionate male vocal 11
- groovy bass 8
- shimmering hi hats 8
- acoustic rhythm guitar 7
- joyful 7
- sustained strings melody 7
- wooden percussions 7
- energetic 6
- flat male vocal 6
- passionate female vocal 6
- punchy snare 6
- reverberant 5
- rock 5
- breathy flute melody 4
- electric guitar melody 4
- folk 4
- harmonica solo melody 4
- muffled 4
- playback 4
- shimmering shakers 4
- wooden percussive elements 4
- accordion melody 3
- country 3
- easygoing 3
- electric guitar solo melody 3
- energetic drums 3
- groovy 3
- groovy piano melody 3
- harmonizing male vocals 3
- jazz 3
- mellow piano chords 3
- punchy kick 3
- saxophone solo melody 3
- acoustic guitar melody 2
- acoustic rhythm guitar chords 2
- arpeggiated acoustic guitar melody 2
- arpeggiated electric guitar melody 2
- arpeggiated harp melody 2
- bagpipe melody 2
- bagpipes melodies 2
- clapping 2
- classical 2
- crowd clapping 2
- flute melody 2
- fruity male vocal 2
- funky 2
- gospel 2
- groovy double bass 2
- harmonizing female vocals 2
- heartfelt 2
- orchestra 2
- plucked strings melody 2
- pop 2
- regional mexican 2
- sad 2
- shimmering cymbals 2
- simple bass 2
- smooth bass 2
- strings melody 2
- sustained brass melody 2
- uptempo 2
- vintage 2
- accordion chords 1
- acoustic guitar chords 1
- addictive 1
- addictive brass melody 1
- addictive strings melody 1
- aggressive harmonica solo 1
- alternative/indie 1
- arpeggiated acoustic guitars melodies 1
- arpeggiated guitar melody 1
- arpeggiated piano melody 1
- asphalt sounds 1
- audio cut 1
- auto harp melody 1
- bagpipes melody 1
- ballad 1
- banjo guitar melody 1
- banjo solo melody 1
- bass clarinet melody 1
- bass guitar 1
- beatiful 1
- blues 1
- boogie 1
- boomy playback 1
- bright trumpet melody 1
- buzzy 1
- chorus pedal effect 1
- clarinet solo melody 1
- clean electric guitar melody 1
- compilation 1
- cool 1
- cough 1
- crowd chattering 1
- crowd cheering 1
- crowd talking 1
- cultural 1
- distorted 1
- distorted electric guitar solo melody 1
- dynamic 1
- echoing electric guitar solo melody 1
- echoing male chant 1
- echoing passionate male vocal 1
- electric guitar arpeggiated melody 1
- electric rhythm guitar melody 1
- emotiona 1
- energetic crash cymbal 1
- enka 1
- epic 1
- exciting 1
- exotic 1
- female laugh 1
- finger style acoustic guitar melody 1
- flat female vocal 1
- footstep sound 1
- french horn melody 1
- fun 1
- funky acoustic rhythm guitar 1
- funky blues acoustic guitar melody 1
- funky electric guitars melodies 1
- groovy accordion melody 1
- groovy piano 1
- groovy rhodes keys melody 1
- happy 1
- harmonica solo 1
- harmonizing background female vocals 1
- harmonizing female choir vocals 1
- harmonizing french horn melody 1
- harmonizing girls vocals 1
- harmonizing mixed choir 1
- harmonizing mixed vocals 1
- harmonizing vocals 1
- harpsichord melody 1
- instrumental playback 1
- jazz orchestra 1
- jazzy 1
- keys chords 1
- laughing 1
- leg tapping 1
- loud brass section melody 1
- loud shoe tapping 1
- low microphone pop sound 1
- male laugh 1
- mandolin solo melody 1
- mellow 1
- mellow bells chord progression 1
- mellow dark keys melody 1
- mellow french horn melody 1
- mellow keys melody 1
- mellow organ keys chords 1
- mellow wooden percussion 1
- mellow woodwinds melody 1
- metronome 1
- mixed harmonizing choir 1
- monotone female vocal 1
- muddy 1
- muffled percussion 1
- mystical 1
- national anthem 1
- passionate harmonizing choir vocals 1
- passionate woodwind melody 1
- pedal tap sound effect 1
- people talking 1
- percussive wooden elements 1
- piano chords 1
- pitch change 1
- powerful 1
- raw innocent girl vocal 1
- raw male vocal 1
- romantic 1
- sad violin melody 1
- saxophone melody 1
- shimmering shaker 1
- sitar melody 1
- sliding effect 1
- sloppy 1
- sloppy acoustic rhythm guitar 1
- snappy rimshots 1
- snare rolls 1
- soft 1
- soft female vocal 1
- soft kick hits 1
- spanish guitar solo melody 1
- steel drums melody 1
- steel guitar solo melody 1
- strings creaking sound 1
- subtle female vocal 1
- suspenseful 1
- suspenseful violin melody 1
- sustained string melody 1
- sustained suspenseful strings melody 1
- sustained violin melody 1
- synchronized brass melody 1
- synth lead melody 1
- synth pads 1
- theremin solo 1
- theremin solo melody 1
- toms roll 1
- tutorial 1
- upbeat 1
- violin melody 1
- whistling sound 1
- wobble bass 1
- wooden percussion 1
musiccaps_names (array) 81 ✖
- Music 48
- Musical instrument 22
- Plucked string instrument 18
- Singing 18
- Guitar 16
- Wind instrument, woodwind instrument 15
- Acoustic guitar 7
- Brass instrument 7
- Bagpipes 6
- Choir 6
- Effects unit 6
- Harmonica 6
- A capella 5
- Country 5
- Middle Eastern music 5
- Percussion 5
- Strum 5
- Pizzicato 4
- Vocal music 4
- Accordion 3
- Bluegrass 3
- Chorus effect 3
- Distortion 3
- Drum 3
- Electric guitar 3
- French horn 3
- Inside, small room 3
- Jazz 3
- Mandolin 3
- Orchestra 3
- Song 3
- Steel guitar, slide guitar 3
- Tabla 3
- Traditional music 3
- Ukulele 3
- Banjo 2
- Bass guitar 2
- Blues 2
- Carnatic music 2
- Christian music 2
- Clarinet 2
- Electric piano 2
- Flute 2
- Gospel music 2
- Harp 2
- Keyboard (musical) 2
- Music of Asia 2
- Piano 2
- Reverberation 2
- Saxophone 2
- Speech 2
- Theremin 2
- Trumpet 2
- Wedding music 2
- /m/05zppz 1
- /t/dd00003 1
- Bowed string instrument 1
- Child singing 1
- Christmas music 1
- Classical music 1
- Drum kit 1
- Electronic organ 1
- Folk music 1
- Happy music 1
- Harmonic 1
- Harpsichord 1
- Inside, large room or hall 1
- Mantra 1
- Music of Bollywood 1
- Opera 1
- Organ 1
- Pop music 1
- Steelpan 1
- String section 1
- Swing music 1
- Tap 1
- Tapping (guitar technique) 1
- Violin, fiddle 1
- Whoop 1
- Wood block 1
- Yodeling 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;