musiccaps_details (view)
17 rows where musiccaps_aspects contains "groovy piano melody" and musiccaps_aspects contains "passionate"
This data as json
musiccaps_aspects (array) 90 ✖
- groovy piano melody · 17 ✖
- passionate · 17 ✖
- low quality 15
- emotional 10
- noisy 7
- groovy bass 6
- live performance 5
- shimmering hi hats 5
- punchy snare 4
- shimmering shakers 4
- soulful 4
- folk 3
- jazz 3
- mono 3
- passionate female vocal 3
- sustained strings melody 3
- groovy 2
- groovy double bass 2
- happy 2
- harmonizing female vocals 2
- joyful 2
- punchy kick 2
- shimmering cymbals 2
- soft kick 2
- soft kick hits 2
- vintage 2
- addictive 1
- brass melody 1
- breathy flute melody 1
- children song 1
- chill 1
- choir 1
- church organ chords progression 1
- clapping 1
- clarinet solo melody 1
- crowd talking 1
- easygoing 1
- energetic 1
- euphoric 1
- exciting background male vocal 1
- exotic 1
- flat male vocal 1
- fun 1
- funky electric guitar melody 1
- gospel 1
- groovy bass guitar 1
- harmonizing male vocals 1
- male vocal 1
- male vocal ad libs 1
- mellow 1
- mellow brass melody 1
- mellow cello melody 1
- mellow kick 1
- mellow kick hits 1
- mixed harmonizing choir 1
- passionate accordion melody 1
- passionate boy vocal 1
- passionate boys vocals 1
- passionate electric guitar melody 1
- passionate girls vocals 1
- passionate male vocal 1
- percussive elements 1
- regional mexican 1
- reverberant saxophone 1
- rock 1
- rock & roll 1
- romantic 1
- salsa 1
- saxophone melody 1
- shimmering bells melody 1
- shimmering chime bells 1
- shimmering crash cymbal 1
- smooth bass 1
- soft 1
- soft crashes 1
- soft snare 1
- strummed acoustic rhythm guitar chords progression 1
- subtle microphone feedback 1
- synth lead melody 1
- trumpet melody 1
- uplifting 1
- uptempo 1
- urban latin 1
- warm brass 1
- wide claps 1
- wide muffled brass section 1
- wide toms 1
- wooden percussion 1
- wooden percussions 1
- wooden percussive elements 1
musiccaps_names (array) 32 ✖
- Music 15
- Singing 4
- Happy music 3
- Salsa music 3
- Blues 2
- Choir 2
- Jazz 2
- Music of Latin America 2
- Pop music 2
- Song 2
- Swing music 2
- Bowed string instrument 1
- Brass instrument 1
- Cello 1
- Chant 1
- Christmas music 1
- Clarinet 1
- Classical music 1
- Double bass 1
- Harmonic 1
- Music for children 1
- Music of Africa 1
- Music of Asia 1
- Opera 1
- Orchestra 1
- Rock and roll 1
- Rock music 1
- Ska 1
- Soul music 1
- Trombone 1
- Trumpet 1
- Wedding music 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;