musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "mellow synth pad" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- energetic 2
- mellow synth pad · 2 ✖
- bright wide steel guitar melody 1
- claps 1
- dull 1
- electric guitar power chords 1
- electric guitar solo melody 1
- energetic crash cymbal 1
- flanger effect 1
- groovy 1
- groovy bass 1
- hip hop 1
- instrumental 1
- low quality 1
- powerful 1
- powerful bass guitar 1
- reverberant flute melody 1
- rock 1
- shimmering triangle 1
- soft 1
- soft kick 1
- straight piano chords 1
- tinny muffled percussive elements 1
- tropical 1
musiccaps_names (array) 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|
Antaeus - Kyrie (Official Music) | The low quality recording features a hip hop song that consists bright, widely spread steel guitar melody, tinny muffled percussive elements, shimmering triangle, reverberant flute melody, claps, soft kick hits, mellow synth pad and groovy bass that glues everything together. It sounds kind of dull, but groovy, energetic and tropical - thanks to those flute and guitar melodies. | 2015-02-12T11:31:28Z | A L P H A | ["Traditional music", "Music"] | ["low quality", "hip hop", "tinny muffled percussive elements", "bright wide steel guitar melody", "shimmering triangle", "reverberant flute melody", "claps", "soft kick", "groovy bass", "mellow synth pad", "dull", "energetic", "tropical", "groovy"] | 4 | HS_ikHx4LIQ | 1803 | ||
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;