musiccaps_details (view)
4 rows where musiccaps_aspects contains "sentimental", musiccaps_author = 7 and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 96 ✖
- sentimental · 4 ✖
- emotional 2
- keyboard harmony 2
- mellow 2
- soft 2
- acoustic guitar 1
- acoustic guitar harmony 1
- amateur recording 1
- amateur singer 1
- amplified keyboard 1
- auto harp 1
- backup harmony 1
- banjo 1
- calm 1
- catchy 1
- children’s song 1
- christian gospel music 1
- christian music 1
- christian pop 1
- christian praise and worship 1
- christian rock 1
- christian song 1
- christian worship song 1
- church 1
- country music 1
- country pop 1
- country side 1
- cowboys 1
- dreamy 1
- electric guitar 1
- enthusiastic 1
- enthusiastic drumming 1
- fast tempo 1
- female singer 1
- female vocalist 1
- fiddle 1
- folk music 1
- foreign language 1
- gentle 1
- girl singing 1
- gospel music 1
- gratitude 1
- happy 1
- humility 1
- karaoke 1
- keyboard accompaniment 1
- love song 1
- lullaby 1
- male singer 1
- male vocalist 1
- mandolin 1
- march like beat 1
- medium 1
- medium tempo 1
- mellifluous 1
- melodic 1
- melodic piano accompaniment 1
- no percussions 1
- passionate 1
- pensive 1
- people clapping 1
- peppy 1
- pleasant 1
- poignant 1
- pop 1
- powerful vocals 1
- powerfully voice 1
- regional music 1
- repentance 1
- resonator 1
- reverb 1
- reverence 1
- romantic 1
- simple 1
- slick drumming 1
- slow tempo 1
- soothing 1
- sound of static 1
- spirited 1
- steady drumming 1
- story telling 1
- straight bass lines 1
- subtle bass 1
- synchronous singing 1
- tambourine beats 1
- tempo 1
- vibrant 1
- violin harmony 1
- violin symphony 1
- vocal backup 1
- vocal choral harmony 1
- vocal emphasis 1
- vocal treat 1
- worship 1
- young vocalist 1
- youthful 1
musiccaps_names (array) 9 ✖
- Music 4
- Song · 4 ✖
- Christmas music 2
- Jingle (music) 1
- Lullaby 1
- Psychedelic rock 1
- Rock music 1
- Soul music 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bella's Lullaby (with lyrics) | A female vocalist sings this pleasant melody. The tempo is slow with a melodic piano accompaniment. There is minimal instrumentation with emphasis on vocals. The song is soft, mellow, soothing, calming, mellifluous, pleasant, and dreamy. This song is a love song, children’s song or a lullaby. | 2008-11-30T03:54:32Z | Camille Chen | Song: Bella's Lullaby Artist: the BELLA CULLEN PROJECT | ["Music", "Song", "Lullaby"] | ["female vocalist", "slow tempo", "vocal choral harmony", "love song", "children’s song", "calm", "soothing", "gentle", "sound of static", "dreamy", "lullaby", "melodic piano accompaniment", "amplified keyboard", "no percussions", "vocal treat", "synchronous singing", "pleasant", "mellifluous", "romantic", "passionate", "sentimental", "melodic", "simple"] | 7 | 1rhsnmWLeGw | 314 | |
Thien kong nyit cie jiu ko ho ( Hakka song ) | A male vocalist sings this soft melody. The song is medium tempo, with violin harmony, steady drumming, straight bass lines, acoustic guitar and keyboard accompaniment with vocal backup. The song is in a foreign language. It is slow, and has a mellow, soft, emotional , sentimental and romantic vibe. This is a regional Pop song. | 2007-11-02T14:18:16Z | HakkaNyinXmantan | hakka love song | ["Christmas music", "Music", "Song"] | ["male singer", "medium tempo", "foreign language", "steady drumming", "keyboard harmony", "straight bass lines", "acoustic guitar", "vocal backup", "violin harmony", "violin symphony", "emotional", "sentimental", "mellow", "soft", "reverb", "backup harmony", "karaoke", "amateur recording", "amateur singer", "soft", "mellow", "emotional", "sentimental", "pop"] | 7 | MZhaDGgULtc | 2281 | |
God Must be Loved / Rich Moore - Praise Song / Lyrics | A male vocalist sings this emotional Christian Worship Song. The tempo is medium with energetic drumming,harmonious electric guitar , acoustic Guiana keyboard accompaniment and subtle bass. The song is a soft, mellow, emotional, pensive, devotional, Christian music. | 2014-01-15T17:06:38Z | Christian Sermons and Audio Books | God Must be Loved / Rich Moore - Praise Song / Lyrics My original Christian music facebook page: https://www.facebook.com/richmoorechristianmusic I am a singer, guitarist, and songwriter. This is a new original contemporary Christian song I recently wrote and recorded. May those who listen find it a great blessing, to the glory of the Lord Jesus Christ...praise God. (Music and video owned and copyrighted by stack45ny) My Original Contemporary Christian Songs (playlist): http://www.youtube.com/playlist?list=PLzOwqed_gET0JkRfjd1-xm_BGrCYaJqVR Christian Praise and Worship Songs playlist: https://www.youtube.com/playlist?list=PL4D0533BC00E40EA4 Matthew 10:34 "Do not think that I came to bring peace on earth. I did not come to bring peace but a sword. 35 For I have come to 'set a man against his father, a daughter against her mother, and a daughter-in-law against her mother-in-law'; 36 and 'a man's enemies will be those of his own household.' 37 He who loves father or mother more than Me is not worthy of Me. And he who loves son or daughter more than Me is not worthy of Me. 38 And he who does not take his cross and follow after Me is not worthy of Me. -~-~~-~~~-~~-~- Please watch: "A Call to Separation - A. W. Pink Christian Audio Books / Don't be Unequally Yoked / Be Ye Separate" https://www.youtube.com/watch?v=CBDg7u21cKY -~-~~-~~~-~~-~- | ["Christmas music", "Jingle (music)", "Music", "Psychedelic rock", "Rock music", "Song", "Soul music"] | ["male vocalist", "medium", "emotional", "sentimental", "soft", "subtle bass", "mellow", "pensive", "poignant", "repentance", "gratitude", "worship", "reverence", "church", "humility", "tempo", "slick drumming", "acoustic guitar harmony", "keyboard accompaniment", "christian song", "christian gospel music", "christian praise and worship", "christian worship song", "gospel music", "christian pop", "christian rock", "electric guitar", "christian music"] | 7 | RceCfg1FQq4 | 2713 | |
cutie girl singing (11 years old) | A young female vocalist sings this upbeat country song. The tempo is fast with keyboard harmony,enthusiastic drumming , rhythmic accompaniment of acoustic guitar, mandolin, fiddle, resonator, auto harp and dobro and tambourine beats. The song is fresh, youthful, energetic, vivacious, catchy, upbeat, simple and peppy. This song is Country Pop. | 2006-07-16T08:08:14Z | Trofimo | El origen de la Humanidad (la infancia) puede descubrirnos el origen de la música... | ["Yodeling", "Music", "Song"] | ["female singer", "fast tempo", "girl singing", "young vocalist", "peppy", "enthusiastic", "auto harp", "folk music", "regional music", "country side", "cowboys", "catchy", "country music", "country pop", "march like beat", "powerfully voice", "people clapping", "enthusiastic drumming", "fiddle", "mandolin", "resonator", "banjo", "tambourine beats", "youthful", "happy", "sentimental", "story telling", "powerful vocals", "vocal emphasis", "keyboard harmony", "spirited", "vibrant"] | 7 | hdlnugbWjKA | 4122 |
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;