musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "pleasant melody" and musiccaps_aspects contains "steady bass lines"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- pleasant melody · 2 ✖
- steady bass lines · 2 ✖
- ambient 1
- bass lines 1
- bongos 1
- calm 1
- classic pop 1
- congas 1
- electric guitar harmony 1
- emotional 1
- folk pop 1
- harp 1
- hawaiian guitar 1
- insistent rhythm 1
- instrumental 1
- keyboard accompaniment 1
- keyboard harmony 1
- male vocalist 1
- medium tempo 1
- mellow 1
- muffled music 1
- people talking 1
- pop 1
- recurring 1
- regional pop 1
- sentimental 1
- soft 1
- steady drumming 1
- string instrument harmony 1
- ukele 1
- youthful 1
musiccaps_names (array) 5 ✖
- Music 2
- Musical instrument 1
- Rattle 1
- Rock music 1
- Steelpan 1
youtube_published (date) 2 ✖
- 2008-02-17 1
- 2013-05-12 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jamaica Farewell / Island In The Sun | This song is an instrumental. The tempo is slow with a keyboard harmony, steady bass lines, congas and bongo rhythm and sound of an instrument like a harp and string instrument like a ukelele or Hawaiian guitar.The music is soft, mellow, pleasant and simple with the sound of people talking in the background. This is a Regional/Folk Pop instrumental. | 2008-02-17T15:07:09Z | Steel Drum Music | Now on iTunes → click the little tab button for the link and info → → → Caribbean classics played on steel drums from Trinidad. This song is featured on the 'Steel Drum Gold' album. You can get it at: iTunes - http://bit.ly/aE3djW Amazon - http://bit.ly/cgT7rA or directly from Bob Lyons' web site: http://www.SteelDrumMusic.net Steel drums at dinner party, Stranahan House, Fort Lauderdale, 2-13-08 | ["Music", "Musical instrument", "Steelpan"] | ["instrumental", "keyboard accompaniment", "congas", "string instrument harmony", "hawaiian guitar", "ukele", "steady bass lines", "regional pop", "folk pop", "pleasant melody", "bongos", "bass lines", "harp", "people talking", "soft", "mellow", "ambient", "muffled music"] | 7 | P996TZp25PM | 2512 | |
My Love is Sweeter - Hyper Sound | A male vocalist sings this simple melody. The tempo is medium with a pleasant keyboard harmony, slick drumming, steady bass lines and an melodic electric guitar harmony. The song is a simple, insistent rhythm,recurring beat, youthful , emotional, sentimental and passionate classic Pop. | 2013-05-12T12:08:57Z | HypersoundVevo | Rock Music from the african Hollywood "Ouarzazate" https://www.facebook.com/HypersoundBand | ["Music", "Rock music", "Rattle"] | ["male vocalist", "medium tempo", "keyboard harmony", "emotional", "pop", "classic pop", "recurring", "insistent rhythm", "steady drumming", "electric guitar harmony", "steady bass lines", "pleasant melody", "calm", "emotional", "sentimental", "youthful"] | 7 | evscfdO-oSY | 3907 |
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;