musiccaps_details (view)
93 rows where musiccaps_aspects contains "piano" and musiccaps_author = 9
This data as json
musiccaps_aspects (array) 334 ✖
- piano · 93 ✖
- bass guitar 31
- acoustic drums 29
- instrumental 29
- male vocal 27
- melodic singing 24
- strings 19
- female vocal 17
- emotional 15
- no singer 15
- sentimental 13
- electric guitar 12
- electronic drums 11
- live performance 11
- gentle 9
- upright bass 9
- groovy 8
- melancholic 8
- acoustic guitar 7
- jazz 7
- mellow 7
- playful 7
- pop music 7
- upbeat 7
- calming 6
- classical 6
- easygoing 6
- flute 6
- heart-touching 6
- male vocals 6
- slow tempo 6
- trumpet 6
- vibrant 6
- violin 6
- classical music 5
- eccentric 5
- joyful 5
- latin percussion 5
- lively 5
- movie music 5
- religious 5
- romantic 5
- salsa 5
- saxophone 5
- sound effects 5
- dramatic 4
- eerie 4
- relaxing 4
- repeated theme 4
- simple tune 4
- spiritual 4
- synth 4
- acoustic jazz drums 3
- choir 3
- clarinet 3
- complex 3
- dance 3
- energetic 3
- gentle singing 3
- gospel 3
- hip 3
- hip-hop 3
- jazz music 3
- keyboard 3
- latin dance 3
- loud 3
- medium-to-high pitch singing 3
- poor quality 3
- rapping 3
- rock music 3
- sensual 3
- soothing 3
- unique 3
- amateur recording 2
- backing track 2
- ballad 2
- bizarre 2
- bleak 2
- brass 2
- celtic 2
- cheerful 2
- chill 2
- christian 2
- comedic 2
- danceable 2
- dreamy 2
- educational 2
- electronic percussion 2
- guitar solo 2
- jam 2
- jazz fusion 2
- jingle 2
- lullaby 2
- melodic 2
- optimistic 2
- orchestra 2
- passionate 2
- percussion 2
- positive 2
- r&b 2
- rising pattern 2
- rock 2
- rock opera 2
- shouting 2
- story-telling mood 2
- swing 2
- synth strings 2
- theremin 2
- trombone 2
- uneasy 2
- urban 2
- xylophone 2
- acoustic guitars 1
- acoustic live performance 1
- advertisement jingle 1
- afropop 1
- airy strings 1
- ambient 1
- ambient sounds 1
- ambient synth 1
- amusing 1
- animal-like 1
- anime music 1
- armenian 1
- background music 1
- bass 1
- beating 1
- beep 1
- bhajan 1
- big band 1
- birds singing 1
- blues 1
- boogie woogie 1
- brass section 1
- brazilian portuguese 1
- calm 1
- car engine sound 1
- carnatic music 1
- cartoon theme 1
- celeste 1
- cello 1
- childlike 1
- chipmunk vocal 1
- christian contemporary music 1
- christian music 1
- christian rock 1
- christmas 1
- cinematic 1
- cinematic synth 1
- clave 1
- clicks 1
- comedy 1
- complaining 1
- contemporary 1
- contemporary classical 1
- country music 1
- cover 1
- cowbell 1
- crestfallen 1
- crisp synth 1
- crying 1
- cumbia 1
- dancehall 1
- deep house 1
- devotional singing 1
- distorted 1
- downcast 1
- downtempo 1
- dramatic singing 1
- dread 1
- drums 1
- dulcimer 1
- electro swing 1
- electronic 1
- electronic dance music 1
- electronic music 1
- electronica 1
- enigmatic 1
- euphoric 1
- exhilarating 1
- female choir 1
- female vocal sample 1
- female vocals 1
- female voice 1
- festive 1
- folk music 1
- folk rock 1
- fooling around 1
- french horn 1
- funk 1
- funky 1
- funny 1
- gentle playing 1
- gibberish singing 1
- gloomy 1
- goosebumps 1
- gothic 1
- granular synth 1
- hard 1
- harmony singing 1
- harp 1
- harpsichord 1
- haunting 1
- heartbeat 1
- high pitch 1
- high-pitch singing 1
- hindi film music 1
- hindu 1
- hip-hop music 1
- hmong pop 1
- horror 1
- hungarian pop 1
- improvisation 1
- indo-european fusion 1
- instructive 1
- instrument review 1
- irritating 1
- italian 1
- japanese 1
- japanese jazz 1
- jolly 1
- joyful singing 1
- kids song 1
- latin 1
- latin acoustic drums 1
- latin dance music 1
- latin music 1
- latin percussive elements 1
- latin pop music 1
- light-hearted 1
- loud singing 1
- male voice 1
- mandolin 1
- maracas 1
- mashup 1
- meditation music 1
- medium pitch singing 1
- medium tempo 1
- medium-to-high pitch 1
- medium-to-high pitch male vocal 1
- mellow sounding 1
- merrily singing 1
- metalcore 1
- minimal 1
- modern r&b 1
- modern sounding 1
- movie trailer 1
- musical 1
- musical piece 1
- mysterious 1
- new-age 1
- normal tempo 1
- nostalgic 1
- old recording 1
- opera 1
- orchestral rock 1
- organ 1
- out of tune 1
- outer space 1
- package opening 1
- persian folk music 1
- playful singing 1
- pop rock 1
- post-hardcore 1
- profound 1
- progressive rock 1
- quirky 1
- rap-like singing 1
- raw 1
- rebellious 1
- religious music 1
- resentment 1
- resolution 1
- restless 1
- rhodes 1
- rhythm 1
- rhythmic effects 1
- romance 1
- russian 1
- saxophone solo 1
- saxophones 1
- scratching 1
- seductive singing 1
- serene 1
- shoes 1
- showcase 1
- shredding 1
- sigh-like singing 1
- simple 1
- sitar 1
- sleep 1
- slow 1
- soap opera music 1
- soap opera soundtrack 1
- soft 1
- soft rock 1
- soul 1
- soul music sample 1
- spoken word 1
- strings sound 1
- strong bass 1
- suspense 1
- syncopated 1
- synth bass 1
- tap dancing 1
- techno trance 1
- terrified female voice 1
- thai 1
- theme music 1
- toy 1
- toy review 1
- transition effects 1
- transposed instruments 1
- trumpet solo 1
- trumpets 1
- tuba 1
- turntable 1
- underwater 1
- unsettling 1
- uplifting 1
- valentines 1
- various instruments 1
- vibraphone 1
- video game theme 1
- violence 1
- virtual sounding brass 1
- vocal fry 1
- vocal performance 1
- warp effect 1
- water running 1
- wedding 1
- winds section 1
- world 1
- youtube channel intro 1
musiccaps_names (array) 95 ✖
- Music 73
- Brass instrument 7
- Keyboard (musical) 7
- Piano 6
- Happy music 5
- Sad music 5
- Salsa music 5
- Christian music 4
- Electric piano 4
- Lullaby 4
- New-age music 4
- Saxophone 4
- Singing 4
- Song 4
- Soundtrack music 4
- Trombone 4
- Wedding music 4
- Ambient music 3
- Bowed string instrument 3
- Cello 3
- Double bass 3
- Electronica 3
- Independent music 3
- Music of Asia 3
- Music of Latin America 3
- Musical instrument 3
- Speech 3
- Swing music 3
- Tender music 3
- Theremin 3
- Trumpet 3
- /t/dd00003 2
- /t/dd00004 2
- Background music 2
- Blues 2
- Carnatic music 2
- Classical music 2
- Country 2
- Exciting music 2
- Hip hop music 2
- Jazz 2
- Opera 2
- Rapping 2
- Rhythm and blues 2
- Ska 2
- Violin, fiddle 2
- /m/05zppz 1
- Afrobeat 1
- Angry music 1
- Beep, bleep 1
- Car 1
- Cash register 1
- Chant 1
- Child singing 1
- Clarinet 1
- Disco 1
- Drum and bass 1
- Echo 1
- Electric guitar 1
- Electronic dance music 1
- Electronic music 1
- French horn 1
- Funk 1
- Grunge 1
- Guitar 1
- Harmonic 1
- Harp 1
- Harpsichord 1
- Heart murmur 1
- House music 1
- Inside, small room 1
- Music for children 1
- Music of Africa 1
- Music of Bollywood 1
- Orchestra 1
- Outside, urban or manmade 1
- Pizzicato 1
- Plucked string instrument 1
- Punk rock 1
- Roll 1
- Scratching (performance technique) 1
- Singing bowl 1
- Soul music 1
- Tap 1
- Techno 1
- Theme music 1
- Tick 1
- Traditional music 1
- Trance music 1
- Vehicle 1
- Vocal music 1
- Whale vocalization 1
- Wind instrument, woodwind instrument 1
- Yodeling 1
- Zing 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;