musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "mellow" and musiccaps_aspects contains "punchy kick" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- addictive 2
- energetic 2
- mellow · 2 ✖
- punchy kick · 2 ✖
- rock 2
- addictive synth keys melody 1
- cover 1
- electric guitar melody 1
- groovy bass 1
- groovy bass guitar 1
- low quality 1
- passionate female vocal 1
- punchy snare 1
- shimmering cymbals 1
- shimmering hi hats 1
- soft 1
- soft male vocal 1
- wide electric guitar melody 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Maps (UCSC Version) - Yeah Yeah Yeahs | The cover of a rock song consists of soft male vocal singing over shimmering cymbals, punchy snare and kick hits, groovy bass guitar, addictive synth keys melody and electric guitar melody. It sounds energetic, but yet mellow and addictive - thanks to that cadence. | 2006-08-06T04:59:47Z | Michael Tucker | "Fantastically Creepy" is one way it has been described. How would you describe it? Video for "Maps" by the Yeah Yeah Yeahs. Go UCSC (University of California at Santa Cruz). Check out more of our movies at http://www.finite-films.com | ["Independent music"] | ["cover", "rock", "soft male vocal", "shimmering cymbals", "punchy snare", "punchy kick", "groovy bass guitar", "addictive synth keys melody", "electric guitar melody", "energetic", "addictive", "mellow"] | 4 | nZOgoVEud_w | 4553 | |
Silent Hill Shattered Memories - Hell Frozen Rain | The low quality recording features a rock song that consists of a passionate female vocal singing over punchy kick and snare hits, shimmering hi hats, wide electric guitar melody and groovy bass guitar. It sounds energetic and addictive in the first half of the loop, while in the second part it's mellow and softer. | 2009-12-17T08:21:09Z | Person Whatname | Artist : Akira Yamaoka Vocals: Mary Elizabeth McGlynn at 3:56, it's "THERE's one that confuses me". thanks to ares5566 for the correction. From Silent Hill Shattered Memories Soundtrack. This song plays during the credits, depends on which ending you get. AWESOME FACT : at 3:34, you can hear part of Silent Hill 1 theme :) | ["Punk rock", "Psychedelic rock", "Rock music", "Song", "Progressive rock"] | ["low quality", "rock", "passionate female vocal", "wide electric guitar melody", "groovy bass", "shimmering hi hats", "punchy kick", "punchy kick", "mellow", "energetic", "addictive", "soft"] | 4 | qrzNABqN420 | 4828 |
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;