musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "bass guitar solo" and musiccaps_aspects contains "male singer"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 37 ✖
- bass guitar solo · 2 ✖
- male singer · 2 ✖
- adrenaline rush 1
- arena 1
- bad audio quality 1
- big band 1
- crowds cheering 1
- emotional 1
- energetic 1
- excitement in the air 1
- exciting 1
- groovy 1
- guitar accompaniment 1
- guitar lead 1
- latin percussions 1
- latin pop hits 1
- live audience 1
- live in concert 1
- love song 1
- medium fast tempo 1
- medium tempo 1
- missing you 1
- noir style 1
- passionate 1
- percussion hits 1
- percussions 1
- poor audio quality 1
- retro latin hits 1
- retro pop hits 1
- rhythm guitar 1
- romantic 1
- saxophone solo 1
- story telling 1
- strong bass guitar 1
- strong drumming rhythm 1
- tambourine percussions 1
- together forever 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 | |
Mavericks - Things You Said To Me (Live In Austin) | A male singer sings this cool melody. The song is medium tempo with a groovy guitar lead and steady drumming with tambourine percussion. The song is cool and sophisticated. The audio quality is bad. | 2009-08-31T06:32:02Z | leshumphrey | ["Blues", "Singing"] | ["bass guitar solo", "male singer", "guitar lead", "retro pop hits", "noir style", "rhythm guitar", "percussion hits", "love song", "missing you", "together forever", "strong bass guitar", "percussions", "big band", "story telling", "romantic", "emotional", "groovy", "tambourine percussions", "medium tempo", "bad audio quality"] | 1 | FXVu-YwjhxM | 1646 |
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;