musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "passionate male vocal" and musiccaps_aspects contains "wooden percussions"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 19 ✖
- groovy bass · 2 ✖
- happy 2
- joyful 2
- passionate male vocal · 2 ✖
- wooden percussions · 2 ✖
- acoustic rhythm guitar 1
- bright brass melody 1
- chill 1
- easygoing 1
- funky electric guitar melodies 1
- guiro percussion 1
- mellow rimshots 1
- passionate 1
- passionate female vocals 1
- reggae 1
- regional mexican 1
- shimmering cymbals 1
- shimmering hi hats 1
- synth keys melody 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chango - Henry Fiol | The Regional Mexican song features a passionate male vocal singing over guiro percussion, followed by wooden percussion, shimmering cymbals, acoustic rhythm guitar in the left channel of the stereo image and bright brass melody in the right channel. It sounds joyful, happy and passionate. | 2009-09-17T01:58:57Z | Pedro Velazco | ["Music", "Music of Latin America", "Salsa music"] | ["regional mexican", "passionate male vocal", "guiro percussion", "wooden percussions", "shimmering cymbals", "bright brass melody", "groovy bass", "acoustic rhythm guitar", "passionate", "happy", "joyful"] | 4 | UJA5AWbt6HM | 2905 | ||
Bob Marley - Positive Vibration | The low quality recording features a passionate male vocal, alongside passionate female vocal in the left channel of the stereo image, singing over shimmering hi hats, which are also in the left channel, widely spread funky electric guitar chords, synth keys melody in the right channel, groovy bass, wooden percussions and mellow rimshots. It sounds happy, joyful, easygoing and chill. | 2009-05-20T09:26:13Z | Reggae Man | Live if you want to live (Rastaman vibration, yeah! Positive!) That's what we got to give! (I'n'I vibration yeah! Positive) Got to have a good vibe! (Iyaman Iration, yeah! Irie ites!) Wo-wo-ooh! (Positive vibration, yeah! Positive!) If you get down and you quarrel everyday, You're saying prayers to the devils, I say. Wo-oh-ooh! Why not help one another on the way? Make it much easier. (Just a little bit easier) Say you just can't live that negative way, If you know what I mean; Make way for the positive day, 'Cause it's news (new day) - news and days - New time (new time), and if it's a new feelin' (new feelin'), yeah! - Said it's a new sign (new sign): Oh, what a new day! Pickin' up? Are you pickin' up now? Jah love - Jah love (protect us); Jah love - Jah love (protect us); Jah love - Jah love (protect us). Rastaman vibration, yeah! (Positive!) I'n'I vibration, yeah! (Positive!) Uh-huh-huh, a yeah! Iyaman Iration, yeah! (Irie ites!) Wo-oo-oh! *Positive vibration, yeah! (Positive!) Pickin' up? Are you pickin' up now? Pickin' up? Are you pickin' up now? Pickin' up? (Jah love, Jah love -) Are you pickin' (protect us!) up now? Pickin' up? (Jah love, Jah love -) Are you pickin' (protect us!) up now? Pickin' up? (Jah love, Jah love -) Are you pickin' (protect us!) up now? Pickin' up? Are you pickin' up now? | ["Folk music", "Music"] | ["reggae", "passionate male vocal", "passionate female vocals", "funky electric guitar melodies", "synth keys melody", "wooden percussions", "groovy bass", "mellow rimshots", "shimmering hi hats", "happy", "joyful", "easygoing", "chill"] | 4 | jPOWgfA0zAo | 4251 |
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;