musiccaps_details (view)
2 rows where musiccaps_aspects contains "exciting", musiccaps_aspects contains "punchy kick" and musiccaps_names contains "Rhythm and blues"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- claps 2
- exciting · 2 ✖
- low quality 2
- punchy kick · 2 ✖
- shimmering hi hats 2
- buzzy synth bass 1
- digital 1
- electro 1
- energetic 1
- passionate female vocal 1
- r&b 1
- simple synth bass 1
- synth lead melody 1
- wide exhale sounds 1
- wide repetitive female vocals 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;