musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "piano accompaniment" and musiccaps_aspects contains "vivacious" sorted by musiccaps_rowid
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 48 ✖
- piano accompaniment · 2 ✖
- vivacious · 2 ✖
- acoustic guitar 1
- ambient 1
- animated 1
- atmospheric synthesiser 1
- auto tune 1
- blues 1
- buoyant 1
- burgeoning tempo 1
- catchy beat 1
- complex chords 1
- complex harmony 1
- cymbal rides 1
- dance groove 1
- edm 1
- electric guitar 1
- electronic music 1
- fast tempo 1
- female vocalisation 1
- funk/soul 1
- groovy bass lines 1
- hard hitting drums 1
- improvisation 1
- infectious drum grooves 1
- instrumental 1
- keyboard harmony 1
- lively 1
- lively spirited 1
- loud electric guitar feed 1
- male singer 1
- mellow piano introduction 1
- multi singer song 1
- music building up 1
- peppy 1
- perky 1
- punchy 1
- rhythmic 1
- rhythmic counter play 1
- rock 1
- slick drumming 1
- soothing 1
- soul 1
- spirited 1
- syncopated bass lines 1
- trumpets 1
- vibrant 1
- youthful 1
musiccaps_names (array) 4 ✖
- Music 2
- Soul music 1
- Swing music 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
HONK - Hesitation | This music is instrumental. The tempo is fast with trumpet harmony, keyboard accompaniment, infectious drumming, syncopated, funky bass lines, lively piano and electric and acoustic guitar riffs. The music is upbeat, groovy, complex harmony, ambient, soulful and funky. This song is Funk Soul; | 2010-05-19T16:30:27Z | 123c123c123c | Honk - Honk LP :: 1974 | ["Swing music", "Music", "Soul music"] | ["instrumental", "fast tempo", "rock", "blues", "trumpets", "lively spirited", "complex harmony", "complex chords", "cymbal rides", "dance groove", "peppy", "perky", "vivacious", "keyboard harmony", "piano accompaniment", "groovy bass lines", "acoustic guitar", "electric guitar", "slick drumming", "trumpets", "lively", "ambient", "soothing", "improvisation", "soul", "funk/soul", "rhythmic", "dance groove", "syncopated bass lines", "rhythmic counter play", "infectious drum grooves"] | 7 | 2sIfE3KOi5s | 410 | |
*** 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 |
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;