musiccaps_details (view)
16 rows where musiccaps_aspects contains "instrumental" and musiccaps_names contains "Piano"
This data as json
musiccaps_aspects (array) 163 ✖
- instrumental · 16 ✖
- no singer 7
- organ 4
- energetic 3
- keyboard 3
- piano 3
- bass 2
- calming 2
- danceable 2
- electronic drums 2
- fast tempo 2
- funky 2
- improvisation 2
- jazz 2
- medium tempo 2
- no voices 2
- piano sound 2
- synth 2
- acoustic drums 1
- acoustic guitar 1
- ambient 1
- ball rom dancing 1
- ball room 1
- bass guitar 1
- bass notes 1
- bass track 1
- basset horn 1
- bassoon 1
- batman 1
- bebop jazz 1
- burgeoning 1
- catchy 1
- celebratory 1
- celeste 1
- chamber music 1
- cheerful 1
- church music 1
- church organ 1
- clarinet 1
- classic pop 1
- classical 1
- classical music 1
- clinking sound 1
- colourful 1
- complex 1
- complex chords 1
- contrabass 1
- cover 1
- demo 1
- dense 1
- duo 1
- easy listening 1
- eccentric 1
- edm 1
- electric cello 1
- electric guitar sound 1
- electric piano 1
- electro pop 1
- electronic keyboard 1
- electronic music 1
- elegant 1
- emotional 1
- experimental music 1
- exquisite 1
- funk guitar track 1
- funk jazz 1
- futuristic 1
- gentle 1
- gospel 1
- groovy 1
- guitar 1
- guitar solo 1
- harpsichord 1
- high notes 1
- inauthentic 1
- innovative 1
- intricate organ playing 1
- j-pop 1
- jam 1
- jazz and electronic collaboration 1
- jazz fusion 1
- jazz style drumming 1
- jazz tone 1
- jazz-o-tech 1
- keyboard harmony 1
- latin 1
- layering 1
- live recording 1
- lively 1
- love song 1
- low keys 1
- major key 1
- male voice speaking 1
- male voice talking 1
- meditation music 1
- melancholic 1
- mellow 1
- melodic 1
- merry 1
- minimal instruments 1
- minimalist 1
- new-age 1
- no other instruments 1
- no percussion 1
- nostalgic 1
- oboe 1
- orchestra 1
- ost 1
- peppy 1
- poor audio quality 1
- poor quality 1
- pop 1
- positive 1
- punchy 1
- relaxing 1
- repeated theme 1
- rhodes 1
- rich 1
- romantic 1
- sentimental 1
- sharp notes 1
- simple melody 1
- single instrument 1
- slow pop song 1
- slow tempo 1
- soft 1
- solo 1
- song introduction 1
- soothing 1
- soulful 1
- sound testing 1
- soundtrack 1
- string section 1
- synth music 1
- synth review 1
- synth song 1
- synth strings 1
- synthesised bass 1
- synthesiser arrangement 1
- synthesiser demonstration 1
- synthesiser lesson 1
- synthesiser tutorial 1
- synthesises funk guitar 1
- techno 1
- techno jazz 1
- techno trance 1
- treble notes 1
- tutorial 1
- two seperate grooves 1
- upbeat 1
- urban 1
- various instruments 1
- vibrant 1
- vibraphone 1
- violin symphony 1
- violins 1
- virtual sounds 1
- vivacious 1
- vivid 1
- western classical 1
- whirring sound 1
- winds 1
- wobbly bass 1
musiccaps_names (array) 16 ✖
- Piano · 16 ✖
- Keyboard (musical) 15
- Electric piano 12
- Music 4
- Musical instrument 3
- Organ 3
- Electronic organ 2
- Hammond organ 2
- Synthesizer 2
- Brass instrument 1
- Clarinet 1
- Inside, small room 1
- Lullaby 1
- Reverberation 1
- Vibraphone 1
- Wind instrument, woodwind instrument 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;