musiccaps_details (view)

7 rows where musiccaps_aspects contains "noisy", musiccaps_names = "["Tabla", "Drum", "Percussion"]" and musiccaps_names contains "Percussion"

✎ View and edit SQL

This data as json, CSV (advanced)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Saleem Javeed qawwali Nizampur part 1 The low quality recording features a live performance of a traditional song and it consists of an echoing male vocal singing over acoustic strings melody, plucked strings melody and wooden percussion. There is a crowd chattering noise in the background. The recording is a bit noisy and it sounds passionate. 2014-08-05T20:41:31Z KOKAN MEHFIL-E-QAWWALI Everyone should watch the video ["Tabla", "Drum", "Percussion"] ["low quality", "echoing male vocal", "acoustic strings melody", "crowd chattering", "wooden percussions", "plucked strings melody", "live performance", "traditional", "noisy", "passionate"] 4 -6QGvxvaTkI 15
Photo Zardari %%Bewafa dil tori chadei. The low quality recording features a flat male vocal singing over digital piano melody and wooden percussion. The recording is noisy, in mono, loud and distorted. 2012-06-03T10:43:33Z arjiskani ["Tabla", "Drum", "Percussion"] ["low quality", "mono", "noisy", "flat male vocal", "wooden percussions", "digital piano melody", "loud", "distorted"] 4 -w4HLksto_k 102
Mridanga Lessons Pt. 4 The low quality recording features a traditional song sung by flat male vocals over wooden, boomy percussion. The recording is in mono, a bit noisy and it sounds muddy, as the bass frequencies are overwhelming. 2008-11-22T07:37:17Z abhijitb1 New Rhythm: Dha - Ge - Ti - Kha Na - Ge - Dhi - Na ["Tabla", "Drum", "Percussion"] ["low quality", "boomy", "wooden percussion", "flat male vocal", "noisy", "traditional", "muddy"] 4 6PquRVe1Wa4 752
Ustad Salamat Ali Khan and Salar Nader The low quality recording features a live performance of a traditional song and it consists of a flat male vocal singing over sustained strings melody and mellow, subtle percussive element. There are some people talking in the background, followed by a cough. It sounds passionate and emotional, even though the recording is noisy and in mono. 2007-08-02T09:06:32Z cyrh Legendary vocalist from Sham Chorasi Gharana Ustad Salamat Ali khan accompanied by his sons Shafqat Ali khan and Sukhawat Ali Khan, 11 year old Salar Nader on Tabla ["Tabla", "Drum", "Percussion"] ["low quality", "traditional", "live performance", "noisy", "mono", "flat male vocal", "mellow wooden percussion", "sustained strings melody", "passionate", "emotional", "people talking", "cough"] 4 NgniX3tg_Mo 2355
Play Tabla - Oxford, teaching video 1 of 15, BOL(stroke) The low quality recording features a live performance of a traditional song and it consists of pitch bend wooden percussion. It sounds boomy and the recording is in mono and noisy. 2014-07-15T10:23:08Z Conrad Weiskrantz The wonderful sound of tabla is always given life, variation and beauty by the bayan (left hand drum) strokes. Have a look at this and discover the left hand strokes Ghe and Ke - an open and a closed stroke. Find out how to play one of the most important phrases for tabla which is TeTe. Discover another phrase called Tira Kita. Featuring the tabla virtuoso Pandit Sharda Sahai. Website to follow soon, if you have any questions please email: oxfordtabla@outlook.com ["Tabla", "Drum", "Percussion"] ["low quality", "pitch bend wooden percussions", "boomy", "traditional", "noisy", "mono", "live performance"] 4 RxmGtt0YzYY 2732
Ustad Younas Khan 'Joona ' Tabla legend of Lahore The low quality recording features a groovy tabla percussion playing. The recording is noisy and in mono. 2010-07-06T04:51:47Z Asarulislam Ace Tabla player of Pakistan Ustad Younas Khan Joona, a maestro of Tabla, came from a family of musicians and percussionists. He lived in Mohalla Dhup Sari, Mozang Lahore. He was highly respected in the circle of musicians of Lahore. He was classically trained and lived a humble life. Returning from a musical performance in Sialkot, Ustad Joona was killed in a car accident near Muridke on June 17, 2010. He is survived by his four sons. His eldest son Naveed Hussain Joona is a celebrated Tabla player of Pakistan and won the first prize in Tabla in the All Pakistan Tabla Sangat 2009. The Sangat was organized by Ustad Altaf Hussain Khan Tafoo who was the judge in this Sangat competition. Ustad Younas Khan taught Tabla to young musicians of Lahore. He took Zain Syed of Berkeley California under his tutelage in 2003. This video is Zain Syed's homage to his master. ["Tabla", "Drum", "Percussion"] ["low quality", "noisy", "mono", "groovy tabla percussion"] 4 mOmYcOBqhwo 4466
Tabla - Gurdain and Harkiret Dhere Dhere Riyaaz... The low quality recording features groovy wooden percussion. The recording is in mono, noisy and it sounds boomy. 2007-07-14T16:36:03Z Chakardar Gurdain and Harkiret, students of Ustad Harkirat Singh (Chakardar) practicing Dhere Dhere... Gurdain is now a student of Pandit Shankar Ghosh. Copyright © Chakardar 2007 ["Tabla", "Drum", "Percussion"] ["low quality", "noisy", "mono", "groovy wooden percussions", "boomy"] 4 tyAXjOihm6g 5081

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;