musiccaps_details (view)
2 rows where search matches "opera", musiccaps_aspects contains "clarinet" and musiccaps_author = 9 sorted by youtube_channel
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 19 ✖
- bass guitar 2
- clarinet · 2 ✖
- emotional 2
- acoustic drums 1
- acoustic guitar 1
- arabesque 1
- chimes 1
- electronic drums 1
- heart-touching 1
- keyboard 1
- live performance 1
- melodic pad 1
- percussion 1
- qanun 1
- saz 1
- sentimental 1
- soap opera theme 1
- turkish folk 1
- vibrant 1
musiccaps_names (array) 4 ✖
- Music 2
- Clarinet 1
- Sad music 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ab Tere Bin Hum Bhi Jee Lenge from AURANGZEB | This is a soap opera theme music. There is a clarinet playing the main tune with the acoustic guitar and the bass guitar in the backing. There is a melodic pad that can be heard. An acoustic sounding electronic cymbal and wind chimes strokes are playing every now and then. There is a sentimental atmosphere to this piece. | 2010-09-16T12:47:18Z | AB Shah Ahmad | very nice song | ["Music", "Sad music"] | ["soap opera theme", "acoustic guitar", "clarinet", "bass guitar", "melodic pad", "electronic drums", "chimes", "sentimental", "emotional"] | 9 | sMNuJy4f4A0 | 4944 | |
Hüsnü Klarnet - senin olmaya geldim | This is the live performance of a Turkish folk music piece with arabesque influences. The clarinet is playing the main melody in the lead at a medium-to-high pitch. A secondary melody is playing the qanun in the background. There are supportive elements in the melodic background such as the saz, the keyboard and the bass guitar. The acoustic drums are playing a mellow beat accompanied by rich percussion. There is a vibrant atmosphere in this piece. This could be playing in the background of a Turkish cuisine restaurant or a hookah place. It could also be used in the soundtrack of a Turkish soap opera. | 2008-09-27T11:11:52Z | hsenlendirici | WWW.HUSNUFAN.ORG | ["Clarinet", "Traditional music", "Music"] | ["turkish folk", "arabesque", "clarinet", "qanun", "saz", "keyboard", "bass guitar", "acoustic drums", "percussion", "vibrant", "emotional", "heart-touching", "live performance"] | 9 | BMgYWTTJv3s | 1232 |
Advanced export
JSON shape: default, array, newline-delimited
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;