musiccaps_details (view)

1 row where musiccaps_aspects contains "higher register", musiccaps_names = "["Christmas music", "Christian music", "Music", "Psychedelic rock", "Rock music", "Song"]" and musiccaps_names contains "Music"

✎ View and edit SQL

This data as json, CSV (advanced)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
New Christian rock song inspirational music 2014 2015 Young Child - Petra Resurrection Band fans An acoustic drum with a lot of reverb is playing a minimalistic slow groove along with an e-bass playing long single notes. A synth hit comes in for a moment and then an e-guitar is talking over it with a melody. The male voice sings with a lot of reverb, reverb and a chorus/flanger on his voice. The whole recording is full of reverb and the voice of the singer is using a ping pong delay. This song may be playing on a lazy day at home. 2014-01-25T03:23:51Z MattNortonMusic http://www.MattNortonMusic.com.You may like Matt Norton's Music If you like bands like:Royal Tailor After Edmund, Anthem Lights, Audio Adrenaline, Bread of Stone, Daniel's Window, Echoing Angels, Everyday Sunday, Hearts of Saints, Day of Fire, Van Halen, Chicago, Journey Def Leppard, Stryper, Petra, Whitecross, White Heart, Degarmo & Key, Mylon LeFevre & Broken Heart, Petra, HB, Within Temptation, Evanescence, Circle Of Dust, Jesus Coulter, Hillsong United, Chris Tomlin, Kari Jobi, Sonicflood , Michael W. Smith, Gateway Worship, RussTaff, Keith Green, Greg X Volz, Ken Tamplin Shout, Idle Cure, Barren Cross, Bloodgood, Resurrection Band, Holy Soldier, Guardian, Leslie Phillips, Crumbacher, Fear Not, Crystavox, Jesus Culture, Matt Redman, John Schlitt, Third Day. Skillet, Royal Tailor. Echoing Green, Jeff Deyo Matt Norton's Music spans over nearly tow decades ranging in style; Classic/Modern Christian Rock/Hard Rock/Alternative Rock/ Symphonic Rock/Symphonic Mettle/ Industrial Rock/ Electronic Pop Rock/Ska/Dance/Energetic Worship/Praise And Worship. Remix, New Christian Music 2012, 2013, 2014 christian pop punk bands, christian punk bands, christian ska band, youth worship songs,. good worship songs for youth, fast worship songs for youth, good youth worship songs, praise and worship songs for you, youth group worship songs, christian rock bands 2014 popular christian rock bands, popular christian rock songs, christian rock artists, top ten christian rock bands, most popular christian songs, new christian rock songs, ["Christmas music", "Christian music", "Music", "Psychedelic rock", "Rock music", "Song"] ["christian rock", "guitars", "acoustic drums", "e-bass", "male voice singing", "higher register", "synthesizer", "slow tempo"] 6 fWwV7o4VjEQ 3954

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;