musiccaps_details (view)
4 rows where musiccaps_aspects contains "exciting", musiccaps_aspects contains "low quality", musiccaps_author = 4 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 |
---|---|---|---|---|---|---|---|---|---|---|
TALL BOY - HAR MAR SUPERSTAR (Official Music Video) | The low quality recording features a pop song that consists of a passionate male vocal, alongside background male vocals, singing over punchy 808 bass, claps, shimmering hi hats, wide tinny percussion, repetitive synth lead melody and groovy synth keys melody. It sounds groovy, addictive and exciting - like something you would hear in a club. | 2009-09-30T18:50:07Z | HarMarSuperstar | Har Mar Superstar, Eva Mendes, Alia Shawkat, Eric Wareheim, and a bevy of intergalactic beauties get wet and sparkly. Produced and directed by Tomorrow's Brightest Minds. For more information about Har Mar -- the man & his music -- visit harmarsuperstar.com. | ["Music", "Middle Eastern music", "Rhythm and blues", "Dance music"] | ["low quality", "pop", "wide tinny percussions", "punchy 808 bass", "groovy synth keys", "passionate male vocal", "background male vocals", "repetitive synth lead melody", "groovy", "addictive", "exciting", "claps", "shimmering hi hats"] | 4 | 2SenLjPbGzU | 366 | |
Galantis No money- Bully story Roblox music vid | The low quality recording features a high pitched female vocal singing over snare roll, repetitive synth keys chords and echoing crash cymbals all impacted by filter modulation that slowly opens up. It sounds exciting and energetic. | 2016-08-31T03:10:26Z | Twopixel | Credit to the song creators | ["Funk", "Music", "Rhythm and blues"] | ["low quality", "high pitched female vocal", "snare roll", "repetitive synth keys chords", "echoing crash cymbal", "exciting", "energetic", "filter modulation"] | 4 | 5D4siJjh1j0 | 643 | |
How to make Green Fire from Borax / How to make Boric Acid/ How to make wildfire | The low quality recording features an electro song that consists of a punchy kick, buzzy synth bass, claps and shimmering hi-hats. It sounds exciting and a bit too digital - like something you would hear in old video games. | 2013-06-17T07:13:48Z | PAChemistry | "Music courtesy of Kevin MacLeod (www.smartsound.com/royalty-free-music/incompetech)" If you already have boric acid or want to use borax, skip to 4:20 In this video i show you how to make your own boric acid from borax and other common chemicals to produce a green flame when mixed with methanol | ["Ringtone", "Music", "Rhythm and blues"] | ["low quality", "electro", "claps", "punchy kick", "buzzy synth bass", "shimmering hi hats", "digital", "exciting"] | 4 | 8pl1D6oG38k | 952 | |
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;