musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "passionate female vocal", musiccaps_aspects contains "punchy snare" and musiccaps_aspects contains "shimmering cymbals"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 17 ✖
- addictive 2
- emotional 2
- groovy bass guitar 2
- passionate 2
- passionate female vocal · 2 ✖
- punchy snare · 2 ✖
- shimmering cymbals · 2 ✖
- claps 1
- low quality 1
- punchy kick 1
- r&b 1
- repetitive low plucked string melody 1
- soft kick hits 1
- soul/funk 1
- wide background female vocals 1
- wide electric guitar melody 1
- wide strings chords 1
musiccaps_names (array) 3 ✖
- Music 2
- Happy music 1
- 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 |
---|---|---|---|---|---|---|---|---|---|---|
Faith Evans- Mesmerized | The R&B song features a passionate female vocal, alongside wide background female vocals, singing over shimmering cymbals, punchy kick and snare hits, groovy bass guitar and wide electric guitar melody. It sounds passionate, emotional and addictive - like something you would hear in clubs a lot. | 2007-04-16T15:46:14Z | Amanda Ab | Faith evans video | ["Music", "Rhythm and blues"] | ["r&b", "wide background female vocals", "passionate female vocal", "shimmering cymbals", "punchy kick", "punchy snare", "groovy bass guitar", "wide electric guitar melody", "passionate", "emotional", "addictive"] | 4 | NC5tIv4-8fg | 2325 | |
[HD] House Season 7 Promo Music | Macy Gray - Help Me | The low quality recording features a funk/soul song that consists of a passionate female vocal singing over groovy bass guitar, wide strings chords, low repetitive plucked strings melody, punchy snare layered with claps, soft kicks and shimmering cymbals. It sounds emotional, passionate and addictive. | 2010-09-03T17:57:32Z | mercman | Music from one of the promos of seventh season of House on FOX. | ["Music", "Happy music"] | ["low quality", "soul/funk", "passionate female vocal", "groovy bass guitar", "repetitive low plucked string melody", "wide strings chords", "punchy snare", "claps", "shimmering cymbals", "soft kick hits", "emotional", "passionate", "addictive"] | 4 | tnDUwvxQU3k | 5065 |
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;