musiccaps_details (view)
3 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "medium tempo" and musiccaps_names contains "Percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 55 ✖
- instrumental · 3 ✖
- medium tempo · 3 ✖
- mesmerising 2
- oud 2
- active 1
- ambient 1
- amplified guitar harmony 1
- arabic music 1
- atmospheric 1
- beautiful 1
- call and response 1
- captivating 1
- classical music 1
- complex harmony 1
- contemporary jazz 1
- eastern classical 1
- empahtic 1
- energetic 1
- engaging 1
- folk music 1
- groovy bass line 1
- hand percussion 1
- hindustani music 1
- improvisation 1
- indian classical 1
- indian classical instruments 1
- informal 1
- irregular beats 1
- jazz 1
- lively 1
- lute 1
- middle eastern music 1
- nostalgic 1
- pakistani music 1
- pleasant 1
- polished 1
- polyrhythms 1
- raga 1
- regional music 1
- rim shot 1
- romantic 1
- santoor 1
- santoor harmony 1
- sarod harmony 1
- skilful musicians 1
- sliding pitches 1
- smooth 1
- solos 1
- spirited 1
- string instrument 1
- stringed instrument 1
- sympathetic strings 1
- syncopation 1
- tabla accompaniment 1
- traditional 1
musiccaps_names (array) 8 ✖
- Percussion · 3 ✖
- Tabla 2
- Drum 1
- Guitar 1
- Music 1
- Musical instrument 1
- Traditional music 1
- Wood block 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Daud Khan Sadozai - live - 2013 | This music is a mellifluous Indian classical instrumental. The tempo is fast with a harmonic sarod and rhythmic Oud accompaniment. The music is mesmerising, spirited, engaging, captivating and skilfully rendered Ragas. This instrumental is an Indian/Pakistani classical music. | 2013-02-10T17:18:05Z | soon4ward | Daud Khan live 26-01-2013 in Hagen, Germany. Daud Khan Sadozai - Robab, Sarod Efren Lopez - Robab, Oud Yma Karin / Shekab Wadwa- Tabla | ["Tabla", "Traditional music", "Guitar", "Music", "Musical instrument", "Percussion"] | ["instrumental", "medium tempo", "sarod harmony", "oud", "hindustani music", "indian classical", "stringed instrument", "lute", "pakistani music", "mesmerising", "engaging", "skilful musicians", "raga", "sympathetic strings", "sliding pitches", "indian classical instruments"] | 7 | ALU-1AILj1c | 1107 | |
Kabul Afghanistan 1978-79 - Rabab & Tabla (Rubab) | This music is instrumental. The tempo is medium with a lilting middle eastern kind of melody on a string instrument that sounds like a santoor along with a classical tabla accompaniment. The music is traditional, classical, captivating, romantic and nostalgic. This music is an Eastern Classical instrumental. | 2011-06-18T23:13:06Z | Noor Khan | 'Nastaran' - Recorded one snowy night in Kabul, February 1978 Rabab - Mir Mohammad, Tabla - Jan Mohammad *** More photos plus samples of a new completely different book about Pakistan (Khyber Pukhtunkhwa-NWFP) at http://www.pbase.com/noorkhan | ["Tabla", "Drum", "Percussion"] | ["instrumental", "medium tempo", "middle eastern music", "eastern classical", "santoor", "nostalgic", "romantic", "beautiful", "traditional", "regional music", "folk music", "captivating", "string instrument", "classical music", "oud", "arabic music", "pleasant", "mesmerising", "romantic", "santoor harmony", "tabla accompaniment", "hand percussion"] | 7 | KJHqQ5aKu8U | 2073 | |
Mimi Jones Band Live @ Smalls: Fast Lane | This music is a Jazz instrumental. The tempo is medium with a groovy bass one, smooth harmony on acoustic guitar and rim shots.The music is smooth, lively, informal, chill, ambient and atmospheric with the sound of musicians talking to each other. | 2010-10-01T16:24:53Z | Mimi Jones | Mimi Jones, bass; Sean Harkness, guitar; Miki Hayama, piano; Chris Eddleton, drums; Sam Newsome, soprano sax | ["Wood block", "Percussion"] | ["instrumental", "medium tempo", "jazz", "contemporary jazz", "call and response", "irregular beats", "solos", "rim shot", "complex harmony", "syncopation", "groovy bass line", "amplified guitar harmony", "polyrhythms", "ambient", "atmospheric", "improvisation", "lively", "energetic", "spirited", "active", "informal", "smooth", "polished", "empahtic"] | 7 | WK-gdfCurCg | 3085 |
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;