musiccaps_details (view)
18 rows where musiccaps_aspects contains "classical music" and musiccaps_author = 7
This data as json
musiccaps_aspects (array) 249 ✖
- classical music · 18 ✖
- instrumental 12
- slow tempo 9
- western classical 9
- fast tempo 6
- captivating 4
- celestial 4
- dreamy 4
- emotional 4
- enchanting 4
- ethereal 4
- meditative 4
- pensive 4
- rich 4
- soothing 4
- dulcet 3
- enthralling 3
- female singer 3
- harp 3
- high notes 3
- lively 3
- melancholic 3
- mellow 3
- melodic 3
- nostalgic 3
- orchestra 3
- pleasant 3
- raga 3
- soft 3
- soprano 3
- stringed instrument 3
- wistful 3
- angelic 2
- arabic music 2
- beautiful 2
- calming 2
- cello 2
- chanting 2
- concert 2
- contemplative 2
- energetic 2
- engaging 2
- euphonious 2
- falsetto 2
- flute melody 2
- folk music 2
- french composer 2
- french composition 2
- indian classical 2
- lilting melody 2
- live performance 2
- mellifluous 2
- mesmerising 2
- middle eastern music 2
- minimalist 2
- mystical 2
- oldest instrument 2
- opera singer 2
- plucked string instrument 2
- regional music 2
- sentimental 2
- serene 2
- spirited 2
- sruti 2
- taal 2
- viola 2
- violin symphony 2
- violins 2
- vocalisation 2
- acoustic guitar accompaniment 1
- aerophone 1
- alap 1
- amateur recording 1
- ambient auditorium sounds 1
- ancient lineage instrument 1
- animated trombone 1
- art music 1
- banjo harmony 1
- banjo lead 1
- banjo solo 1
- bee 1
- beseeching 1
- bhakti 1
- bow shaped harp 1
- bow stringed instrument 1
- bow stringed instruments 1
- brass band 1
- bumble bee 1
- buzzing 1
- buzzing sound 1
- calm 1
- carnatic music 1
- cascading melody 1
- catholic prayer 1
- catholic salutation 1
- celebratory 1
- chamber music 1
- chant like 1
- cheerful 1
- choral symphony 1
- chordophone 1
- clapping 1
- classical song 1
- clear 1
- complex 1
- deep sound 1
- deliberate 1
- descan 1
- descant 1
- devotional 1
- dominant 1
- drone layer 1
- droning 1
- eastern classical 1
- elegy 1
- empahtic 1
- emphatic solos 1
- emphatic vocals 1
- energetic drumming 1
- enigmatic 1
- enthusiastic 1
- enthusiastic harpsichord 1
- enthusiastic piano 1
- expressive vocals 1
- extemporaneous 1
- female harpist 1
- female vocalist 1
- fiddle 1
- flowing 1
- folk song 1
- four stringed instrument 1
- french music 1
- full sounding 1
- gentle 1
- ghatam 1
- hand percussion 1
- happy 1
- harmony 1
- harp solo 1
- harpsichord 1
- harpsichord accompaniment 1
- heavenly 1
- hills 1
- hindustani 1
- hindustani instrumental 1
- honey bee 1
- hynoptic 1
- imploring 1
- incessant 1
- incoherent music 1
- indian bowed string instrument 1
- indian classical music 1
- indian percussion 1
- indian string instrument 1
- indian wind instrument 1
- intense cello 1
- irish banjo 1
- irish style banjo 1
- keyboard instrument 1
- lao folk music 1
- laos classical song 1
- laos folk song 1
- laotian classical music 1
- latin music 1
- latin song 1
- lilting 1
- lively engaging 1
- lively veena harmony 1
- lonely 1
- low pitch 1
- lucid vocals 1
- magical 1
- magicalvocalisation 1
- male vocalist 1
- march like drum beat 1
- masterpiece 1
- medium fast tempo 1
- medium tempo 1
- melancholy 1
- melodic flute harmony 1
- melodic layer 1
- melodic violin 1
- minimalist music 1
- mosquito 1
- mountains 1
- mridangam 1
- north indian classical music 1
- opera 1
- ost 1
- oud 1
- oud melody 1
- passionate 1
- peaceful 1
- people talking 1
- percussion layer 1
- philharmonic 1
- piano accompaniment 1
- playful 1
- pleading 1
- plucking 1
- poignant 1
- rapid 1
- resonating 1
- resonator 1
- romantic 1
- sad 1
- sandhya raag 1
- santoor 1
- santoor harmony 1
- sarangi 1
- sharp sound 1
- small hand cymbals 1
- soft piano 1
- solo 1
- soloist 1
- soundtrack 1
- south indian classical music 1
- south indian music 1
- sow tempo 1
- story telling 1
- string instrument 1
- string instruments 1
- strong melodic lines 1
- swar 1
- sweet 1
- symphonic music 1
- symphony orchestra 1
- tabla 1
- tabla accompaniment 1
- tabla rhythm 1
- tanpura 1
- tenor banjo 1
- tenor sax 1
- traditional 1
- traditional music 1
- twangy 1
- untiring 1
- vibrant 1
- vigorous 1
- violin accompaniment 1
- violin harmony 1
- vocal backup 1
- vocal harmony 1
- wind band repertoire 1
- wind instrument 1
- wind of provence 1
- woodwind 1
- xylophone like instrument 1
- youthful 1
musiccaps_names (array) 31 ✖
- Music 10
- Folk music 3
- Opera 3
- Percussion 3
- Brass instrument 2
- Drum 2
- Musical instrument 2
- Tabla 2
- Banjo 1
- Bluegrass 1
- Bowed string instrument 1
- Carnatic music 1
- Cello 1
- Country 1
- Double bass 1
- Flute 1
- Harp 1
- Harpsichord 1
- Keyboard (musical) 1
- Mantra 1
- Middle Eastern music 1
- New-age music 1
- Pizzicato 1
- Plucked string instrument 1
- Rattle (instrument) 1
- Saxophone 1
- Sitar 1
- Tender music 1
- Trombone 1
- Violin, fiddle 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;