musiccaps_details (view)
2 rows where musiccaps_aspects contains "dance groove", musiccaps_aspects contains "keyboard harmony" and musiccaps_aspects contains "rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 47 ✖
- dance groove · 2 ✖
- fast tempo 2
- keyboard harmony · 2 ✖
- rock · 2 ✖
- acoustic guitar 1
- ambient 1
- amplified instruments 1
- blues 1
- boisterous 1
- complex chords 1
- complex harmony 1
- cymbal rides 1
- cymbals 1
- electric guitar 1
- electrifying 1
- energetic 1
- enthusiastic 1
- funk/soul 1
- groovy bass lines 1
- hard rock 1
- heavy metal 1
- improvisation 1
- infectious drum grooves 1
- instrumental 1
- intense electric guitar lead 1
- lively 1
- lively spirited 1
- loud 1
- male singer 1
- metal 1
- peppy 1
- perky 1
- piano accompaniment 1
- pop rock 1
- pulsating 1
- rhythmic 1
- rhythmic counter play 1
- slick drumming 1
- sonic power 1
- soothing 1
- soul 1
- syncopated bass lines 1
- trumpets 1
- upbeat 1
- vigorous drumming 1
- vivacious 1
- youthful 1
musiccaps_names (array) 6 ✖
- Music 2
- Grunge 1
- Progressive rock 1
- Rock music 1
- Soul music 1
- Swing music 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 | |
Forgotten Suns - Walk On | A male vocalist sings this enthusiastic Rock. The tempo is fast and upbeat with a vigorous electric guitar lead and harmony, hard hitting drums and amplified keyboard. The music is an energetic, boisterous, youthful, enthusiastic, engaging, pulsating and electrifying Hard Rock. | 2006-12-13T08:02:40Z | tyepennington | Footage taken from a gig at The Mandarin Club on 5th August 2006. | ["Music", "Rock music", "Progressive rock", "Grunge"] | ["male singer", "fast tempo", "rock", "hard rock", "sonic power", "cymbals", "youthful", "pulsating", "electrifying", "enthusiastic", "amplified instruments", "vigorous drumming", "intense electric guitar lead", "keyboard harmony", "upbeat", "energetic", "loud", "boisterous", "enthusiastic", "metal", "heavy metal", "pop rock", "dance groove"] | 7 | J9ZlahUawkg | 1975 |
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;