musiccaps_details (view)
5 rows where musiccaps_aspects contains "female singer" and musiccaps_aspects contains "together forever"
This data as json, CSV (advanced)
musiccaps_aspects (array) 80 ✖
- emotional 5
- female singer · 5 ✖
- together forever · 5 ✖
- love song 3
- bad audio quality 2
- guitar accompaniment 2
- guitar rhythm 2
- jazz music 2
- passionate 2
- piano accompaniment 2
- slow tempo 2
- soul music 2
- subtle bass line 2
- acoustic love song 1
- always with you 1
- ambient room noise 1
- ambient room noises 1
- autoharp accompaniment 1
- backup singers 1
- backup singers vocal harmony 1
- best day of my life 1
- black gospel influences 1
- black gospel music influences 1
- blues music 1
- caring 1
- country love songs 1
- country music 1
- country romantic hits 1
- crying 1
- cymbals crashing 1
- disco music 1
- disco romance hits 1
- dream of you 1
- falsetto 1
- groovy bass line 1
- guitar bass line 1
- happy cheerful positive 1
- home video 1
- inspiring 1
- jazz and blues 1
- jazz drumming rhythm 1
- keyboard accompaniment 1
- kindness 1
- love you so badly 1
- madly in love 1
- marry me 1
- medium tempo 1
- missing you 1
- motivational 1
- never give up 1
- no percussion instruments 1
- no percussions 1
- people talking 1
- percussive bass line 1
- poor audio quality 1
- prayer 1
- promises 1
- relaxing and comforting 1
- retro hits 1
- retro pop song 1
- romantic 1
- romantic emotional 1
- sharing 1
- slowing down 1
- song retarding 1
- soulful singing 1
- special someone 1
- steady drumming 1
- steady drumming rhythm 1
- story telling 1
- strength 1
- tambourine percussions 1
- vocal harmony 1
- vocal vibrato 1
- wedding dance 1
- wedding dance song 1
- wedding love song 1
- wedding songs 1
- wedding super hits 1
- wedding vows 1
musiccaps_names (array) 6 ✖
- Music 4
- Happy music 1
- Humming 1
- Music of Latin America 1
- Soul music 1
- Wedding music 1
youtube_published (date) 5 ✖
- 2007-07-22 1
- 2008-06-01 1
- 2009-03-23 1
- 2009-04-21 1
- 2013-07-28 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
When I Loved You (interlude)/original (a YT feature) READ INFO BOX! | A female singer sings this soulful melody. The song is slow tempo with a guitar playing a subtle bass line and no other instrumentation. The song is romantic and emotional. The song is soul music with jazz and black gospel influences. The audio quality is poor as it is recorded casually at home. | 2007-07-22T20:00:02Z | mishalmooremusic | THANK YOU ALL FOR SHOWING ME LOVE!!!! You can follow me if you'd like: http://www.twitter.com/mishalmoore My single "Oh Lord" is available at: http://www.itunes.com/mishalmoore and/or any other major music site! Be sure to rate/review if you're purchasing from Itunes!! :) Myspace: http://myspace.com/mishalmmoore WARNING: All rights reserved. © 2007 Mishal Moore Cocobread Entertaiment LLC http://twitter.com/mishalmoore http://myspace.com/mishalmmoore | ["Humming", "Music"] | ["female singer", "soulful singing", "guitar bass line", "slow tempo", "home video", "ambient room noises", "poor audio quality", "jazz music", "no percussion instruments", "subtle bass line", "emotional", "romantic", "love song", "vocal vibrato", "soul music", "black gospel influences", "guitar accompaniment", "passionate", "madly in love", "together forever"] | 1 | KjMRf4egAyA | 2112 | |
Alice Fredenham - How Come You Don't Call | A female singer sings this soulful song. The song is slow tempo with piano accompaniment, strong bass line and groovy jazz drumming. The song is soulful and emotional. The song is a blues jazz song. | 2013-07-28T23:41:28Z | Virgilio Gan | Alice Fredenham - How Come You Don't Call http://www.facebook.com/realhealthnwealth Virgilio Gan World Talent Media Group | ["Music", "Happy music"] | ["female singer", "soul music", "jazz music", "blues music", "jazz and blues", "slow tempo", "black gospel music influences", "special someone", "dream of you", "missing you", "percussive bass line", "jazz drumming rhythm", "piano accompaniment", "emotional", "love song", "story telling", "love you so badly", "together forever"] | 1 | XUD-9HkQuTE | 3186 | |
Suprise Thriller Wedding Dance!!! | A female singer sings this beautiful love song with backup singers in vocal harmony. The song is medium tempo with a steady drumming rhythm, percussive bass line, autoharp accompaniment, guitar rhythm and keyboard accompaniment. The song has poor audio quality and makes an excellent wedding dance song. | 2009-04-21T00:29:24Z | Jeffrey Brinkley | Me and my wife and kids suprised our guest with thriller!! | ["Music of Latin America"] | ["wedding dance", "female singer", "country music", "wedding dance song", "bad audio quality", "ambient room noise", "country love songs", "backup singers vocal harmony", "steady drumming rhythm", "keyboard accompaniment", "autoharp accompaniment", "guitar rhythm", "country romantic hits", "always with you", "together forever", "crying", "happy cheerful positive", "people talking", "emotional", "best day of my life"] | 1 | bPWbeWf5xNI | 3622 | |
Wedding Song - This is the Day | A female singer sings this emotional melody. The song is medium tempo with a guitar accompaniment and a subtle bass line with no percussion instruments. The song is emotional and romantic. The song is a wedding song. | 2008-06-01T08:00:56Z | Francis H | This song is lovingly dedicated for my everdearest wife "Riza" I love you...for free chord lyrics of this song follow this link: http://www.nfphampden.com/thisday.pdf | ["Music", "Wedding music"] | ["female singer", "wedding songs", "medium tempo", "acoustic love song", "no percussions", "together forever", "never give up", "wedding super hits", "wedding love song", "prayer", "motivational", "inspiring", "strength", "caring", "kindness", "sharing", "relaxing and comforting", "emotional", "guitar accompaniment", "subtle bass line", "romantic emotional", "promises", "wedding vows"] | 1 | e8wnUU5pIWE | 3846 | |
PACHUCO ROLAS VOL 1 | A female singer sings this passionate melody with backup singers in vocal harmony. The tempo is medium and gradually slows down towards the end. The drumming rhythm is steady and retards to the end with a percussive bass line and keyboard accompaniment. The song is a retro disco or R&B love song. The song has poor audio quality. | 2009-03-23T07:20:30Z | pachucojae | PACHUCO MEMORIES.... | ["Music", "Soul music"] | ["female singer", "disco music", "song retarding", "bad audio quality", "slowing down", "backup singers", "falsetto", "vocal harmony", "steady drumming", "groovy bass line", "piano accompaniment", "guitar rhythm", "tambourine percussions", "cymbals crashing", "retro pop song", "retro hits", "emotional", "love song", "passionate", "together forever", "disco romance hits", "marry me"] | 1 | iS-iTbHndw8 | 4185 |
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;