musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "energetic" and musiccaps_aspects contains "jazz"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- energetic · 2 ✖
- jazz · 2 ✖
- active 1
- ambient 1
- amplified guitar harmony 1
- atmospheric 1
- call and response 1
- camera shuttering sound effect 1
- complex harmony 1
- contemporary jazz 1
- cool saxophone solo melody 1
- easygoing 1
- easygoing electric guitar chords 1
- empahtic 1
- energetic drums 1
- groovy bass 1
- groovy bass line 1
- improvisation 1
- informal 1
- instrumental 1
- irregular beats 1
- lively 1
- low quality 1
- medium tempo 1
- polished 1
- polyrhythms 1
- rim shot 1
- smooth 1
- solos 1
- spirited 1
- syncopation 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mimi Jones Band Live @ Smalls: Fast Lane | This music is a Jazz instrumental. The tempo is medium with a groovy bass one, smooth harmony on acoustic guitar and rim shots.The music is smooth, lively, informal, chill, ambient and atmospheric with the sound of musicians talking to each other. | 2010-10-01T16:24:53Z | Mimi Jones | Mimi Jones, bass; Sean Harkness, guitar; Miki Hayama, piano; Chris Eddleton, drums; Sam Newsome, soprano sax | ["Wood block", "Percussion"] | ["instrumental", "medium tempo", "jazz", "contemporary jazz", "call and response", "irregular beats", "solos", "rim shot", "complex harmony", "syncopation", "groovy bass line", "amplified guitar harmony", "polyrhythms", "ambient", "atmospheric", "improvisation", "lively", "energetic", "spirited", "active", "informal", "smooth", "polished", "empahtic"] | 7 | WK-gdfCurCg | 3085 | |
Making the Mclaren P1 - Lego StopMotion | The low quality recording features some camera shuttering sound effects and a jazz song playing in the background. The song consists of a cool saxophone solo melody over groovy bass, easygoing electric guitar chords in the left channel of the stereo image and energetic drums. It sounds easygoing and energetic at the same time. | 2015-09-03T19:10:35Z | Eton | Used 5042 Pictures! *21 FPS Thanks for Watching! Music _ Get Back(Youtube Audio library) | ["Brass instrument", "Saxophone"] | ["low quality", "camera shuttering sound effect", "jazz", "energetic drums", "groovy bass", "easygoing electric guitar chords", "cool saxophone solo melody", "easygoing", "energetic"] | 4 | eSsadT6mh7g | 3864 |
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;