musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "electric guitar solo melody", musiccaps_aspects contains "energetic" and musiccaps_aspects contains "rock"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 23 ✖
- electric guitar solo melody · 2 ✖
- energetic · 2 ✖
- rock · 2 ✖
- addictive 1
- crowd noises 1
- electric guitar power chords 1
- emotional 1
- energetic crash cymbal 1
- energetic cymbals 1
- flanger effect 1
- groovy bass guitar 1
- instrumental 1
- live performance 1
- low quality 1
- mellow synth pad 1
- muffled kick hits 1
- muffled snare hits 1
- noisy 1
- passionate male vocal 1
- powerful 1
- powerful bass guitar 1
- soft 1
- straight piano chords 1
musiccaps_names (array) 7 ✖
- Music 2
- Background music 1
- Heavy metal 1
- Progressive rock 1
- Roll 1
- Singing 1
- Theme music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
MONSTER - PALLAS - OFFICIAL VIDEO | The Rock song instrumental features a mellow synth pad with flanger effect on, and straight piano chords playing in the beginning. In the second part of the loop, there is an electric guitar solo melody layered with synth pad melody and electric guitar power chords layered with powerful bass guitar and energetic crash cymbal. It sounds energetic and powerful, even though it starts softly. | 2011-07-21T06:36:47Z | PallasOfficial | The Official Video for "Monster" taken from 2011's "XXV" by Scottish progressive rock group Pallas. This is the bands first video since 1984's "Arrive Alive" Pallas are due to play at this weekends High Voltage Festival Sunday 24th July 2011 at 13:30 on the prog stage, don't miss it!! http://www.pallasxxv.com | ["Background music", "Theme music", "Heavy metal", "Music", "Progressive rock"] | ["rock", "energetic", "electric guitar solo melody", "electric guitar power chords", "instrumental", "flanger effect", "mellow synth pad", "straight piano chords", "energetic crash cymbal", "powerful bass guitar", "soft", "powerful"] | 4 | LadgIxZu8Oc | 2203 | |
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 |
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;