musiccaps_details (view)
1 row where search matches "guitar", musiccaps_aspects contains "bongos" and musiccaps_aspects contains "harp" sorted by musiccaps_author
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 18 ✖
- ambient 1
- bass lines 1
- bongos · 1 ✖
- congas 1
- folk pop 1
- harp · 1 ✖
- hawaiian guitar 1
- instrumental 1
- keyboard accompaniment 1
- mellow 1
- muffled music 1
- people talking 1
- pleasant melody 1
- regional pop 1
- soft 1
- steady bass lines 1
- string instrument harmony 1
- ukele 1
musiccaps_names (array) 3 ✖
- Music 1
- Musical instrument 1
- Steelpan 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 |
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;