musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "people talking" and musiccaps_aspects contains "steady bass lines" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- people talking · 2 ✖
- steady bass lines · 2 ✖
- accordion melody 1
- acoustic guitar 1
- ambient 1
- animated music 1
- bass lines 1
- bongos 1
- cheering 1
- clapping 1
- congas 1
- crowd cheering 1
- fast tempo 1
- folk pop 1
- harp 1
- hawaiian guitar 1
- inferior audio quality 1
- instrumental 1
- keyboard accompaniment 1
- keyboard harmony 1
- live performance 1
- lively vocals 1
- male vocalist 1
- mellow 1
- muffled audio 1
- muffled music 1
- pleasant melody 1
- regional pop 1
- soft 1
- string instrument harmony 1
- ukele 1
- vigorous drumming 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Safe Sane and Single - Comedy Tap (retro) | A male vocalist sings this energetic song. The tempo is fast with accordion harmony, funky bass lines, vigorous drumming,rhythmic acoustic guitar and keyboard harmony. The audio is muffled making it difficult to hear the other elements in the song. This song is a live performance as there are sounds of clapping, cheering and people murmuring. This song is a vibrant,vivacious,bright, punchy, and energetic Pop. | 2007-10-29T08:51:30Z | FatLane | Another one from the archives. | ["Singing", "Music", "Tap"] | ["male vocalist", "fast tempo", "animated music", "clapping", "live performance", "people talking", "cheering", "accordion melody", "vigorous drumming", "keyboard harmony", "steady bass lines", "acoustic guitar", "lively vocals", "inferior audio quality", "muffled audio", "crowd cheering"] | 7 | ZgooDijn2as | 3403 | |
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;