musiccaps_details (view)
3 rows where musiccaps_aspects contains "motivational", musiccaps_aspects contains "poignant" and musiccaps_aspects contains "strong bass line"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Tom Dugan's Backyard bmx fun | The song is an instrumental. The song is medium tempo with a moog bass accompaniment, keyboard organ tone and a strong bass line. The song is emotional and poignant. The song is a new age pop soundtrack. | 2011-12-13T22:50:28Z | MrBMXBEAST666 | Uploaded by brycejrich on Aug 16, 2011 A session of the half built backyard at the 316 House, Austin, Texas. Tom Dugan, Cody Nutter, Joeseph Franz, Levi Brewer, Jared Allen Swafford, Danny Hickerson, Will, Mike McFrench Molineri, Jay, Cassie Nutter, Daria Nutter (the Puppy Dog) and friend. | ["Music", "Harmonic"] | ["moog bass", "keyboard accompaniment", "experimental", "experimental", "abstract", "art music", "documentary soundtrack", "instrumental music", "memdium tempo", "organ accompaniment", "strong bass line", "emotional", "melancholic", "poignant", "playful", "inspirational", "motivational", "new age", "song introduction"] | 1 | BWSJjF32tQA | 1249 | |
| You will never win if you never begin(Nick Vujicic: Life Without Limbs).wmv | The song is an instrumental. The tempo is slow with a lion playing an emotional solo, string section harmony, strong drumming rhythm and a steady bass line. The song is emotional and inspiring. The audio quality is poor. | 2011-01-21T20:42:38Z | 89chatty | The man originally born to win life. | ["Music", "Sad music"] | ["instrumental music", "violin playing emotionally", "never say die", "string section harmony", "slow tempo", "steady drumming rhythm", "echoes", "keyboard harmony", "philharmonic orchestra", "strong bass line", "inspiring", "motivational", "poor audio quality", "poignant", "spirited", "passionate", "documentary soundtrack", "movie soundtrack", "never give up"] | 1 | KxjiEi2Eywk | 2135 | |
| The Sound Of Intercession - Apostolic/Prophetic Prayer and Worship Music | The song is an instrumental. The song is slow tempo with a steady drumming rhythm, triangle percussions, piano accompaniment, String synth harmony and strong bass line. The song is emotional and deeply meditative. | 2015-08-28T01:56:41Z | Nathaniel Coe III | Instrumental Intercessory Prayer and Apostolic Music https://www.natecoemusic.com/musicstore https://itunes.apple.com/us/album/the-heart-of-a-minstrel/id1035476762 This is a must have prophetic instrumental for Prayer, Worship, Deliverance, and Altar Calls. With the current revival of prayer and intercession, it is my goal and responsibility to dedicate this album to every house that will respond to the call of prayer. In this season, where our churches have become consumed by preaching and teaching, God is requiring that his church begin to rebuild the altar of prayer. "For it is written, my house shall be called a house of prayer..." Matthew 21:13 If You would like to sow into the ministry of Prophet Nathaniel Coe III: http://paypal.me/natecoe3 Please Visit my Facebook Page for up to date information: https://www.facebook.com/ProphetNateCoe3/ http://www.cdbaby.com/cd/nathanielcoeiii - The Heart Of A Minstrel https://www.facebook.com/natecoe3 http://www.periscope.com/tv/natecoe3 http://www.natecoemusic.com/ministries For all booking requests, please visit us at http://www.natecoemusic.com/bookings. Affirmed as an Apostle, Nathaniel is an anointed and gifted Minstrel, Teacher and Preacher who ministers in the Apostolic and Prophetic dimensions of Christ (Ephesians 4:11). Under the leadership of Apostle Alexander Thompson Of The Ever Abundant Life Church in Darby, PA, Prophet Nate excels in the areas of Spiritual Warfare, Deliverance, and Moving in the Prophetic. Nate's Apostolic assignment on the earth is to train leaders for Kingdom Agenda's. | ["Music", "Tender music"] | ["instrumental music", "gospel music", "strong bass line", "christian contemporary music", "triangle percussions", "piano accompaniment", "piano playing chords", "string bass line", "keyboard accompaniment", "string section harmony", "poignant", "solemn", "steady drumming rhythm", "groovy rhythm", "emotional", "passionate", "spirited", "meditational", "trance like", "prayerful", "meditational", "inspirational", "motivational", "slow tempo"] | 1 | zyXa2tdBTGc | 5520 |
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;