musiccaps_details (view)
2 rows where musiccaps_aspects contains "filtered male vocal", musiccaps_aspects contains "groovy" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- filtered male vocal · 2 ✖
- groovy · 2 ✖
- addictive 1
- addictive synth lead melody 1
- boomy kick 1
- chimes bells 1
- claps 1
- emotional 1
- energetic 1
- exciting 1
- flat male vocal 1
- hip hop 1
- laser synth riser 1
- laughing 1
- low quality 1
- mellow arpeggiated piano melody 1
- passionate 1
- passionate female vocal 1
- pop 1
- punchy kick 1
- punchy snare 1
- shimmering hi hats 1
- sustained strings melody 1
musiccaps_names (array) 4 ✖
- Music 2
- Dance music 1
- Hip hop music 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mali Bang Mag Mahal by CRSP (official music video) | The low quality recording features a hip hop song that consists of a mellow arpeggiated piano melody played over sustained strings melody, chime bell and filtered male vocal in the first half of the loop. In the second half the beat drops and it consists of a punchy kick and snare hits, shimmering hi hats and passionate female vocals singing over. It sounds passionate, groovy and emotional. | 2013-07-04T05:19:16Z | MrRight VEVO | Directed by : Lilcoli Tugista Singer : Still One & Loraine Composed by : Right One Arranged by : Still One & Right One Released : July 2013 | ["Music", "Tender music"] | ["low quality", "hip hop", "mellow arpeggiated piano melody", "filtered male vocal", "sustained strings melody", "chimes bells", "punchy kick", "punchy snare", "shimmering hi hats", "passionate female vocal", "passionate", "emotional", "groovy"] | 4 | jD0nqkyuHPg | 4242 | |
Pok'Chop - What You Bout (ft. Solo, Sly) (NEW BAY ORDER!! 2011) | The Pop song features a filtered male vocal, alongside flat male vocal, singing over some claps, boomy kick hits, laser synth riser and addictive synth lead melody. There are also some male laughing sounds. It sounds addictive, groovy and exciting - like something you would hear in clubs. | 2011-11-04T04:27:10Z | WeLovePokChop | Free Download: http://hulkshare.com/yjvnoy3zwhl2 | ["Music", "Dance music", "Hip hop music"] | ["pop", "addictive synth lead melody", "filtered male vocal", "flat male vocal", "claps", "boomy kick", "laser synth riser", "energetic", "laughing", "addictive", "groovy", "exciting"] | 4 | on18CWdmxn8 | 4657 |
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;