musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar accompaniment", musiccaps_aspects contains "emotional" and musiccaps_aspects contains "mellow"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- acoustic guitar accompaniment · 2 ✖
- emotional · 2 ✖
- mellow · 2 ✖
- christian gospel song 1
- christian praise and worship 1
- christian song 1
- devotion 1
- dissonant tambourine beats 1
- electric guitar rhythm 1
- energetic drumming 1
- groovy bass line 1
- keyboard harmony 1
- male singer 1
- male vocalist 1
- medium tempo 1
- melodious 1
- nostalgic 1
- poignant 1
- reverence 1
- romantic 1
- sentimental 1
- slow tempo 1
- soft melody 1
- sweet 1
- synth arrangement 1
musiccaps_names (array) 6 ✖
- Music 2
- Acoustic guitar 1
- Country 1
- Grunge 1
- Guitar 1
- Plucked string instrument 1
youtube_published (date) 2 ✖
- 2009-04-17 1
- 2010-11-22 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Behold, I Stand At The Door and Knock (Rev. 3:20) - as sung by Jack Marti | A male vocalist sings this soft melody. The tempo is slow with acoustic guitar accompaniment. The song is soft, mellow, dulse, emotional and gentle with minimal music. The song is a Christian Gospel Song. | 2010-11-22T05:34:11Z | Jack Marti | Here's another scripture song I learned back in the '80s. I was told (in error) the music for it was composed by Doug Bachelor, the speaker/director of Amazing Facts, however recently I was informed by Doug Batchelor, himself that he learned it from some friends in the late '70s. The composer, possibly Debbie Kerner, sang it as part of a song she recorded on her album, Come Walk With Me, back in the '70s. In any case, its message is more relevant now than ever. It is the last message of hope for the Laodicean church, which I believe to be the last church age just before Jesus' return. May all who have ears open the door of their heart and mind, and let Jesus come in and sup with them, and they with Him. I would like to dedicate this song to the memory of a friend of mine who just fell asleep in Jesus on November 20, 2010. I learned of this just moments before I recorded this video. His name was Dr. William Palmer and he was a great man who taught me much about the things of God. Be(G)hold, I (D)stand at the (Em)door, and knock: And if (C)any man (D)hear my (G)voice, And (C)open the (D)door, I will come (G)in to (C)him, And (G)sup with (Em)him, And (C)he (D)with (G)me; (D)I will come (G)in to (C)him, And (G)sup with (Em)him, And (C)he (D)with (G)me. | ["Country", "Guitar", "Acoustic guitar", "Music", "Plucked string instrument"] | ["male singer", "slow tempo", "soft melody", "acoustic guitar accompaniment", "mellow", "emotional", "devotion", "christian gospel song", "christian song", "christian praise and worship", "reverence", "devotion"] | 7 | O2HttJtcec4 | 2394 | |
Lie To Me opening theme - Music - Ryan Star - Brand New Day | A male vocalist sings this melodic pop song.The tempo is medium with energetic drumming, keyboard harmony, groovy bass lines, electric guitar harmony, acoustic guitar rhythm and dissonant tambourine beats. The is soft, calming, mellow, sentimental, emotional and nostalgic. This song is Pop Rock/Soft Rock. | 2009-04-17T03:37:09Z | Ricardo Miranda | Clipe da musica de abertura do seriado Lie To Me (Ryan Star - Brand New Day) Hello to all the video was made is not official Fan to Fan Olá a todos o video não é oficial foi feito de Fã para fã Os gráficos são baixos o vídeo foi feito com vários outros vídeos disponíveis no YT | ["Music", "Grunge"] | ["male vocalist", "medium tempo", "energetic drumming", "groovy bass line", "synth arrangement", "keyboard harmony", "electric guitar rhythm", "dissonant tambourine beats", "sweet", "melodious", "mellow", "romantic", "emotional", "sentimental", "nostalgic", "poignant", "acoustic guitar accompaniment"] | 7 | l9vYSBR9nio | 4377 |
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;