musiccaps_details (view)
17 rows where musiccaps_aspects contains "classical" and musiccaps_author = 9
This data as json
musiccaps_aspects (array) 91 ✖
- classical · 17 ✖
- instrumental 10
- live performance 6
- piano 6
- calming 3
- movie music 3
- no singer 3
- orchestra 3
- strings 3
- contemporary 2
- dramatic 2
- easygoing 2
- emotional 2
- festive 2
- grand piano 2
- grandiose 2
- heart-touching 2
- joyful 2
- lively 2
- single instrument 2
- strings section 2
- unique 2
- vibrant 2
- accentuated playing 1
- acoustic guitar 1
- ambient sounds 1
- ambient synth 1
- animal-like 1
- baroque 1
- birds singing 1
- brass section 1
- canon 1
- catchy 1
- celebration 1
- cello 1
- chamber orchestra 1
- cheerful 1
- chinese 1
- cinematic 1
- cinematic strings 1
- compilation 1
- crestfallen 1
- eastern 1
- eerie 1
- elegant 1
- female vocal 1
- french horn 1
- fugue 1
- gentle 1
- glass harp 1
- harp 1
- haunting 1
- high-pitched 1
- high-pitched singing 1
- hopeful 1
- horn 1
- iconic 1
- lighthearted 1
- lullaby 1
- male vocal 1
- medium-to-high pitch singing 1
- melancholic 1
- minor key 1
- mysterious 1
- opera 1
- organ 1
- outer space 1
- passionate 1
- poor quality 1
- positive 1
- powerful 1
- procession 1
- profound 1
- relaxing 1
- reverb 1
- romantic 1
- russian 1
- saxophone 1
- saxophone solo 1
- sleep 1
- soothing 1
- sound effects 1
- tarantella 1
- theremin 1
- tubular bells 1
- underwater 1
- vocal range 1
- waltz 1
- wedding 1
- wedding music 1
- xiao 1
musiccaps_names (array) 27 ✖
- Music 14
- Musical instrument 4
- Wedding music 4
- Keyboard (musical) 3
- Piano 3
- Bowed string instrument 2
- Brass instrument 2
- Cello 2
- Classical music 2
- French horn 2
- Opera 2
- Ambient music 1
- Double bass 1
- Electric piano 1
- Flute 1
- Glass 1
- Harmonic 1
- Harpsichord 1
- Lullaby 1
- Sad music 1
- Salsa music 1
- Saxophone 1
- Singing 1
- String section 1
- Theme music 1
- Theremin 1
- Whale vocalization 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;