musiccaps_details (view)
2 rows where musiccaps_aspects contains "claps", musiccaps_aspects contains "exciting" and musiccaps_aspects contains "synth lead melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- claps · 2 ✖
- energetic 2
- exciting · 2 ✖
- low quality 2
- punchy kick 2
- shimmering hi hats 2
- synth lead melody · 2 ✖
- addictive 1
- boomy 808 bass 1
- hip hop 1
- passionate female vocal 1
- r&b 1
- simple synth bass 1
- siren sound effect 1
- wide exhale sounds 1
- wide repetitive female vocals 1
- wide reverberant flat male vocal 1
musiccaps_names (array) 5 ✖
- Hip hop music 2
- Music 2
- Pop music 1
- Rapping 1
- Rhythm and blues 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Roy Jones Jr - I Smoke I Drank | The low quality recording features a hip hop song that consists of a wide reverberant flat male vocal rapping over synth lead melody, sire sound effects, punchy kick, boomy 808 bass, claps and shimmering hi hats. It sounds exciting, energetic and addictive - like something you would hear in clubs. | 2008-10-03T14:48:46Z | Body Head Entertainment Films | Roy Jones Jr, Youngbloods and Body Head Bangerz | ["Music", "Rapping", "Hip hop music"] | ["low quality", "hip hop", "synth lead melody", "siren sound effect", "punchy kick", "boomy 808 bass", "claps", "shimmering hi hats", "wide reverberant flat male vocal", "energetic", "exciting", "addictive"] | 4 | RmDfwz0OG8E | 2723 | |
Anthony Hall - Breathe (New R&B Song 2010) | The low quality recording features a R&B song that consists of a passionate female vocal, alongside wide exhale sounds and wide repetitive female vocals, singing over claps, punchy kick, shimmering hi hats, synth lead melody and simple synth bass. It sounds energetic and exciting. | 2010-01-09T17:09:41Z | Janniiex3 | Hit me up on Facebook: Jannie NiCheer Introducing a hot new R&B-Artist: Anthony Hall :) ! enjoy the brandnew Single and leave a comment or rate :) thank you ;) almost daily new music :) | ["Music", "Pop music", "Rhythm and blues", "Hip hop music"] | ["low quality", "r&b", "synth lead melody", "wide exhale sounds", "passionate female vocal", "wide repetitive female vocals", "claps", "punchy kick", "shimmering hi hats", "simple synth bass", "energetic", "exciting"] | 4 | pELIBvAnbkY | 4692 |
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;