musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "medium fast tempo" and musiccaps_names contains "Jazz"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- medium fast tempo · 2 ✖
- adrenaline rush 1
- arena 1
- bass guitar solo 1
- crowds cheering 1
- electric guitar 1
- ending song 1
- energetic 1
- excitement in the air 1
- exciting 1
- first love 1
- guitar accompaniment 1
- infectious drumming 1
- keyboard harmony 1
- latin percussions 1
- latin pop hits 1
- live audience 1
- live in concert 1
- love song 1
- male singer 1
- male vocalist 1
- mellow 1
- ost 1
- passionate 1
- poor audio quality 1
- pop 1
- retro latin hits 1
- romantic 1
- saxophone solo 1
- sentimental 1
- soft rock 1
- steady bass lines 1
- strong drumming rhythm 1
- tender 1
- violin harmony soft 1
- you’ve got mail 1
musiccaps_names (array) 3 ✖
- Jazz · 2 ✖
- Music 2
- Rhythm and blues 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Los Autenticos Decadentes - Veni Raquel (Vivo Pepsi Music 2010) HD | A male singer sings this exciting Latin dance melody. The tempo is medium fast with a saxophone solo, percussive bass line, guitar accompaniment, latin percussion, steady drumming rhythm, and cymbal crashes. The song is exciting with the crowds going crazy. The audio quality is poor. | 2010-11-03T06:42:47Z | popartdiscosvivo | ARTISTA: LOS AUTENTICOS DECADENTES TEMA: VENI RAQUEL EN VIVO EN EL PEPSI MUSIC 2010 - COSTANERA SUR, BUENOS AIRES, ARGENTINA - 23/10/10 | ["Jazz", "Music"] | ["live audience", "saxophone solo", "bass guitar solo", "arena", "excitement in the air", "latin percussions", "strong drumming rhythm", "guitar accompaniment", "latin pop hits", "retro latin hits", "crowds cheering", "poor audio quality", "live in concert", "exciting", "energetic", "passionate", "adrenaline rush", "medium fast tempo", "male singer"] | 1 | 244y56-vLWE | 328 | |
You've got mail ending - Music: Forever J | A male vocalist sings this romantic song. The tempo is medium fast with keyboard harmony, infectious drumming, steady bass lines and electronic guitar. The song is simple, mellow, tender, sentimental, emotional and mellow. This is a Romantic Soft Rock. | 2007-02-17T09:45:14Z | john kouk | Sweet movie, sweet actors, sweet song... | ["Jazz", "Music", "Rhythm and blues"] | ["male vocalist", "medium fast tempo", "infectious drumming", "sentimental", "mellow", "tender", "love song", "first love", "pop", "ost", "you’ve got mail", "ending song", "keyboard harmony", "steady bass lines", "violin harmony soft", "mellow", "romantic", "soft rock", "electric guitar"] | 7 | 6PWiDlWmPs0 | 751 |
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;