musiccaps_details (view)
2 rows where musiccaps_aspects contains "low quality", musiccaps_aspects contains "punchy kick", musiccaps_names contains "Hip hop music" and musiccaps_names contains "Rhythm and blues"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Edo Maajka Feat Alejuandro Buendija - Boing | The low quality recording features a hip hop song that consists of flat male vocals, alongside background male ad libs, rapping over boomy bass, punchy kick, slap snare, shimmering hi hats, tinny percussive elements and weird, funny and repetitive percussion. It sounds groovy and boomy, but also muddy and poorly mixed. | 2009-03-24T12:32:06Z | interist89 | Edo Maajka Feat Alejuandro Buendija - Boing | ["Music", "Rhythm and blues", "Hip hop music"] | ["low quality", "hip hop", "reverberant vocal chant", "boomy bass", "punchy kick", "slap snare", "flat male vocal", "shimmering hi hats", "tinny percussive elements", "weird funny repetitive percussion", "groovy", "background male ad libs", "poor mix", "boomy", "muddy"] | 4 | GOujNXEtDmg | 1716 | |
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;