musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "emotional", musiccaps_aspects contains "groovy bass guitar" and musiccaps_aspects contains "wide electric guitar melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- emotional · 3 ✖
- groovy bass guitar · 3 ✖
- wide electric guitar melody · 3 ✖
- passionate 2
- passionate female vocal 2
- punchy kick 2
- punchy snare 2
- addictive 1
- bouncy snare 1
- groovy 1
- low quality 1
- melancholic 1
- melancholic male vocal 1
- messy 1
- muddy 1
- noisy 1
- r&b 1
- rock 1
- sad 1
- shimmering cymbals 1
- shimmering hi hats 1
- soft kick hits 1
- soft rock 1
- wide background female vocals 1
musiccaps_names (array) 5 ✖
- Music 3
- Grunge 1
- Independent music 1
- Rhythm and blues 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Miley Cyrus - I hope you find it official music video | The Soft Rock song features a passionate female vocalist singing over a wide electric guitar melody, punchy snare, soft kick hits, groovy bass guitar and shimmering hi-hats. It sounds sad, emotional and passionate - like something you would listen to on a day you are feeling down. | 2010-12-25T16:59:54Z | Misslill15 | Fanmade music video. | ["Music", "Tender music"] | ["soft rock", "passionate female vocal", "wide electric guitar melody", "punchy snare", "shimmering hi hats", "soft kick hits", "groovy bass guitar", "sad", "emotional", "passionate"] | 4 | -v5hgCh3M2w | 100 | |
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 | |
Smashing Pumpkins - Whir (Whirl) | The low quality recording features a rock song that consists of melancholic male vocal singing over a wide electric guitar melody, bouncy snare, groovy bass guitar and punchy kick. The recording is noisy, muddy and messy, since the frequencies are clashing with each other - drums cymbals are inaudible. Regardless, it sounds groovy, emotional and melancholic thanks to that vocal. | 2012-04-26T21:13:42Z | xthreenightsx | Demo '92 | ["Music", "Independent music", "Grunge"] | ["low quality", "rock", "wide electric guitar melody", "melancholic male vocal", "bouncy snare", "groovy bass guitar", "noisy", "muddy", "messy", "punchy kick", "melancholic", "emotional", "groovy"] | 4 | aO0QzRPiEC4 | 3533 |
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;