musiccaps_details (view)
28 rows where musiccaps_aspects contains "classical music" and musiccaps_author = 9
This data as json
musiccaps_aspects (array) 113 ✖
- classical music · 28 ✖
- instrumental 21
- live performance 8
- dramatic 7
- harpsichord 6
- medieval sounding 6
- violin 6
- epic 5
- gentle 5
- no singer 5
- piano 5
- tender 5
- baroque 4
- eccentric 4
- orchestra 4
- brass 3
- cello 3
- heart-touching 3
- melancholic 3
- movie music 3
- single instrument 3
- unique 3
- amateur recording 2
- calming 2
- emotional 2
- grandiose 2
- major key 2
- march 2
- mellow 2
- sentimental 2
- theremin 2
- tuba 2
- acoustic guitar 1
- anthem 1
- baritone saxophone 1
- bass drum 1
- basset horn 1
- bassoon 1
- brass section 1
- calm 1
- cello-like sound 1
- cheerful 1
- clarinet 1
- claviorgan 1
- contemporary 1
- contrabass 1
- cymbal 1
- dark 1
- delicate 1
- double bass 1
- dreamy 1
- eerie 1
- electronic sounding 1
- enigmatic 1
- fast-paced 1
- french horn 1
- french opera 1
- gentle playing 1
- gloomy 1
- harp 1
- impressionist 1
- inauthentic 1
- innovative 1
- intense 1
- intrigue 1
- italian 1
- lively 1
- male vocal 1
- mandolin 1
- maximalist 1
- melodic 1
- military march 1
- minor key 1
- movie soundtrack 1
- mysterious 1
- oboe 1
- optimistic 1
- percussive 1
- philharmonic orchestra 1
- positive 1
- profound 1
- recital 1
- relaxing 1
- resolution 1
- rising pattern 1
- romantic era 1
- saxophone quartet 1
- saxophone solo 1
- serene 1
- simple tune 1
- slightly poor quality 1
- slow tempo 1
- snare drum 1
- solemn 1
- sophisticated 1
- soprano 1
- string quartet 1
- strings 1
- suspenseful 1
- tango 1
- tension 1
- timpani 1
- triangle 1
- trombone 1
- trombones 1
- trumpet solo 1
- varying pitch 1
- vibrant 1
- viola 1
- virtual sounds 1
- weird 1
- wind orchestra 1
- winds 1
musiccaps_names (array) 30 ✖
- Keyboard (musical) 9
- Music 8
- Brass instrument 7
- Bowed string instrument 6
- Harpsichord 6
- Musical instrument 6
- Violin, fiddle 5
- Cello 4
- Classical music 4
- Double bass 4
- Clarinet 3
- Piano 3
- Saxophone 3
- Orchestra 2
- Theremin 2
- Acoustic guitar 1
- Foghorn 1
- French horn 1
- Guitar 1
- Harp 1
- Inside, small room 1
- Opera 1
- Percussion 1
- Pizzicato 1
- Plucked string instrument 1
- Strum 1
- Trombone 1
- Trumpet 1
- Wind instrument, woodwind instrument 1
- Wood block 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;