musiccaps_details (view)
4 rows where musiccaps_aspects contains "engaging", musiccaps_aspects contains "stringed instrument" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 58 ✖
- engaging · 4 ✖
- instrumental 4
- stringed instrument · 4 ✖
- fast tempo 3
- lively 3
- spirited 3
- folk music 2
- pleasant 2
- banjo 1
- banjo harmony 1
- banjo lead 1
- banjo solo 1
- bluegrass 1
- captivating 1
- classical music 1
- country music 1
- dance master’s fiddle 1
- dominant 1
- dulcet 1
- empahtic 1
- four stringed instrument 1
- hindustani music 1
- indian classical 1
- indian classical instruments 1
- irish banjo 1
- irish style banjo 1
- kit 1
- lead harmony 1
- lilting melody 1
- lute 1
- medium tempo 1
- melodic 1
- mesmerising 1
- minimalist 1
- oud 1
- pakistani music 1
- pochette 1
- popping sound 1
- raga 1
- rich 1
- sarod harmony 1
- simple 1
- skilful 1
- skilful musicians 1
- sliding pitches 1
- small bowed string instrument 1
- snappy 1
- solo 1
- string instrument 1
- strong melodic lines 1
- sweet 1
- sympathetic strings 1
- tenor banjo 1
- traditional music 1
- twangy 1
- upbeat 1
- vibration 1
- violin like instrument 1
musiccaps_names (array) 10 ✖
- Music 4
- Musical instrument 3
- Banjo 2
- Plucked string instrument 2
- Traditional music 2
- Bluegrass 1
- Guitar 1
- Mandolin 1
- Percussion 1
- Tabla 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 | |
Little Rock Getaway Performed by Daniel Patrick | This music is a lively Banjo instrumental. The tempo is fast with the musician dexterously playing a very spirited, vivacious and complex harmony. There is no other instrument accompaniment. This instrument is often heard in Country and Bluegrass. | 2009-03-21T18:53:07Z | James Duckworth | Number one of a session of seven song I was privileged to video of the young 14 year old self taught banjo talent Daniel Patrick from my area. Sit back enjoy the tune. Look for the others soon. www.danielpatrickandfamily.com | ["Banjo", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["instrumental", "fast tempo", "banjo", "stringed instrument", "country music", "folk music", "bluegrass", "popping sound", "snappy", "vibration", "lively", "spirited", "melodic", "engaging", "pleasant", "skilful"] | 7 | BWvKAcOV_co | 1251 | |
How to Play the Irish Tenor Banjo : Banjo Basics | This music is an enthusiastic Irish tenor Banjo instrumental. The tempo is fast with a lively, upbeat, soothing, emphatic, twangy, sweet, rich, and engaging with traditional and folksy groove. | 2013-07-09T01:02:01Z | ehow | Subscribe Now: http://www.youtube.com/subscription_center?add_user=ehow Watch More: http://www.youtube.com/ehow The tenor banjo is tuned in straight fifths. Find out how to play the Irish tenor banjo with help from an experienced music professional in this free video clip. Expert: Peter S. Kohman Contact: www.retrofret.com Bio: Peter Kohman became interested in old banjos and guitars at the age of 16. Filmmaker: B. Michael Sullivan Series Description: Owning a banjo requires you to both know how to play it and know how to take excellent care of it to preserve it for the future. Find out about banjo basics with help from an experienced music professional in this free video series. | ["Banjo", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["instrumental", "fast tempo", "banjo harmony", "sweet", "rich", "dulcet", "stringed instrument", "twangy", "engaging", "empahtic", "dominant", "solo", "irish banjo", "irish style banjo", "lively", "spirited", "engaging", "captivating", "pleasant", "lilting melody", "strong melodic lines", "banjo solo", "banjo lead", "tenor banjo", "four stringed instrument", "traditional music", "folk music", "classical music"] | 7 | JYYfw3id3ek | 2017 | |
polatidis v UMUT AYVAZ - TUZCUOGLU | This music is a lively instrumental. The tempo is fast with a spirited violin which is most likely a pochette playing a spirited harmony. The music is upbeat, catchy, happy,cheerful, engaging and energetic. This instrumental is a folk song instrumental. | 2008-07-22T17:38:32Z | kalospaidas | polatidis v UMUT AYVAZ - TUZCUOGLU | ["Traditional music", "Music"] | ["instrumental", "fast tempo", "stringed instrument", "lively", "spirited", "upbeat", "engaging", "simple", "lead harmony", "minimalist", "violin like instrument", "pochette", "string instrument", "small bowed string instrument", "kit", "dance master’s fiddle"] | 7 | ehJKd9HLA04 | 3891 |
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;