musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "congas" and musiccaps_names contains "Steelpan" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- congas · 3 ✖
- keyboard accompaniment 3
- instrumental 2
- ambient 1
- bass lines 1
- bongos 1
- buoyant 1
- cajun 1
- celebratory 1
- chatter of people 1
- cheering 1
- crowd chatter 1
- dance music 1
- distorted audio 1
- drums 1
- electric guitar harmony 1
- electric guitar riff 1
- energetic 1
- fast tempo 1
- folk pop 1
- happy 1
- harp 1
- hawaiian guitar 1
- inferior audio quality 1
- latin dance music 1
- latin folk 1
- latin music 1
- latin pop 1
- lively 1
- mellow 1
- merry 1
- muddled audio 1
- muffled music 1
- muffled sounds 1
- people talking 1
- percussion 1
- pleasant melody 1
- regional pop 1
- soft 1
- spirited 1
- steady bass lines 1
- string instrument harmony 1
- ukele 1
- vocalisation 1
- wind instrument harmony 1
musiccaps_names (array) 3 ✖
- Music 3
- Steelpan · 3 ✖
- Musical instrument 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 | |
Eddie Santiago Live - Mia | This song is a spirited Latin instrumental. The song is fast tempo with distorted keyboard harmony, electric guitar and percussion with some vocalisation. The song quality is inferior but the vibe of the song is upbeat, peppy, happy, celebratory, energetic with the sound of chatter in the background. This song is Latin pop. | 2008-03-24T14:32:02Z | Fernando Escobar | Eddie Santiago Live - Mia | ["Music", "Steelpan"] | ["congas", "muffled sounds", "keyboard accompaniment", "crowd chatter", "cheering", "percussion", "fast tempo", "electric guitar riff", "inferior audio quality", "vocalisation", "energetic", "happy", "merry", "buoyant", "latin music", "latin folk", "latin pop", "latin dance music", "celebratory"] | 7 | QVpsAY9oR_4 | 2624 | |
demo kisanola | This song is an instrumental. The tempo is medium fast with enthusiastic drumming, congas and canon rhythm,electronic guitar harmony, keyboard accompaniment and a wind instrument playing a melodious harmony. There is the sound of chattering in the background. The audio is of inferior quality and muddled. The song is energetic, spirited and melodic with a catchy dance groove. | 2007-11-17T14:44:37Z | llawal41 | african men dancing like men, not women | ["Music", "Steelpan"] | ["instrumental", "distorted audio", "drums", "dance music", "wind instrument harmony", "congas", "electric guitar harmony", "keyboard accompaniment", "cajun", "lively", "spirited", "dance music", "muddled audio", "chatter of people"] | 7 | rTBQmP6Vt0g | 4878 |
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;