musiccaps_details (view)
2 rows where musiccaps_aspects contains "female vocalisation" and musiccaps_aspects contains "hard hitting drums"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- female vocalisation · 2 ✖
- hard hitting drums · 2 ✖
- acordion harmony 1
- amateur recording 1
- animated 1
- animated piano 1
- atmospheric synthesiser 1
- auto tune 1
- bass drums 1
- buoyant 1
- burgeoning tempo 1
- bustling 1
- catchy beat 1
- cello 1
- edm 1
- electronic music 1
- enthusiastic vocals 1
- fast tempo 1
- funky bass lines 1
- gig 1
- hand percussion 1
- live performance 1
- loud electric guitar feed 1
- male singer 1
- mellow piano introduction 1
- multi singer song 1
- music building up 1
- people talking 1
- piano accompaniment 1
- poor audio quality 1
- punchy 1
- shakers 1
- spirited 1
- vibrant 1
- vivacious 1
- xylophone 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
*** DJ Earworm United State of Pop 2012 *** | A male singer sings this high energy EDM. The tempo fast with the song starts with a slow female vocalisation, soft piano accompaniment and takes off to an upbeat groove. The song is groovy, youthful, buoyant, vivacious;punchy and vibrant with atmospheric synthesiser, hard hitting drumming, funky bass line, spirited electric guitar harmony along with enthusiastic vocals. The vocals are auto tuned and the use of heavy electronic instrumentation make it an ultimate EDM. | 2010-07-09T15:14:12Z | RnBxclusiiVe | ***** Comment / Rate / Subscribe ***** * I Don't own this music * | ["Music", "Zing"] | ["electronic music", "male singer", "female vocalisation", "vivacious", "catchy beat", "vibrant", "animated", "burgeoning tempo", "multi singer song", "auto tune", "punchy", "buoyant", "piano accompaniment", "hard hitting drums", "loud electric guitar feed", "mellow piano introduction", "music building up", "edm", "atmospheric synthesiser", "youthful", "spirited"] | 7 | 3tyb0cXoX2g | 516 | |
HESTER GOODMAN...HAT SONG.. | This song is an animated vocalisation. The tempo is fast with a lively piano accompaniment, accordion harmony, cello rhythm, hard hitting drums, groovy bass lines, hand percussion beats and xylophone. The music is upbeat, energetic,enthusiastic, high-spirited and vivacious. This is a live performance with ambient sounds of people talking and general bustling. The audio quality is inferior. This song is a live Pop. | 2010-10-21T17:54:37Z | spaceritual72 | ...HAT SONG.....from "you could at least smile" album launch night...by HESTER GOODMAN..available at.......www.ukuleleorchestra.com | ["Singing", "Jazz", "Music", "Musical instrument", "Rattle (instrument)", "Ukulele"] | ["female vocalisation", "fast tempo", "cello", "hand percussion", "bass drums", "xylophone", "hard hitting drums", "animated piano", "shakers", "funky bass lines", "amateur recording", "live performance", "gig", "poor audio quality", "people talking", "bustling", "acordion harmony", "enthusiastic vocals"] | 7 | qXSG2uq2tNw | 4795 |
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;