musiccaps_details (view)
2 rows where musiccaps_names contains "Music of Bollywood" and musiccaps_names contains "Traditional music" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
musiccaps_names (array) 4 ✖
- Music 2
- Music of Bollywood · 2 ✖
- Traditional music · 2 ✖
- Middle Eastern music 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Malay Traditional Dance to the tune of Thai Folk Music | Sounds like happy instrumental karaoke music featuring synthesized horns and a simple chord progression. There is a mallet percussion instrument playing rolls and following a pentatonic melody. Drums playing a simple beat. | 2010-10-27T07:04:15Z | SRetas | This dance was performed by secondary school students at the atrium of Causeway Point Shopping Centre in Singapore. Actual performance was with the traditional Malay music, but the sound quality recorded was poor due to noise interference and outside open space. This video is our editted version of that performance to the tune of the lively hit of Thai Folk Music. If you happen to know the title of this happy song and the singers, please do let us know. Thanks! | ["Traditional music", "Music", "Music of Bollywood"] | ["karaoke", "synthesized horns", "pentatonic melody", "mallet percussion", "rolls", "instrumental", "happy", "simple chord progression", "simple beat"] | 8 | GbjtSTTEFK4 | 1738 | |
Irish traditional music : "Altan" [ with Frankie Kennedy ] play a medley | This clip features a melody played by violins and flutes. This is a low quality recording. There is no percussion in this song. Hand claps are played on every count. This is a folk song which has a happy mood. There is no voice in this song. This song can be used in a movie scene where somebody enters a castle to meet medieval royalty. | 2014-06-17T20:58:48Z | DOUGLAS HADDEN | "Altan" play a set of "highlands" and reels. The reels are "The Monaghan Twig" and the Scottish reel "The High Road To Linton". | ["Traditional music", "Music", "Middle Eastern music", "Music of Bollywood"] | ["low quality recording", "hand claps", "violins", "flutes", "no percussion", "no voices", "moderate tempo", "folk song", "happy feel"] | 0 | a2Wuroc8DQU | 3513 |
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;