musiccaps_details (view)
2 rows where musiccaps_aspects contains "echoing brass melody", musiccaps_aspects contains "punchy kick" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- echoing brass melody · 2 ✖
- low quality 2
- punchy kick · 2 ✖
- addictive 1
- bouncy wooden percussions 1
- brass melody 1
- claps 1
- commercial music 1
- energetic 1
- fun 1
- funny processed male vocal 1
- groovy bass 1
- happy 1
- harmonizing female vocal 1
- offbeat wide electric guitar chords 1
- passionate male vocal 1
- pop 1
- punchy snare 1
- reggae 1
- wooden percussions 1
musiccaps_names (array) 4 ✖
- Music · 2 ✖
- Middle Eastern music 1
- Reggae 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Nivine Nasr - Yo2bosh - Video Clip | The low quality recording features a commercial music that consists of a funny processed male vocal, after which there is a harmonizing female vocal singing over punchy kick, brass melody, wooden percussion and echoing brass melody. It sounds addictive - like every commercial music should sound. | 2010-04-20T13:18:50Z | ArmVisions | Nivine Nasr Yo2bosh نيفين نصر يؤبش | ["Music", "Middle Eastern music", "Speech"] | ["low quality", "pop", "funny processed male vocal", "brass melody", "punchy kick", "wooden percussions", "echoing brass melody", "harmonizing female vocal", "addictive", "commercial music"] | 4 | 3QqVP0odOw4 | 467 | |
Pinoy Reggae | The low quality recording features a reggae song that consists of passionate male vocal singing over offbeat, widely spread guitar chords, groovy bass, punchy kick hits, punchy snare hits layered with claps, bouncy wooden percussions and echoing brass melody. It gives off happy and fun vibes - as every reggae song should. | 2013-09-18T04:27:38Z | j baunsit | Basilyo,Brownman Revival,The Youth,The Weeddz,Enchi | ["Music", "Reggae"] | ["low quality", "reggae", "passionate male vocal", "offbeat wide electric guitar chords", "groovy bass", "punchy kick", "punchy snare", "claps", "bouncy wooden percussions", "echoing brass melody", "energetic", "happy", "fun"] | 4 | v1EDTMRmJlY | 5147 |
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;