musiccaps_details (view)
3 rows where musiccaps_aspects contains "low quality recording" and musiccaps_names contains "Traditional music" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- low quality recording · 3 ✖
- male voice 2
- accordion 1
- double bass 1
- drum 1
- flutes 1
- folk song 1
- foreign language 1
- hand claps 1
- happy feel 1
- male backing vocals 1
- moderate tempo 1
- no percussion 1
- no voices 1
- pop song 1
- violin 1
- violins 1
musiccaps_names (array) 6 ✖
- Music 3
- Traditional music · 3 ✖
- Accordion 1
- Middle Eastern music 1
- Music of Bollywood 1
- Musical instrument 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
traditional malay music | The music starts off with male backing vocals making way for the main male singer. Throughout the music excerpt a drum rhythmic accompaniment can be heard. The quality of the recording is low and so it's not clear if other instruments take part in accompanying the singer. | 2007-08-21T08:37:53Z | bizzport | traditional malaysian music group | ["Traditional music", "Music"] | ["male voice", "male backing vocals", "drum", "low quality recording"] | 2 | nj6N7m8SeK4 | 4570 | |
Marin Doru- Ramane masa saraca | This low quality recording features a male voice singing the main melody in a foreign language. This is accompanied by percussion playing a simple beat with a Latin feel. The bass is played on a double bass. The double bass plays a groovy bassline. Flute fills are played in the background. An accordion plays melodies in harmony with the voice. This song has romantic overtones. This song can be played at the end credits of a mafia romance movie. | 2011-04-20T14:52:21Z | Beto stylle | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["low quality recording", "pop song", "male voice", "foreign language", "accordion", "double bass", "violin"] | 0 | 2bCuw7U_Rac | 387 | ||
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;