musiccaps_details (view)
2 rows where search matches "opera" and musiccaps_aspects contains "keyboard" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- keyboard · 2 ✖
- 50s/60s ballad 1
- acoustic drums 1
- arabesque 1
- bass guitar 1
- clarinet 1
- emotional 1
- female voice singing 1
- heart-touching 1
- live performance 1
- percussion 1
- qanun 1
- saz 1
- slow tempo 1
- string section 1
- turkish folk 1
- upright bass bowed 1
- vibrant 1
musiccaps_names (array) 5 ✖
- Music 2
- Clarinet 1
- Opera 1
- Soundtrack music 1
- Traditional music 1
youtube_published (date) 2 ✖
- 2008-09-27 1
- 2011-03-15 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Sound of Music Soundtrack - 15 - Climb Ev'ry Mountain | A female voice is singing with a slight opera feeling to it. A string section is playing along with her melody. An upright-bass is played with a bow providing the bassline. This song may be playing at a musical. | 2011-03-15T02:03:19Z | xosoundtrackloverxo | ["Music", "Opera", "Soundtrack music"] | ["50s/60s ballad", "string section", "keyboard", "upright bass bowed", "female voice singing", "slow tempo"] | 6 | UtCRBs5p4EQ | 2951 | ||
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;