musiccaps_details (view)
2 rows where musiccaps_aspects contains "keyboard harmony", musiccaps_aspects contains "male singer" and musiccaps_names contains "Salsa music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- keyboard harmony · 2 ✖
- male singer · 2 ✖
- animated piano 1
- bouncy 1
- brass band 1
- brass instruments 1
- bright trumpet 1
- buoyant 1
- congas 1
- couples dancing 1
- dance music 1
- emotional 1
- energetic 1
- enthusiastic 1
- enthusiastic drumming 1
- fast tempo 1
- groovy bass line 1
- groovy bass lines 1
- keyboard accompaniment 1
- latin dance music 1
- latin folk 1
- latin folk music 1
- latin music 1
- latin percussions 1
- latin pop 1
- latin romantic hits 1
- lively piano 1
- love songs 1
- medium tempo 1
- mysterious 1
- passionate 1
- passionate song 1
- poor audio quality 1
- romantic 1
- salsa 1
- spanish guitar 1
- spirited singing 1
- trumpets playing 1
- upbeat 1
- various percussion hits 1
- vibrant 1
- vigorous 1
- world music 1
- youthful 1
musiccaps_names (array) 4 ✖
- Music 2
- Salsa music · 2 ✖
- Middle Eastern music 1
- Music of Latin America 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SALSA CLASICA ROMANTICA MIX RONNY MUSIC | A male singer sings this Latin melody. The song is medium tempo with a groovy Latin percussive rhythm, keyboard accompaniment, brass band harmony and a groovy bass line. The song is romantic and emotional. The song is a salsa dance hit, but has poor audio quality issues.. | 2011-09-30T01:08:54Z | ronnymusic01 | BY DJ RONNY MUSIC | ["Music", "Middle Eastern music", "Salsa music"] | ["salsa", "latin folk music", "male singer", "spirited singing", "emotional", "couples dancing", "passionate song", "mysterious", "latin percussions", "trumpets playing", "medium tempo", "various percussion hits", "keyboard harmony", "romantic", "love songs", "latin romantic hits", "keyboard accompaniment", "poor audio quality", "passionate", "groovy bass line"] | 1 | DKflAAykh6A | 1464 | |
Toño Rosario-El Hot Dog | A male vocalist sings this lively Latino song. The tempo is fast with an animated piano accompaniment, bright trumpets, energetic and rhythmic drumming, groovy bass and keyboard. The song is energetic, lively, buoyant, bouncy, vibrant and vivacious with a dance groove. This song is Latin Pop. | 2011-09-18T02:16:01Z | TheBombers27 | ["Music", "Music of Latin America", "Salsa music"] | ["male singer", "fast tempo", "brass band", "brass instruments", "vibrant", "animated piano", "youthful", "buoyant", "bouncy", "enthusiastic", "energetic", "vigorous", "latin music", "bright trumpet", "groovy bass lines", "keyboard harmony", "enthusiastic drumming", "spanish guitar", "upbeat", "latin pop", "latin dance music", "latin folk", "lively piano", "world music", "congas", "dance music", "latin pop"] | 7 | vMU7ZKY2Eso | 5174 |
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;