musiccaps_details (view)
18 rows where musiccaps_aspects contains "tabla" and musiccaps_author = 9
This data as json
musiccaps_aspects (array) 78 ✖
- tabla · 18 ✖
- sitar 6
- vibrant 6
- bansuri 5
- live performance 5
- male vocal 5
- female vocal 4
- harmonium 4
- carnatic classical 3
- hindu 3
- joyful 3
- lively 3
- percussion 3
- religious 3
- spiritual 3
- backing track 2
- carnatic violin 2
- complex 2
- devotional 2
- dreamy 2
- female vocals 2
- hindustani classical music 2
- instrumental 2
- versatile singing 2
- afghan 1
- amusing 1
- bhajan 1
- bhakti 1
- cajon 1
- comedy 1
- cymbals 1
- devotional singing 1
- drums 1
- electronic drums 1
- emotional 1
- esraj 1
- funny singing 1
- gujarati folk music 1
- haunting 1
- heart-touching 1
- hindi language 1
- hypnotic 1
- indian 1
- indian classical 1
- indian film music 1
- indian folk music 1
- indian traditional music 1
- instructive recording 1
- italian language 1
- kanjira 1
- kathak dance 1
- male child voice 1
- male vocals 1
- male voices 1
- manjira 1
- medium tempo 1
- medium-to-high pitch singing 1
- melodic singing 1
- movie music 1
- nepali folk music 1
- obscene 1
- orchestra 1
- passionate singing 1
- profound 1
- repeated theme 1
- romantic 1
- romantic pop 1
- sanskrit 1
- sentimental 1
- singing 1
- strings 1
- talking 1
- tanpura 1
- trippy 1
- upbeat 1
- vedic music 1
- veena 1
- veena-like singing 1
musiccaps_names (array) 18 ✖
- Music 11
- Tabla 8
- Carnatic music 7
- Percussion 6
- Classical music 4
- Drum 4
- Folk music 3
- Middle Eastern music 3
- Music of Asia 3
- Music of Bollywood 2
- Singing 2
- Sitar 2
- Bowed string instrument 1
- Flute 1
- Mantra 1
- Musical instrument 1
- Song 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;