musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "gospel", musiccaps_names contains "Independent music" and "youtube_published" is on date 2013-10-05
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 |
---|---|---|---|---|---|---|---|---|---|---|
Phil Laeger — Let Your Glory Shine (Lyric Video) | This is a Christian gospel music piece. There is a male vocalist singing melodically in the lead. The tune is being played by the acoustic guitar and the piano while the bass guitar is following with the root notes. The rhythm is played with brushes on the acoustic drums. The atmosphere is mellow. This piece could be playing in the background at Christian religious events. | 2013-10-05T08:13:57Z | Phil Laeger | Lyric video for "Let Your Glory Shine", from the album Return. Lyrics below: All these dreams I believe You have placed inside of me Even what's good can be abused All this time I believed You'd make something great of me Seems my focus shifted Now I want You to know All I want is for You to be lifted high Be lifted high Hide me behind Your cross, Lord I want You to be seen and lifted high Hide me now and let Your glory shine Shine brighter Hide me now and let Your glory shine So much praise of mine is so pretentious Take my quote unquote good intentions Take all I say that I believe Make it real, make it so unquestionable Make Your mark on my life so un-second-guess-able Like those hands and feet Scarred by love for eternity Oh, Love, make Your mark in me Hide me behind Your cross, Lord I want You to be seen and lifted high Hide me now and let Your glory shine Shine brighter Hide me now and let Your glory shine Author of my faith Lord, let Your glory increase And as Your story unfolds in me I know I am but one thought You have conceived Just one word on the pages of Your history Hide me behind Your cross, Lord I want You to be seen and lifted high Hide me now and let Your glory shine Shine brighter Hide me now and let Your glory shine ------------------------ words & music by Phil Laeger © 2013 Weathered Music www.phillaeger.com | ["Music", "Independent music"] | ["gospel", "christian", "male vocal", "melodic singing", "acoustic guitar", "bass guitar", "piano", "acoustic drums", "mellow", "religious"] | 9 | APSbmhJam74 | 1112 |
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;