musiccaps_details (view)
22 rows where musiccaps_aspects contains "rich" and musiccaps_author = 7
This data as json
musiccaps_aspects (array) 281 ✖
- rich · 22 ✖
- instrumental 21
- slow tempo 8
- western classical 8
- engaging 6
- fast tempo 6
- intense 6
- orchestra 6
- classical 5
- concert 5
- exquisite 5
- medium tempo 5
- stringed instrument 5
- wind instrument 5
- cello 4
- classical music 4
- clear 4
- compelling 4
- dense 4
- live performance 4
- lively 4
- art music 3
- captivating 3
- chamber music 3
- demonstration 3
- elegant 3
- french horn 3
- loud 3
- minimalist 3
- powerful 3
- resonating 3
- spirited 3
- violins 3
- aerophone 2
- baroque 2
- blues 2
- bow stringed instrument 2
- brass instrument 2
- celestial 2
- cheerful 2
- deep 2
- deep sound 2
- dominant 2
- electric guitar 2
- electric guitar lesson 2
- electric guitar solo 2
- empahtic 2
- emphatic 2
- enthralling 2
- ethereal 2
- flute 2
- folk music 2
- full bodied 2
- harpsichord accompaniment 2
- italian composer 2
- jazz 2
- live audience 2
- male voice speaking 2
- melodic 2
- mesmerising 2
- monotone 2
- passionate 2
- people talking 2
- plucked string instrument 2
- reverb 2
- rock 2
- smooth 2
- soothing 2
- symphony 2
- traditional music 2
- trombone 2
- tutorial 2
- vibrant 2
- viola 2
- violin harmony 2
- violin symphony 2
- acoustic guitar accompaniment 1
- ambient outdoor sounds 1
- ambient sounds 1
- amplified guitar 1
- amplified instrument 1
- analog chorus 1
- arabic music 1
- atmospheric synthesiser 1
- australian accent 1
- bagpiper 1
- ball rom dancing 1
- ball room 1
- banjo harmony 1
- banjo lead 1
- banjo solo 1
- baroque music 1
- bassoon 1
- batman 1
- beautiful 1
- beautiful melody 1
- bellows 1
- bells 1
- blowing raspberries 1
- bongos 1
- bow shaped harp 1
- bow stringed instruments 1
- brass band 1
- breeze 1
- burgeoning 1
- calming 1
- cascading melody 1
- catchy riff 1
- celebratory 1
- celestial music 1
- cello harmony 1
- charming 1
- chordophone 1
- chorus guitar effect 1
- clarinet 1
- clasical music 1
- classic acoustic string instrument 1
- coke studio 1
- colourful 1
- comparison 1
- complex 1
- conductor 1
- congas 1
- contemporary indian pop 1
- counting 1
- counting in french 1
- creative 1
- crisp 1
- cymbal ride 1
- dense layers 1
- didgeridoo lesson 1
- didgeridoo melody 1
- didgeridoo tutorial 1
- double elcetric bass 1
- double reed 1
- double reed instrument 1
- dreamy 1
- drone pipes 1
- dulcet 1
- edgy 1
- egyptian oud 1
- electric cello 1
- electric guitar lead 1
- electric guitar techniques 1
- electric guitar tutorial 1
- electric guitars 1
- eloquent piano accompaniment 1
- emotional 1
- energetic 1
- engine sound 1
- english dance 1
- enigmatic 1
- euphonious 1
- female singer 1
- fiddle 1
- finger play 1
- flowing 1
- flute harmony 1
- flute melody 1
- four stringed instrument 1
- french composer 1
- french composition 1
- french horn tutorial 1
- french music 1
- full sounding 1
- gentle 1
- groovy 1
- guitar 1
- hand percussion 1
- happy 1
- hard rock 1
- harp 1
- harp solo 1
- harpsichord 1
- heavy metal 1
- high notes 1
- high pitched flute 1
- high-spirited 1
- holding notes 1
- how to play didgeridoo 1
- incessant buzz 1
- indian music 1
- inferior audio quality 1
- intense bass 1
- interlude in song 1
- intricately coiled instrument 1
- irish banjo 1
- irish style banjo 1
- italian music 1
- italian composition 1
- keeping beat 1
- keyboard instrument 1
- layers building gradually 1
- learning electric 1
- learning electric guitar 1
- lilting 1
- lilting melody 1
- live orchestra 1
- lively trumpets 1
- loud feed back 1
- low pitch 1
- low pitch instrument 1
- low pitched bassoon accompaniment 1
- lush 1
- male voice 1
- male voice talking 1
- medicinal music 1
- meditative 1
- medium fast 1
- melancholic 1
- melancholy 1
- mellow 1
- melodious 1
- melody pie 1
- merry 1
- metal 1
- metal bowls 1
- middle eastern cultural music 1
- monks 1
- music therapy 1
- nostalgic 1
- oldest instrument 1
- opera 1
- ost 1
- oud 1
- oud melody 1
- oud riff 1
- peaceful 1
- pensive 1
- percusssion 1
- piano 1
- piper 1
- pleasant 1
- pop 1
- powerful vocals 1
- pulsating 1
- reflective 1
- regional musc 1
- relaxing 1
- resounding 1
- review video 1
- rising tempo 1
- rock and roll 1
- serene 1
- shakers 1
- sharp sound 1
- sharp sounds 1
- singing bowls 1
- soft 1
- solo 1
- sonatas 1
- sonic delight 1
- sound of switches 1
- static 1
- stress relieving 1
- string instruments 1
- string section 1
- strong 1
- strong melodic lines 1
- sweet 1
- symphonic music 1
- synthesiser arrangements 1
- tenor banjo 1
- tenor bass range 1
- the horn 1
- tibetan bowls 1
- tortuga martini review 1
- trombone solo 1
- trumpet 1
- trumpets 1
- twangy 1
- vibrations 1
- vigorous 1
- vigorous clarinet solo 1
- violin 1
- vivid 1
- vocal vibrations 1
- warm 1
- western classic 1
- woodwindninst 1
- youthful 1
musiccaps_names (array) 40 ✖
- Music 7
- Brass instrument 4
- Musical instrument 4
- Plucked string instrument 4
- Guitar 3
- Keyboard (musical) 3
- Speech 3
- Trombone 3
- Bowed string instrument 2
- Clarinet 2
- Double bass 2
- Harpsichord 2
- Pizzicato 2
- Tapping (guitar technique) 2
- Wind instrument, woodwind instrument 2
- Accordion 1
- Bagpipes 1
- Banjo 1
- Bluegrass 1
- Cello 1
- Chorus effect 1
- Didgeridoo 1
- Distortion 1
- Echo 1
- Effects unit 1
- Electric guitar 1
- Electric piano 1
- Flute 1
- Foghorn 1
- Gong 1
- Harp 1
- Jazz 1
- Middle Eastern music 1
- Piano 1
- Rattle (instrument) 1
- Reverberation 1
- Singing 1
- Singing bowl 1
- Tender music 1
- Violin, fiddle 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;