musiccaps_details (view)
12 rows where musiccaps_aspects contains "violin" and musiccaps_author = 7
This data as json
musiccaps_aspects (array) 175 ✖
- violin · 12 ✖
- instrumental 9
- cello 6
- fast tempo 6
- intense 4
- animated 3
- concert 3
- country music 3
- emotional 3
- engaging 3
- fiddle 3
- orchestra 3
- piano accompaniment 3
- sentimental 3
- slow tempo 3
- soft 3
- string instrument 3
- viola 3
- acoustic guitar 2
- captivating 2
- carnatic music 2
- country pop 2
- digital drumming 2
- four stringed instrument 2
- happy 2
- lively 2
- male singer 2
- medium fast tempo 2
- melancholic 2
- mellow 2
- melodic 2
- melodious 2
- ragas 2
- soothing 2
- south indian classical 2
- spirited 2
- sruti 2
- symphony 2
- trombone 2
- violin harmony 2
- wind instrument 2
- ambient 1
- amplified cello harmony 1
- banjo 1
- baroque 1
- bassoon 1
- beseeching 1
- bleak 1
- boomy bass 1
- bow string instrument 1
- bow stringed 1
- bow stringed instrument 1
- bowed string instrument 1
- brass band 1
- brass instrument 1
- bright 1
- cajun music 1
- cheerful 1
- choral harmonybright trumpet harmony 1
- clapping 1
- clarinet 1
- clasical music 1
- classical ensemble 1
- compelling 1
- country folk song 1
- country hits 1
- country movie 1
- country song 1
- country songs 1
- cowboy 1
- crisis 1
- danger 1
- dangerous 1
- dark 1
- delicate 1
- devotional 1
- dire 1
- dismal 1
- dreamy 1
- dreary 1
- duel 1
- dulcet 1
- elegant 1
- emergency 1
- enthralling 1
- enthusiastic drumming 1
- exigency 1
- exquisite 1
- flute 1
- flute harmony 1
- french horn 1
- gadam rhythm 1
- ghatak 1
- gloomy 1
- grim 1
- helicopter sound 1
- high pitched 1
- high spirited 1
- hindu deities 1
- impactful 1
- indian clasical 1
- indian classical 1
- indian classical violin 1
- indian percussion instruments 1
- intesnse drumming 1
- jugalbandi 1
- keyboard accompaniment 1
- kriti 1
- live orchestra 1
- live performance 1
- male vocalist 1
- mandolin 1
- meditative 1
- medium tempo 1
- mellifluous 1
- mesmerising 1
- mridangam 1
- mridangam rhythm 1
- muffled audio 1
- orchestral music 1
- panic situation 1
- pensive 1
- people cheering 1
- percussion 1
- performance 1
- perky 1
- piano 1
- playful music 1
- pleading 1
- poignant 1
- ponderous 1
- prayer 1
- pressing 1
- reflective 1
- regional music 1
- regional pop 1
- request 1
- resonator 1
- rhythmic drumming 1
- rich 1
- ritardando 1
- romantic 1
- sad 1
- sentimental nostalgic 1
- sinister 1
- skilled 1
- sound of galloping horse 1
- south indian traditional music 1
- spirited string arrangement 1
- stage performance 1
- steady bass 1
- steady drumming 1
- story telling 1
- string harmony 1
- string orchestra 1
- surround sound 1
- synthesiser arrangement 1
- sythesiser arrangements 1
- tala 1
- traditional indian music 1
- triumphant music 1
- trumpet 1
- trumpet flourish 1
- trumpets 1
- ukelele accompaniment 1
- urgency 1
- vibrant 1
- video game music 1
- violin symphony 1
- vocal duel 1
- western classic 1
- western classical 1
- whimsical 1
- whistling 1
- xylophone 1
musiccaps_names (array) 23 ✖
- Music 9
- Bowed string instrument 3
- Carnatic music 2
- Cello 2
- Double bass 2
- Musical instrument 2
- Violin, fiddle 2
- Brass instrument 1
- Clarinet 1
- Classical music 1
- Country 1
- Folk music 1
- Helicopter 1
- Middle Eastern music 1
- Pizzicato 1
- Roll 1
- Scary music 1
- Sitar 1
- Swing music 1
- Traditional music 1
- Trombone 1
- Vibraphone 1
- Wedding music 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;