musiccaps_details (view)
2 rows where musiccaps_aspects contains "shimmering shakers" and musiccaps_aspects contains "wooden percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- low quality 2
- shimmering shakers · 2 ✖
- wooden percussion · 2 ✖
- 4 on the floor kick pattern 1
- addictive 1
- dark arpeggiated bells 1
- emotional 1
- flat male lead vocal 1
- fun 1
- groovy bass 1
- groovy piano melody 1
- happy 1
- harmonizing background vocals 1
- male vocal 1
- passionate 1
- salsa 1
- shimmering chime bells 1
- staccato background vocals 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
salsa cubana musica cubana inoel regeaton | The low quality recording features a salsa song that consists of a passionate male vocal singing over shimmering chime bells, wooden percussion, shimmering shakers and groovy piano melody. It sounds passionate, emotional and addictive. | 2008-08-02T01:08:58Z | InoelQuiros | New song by Inoel Quiros for the "Pura Salsa Na Ma" CD. Visit Inoel on MySpace @ www.myspace.com/inoelquiros. | ["Music of Africa", "Music", "Salsa music"] | ["low quality", "salsa", "groovy piano melody", "shimmering chime bells", "wooden percussion", "shimmering shakers", "passionate", "male vocal", "passionate", "emotional", "addictive"] | 4 | bTlp5Qr99RY | 3628 | |
~Lord of the Rings Parody~ ~Truth or Dare~ | The low quality recording features a flat male lead vocal, alongside harmonizing background vocals, singing over, staccato background vocals, groovy bass, wooden percussion, shimmering shakers and "4 on the floor" kick pattern. At the very end of the loop, there is a dark arpeggiated bell melody. Overall, it sounds happy and fun. | 2006-10-18T00:36:05Z | Jacinta12 | Parody. I mixed it but i DID NOT make the video. | ["Music", "Reggae"] | ["low quality", "harmonizing background vocals", "staccato background vocals", "groovy bass", "wooden percussion", "flat male lead vocal", "shimmering shakers", "4 on the floor kick pattern", "dark arpeggiated bells", "happy", "fun"] | 4 | vNZ3JS1LjDc | 5177 |
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;