musiccaps_details (view)
2 rows where musiccaps_aspects contains "low quality recording", musiccaps_aspects contains "male voice" and musiccaps_names contains "Traditional music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 9 ✖
- low quality recording · 2 ✖
- male voice · 2 ✖
- accordion 1
- double bass 1
- drum 1
- foreign language 1
- male backing vocals 1
- pop song 1
- violin 1
musiccaps_names (array) 4 ✖
- Music 2
- Traditional music · 2 ✖
- Accordion 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 |
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;