musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_author = 4 and musiccaps_names contains "Theme music"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 20 ✖
- electric guitar power chords 1
- electric guitar solo melody 1
- emotional 1
- energetic 1
- energetic crash cymbal 1
- flanger effect 1
- fruity male vocal 1
- groovy bass 1
- instrumental 1
- low quality 1
- low toms 1
- mellow synth pad 1
- nostalgic 1
- powerful 1
- powerful bass guitar 1
- rock 1
- soft 1
- southern rock 1
- straight piano chords 1
- wide electric guitar melody 1
musiccaps_names (array) 8 ✖
- Music 2
- Theme music · 2 ✖
- Background music 1
- Dance music 1
- Heavy metal 1
- Jazz 1
- Pop music 1
- Progressive rock 1
youtube_description 2 ✖
- - 1
- 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 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
WWE NXT New Official Theme Music - Wild & Young | The low quality recording features a southern rock song that consists of a fruity male vocal singing over groovy bass guitar, low toms and wide electric guitar melody. It sounds emotional and nostalgic. | 2010-02-21T17:26:22Z | UniverseOfWWE | ["Theme music", "Jazz", "Music", "Pop music", "Dance music"] | ["low quality", "southern rock", "wide electric guitar melody", "groovy bass", "low toms", "fruity male vocal", "emotional", "nostalgic"] | 4 | 53UF6F7D284 | 629 | ||
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 |
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;