musiccaps_details (view)
3 rows where musiccaps_aspects contains "exciting" and musiccaps_aspects contains "passionate female vocal"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- exciting · 3 ✖
- passionate female vocal · 3 ✖
- low quality 2
- shimmering hi hats 2
- 4 on the floor kick pattern 1
- addictive 1
- buzzy synth lead melody 1
- claps 1
- drums solo 1
- electro 1
- energetic 1
- haunting synth lead melody 1
- mellow synth keys 1
- pop 1
- punchy kick 1
- r&b 1
- shimmering cymbals 1
- simple synth bass 1
- snare roll 1
- synth lead melody 1
- wide exhale sounds 1
- wide repetitive female vocals 1
- wide synth pad chords 1
musiccaps_names (array) 15 ✖
- Music 2
- Bass drum 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Electronic dance music 1
- Electronic music 1
- Hi-hat 1
- Hip hop music 1
- Percussion 1
- Pop music 1
- Rhythm and blues 1
- Rimshot 1
- Snare drum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
RWBY Crack | #1 | The low quality recording features a drums solo at the very beginning of the loop, after which a pop song starts playing and it consists of a passionate female vocal singing over buzzy synth lead melody. The drums solo contains snare roll and shimmering cymbals. Overall it sounds exciting. | 2014-11-24T04:20:16Z | cookies | RWBY Crack, Episode 1~ I think I should DEFINATELY do more of these XD | ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "drums solo", "snare roll", "shimmering cymbals", "pop", "passionate female vocal", "buzzy synth lead melody", "exciting"] | 4 | KqtlecvEOGw | 2125 | |
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 | |
DANCE FLOOR 2011 - VOEUX 2011 - FRED FRUHAUF | The Electro song features a passionate female vocalist singing over wide synth pad chords, mellow synth keys, shimmering hi hats, "4 on the floor" kick pattern and haunting synth lead melody. It sounds addictive and exciting. | 2010-12-31T18:06:42Z | Fred Fruhauf | Un petit Remix de l'année 2010 pour passer votre réveillon. Toute l'équipe FFZOOM, ainsi que le Studio le Clos Sevestre vous présente SES MEILLEURS VOEUX POUR L'ANNEE 2011. | ["Electronic music", "Music", "Electronic dance music"] | ["electro", "passionate female vocal", "wide synth pad chords", "mellow synth keys", "shimmering hi hats", "4 on the floor kick pattern", "haunting synth lead melody", "addictive", "exciting"] | 4 | sU08gu2zJ4c | 4953 |
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;