musiccaps_details (view)
2 rows where musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "regional mexican"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- flat male vocal · 2 ✖
- low quality 2
- passionate · 2 ✖
- regional mexican · 2 ✖
- accordion chords 1
- accordion melody 1
- emotiona 1
- emotional 1
- groovy bass 1
- groovy trombone 1
- happy 1
- mono 1
- noisy 1
- playback 1
- shimmering shakers 1
- short brass melody 1
- wooden percussive elements 1
musiccaps_names (array) 3 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Julio Chaidez Hombre de Negocios | The low quality recording features an accordion melody played over regional Mexican playback that consists of accordion chords, groovy bass and flat male vocal singing over it. The recording is in mono, noisy and it sounds emotional and passionate. | 2009-05-27T05:57:03Z | jgg171990 | Tono de Sib | ["Accordion"] | ["regional mexican", "low quality", "mono", "noisy", "playback", "groovy bass", "accordion chords", "flat male vocal", "accordion melody", "passionate", "emotiona"] | 4 | FLJPxFCPeDY | 1638 | |
Banda San miguel " volvere" | The low quality recording features a regional Mexican song that consists of a flat male vocal singing over groovy trombone, shimmering shakers, short brass melody and wooden percussive elements. It sounds emotional, passionate and happy. | 2009-04-07T03:20:06Z | HEAD SHOOT | ["Music", "Music of Latin America"] | ["low quality", "short brass melody", "groovy trombone", "shimmering shakers", "regional mexican", "wooden percussive elements", "happy", "emotional", "passionate", "flat male vocal"] | 4 | LYO7_GxyaZc | 2197 |
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;