musiccaps_details (view)
2 rows where musiccaps_aspects contains "complex harmony" and musiccaps_aspects contains "jazz" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- complex harmony · 2 ✖
- groovy bass line 2
- jazz · 2 ✖
- active 1
- ambient 1
- ambient music 1
- amplified guitar harmony 1
- atmospheric 1
- blues 1
- call and response 1
- contemporary jazz 1
- emotional 1
- empahtic 1
- energetic 1
- improvisation 1
- informal 1
- instrumental 1
- irregular beats 1
- lively 1
- love song 1
- male singer 1
- medium tempo 1
- pleasant 1
- polished 1
- polyrhythms 1
- proposal song 1
- r&b 1
- rim shot 1
- romantic 1
- romantic piano 1
- saxophone harmony 1
- sentimental 1
- slow tempo 1
- smooth 1
- solos 1
- soul 1
- spirited 1
- steady drumming 1
- syncopated 1
- syncopation 1
- wedding song 1
musiccaps_names (array) 4 ✖
- Music 1
- Percussion 1
- Wedding music 1
- Wood block 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
2013 Wedding Song (You Are) Derek Rusel | A male vocalist sings this soft love song. The tempo is slow with a romantic piano accompaniment, groovy bass line, steady drumming and ambient saxophone harmony. The song is a romantic, emotional, mellow, sentimental, proposal or wedding song. This song is a R&B/Soul song. | 2011-01-14T10:13:18Z | Vent Music | ["Music", "Wedding music"] | ["male singer", "slow tempo", "romantic piano", "ambient music", "saxophone harmony", "steady drumming", "groovy bass line", "r&b", "soul", "blues", "jazz", "complex harmony", "syncopated", "pleasant", "romantic", "emotional", "sentimental", "love song", "wedding song", "proposal song"] | 7 | 07xGXxIHOL4 | 125 | ||
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 |
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;