musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "female singer" and musiccaps_aspects contains "together forever" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 55 ✖
- emotional 3
- female singer · 3 ✖
- together forever · 3 ✖
- guitar accompaniment 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 vocal harmony 1
- bad audio quality 1
- best day of my life 1
- black gospel influences 1
- caring 1
- country love songs 1
- country music 1
- country romantic hits 1
- crying 1
- guitar bass line 1
- guitar rhythm 1
- happy cheerful positive 1
- home video 1
- inspiring 1
- jazz music 1
- keyboard accompaniment 1
- kindness 1
- love song 1
- madly in love 1
- medium tempo 1
- motivational 1
- never give up 1
- no percussion instruments 1
- no percussions 1
- passionate 1
- people talking 1
- poor audio quality 1
- prayer 1
- promises 1
- relaxing and comforting 1
- romantic 1
- romantic emotional 1
- sharing 1
- slow tempo 1
- soul music 1
- soulful singing 1
- steady drumming rhythm 1
- strength 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) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 |
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;