musiccaps_details (view)
2 rows where musiccaps_aspects contains "jazz" and musiccaps_aspects contains "rich"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- blues 2
- dense 2
- instrumental 2
- jazz · 2 ✖
- medium tempo 2
- rich · 2 ✖
- amplified guitar 1
- catchy riff 1
- classic acoustic string instrument 1
- clear 1
- crisp 1
- demonstration 1
- double elcetric bass 1
- edgy 1
- electric guitar 1
- electric guitar lead 1
- electric guitar lesson 1
- electric guitar solo 1
- electric guitars 1
- empahtic 1
- full bodied 1
- groovy 1
- intense 1
- intense bass 1
- learning electric 1
- loud 1
- loud feed back 1
- powerful 1
- resonating 1
- reverb 1
- rock 1
- rock and roll 1
- smooth 1
- stringed instrument 1
- tutorial 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
A First Look At The Stagg Electric Upright Bass | This music is instrumental. The tempo is medium with an intense electric upright double bass harmony. The music is dense, deep, powerful, full bodied and vibrant. | 2008-08-12T11:27:12Z | roger alcantara | The Stagg Electric Upright Bass | ["Double bass", "Pizzicato", "Bowed string instrument"] | ["instrumental", "medium tempo", "intense bass", "dense", "rich", "double elcetric bass", "classic acoustic string instrument", "jazz", "blues", "rock and roll", "intense", "full bodied"] | 7 | RJViDdqUYyo | 2692 | |
The Jim Kelley Reverb amplifier, demo by Pete Thorn | This music is an electric guitar instrumental. The tempo is medium with a smooth electric guitar lead harmony. The music is clear, emphatic, smooth, groovy, youthful, crisp, edgy and dominant. | 2013-03-03T20:58:20Z | Pete Thorn | An in-depth look at the Kelley Reverb head, built by J.S. Technologies Check out Pete Thorn's "Guitar Nerd" album at CDbaby.com and iTunes: http://www.cdbaby.com/cd/petethorn https://itunes.apple.com/us/artist/pete-thorn/id437846702 | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["instrumental", "electric guitars", "medium tempo", "demonstration", "tutorial", "learning electric", "electric guitar lesson", "clear", "loud", "powerful", "empahtic", "amplified guitar", "electric guitar", "stringed instrument", "loud feed back", "blues", "rock", "jazz", "resonating", "reverb", "youthful", "groovy", "catchy riff", "smooth", "electric guitar lead", "electric guitar solo", "dense", "rich", "crisp", "edgy"] | 7 | ouVuF-y8bog | 4664 |
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;