musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "passionate male vocal", musiccaps_author = 4 and musiccaps_names contains "Roll"
This data as json, CSV (advanced)
Suggested facets: musiccaps_names
musiccaps_aspects (array) 28 ✖
- energetic 3
- passionate male vocal · 3 ✖
- rock 3
- addictive 2
- groovy bass guitar 2
- low quality 2
- crowd noises 1
- electric guitar solo melody 1
- electric rhythm guitar chords 1
- emotional 1
- energetic crash 1
- energetic cymbals 1
- groovy bass 1
- harmonizing background male vocal 1
- live performance 1
- mono 1
- muffled kick hits 1
- muffled snare hits 1
- noisy 1
- punchy kick hits 1
- punchy snare 1
- reverberant 1
- shimmering hi hats 1
- simple kick pattern 1
- suspenseful electric guitar melody 1
- thin snare 1
- tinny percussive elements 1
- uptempo 1
musiccaps_names (array) 4 ✖
- Music 3
- Roll · 3 ✖
- Rock and roll 2
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SPYAIR - Samurai Heart (live) ENG subs | The low quality recording features a live performance of a rock song that consists of passionate male vocal singing over electric guitar solo melody, energetic cymbals, muffled snare and kick hits and groovy bass guitar. There are also some crowd noises, singing along. It sounds energetic, emotional and addictive, thanks to that cadence. | 2014-08-25T16:54:22Z | Rrhae Reyes | Video not mine credit to the owner But the subs are mine xD IKE is so handsome here This is a gintama perf so you can see the anime dubbers here | ["Singing", "Music", "Roll"] | ["low quality", "crowd noises", "noisy", "rock", "live performance", "electric guitar solo melody", "energetic cymbals", "muffled snare hits", "muffled kick hits", "passionate male vocal", "groovy bass guitar", "energetic", "emotional", "addictive"] | 4 | P3ZPbGjHFXE | 2499 | |
The Connells - Scotty's Lament | The Rock song features a passionate male vocal, layered with harmonizing background male vocals, singing over electric rhythm guitar chords spread widely in the stereo image, thin snare, energetic crash, groovy bass, shimmering hi hats and punchy kick hits. The drums are very reverberant, which is probably the reason why they sound softer. It sounds addictive, thanks to those harmonizing vocals, and energetic overall. | 2007-11-12T22:30:12Z | streetsintherain | The video for "Scotty's Lament", made in 1987. | ["Music", "Roll", "Rock and roll"] | ["rock", "passionate male vocal", "harmonizing background male vocal", "electric rhythm guitar chords", "groovy bass", "thin snare", "energetic crash", "shimmering hi hats", "punchy kick hits", "reverberant", "addictive", "energetic"] | 4 | hKSg3zFB2dE | 4095 | |
Rock and Roll Dance in Radio Planeta 2 | The low quality recording features an uptempo rock song that consists of suspenseful electric guitar melody, punchy snare, simple kick pattern, groovy bass guitar, tinny percussive elements and passionate male vocal singing over it. The recording is in mono and it sounds energetic, groovy and like something you would dance to with your friends. | 2012-11-15T13:07:30Z | Bertjuh Chevy | ["Music", "Roll", "Rock and roll"] | ["rock", "suspenseful electric guitar melody", "punchy snare", "simple kick pattern", "groovy bass guitar", "passionate male vocal", "mono", "low quality", "energetic", "uptempo", "tinny percussive elements"] | 4 | lHlOSsnP48c | 4388 |
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;