musiccaps_details (view)

3 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2007-04-15

✎ 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
Ernie Haase & Signature Sound - Will The Lord Be With Me Male singers sing this vocal harmony. The song is medium fast tempo with a groovy bass line, steady drumming rhythm, piano accompaniment and guitar rhythm. The song is devotional and congregational. The song is a classic Christian praise hit. 2007-04-15T03:40:47Z moondoggy22 Will The Lord Be With Me is another fantastic performance from Ernie Haase and Signature Sound video ["Music", "Clapping"] ["male singers", "vocal harmony", "people clapping", "acapella", "poor audio quality", "steady drumming rhythm", "piano accompaniment", "guitar rhythm", "groovy bass line", "christian contemporary music", "praise and worship", "christian praise hits", "devotional", "meditational", "congregational", "inspiring", "motivational", "hymns", "medium fast tempo"] 1 0trWdhSvab4 218
Cinderella III: A Twist in Time - Please Remember The track is an emotional love ballad that features heartfelt female vocals. Piano chords play in the background as a string section that sounds inspiring sustains chords. A drum kit plays a slow beat that adds to the romantic mood of the song. 2007-04-15T07:04:50Z disneyscarlos So, I finally gathered up my courage to add a new and improved version of my classic fan video of Cinderella III: A Twist in Time *amazing sequel* with the song "Please Remember" from Cayote Ugly! Comment and rate! ["Music", "Tender music"] ["emotional", "bright", "heartfelt female vocals", "low tempo", "inspiring piano melody", "ballad", "soul", "r&b", "romantic", "slow tempo", "soft drum kit", "inspirational string section"] 5 W7U-glgu4GM 3067
Mildred Lorton Walton/ DON'T OVERLOOK SALVATION This is a Christian gospel music piece. There is a female vocalist singing melodically. An acoustic guitar and an electric guitar are playing in the melodic background. The atmosphere is religious. This piece could be used as a background music for Christian social media content. 2007-04-15T23:19:37Z emmylousings Country Gospel/ by Mildred Walton; Kitty Wells Tribute Artist ["Country", "Music", "Synthetic singing"] ["gospel", "christian", "female vocal", "melodic singing", "acoustic guitar", "electric guitar", "religious", "spiritual", "devotional"] 9 m-eyGzf9Ux4 4438

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;