musiccaps_details (view)
1 row where musiccaps_aspects contains "low quality", musiccaps_aspects contains "pitch bend wooden percussions" and musiccaps_aspects contains "traditional"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;