musiccaps_details (view)
2 rows where musiccaps_aspects contains "pop" and musiccaps_names = "["Christian music", "Music"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Shane & Shane - When I Think About The Lord | Someone is playing a kick on every beat along with little fill-ins on toms, cymbals and hihat. An e-bass is playing long notes along with an acoustic guitar finger picking chords while another guitar is playing higher pitched notes in a tremolo. A male voice is singing in a higher pitch sounding grateful. An atmospheric synth pad sound is rising in the background processed with a lot of reverb. This song may be playing with headphones enjoying a beautiful day. | 2008-05-08T21:47:53Z | monkeypop24 | another video, this time with the song when i think about the Lord by shane & shane... not ALL the pictures are repeated, like my other two vids, but some pics are the same as filled with Your glory and such... but thats cuz my movie maker thing or whatever kept freezing..piece of junk. anyway, if u see a pic that u saw in the other one, that's too bad for you~~!(jk) All pictures are found off Google Search. No copyright intended. LYRICS : When I think about the Lord How He saved me, How He raised me How He filled me With the Holy Ghost How He healed me To the uttermost. When I think about the Lord How He picked me up, Turned me around, How He set my feet On solid ground It makes me want to shout: Hallelujah! Thank You, Jesus! Lord, You're worthy Of all the glory, And all the honor And all the praise! It makes me want to shout: Hallelujah! Thank You, Jesus! Lord, You're worthy Of all the glory, And all the honor And all the praise! When I think about the Lord How He saved me, How He raised me How He filled me With the Holy Ghost How He healed me To the uttermost. When I think about the Lord How He picked me up, Turned me around, How He set my feet On solid ground And it makes me want to shout: Hallelujah! Thank You, Jesus! Lord, You're worthy Of all the glory, And all the honor And all the praise! It makes me want to shout: Hallelujah! Thank You, Jesus! Lord, You're worthy Of all the glory, And all the honor And all the praise! Hallelujah Thank You, Jesus Lord, You're worthy Of all the glory, And all the honor And all the praise... Yeahh Hallelujah! Thank You, Jesus! Lord, You're worthy Of all the glory, And all the honor And all the praise! And all the praise! And all the praise! Yeahh | ["Christian music", "Music"] | ["pop", "acoustic guitar", "e-bass", "acoustic drums", "synth string sound", "male voice singing", "higher pitch", "medium to uptempo"] | 6 | tdTT6rmkk9M | 5054 | |
Brandon Flowers - Only The Young (Official Video) | A digital drum is playing a simple groove along with an e-bass. An organ is playing long chords with a lot of reverb. On top of that male voices sing a melody in harmony. Their voices sound high. This song may be playing with headphones while running. | 2010-10-13T00:00:08Z | BrandonFlowersVEVO | Music video by Brandon Flowers performing Only The Young. (C) 2010 The Island Def Jam Music Group #BrandonFlowers #OnlyTheYoung #Vevo | ["Christian music", "Music"] | ["pop", "electric organ", "digital drums", "e-bass", "male voices singing", "higher register", "medium tempo"] | 6 | uBENjCPS8LI | 5097 |
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;