musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "groovy bass guitar", musiccaps_aspects contains "punchy snare" and musiccaps_aspects contains "wide electric guitar melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- groovy bass guitar · 4 ✖
- punchy snare · 4 ✖
- wide electric guitar melody · 4 ✖
- punchy kick 3
- emotional 2
- energetic 2
- low quality 2
- passionate 2
- passionate female vocal 2
- rock 2
- shimmering hi hats 2
- addictive 1
- aggressive tom rolls 1
- exciting 1
- live performance 1
- passionate male vocal 1
- r&b 1
- reverberant 1
- sad 1
- shimmering cymbals 1
- shimmering shakers 1
- soft kick hits 1
- soft ride cymbals 1
- soft rock 1
- wide background female vocals 1
musiccaps_names (array) 15 ✖
- Music 3
- Bass drum 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Hi-hat 1
- Percussion 1
- Rhythm and blues 1
- Rimshot 1
- Rock and roll 1
- Rock music 1
- Singing 1
- Snare drum 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 | |
ずっと好きだった | The low quality recording features a live performance of a rock song and it consists of a passionate male vocal singing over groovy bass guitar, wide electric guitar melody, shimmering hi hats, punchy kick and snare hits. It sounds energetic and exciting. | 2011-10-08T06:45:59Z | Sheik | ["Singing", "Music", "Rock music", "Rock and roll"] | ["low quality", "rock", "live performance", "passionate male vocal", "wide electric guitar melody", "groovy bass guitar", "shimmering hi hats", "punchy kick", "punchy snare", "energetic", "exciting"] | 4 | InfQUMh935c | 1941 | ||
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 | |
OSET MX-10, 24.0, Chris Northover at the 2014 Dirt Bike Show! | The low quality recording features a rock song that consists of wide electric guitar melodies, groovy bass guitar, shimmering shakers, punchy snare and kick hits, followed by aggressive tom rolls. It sounds energetic and the drums are reverberant, as they were probably recorded in a medium size drum room. | 2014-11-14T23:12:45Z | OSET Bikes | A run-down of OSET at the 2014 International Dirt Bike Show. This was the debut for the MX-10 mini motocross bike, and for the 24.0 24" concept bike. Both got lots of attention! This video shows both, and the OSET demo Team - including Chris Northover - in action. | ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "rock", "aggressive tom rolls", "wide electric guitar melody", "punchy kick", "groovy bass guitar", "shimmering shakers", "soft ride cymbals", "punchy snare", "energetic", "reverberant"] | 4 | Wu3LKQG1fwU | 3147 |
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;