musiccaps_details (view)
2 rows where search matches "guitar" and "youtube_published" is on date 2008-09-27 sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- acoustic drums 1
- arabesque 1
- bass guitar 1
- clarinet 1
- digital drums 1
- e-guitar 1
- electro/rock 1
- emotional 1
- fast paced 1
- heart-touching 1
- keyboard 1
- live performance 1
- percussion 1
- qanun 1
- saz 1
- synth bass 1
- turkish folk 1
- uplifting 1
- vibrant 1
musiccaps_names (array) 4 ✖
- Music 2
- Angry music 1
- Clarinet 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Devil Jin's theme (Tekken 5-dark resurrection) | This song contains a synth bass changing pitch really fast along with a digital drum groove. A distorted e-guitar is playing a riff that is panned to the right side of the speakers. This audio may be playing in a fast paced, arcade video-game. | 2008-09-27T15:36:29Z | Dbzfan109 | I am still taking request even though I am having a REALLY hard time finding these mp3's | ["Music", "Angry music"] | ["electro/rock", "synth bass", "e-guitar", "digital drums", "fast paced", "uplifting"] | 6 | DC0C-KO9EJk | 1451 |
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;