musiccaps_details (view)
2 rows where musiccaps_aspects contains "cover" and musiccaps_names contains "Classical music" sorted by musiccaps_names
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
musiccaps_names (array) 6 ✖
- Classical music · 2 ✖
- Music 2
- /t/dd00004 1
- A capella 1
- Carnatic music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names ▼ | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Banana Boat Song ukulele cover with chords and lyrics - Harry Belafonte style (hopefully).wmv | The low quality recording features a cover of a song and it consists of passionate male vocals that together with the actual song's vocal, sounds harmonizing. There are simple acoustic guitar chords too. The recording is very noisy as it was probably recorded with a phone, but regardless it sounds emotional. | 2012-07-30T15:21:15Z | raffaport | Some calypso fun from a bygone age ... too piercing, man! | ["Music", "Classical music", "A capella"] | ["low quality", "cover", "harmonizing male vocals", "simple acoustic guitar chords", "emotional", "noisy", "phone recording", "passionate male vocal"] | 4 | BfMKdrK9D8M | 1272 | |
Raag Bhopali | The low quality recording features a cover of traditional folk song and it consists of reverberant, passionate female vocal singing over repetitive percussive instrument and plucked strings melody. It sounds passionate, cultural and emotional. | 2011-01-20T17:29:46Z | aradhanakarhade | Raag Bhupali tutorial for beginners - Raag Bhopali has five notes, and is thus a raag of the "audhav jaati". Follow the instructions and practice this raag. Here, it is sung in the scale of B major. The corresponding notes in B scale are B, C#, D#, F#, G# PLEASE SUBSCRIBE TO OUR NEW CHANNEL: https://www.youtube.com/channel/UCezyky1nT-IVvKAEZagViUA | ["Singing", "Carnatic music", "Music", "Classical music", "/t/dd00004"] | ["low quality", "noisy", "cover", "reverberant passionate female vocal", "traditional folk", "repetitive percussive element", "plucked strings melody", "passionate", "emotional", "cultural"] | 4 | VV-DgnPPhSo | 3006 |
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;