musiccaps_details (view)

1 row where musiccaps_aspects contains "acoustic guitar" and "youtube_published" is on date 2008-05-08

✎ 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
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

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;