musiccaps_details (view)
3 rows where musiccaps_aspects contains "emotional", musiccaps_names contains "Country" and musiccaps_names contains "Guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- emotional · 3 ✖
- acoustic guitar accompaniment 1
- christian gospel song 1
- christian praise and worship 1
- christian song 1
- classical 1
- couples dancing 1
- crowd clapping 1
- dance rhythm 1
- devotion 1
- electric guitar melody 1
- erotic 1
- flamenco guitar style 1
- groovy music 1
- guitar lead 1
- guitar strumming 1
- instrumental music 1
- latin dance music 1
- latin guitar player 1
- live performance 1
- low quality 1
- madly in love 1
- male singer 1
- medium tempo 1
- mellow 1
- mono 1
- music lesson ideo 1
- noisy 1
- passionate 1
- poor audio quality 1
- …
musiccaps_names (array) 9 ✖
- Country · 3 ✖
- Guitar · 3 ✖
- Music 3
- Acoustic guitar 2
- Plucked string instrument 2
- Flamenco 1
- Musical instrument 1
- Singing 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sweet Memories- Tess Sears tribute to her mom Dawn Sears | The low quality recording features a classical live performance of sustained violin melody, shimmering hi hats, electric guitar melody, theremin solo melody and subtle female vocals at the end of the loop. There are some crowd clapping sounds in the background. It is noisy, in mono and it sounds passionate and emotional. | 2014-12-23T23:40:06Z | Tesla Dawn | Tess Sears sings her moms song Sweet Memories in memory of her mother Dawn Sears at the first Monday night Time Jumper meeting after her passing. | ["Singing", "Country", "Guitar", "Music", "Wedding music"] | ["classical", "sustained violin melody", "crowd clapping", "shimmering hi hats", "theremin solo", "subtle female vocal", "live performance", "electric guitar melody", "low quality", "noisy", "mono", "passionate", "emotional"] | 4 | -WvVG0wHcTc | 57 | |
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 | |
Nancy 🇮🇳 Rumba 🇮🇳 (Juan Serrano) | The song is an instrumental. The tempo is medium with a guitarist playing traditional flamenco style guitar in a rhumba rhythm. The song has a Latin dance groove and sounds delightful. The song has a poor audio quality. | 2015-07-07T18:32:38Z | Aman (Flamenco Guitarist) | Nancy (Rumba Flamenca) composed by Juan Serrano played by me on YAMAHA CG172SF Flamenco guitar. | ["Country", "Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["rhumba music", "latin guitar player", "instrumental music", "medium tempo", "emotional", "romantic", "erotic", "madly in love", "couples dancing", "tango", "guitar lead", "guitar strumming", "music lesson ideo", "poor audio quality", "latin dance music", "groovy music", "solo instrumental", "groovy music", "dance rhythm", "flamenco guitar style"] | 1 | w4Z1QuBOMWU | 5236 |
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;